Zhaolin Cheng

Work Summary

• Nine years’ experience in ETL, data migration, data analytics and software development at a

leading bail bond IT service company.

• Demonstrated success in employing flexible and nimble strategies to solve complicated problems.

• Passionate about data services and analytical, IT consulting and project management coupled with

a passion for customer satisfaction.

Work Experience

Senior ETL Developer, Captira Analytical, Albany, NY, 2012-present

CAPTIRA ANALYTICAL is a leading bail bond software provider with a national IT services including

data management, database and data warehouse services to more than 500 customers.

• Designed and implemented ETL processes for enterprise migration system.

• Created SSIS Packages to extract data from Excel files, MS Access files using Pivot

Transformation, Condition Split, Execute SQL Task, Data Flow Task, Execute Package Task etc

to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets,

Text file, MA Access and CSV files to enterprise databases.

• Participates in all phases of the ETL development lifecycle including unit testing and ongoing

support.

• Lead a data team to meet enterprise and client data need.

• Used Powershell Scripting and Pipeline to do routine SQL tasks.

Junior ETL Developer, Captira Analytical, Albany, NY, June 2006-2012

• Developed a data migration tool which is routinely used to transfer various client data sources

into enterprise databases.

• Drew ER diagrams for the mappings between client data sources and enterprise databases.

• Extracted data from various sources like data files, databases and Excel spreadsheets using DTS.

• Designed migration scripts to convert and transfer source data to enterprise databases.

• Created packages to do data extraction in the migration tool (implemented ER diagrams,

configured the tool, and executed the packages).

• Developed testing procedures to validate the migration data.

• Migrated mappings from Development to Testing and from Testing to Production.

• Extensively worked on Views, Stored Procedures, Triggers, SQL queries and for loading the data

(staging) to enhance and maintain the existing functionality.

Skills

ETL: Visual Studio 2010, Business Intelligence Studio 2008, SQL Server Integration Services (SSIS)

2008, SQL Server Reporting Services (SSRS) 2008, SQL Server 2012,

Databases: MS SQL Server 2005/2008/2012, MySQL, MS Access 2010, Sybase 12.x SQL Navigator

Data Modeling: MS Visio, ER diagrams

Others: Power shell, HTML 5.0, CSS, MVC, C++, TSQL, ODBC

Environment: Windows 7

Education

Master of Electrical and Computer Engineering, Rensselaer Polytechnic Institute, Troy, NY, 2006

Bachelor of Engineering, Southeast University, Nanjing, China, 1996

Contact this candidate