Database Architect/Senior-Developer Resume Example
Love this resume?Build Your Own Now
DATABASE ARCHITECT/SENIOR-DEVELOPER
Profile
DEVELOPER, SENIOR PROGRAMMER ANALYST
Developer and Senior Programmer Analyst with over 20 years' experience in applications and database development, implementation and support. Expertise in translating business requirements into programming specifications, and developing business applications. Proven ability to work both independently, remotely, and in a team environment, offering an extensive background in application development for the brokerage, banking, retail and advertising industries.
Core Qualifications
|
Professional Experience
Database Architect/Senior-Developer
January 2013 to February 2016Ally - Remote , PA
January 2013 to February 2016Ally - Remote , PA
- Development and support of Search Engine Marketing (SEM) data warehouse that generates daily budget efficiency data, providing visual campaign performance in required format.
- Client application used for data consumption: Tableau Reports and dashboards.
- Implemented and supporting data flow-back end processes which connected to external applications via web services and pulled data into internal data warehouse.
- Created a mapping process between the internal systems and external data sources.
- Working closely with internal SEM team on reports and dimensions configuration, data verifications and resolving day to day issues.
- Working closely with Marin on resolving pass-back data issues and fixing data discrepancies.
- Worked on Development, Design, SQL database, stored procedures, SSIS packages, SQL Agent Jobs C# API applications, files manipulation Perl scripts as well as Tracing API updates, deprecation schedule and updated related processes accordingly.
- Managing SQL server databases and performed query optimizations Worked with external vendors such as AdWords, Bing Ads, Yahoo Gemini, Marin, and TubeMogul.
- Technologies used include: Web Services API (AdWords API, Microsoft Bing Ads API, DCM/DFA Reporting and Trafficking API, Yahoo Gemini), FTP.
- Implemented process to load Google daily transfer files.
- This process use Google GSutil Python utility to access Google bucket, get impression/click/activities files and load to database.
- Created and support application which access Google DCM report builder to execute and pull generated reports.
Prepared and presented technical proposals for clients.
System Analyst / Developer
January 2006 to January 2013Amerisourcebergen Corporation - Corporate - Sacramento , CA
January 2006 to January 2013Amerisourcebergen Corporation - Corporate - Sacramento , CA
- Developed, implemented and maintained Trading applications for a broker-dealer firm.
- Developed using C#, Perl interfacing with databases including Oracle, MS SQL, and Sybase.
- Generate reports for senior Trading Management to monitor trading activities and cost revenue data.
- Maintained web based Commission Tracking System for the Option Desk.
- Completed technical analysis for Oracle to MS SQL database migration.
- Development and daily support of trading jobs automation.
- Development and daily support of trading activity files into the compliance platform.
- Developed a web based trade activity reporting system.
- Participated in a back office system conversion, involving schema creation, file handling and building of business logic.
- Significant involvement in the change of company's clearing house that occurred in 2006.
- Tasks included business analysis, managing offshore development and actual modifications of several .NET applications.
- Assisted the company in switching from Beta Thomson Financial to NFS (National Financials Services) clearing house.
- Created and maintained various applications for research and human resources departments.
- Prepared technical specifications for various projects.
- Supported and enhanced Compliance platform used by SG and Cowen.
- Maintained and enhanced C code which used Tibco to record instrument bids.
Senior Developer
January 2002 to January 2006Health & Hospital Corporation - Indianapolis , IN
January 2002 to January 2006Health & Hospital Corporation - Indianapolis , IN
- Provided ongoing support for the electronic shoppingordering system.
- The system was implemented on a central server, polling orders from stores and then placing orders with vendors based on shopping cascades for every store.
- Responsibilities included constant monitoring of ordering processes, resolving production issues, working with stores as well as with different vendor warehouses.
- Worked as part of the group handling 24-hour on-call support for production systems.
- Participated in development and support of music system central search.
- Created various feeds and report processes using Java and UNIX shell scripts.
- Took part in the integration project with BN.com.
- Personally designed and developed new process of exporting and importing data from NT servers in stores to HP UX central server using Java, C++ and XML.
- Created web applications using Java servlet and JSP technologies.
- These applications are part of the Barnes & Noble BookMaster central store system.
Senior Programmer Analyst
May 2001 to August 2001Wellington Consulting - City , STATE
May 2001 to August 2001Wellington Consulting - City , STATE
- Designed and developed credit card information retrieval routine for the Lawnet SPSprint using object-oriented design.
- The routine employed PGP encryption mechanism for processing files on different ftp servers.
- Designed Client site web pages with HTML and JavaScript.
- Developed Server-side functionalities with ASP, and C++.
Programmer Analyst
January 1996 to January 2001Paradigm Software Technologies - City , STATE
January 1996 to January 2001Paradigm Software Technologies - City , STATE
- Designed and developed the eServicesManager (eSM) subsystem of the Jobs Casting System (ParaTrac).
- The system allowed the project manager to plan, track and bill all assets used throughout the project and then arrive at the true cost of each activity and resource used.
- Designed and implemented the LAN version of the Time and Expense Entry module.
- Developed the interface with various email clients using MAPI and SMI libraries.
- The application was written in Visual C++ using the MFC library and Dundas grid library.
- Ported the application to the Macintosh platform.
- Extensively used MFC database classes for the database access.
- Used MS SQL Server transaction control mechanism as well as triggers and stored procedures to ensure data integrity.
Education
Bachelor of Computer ScienceBelarusian State University of Informatics and Radio Electronics - City, Belarus
Skills
.NET, ASP.net, .NET programming, Ads, API, ASP, automation, budget, business analysis, C, C++, com, conversion, credit, encryption, Client, clients, data warehouse, Databases, database, dimensions, email, XML, Financials, Financial, FTP, HP UX, HTML, human resources, Java, JSP, JavaScript, LAN, logic, Macintosh platform, Managing, MAPI, Marketing, access, C#, MFC, office, migration, NFS, NT servers, object-oriented design, Oracle, Perl, processes, Python, reporting, research, servers, servlet, scripts, Script, MS SQL Server, MS SQL, SQL, SQL Server, Sybase, Tableau, technical analysis, Technical writing, Tibco, UNIX shell scripts, Visual C++, MS Visual studio, web applications, Web development, web pages, written
DISCLAIMER
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Completeness
- Formatting
- Word choice
- Measurable results
- Strong summary
- Typos
Resume Overview
School Attended
- Belarusian State University of Informatics and Radio Electronics
Job Titles Held:
- Database Architect/Senior-Developer
- System Analyst / Developer
- Senior Developer
- Senior Programmer Analyst
- Programmer Analyst
Degrees
- Bachelor of Computer Science
Similar Resumes
