PROFESSIONAL SUMMARY:

• 17 years SAP experience of which 14 years of BW system analyst in FI/CO, MM, SD, APO DP, and SRM modules.
• Proficient in 3 - Tier SAP BW Architecture, BW HANA Info Model, Data/Metadata Administration and Reporting.
• 8 years of SAP BW 7.x development with strong knowledge of BW Administrator Workbench features and toolset
• 5 years as ABAP in FI/CO, MM, PO, and SD reporting, data conversion, and workflow.
• 1 year Teradata SQL and 1 year HANA Studio SQL
• Proficient with business integrated strategy, demand management, service management, QA test, Gap Analysis, and data flow management.

SKILL:

Microsoft Access, Word, Excel, PowerPoint, and Lotus Notes. 10 Keys by touch.

WORK EXPERIENCE:

Confidential

Responsibilities:

• Performed BW technical lead in FI/CO production supports and simple enhancement
• Designed Integration Finance Reporting
• Led BI Tech team working with FI/CO, Enterprise Information Management & Architecture, and Data Warehouse Enginnering teams to provide Finance Management Reports (Re-leveraging Data structures) by using HANA Calculation Views and tables, BW virture cubes, multi providers and BOBJ tools.
• Designed and Developed Data Mart for SONGS Weekly Work Order Cost Simulation
• Designed data modeling and development Info Cubes, DSOs, Multi Providers, Master Data, transformation, update rules/transfer rules, process chains to calculate SONGS Work Orders cost simulation by setttlement rules to Cost Center information for SONGS weekly cost control.
• Designed and developed FI Month End Data Extraction Automation project
• Created three adhoc process chains for General Ledger, Orders, WBS, and Cost Center data extractions;
• Created three CPS job chains to allow FI team executing above three adhoc chains in Finance Closing Cockpit System;
• Created three Z Tcodes to allow authorized personnel trigger above three adhoc process chains;
• Created one security control table to manage access for above three Tcodes;
• Created one ABAP general program to access process chain with security checking.
• Financial Closing Cockpit BI reporting project
• Created a process chain to automatically load Cost Planning data into BI through a new data extraction method data flow analysis.
• Enhanced FI Month End BI Extraction Automation system to meet Financial Closing Cockpit system.
• Designed and developed Participant Billing System for FI CO reporting
• Extract GL and CO data from ECC into BI and Look up MM data in BI to get all data by profit center, cost centerd, co order, and cost element to get data mart ready and have Universe ready for reporting.
• Day to day support BW FICO area.
• Performing technical led on FI/CO month end process

Confidential

System Consultant

Responsibilities:

• Designed data modeling and development Info Cubes, DSOs, Multi Providers, Infosets, Master Data, update rules/transfer rules, process chains, and BEx Queries, Variables in SRM, FI, and HR areas.
• Performing technical led in production supports and data validation and reconciliation in FI, PCA, SD, and HR modules.
• Developing service request analytics system to extract data from Oracle system for service request information and extract HR data from R3 to provide analytics reporting system for senior management control project cost. Creating new Info Cubes, Remote cube, and Multi Provider, transformation, DTP, DSOs to extract and store data.
• Creating two open hubs to provide files for BPS system.
• Enhancing existing Returns Analytics system to provide related sales order, delivery batch information, billing document, and material information for Finance and Internal Auditor.
• Created new Info Cubes, Remote cube, and Multi Provider.
• Using user exit gets sales order, delivery, billing and material information in R3. Created three Queries for user reporting.
• Implemented BW system for Supplier Relationship Management system. Installed Info Objects, ODS, Info Cubes, Multi Cubes, transfer structures, transfer rules, communication structures, start routines, update rules and Queries and Created process chain to perform data load for Shopping Cart function.
• Configured Data Sources in SRM system.
• Performed data extraction and Validation.
• Designed and developed Multi Providers, Info Cubes, and ODSs providing Sales reports for Europen and Global sales and marketing.
• Configured standard Logics Sales Order, Delivery, and Billing document data extraction in R3 for historical data and current delta data extraction.

Confidential

Sr. Programmer/Analyst

Responsibilities:

• Performed technical supervisor job in design data modeling and development data targets, info objects, update rules/transfer rules, process chains, and jump queries in SRM, FI, and HR areas.
• SRM (Supplier Relationship Management) PROJECT - SRM 4.0 and BW 3.5
• Implemented BW system for Supplier Relationship Management system. Installed Info Objects, ODS, Info Cubes, Multi Cubes, transfer structures, transfer rules, communication structures, start routines, update rules and Queries. Configured Data Sources in both SRM system and R3 system (Material Management module and Purchasing module). Performed data extraction and Validation.
• Designed and developed NORM system to provide actual and budget Schools NORM head counts information. Created Info Cubes, ODS, Info Object, and Info Sets to store data for NORM reporting.
• Created process chains to load data automatically from for HR, NORM, and FI areas.
• Redesigned Budget and Expenditure Analysis reporting system by re-configuring master data, ODSs, cubes, and multi providers for FI and HR with BPS team.

Confidential

Sr. Programmer/Analyst

Responsibilities:

• Led APO project and Teradata BW integration project on design data modeling and development multi providers, info providers, ODS, update rules/transfer rules, transfer structures, data sources, info objects, and info spokes.
• Designed and developed BW for APO-Demand Planning Reporting System. Created two info sources to submit APO forecast vs. actual reports by two remote cubes in BW reporting environment. No any APO data stored/loaded into BW environment to meet user requirments. All reports must be real time data for APO analysis.
• Configured three Info Sources to extract SD data into three Info Cubes: Sales Order, Delivery, and Billing.
• Used Info Spoke to generate three flat files for Teradata. Created three tables in Teradata which have the same structure from Info Spoke.
• After data loaded into Teradata tables, created Info Sources by UDConnect. Moved data back to Info Cubes from Teradata smoothly.
• Also created virtual cubes by using those Info Sources.
• Created Queries to report information out Teradata by Info Cubes successfully.

Confidential

Sr. Programmer/Analyst

Responsibilities:

• Designed data model and development Info Providers, Info Objects, ODS, PSA, Info Sets, Process Chains, and update rules/transfer rules, tables, views, programs, start routines, user exits, Variables, BEx Queries, and Workbooks in FI/CO, MM, and SD modules.
• Redesigned AC Nielsen project to have source data validation function in INFORMATICA, remodeled database structure in TERADATA and remapped MicroStrategy attributes.
• Participated on TERADATA modeling to implement sales distribution models for HEG (Home Entertainment Group) sales and marketing. Performed data validation and reconciliation with SAP R3 by Informatica and Teradata Queryman. Working on security roles setup and maintenance in MicroStrategy. Participating business layer development for AC Neilson system in MicroStrategy.
• Designed and developed BW for APO-Demand Planning model, Sales Order, Shippment, and Billing Systems;
• Created two tables and multiple programs to manage data load automatically for International Sales Overview system.
• Implemented Workflow for Purchase Order and SD EDI processes.
• Managed interface and conversion process for FI/CO, and SD modules.
• Responsible for the design, configuration, and customization of the Cash Management module.
• Designed, developed and programmed interface processes for FI/CO areas such as Chart of Account, Cost Center, Projects, and Detail General Ledger transaction data.
• Developed reports for GR/IR areas.
• Developed forms to support procurement area - Purchase Requisitions, Purchase Orders etc.
• Developed Customizing SAPScript for Accounts Payable including Invoice and Credit Memo, Charge Back, Customer Statement, and W2/1099 Forms.