SEARCH

Database Architect/Senior-Developer Resume Example

Resume Score: 90%

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
  • Databases (Oracle, SQL Server and Sybase)
  • NET programming (C++,C#, MS Visual studio 2013\2014)
  • Perl Script, Unix Shell Scripts
  • Web development (ASP.net, HTML)
  • Technical writing and business analysis
  • Tableau reporting
  • Autosys SQL Agent Jobs, Google APIs, SSIS, Reporting
Professional Experience
Database Architect/Senior-Developer
January 2013 to February 2016Company Name - City, State
  • 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 2013Company Name - City, State
  • 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 2006Company Name - City, State
  • Provided ongoing support for the electronic shopping ordering 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 2001Company Name - 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 2001Company Name - 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

Build Your Own Now

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.

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

View All
Database-Architect-resume-sample

Database Architect

San Clemente, California