PROFESSIONAL SUMMARY:

• 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.
• 14 years of BW designing, implementing, and maintaining experience in Fortune 200 companies specializing in BW Optimization, SAP ECC FICO Business Process Optimization and SAP ECC FICO Business Planning & Consolidation (BPC).
• 14 years of BW system analyst includes 8 years in SAPBW 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, BI Reporting
• Experience BI extractor implementation, enhancement and maintenance for FICO, BPC, LO (MM and SD), SCM, and SRM.
• Proficient in Development, creation, enhancement, monitoring, and scheduling BW 7.x objects including BW Administrator Workbench, Modeling, Open Hub, 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.

SKILL:

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

WORK EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

• Perform technical lead in number system migration
• Performing data flow analysis.
• Maintaining master data for number system.
• Leading change management on number system.
• Updating documentation.

Confidential, San Gabriel, CA

System Analyst

Responsibilities:

• 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.

Confidential, Glendale, CA

Customer Master Data Migration

Responsibilities:

• 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

Confidential, Irwindale, CA

IT Specialist

Responsibilities:

• 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 in all source systems such as ECC, BPC, MDM, and SRM.
• Provided informal mentoring to less experienced colleagues
• Managed BW performance including BW actives, BW jobs in ECC, and RFC connection
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.

Confidential, Irvine, CA

System Analyst in IT

Responsibilities:

• 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.
• 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.
• 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
• 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, 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.

Confidential, Los Angeles, CA

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.
• 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.

Confidential, Burbank, CA

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 requirements. 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 as Info Spoke.
• After data loaded into Teradata tables, created Info Sources by Confidential .
• 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.