Project Quality Control

VINCENT YU

***-** ********** ****

******@*****.***

North York, Ontario M2J 1A8 647-***-**** (

OBJECTIVE

To obtain a position as a System Analyst where my previous excellent system analysis, project implementation skills and background may be applied.

TECHNICAL SUMMARY

Database Design : Data modeling(DataCenter/Datawarehous/OLAP Design)

Database: OS/400, IBM DB2 UDB 9.1, Netezza 3.0; Oracle

Programming Language: CL/ILE RPG, Unix Script, PL/SQL, ASP.NET C# 2.0

Tools: Erwin, TOAD, BMC Remedy, Test Direct

ETL: Informatica8 / Datastage

OLAP: Microstrategy Certified Project Designer/ Report Developer

Certified Advanced Administrator/Engine Specialist

MCEP: Microstrategy Certified Engineer Principle

Others: DW Testing and Quality Control.

SUMMARY OF QUALIFICTION

Over 13 years Application Analysis/Enhancement/Administration experience in Retailing, Manufacturing, Banking and Aviation sectors.

Proven ability to be a coordinator and Team Leader; Strong and Effective Scheduling, Cost &Risk Control and Change Management experience.

Solid hands on experience in data warehouse design and implementation. Have been experienced several improper DW/DM design. Quite familiar with what should be or not be for BI Data modeling design. Different design for different BI tools.

PROFESSIONAL EXPERIENCE

ETL Developer Adastra 2008.1 -

Work Background:

Cancer Care Ontario DW project, worked as ETL informatica Developer

Skill Set : ORACLE, PL/SQL, Informatica mapping

Specific duties included:

Conform Dimension Specification & Development;

Has been rewarded as most efficient consultant.

DBA & MSTR Principle SHOPPER DRUG MART 2005.2 -

Work Background:

Shoppers Drug Mart, DBA Group, Involved in BIDW Project.

Skill Set : Netezza / DB2 / Informatica / Microstrategy / Pharmacy / Retailing

Specific duties included:

Datamart Design & Development;

Microstrategy Project Design & Report Development

Microstrategy Report Performance Tuning

ETL process: DM Informatica Mapping Development

Datamart Data Quality Control

DB2/Netezza maintenance and Support;.

Microstrategy/NarrowCastServer administration, upgrade and optimization

Projects :

BIDW Category Management

BIDW ZeroingIn Project (CRM for Vendor)

BIDW Rx Project (Pharmacy Data Repository DM)

Analyst Programmer CANON CHINA CO., LTD

2003.7-2004.11

Work Background:

Canon E-business (E-Ordering/Banking/Service) Project provides Web Application to it s Vendors, Bank and Customers. The Data exchange between E-business and AS/400 based

RAMBO AP system is deployed by using IBM MQ Series;

Skill Set : AS/400 / MQ Series / Retailing

Key Role : Project Coordinator / Analyst programmer

Specific duties included:

Worked with Management and third party to prioritize projects. Worked with third party AP support to resolve issues; Ensured information regarding Customer site access and changes is communicated to all facilities.

Data exchange between Web and AS/400 architecture design and development

Installation, configuration and administration of MQ Series;

System Unit & Integrity testing; Ensured EDI availability 24/7; Technical Documentation

Application Support: Inventory/Purchasing/Sales Order/Delivering/Invoicing/GL/AP/AR.

Projects :

E-Ordering architecture design and implementation

E-Business Data Interface with AS/400 design and implementation

Data Architect NEWLANDSOFT CO., LTD

2002.7-2003

.7

Project Background:

COMPUTER ASSOICATE(CA), NEWLANDSOFT, and AIR CHINA have been involved into AirChina Datawarehouse Project. As Data Architect, I carried on the design task from UK DW specialists.

Skill Set : DataWarehousing/Data Modeling/ORACLE 8/ CA ETL/OLAP Toolset / Aviation

Specific duties included:

Enterprise Level Data Centre Core, Consolidated Data Store and DataWarehouse Design

Data Gathering, Conforming and Consolidation; ETL specification design

DCC&CDS(Consolidate Data Store) Construction

Route traffic and Revenue data OLAP analysis -- EIS design and implementation

Data Gap Analysis & Data Quality Control

Projects:

AirChina Enterprise Data Warehouse Project

ShanDong Province Construction Bank DM Project

System Analyst SEIYU SINGAPORE PTE, LTD 1998.12-2002.6

Work Background:

SEIYU DataWarehouse project started in Mar 2000. I was involved to be DW/ETL/OLAP designer and developer

Skill Set : DataWarehousing/Data Modeling/DB2/DataStage/Microstrategy/JDA/ Retailing

Specific duties included:

JDA MMS AP support for Inventory Control/Purchasing /Sales/Price&Cost/AP;

JDA MMS based Datawarehouse design and implementation;

Datawarehouse software installation and configuration

DW ETL Design and implementation (Datastage 6.5); Leverage ILE RPG, AS/400 trigger function and DataStage to achieve efficiency and effectiveness of ETL process.

Administration of Datawarehouse environment; Fine tuned DB2 UDB to maximum the Microstrategy reporting performance;

Microstrategy Project and Reporting design.

Projects :

JDA MMS4 SYSTEM Enhancement Projects (AS/400, RPG)

SEIYU

(Singapore) JDA MMS DataWarehouse

1> Marketing Daily Sales/GP Reporting project

2> Consignment and Concessionaire Sales Project

Event management Project

AS/400 Analyst Programmer LITEON (TIANJIN) PTE., LTD 1997-1998

Manufacturing Company, Maintenance and Development of DIS and BPCS system

AS/400 programmer TOYOTA (TIANJIN) CO., LTD

1994-1996

Manufacturing MIS, Maintenance and Development of TTME System.

EDUCATION

Microstrategy Certified Engineer Principle (MCEP/MCE/CAA/CPA/CPD/CRD)

Bachelor Degree

Engineering Information Management, 1994

Haerbin University of Science & Technology,

China

Contact this candidate