Manager Project

John Jiang

Email: ************@*******.*** Cellphone: 416-***-****

Abstract

I am a senior business intelligence consultant with 8 years in consulting, 10+ years in BI and 20 years in IT. I have double top certifications in BI industry: IBM Certified Solution Expert and Microsoft Certified Solution Expert. I have extensive consulting experience in data warehouse/data modelling, ETL, OLAP/cube, dashboard KPI reports and BI architecture design. I have successfully delivered many end-to-end BI projects for retail, wholesale, pharmaceutical, health care industry. Strong business analysis skills and data modeling skills.

Expertise

20 years IT experience

10+ years in Business Intelligence, ETL, Data Warehouse, Reports, Dashboard, OLAP/cube

IBM Certified Solution Expert - Cognos BI (top level certification of Cognos BI), Framework Manager, Report Studio, Transformer, Data Manager

Microsoft Certified Solution Expert – BI (top level certification of Microsoft BI), SQL Server 2005/2008/2012 (SSIS, SSAS, SSRS)

Certified PMP professional

Substantial experience in retail, wholesale, pharmaceutical, health care industries

Technical Skills

Cognos BI: Cognos 8/10 Framework Manager, Analysis Studio, Report Studio, Query Studio, Event Studio, PowerPlay, Transformer, Active Reports

Microsoft BI: Microsoft SQL 2005/2008/2012, SSIS, SSAS, SSRS

Database: SQL 2000/2005/2012, Oracle 8i/9i/10g

Programming: T-SQL, PLSQL with TOAD, MDX

Knowledge: IBM TM1 9.5/10.2 Architect, Big Data Hadoop HDFS/MapRedue

Work Experience

Newcomp Solutions, Toronto

Senior Business Intelligence Consultant 2008 – Present

Projects

Noble Enterprise Data Warehouse and BI Project 2010 – 2015

Technical lead to deliver end-to-end business intelligence solution with Microsoft BI and Cognos BI technology to help client manage wholesales business for Plumbing, HVAC, Hydronics, Industrial, Building Maintenance and Fire Protection products with branches in Ontario, Quebec and British Columbia

Designed/developed the BI architecture with multi layers and multi servers installation

Designed and developed data warehouse with SSIS, loaded data from Progress database, SXe ERP system, Novatime, Nuway, TWL

Created finance cube, sales cube, purchasing cube and inventory cube with SSAS

Managed meta data with Framework Manager, built comprehensive security control with Access Manager

Conducted business analysis, collected business requirements, created reports to improve business decision process and explore business opportunities

Built 200+ analytical reports, dashboard reports, active reports, and portal for senior management, managers, and sales rep

Using Event Studio to manage event based jobs and schedules for 100+ jobs to run reports and bursting to 500+ users

Upgraded Cognos from 8.4 to 10.1.1 to 10.2.1 to 10.2.2 with LifeCycle Manager

Ontario College Application Service (OCAS) Reporting Project 2010

Developed 20+ formatted reports with Report Studio to help client manage student information

Amgen DLD Project 2009

Developed ETL and data mart to process Doctor Level Data from IMS

Created dashboard reports to analyze pharmaceutical information in healthcare industry

Toronto Star Marketing Reporting Project 2009

Created marketing reports for business to analyze customer information

Markham Stouffville Hospital Nursing KPI Project 2008

Developed ETL and data mart to integrate MediTech and MediHR data

Zimmers Data Warehouse and BI Project 2008

Developed ETL and data mart to load data from AS400

Developed PowerPlay cube with Transformer

Managed meta data with Framework Manager

Created portal reports with Report Studio

Novo Nordisk Third Eye Project 2008

Built data warehouse in star schema using SQL 2005 database with proven best practice, high scalable and extendable, maximum query performance

Developed SSIS ETL to integrate IMS data, TSA data, Xponent data and Siebel CRM data, built alignment hierarchies to analyze data by territory, region

Developed cubes with SSAS to handle many-to-many entities relationship

Created dashboard reports to analyze pharmaceutical market information (diabetes market)

Longo Brothers Fruit Markets Inc., Mississauga 2005 – 2007

Business Intelligence Analyst

Responsibilities

Worked in Longo’s head office, responsible for enterprise BI solutions, leading BI projects from designing, developing and implementations (five people in team)

Analyzed business requirements, prepared project charter and project plan for BI projects, developed project status reports and presentations for steering committee

Designed data warehouse model and cube structures including dimensions and hierarchies

Integrated data among several ERP systems, eliminated data discrepancies issues

Built data warehouse with ETL in SQL 2005 and Oracle 10g to extract data from ERP systems (Oracle HR/Finance, Tomax, Grocery Gateway, and POS)

Built sales cube and finance cube with SQL 2005 SSAS, created calculation measures, partitions, and aggregations to enable business query cube fast

Built basket analysis cube which enable business to analyze product sales in transaction level with flexible ways (saved $20,000 for company)

Installed and configured ProClarity Analytical Server (PAS) 6.2, ProClarity Dashboard 6.2, set up security model in cube level and PAS level with customized user roles

Built sales projection model to forecast promotion sales which dramatically improved work efficiency from 3 days to 10 minutes

Supported Cognos Impromptu, IWR and Upfront, set up security, managed report sets

Created 200+ KPI business reports with Cognos Impromptu and IWR, MS Reporting Services and ProClarity Professional

Kraft International, Greater China Region 1997 - 2005

Systems Developer

Projects

Kraft Food International Regional Headquarter, Beijing 2004 - 2005

Promoted to Project Leader to design and develop technical/business solutions, manage business projects to deliver the solutions for business clients to improve process efficiency

Project Manager of Distributor Information System Project

Led 20-people team designed and developed data warehouse model, implemented BI application with Business Objects(BO)

Organized resource to deliver project outcomes within scope, budget and timelines

Directly communicated with national sales team to collect business requirements, analyzed risks and business change impact, designed BI infrastructure and solutions

Negotiated with distributors, worked with business partners to make project successful in win-win mode to enhance business relationship

Built ETL, Data Mart and Cube, prepared client tools for business to analyze data

Project Manager of Sales Forecasting Project

Managed the whole process from analyzing present forecast process to implementing forecasting system with Mercia

Reengineered sales forecasting process, improved forecast accuracy from 30% to 45%, reduced work time from five days to three days

SENIOR PROJECT ENGINEER

Kraft Food International Regional Headquarter, Beijing 2001 - 2003

Promoted to headquarters to lead IT technical engineers in designing, implementation and support IT services for four food plants; achieved over 95% customer satisfaction based on survey

Project Leader of System Migration Project

Lead a 10-people team, budgeted US $300,000 to migrate system from Windows NT to Windows 2003 AD (Active Directory) and XP, to standardize information infrastructure

Coordinated with other IT team in conform with IT infrastructure requirements and application developing standardization

Redesigned network and server structure, tested and packaged 100+ applications, built image and installed it for 800+ servers and workstations, and trained 1000+ users in 40+ cities

Saved 20,000USD with excellent organization for training and deployment, and reached 99.9% customer satisfaction

Project Leader of Kraft and Nabisco Information System Integration

Lead a 15-people team, planned and budgeted US $500,000 to integrate information infrastructure, network, email and applications

Managed multi-projects in coordinating with entire project plan

Saved 60,000USD in procurement hardware and software, completed all tasks in 9 months (1 month ahead of schedule) without interrupted business operation and integration

TECHNICAL SUPPORT SUPERVISOR

Kraft Food Suzhou Plant (formerly Nabisco Food), Suzhou 1999 – 2000

Responsible for designing and managing network infrastructure, database, and WAN communications

SYSTEM ENGINEER

Kraft Food Suzhou Plant (formerly Nabisco Food), Suzhou 1997 – 1998

Responsible for managing network system and helpdesk support, provided technical support to implement/solve manufacturing equipment, system, applications issues.

Education

Dongnan University, China 1992 – 1996

Computer Science

Professional Certifications

IBM Cognos 8/10 Solution Expert

Cognos 8/10 Administration

Cognos 8/10 Metadata Model Developer

Cognos 8/10 Report Author

Cognos 8/10 MultiDimensional Repor Author

Cognos 8/10 Data Warehouse Developer

Microsoft Certified Solutions Expert - BI

Microsoft Certified Solution Expert - BI

Microsoft Certified Technology Specialist

Microsoft MCDBA

Microsoft MCSE

PMI Project Management Professional (PMP)

Contact this candidate