Profileimage by ZHONGXIAN ZHONGXIANWU SAP BW Consultant from BEIJING

ZHONGXIAN ZHONGXIANWU

available

Last update: 28.08.2013

SAP BW Consultant

Graduation: not provided
Hourly-/Daily rates: show
Languages: Chinese (Native or Bilingual) | German (Elementary) | English (Full Professional)

Skills

? BW (3.X, 7.0): Data Model, ETL, BEX (both 3.5 and 7.0) etc.
? Proficient in BW Performance optimization, Transformation, PSA, DSO, InfoCube, Query.
? ABAP: Proficient in ABAP programming, SQL programming, etc.
? BO: Skilled in BOE, Universe Designer, Dashboard, CMC, and WEBI.
? MSTR: Skilled in Schema (Attribute, Table and Hierarchy), Report Objects (Metrics, Filter, Prompts, Grid Report, and Document), and Web Interface.
? Familiar with SAP function modules: FI (AP, AR, and GL), CO (COPA, COOM), and Master Data.
? DB: Skilled in oracle10g, SQL Server 2008, MYSQL database management system, etc.
? OS: Skilled in Linux, familiar with common commands (putty, winscp3)

Project history

Project: 2013.05- 2013.08: Cost Controlling Projects (Global)
Development Tools: BI 7.3, AO 1.4
Responsibility:
? Data Model Design.
? Class Development
? Data Loading and Data check
? Performance Tuning
? Query Creating and UAT


Project 1: 2013.06 – 2013.07: BW Migration Project(Global)
Development Tools?BW 3.5, BI 7.0
Responsibility:
? Function Module migration.
? Program migration.
? Table structure, table type, data element creation.
? Infoobject creation.
? Data model design.

Project 2: 2013.05 – 2013.06 : SIS CC Project (Global)
Development Tools?Microstrategy(9.2.1), Oracle SQL Developer
Responsibility:
? Grid Report Development (Metrics, Formula, Filter, Prompt).
? Translation Attribute, Report, Filter and so on.
? Data quality check and data gap fix.
? UAT.
? Key user and End user Training

Project 3: 2012.06 – 2013.04: Old BW Migration Project (Global)
Development Tools?BW 3.5, BI 7.0, BEX 3.5
Responsibility:
? Requirement Analysis.
? Fix Gap Analysis.
? Solution Design and implementation for FICO (AP, AR, GL, and COOM) part enhancement.
? Solution Design for Data loading and process chain.
? Documentation of Technical Design, Test Notes.
? UAT.
? Post go-live support.


Project 1? 2012.04- 2012.05: BW 7.0 upgrade to BW 7.3?Global?
Development Tools?BW
Responsibility?
? The overall Project planning and resource allocation.
? Test case preparation.
? Function Testing in Sandbox.


Project 2? 2011.11- 2012.03: Sales-Force Report Project?Global?
Development Tools?Xcelsius, Universe Designer, Query as Web-service, SAP BW
Responsibility?
? Requirement collection and analysis with sales force team via conference call.
? Delivery Design Specification and confirm with BW Architect.
? Development and integration test.
? UAT with solution manager and business.
? Delivery handover documents and handover to IBM BW AM.
? Project goes live and post go-live support for two weeks.

Project 3?2011.05-2011.11: Mass Detail Project(Global)
Responsibility?
? Requirement collection and ananlysis.

? According requirments, raise BW solution?

? Delivery design document and finish development?integration test?

? UAT with solution manager, business

? Delivery handover?checklist, cutover documents and do handover to IBM BW AM team?

? Project go live and post go-live support for two weeks.

Project 4? 2011.02-2011.04: Business Object Upgrade Project(Global)
Development tools? BOE, Universe Designer, Web Intelligence Rich Client, CMC, Query as Web-service
Responsibility?
? The overall Project planning?time plan? resource arrangement;

? Test current Business Object version and solve all the current report issues.

? Download Business Object 3.6 patch and install, test

? Delivery test documents and provide installation files.

Project 5? 2010.07-2011.01: Purchase Order Status Follow up Project(Global)
Development Tool? SAP BW, SAP SRM,SAP APO
Responsibility:
? Reuquirments collaction and anylisis with Janpenes customer via conference call.

? Delivery design specification and estimation hours.

? Confirm the feasibiliy of solution with BW Archetector?

? Development and transport to Quanlity server and integration test.

? UAT with solution manager, business ?

? Delivery handover?checklist, cutover documents and do handover to IBM BW AM team?

? Project go live and post go-live support for two weeks.

Project 6?2010.01-2011.06: PSI Spend Project?Global?
Development Tool? SAP BW? Integration Center
Responsibility:
? Reuquirments collaction and anylisis with Janpenes customer via conference call.

? Delivery design specification and estimation hours.

? Confirm the feasibiliy of solution with BW Archetector?

? Development and transport to Quanlity server and integration test;

? UAT with solution manager, business;

? Delivery handover?checklist, cutover documents and do handover to IBM BW AM team?

? Project go live and post go-live support for two weeks.

Project 7?2009.11-2009.12: BW Report Performance Improvement Project
Development? BW, BIA
Responsibility:
? Performance Optimization Scope list and plan.

? Regarding key reports?migrate logic part to ETL.

? Add the frequently used report to BIA?and selective deleting data.

? Improve Process chain by modify DTP and DSO activation parameter.

? ABAP code optimization.

Project 8?2008.08-2009.08: Retail Sales Statistics Project
Responsibility?
? Join the discussion of establish the project strategy and project plan.
? Requirement collection and analysis.
? Report development confirmation and signature.
? Specific Design and Implementation (Cube, DSO, Transfer rule, DTP, Process Chain, Data-source, Source System etc).
? ETL, check data and handle the issues.
? User Training and System Testing.
? User manual and Online support report.

Project 9?2008.02.-2008.06: Retail Sales Statistics Project
Development Tool: BW3.5, Bex 3.5
Responsibility?.

? BW Process chain monitor and fix.
? Data check and documentation.
? ETL, load data and solve issue for user.
? Mainly work for maintaince.

Project 10?2007.10-2008.02?ICBA Core Banking System
Environment: Linux server, JDK1.5, oracle 10g
Development Tool: Toad, SQLPLUS, Putty, winscp3
Responsibility?
? For financial departments, market from the oracle database abstraction to relevant data, financial statements, and check the financial data (SQL PLSQL)

? Development and commissioning of the oracle store procedure, package, etc, to trigger SQL PLSQL

? Support customers because the system the several problems and needs (finance ,account)

? Timely to Malaysia corporation reaction customers' opinions and demands, and puts forward some effective Suggestions and solutions

Local Availability

Only available in these countries: China
Can start within one month and anywhere.
Profileimage by ZHONGXIAN ZHONGXIANWU SAP BW Consultant from BEIJING SAP BW Consultant
Register