Jinson Wong

Senior SAP BW / HANA / ABAP / BOBJ Architect

*** ***** **** ****

Markham, ON L3T 0B9

416-***-****

Email: acomfm@r.postjobfree.com

IMAX, Toronto, Ontario, Canada

Entertainment - January 2015 to present

Senior SAP BW/ABAP/BOBJ Consultant

SAP 7.3, Integration Planning, SAP ECC 6

User: 500, company 10,000

China Box Office implementation

- Work on enhancements to accommodate the addition of China region (new

data flow and Info Providers) into the existing SAP BW system

- Create multiple complex BEx queries using Cell Editing, Variable

Formula, User exits, Exception Aggregation on average and summation,

Booleans, counts, and etc.

- Create other complex BEx queries to calculate Weighted Average of the

product cycle where it was further used in the SAP BOBJ WEBI report

- Create complex Excel Workbooks that involve 15 BEx queries. The

workbook consist of multiple tabs and sections in Excel

- Created Excel macros to compensate the standard SAP functions that the

original design of the other regions did not consider.

- Work on SAP BW Integration Planning to add/change data in the Info

Cube

- Support data loading, and resolve environment issues; and apply fixes

and transports.

- Provide recommendation to landscape upgrade strategy, upgrade of MS

Server.

Holcim Canada, Toronto, Ontario, Canada

Construction Material - August 2014 to January 2015

Senior SAP HANA/BW/ABAP Consultant

SAP 7.4 BW on HANA, SAP ECC 6

User 4000, Company 100,000

Full Cycle

ATR - Annual Technical Report - SAP BW on HANA Greenfield Implementation

- Provide guidance on data extractor procedure to keep one single of

TRUTH of data being loaded into the new SAP BW on HANA system.

- Design and implement Plant Maintenance module that requires

information from Costing, Finance, Material Management, Billing,

Manufacturing modules

- Follow SAP Best Practice with LSA++ modeling methodology throughout

the design

- Activate, enhance, and implemented Material Document, Invoice

Verification, Accounts Payable, Billing Conditions, Credit Card

Payment, GL entries extractors

- Further transformed the Cost Center Actual Cost, Order Actual Cost,

Manufacture Goods Movement, Manufacture Confirmation, and PCA data

into the final Plant Maintenance design.

- Create efficient ABAP enhancements for both ECC and BW on HANA

systems

- Designed a robust data warehouse solution that can reconcile a portion

of summarized data with item level information to ensure an absolute

accuracy of the final report; allows the support team to explain the

complex data flow and data model

- Setup Process Chains

- Create detailed Functional and Technical documentation

- Create detailed test scripts for both SIT and UAT procedures

- Assist peers wherever possible.

Vale, Toronto, Ontario, Canada

Mining - February 2013 to April 2014

Senior SAP BW/ABAP/BOBJ Consultant

SAP BW 7.3, SAP BOBJ 4.0, HP Oracle

User 5000+ Company 50,000

One Vale SAP BW / BOBJ Implementation

- Create and coordinate SAP BO Training Material base on BOBJ 4.0

- Create Universe using Information Design Tool on BEx Queries

- Create multiple WEBI reports base on SAP BO Universe

- Follow SAP Best Practice with LSA modeling (Layered Scalable

Architecture) and SPO development technique (Sematic Partition

Objects) for all BW components including DSOs, InfoCubs,

MultiProviders, Transformation, and InfoSource.

- Requirement gathering to implement SAP BW for Requisition-to-Receive,

Order-to-Cash, and Receive-to-Pay processes; also covers for FI/CO,

PP, PS, and Master Data extractions.

- Design HPQC test procedures for the SAP BW environment

- Design authorization settings in SAP BW and SAP BOBJ

- Work on technical specification, setup meetings with business owners

to go over the requirements in detail

- Consolidate multiple reports into few reports to optimize TOC.

Approximately 15 major reports were designed base on about 100 legacy

layouts.

- Assist peers wherever possible.

Projects Reporting System (SAP BW with OEBS data into MS SQL using Open Hub

and BODS)

- Create BW Process Chain using Open Hub connection to extract PO and

Projects related DSOs to an external MS SQL server.

- Create SAP BODS Connection to extract data from Oracle OEBS system

into MS SQL server.

Sobeys, Stellarton, Nova Scotia, Canada

Retail - July 2011 to Dec 2012

Senior SAP BW and ABAP Architect (through SAP Canada)

Quebec Region SAP BI-7.0, SAP ECC 6, OS-AIX, DB-DB2

User 5000+ 100,000

Multiple Full cycle

Quebec Transformation Implementation - BW

- Architected and designed an application on FI-to-BW Reconciliation

Process. Also architect and design the reports for Store Operation,

Merchandising, Retail Pricing, Inventory Management, and Sale

Projection.

- Enhance several Data Sources, Info Cubes, DSO, large size Info

Objects, Transformation, and BEx Queries

- Modified the ECC BW ABAP User Exit, ETL, and etc. to decrease the data

load time from 8 hours to 2 hours, a 75% performance improvement.

- Create and document multiple new complex BEx Queries using Variable

Exit, Cell Editing, and Virtual Key Figures.

- Main contact whom is responsible for cut over and deployment

- Conduct emergency support procedures in the Production environment at

after hours, and coordinate updates to management.

Quebec Transformation Implementation - ABAP

- Architected and designed an ECC customized process for Site Master

(WB0n), the process later being used by all other SAP transactions

and reporting systems

- Developed a mass maintenance tool by customizing standard SAP program

in ABAP

- Modify many custom ABAP interfaces and programs to accommodate the new

changes (20+ programs)

- Present the solution to the comity; document, test, and deployed the

solution

SpinMaster, Toronto, Canada.

Retail - November 2008 to April 2011 (full time onsite)

January 2012 to May 2012 (part time remote)

Senior SAP BI/ABAP Architect

SAP BI-7.0, SAP ECC 6, OS-LINUS/ IBM AIX, DB-DB2

User 500 company 5000

Multiple Full Cycle

FI/CO Cost Allocation Analysis

- Architect a Revenue/Costing Allocation reporting system. Worked

with standard CCA, GL4, COPC extractors, SD pricing conditions

extraction, flat file loads, Costing run, and other multiple R3

generic data extractors.

- Create/reuse Info Objects, Cost Element groups, Reference Info

Objects, DSOs, Info Cubes, Multi Providers, and Aggregates.

- Developed a highly complex and efficient ABAP program in the End

Routine of the transformation to allocate different cost by Gross

Sales or COGS

- Create complex BEx report that have over 70 key figures to describe

all the soft costs by Material Classification and by Customer.

- Create software specification, and provide guidance with UAT to the

business

- Coordinate a 100+ transport procedure and detail Go-live plan

System Optimization and Performance Project

- Investigate all objects created by all consultants, and look for

better ETL methods.

- Reduced multiple ETL runtime process range from 300% to 80% faster

than it was originally created.

- Realign several Process Chains and Batch Management process to

maximize runtime process and utilize system resource.

- Review ETL ABAP routines for better performance.

Custom Care System Integration into BI implementation

- Architect a SAP BI solution that incorporate third party external

system, consolidate the data and merge certain fields that are SAP

related to create multiple complex BEx reports for upper management to

review the critical state of the return products.

- Work with external TELUS RightNow CRM Custom Care system

SAP R3 Database and OS Upgrade

- Advice on the new landscape the evolve of the new architecture

- Create BAPI in BI for external C# program

- Create specification and provide guidance with other developers, on

both BI and non-BI components

FI/CO implementation

- Architect, develop, and design the AP payment process

- Activate/modify GL, AP, AR, COOM, WBS extractors.

- Gather and translate business specification to technical specification

- Work with BI extractors, custom extractors, DSOs, Cubes, Multi

Providers.

- Setup detailed cutover and go-live plan, collect/coordinate multiple

transports (over 100) from a team of consultants

- Create multiple complex BEx reports and Web Templates

SD/MM implementation

- Activate/modify application 08 (Transports), application 11 (Order),

12 (Delivery), 13 (Billing), 02 (Purchasing), 03 (Inventory movement),

41(Allocation), and custom MRP extractor.

- Create Info Cubes, DSO, InfoSet, Multi Cube, Transformation with

complex/efficient ABAP routines, Process Chains, multiple BEx reports.

Also worked with LIS structures and generic extractors.

- Trigger standard BI delta base on custom fields from a standard R/3

Transaction, where the custom fields are not suppose to trigger

standard BI delta process

- Custom enhancements on enabling new custom fields in Transformation

- Setup cutover and Go-live procedure, and collect/coordinate multi

transports from different developers to setup the QA environment (over

100) -> Production environment.

- Customize DTP and Process Chains for other newly added InfoProviders

- Create complex BEx reports; with RKF, CKF, variables, user exits, and

replacement path.

- Debug, trace, and enhance existing BEx report to find out the root

cause of certain reporting issue; ability to provide trace backs from

the aggregated data from BI and explain how the data is formulated

from R3 to BI of other developer's work (Info Structure or R3

transactions)

SAP R3 Database and OS Upgrade, SAP BI Support Package Upgrade

- Provide consultation and guidance with R3 LINUS DB2 to AIX DB2

upgrade

- Provide consultation and guidance in BI support package and SAP

notes implementation

POS connectivity with European and US customers

- Preparing mapping documents for eleven external vendors to map their

required fields into BW, and define relationships of certain external

fields to SAP ECC/BW

- Customize several efficient Transformation / DTP loading process

- Adjust process chains for new customers

- Setup Go-live procedure and monitor QA and Go-Live process

- Prepare training document for user community

Sobeys, Mississauga, Canada.

Retail - January 2007 to September 2008

Senior SAP BI Architect

Multi Region SAP BI-3.5, OS-AIX, DB-DB2

User 2000, Company 100,000

POS Analytic phase I & phase II

- Senior technical advisor on the overall BW project design and

implementation on 0RT_PA; overall technical architecture design on

multiple Info Cubes, Multi Providers, ODS, ETL, queries, WAD,

reporting agent, and SharePoint.

- Worked with application 11 (Order), 12 (Delivery), 13 (Billing), 45

(Agency payment), 40 (STRPS), 03 (Inv movement), 02 (Purchasing), and

custom LIS structures.

- Enhance R/3 extractor to feed in extra data for the InfoStructure

extraction

- Implemented multiple complex BW queries, Web templates, Reporting

Agent settings, Process Chains for instant report access on the

intranet for the internal company user across different regions. Used

download scheduler to download html and Excel files to the SharePoint

for instant reporting needs

- Create complex and high performance user exit variables

- ETL process via multiple process chains, flat file loads and delta

loads.

- Performance tuning transfer rules and aggregates. The TR speeds up

the loading process by eighty percent; and the aggregate speed up the

report generation time by ninety percent

- Implemented global parameter solution using TVARVC to handle different

parameter for different regional settings

- Create aggregates for better performance

- Create hierarchies, create custom Web Template Objects for reporting

purposes

- Customized SharePoint for Web Report layout

- Create graphs with query views for trend reporting

- Test and document all results with Mercury test software

- Documented all technical steps for internal training

BW Upgrade to SAP NetWeaver 2004s BI7 Project

- Design, research, and documented the complex three regions, nine

Terabyte, upgrade project charter for upper management to review. The

documentation includes system landscape design, upgrade path, system

requirement, Project scope, dos & don'ts, possible alternatives,

project constraints, risk assessment, and quality planning.

- Upgrade SAP Sandbox system and identify issues after the upgrade

- Conduct regression testing with the system, and provide technical

advice on different system check points

- Provide upgrade service to the internal HR BI7 upgrade project

Operationalization - system maintenance procedure and performance tuning

- Investigated, documented, and executed an urgent system request to

remove data due to lack of disk space for immediate growth on the

first week of arrival.

- Designed and implemented the Selective Delete process that will

permanently remove retention data in a Process Chain that runs

daily but only triggers on the second week of the month due to

aggregate rebuild constraint.

- Performance tuning on custom R/3 extractor and R/3 BW retraction

program

- Examined and improved the overall BW system health, storage

required of all the InfoProviders at retention, aggregates and

query performance for optimal system usage.

- Adjusted multiple Transfer Rules to enhance loading performance as

well as fixing the nightly loading errors that may take hours to

fix in the Production environment;

- Test and document all results with Mercury test software

- Review and improve system monitoring and management process

Non-Project tasks

- Overall technical advisor on the ten terabyte Multi Region BW

system

- Create BEx reports, web templates, process chains and post them

onto SharePoint

- Extractor enhancement

- Create new aggregates

- Performance tuning

- Enhance/modify contents in the area of 0RT_SAL, 0RT_STOCK, 0RT_PUR,

0RT_AB

- Technical advisor on all production issues or related project

issues

Dofasco, Hamilton, Canada

Automotive Implementation - August 2006 to January 2007

Senior SAP ABAP Architect (through CGI Canada)

Full Cycle

SAP R3 ECC5, OS-UNIX, DB-Oracle

- Responsible for gathering specifications from the functional

consultants to create technical requirements.

- Create custom IDOC Function Module that will create subsequent MIGO

WMMBXY IDOC, MB1B WMMBXY IDOC, Batch Create BAPI, Batch Update

BAPI, QM Notification through IDOC enhancement, or Service Entry

Sheet through BAPI for an EDI 870 PR document. Also build an error

handling program to track the IDOC errors.

- Create outbound interface to extract Inventory related data and

transfer the file to an external system. Also responsible for

complete end-to-end testing.

- Create inbound interface using standard BAPI to post Independent

Requirements.

- Use user exit and standard BAPI, created an automatic batch

creation routine that determines the appropriate characteristic /

classification information. Standard SD Batch determination

configuration was turn off for some business requirements

constraint. The reason of doing it in ABAP is because the EDI

Process can also share the same code.

- Enhancement on SIS structure by adding in append structures to the

Billing communication structure, and also create User exit with

standard BAPI to determine its values.

- Create special requirement routines for order output, using SD

forms and formula.

- Enhanced the standard Service Entry Sheet to add additional fields

to the standard transactions; and automatically determines its

value base on certain data.

- Create COPA derivation rules

- Responsible for examining OSS Notes for various modules.

ChemTrade Logistics, Toronto, Canada

Chemical Industry - October 2006 - November 2006

Senior SAP ABAP Architect

SAP R3 4.6, OS-UNIX, DB-Oracle

- Enhance custom ABAP report to retrieve additional information in

the Sales area, and also created an Excel download functionality.

- Create SAP Query to report PO Schedule information.

- Enhance Payment notification SAP Script to change its layout, text

elements, and retrieve additional fields.

- Add new segments to the EDI 856 interface to transfer additional

custom information.

- Adjust Tank Tracking SAP Script to show additional broker

information.

ATI Technologies Inc., Markham, Canada.

High Tech Industry - August 1998 to May 2006

Senior SAP BW, ABAP Developer, SIS Specialist

SAP R3 4.0 and 4.6, OS-UNIX, DB-Oracle

SAP BW 3.0 & 3.5, OS-UNIX, DB-Oracle

User: 2500, Company 70,000

Phase 2 BW Product Life Cycle Reporting System

November 2005 to April 2006 - Technical project coordinator and BW

developer

- Leaded the project development on design, implementation, and

architecture

- Examined Rosetta Net PIP 7B1 XML and defined the Meta data for the

external vendor to submit data into the R/3 system; the design have to

automatically triggers multiple GR/IR/TP transactions in R/3

- Performed analysis, design, data modeling, and implementation on

multiple ODS, Info Cube, Multi Cube, Info Objects, and Info Sources,

Characteristics, and Key Figures to fit the new business requirement

on measuring the performance of the Supply Chain process, also

designed an archiving method to transfer certain inactive transactions

into a historic Info Cube.

- Created Remote Cubes to access R/3 data in real time to analyze the

incoming raw R/3 data

- Designed and implemented ETL process with Process Chain to load part

of the data in parallel sequence and the other part of the data in

sequential sequence.

- Created complex ABAP program at the Start Routine to update ODS; it

requires sorting out the events associated with incoming data packages

while keeping the program running optimized.

- Extend existing customized Master Data Info Sources for uploading

attributes and texts

- Create transfer rules, update rules, and communication structures for

all Info Providers.

- Written a complex custom IDOC function module to receive information

from SAP XI, apply business logic to transform the incoming data to

fit into the BW star schema.

- Setup partner profile in R3 to receive external information from SAP

XI

- Create and schedule process chains with an automated error message

program on every load steps to eliminates manual monitoring of data

loads

- Written multiple complex BEx queries with User Exits to calculate

current week/month inventory versus previous weeks/months

- Used Replacement Path to query another Info Provider to get the

definition for the existing query.

- Created variables, calculated key figures, restricted key figures for

BW Queries, RRI, report tuning via reporting agent, global cache, and

etc.

- Created Web Application with the BEx Web Application Designer to post

the reports onto the SAP Portal

- Created user roles and report role (PFCG) for displaying reports in

the SAP Portal environment

- Provided end-to-end data flow testing from xml to SAP XI, SAP XI to

SAP R/3, then from SAP R/3 to SAP BW systems

- Created transports procedure on technical/custom objects, and detailed

Go-Live procedures

- Provide data flow explanation to user community

SAP BW Custom Inventory Reconciliation Process

October 2005 to February 2006 - Technical project coordinator and BW

analyst

- Lead the technical project timeline, development, and create

detailed specification.

- Analysis and design the complex data model that involves over 15

Info Providers. The infrastructure includes data from R/3,

external spreadsheets, and external data that come from SAP XI 3.0.

The data includes: 0MATERIAL, Info Structure S032, extractor 03

Inventory Movement, extractor 02 Purchasing, COPC, and multiple

vendor inventory reports.

- Analyzed all the business reporting requirements with the users and

summarized all the reports from the Finance, Audit, Purchasing, and

Inventory Control departments.

- Investigate and design the usage of custom data extractors /

reports for extracting data from R/3 into BW, include loading data

from LIS into BW, custom extractor loading data from customized R/3

tables into BW, table replication method for loading data from R/3

into BW; and layout all loading methods in VISIO

- Investigated the usage of Business Contents

- Investigate and successfully implemented the data source to make

direct connection between SAP XI 3.0 with SAP BW 3.5

- Setup meeting and provide guidance to the Business Analyst,

Business Power Users, External Contractors, and in house resource

to over come business and technical R/3 or BW issues

- Worked on the data loading procedure using Data Mining method with

Process Chains.

- Analyzed all the incoming data and Meta data definitions

SAP BW 3.1 to 3.5 Upgrade Project

June 2005 to September 2005 - Technical project coordinator and BW

developer

- Independently conducted the upgrade; lead the project timeline and

development.

- Migrate existing Business Contents (SD, MM, FI/CO) in the SAP BW

3.5 environment

- Designed and executed the migration plan to move the existing BW

3.1 objects to BW 3.5 while implementing new projects in BW 3.5

environment

- Created multiple transports to move all necessary objects to the

new Development server

- Advice the Basis team to apply the latest SP and OSS notes to the

new BW server for enhanced functionality

- Created and conducted detail test plans to test the support

packages and OSS notes.

- Ensured all the functionalities remain the same after the upgrade,

conduct regression testing on all Info Providers between the BW 3.1

and BW 3.5

- Recreate Report Roles using transaction PFCG

- Recreate all the reports including restricted key figures,

calculated key figures, and Web Application templates (WAD).

- Design and execute test scripts, and educate the users the method

of testing the new BW 3.5 environment

- Communicated with SAP and implement SAP notes

- Created transports and detailed Go-Live procedures

SAP BW CRM Design Win Funnel implementation

May 2005 to August 2005 - Technical project coordinator

- Communicated in regular basis on the status of the project to

management

- Prepared the BADI for object Material ID allowing a custom prefix

to be appended to the start of a number from a number range for

product number, then the product number is returned to the screen

100 of tcode COMMPR01, create material, where the field Material is

automatically populated.

- Worked with Business Content: 0CRM_OPPH, 0CRM_OPPI, 0CRM_C04,

YCSAL_C02, and its relevant objects

- Define new attributes in BW, and also ensure the BW BPS module

recognizes the new changes.

- Monitor and provide support on periodic data loads from SAP R/3 to

BW (BDOC, SMQ1 & SMQ2)

SAP BW OutLook Soft / Costing data development

May 2005 to June 2005 - Technical project coordinator and BW Developer

- Worked on a custom ABAP Info Cube extraction program to download

the data into the UNIX directory

- Worked on 0CCA_C11, and Cost Center/Cost Element Hierarchies

- Worked on creating the Process Chain to load data from R/3 into BW

- Setup external command using AL11 for the SSH script

- Monitor and provide support on periodic data loads from SAP R/3 to

BW

SAP BW Ram Up / Phase 1 Product Life Cycle

June 2004 to April 2005 - Technical project coordinator and BW developer

- Lead the project development from initiation to final Go-Live and

support

- Examined Rosetta Net PIP 7B1 XML and fit it into the business

requirements for transmitting external data into R/3

- Setup the base environment for SAP BW including RFC destination,

Source System configuration, and SPRO setting

- Designed the technical architecture of the material manufacturing

process data flow

- Designed and implemented the ODS, Info Cube, Remote Cube, Info

Objects, Info Sources, and Process Chains to fit into the business

requirements

- Wrote ABAP extractors / programs to extract data into custom R/3

tables for BW

- Setup Process Chains for master data and transactional data to load

into SAP BW

- Activated and enhance standard Business Content Info Objects

- Created multiple BEx queries using User Exits and Substitution

Rules

- Created Web Application with the BEx Web Application Designer to

post the reports onto the SAP Portal

- Communicated with SAP and read SAP notes regarding short dumps and

errors

- Created transports and detailed Go-Live plan

SAP R/3 Customer Master Re-org Project with SIS development

April 2004 to May 2004 - Technical ABAP Developer and SIS specialist

- Implemented the new changes to the SIS update rules

- Modified multiple custom ABAP Reports to reflect the new changes

- Modified the existing SIS structure to reflect the new changes

- Created custom BDC upload program to wrap around a standard SAP

program to automatically create the SIS Hierarchy

- Created a custom ABAP BDC program to migrate the existing data to

the new SIS structure

- Prepared transport and plan the Go-Live strategy

SAP R/3 Custom RMA Approval transaction

November 2003 to March 2004 - Technical ABAP Developer

- Designed, architect, and implemented the custom Sales Order Return

approval process

- Used SAP Sales Order User Exit and implemented an automated email

notification process

- Implemented a custom transaction to display an user specific

approval report with the functionality of allowing the user to

approve only their own outstanding RMA; furthermore, it triggers

another work flow process to issue another email for the next level

of approval

- Designed and created customer tables to store the master data of

the approval process, and the transactional tables to store the

current status of the approval process.

- Used Table Maintenance Generator and its standard authorization

functionality, created a custom Transaction Variant for super users

to maintain the work flow master data

- Developed custom ABAP report to sent alerts the RMA administrator

that the work flow is over due and require further attention

- Developed custom ABAP report with ALV Grid Display functionality to

reflect the point of delay where the work flow process can be

further streamline

SAP R/3 Custom Sale Order commit date tracking process

January 2003 to September 2003 - Technical ABAP Developer

- Designed, architect, and implemented the Sales Order Commit Date

process

- Used SAP Sales Order User Exits and Customer Screen two,

implemented custom functionality of screen controls using standard

SAP internal program tables

- Developed new and enhance multiple custom ABAP reports and SAP

Queries to reflect new changes

- Created detailed test plan and conduct tests on the Sales Order

transaction

- Create five new ABAP reports using ALV Grid Display function

- Modify existing invoice SAP Script to display the customer

commitment date

- Prepared transport and plan the Go-Live strategy

SAP R/3 / eMatrix Implementation

October 2002 to December 2002 - Technical ABAP Developer

- Created custom ABAP UNIX download interface programs on BOM,

Material Master, Material characteristics, ECN, and Material

Document information

- Created detailed test plan and conduct tests on the program to

ensure program accuracy

SAP R/3 4.0B to SAP R/3 4.6C Upgrade

July 2002 - September 2002 - Technical ABAP Developer

- Executed SPAU, analyze the output result, and determine the

technical requirements for resource management

- Examined the system and re-implement OSS notes where is necessary

- Re-implemented and redesigned SAP modifications back into the

system to maintain the same business logic to remain the same after

the upgrade

- Adjusted standard SAP R/3 tables and custom SAP R/3 structures for

the custom / standard SAP R/3 program to run

- Created new SAP modifications that is necessary for SAP R/3 to

maintain the same business logic to remain the same after the

upgrade

- Recreated Area Menu for the SAP R/3 Report trees

- Examine and analyze the Batch Jobs in the Production environment;

and advice the business regarding the report interface changes

between upgraded system

- Involved in sorting the order of the transports required to go into

the QA and Production environment

- Prepared training material and conduct training courses on SAP

Query.

Develop and enhance Sales Forecast and Revenue Systems using SIS component

August 2001 to May 2002 - Technical ABAP Developer and SIS Specialist

- Implemented the Sale Revenue Info Structure

- Created new update rules and key figures on the existing Forecast

Info Structure

- Adjusted custom ABAP reports and enhance standard SAP SIS reports

SAP COPA implementation

September 2000 to December 2001 - Technical ABAP developer

- Implemented Sales Order pricing procedure to capture the costing

information of a specific plant, used ABAP code in Formula

Assignment and Condition type, and along with SD configuration to

calculate the output price. This price is then transferred into

COPA through standard COPA functionality.

- Implemented a Material Master User exit to force the user to enter

Cost Center information into the standard MM transaction (MM0n).

Upon saving the transaction, if the Cost Center information is

missing, a dialog box would appear allowing the user to enter the

appropriate Cost Center information,

- Implemented Derivation rule and Substitution rule in a generic

format. A custom table was created to store generic rules of the

formula, if incoming data satisfies certain criteria, it will

select a rule and conduct calculations to store the information in

the custom COPA table (PA1000)

- Prepared transport procedure along with other developer and

configuration specialist.

SAP Implementation

Contact this candidate