Terry Zhou

Cell Phone: 647-***-****

Email: ac4p92@r.postjobfree.com

Summary of Qualifications

** ***** **** ********* *********** and maintenance experience.

** **** *** *********** ********** in Ab-initio, Datastage, Informatica and SAS.

8 year BI development experience in Cognos and BusinessObjects

Over 8 years DBA experience with DB2 and Informix.

8 years Data Warehouse project development experience on Canada banking industry.

More data model tools experience on ERWIN, Power Designer

Proficient programming skills in SAS, JCL, COBOL, SQL, UNIX Shell and Perl.

Professional Certification:

DB2 Advanced Administration for UNIX, Linux, Windows and OS/2 Certification

DB2 Administration for UNIX, Linux, Windows and OS/2 Certification

DB2 Fundamental Certification

Professional Experiences:

Investment Group (Mar 2016 – Dec 2017)

Senior Consultant/ ETL Lead

Mackenzie Investments ETF Project

Review the business requirement specification

Design the ETL technical and mapping specification

Review the testing plan and support the UAT.

Development the ETL process using GDE and UNIX shell scripts.

Daily Production and BAU support

Environment: Linux, Ab-initio, Bloomberg, Oracle & SQL server, UNIX Script and ESP

Mackenzie Marketing Data mart migration project

Design the ETL migration approach from Informatica to Ab-initio

Design the Ab-inito common component refer to Informatica mapplet

Design Ab-initio graph refer to the Informatica mapping/session to

Design ESP subapp refer the Informatica workflow.

Daily Production and BAU support

Environment: Linux, Oracle, ESP, Ab-initio and Informatica

TD Bank (Jul 2013 –Mar 2016)

Senior Consultant/ ETL Lead

TD Enterprise Metadata Management and Data quality Platform

Gathered various business requirements from the multiple BS/CF

Work with Business user design TD Data Governance process

Design Enterprise Business Glossary and define the CDE

Load the Enterprise Data Model to metadata repository

Support TD Enterprise Metadata Management solution Implementation in Cloud environment

Build Data Lineage and metadata usage report for CCAR project using IGC and Cognos.

Environment: Cloudia, InfoSphere Server, IBM IGC, Datastage, Perl

BDW IVR Project

System requirement specification review

Design ETL Technical and mapping specification

Low lever ETL technical document design (SDS and Mapping Spec).

Implemented procedure for designing, testing and debugging data flow plans for populated databases.

Coordinated with ETL architects and process analysts for development and execution of system and integration test plans.

Executed processes for performance tuning of applications to meet operational production needs.

Suggested enhancement and optimization procedures for all ETL and Data stage processes.

Resolved data and application related issues by proper interfacing with users.

Environment: DB2, Datastage, UNIX Shell and ESP

BDW OAO (Online Account Opening) Project

System requirement specification review

Design ETL Technical and mapping specification

Low lever ETL technical document design (SDS and Mapping Spec).

Lead offshore team develop the ETL job build by Datastage and UNIX shell script

Test Strategy and plan review

Deployment design and implementation support

Environment: DB2, Datastage, UNIX-shell

BDW Credit Risk Project

System requirement specification review

Physical data model design

Low lever ETL technical document design (SDS and Mapping Spec).

Lead and develop the ETL job build by COBOL, SAS and UNIX shell script

Test Strategy and plan review

SDP design and implementation support

Environment: TSOD, SAS, DB2, JCL, COBOL

JPMorgan Chase (Nov 2012 – Jun 2013)

Senior ETL Developer

Chase AML Project

ETL systems design on technical specification and ETL mapping specification

Data mart development for Risk department using SAS, SAS Macro.

Fraud application Reporting development using Cognos

Application Level 1 AML business rules checking in ACAPS data mart using PL/SQL

Environment: AIX, DB2, Erwin, Ab-initio and Cognos

Canada ACAPS Project

Designed low level design document.

Developed Graphs (.mp), XFRs, DMLs and scripts for all interfaces as per Technical Specification.

Review and Guide the offshore team code

Prepared the TEST CASES, based on tested Graphs.

Handled UAT and SIT issues till the code is in production.

Environment: AIX, DB2 9.1, Erwin, Ab-Initio and Cognos

IBM Canada (Jun 2012 – Nov 2012)

DBA/ ETL Developer

TD Voyageur Reporting Project

Performs modelling activities in the development of logical and physical models

Coordinate code walkthroughs and reviews

Migration the ETL process from Embarcadero to Datastage

Daily production DB support

Application Implementation and Production Support

Environment: AIX, DB2, Datastage, Embarcadero

Bank of Montreal (Oct 2011 – Jun2012)

Senior ETL Developer

BMO EDW Project (FCI/AML)

Prepare technical specifications documents

Develop of ETL process using Datastage extracting the data from EDW to mdm system

Retrieve/Load data from/to DB2 tables for end-user processing

Coordinate code walkthroughs and reviews

Identify any problems in the ETL process and modules.

Application Implementation and Production Support

Environment: AIX, DB2 9.7, Erwin, Datastage

BMO ISASII Migration Project

Working with DBA team designing the migration strategy

Prepare the Migration scripts.

Retrieve/Load data from/to DB2 tables for end-user processing

Coordinate code walkthroughs and reviews

Identify any problems in the graphs and modules, arriving at solutions and implementing the solution plan.

Application Implementation and Production Support

Environment: AIX, DB2 9.7, Erwin, Ab-Initio

JPMorgan Chase (Jun 2009 – Sep 2011)

Technical Architect /Senior ETL Developer

IXE Data warehouse Project

Gathered metadata and created a data analysis repository, which includes the following meta information: data source, hierarchy, fact, dimension, data attribute, data integration, data model, data acquisition etc.

Analyzed the data sources in the following areas: data availability, data quality and fitness for use

Designed a cube model in Analytic Workspace, which provides custom calculation

Used ERwin 4.0/Visio to create a conceptual, logical data model (star schema) and physical model based on data analysis and documented these models in corresponding specifications

Append Master Data and Data Quality Standard/Process Design

Environment: AIX, DB2, Oracle, Erwin, SAS and Cognos

Bank of Montreal (Aug 2007 – Mar 2009)

Data Warehouse Consultant

BMO Basel Center Solution Project Phase II

Perform ETL development and tests in 13 LOBS data certification (EQUITY, IBG Capital Market, JADE, NCMA, Harris Commercial and Harris Retail)

Conduct data certification tests in Release5 to Release9.1

Automation Utility Build including process management and scripts auto build tools

Environment: AIX, DB2, Erwin, PL/SQL, Ab-Initio

BMO Anti-money launder Project

Perform ETL development/testing in BOC (Bank of Canada) data mart

Generated and modified database DDL scripts using ERwin when necessary

Created and modified DML scripts to populate data (in a “Time” dimension, for example)

Environment:

AIX, DB2, Oracle, AQT, Erwin, PL/SQL, Ab-Initio, PVCS

Accenture (China) Co, Ltd. – China

Senior Consultant

Apr 2005 – Dec 2006

Project:

China XinJiang Telecom Business and Operation Support System – Data Management Team lead

Designed the data migration approach, staging database’s logical model and physical data model on DB2 using ERWIN

Provided guidance to the application developers on how to code efficient SQL queries and was available to the development staff to assist in resolving database issues relevant to the development of the application

Attended to the development of the ETL program using UNIX Shell and Power Center

Environment: AIX, DB2, Informatica

Bank of China Core Banking System – Data Architect Team Consultant

End-to-end ETL development of the Customer Module Data Mart

Extensively used PowerCenter to design multiple mappings with embedded business logic.

Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.

Data Quality Analysis to determine cleansing requirements.

Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting

Environment:

DB2,Oracle, Erwin, SAP, Informatica

SAS (China) Institute Ltd. – China

Senior Consultant

Mar 2003 – Mar 2005

Projects:

Tianjin Unicom Customer Relationship Analysis Data Mining Project

Designed logical and physical data models

Designed and developed ETL processes

Environment:

DB2, Informatica, SAS/BASE, SAS/Enterprise Miner

China Academy of Railway Sciences DM Project

Designed the physical model design

Provided performance tuning on the data mining database

Designed and developed ETL process

Environment:

DB2, Informatica, Sybase, SAS/Enterprise Miner

Ministry of Railway EDW Project

Analyzed, designed, developed and maintained ETL processes

Developed an ETL program using SAS/BASE, PL/SQL and UNIX Shell

Designed and coordinated the scheduling of jobs

Environment:

DB2, Oracle, Sybase, SAS Data Mining Solution

IBM (China) Co, Ltd. – China

Technical Specialist/Technical Consultant

Apr 2001 – Mar 2003

Projects:

HeNan Telecom Billing System

Production database implementation design including sizing and data distribution, security and data recovery

Data migration application developer using DataStage and UNIX shell

Environment:

DB2, Oracle, TOAD, UNIX Shell, PL/SQL

State Economic and Trade Commission Industry Investment Management Data Warehouse System

ODS Logical and Physical Data Model design

Defined support and administered standards for production databases

Supported the ETL development on DB2

Environment:

DB2, DataStage

China Railway Communication Company Business Analysis Support System

Performed monitoring and tuning

Designed ETL process

Designed the fix solution including index strategies and data distribution

Environment:

Informix, Redbrick, DataStage

China Construction Bank Bond and Mutual Fund system

Maintained database physical data model

Supported the development application on Informix

Defined support and administered standards for production databases

Environment:

Informix, Erwin, Datastage, Business Objects

Sagent Technology Services China Ltd. – China

Technical Consultant

Dec 2000 – May 2001

Projects:

Tang Shan Telecom Customer Relational Management System

Implemented database design including sizing and data distribution, security and data recovery

Data migration application developer using Sagent

Environment:

Oracle, DB2, Sagent

China Beijing Telecom Business Department Data Warehouse System

Logical and physical data modelling design

Designed and developed ETL process using Sagent

Environment:

Oracle, Sybase, DB2, Sagent, Power Designer

Computer Center, Institute of Geophysical Exploration – Beijing, China

Reporter Developer/Developer/Project Manager/Programmer

Sep 1995 – Dec 2000

Projects:

China Construction Bank Credit Data Warehouse System – Reporter Developer

China Air Sales Analysis Systems of Passenger Transport Center – Developer

China Petroleum and Natural Gas Group. Co. Statistical Information Analysis Systems – Project Manager

CCTV video source material management system, First Phase – DBA and C Developer

Advertisement Edit and CDbase Management Systems Using TV station – DBA and C Developer

The Traffic Bank of China Deposit Software Development

Institute of Geophysical Exploration’s Database Information System

Environment:

Visual C, Visual Basic, Sybase, DB2, Power Designer Business Objects

EDUCATION

Qualification

Computer Application (University of Shijiazhuang, 1995)

Contact this candidate