ZHEN ZOU

****-*** ********* *** ******: 647-***-****

Mississauga, ON L5B 3Z2 acth8r@r.postjobfree.com

OBJECTIVE

Data Analyst/Business

Intelligence Consultant

TECHNICAL SUMMARY

Languages

SQL, T-SQL, MDX, VBScript, VB/C#, Java/JSP/Servlet, HTML/CSS

Platforms/Tools

ETL (DTS/SSIS), SSAS, SSRS, SQL Server Management Studio,

SQL Server Business Intelligence Development Studio(BIDs)/SSDT,

MS Visual Studio, SVN/TFS, MS Office, MS Visio

IBM RAD/RSA/WAS/WPS, Eclipse/JDeveloper

Operating Systems

DOS/Windows, UNIX (Solaris/AIX), Linux (Redhat/SLES )

Databases

SQL Server (2005/2008/2012), DB2 8.0, Oracle 9i/10g

QUALIFICATIONS SUMMARY

6 years of database and business intelligence development experience with

Microsoft BI Stack (SQL 2008/2012, SSIS/SSAS/SSRS, BIDS/SSDT)

Excel at SQL Queries, T-SQL, Stored procedures/Functions for reports

Experienced and well-skilled in ETL functions using SQL Server SSIS utilities

Experienced with OLAP Cube, Dimension/Measures, MDX queries, SSAS, SSRS

Experienced in using .NET scripting for SSIS packages

Familiar with Trade Finance, Letter of Credits, Trade Risk and Income Management

Effective communicator with business partners and clients

PROFESSIONAL EXPERIENCE

Data Analyst 2014.12 – 2016.01

Scotia Global Transaction Banking, Management Information & Analytics, Toronto

Main work: Developed and maintained Data Mart for MIS reporting of Trade Risk and Income

Management on CorrRisk platform to be used by TS&FI unit

CorrRisk: http://www.corrtec.com/Product.html

Designed and developed SSIS packages to load and transform OLTP and other data source

into staging and data mart; Migrated and re-developed existing DTS packages into SSIS.

Designed, implemented, and maintained Dimensions, SCD Dimensions, Facts, Controlling

and metadata tables for the reports, extract, and ad-hoc queries

Developed and maintained Stored Procedures and Functions to be used by reporting team

Developed and maintained OLAP Cubes extracted from data mart for specific user groups

Maintained and extended the existing ETL load to meet new change per request

Supported reporting team, operation team by providing data analysis and needed scripts

Assisted operation team on SQL Servers, MS BI Stack tool installation and troubleshooting

Documented and maintained design, implementation, and testing docs

Participated in requirement collection, refining, clarification with business analyst,

Internal customers, and project manager based on the pre-analysis on dataset as inputs

Sr. Consultant

Ericson Beijing, China 2010.03 – 2014.09

Consolidated and transformed multiple, disparate data sources into staging database

Developed and maintained SSIS packages for data cleansing, data conforming, data

aggregating, data loading automation

Developed and maintained Stored Procedures/Functions to be used by reporting team

Designed and developed new features, change request, and maintained existing reports

Provided ad-hoc query and analysis for senior managers on a regular basis

Developed and maintained related design and implementation documents

Led a 5-person team for level 3 product maintenance support

Sr. Consultant

Intershop Germany 2007.9 – 2010.1

E-Commerce Customization (B2B/B2C)

Developed new functionalities, and applied customization based on Enfinity platform

Performed timely internal bug fix, and external bug fix assigned by customers

Participated in design of web service integration for orders from external suppliers

Involved in design and implementation of external system integration (ERP/SAP)

Wrote and refined technical specifications for implemented functionalities

Advisory IT Specialist

IBM Global Service Austin and China 2006.5 – 2007.7

International assignment for IBM Web Portal Project

Developed, implemented new Portlets and related Portal Pages per customer’s needs

Enhanced, maintained existing IBM Portlets

Developed, enhanced, maintained JSP/Servlet/SQL Queries in web admin layer

Assisted in migration from IBM Portal 4.1 to 5.1 (code migration and server configuration)

Wrote and refined low level design for functionalities implemented

Advisory IT Specialist

IBM Global Service Vienna and China 2005.6 – 2006.4

International assignment for IBM Internal Tools Development

Participated in design and implementation of LADP migration to DB2

Developed, implemented EJB layer as database wrapper to separate direct database access

Developed, implemented web service layer generated by session beans from EJB layer

Wrote and refined low level design for functionalities and components implemented

Worked tightly with cross-functional team to succeed project delivery on schedule

Application Developer

London Hydro Canada, Information Service Division 2004. 2 – 2005. 4

Self-Service Web Window for customers. A Java/Web based application with struts as controller,

and Oracle 9i database as backend

Developed, implemented the functionality of main login pages, customer registrations,

pre-authorize payment plan, viewing previous billings and payment, budget billing plan with

complex data input/output and validation logic (utilizing Struts, JSP/Servlets, JDBC,

ADF/OC4J framework with JDeveloper)

Assisted developing consumption history chart which allows customers to view electricity

usage data in a graph or table format (utilizing JFreeChart)

Developed, enhanced, maintained SQL queries as need for self-service application

Assisted in developing visual appearance of web pages using HTML/CSS

Wrote and refined low level design for functionalities implemented

Research Assistant

University of Western Ontario, London, Ontario, Canada 2001. 9 – 2003.10

Developed a novel algorithm for multi-robot mapping and exploration

Participated in developing robots mapping simulator using Java/Cobra

Software Developer

Shanghai Avionics Technology Inc., (China) 1996. 10 – 2001. 2

Developed AEDK 51 Development Kit by converting an existing character-mode DOS

program into GUI using Visual C++ with MFC (AEDK 51: Assembly Emulator

Development Kit for Intel 8051/98 embedded assembly system)

Worked closely with the development team and clients side to provide technical support

EDUCATION

Master of Engineering Science (M.ENG), Electrical and Computer Engineering

University of Western Ontario, London, Ontario, Canada 2001. 9 – 2003. 10

Bachelor of Engineering Science (B.ENG), Electrical Engineering

Northwestern Polytechnical University, Xi’an, P.R China 1992. 9 – 1996. 9

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate