ABAP OO/Fiori/S4/BPC/BW Developer, ABAP Technical SME, ABAP on HANA

Kohler, WI
Project Description/Scope: BW data source enhancement on ECC
Role: ABAP Developer Duration:09/2018-09/2019
* HANA version 1809.
* Create new data element, extend, append data structure on product costing data source
0CO_PC_PCP_30 and 0CO_PC_PCP_20, adding custom logic to extract mixed costing and realign parent
pricing information/BOM information to each base member, fixing issue that SAP global support was
not able to resolve for three years.
* Develop fiori application based on CDS view table function, controlled by AMDP, this way the
logic is pushed down to
* Extensive use of ADT( ABAP Development Tool) in Eclipse/Hana studio with ABAP testing
case/class/test cockpit

TreeHouse Foods Inc., Oak Brook, IL
Project Description/Scope: central Finance integration with BPC, IBP enhancement
Role: ABAP Technical SME Duration:09/2018-01/2019
* HANA version 1809
* Create multi-level CDS view and expose to OData for Fiori consumption. Develop dynamic SQL
statement for cross-client execution. Dynamic data structure definition on the fly with
RTTS(runtime type service)
* Extensive use of ADT( ABAP Development Tool) in Eclipse/Hana studio with ABAP testing
case/class/test cockpit
* Provide Virtual data provisioning, via HANA VDM from cFIN(central finance ACDOCA,ACDOCP table) to
BPC classic model via enhanced ABAP CDS views., exposed to odata to be consumed. Save memory by
reduce huge data volume at interim data staging area.
* Provide generic ABAP solution for Fiori development in backend integrating to IBP.
* Provide virtual master data access for IBP to save space, and agile, realtime master data update
for IBP planning process in S&OP
* Provide virtual data provisioning for transaction data for material based unit of measure
conversion function on realtime.

Moen, North Olmstad, OH
Project Description/Scope: BPC embeded BW-IP on HANA
Role: ABAP Technical SME Duration:02/2018-09/2018
Responsibilities/Deliverables:
* HANA version 1709
* Develop generic RFC call on FM to bypass security check for deep query on info providers
* Create customized planning function type in ABAP OO as wrapper to execute any specific customized
ABAP class on various functions
* Extensive use of ADT( ABAP Development Tool) in Eclipse/Hana studio with ABAP testing
case/class/test cockpit
* Design and implement RFC call to ECC system with dynamic parameters on generic data
structure(converted by JSON converter).
* Create generic OData service for multiple master data comparison program in one Bex query which
consume one OData service MPC, however DPC classes are derived from one super class.
* Design and implement dynamic ABAP CDS view through AMDP insert to extract COPA data. The
transformation is pushed down to CDS view on HANA to accomplish.
* Design and implement transpose function on multi-key figure model to single key figure model in
nested CDS views. This improve performance by 80%+.
* Design virtual provider, transformation to get realtime copa data, cost center accounting data,
profitcenter accounting data, internal order data into embeded BPC
* Run currency translation on the fly with complex fx rate determination.
* Run QTD YTD calculation on the fly.
* Run P&L statement line item conversion on the fly
* Design BPC modeling in composite provider with planned data physical in ADSO, actual data being
virtual.
* Design and implement bw-ip planning function for allocation, characteristic relationship
function.
* All development work are done in object-oriented ABAP and are parameterized, generic, reusable in
BW transformation or anywhere in BW-IP.

Mead Johnson Nutrition, Evansville, IN
Project Description/Scope: BPC embedded integration with BW on HANA
Role: ABAP Developer Duration: 09/2017 - 12/2017
Responsibilities/Deliverables:
* Design and implement transformation from BPC virtual infoprovider to ADSO in sleek
object-oriented ABAP to improve performance. Reaching total runtime of less than 7 min for 30M
records in query and transformation through complex mapping rules. This is for MJN's integration
with parent company RB.
* Fetch wbs distribution rate from flat file on ECC server to BPC model in realtime with
transformation, triggered by data manager package
* Run data manager package with realtime mapping rules/distribution from calculation on brand
revenue percentage.

Adient, Polymouth, MI
Project Description/Scope: BW-IP/BPC embeded for PPM
Role: ABAP developer for BW-IP Duration: 01/2017 - 09/2017
Responsibilities/Deliverables:
* HANA version 1511
* Scrum development approach using Trello to track progress, features and deliverables.
* In BW-IP, implement factory method to invoke query with dynamic SQL in BW-IP calculation formula
related to view, push down mapping to CDS view
* Extensive use of ADT( ABAP Development Tool) in Eclipse/Hana studio with ABAP testing
case/class/test cockpit
* Create multiple OData service from multiple systems, through one single gateway hub to be
consumed by Fiori, including transaction data from PPM, PS, and analytics data from BW-IP
* Design and implement RFC call with generic RFC program interface to execute remote functions,
pass data in JSON format, pass data definition(metadata) in JSON format, build bi-directional
communication between FIORI and PPM, PPM and BW-IP, FIORI and BW-IP
* Performance improvement by developing generic JSON based data transfer, and generic virtual
infoprovider interface.
* Develop customized planning function type for shifting, clear, specific version copy, rolling
forecast, time/labor calculation
* Develop customized characteristic relationship function with ABAP class, with restriction on
foreign PPM tables, and PPM item id characteristic attributes. Improve the performance with
shared memory.

Infinera, Sunnyvale, CA
Project Description/Scope: BW-IP for CPM
Role: ABAP consultant for BPC/BW-IP Duration: 02/2016-12/2016
Responsibilities/Deliverables:
* Design and implement analysis workbooks with BW-IP planning functions to support CPM planning
* Performance improvement by running CPM report on customized virtual provider for multiple project
with realtime data acquisition from PS module and FICO module.
* Design and implement virtual info provider to plan on multiple projects in one workbook
* Design and implement planning functions to support multi-project revenue/expense calculation,
budget shifting.
* Design, change and implement virtual info provider to support realtime CPM reporting for
multi-projects with high performance.

Florida Power & Lights, Juno Beach, FL
Project Description/Scope: BPC10.1 HANA Planning/Integration with BW-IP
Role: ABAP development consultant on BPC/BW Duration: 08/2015 - 02/2016
Responsibilities/Deliverables:
* Design Driver-based planning on ABAP BADI and on script logic. Demonstrate performance via ABAP
BADI over script logic approach by 1000%. Takes 27 seconds to fetch reference data at realtime
and run calculation, mapping and save data.
* Create SQL script to create CDS view in HANA at runtime and push logic into SQL script. Design to
have ABAP drive the creation at runtime.
* Change original design of script logic based design to realtime, integrated generic ABAP BADI
covering write-back, custom logic and SQE post BADI. This streamline the data flow across
different systems in realtime data integration.

Mead Johnson Nutrition, Evansville, IN
Project Description/Scope: BPC 7.5 to BPC10.1 HANA upgrade
Role: ABAP developer for BPC Duration: 06/2015 - 08/2015
Responsibilities/Deliverables:
* Dynamically get result from CRM/ECC to update BPC functions in realtime. This class can be run
from script logic or from report refresh as well, a generic class embedded in multiple
systems/modules.
* ABAP OO development to have one generic class for multiple interfacing scenarios with difference
data structures on the fly.

Lam Research, Fremont, CA
Project Description/Scope: BW performance tuning on HANA
Role: ABAP BPC/BW-IP/HANA consultant Duration: 04/2015 - 06/2015
Responsibilities/Deliverables:
* Analyze, debug, and trace current BW transformation routines, replace it with generic OO class to
simplify the code, improve runtime by 62% to 1600% for 7 programs in one week.
* Create new API to invoke BPC classes from Integrated Planning customized function types.
* Rewrite query to BPC object in a better OO way.
* Consolidate 35+ BPC BADIs into 5-7 generically parameterized classes, simplifying the logic
scripts and BADI classes.

Kenna Metal, PA
Project Description/Scope: ECC/E commerce performance tuning
Role: ABAP consultant Duration: 03/2015 - 03/2015
Responsibilities/Deliverables:
* Analyze, debug current Json xml -> ABAP program, trace performance.
* Rewrite it in XSLT program then evolved into dynamic/generic two-way Json - ABAP conversion
program with known ABAP structure in NW7.4 environment, efficiency beyond client expectation.

Tyson Food, AL
Project Description/Scope: ECC performance tuning
Role: ABAP consultant Duration: 02/2015 - 02/2015
Responsibilities/Deliverables:
* Analyze, debug ABAP interface program with RFID, develop solution to fix the error about missing
data, improve performance by 60% calling parallel processing dynamically.

Bank of Montreal(BMO) Harris Bank, Milwaukee, WI
Project Description/Scope: BPC BADI development, performance
Role: ABAP BPC development consultant Duration: 06/2014 - 01/2015
Responsibilities/Deliverables:
* In instrumental planning and forecasting application, develop
* Implement SQE BADI on non-aggregation effect in EPM reporting
* Performance improvement by 80% integrating with SAP bank solution on complex calculation.
* Create scenario planning with multiple time-dependent master data vs. multiple period
transaction data matrix in BPC HANA environment.
* Driver-based planning/seeding, lookup drivers and produce rolling forward planning results.
* Disaggregate rate at hierarchy nodes after SQE aggregation result
* Handling master data attribute read in a more efficient way to save 30% of time in SQE BADI
and write-back badi, regarding a dimension with 45K members and 9 hierarchies.
* Advise and improve the planning calculation engine developed by SAP CDP team(custom
development program).

Foster Farms, Livingston, CA
Project Description/Scope: BW-IP with Analysis Office, TPM/BPS Integration
Role: ABAP consultant Duration: 12/2014 - 02/2014
Responsibilities/Deliverables:
* Integration of TPM with BPS so that TPM planning will trigger BPS planning profile and planning
function, to lookup historical data to identify the driver for planning for sales forecast. This
involves RFC call and ABAP OO in backend.
* Create Input ready query using Analysis Office and it triggers BW-IP customized planning function
which is a copy with customized COPA data lookup for driver for distribution to complete top-down
allocation on estimated shipment and shipment adjustment.

Mead Johnson Nutrition, Evansville, IN
Project Description/Scope: BPC 7.5 performance enhancement
Role: ABAP BPC development consultant Duration: 03/2014 - 06/2014
Responsibilities/Deliverables:
* Create generic script logic to replace dozens of hard coded script logic, in UJ_CUSTOM_LOGIC BADI
to dynamically replace it with parameters and execute in runlogic in parallel processing
* Optimize the ABAP BADI code, performance improved by 70%. Total runtime reduced from 3.5 hrs down
to 0.6 hrs.
* Bring in delta data load in 7.5 environment to reduce data volume.
* Create BPC custom logic badi to do allocation based on allocation percentage imported from ECC,
and user input percentage from input form, and ratio from Cost of Sales or COGS.

QVC, West Chester, PA
Project Description/Scope: BPC performance tuning
Role: ABAP BPC development consultant Duration: 03/2014 - 03/2014
Responsibilities/Deliverables:
* ABAP Debug and BPC performance tuning, identify default logic performance, and SQE engine
performance

Limited Brands, Columbus, OH
Project Description/Scope: Web Dynpro ABAP
Role: ABAP consultant Duration: 03/2014 - 03/2014
Responsibilities/Deliverables:
* Debug Web Dynpro ABAP for PLM solutions, especially the search function and work on assistant
class to attach to the standard component controller.
* Test with ABAP testing class taking testing data from txt file.

Morgan Stanley, New York, NY
Project Description/Scope: BPC consolidation
Role: BPC development consultant Duration: 11/2013 - 1/2014
Responsibilities/Deliverables:
* Design matrix consolidation process based on entity and segment. (Management Consolidation)
* Implement Financial Consolidation for multi-ledger by complex ownership company codes and
Management consolidation by segment/profit center
* Develop matrix consolidation for financial consolidation(by entity) and for management
consolidation(by segment) using ABAP BADI

PETSMART. - AZ
Project Description/Scope: BPC 7.5 Planning,
Role: ABAP BPC Consultant Duration: 11/2013 - 11/2013
Responsibilities/Deliverables:
* HR headcount planning and integrated with expense planning
* Implement complex BADI solution using ABAP OO for driver-based planning like UJ_CUSTOM_LOGIC
and in UJO_WRITEBACK for HR planning.

Baker & McKenzie, Chicago, IL
Project Description/Scope: ECC Implementation
Role: Data conversion and ABAP Duration: 11/2013 - 11/2013
Responsibilities/Deliverables:
* Create generic interface for data processing/data validation via WebDynpro ABAP OO.
* Create delta mechanism to control data extraction/loading from BOBJ Data services to BW and Data
services to ECC.
* Transaction data load using LSMW, BDC.
* Extract contact information and ETL process to cleanse data using data services, create ALE/IDocs
structure

Jones New York. - PA
Project Description/Scope: BPC 7.5 Planning,
Role: ABAP BPC Consultant Duration: 06/2013 - 10/2013
Responsibilities/Deliverables:
* Cost center planning and distribution: design and implement.
* Develop data extraction, transformation from ECC to BW and to BPC, including master data and
transaction data.
* Develop data validation logic in ETL process.
* Extensively using BAPI via RFC call to get data from ECC to BW/BPC.

FBL Financials Inc. - West Des Moines, IA
Project Description/Scope: BPC 10 NW upgrade,
Role: ABAP BPC Consultant Duration: 06/2013 - 06/2013
Responsibilities/Deliverables:
* Implement financial consolidation on NW platform.
* Implement complex BADI solution for a variety of allocation requirement, including
driver-based allocation and disaggregation
* Convert MS7.5 script into NW10.0 script, some of which are converted into BADIs.
* Performance tuning using parallel processing and dynamically determine package size in data
processing.
* Seamlessly integrate with BW EDW solution using process chain, and ABAP.
* Debug and fix issues with complex dimension logic

JP Morgan Chase - Chicago, IL
Project Description/Scope: BPC 10 NW, Consolidation
Role: ABAP BPC DEVELOPER Duration: 10/2012 - 06/2013
Responsibilities/Deliverables:
* Manage and support consolidation for over 2000 entities in multi-currency, multi country
environment.
* Optimize consolidation and incremental consolidation, reducing total operation from 10+ hrs
down to 3-4hrs, commit to target 8 day closing.
* ABAP development - BADI implementation including master data BADI UJD_ROUTINE, retraction in
UJD_RETRACT, script logic in BADI UJ_CUSTOM_LOGIC, and journal entry BADI UJJ

Responsibilities/Deliverables:
* Implemented EPM10 NW.
* Design and implement data extraction, transformation, loading into BPC from multiple versions
of ECC systems and BW system.
* Lead in technical integration solution for Consolidation and Financial planning.

Proctor & Gamble - Cincinnati, OH
Project Description / Scope: BW query performance tuning
Role: ABAP BW consultant Duration: 05/2012 - 06/2012
Responsibilities/Deliverables:

* Analyze, trace, debug and tune up BW bex query performance with large volume data.

Mars-Wrigley - Chicago, IL
Project Description / Scope: BW-IP/TPM integration, EPM/BPC 10 NW Planning
Role: BPC ABAP consultant Duration: 01/2012 - 04/2012
Responsibilities/Deliverables:
* Design and call BW-IP planning sequence from BPC interface using ABAP OO
* Replace standard planning cube in BW-IP with virtual info provider to improve the performance
of actual data extraction.
* Design and implement UJR write back BADI to accommodate business needs in planning.
* Design and implementing data integration for multi-platform planning integration across BPC,
TPM/BPS and R/3 budgeting.
* Backend integration between BPC10 and BW7.3, (real-time master data integration, real-time
transaction recalculation on planning transaction data)
* Performance tuning for BPC-CRM, BPC, and BPC-BW.

BWI Group - Dayton, OH
Project Description / Scope: ECC6.0 auto industry solution Global Implementation - ECC6.0 auto
industry solution implementation in 7 countries with 4 languages, 9 locations covering 3.1i,
non-SAP, 4.6C migration, SD/MM/PP/FI/CO/EDI/3rd party interface.
Role: SAP Technical Architect Duration: 02/2010 - 04/2011
Responsibilities/Deliverables:
* Review/manage all technical design spec documents
* Lead WRICEF development and plan.
* Lead data migration team

Haier Corporation
Project Description / Scope: SEM/BPS, BI-IP Project
Role: SAP Technical Architect Duration: 02/2008 - 09/2008
Accomplishments / Results:

* BW development in COPA data source, transformation, reporting and BW-IP function using ABAP OO.

Lenovo
Project Description / Scope: ECC global implementation - Managed thirteen project teams in MTP(Move
To Production) and PPS (Post Production Support) in a Global Release covering ECC in Canada, CRM
global (three continents, 26 countries), i2 in two countries and PLM in one country.
Role: PM / SAP Technical Architect Duration: 09/2007 - 01/2008
Responsibilities/Deliverables:
* Responsible for project management of R/3 rollout in Canada territory.
* Lead PLM project integration with ECC and PDM, focusing on ECM in BOM change/distribution and
material change/distribution

TTX Corporation - Chicago, IL
Project Description / Scope: Upgrade from R/3 4.0 to R/3 4.7.
Role: PM / SAP Technical Architect Duration: 06/2007 - 09/2007
Responsibilities/Deliverables:
* Lead onsite team (8) and offshore team (6) to run ECC upgrade project. Collision program analysis
and fix for hundreds of ABAP programs.

Kimberly Clark through Inforte Inc. - Chicago, IL
Project Description / Scope: BW-IP Project - Used BW-IP to integrate data from different system to
create predictive model which provide quantitative support for company's R&D projects evaluation.
Role: BI Technical Architect Duration: 12/2005 - 06/2007
Responsibilities/Deliverables:
* Work with Chief Statistician to create predictive model(Logistic regression, parameters importing
from SAS) in BW-IP, to forecast sales and financial analytics for new product development.
* ABAP development in BW-IP

Capstone Turbine Corp. - Los Angeles, CA
Project Description / Scope: R/3 support & Project.
Role: SAP Functional Lead Duration: 11/2003 - 11/2005
Responsibilities/Deliverables:
* Responsible for production support in R/3 4.7, ECC5.0, environment in
assembly-to-order/make-to-order production process.
* Lead Projects in PP,PLM, ECM, SD Variant Configuration, PDM,
* ABAP development in ECC

THQ - Los Angeles, CA
Project Description / Scope: R/3 & BI.
Role: BI Developer / Lead in SD/MM/EDI Duration: 05/2002 - 11/2003
Responsibilities/Deliverables:
* Complete BW implementation with end-to-end solution on finance, and logistics cockpit.
* Lead ECC SD/MM configuration, post-go-live support.
* Lead ECC SD/ALE/EDI work while company expanding business into Europe and have new acquisition in
MN.

ITT Cannon - Los Angeles, CA
Project Description / Scope: R/3 Production Support.
Role: SAP Functional Lead Duration: 05/2000 - 02/2002
Responsibilities/Deliverables:
* Work on MM/PP modules
* Support ALE/EDI/IDoc process between SAP R/3 and third party WM software, Time management/labor
confirmation.
* Workflow Design/Maintenance.

Capstone Turbine Corp. - Los Angeles, CA
Project Description / Scope: R/3 support & Project.
Role: SAP Functional Lead Duration: 09/1998 - 05/2000
Responsibilities/Deliverables:
* Work on FICO/SD/MM as functional support business analyst
* Work on product costing CO-PC application