ETL developer Resume Ashburn, VA - Hire IT People

OBJECTIVE

SUMMARY

Hands on experiences of RDBMS (SQL Server 2008, Oracle 11g, and Access), data modeling and database/data warehouse design
Professional experiences with high performance data integration solutions - SSIS, including design of ETL packages for data warehouse
Experience with loading of variety of large volume data files into SQL server 2008 database tables, migrate Oracle tables into SQL Server 2008 database tables and generate report with SSRS
Strong data manage and reporting experience on quantitative analysis

TECHNICAL SKILLS

Database: SQL Server 2008, Oracle 11g, Access, SQL

Data Integration: SSIS

Reporting: SSRS, Access, Excel

Language: PL/SQL, T-SQL Visual Basic for Application

Internet: SharePoint Server

MS Office: Visio, Word, Excel, PowerPoint, Access

Operating System: Windows Server 2008, Virtual Machine

PROFESSIONAL EXPERIENCE

ETL developer

Confidential, Ashburn, VA

Responsibilities:

Participate in the design of SQL server 2008 database and data mart
Collect, analyze and document business requirement
Data source mapping
Perform data profiling using SSIS data profiling task
Create ETL packages for loading/migration of data from various sources (Oracle database, SQL server database, and Excel files) to SQL server data warehouse using agile development method
Create SSIS package templates for ETL development environment
Perform performance tuning of ETL packages
Debug ETL packages, improve ETL package design logic to avoid further errors
Create cubes and generate dashboard reports, matrix reports and KPI reports to monitor project progress using SSRS
Improved data analysis performance by 50% using Microsoft SSIS BI solutions

Confidential, Bethesda, MD

Responsibilities:

Successfully loaded millions rows of Microarray experiment data into SQL Server 2008 database, then created SSIS ETL packages and loaded the data into data warehouse using advanced SQL scripts (multi-table joins, group functions, sub-queries and set operations etc.), re-processed cubes linked with the data warehouse, analyzed cube data and generated various ad hoc reports using SSRS
Created data model and SQL server database to manage plasmid DNA sequences; upload DNA sequences (text string) into SQL server database; added primary key and foreign key constraints; wrote stored procedures to query data to simplify DAN fragment assembling design
Created data model and SQL server database to manage Fly stocks; import data from excel file into database; cross references other database and linking their related knowledge together using SQL server