Bo Zhang

Cell Phone: 647-***-****

acptau@r.postjobfree.com

Bo Zhang

Objective

Seek a challenging and exciting career opportunity as SAP BW/BOBJ/BODS/HANA consultant. (will need TN visa status to work in USA)

Professional Summary

Overall 14 years of professional experience as SAP BI/BO Consultant. Experience in implementations for different modules in Business objects Solutions XI 3.1/ BI 4.1 and in SAP Business warehouse 3.x/7.0/7.3, SAP data service 4.0/4.1 which involves Gap analysis, Blue Printing, Realization, Production support, Testing, Documentation, Requirement analysis, End user documentation, Data extraction, Data modeling, Data loading and Reporting. Expertise in Universe and Information Design Tool (IDT), Web Intelligence, Crystal Report, and Xcelsius Dashboard Design, design studio, explore/lumira for development

SAP BW/BI

? Extensively worked in designing and configuring back-end components including InfoObjects, Datasources, Transformations, Data Transfer Process (DTP), Hierarchies, Infosources, Update Rules, Transfer Rules, InfoSets, Infopackages, Infocubes, DSO's( Standard, Write Optimized, Direct update), Multiproviders and Process Chains.

? Proficient in ETL activities like Data Extraction, Loading (Full/Delta upload) and Data Modeling and proficient in data extraction from SAP R/3 SD, MM, PP, PM, FI-CO and COPA.

? Extensively used Open Hub Service to extract data out of BW and feed downstream systems to support Legacy System reporting needs. Creating and scheduling process chains for data loading process.

? Improved data load and query performance by using Aggregates, Compression, Partitioning, Indexes and optimizing Data packet size. Evaluated statistical performance using BW Statistics for optimization.

? Expertise in working with BEx in building Queries. Extensively created Calculated Key Figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Aggregations, RRI, Cell editors, and Customer Exit Variables for developing custom reports.

? Proficient in ETL activities like Data Extraction, Loading (Full/Delta upload) and Data modeling and proficient in data extraction using LO Cockpit and Generic Extractors.

? Strong ABAP4 programming, and strong problem solving/debugging skills

SAP BO

? Experience in Analysis, Design, Development and Implementation of Business Intelligence tools such as SAP BO XI R3.1 Universe Designer, Web Intelligence Reporting, Xcelsius dashboard and Crystal Report 2008.

? Specialize in migration to SAP BO XI R4.0 Universe Information Design Tool (IDT), Web Intelligence Reporting, SAP Dashboard 4.0 (Xcelsius) and Crystal Report 2011.

? Expertise in working with new tools in BO4.1 Design Studio 1.2 and Lumira.

? Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

? Extensive experience in building Universes, and retrieving data using Universes.

? Expert in creating complex and sophisticated reports using Web Intelligence, Crystal Reports that had multiple data providers, drilldown, slice and dice features using Business Objects.

? Experience in creating Dashboards using SAP Dashboard 4.0 using Live Office, QaaWS, Bex query and IDT for measuring KPI.

? Involvement in gathering business data requirements, analysis and understanding database to create robust semantic layers.

? Experience in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.

? Strong knowledge of Data Warehousing concepts, Dimensional Modeling, Operational Data Store (ODS) and Data Mart.

? Training and support end-user reporting needs using Business Objects.

SAP BODS

? Experienced in installing BODS XI 4.0 including Client/Server and configuring JobServer, Access Server, Profiler Server and setting up Local, Central & Profiler Repositories.

? Strong experience with SAP Business Objects Data services 4.0/4.1 (configuring job server, creating repositories, implementing batch jobs, designing work & data flows, extraction from various sources, applying transformations and data loading)

? Worked on complex transformation logics to efficiently handle SCD (type 1/2/3) and early/Late arriving facts

? Used various transformations like Map Operation, Table Comparison, Row-Generation, Query History Generation, Key Generation, Pivot and Query

? experienced with Data Quality of data profiling, parsing, cleansing, standardization and matching capabilities to make sure data is correct.

? Well versed in using Data Services Designer to ETL from multiple sources including Oracle / SQL server database, Flat Files, Excel workbooks, XML, SAP ECC and third-party tools through DataStore setup and custom transfer program.

? Well versed in using Performance Tuning techniques to improve Throughput of data

? Fluent in utilizing Data Integrator and Platform transforms, Variables and functions

? Fluent in SQL Coding using different software tools such as TOAD and SQL Server Management Studio 2008.

SAP HANA

? Good understanding of various components of SAP HANA.

? Having strong knowledge on SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views (both Graphical & SQL script based) & SAP HANA Data Provisioning using SAP LT Replication Server (SLT).

? Good exposure on Schemas, table definitions, Attributes, Measures &Hierarchies in HANA.

? Good Knowledge in SAP HANA security including User Management, Roles and Privileges.

? Strong knowledge on data flows & workflows using BODS.

Technical Skills Matrix

Expertise service years

SAP BO 4.x 4

SAP BO 3.1 4

SAP BW7.3/7.0 8

SAP BO Data Service 4.x 5

SAP HANA 1.0 1

SAP ABAP 6

SAP BW Modeling 3

SAP BW ETL 8

SAP BW BEX 5

SAP BO universe 4

SAP BO WEBI 5

SAP BO DASHBOARD 4

SAP BO Crystal Report 5

SAP BO Analysis 3

SAP BW Implementation 7

SAP BW Sustainment 5

SAP BO Report Development 8

Experience Summary

BMO Bank

Nov 2014 ? April 2015

SAP BI Consultant

Environment : SAP BW 7.3, HANA 1.0 SP 07, SAP BOBJ 4.1, Design Studio 1.1, DB2

? Involved implementation on SAP BW on HANA. Performed BW functionality, BEx functionality and BPS testing for post migration process of HANA.

? Data Provisioning and replicating data from MRP source system to HANA Database using SLT and Business Objects Data Services.

? Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.

? Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

? Migrating standard Infocubes/DSO to In memory optimized objects using migration Tool.

? Importing the BW Models into HANA using HANA Studio.

? Consuming the HANA Models in BW by creating the Transient Providers.

? Monitored daily BW process chain running, and resolved failure about special character/duplication/resource restriction/system failure etc.

? Supported LRM and BPC projects on SAP BW. Compiled operation guide for monthly run/month end run/month end rerun/special processing.

? Worked on change request for ?Historical deposit data? and ?split APMS into APMF and APMD? by creating new data-source/DSO/info-cube/SPO/multi-provider/process chains.

? Worked on multiple operation and business defects, analyzed by comparing data and debugging ABAP code of transformations, then fixed by changing SAP BW data flow components (data-source, DSO, SPO, multi-provider etc.), and also patching/modifying transformation and routines by ABAP

? Debugged ABAP code of transformation/routine to troubleshoot defects and performance issues of daily support.

? Developed dashboard ?LRM view? by using design studio.

CP_Rail

April 2014 ? Oct 2014

SAP BW/BI Consultant

Environment : SAP BW 7.3, SAP BOBJ4.0, SAP BO4.0, Oracle 11g

? Collected report requirement, and performed gap analysis, created function and technical Design for reports for HCM Personnel Time Management/ Payroll/Personnel Management/Personnel Administration/Organizational Management.

? Troubleshooting HCM/EHS WEBI reports by debugging ABAP code for data-source/transformation/start routine/end routine, and also in order to pinpoint issue, performed test within SAP BW among different info-providers and test between SAP BW and SAP HCM .

? Designed 15 sap BEX queries, such as ?Overtime Compensation?, ?Employee FTE Qualifying Hours from Payroll?, ?TOP 10 T&E CURRENT PAY PERIOD?, and ?TOP 10 T&E YEAR TO DATE?, ?Monthly Average Rate Review Report?, ?Gross/Net per pay period summarized?,?organization overtime report?, ?OT dashboard-overtime by process/by reason/by unit count? etc. by using CKF/RKF/RRI/virtual dimension/virtual KF/variables etc.

? Created dashboard/WEBI reports/Advanced analysis reports based on above 15 SAP BEX queries on SAP BO platform

? Created 3 universes to collect data from third part system for overtime compensation, and from CAT database to support WEBI reports of ?Overtime Compensation from third party?

? Resolved universe looping using context/alias.

? Dealt with new business requirement by Performing enhancement for HCM data-source (0CA_TS_IS_1/0HR_PA_0 /0HR_PA_1/0HR_PA_OS_1/ 0HR_PY_1_CE etc.), or by bring in new fields in the middle of BW data flow (DSO/Info-cube/Multi-provider etc.), or remodeling using constant/custom exit/attribute of characteristic.

? Performed transport for BW components (data-source, DSO, info-cube, BEX query etc.) from DEV to QA to PROD.

Hydro One

Jul 2013 ? Mar 2014

SAP BI/BODS Consultant

Environment : SAP BW 7.3, SAP BO4.0, BODS4.0, Oracle 11g Universe designer,

Web Intelligence Dashboard.

? Analyzed the report requirements on Data Modeling, Data extraction, Data Loading, Scheduling, Monitoring and Reporting.

? Creating Jobs, Work flows, data flows and scripts in Data service to pull data from the legacy systems and load the data into target database. Writing SQL Statements in BODS scripts to modify data. Created initial and delta loads.

? Responsible for creating mapping and transformation specifications based on the business requirements from various business teams and implemented in Data Integrator jobs.

? Created the Users, groups and assigned the security in The Central Management console. Worked on the Universe Design Row- level Security in the Business objects.

? Involved in knowledge transition to other Developers. Presented a Demo of using all the Platform Transforms, complex functions, look up functions.

? Involved into Asset Analysis project for SAP BW. Responsible to perform peer review (design reviews, spec reviews, code reviews, test plan reviews ), collected and transported designed objects to QA/PROD, perform initial loading and design process chain for delta loading, resolve loading issues, and improve loading performance.

? Worked with various standard as well as custom BI/BW objects for FI, CO, SD, HR and MM of ECC.

? Worked on customization and enhanced the extract structure to support business needs

? Improved data load and query performance by doing compression, aggregates, and partitioning etc.

? Designed and developed various Data targets and Info-providers like DSO (ODS), Info-cubes, Info-objects, Multi-providers and Info-sets.

? Developed various transformations/start routine/end routine to using Formula Builder and ABAP programing to suit the business requirements

? Created DTPs, Info-packages for Full, Initial, Delta and Full repair loads for both Master data and Transaction data

? Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, initial fills, roll up, attribute change run and DB stats creation etc.,

? Developed BEX Queries to access data from various BW Info-providers like DSO, Info-cubes, Info-objects, Multi-providers and Info-sets.

? Involved into Smart meter project, and developed WEBI reports ?SMI Orders Report?, ?Missing Reads Tickets?, ?Global Ticket Summary ? ?Meter Install? etc.

? Created 5 universes to feed data from third party system to combine with BEX queries to serve data for above WEBI reports.

? Developed a dashboard to present data loading process and status, in which developed universe to fetch data from SAP database tables.

? Daily involved in production data loading and monitoring. 24/7 production BI/BODS on call support.

? Performed application product test / integration product test by writing Test Plan and Test Script, and uploaded into HPQC.

Healthcare Insurance Reciprocal of Canada

Mar 2010 ? June 2013

SAP BI/BODS Consultant

Environment: SAP BO Data service 4.0, BW 7.3, SAP BOBJ 4.0, Universe designer,

Web Intelligence, Crystal report, Dashboard, SAP ECC FI/CO, Oracle

10g & 11g.

? Responsible for analyzing the Report requirements and gaps, design Data Modeling, Data extraction, Data Loading, Scheduling, Monitoring and Reporting processes.

? Configured repository (local repository and central repository )and Job server using Data Service tool.

? Set up datastores to connect the source system: database, flat file and excel file. Configured Multi-configuration datastore for data migration.

? Created combination of transforms to ETL data from multi-SQL Server, BW, flat file& Excel to Oracle.

? Created Fact & Dimension tables and written scripts and using functions for transforms.

? Performed source data assessment using Data Quality & data profiler transforms and validate data by validation transform.

? Used interactive debugger, setting up of error handling and audit to ensure correct data transformation.

? Scheduled and operated jobs in both BODS administrator and BI/BW side (used Infopackage), and used Auto documentation for dev-files.

? Developed various documents like Data flow, Data mapping, Data dictionary, Functional and Technical specs to support the design

? Developed 6 crystal reports for finance and claims. Developed 3 complex WEBI reports for risk management. Developed 2 dashboards for clients and claims.

? Developed complex universe by using @-prompt, and resolved loops by alias and context, and resolved chasm trap and fan trap by using query option and context.

? Developed universe from multiple data source, and developed universe using derived tables.

? Extracted and enhanced BC data source of 3FI_GL_0L_TT & 3FI_GL_N1_TT, and 0FI_AR_4& 0FI_AR_6.

? Designed and developed data marts for finance/claim/risk management /brokerage in sap BW, and developed the ETL process to extract data from OASIS using SAP BODS, and developed ETL data flow in sap BW to extract data from SAP FICO and SAP BODS into corresponding data targets.

? Created various BW backend objects which includes real time cubes, Basic cubes, DSOs, Data-sources, Info-sources, Transformations, DTPs, Open hub spokes and Process chains

? Developed complex ABAP code in the end routines and start routines of the Transformation

? Developed DTPs and Info-packages and created various routines with ABAP for the selections.

? Created complex BEX queries by Calculated Key figures, Restricted Key Figures, structures, variables. Implemented conditions and restrictions in the queries based on the business requirements. Used Hierarchies in the reporting to provide drill down features. Designed and developed reports with filters and free characteristics. Designed and provided RRI reporting.

? Created various Customer exit variables to support the queries. Used ABAP in the enhancements to fill these variables.

? Involved in Unit and QA testing and performed the tuning to improve the query as well as the loading performance.

? Created various transports, collected the required objects and migrated to the target systems for BODS and BW objects.

? Developed, conducted and presented various training to the users as well as the project members

? Daily involved in production support for data loading and monitoring, and resolved report issues and data flow issues by ticket assigned.

Microsoft Corporation.

May 2009 ? Feb 2010

SAP BW/BOBJ Consultant

Environment : SAP BW 7.3, BI7.0, ECC 6.0, BOXI3.1, SQL Server 2008

? Created multidimensional Data Model using Extended Star Schema, designed and developed multi-provider, Info cubes Standard, ODS/DSO, Info Sources and Data Sources.

? Developed Technical Design Documents including GAP Analysis.

? Configured and activated, customized Data-source/Business contents

? ABAP coding Start/End Routines, transformation routine

? Uploaded Master data, Transaction data and Hierarchical data into the SAP BW .

? Worked on Change requests, and Problem reports as part of minor releases and major releases which range from simple Query changes to data source enhancement

? Employed the enhanced functionality of the Process Chains for automating processes.

? Extensively using ABAP to compile transformation and data-source enhancement.

? Provided support for data load, validation, performance monitoring and tuning using Aggregates, Rollups, Partition and Compression.

? Created queries with Variables, Filters, conditions, and Restricted & Calculated Key figures by SAP BEX query designer.

? Created Universes for various functional areas of high level reports group. Customized LOVs in Universes for quicker performance of reports.

? Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.

? Checked and tested data by consolidate DS/RSA3/SQL etc.

? Support for monitoring daily processing of SAP BW system by loading monitor and process chain monitor. And doing enhancement by quarterly requirement.

? Created various WEBI analytical reports like Market Share, Trending, Rank reports from multiple data providers.

MPR Consulting, North York, ON, Canada

January 2005 ? May 2009

SAP BW/BI Consultant

Project

April 2008 ? Mar 2009

Client: Pitney Bowes

SAP BW/BOBJ Consultant

Environment : SAP BI7.0, ECC 6.0, BOXI3.1, Oracle10g

Responsibilities:

? Customized Sales Overview (0SD_C03), Purchasing Data (0PUR_C01) etc. as per the client's requirement and enhanced the data-sources and loaded into the data targets.

? Created Process chains to automate the data loading.

? Configured and extracted Inventory management data from LO Cockpit extractors by making use of the SAP defined data-sources like 2LIS_03_BF, 2LIS_03_BX, 2LIS_03_UM.

? Development of Transformations, DTP, Data Sources (flat file source system), Update Rules and Transfer rules for BI data flow and 3.x data flow.

? Creation and maintenance of BI objects (Info-Cubes, DSO objects, Info-set, Multi Providers).

? Involved in documentation for the mapping, technical specifications, data validations and Test cases

? Developed and modified BEX QUERIES using Calculated and Restricted Key Figures, Variables, Structures and Conditions for complex reporting and worked on query performance optimization

? Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.

? Involved in migration and deployment of the universes and reports across multiple domains

? Used Business Objects Developer Suite (CMC, Designer, and Info-View) to perform various tasks specific to every component.

? Creating Crystal reports and WEBI reports.

? Conducted unit/integration testing and performance tuning.

? Involved in end user training and knowledge transfer.

April, 2007 ? April, 2008

Client: Embry Group

SAP BW/BOBJ Consultant

Environment : SAP BI7.0, ECC 6.0, BOXI3.0, Oracle10g

Responsibilities:

? Analyzed data and BW capabilities to build relevant financial, operational, and strategic reporting views

? Responsible for business data modeling, data mapping, and gap analysis

? Enhanced the business content Info-cubes for product costing and cost center budgeting

? Configured Generic Data Sources, and activated and enhanced data sources and extracted data from R/3 and flat file.

? Created and maintained customer InfoObjects, multiprovider, Transfer Structures, transformation, Info-Sources, Info-Packaged etc.

? Developed Queries using BEX Analyzer on the above cubes, created and maintained Variables, Calculated and Restricted Key Figures for BEX Query as required.

? Designing new Universes and Modifying the existing Universes, using features like Check Integrity, Aliases, Loops, Contexts, Joins and finally creating the Objects (Dimensions, Measures and Details), which are grouped into Classes.

? Extracted data from ECC and oracle 9i(UD Connect).

? Worked extensively on WEBI and Crystal reports.

? Created live office Spread sheets according to requirements and used these spread sheets to create interactive dashboards and power point presentations using Xcelsius 2008.

? Administered the user?s roles and privileges in Central Management Console.

? Scheduling the documents and distributing them using CMC and monitoring them.

? Responsible to work on the Production Support issues related to Crystal Reports.

? Used import wizard to transport the objects around the layers

July, 2006 ? March, 2007

Client: Sunrise Communications

SAP BW/BI Consultant

Environment: SAP BI7.0, ECC 6.0, BOXI3.0, Oracle10g

Responsibilities:

? Extensively involved in project preparation, business blue print, realization, final preparation and go live and support phases.

? Analyzed reporting requirements and translated the requirements into multidimensional data module.

? Extensively involved in setting up procedures for Generic Extractions and customizing LO Cockpit.

? Data extraction from FI-CO and HR

? Extensively using ABAP to compile transformation and data-source enhancement.

? Installed Business Content, designed and created customer service cube.

? Created and maintained process chains for master and transaction data loading.

? Created BEX Web reports for required GL accounts, purchasing and sales order queries by SAP BEX web application designer and query designer. and set scheduled broadcast to send report to portal

? Generated Data Mart for other BW systems and external ERP systems.

? Transported the objects from Dev Server to QA Server and production server.

? Knowledge transfer to the client support team.

? Involved in go ? live and production support.

? Handled creation of queries in Business Explorer (BEX) with calculated key figures, navigational attributes, variable and restricted key figures.

? Customized the standard reports as per client?s requirements.

? Involved in the scheduling of reports using information broadcast.

? Developed workbooks and used RRI Jump Queries to drill down to other queries and R/3 Transactions.

? Created Web enabled reports using Web Application Designer (WAD).

? Worked on performance tuning of queries by creating aggregates, compression, indexing and OLAP cache.

March, 2005 ? June, 2006

Client: Kinhom Group

SAP BW/BI Consultant.

Environment: SAP BW3.5, R/3 4.6C, SQL server

Responsibilities:

? Developed and scheduled Business Content data extraction from SAP R/3

? Created generic transactional data source from R/3 customized tables.

? Extracted data from flat files and external source systems.

? Created and maintained InfoObjects, Transfer Structures, InfoSources, Communication Structures, InfoPackages and scheduled the data loading.

? ABAP coding start routine, Transfer Rules, Update Rules.

? Modeled ODS from corresponding InfoSources, determined key fields, data fields and navigational attributes.

? Involved in creating and maintained InfoCubes, aggregated and PSA.

? Extensively using ABAP to compile transformation and datasource enhancement.

? Created and maintained Process Chains for Master data and transaction data loading.

? Developed WEBI report for Plant Maintenance by SAP BEX query designer and web application designer, set scheduled broadcast to send report to portal

? Performed analysis, testing and tuning.

? Created Data Mart to distributed summarized data from central BW system to sub BW system.

? Involved in unit and integration test.

? Created transport list and transported objects from Dev Server to QA Server and production server.

? Supported for fixing daily running issue, and monitoring loading performance to iteratively optimize the SAP BW design strategy and development structure.

Nokia (China) Telecommunication Ltd

2000 ? 2005

SAP BW/BI Consultant

Environment: SAP BW3.5, R/3 4.6C, Oracle9i

Responsibilities:

? Analyzed data and BW capabilities to build relevant financial, operational, and strategic reporting views

? Responsible for business data modeling, data mapping, and gap analysis, BW implementation.

? Enhanced the business content infocubes for product costing and cost center budgeting Used the calculated key figures in the purchase report, and restricted key figures to make the reports user friendly. Created query jump targets to maintain Report-to-Report interfaces (RRI)

? Performed optimization for data loading and data reporting.

? Monitored data flow by DTP monitor or process chain monitor, and fixed issue for data loading and data inconsistency.

? Prepared documents for technical specification/mapping rule/test design/test strategy/test case design etc.

? Worked on Enhancement of Standard Data Sources.

? Performed unit testing/functional testing/integration testing.

? Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports for sales, marketing reports for marketing group users etc.

? Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.

? Generated various WEBI reports of sale distribution on Daily, Weekly, Monthly and Yearly basis.

? Created and modified the Crystal Reports for various financial groups using the Universe as a main data provider.

? Created WEBI/Crystal reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs. Some of these reports are extremely complicated and retrieve data from multiple data sources

? Created dashboard to present summary sales data by district and product using universe as main data provider.

? Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.

? Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.

? Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.

? Knowledge transfer to people in the downstream.

Training

? SAP Certified Application Associate ? Business Intelligence with SAP NetWeaver 7.0

? SAP Certified Application Professional - Business Intelligence with SAP BW 7.3 & SAP BI 4.0

? SAP BW 7.3 on SAP HANA 1.0

? HA100 SAP-HANA Introduction

? HA 300 SAP-HANA Implementation and Modeling

Education

Master of Science University of Electrical and Electronic Technology

Contact this candidate