OBJECTIVE:

• To be in a technically stimulating environment where I can fully utilize my experience, skills, and abilities to turn problems into solutions.
• To be in a responsible position like Data Warehouse Specialist where I can contribute to organization\'s success.

SUMMARY:

• More than 15 years of IT professional experience as developer / production support in various platforms both in hardware and software from physical level to application level.
• Over 9 years experience in both ETL and business intelligence. Tools include Informatica, DataStage, Microsoft Integration Service (SSIS) Decision Stream/Data Manager, Cognos 8.x.
• 7+ years of professional ETL experience in DataStage, Informatica,, Microsoft Integration Service (SSIS) development, administration and architecture.
• 3+ years of hand - on experience of Cognos including using Decision Stream/Data Manager ETL data; creating OLAP model with Framework manage; creating cube with Transformer; creating professional report and analysis data using Power play, Report studio, Analysis studio, Query studio and Metric studio.
• 5+ years experience in ER model design, logical and physical modeling design, RDBMS application development and implementation based on Oracle, MS-SQL Server, Teradata and DB2.
• 3+ years of professional development experience in Mainframe MVS.
• Strong database development skills in Teradata, Oracle, DB2, SQL Server
• In depth experience and knowledge in Data Warehouse including Data modeling, OLAP analysis, Data mining, report services development, analysis.
• Demonstrated working experience in enterprise-wide, complex IT projects with terabyte databases of heterogeneous database including Teradata, Oracle, DB2, SQL Server
• In depth knowledge and experience in all phases of architecture development life cycle as integrated in software development life cycle (SDLC).
• Demonstrated project management experience and skills including planning, estimating leading teams to deliver the high-profile project beyond deadlines.
• Lead a team as project leader to finish the multi-millions high-profile projects (WNQA, RAM(Risk Accumulation Management), PIA) with an extremely tight deadline
• Closely work the business from senior management to front-end users. Acted as single point of to both business partners and IT department.
• Technical documentation including BRD, design specification, deployment and user guides, project plans, RFP and Proposal activity and status reports for clients, senior managements and team members to ensure the project efficiency and effectiveness.
• Self-motivated, detail-oriented, creative, flexible and able to work effectively in a fast paced environment.

TECHNICAL Skills:

Informatica 8.5, 7.4, 6.2

IBM WebSphere DataStage 8.1, 7.5.2, 6.5

Microsoft SSIS 2005, 2008

IBM Cognos Decision stream / Data manager

OLAP/REPORT:

Cognos 8.4, 8.3, 7.1, Cognos TM1

Microsoft SSAS, SSRS 2002, 2005, 2008.

Data modeling:

ERWIN 4.0/3.5, Star-Schema & Snowflake-SchemaModeling

RDBMS:

Teradata, Oracle, DB2, SQL Server, IMS

Operating Systems:

Unix, Windows, IBM Mainframe MVS

Programming:

SQL, MDX, C,C++,C# Java, PL SQL, Transact-SQL, Teradata-SQL, Mainframe JCL, Cobol, PLI, Unix Script.

Work Experiences:

Confidential, 2010. 7 -- 2010.11

Projects: Online Banking, Contact Center, Sales person Commission Audit.

The purpose of these three projects are use enterprise data warehouse as data bus to share the business data between the applications

Responsibilities:

• Worked close with business user and BA to find you the business requirement.
• Designed and developed jobs to share the data between the various applications using Teradata BTEQ, Fast export and MutiLoad.
• Participated whole SDLC including business requirement collection, design, development, testing, implementation and production support.
• Carried out performance test and performance turning in Teradata data warehouse environment.

Environment: Teradata, Datastage, Mainframe, DB2, Oracle, Sql server.

Confidential, 2010.2 2010.06

I am working for Confidential, as an ETL developer. Confidential, leading property and casualty insurance companies in terms of direct written premiums.

Projects: HCAI, RAM (Risk Accumulation Management)

RAM is a multi-millions data warehouse project of the insurance company. This provides the information including GIS for risk management purpose. This system provides integrated information for business analytics and predictive analytics matching the company strategies.

Responsibilities:

• Design and development the ETL application including source to target mapping, documentation and coding.
• Closely working with the businessiness including BRD review, business process analysis.
• In depth knowledge of data modeling including data modeling review.
• Data Quality Controlling (various OLTP data source analysis) and Data Cleansing (resolving inconsistencies and fixing the anomalies in source data).
• Through knowledge and experience in SDLC process. Worked through whole ETL development lifecycle.
• Participate in UAT testing.
• Production support, maintained, debugged and modified all existing ETL scripts according to the RFC No. (Request for Change) and Defect No.
• Performance tuning for ETL systems.

Environment: Informatica, Datastage, DB2, UDB, SQL server, Mainframe.

Confidential, 20 .2

ETL/BI Specialist

Project: Training management

Responsibilities:

• Performing ETL job with using of SQL programming skills and SSIS.
• Design and develop the interface for data migration and data reconciliation.
• Worked with end users and collected the business requirements.
• Wrote down the function specification, high level and detail design.
• Wrote down the data mapping.
• Designed the logical models and physical models
• Worked with DBA implemented the data model
• ETL data with Microsoft SSIS and Cognos data manager.
• Created BI models with Cognos framework management.
• Created Cubes with Microsoft SSAS.
• Created reports with Cognos report studio and Cognos analysis studio etc.

Environment: Cognos 8.4, Cognos data manager,Cognos TM1, SQL server 2005/2008, SSIS, SSAS

Confidential,

Data Architect/Developer 2009.3 2009.11

Project: Performance Index Analysis (PIA)

Confidential, This system provides the KPI performance analysis across over the province. The clients’ coverage over ten millions.

Responsibilities:

• Act as oversea specialist providing consulting services from strategies, design for the whole systems.
• Review the output and implementation process of the system.
• Supervise and work with a team oversea to implement the process.
• Designed data model for the data warehouse, business intelligence application.
• Closely work with the business parties with matching the architecture standard and business strategic scope.
• Design and develop the system including performance tuning.
• Mentored junior staffs and provide recommendation on critical issues.

Environment: Informatica, SSIS, Cognos, Oracle, SQL server, IMS, AIX UNIX, Windows Server.

Confidential,

ETL Developer 20 .09

Confidential,Both of these two projects involved re-engineered and enhanced. The existing ETL processes were coded by PL1, COBOL, SAS, DB2 and Oracle utilities running on the Mainframe MVS. The purpose of these projects is to migrate the existing logic from the Mainframe to the Datastage, Unix platform and then add some new logic on top of it.

Responsibilities:

• Worked on the EDW and CAMPS projects
• Read the existing Mainframe codes to figure out the original logic as business requirement
• Designed and coded new ETL process on DataStage environment based on the logic from original mainframe jobs.
• Performed parallel tests to ensure that the new code produced the same result
• Mentored junior developers and worked with team members to resolve critical issues
• Implemented the new ETL process scheduled by Mainframe MVS ESP
• Created reports with the data from Data Warehouse previous created by Cognos

Environment: DataStage, DB2, Mainframe, PL1, SAS, Oracle, SQL Server, Cognos, Crystal Reports, Unix, Windows

Confidential, 20 .11

Technical System Analyst

Confidential,working in Royal Bank of Canada (RBC) client site as a Data warehouse consultant, RBC is using Teradata solution to build their own Enterprise data warehouse. My tasks are to ETL the data from various operational systems to build the Enterprise data warehouse. In this period I have completed the following projects involving ETL data using various solution such as Teradata solution, Oracle solution, SQL server solution, IBM solution etc, performance data migration, design Data Modeling, establish Enterprise data warehouse, code convert (Convert COBOL, WebFocus ) etc.

Project: Prepaid Debit Cards

This project is required to extract data from Oracle, its need to be transformed and loaded to Teradata Data warehouse, using DataStage and Oracle utility and the jobs should be scheduled by Mainframe Jcl and zeke.

Responsibilities:

• Provided the technical helps to analyze the relation among the source data and warehouse data and help to write mapping document.
• Wrote the detail design documents.
• Coded Extract jobs to extract data from Oracle platform with PLSQL program.
• Coded Transform jobs using Datastage, Teradata .
• Loaded the data to Teradata with DataStage.
• Create JCLs and schedule the jobs in Mainframe Zeke with JCL.
• Wrote the operational manual.
• Provided production support.

Project: Business Loan Insurance Plan

This project is required to extract data from Mainframe applications. The Mainframe applications are coded by COBOL. The target data warehouse is host by Taradata, the ETL tool is DataStage and jobs should be scheduled by Mainframe.

Rresponsibilities:

• Analyzed the logic from COBOL code
• Created new data model .
• Provided technical help to write the mapping document.
• Profiled data against Mainframe data (i.e. EBCDIC, comp, binary etc).
• Wrote the detail design documents.
• Coded extract job with mainframe utilities.
• Coded Transformed jobs with DataStage.
• Created the Slow Change Dimension with DataStage.
• Loaded the data to Teradata with DataStage.
• Created JCLs and schedule the jobs in Mainframe Zeke with JCL.
• Wrote the operational manual.
• Provided production support.

Project: Conversational Log

This project is required to convert existing program from COBOL code, Web Focus code, DataStage server code and add some new logic on top of existing logic.

Responsibilities:

• Analyzed the COBOL, Webfocus, Passport code base.
• Wrote the data mapping and detail design.
• Coded the extract job to extract the source data from DB2 with DB2 utility.
• Loaded the data to Teradata.
• Coded transformation jobs using SQL statement and Teradata utilities.
• Create Slow Data Dimension with TeraData utility ie. BTEQ and Multiload.
• Create summary tables and performance Referential Integrity check with SQL statement.
• Created JCLs and schedule the jobs in Mainframe Zeke with JCL.
• Wrote the operational manual.
• Provided production support.

Environment: DataStage, SSIS, Cognos, Teradata, Mainframe, Oracle, DB2, SQL server, JCL, COBOL, WebFocus, UNIX, WINDOWS.

Confidential,

Data Warehouse Analyst/Developer

During the period of working for the Chinese leading Telecommunications Company, I took part in: Decision Support project, Customer Behavior Analysis project and Wireless Network (CDMA/GSM) Quality analysis project.

Project: Wireless Network (CDMA/GSM) Quality analysis

This project is to build data mart for Network optimization

Responsibilities:

• Provided data warehouse related technical support with RF engineer help to build various KPI data model
• Converted Call detail Log from the Switch, extracted Call detail Record from BTS and extract data from Road Test which is in internal binary into Text format with C program.
• Extracted the formatted data into staging table stored by Oracle in UNIX with Informatica.
• Coded transformation and loaded jobs to build data mart with Informatica
• Created summary table and cube with PLSQL
• Worked with network optimization engineer to created report and performance OLAP such as Drop call analyze, Ec/Io, RX power analyze, TX poser analyze and other KPI analyze with Cognos and MicroStrategy.

Project: Customer Behavior Analysis

This project is to build data mart for marketing support

Responsibilities:

• Extracted Call detail Record, short text message from staging table and Extracted data for user management database with Datastage.
• Transferred and loaded them to various Data Marts host by SQL server with SSIS.
• Provided technical support to marketing department help to create reports i.e. subscriber plan analyze, Promotion analyze etc with MicroStrategy, Brio,excel.

Project: Decision Support project

Responsibilities:

• Converted the data from telecommunications system internal format (BINARY) into text (ASCII) format with C program.
• Extracted data from operational system i.e. billing system value-add system, CRM system etc host by Oracle, Sybase with Informatica.
• Transfered and loaded them to staging table for enterprise data warehouse with Informatica.
• Provided technical support to create the report and performance OLAP such as Competitor Analyses report, Return on Investment report, Service Package analysis report with Cognos.

Project: Enterprise Data collection

This project is to collect log data from Telecommunication facilities, transform the internal format to text (ASCII) format and load the formatted data to staging table, for purpose of establishing Enterprise data warehouse.

Responsibilities:

• Took part in design data model of the staging database with ERWIN in Oracle
• Collected, log data from various Telecommunication facilities. Which’s are Motorola BTS, Alcatel switch, CISCO router.
• Analyzed and transferred the data to text file with C according to manufacturer’s manual.
• Reorganized, transformed, Load the formatted data to staging table with SSIS.

Project: Network management system for China Unicom.

This project is to build Data Mart for network maintain purpose

Responsibilities:

• Took part in establishing data model of the staging database with ERWIN in Oracle.
• Provided data warehouse related technical support to design the analysis model of data mart for CDMA/GSM Daily Running Report.
• ETLed the data from enterprise staging database to Data mart with Informatica.
• Created summary table and report with Crystal Report.
• Created report and OLAP analysis SSAS, SSRS.

Environment: Informatica, DataStage, SSIS, Cognos, SSRS, SSAS, MicroStrategy, Oracle, SQL server,DB2, UNIX,WINDOWS.

Professional Training and Certification:

• Bachelor of computer science in South China University of Technology.
• IBM Certified Solution Developer of WebSphere IIS DataStage Enterprise Edition V7.5