Database Analyst Resume Profile

Applied Skills:

7 years experience in Database Administration/Developer role for very large and complex databases
using SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
Expertise Planning, Testing, and Deploying ETL mappings as part of application build process across
the enterprise.
Experience using SSIS transformations such as Lookup, Derived column, Data
Conversion, Aggregate, Conditional Split, SQL Task and Script task.

Work Experience:

ETL Developer Consultant

Confidential

Responsible for SSIS tasks such as Conditional Split, Derived Column on data retrieved, performing
Data Validation Checks during Staging, and loading of Data.
Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
Assist junior programmers with scripts, SSIS projects, troubleshoot complex stored procedures and

Confidential

Database Analyst

Analyzed existing informational sources and methods to identify problem
areas and make recommendations for improvement. This required a detailed understanding
of the data sources and researching possible solutions.
Involved in complete SSIS life cycle in creating SSIS packages, building, deploying
and executing packages in both environments Development and Production .
Maintained SQL Tables and Views, Stored Procedures, User-Defined Functions, Indexes
and appropriate Triggers to facilitate efficient data manipulation and consistency.

Confidential

Database Analyst

Coded SQL Stored Procedures, Triggers, Views and Jobs for PPMC's Healthcare
System verifying Data Integrity from Source to Destination.
As an Administrator of the Technical OCR Optical Character Recognition Team, I
automated several processes that reduced manual data entry and increased
accuracy.
Enhanced end users' understanding of database systems by conducting pre-implementation workshops,
leading group and individual training sessions and creating user-friendly training materials.

Confidential

Data Specialist

Facilitated modification and Data migration initiatives adhering to new technology
Protocols.
Trained administrators and users regarding newly implemented systems and
Software.
Created technical documentation for server environments, application, and IT
Development.