Manager Project

ALLAN WANG

Tel: 416-***-****

Email: *************@*****.***

OBJECTIVE

With many years of solid experience in information systems design, development and support, primarily in Business Intelligence (BI) / Data Warehousing area, a strong team player and self-starter, exploring for a challenging opportunity with a great organization.

SUMMARYSeventeen years of IT professional experience and fifteen years in the business intelligence / data warehousing area, working experience in different industries such as banking/financial services, telecommunications, government/education and manufacturingWell versed with industry-recognized DW / BI systems design methodologies (Ralph Kimball / Bill Inmon), with extensive experience in all phases of DW/BI system development life cycle (SDLC): from requirement analysis, architectural design to detailed implementation; from back-end data processing to front-end BI solutions.Hands-on experience in RAD / Agile DW/BI systems development methodologies;BI (OLAP/Reporting) solutions expertise: Profound experience in BI systems planning, design, implementation, administration, and support. Extensive working experience with Cognos BI Series, Business Objects, Oracle OBIEE, and Crystal Reports, etc.Data Integration / ETL experience: Experienced in Data Profiling, ETL process design and development, worked on very large data warehouse systems; Working experience with a variety of ETL tools such as Informatica PowerCenter, Ab Initio, Oracle Warehouse Builder (OWB), SSIS, etc.Data Architecture / Data Modeling expertise: Highly experienced in conceptual/logical/physical data modeling, including dimensional (Star Schema /Snowflake) and 3rd Normal Form (relational, OLTP). Thorough understanding of Enterprise Data Management (EDM), Master Data Management (MDM), and Metadata Management methodologiesBusiness Systems Analysis expertise: experienced in business requirements analysis, process design, change management, systems analysis / data analysis, functional/technical specifications (ETL rule/data mapping, BI front-end specifications), testing, training, documentation, etc.Profound experience working with different relational database such as Oracle, DB2, MS SQL Server, and Sybase, etc., Strong background with different UNIX and Windows platforms;Strong analytical and problem-solving skills, excellent inter-personal communication skills;

TECHNICAL SKILLS & TOOLSBI OLAP/Reporting: Cognos BI Series (Business Insight, Business Insight Advanced,

Go! Dashboard Framework Manager, Report Studio, Query Studio,

Analysis Studio, Transformer, Metrics Designer, Metrics Studio, DMR, MDX,

SDK, etc.), Cognos Express, Business Objects, OBIEE, Crystal Reports

- ETL Tools: Informatica PowerCenter, Ab Initio, Oracle Warehouse Builder,SSIS,etc.Data Modeling: ERwin, Sybase PowerDesigner, Oracle Designer, Quest QDesignerDatabase: Oracle, DB2, MS SQL Server, Sybase, Informix, MS AccessProgramming: Unix Shell Script, C, PL/SQL, Java, JSP, ASP, XML, Visual Basic/VBA, etc.Platform: Sun Solaris, IBM AIX, HP HP-UX, Windows Server (NT/2003/2008), IIS,

Apache, Tomcat, etc.SQA/SCM/Others: SEI CMM, Rational ClearCase, PVCS, WinCVS, AbInitio EME,

MS Visual SourceSafe, Control-M, XML, HTML, Rational Rose, TOAD,

PLSQL Developer, Visio, MS Project, etc.

PROFESSIONAL EXPERIENCE

York University July 2012 – Present

Senior Enterprise Data Warehouse Analyst

Project Assignment Overview: Enterprise Data Warehouse (EDW) system development / maintenance in support of organization-wide planning, policy formulation and decision-making.

Roles and Achievements:

Acted as a focal person to take care of the Enterprise Data Warehouse, which is composed of both front-end BI solutions and back-end ETL processes. Responsible for all aspects of EDW systems planning, architectural design, development and day-to-day operations. Served as the university EDW expert and the primary source of technical information for proposed solutions.Liaised with different functional groups to gather business requirements;Liaised with senior analysts of source systems, facilitated consensus among system stewards;Performed system / data analysis, gap analysis and feasibility analysis;Produced functional design specifications;Produced system / data architectural design specifications: system specifications, conceptual/logical/physical data models, high-level design of ETL/BI sub-systems;Performed detailed technical design and development of BI elements / ETL processes;Ensured that the EDW/BI systems are available and functioning efficiently as per SLAs;Performed production system support, upgrade and trouble-shooting;Responsible for the final resolution of all technical problems related to the EDW;Researched, recommended and participated in developing university strategic BI initiatives;

Tools / Technology:

ERwin Data Modeler, Cognos BI 10.1 / 8.4, Oracle 11g, Oracle Warehouse Builder (OWB), Oracle Business Intelligence Enterprise Edition (OBIEE), Windows Server 2003, Sun Solaris, TOAD, PL/SQL Developer, etc.

Ontario Ministry of Education January 2012 – May 2012

Senior BI Consultant

Project Assignment Overview: EBI Project - EOIM (Employment Ontario Information Management) BI system design and development.

Roles and Achievements:

Successfully designed, developed and delivered the EOIM Executive Dashboard / scorecards, related reports, metadata models, packages and Cubes, to meet the BI needs from the business.Performed BI / DW systems planning, architectural/detailed solution design and development using RAD / Agile BI systems development methodology;Played a key role in requirement analysis, systems analysis, data analysis, gap analysis and feasibility analysis;Provided professional insights and suggestions to work out quality DW/BI solutions.Designed quality and robust Cognos Framework Manager models that are catered to complex large-scale BI projects;Designed Cognos Transformer dimensional models and PowerCubes for dynamic data analysis / reporting;Designed and developed Executive Dashboards in Cognos Business Insight, Cognos Business Insignt Advanced;Designed and developed complex Report Studio reports and re-usable report templates;Designed and created metrics / scorecards using Metrics Designer and Metrics Studio, to support performance management;Provided user training and assistance in utilizing different BI elements, including Query Studio, Analysis Studio, Metrics Studio, etc.Played an active role in support of the ETL process design and development, using Informatica PowerCenter;Provided BI systems administration and user support;Provided technical training among team members;

Tools / Technology:

Cognos BI 10.1 (Business Insight, Business Insight Advanced, Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Administration, Framework Manager, Transformer, Metrics Designer, Metrics Studio, DMR, MDX, SDK, etc.), ERwin, DB2, Toad for DB2, Informatica PowerCenter 9.x, IBM AIX, Windows Server 2008, etc.

Scotiabank (Scotia Capital) April 2010 – October 2011

DW / BI Consultant

Project Assignment Overview: BI / DW system development, migration and support;

Roles and Achievements:A go-to person to take care of all aspects of the DW/BI systems administration, development and support;Successfully migrated all legacy reports from ReportNet and Business Objects to latest Cognos platform;Performed business requirements analysis;Analyzed legacy reports in BusinessObjects and ReportNet;Performed systems analysis, data analysis, gap analysis and system change impact analysis;Performed functional designs and detailed technical designs of the BI elements;Maintained Cognos Framework Manager Models to make sure the metadata reflects the most up-to-date data warehouse structure and business needs;Created prototype reports to help users/management understand their needs;Developed new reports based on new business requirements, using Cognos ReportStudio;Facilitate users in utilizing Cognos BI elements, eg., Analysis Studio, Query Studio, etc.Performed BI systems administration and production system support;Prepared the upgrade to Cognos 10 platform;Played an active role in data warehouse / ETL process design and development, using Informatica PowerCenter;Provided training and guidance to project team and users in functional and technical areas;Took a lead role in identifying opportunities of improvements in the current BI/DW system;Solely identified a serious architectural design flaw in the data warehouse system;Guided and supported the team to address the data warehouse design issue identified;Provide timely project estimates, status update and input to the project manager;

Tools / Technology:

Cognos BI Series 10 / 8.4, ReportNet (Business Insight, Business Insight Advanced, Go! Dashboard, Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Administration, Framework Manager, Transformer, Metric Designer, Metric Studio, DMR, MDX, SDK, etc.), Business Objects, ERwin, MS SQLServer, SQL Server Management Studio, Informatica PowerCenter 9.x, SSIS, Visio, SAS, IBM AIX, Windows Server 2008, etc.

Telus Communications Company January 2009 – December 2009

DW / BI Systems Analyst

Project Assignment Overview: Data warehouse/BI systems analysis, design and development

Roles and responsibilities:Lead in the design of data, application and technology elements;Played an active role in DW/BI systems requirement analysis and functional designs;Performed systems analysis, data analysis/data profiling, gap analysis, system change impact analysis, etc.Performed architectural / detailed Cognos BI element design and development (Framework Manager metadata models, Transformer dimensional models, packages, Cubes, Report Studio reports, Dashboards, metric extracts, scorecards, etc.)Provided BI systems administration and user support (Cognos Administration, Query Studio, Analysis Studio, Event Studio, etc.)Performed high-level and detailed Informatica ETL process design and development (data mapping/transformation rules, source definition, target definition, transformations, mappings, workflows, reusable mapplets, tasks, worklets, Unix Shell scripts, etc.)Performed DW/BI system Unit Tests and SIT tests, facilitated QA / UAT tests;Created and updated DW/BI systems documentations;Performed production systems trouble-shooting to identify issues in existing DW/BI system;Identified and fixed several severe DW/BI system architecture/design flaws hidden for years;Successfully executed all project coordination, development and implementation tasks within challenging project timeline;

Tools / Technology:

Cognos BI Series 8.3/8.4 (Go! Dashboard, Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Administration, Framework Manager, Transformer, Metric Designer, Metric Studio, DMR, MDX, SDK, etc.), Informatica PowerCenter 8.1/8.5, ERwin, Oracle RDBMS(9i, 10g), PL/SQL, Control-M Scheduler, ClearCase, TOAD, Visio, SAS, IBM AIX, etc.

Toronto District School Board June, 2007 – August, 2008

Business Analyst (Data Warehouse / BI / Data Architecture)

Project Assignment Overview: Data warehouse/BI system design and development

Roles and Achievements:Proposed quality Data Warehouse / BI solutions as per business needs;Liaised with the client groups;Performed business requirements analysis;Performed systems analysis, data analysis, gap analysis, feasibility analysis, impact analysis;Produced functional/technical requirement specifications;Performed data modeling (conceptual / logical / physical data models);Maintained data inventory / meta-data repository;Produced BI front-end design specifications (Cube and Report design specifications)Lead the Cognos BI system design, development and administration (Framework Manager models, Transformer models, packages, Cubes, Reports, Dashboards, etc.) Produced ETL design specifications, including transformation rules and data mappings;Lead the ETL process development and implementation using Informatica PowerCenter;Conducted / coordinated unit test, system test;Facilitated User Acceptance Test;Maintained proper documentations, provided user training;Performed production system support and trouble-shooting, etc.Supported and maintained legacy Crystal Reports;

Tools / Technology:

Cognos BI Series 8.3 (Go! Dashboard, Report Studio, Analysis Studio, Query Studio, Event Studio, Cognos Administration, Framework Manager, Transformer, DMR, MDX, SDK, etc.), ERwin, Informatica PowerCenter 7/8, Crystal Reports, Oracle (9i/10g), PL/SQL, TOAD, Visio,Visual SourceSafe, Windows Server 2003, etc.

Dynamic Funds Oct, 2006 – June, 2007

BI / Data Warehouse Systems Support Analyst

Project Assignment Overview: Data Warehouse / BI system development and support

Roles and Achievements:Liaised with business client groups and other project teams;Identified opportunities and proposed quality solutions to enhance BI / DW systems;Gathered business requirements;Designed conceptual / logical / physical data models;Maintained data inventory / data dictionary / meta-data repository;Produced BI/DW functional / technical design specifications; Created and maintained Cognos Framework Manager metadata models;Designed and maintained Cognos BI reports / dashboards, PowerCubes, etc.Provided Cognos BI system administration;Performed ETL process design and development;Provided user training, performed production system support and trouble-shooting, etc.Performed DW/BI software installation, configuration and upgrade, coordinated with vendors for supports, etc.

Tools / Technology:

Cognos BI Series 8 / 7 (ReportNet, PowerPlay, Impromptu, Transformer, Report Studio, Query Studio, Analysis Studio, SDK, etc.), Cognos Enterprise Planning Series 7, ERwin, Crystal Reports, Informatica PowerCenter (7.1.4), Oracle(9i, 10g), PL/SQL, Oracle Designer, TOAD, Microsoft SQL Server 2005, T-SQL, XML, XSD, MS Access, VBA, Visio, WinCVS, etc.

BMO Financial Group Jul. 2004 – Oct. 2006

DW/BI Systems Analyst / Developer

Project Assignment Overview: Decision Support Services: Data Warehouse / BI systems design & development

Roles and Achievements: Liaised with business client groups and other IT teamsProposed and offered BI solutions

- Gathered business reporting / data analysis requirements

- Produced functional / technical design specifications of Cognos cubes / reports;

- Performed Cognos BI systems administration and support;

- Maintained Cognos catalog;

- Created Cognos reports / dashboards, helped users creating Cognos Ad Hoc reports;

- Facilitated UAT tests;

- Provided user trainings;

- Provided production system support/trouble-shooting, etc.

I received very positive feedbacks from the management & users, and BMO Bravo Award in 2006.

Project Assignment Overview: Harris Basel Retail / BMO Basel Retail Data Warehouse Project

Role: Data Warehousing Systems Analysis, Design and Development.

- Reviewed user requirements;

- Produced functional design specifications, data mapping specifications;

- Performed detailed technical design, ETL process development and unit testing;

- Provided QA system test and UAT test support;

- Performed production support & trouble-shooting;

- Worked out solutions and brought up suggestions to improve existing systems;

- Coordinated development tasks within group;

- Maintained clear project documentations, etc.

Tools / Technology:

Cognos BI Series 7 (PowerPlay, Impromptu, Transformer, etc), Sybase PowerDesigner, Sybase IQ, Erwin Data Modeler, Ab Initio with EME, DB2, IBM AIX, Sun Solaris, Unix Shell script, PVCS, AutoSys Job Management, MS Visio, MS Project, AQT, ESP Job Scheduler, etc.

Motorola (China) Electronics Ltd. Mar. 1997 – Mar. 2003

Business Systems Analyst, Sr. Programmer Analyst

Project/Assignment Overview: BI / Data Warehouse System Development and Support

Roles and Achievements:Lead the DW / BI systems design, development, administration and support;Gathered user requirements, analyzed the business model, process and data architecture as the foundation of the OLAP/reporting systems;Created and maintained data models (conceptual, logical and physical);Created and maintained Cognos Impromptu catalogs / BusinessObjects universes, generated cubes/report/queryies (Cognos, Oracle Discoverer, Business Objects);Managed metadata/report publication, including web-based reporting, etc.Performed ETL process design and development;Conducted user training, user support, maintained documentation, etc.

Tools / Technology:

ERwin, Cognos BI Series (5, 6, 7), BusinessObjects (3, 4, 5)/WebIntelligence, Crystal Reports, MS SQL Server, Oracle 9i database, PL/SQL, Oracle Discoverer, TOAD, DB2, Oracle Warehouse Builder (OWB), K-shell Script, AutoSys, Apache HTTP Server, Tomcat, Java, Windows NT Server, IIS, ASP, VBA, RationalRose, XML, SEI CMM, ClearCase, C, IBM AIX, HP-UX, Sun Solaris, etc.

EDUCATION & CERTIFICATIONSB.S. Computer Science, Tianjin University of Technology, PRC Oracle Database 10g Administrator Certified AssociateCognos BI Series: Impromptu, PowerPlay, PowerPlay Enterprise Server, etc.BusinessObjects: BO, BO Designer, Supervisor, WebIntelligence, etc.ORACLE: Database Administration and Application Design Technology;Data Warehousing: The Data Warehouse Life CycleDimensional Data Modeling with ERwinCanadian Securities Course (certification in progress)IBM AIX/ HP-UX: System Administration, Shell Programming;Motorola University: Project Management; Team Problem Solving, etc.

AWARDS & RECOGNITIONSBMO Bank of Montreal: 2006 Bravo Award

Contact this candidate