Profileimage by George Chen ABAP OO/Fiori/S4/BPC/BW Developer, ABAP Technical SME, ABAP on HANA from

George Chen


Last update: 23.03.2021

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

Graduation: MBA University of California, Irvine
Hourly-/Daily rates: show
C2C + expense. negotiable, prefer remote due to pandemic
Languages: English (Full Professional)


George Yugao Chen - SAP ABAP S4 HANA Interface.doc


ABAP OO, ABAP 1909, S/4 HANA, NW ABAP kernel 7.5x, object-oriented ABAP, HANA, CDS view, generic ABAP OO, ABAP integration, RFC, XML, SOAP, Logic, File, ABAP, BPC, API, parameterized, query performance, WebDynpro, FI, DB, OData, database, data presentation, generic programming, Eclipse/Hana studio, SAP, Analytics, Cloud, Restful program, Eclipse, SQL, script, web application, ABAP RESTFul programming, dynamic SQL, data structure, ABAP testing, Virtual, backend, data access, APO, data integration, wrapper, JSON, data comparison, object-oriented, Scrum, Trello, metadata, data transfer, data acquisition, SQL script, CRM, data structures, XSLT, RFID, parallel processing, EPM, ABAP BADI, Data conversion, data processing, data extraction, BDC, ETL, BAPI, EDW, R/3, EDI, data migration, MTP, Logistic regression, SAS, IDoc, SAP R/3

Project history

12/2018 - 09/2020
ABAP Technical SME
Stepan, Northfield, IL
Project Description/Scope: BPC Classic Planning on HANA
Role: ABAP Technical SME Duration:12/2018-09/2020
* HANA version 1809
* BPC BADI implementation for retraction on planning data, custom logic via script logic.
* BW virtual data staging from another source BW system
* Fiori application on BPC/APO data integration report, ECC Financial planning/APO integration at
product level.
* Rewrite data transformation logic in AMDP to replace ABAP logic at app server.

01/2019 - 07/2020
ABAP Technical SME
Reynolds America Inc.
Reynolds America Inc., Winston-Salem, NC
Project Description/Scope: ABAP development on BW on HANA
Role: ABAP Technical SME Duration:01/2019-07/2020
* Using ABAP OO to create virtual provider for virtual transaction data. Implement virtual master
data and virtual hierarchy for master data info object across different bw systems to provide
realtime, virtual data presentation and data staging.
* Create odata service from BPC model and expose to BW to be consumed by bex query, making DPC/MPC
generic OData service.
* create ABAP CDS views to embed complex financial statement logics on the fly, providing dynamic,
realtime financial reporting
* Implementation is on AMDP(ABAP Managed Database Procedure) to modularize the application methods.
* Design and build Nested CDS views(composite view, basic views) to present accounting data on
ACDOCA with dynamic parameterization to be consumed by Fiori application.
* Create CDS view table function, associated with DB procedure in AMDP class, to push ABAP logic
down to DB level, for parameterized financial reporting on the fly
* Large scale, BPC implantation with generic programming in ABAP BADI and proxy classes.
* Extensive use of ADT( ABAP Development Tool) in Eclipse/Hana studio with CDS view development,
AMDP and ABAP OO development, testing.

10/2019 - 03/2020
ABAP on HANA on SCP Developer
Furst-McNess Company
Furst-McNess Company, Freeport,IL
Project Description/Scope: SAC( SAP Analytics Cloud) on SAP Cloud Planning (SCP)
Role: ABAP on HANA on SCP Developer Duration: 10/2019 - 03/2020
* ABAP 1909 on S/4 HANA 1909
* Develop ABAP Restful program in Eclipse using new behavior model capability in ABAP1909
* Develop Fiori applications based on CDS views with behavior model.
* Create space, cloud foundry, service instances on SCP.
* Create SQL script on HANA, wrapped it with OData to be consumed by SAC reporting and BW reporting
* Create CDS view, projection view, service, service binding, behavioral model/Implementation to
create web application using ABAP RESTFul programming
* Create custom logic using ABAP OO in ADT in Eclipse, connecting to ABAP Cloud service instance
* Extensive use of ADT( ABAP Development Tool) in Eclipse/Hana studio with CDS view development,
AMDP and ABAP OO development, testing.

09/2018 - 09/2019
ABAP Developer
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

09/2018 - 01/2019
ABAP Technical SME
TreeHouse Foods Inc.
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.

02/2018 - 09/2018
ABAP Technical SME
Moen, North Olmstad, OH
Project Description/Scope: BPC embeded BW-IP on HANA
Role: ABAP Technical SME Duration:02/2018-09/2018
* 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
* Design and implement bw-ip planning function for allocation, characteristic relationship
* All development work are done in object-oriented ABAP and are parameterized, generic, reusable in
BW transformation or anywhere in BW-IP.

09/2017 - 12/2017
ABAP Developer
Mead Johnson Nutrition
Mead Johnson Nutrition, Evansville, IN
Project Description/Scope: BPC embedded integration with BW on HANA
Role: ABAP Developer Duration: 09/2017 - 12/2017
* 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.

01/2017 - 09/2017
ABAP developer for BW-IP
Adient, Polymouth, MI
Project Description/Scope: BW-IP/BPC embeded for PPM
Role: ABAP developer for BW-IP Duration: 01/2017 - 09/2017
* 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.

02/2016 - 12/2016
ABAP consultant for BPC/BW-IP
Infinera, Sunnyvale, CA
Project Description/Scope: BW-IP for CPM
Role: ABAP consultant for BPC/BW-IP Duration: 02/2016-12/2016
* 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.

08/2015 - 02/2016
ABAP development consultant on BPC/BW
Florida Power & Lights
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
* 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.

06/2015 - 08/2015
ABAP developer for BPC
Mead Johnson Nutrition
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
* 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
* ABAP OO development to have one generic class for multiple interfacing scenarios with difference
data structures on the fly.

04/2015 - 06/2015
ABAP BPC/BW-IP/HANA consultant
Lam Research
Lam Research, Fremont, CA
Project Description/Scope: BW performance tuning on HANA
Role: ABAP BPC/BW-IP/HANA consultant Duration: 04/2015 - 06/2015
* 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.

03/2015 - 03/2015
ABAP consultant
Kenna Metal
Kenna Metal, PA
Project Description/Scope: ECC/E commerce performance tuning
Role: ABAP consultant Duration: 03/2015 - 03/2015
* 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.

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

06/2014 - 01/2015
ABAP BPC development consultant
Bank of Montreal(BMO) Harris Bank
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
* 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).

02/2014 - 12/2014
ABAP consultant
Foster Farms
Foster Farms, Livingston, CA
Project Description/Scope: BW-IP with Analysis Office, TPM/BPS Integration
Role: ABAP consultant Duration: 12/2014 - 02/2014
* 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.

03/2014 - 06/2014
ABAP BPC development consultant
Mead Johnson Nutrition
Mead Johnson Nutrition, Evansville, IN
Project Description/Scope: BPC 7.5 performance enhancement
Role: ABAP BPC development consultant Duration: 03/2014 - 06/2014
* 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.

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

03/2014 - 03/2014
ABAP consultant
Limited Brands
Limited Brands, Columbus, OH
Project Description/Scope: Web Dynpro ABAP
Role: ABAP consultant Duration: 03/2014 - 03/2014
* 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.

11/2013 - 01/2014
BPC development consultant
Morgan Stanley
Morgan Stanley, New York, NY
Project Description/Scope: BPC consolidation
Role: BPC development consultant Duration: 11/2013 - 1/2014
* 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

11/2013 - 11/2013
ABAP BPC Consultant
Project Description/Scope: BPC 7.5 Planning,
Role: ABAP BPC Consultant Duration: 11/2013 - 11/2013
* 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.

11/2013 - 11/2013
ABAP BPC Consultant
Baker & McKenzie
Baker & McKenzie, Chicago, IL
Project Description/Scope: ECC Implementation
Role: Data conversion and ABAP Duration: 11/2013 - 11/2013
* 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

06/2013 - 10/2013
ABAP BPC Consultant
Jones New York. - PA
Project Description/Scope: BPC 7.5 Planning,
Role: ABAP BPC Consultant Duration: 06/2013 - 10/2013
* 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.

06/2013 - 06/2013
ABAP BPC Consultant
FBL Financials Inc.
FBL Financials Inc. - West Des Moines, IA
Project Description/Scope: BPC 10 NW upgrade,
Role: ABAP BPC Consultant Duration: 06/2013 - 06/2013
* 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
* Seamlessly integrate with BW EDW solution using process chain, and ABAP.
* Debug and fix issues with complex dimension logic

10/2012 - 06/2013
JP Morgan Chase
JP Morgan Chase - Chicago, IL
Project Description/Scope: BPC 10 NW, Consolidation
Role: ABAP BPC DEVELOPER Duration: 10/2012 - 06/2013
* Manage and support consolidation for over 2000 entities in multi-currency, multi country
* 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

05/2012 - 10/2012
Senior ABAP BPC Consultant
* 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.

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

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

01/2012 - 04/2012
BPC ABAP consultant
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
* 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.

02/2010 - 04/2011
SAP Technical Architect
BWI Group
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
* Review/manage all technical design spec documents
* Lead WRICEF development and plan.
* Lead data migration team

02/2008 - 09/2008
SAP Technical Architect
Haier Corporation
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.

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
* 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

06/2007 - 09/2007
PM / SAP Technical Architect
TTX Corporation
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
* Lead onsite team (8) and offshore team (6) to run ECC upgrade project. Collision program analysis
and fix for hundreds of ABAP programs.

12/2005 - 06/2007
BI Technical Architect
Kimberly Clark through Inforte Inc.
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
* 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

11/2003 - 11/2005
SAP Functional Lead
Capstone Turbine Corp.
Capstone Turbine Corp. - Los Angeles, CA
Project Description / Scope: R/3 support & Project.
Role: SAP Functional Lead Duration: 11/2003 - 11/2005
* 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

05/2002 - 11/2003
BI Developer / Lead in SD/MM/EDI
THQ - Los Angeles, CA
Project Description / Scope: R/3 & BI.
Role: BI Developer / Lead in SD/MM/EDI Duration: 05/2002 - 11/2003
* 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

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

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

Time and spatial flexibility

based out of Atlanta, GA, prefer remote due to concern of pandemic. can  travel after pandemic

Contact form

Contact details