Experienced SAP BW developer and designer specialized in BW architect, data modeling, business process re-engineering, business automation and system optimization using SAP solutions to facilitate customers’ business requirements. 15 years of BW designing, implementing, and maintaining experience in Fortune 200 companies specializing in BW Optimization, SAP ECC FICO Business Process Optimization.

Industry Sector: Media & Entertainment, Power and Utility, Wholesale Distribution and Retail, Chemical, Pharmaceutical, Manufacturing and Retail, and Education.

PROFESSIONAL SUMMARY

15 years of BW system analyst includes 8 years in SAP BW 7.x

Experience with many SAP implementations including six complete life cycle implementations with variety of industry sectors.

Experience designing, implementing, and maintaining SAP Business Data Warehouse Solution

Experience mapping BW business processes to technical configuration and addressing gaps

Experience integrating global BI Solution from multiple SAP and Non-SAP systems

End to end experience in BW – requirement gathering, data extraction, data modeling, Process Chains,BI Reporting

Experience BI extractor implementation, enhancement and maintenance for FICO, LO (MM and SD), SCM, and SRM.

Proficient in Development, creation, enhancement, monitoring, and scheduling BW 7.x objects including BW Administrator Workbench, Modeling, Process Chains, APD, and Reporting.

Experience BEx Query Designer, Dashboard Designer, Web Intelligence, and Design Studio tools.

Solid BW experience using ABAP objects on Table and View, Transfer Rules, Transformations, Update Rules, Start Routine and End Routine, BW Extractors, User Exits, and BW workflow.

5 years SAP ECC ABAP experience in FICO, MM, SCM, and SD reporting, data conversion, BW extractor, and workflow.

5 years BWA experience, 2 years BW HANA experience, and 2 years Near Line Storage experience..

Experience in FI and CO modules

Proficient with business integrated strategy, demand management, Blue Print, Configuration, performance tuning, User Acceptance Testing, troubleshooting, Bug fixing, Gap Analysis, and data flow management.

Work Experience

Dr. Hsiao-Fan Chen MD Inc. San Gabriel, CA 06/2016 to Present

Data Migration Analyst

Performed technical lead in Patient care system migration

Performed data flow analysis.

Led Patient care system migration including data flow analysis, data migration, data maintenance, user training, documentation.

Support change management on new patient care system.

Maintained accounting system.

NESTLE USA Glendale, CA 03/2015 to 05/2015

Customer Master Data Migration

Performed technical lead in Customer Master data migration

Designed processing flow to convert customer master from legacy system into SAP ECC customer master.

Maintained customer master data in SAP ECC.

Performed technical lead in customer master data migration

Designed processing flow to convert customer master from legacy system into SAP ECC customer master

Maintained customer master data in SAP ECC

SOUTHERN CALIFORNIA EDISON Irwindale, CA 08/2009 to 01/2015

IT Specialist 4

Responsible for up-front solutions of SAP FICO and BI projects for existing SAP implementation

Day to day management of a team of developers, both internal employees, off-shore and on-shore consultants, focused on specific FICO areas

Experience with performance tuning analysis including indexes, aggregates, statistics, compression, code review, query design review

Managed SAP change control and transports, and analyzed failed transports and failure recovery.

Managed BW performance including BW activities, BO report runs, BW jobs in ECC, and RFC connection

Monitored BW system, Data Services system, BW jobs (including process chains) in all source systems such as ECC, BPC, CRM, and SRM.

Provided informal mentoring to less experienced colleagues

Managed BW performance including BW actives, BW jobs in ECC, and RFC connection

Integration Finance Reporting

Led BI Tech team working with FI/CO, SAP Basis, Enterprise Information Management & Architecture, and Data Warehouse Engineering teams to design and develop Finance Management Reports (Re-leveraging Data structures) by using DSO, Info Cube, Virtue Cube, Multi Provider, HANA Calculation Views, Attribute View, and tables, Process Chain, IP Aggregate Level, BEx Query, and BOBJ Webi and Crystal reports.

BW HANA Upgrade

Planned all tasks including system developments and designs check, version conversion for software and hardware, testing, documentation, and migration.

System verification and conversion for all objects at developments and designs phases .

Software verification including all related system version verification such as SAP XI, SAP IP, SAP CRM, BODS, BOBJ, CPS, SAP ECC, Teradata, Power Builder, Oracle, SQL Server and HP QA

Hardware verification including network sizing and speed verification, server capacity and configuration, desktop and laptop capacity and applications

Provided all test scripts for unit test, qa test, integration test and system test.

Led for FICO, performed all above tasks for FICO area plus SAP ECC and SAP BW for Edison International Consolidated Financial Statements.

FI Month End Data Extraction Automation

Managed FICO Month End process automation. Using BW Workflow provides authorized business user to trigger BW process chains by customized Transaction Codes for FICO Month End process. It is Business Process Optimization project.

Designed and developed ABAP programs to manage and trigger process chains for three SAP tables that contain personnel information for security control.

Configured Financial Closing Cockpit System in SAP ECC (ECC) add three process tasks

Created three customized Transaction Codes to allow authorized personnel to trigger three adhoc process chains manually in BW in case extra data loads needed.

Provided system documents and training material.

Financial Closing Cockpit BI reporting

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. Updated Financial Closing Cockpit task configuration to add new task for Planning data upload in BI.

Power Plant Reporting enhancement

Worked closely with Business users and Power Plant Tech team on gap analysis. Found solution for missing data and data load slowness.

Re-engineered BW process by creating new DSO for current month order cost estimation and created a new multi provider to associate current month data and all history order cost data for year to date order cost reporting. Updated process chain to migrate current month data into history DSO only when month end closing is done. Updated Data Services to pick up the selected month data.

Added data validation and reconciliation process by using SQL to get report into Power Plant system and to create BEx in BW.

Updated functional specification document and technical specification document to include new process.

Contract Order enhancement for MDM

Led BI Tech team working with SCM team on MDM enhancement to have additional fields for Purchase/Contract Orders. Enhanced custom HTML templates for Purchase/Contract Order to extract additional fields into BW-MDM system. Updated contract order reports for data validation and reconciliation between SCM and BW systems.

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 settlement rules to Cost Center information for SONGS weekly cost control.

Participant Billing System for FI CO reporting

Created BW Extractor in SAP ECC by using ABAP program to extract FI/GL and CO data from ECC into BI and look up material master data in BI to get all data from profit center, cost center, co order, and cost element to make data mart ready and Universe ready for reporting.

ALLERGAN INC Irvine, CA 09/2007 to 05/2009

System Analyst in IT

Analyzed business operation. Provided data modeling and addressed development needs in Finance/Accounting, Supplier Relationship Management, Profit Center Accounting, Sales and Distribution, and Human Resource areas.

Performing led in production support and data validation and reconciliation in FI, PCA, SD, and HR modules.

Project Performance Analytics

Led developers on service request analytics system to extract data from Oracle system that provided service request information and extracted Budget and HR data from SAP R3 to provide analytics reporting for senior management to control project cost.

Returns Analytics System

Enhanced existing Returns Analytics system to provide related sales order, delivery batch information, billing document, and material information for Finance and Internal Auditor. Created three BEx Queries for user reporting on Sales Order, Shipping/Delivery, Billing and Material Management information

SRM Shopping Cart BW Implement

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.

Global Sales Reporting

Designed and developed, with developer, on Sales Order, Delivery, and Billing document data extraction in R3 for historical data and current delta data extraction providing Sales reports for European and Global sales and marketing.

LA UNIFIED SCHOOL DISTRICT Los Angeles CA 10/2006 to 09/2007

Sr. Programmer Analyst

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 Implementation – 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 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.

WARNER BROTHERS Burbank, CA 06/2006 to 10/2006

Sr. Programmer Analyst

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.

APO-DP Implementation

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 requirements. All reports must be real time data for APO analysis.

TERADATA and BW Integration

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 as Info Spoke. After data loaded into Teradata tables, created Info Sources by UDConnect. Moved data back to Info Cubes from Teradata smoothly. Created Virtual Cubes by using those Info Sources. Created Queries to report Teradata information through Info Cubes successfully.

METRO GOLDWYN MAYER STUDIO, INC Santa Monica, CA 01/1996 to 05/2006

Sr. Programmer Analyst

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.

AC NIELSEN Sales Data Rework

Redesigned AC Nielsen project to have source data validation function in Informatica, remodeled database structure in Teradata and remapped MicroStrategy attributes.

TERADATA / MICROSTRATEGY Implementation

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.

SAP/BW Implementation

Designed and developed BW for APO-Demand Planning model, sales order, shipment, and billing systems;

Created two tables and multiple programs to manage data load automatically for International Sales Overview system.

SAP/R3 Implementation

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 general ledger transaction data.

Developed reports for GR/IR areas.

Developed forms to support procurement area - purchase requisitions, purchase orders etc.

Developed customized SAPScript for Accounts Payable including invoice and credit memo, charge back, customer statement, and W2/1099 forms.

EDUCATION:

Fang-Chia University

Bachelor of Science degree in Accounting

REFERENCES AVAILABLE UPON REQUEST:

Ken Hong BI Tech Manager at Los Angeles Unified School District 626-***-****

Tom Auyeung Corp Finance IT Support at Southern California Edison 626-***-****

Theresa Miller CIO at Lionsgate ac0y20@r.postjobfree.com

PROFESSIONAL TRAINING:

SAP Business Warehouse

FI/CO and Special Ledger configuration

ABAP/4 Reporting, ABAP/4 Data Dictionary, SAPScript and Report Painter

Workflow, Data Archiving and Cognos Report/Net

Informatica (ETL) Basic and Teradata SQL and BTEQ

IBM Ascential DataStage Administrator

MicroStrategy 8: Certified MicroStrategy Platform Administrator and Certified project Designer

SKILL:

Microsoft Access, Word, Excel, PowerPoint, and Lotus Notes.

Contact this candidate