SQL – ETL - Database Developer / Data Sr. Specialist
Citibank
11.2014 - 11.2016
Client Experience Research Database Development
Extract, transform, and load data from multiple sources into central database and making that data available for analysis
Design and maintain high performance automation of data load for the Client Experience Research process
Responsible for all phases of the database life cycle including design, coding, testing, setting up security and documentation
Writing complex dynamic cross tab queries for data analysis
Applications System Engineer
Wells Fargo Bank
03.2007 - 05.2012
User Interface Application Design and Development
Was part of the IT group that was responsible for the Loan Origination software written in C#.NET
Worked closely with multiple groups such as Project Managers, Database Administrators, and Quality Assurance group during project development Life Cycles
Created technical design documents for the provided Business Requirements
Worked on software development on my own or with other developers
Was a C+.NET mentor to the junior developers
Senior Programmer/Analyst
CitiBank
01.1999 - 03.2007
User Interface and Web Applications Design and Development
Was part of the MIS group that created internal MIS website and was responsible for multiple supportive applications and MIS web application
Developed application mainly using VB and ASP.NET, Crystal Reports, and XML Viewer
Worked closely with internal users during requirements and quality assurance cycles
Education
Bachelor's Degree - Business Administration
University of Sioux Falls
Sioux Falls, SD
01.2003
Associate Degree - Computer Programming
Southeast Technical Institute
Sioux Falls, SD
05.1999
Skills
Project Management
Database Administration
SQL Programming
Programming
Web Programming
Tableau Reports
Microsoft Reporting Services
Microsoft SQL Server 2015
VB Script
Writing Automated Test Scripts
Writing Software Test Scripts
Writing Technical and User Instructions
Writing Technical Requirements
XML (Files and Schemas)
Otherrelatedinformation
One of the projects that I was a lead programmer on for more than 3 years was creating and supporting a web application for 300 internal users. I was a lead programmer over 2 senior programmers. The project involved users from 5 teams in 5 states. After it was implemented in production, more businesses throughout organization signed up to use the website. It was a very high complexity process, which involved automatic data transmission using Connect Direct software, importing data into SQL database located on 4 servers, downloading and comparing data from multiple mainframe systems, data processing by representatives using website application, and generating numerous audit logs. I have received high performance appraisals from upper management for this project.
References
Available upon request
Timeline
Data Mining Analyst
Cigna Ins
11.2016 - Current
SQL – ETL - Database Developer / Data Sr. Specialist