Oliver Yinxing Pan

SAP BI-BPC Consultant - BPC certified

Summary:

** ***** ** ********** ** SAP implementation and ABAP development.

* ***** ** *** ** experience, ETL, interface and reporting, technical and functional from NW2004s to NW7.31.

4 Years of experience in SAP BPC, worked in implementation development and support.

BPC certified EPM 10.0, worked extensively on EPM BPC 10 NW BADI design as well, expertise in OO ABAP.

Expertise in BPC integration with BI(ECC/CRM/APO)/non-BI system and BI objects development.

Very strong knowledge in design data module in BI and BPC according to business requirement.

Very good experience in BI reporting solution - using Bex Analyzer, Bex Workbooks, Web Application Designer, Report Designer and BEx Broadcaster.

Very good experience in building BPC reports and input schedules, Data Manager package, Script Logic, Dimension Formulas, Business Rules.

Strong ability of communication with customers, very good at hosting and presenting in blueprint workshop

Strong knowledge and experience in integrated planning process, covering sales and operation plan, sales forecasting, master plan, production plan, distribution plan,cost plan and revenue plan.

Rich business knowledge and technical background on consolidation,

Global experience, multi-site, multi-lingual, multi-system migration/implementation with ASAP, hybrid approach (best practice).

Strong knowledge of SAP ECC,CRM and APO.

Professional Experience:

Sysco, Houston, TX

Project Description/Scope: EPM/BPC 10 NW Consolidation

Role: Senior BPC consultant

Duration: 01/2015 – 08/2015

Responsibilities/Deliverables:

Set up work status control process: configure work status, set up team access, write work status batch update BADI and build closing validation report

Configure league consolidation business rules, including carry forward, currency conversion and elimination. Set up process chain to automatize monthly close process

Develop logic script to achieve management consolidation process without group dimension

Develop logic script to generate CYNI in monthly closing process.

Develop logic script to copy reforecasting original data from actual data

Develop logic script to copy distribution service and head account data from weekly version to monthly version.

Check and update ownership data to reflect holding relation between entities.

Develop management report, such as weekly sales flash report, weekly operation result report, inventory shrink report, DSO trends report.

Develop and maintain report publish and distribution solution, using VBA and Microsoft Share point

Support all report related issue by face to face visit and remote screen sharing

Analyze the performance issue of the reporting model, calculate and analyze time, check error log, trace ABAP execution, analyze performance related parameter, work with BASIS team and SAP AGS to fix the timed out issue, make sure user can run report successfully even in system peak time

Analyze performance issue of closing time, redesign data update process, including backend update and front end update.

Prepare customer type master data for new acquisition.

Foster Farms, Livingston, CA

Project Description/Scope: TPM/BPS Integration, IP with Analysis Office

Role: Senior BI/BW IP consultant

Duration: 07/2014 – 11/2014

Responsibilities/Deliverables:

Design standard and common sales planning template, achieving flexible extension for new transaction type.

Design customized planning function type base on standard copy planning function type

Design actual planning function model to calculate the initiate sales forecasting. It read the sales history data based on input customer group and time frame, then calculate the planning data by the weight of each ship-to party.

Create and test ETL flow from ECC COPA to customized COPA in BW.

Design operational report and analytical report using Bex Query Designer and Bex Analyzer

Develop and maintain report distribution solution using BEx Broadcaster

Mengniu Dairy Group – Helinger, China

Project Description / Scope: EPM/BPC 10 NW Planning

Role: Senior BI/BPC consultant

Duration: 09/2013 – 06/2014

Responsibilities/Deliverables:

Take part in the integrated planning process design between llamasoft, BW IP, BPC and ECC, establish key business planning flow from sales forecasting, monthly sales plan, master plan, to production and purchasing plan. Integrate promotion budget plan with promotion activity plan and promotion execution.

Design and implementing base volume planning report which is based on history sales, actual shipment and promotion plan.

Design and develop UJ_CUSTOM_LOGIC BADI to project expense by product line and customer.

Design and implementing data integration for multi-platform planning integration across BPC, TPM/BPS and R/3 budgeting.

Create BI ETL process from data source replication/activation, ECC side customization in user exit and BI side transformation/routine/update rule.

Design and develop UJD_ROUTINE BADI to fulfil specific customer requirement, e.g. loop up BW InfoObject property to determine update on property like various allocation rate stored with cost center.

Design and rewrite UJR_WRITE_BACK BADI, distribute rate type singed data from hierarchy nodes to base members in Cartesian product of all base members.

Develop UJ_SQE_POST_PROCESS BADI for real-time calculation with Quarter Average measure

Backend customized process triggered by work status.

City of Nanaimo – Nanaimo, BC, Canada

Project Description / Scope: EPM/BPC 10 NW Planning

Role: Senior BPC consultant

Duration: 12/2012 –07/2013

Responsibilities/Deliverables:

Integrate payroll planning with standardized organization management and performance management

Design and develop UJ_CUSTOM_LOGIC BADI to allocate salary plan for each cost center and each employee with real-time calculation.

Design and develop UJD_ROUTINE BADI to revalidate to master data in BPC before loading transaction data to support delta transaction data loading.

Provide training of BPC administration:

1.Data management: master data management, transactional data loading monitor, backup and restore

2.Process management: work status setting, business process flow configuration,

3.Security management: collect and setup authorization.

4.Report template and input form template management

Support BPC upgrade from 7.5 to 10, upgrade UJR to UJO for write back and RSDRI query to class and method of BPC 10.

Mars-Wrigley, Chicago, IL

Project Description / Scope: EPM/BPC 10 NW Planning and Consolidation

Role: BI/BPC consultant

Duration: 04/2012 – 11/2012

Responsibilities/Deliverables:

Design and implement BW Objects and data flow, activate data source, load data to DSOs of different topics, then load it to monthly staging infoCube.

Provide prototype demo of BPC consolidation: carrying forward, reclassification, intercompany elimination, currency conversion, input form and report.

Implement system integrated consolidation process, automatic currency conversation, inter-company elimination and shorten the total group closing time.

Design and develop UJ_CUSTOM_LOGIC BADI to process the whole EXFX process in one Data Manager package, it include currency conversion, copy data to new category and other business logic .

Configure business rules for currency conversion, intercompany AR/AP elimination, regional consolidation, consolidation of investment.

Configure controls to validate balance of trial balance

Develop report via EPM drill through tool to access BW data targets

Create business rule and script logic to get retained earning account and CYNI calculation.

Design and develop UJ_CUSTOM_LOGIC BADI to process driver based planning.

BWI Group, Dayton, OH

Project Description / Scope: BPC project - BPC 7.5 NW for legal consolidation.

Role: BPC Consultant

Duration: 08/2011 – 03/2012

Responsibilities/Deliverables:

Create and maintain dimensions in different applications through the EPM Admin.

Configure Business Rules for intercompany activity.

Set up the Ownership Application with all the parameter settings.

Set up “Groups” Dimension including the “parent_group” property.

Populate the Dynamic Hierarchy Editor with ownership methods and percentages.

Upload and Download data through flat files and from BW.

Run Legal Consolidation, FX and ultimate ownership packages. Troubleshoot errors.

Design and develop UJJ_CALCULATED_AMOUNT BADI to derive Journal entry from hierarchy node of cost center to each base member cost center.

Support business on month-end close procedures (Financial Consolidation, Corp Planning) and Management Reporting.

Create butterfly report, rolling 12 report, and planning report using dynamic filters and properties with EPM Function.

Suning Appliance CO. Ltd, Nanjing, China

Project Description / Scope: BW project for sales operation,

Role: BW Consultant

Duration: 01/2011 – 06/2011

Responsibilities/Deliverables:

Identify BW report requirement by current report analyzing and business interview

Design info object by analyzing current master data, provide data cleaning suggestion.

Design data model to fulfill comprehensive analyzing requirement and balance the performance impact.

Implement reporting solutions - using Bex Analyzer, Bex Workbooks, Web Application Designer, Report Designer and mobile device

Suning Appliance CO. Lt, Nanjing, China

Project Description / Scope: CRM Sales Project,

Duration: 04/2010 – 12/2010

Role: CRM development Consultant

Bunge Agribusiness Singapore Pte. Ltd, Shanghai China and Singapore

Project Description / Scope: ERP Assessment Project,

Duration: 01/2010 – 03/2010

Role: GTM and SD Consultant.

Qing Dao CSR Locomotive Co. L, Qingdao, China

Project Description / Scope: ECC implementation Project,

Duration: 04/2009 – 12/2009

Role: SD Consultant.

Petro China Sales Subsidiary, Shenyang, China

Project Description / Scope: ECC enhancement and rollout,

Duration: 10/2008 – 03/2009

Role: SD and MM leader.

Mars Food China Co. Ltd, Beijing China

Project Description / Scope: ECC enhancement and rollout,

Duration: 03/2008 – 10/2008

Role: SD and MM Consultant for Supply chain outbound.

Mars Food Australia - Snack food Unit, Ballarat, VIC Australia.

Project Description / Scope: ECC enhancement and rollout,

Duration: 02/2007 – 12/2007

Role: SD and MM Consultant for Supply chain outbound.

Work on Manugistics and SAP integration project, design demanding process base on regional distribution center.

Design supply planning data interface, send on hand stock, in transit stock, sales order and purchase order to Manugistics

Samsung Electronics (China) investment Co. Ltd – Beijing China.

Project Description / Scope: ECC Support and development,

Duration: 07/2004 – 01/2006

Role: SD and MM Consultant, ABAP development Consultant.

Take part in Samsung integrated planning upgrade project, establish system data exchange between I2 and SAP and make rolling planning process for group level, sales subsidiary and manufacturing unit.

Work on I2 and SAP integration project, design SOP import and intercompany sales order trigger process for sales subsidiary.

Related Training:

BC425 Enhancements and Modifications, SAP China, 03/2005

BPC440 SAP Business Objects Planning and Consolidation - Consolidation, ERP Club, 11/2011

Education:

Master of Engineering, Beihang University, Beijing 2003

Bachelor of Engineering, Nanjing University of Aeronautics and Astronautics, Nanjing, China 2000.

acrom9@r.postjobfree.com

Glenview, IL

Tel: +1-224-***-****

Contact this candidate