SUMMARY:

Over 25 years’ experience in ERP system (SAP 15 years), database (Oracle 4 years), graphical user interface, software development and technical support environments. I have delivered successfully on time and on budget more than 10 SAP full cycle implementations (including 3 global implementations). Results - oriented data architect with hands-on development experience, excellent communication and interpersonal skills. Works effectively with others (on-shore and off-shore) to attain or exceed objectives.

TECHNICAL SKILLS:

Process: ETL, Conversion/upgrade documentation standards as RICEF (Reports, Conversions, Interfaces, Enhancements and Forms), Conceptual Design, Technical Design, Data Mapping, Execution Process and Sign-Off

SAP: BODS, LSMW, EMIGALL, CATT, SHDB, BDC, XI/PI, IDOC, BAPI, RFC, SAP-Scripts, Reports, SmartForms, Data Dictionary, ALVs, Dialogs, Enhancements (Exits), Event-triggers, Menu, Screens - SD (OTC), FI/CO (FTM), MM, PM, EAM, HCM, DMS, EP (IS-Oil), WM, SCM, CRM, PS and PP modules

PROFESSIONAL EXPERIENCE:

Confidential, Costa Mesa, CA

SAP Data Conversion Consultant

• Performed some E but main responsibilities were T & L in ETL process of data conversion project
• Coordinated and scheduled legacy data extract downloads using FTP from client’s site
• Created data load templates for Cost Centers, Profit Centers, Chart of Accounts, GL Accounts, Fixed Assets, Account Receivables, Account Payables, Customer Master, CMIR, Credit Limits, Sale Orders, Project (Definitions & WBS Elements), Networks and Network Activities
• Maintained mapping rules and Functional Design Document (FSD) for FTM, OTC and PS objects
• Designed & performed transformation of legacy data (MFG-Pro & Oracle) to SAP using Access & Excel
• Defined rules & applied to Customer addresses cleansing (domestic & international) with Business
• Executed data load programs using LSMW, BAPI and IDOC during ITCs and Cut-Over
• Provided data analysis and troubleshoot data load errors
• Assisted management with Cut-Over Plan activities as load sequence, dependencies & number ranges
• Responsible for the gathering and analysis of WISPER data extract - Vendor Performance System
• Obtain signoffs from Business for pre-load and post-load data validations

Confidential

Data Migration (BODS) Analyst

• Developed and modified BODS codes
• Meet coding standards, analyze and resolve code issues
• Tested and delivered extracts for analysis
• Participate in test loading
• Provided support to the BODS team during Conversion and Cutover cycles
• Identified issues/missing information. Propose the best-practice approach when solving issues
• Facilitated team meetings and conference calls with other teams (SAP Functionals, BI and Emigall teams) for issues resolution

Confidential,Atlanta, GA

Data Migration Architect

• Confidential was brought in after a failed data conversion effort by the client. Joined the project as Data Lead to get project back on track, organize, review and coordinate the data efforts
• Created/updated data maps, testing plans and execution steps documents
• Created/validated data validation reports using Query Extract
• Data loads using LSMW and standard ABAP programs
• Created and maintained cut-over plans using MS Project and Excel
• Coordinated load team and loaded data to systems/clients for Integration Cycles, UAT and Cut-Over
• Identified issues/missing information. Propose the best-practice approach when solving issues
• Coordination and presentation of error handling and bug fixes. Facilitated team meetings and conference calls with Business Owners and SAP Functional for issues resolution

Confidential,Boise,ID

Data Migration Analyst

• Create/update data maps, testing plan and Functional/Technical specification documents
• Create/update Step Forms, data validation reports using Query Extract and load programs using LSMW
• Load data to various systems/clients for data validation and integration
• Identified issues/missing information. Propose the best-practice approach when solving issues
• Coordination and presentation of error handling and bug fixes. Facilitated meetings and conference calls with clients and SAP Functional for issues resolution

Confidential,Roanoke, VA

Data Migration Analyst

• Review/update data maps and development of load programs using LSMW or ABAP
• Coordination and presentation of error handling and bug fixes
• Load data to various systems/clients for data validation and integration
• Identified issues/missing information. Facilitated meetings and conference calls with clients and SAP Functional to get resolution

Confidential

Data Migration Analyst

• Designed and developed data maps, technical specification templates and data file naming standards
• Analyzed and developed extraction logics/programs for data cleansing of current SAP ECC system - Functional Locations, Equipments, Classes and Characteristics
• Assisted clients with legacy data reviews for data mapping and some cleansing

Confidential,Wilmington, DE

Data Migration Analyst

• Analyzed and developed data migration strategy for loading data from multiple legacy SAP 4.6C systems to Oracle Staging Area DB to SAP ECC 6.0 system
• Assisted clients with legacy data reviews for data mapping
• Analyzed existing load programs (LSMW, BDC and BAPI) to determine if can be reuse with some modification or to rewrite new logic

Confidential,Everett, WA

Data Analyst

• Designed and developed custom Reconciliation Report for all migrating objects to compare total counts and amounts of data from legacy systems to staging area to ECC clients
• Developed data templates and load programs using EMIGALL
• Analyzed and resolved data issues logged by customer and development team

Confidential,Huntsville, AL

Data Architect

• Prepared and delivered data migration project plan with task completion date as well as details plan for data cycles: Trial Cut-Over, User Acceptance Test, Full Dry Run and PRD (Go-Live)
• Coordinated, prioritized and assigned development tasks to on-site and off-shore team members
• Delivered Data Strategy presentations: data migration overview, planning, cleansing, de-duplication, extraction, staging and loading data to SAP
• Created loading procedures and templates for FIN, EAM and MM modules
• Analyzed and designed System Landscape and Transport Procedures
• Trained and guided client developers in data translation, cleansing, de-duplication load processes.
• Utilized MS-Access to prepare legacy data for loading such as translations, defaulted values and any special functions to transform date, number and character formats
• Developed and implemented LSMW to load legacy data to SAP ECC 6.0 for FIN: G/L Accounts, Profit Centers, Cost Centers, Primary and Secondary Cost Elements, Asset and Sub-Asset Master, Customer Master, Internal Orders and G/L Balances. For EAM: Characteristics, Classes, Functional Locations, Equipment Master (Meters and Fleets), Task Lists, Measuring Points, Measuring Documents, Maintenance Plans, Compatible Units and Long Texts

Confidential,San Diego,CA

Interface Lead

• Lead requirement gathering session, facilitated requirements meetings, development walk through, and user acceptance testing sessions with the client
• Reviewed functionality specifications before delivering to off-shore for development
• Responsible for supporting the developer and ensuring the developer remains on target
• Worked with BDO to determine the best solution for customer needs and satisfy requirements
• Designed Interface Architecture for secured and non-secured transmission of data to external vendors involving XI/PI, IDOC, RFC and FTP
• Conducted interface team code reviews and end-to-end testing of interfaces

Confidential,Edgewood, MD

Data Architect

• Scheduled, prioritized and assigned development tasks to on-shore and off-shore team members
• Delivered Data Strategy presentations: data migration overview and planning, cleansing, de-duplication, legacy data extraction, data staging and loading data to SAP; reported weekly team progress to PMO
• Created loading procedures and templates for MAN, SCM, OTI, FI and QM modules
• Interviewing team members, set guidelines and procedures for code developments
• Created functional/technical templates and development objects naming standard
• Analyzed and designed System Landscape and Transport Procedures
• Provided guidance at several client sites for data cleansing and data de-duplication processes
• Utilized Macro in MS-Access to prepare legacy data for loading such as translations, defaulted values and any special functions to transform date, number and character formats
• Developed and implemented LSMW to load legacy data to SAP ECC 6.0 for Vendor Master, Purchasing Info Records, Source Lists, Open PO (Standard, Project, Asset and Cost Center type) and Long Texts

Confidential

SAP Data Conversion Lead Consultant

• Scheduled and prioritized loading sequence
• Created data load templates for MM, SD, FI, PP, WM and QM modules
• Coordinated and assisted Business Owners in legacy data extractions
• Created technical specifications
• Trained/guided client technical resources to use LSMW and BDC
• Developed programs and loaded data using LSMW; Mainframe & PeopleSoft to SAP ECC 5.0
• Provided technical assistance to SAP Functional team and users

Confidential,Dallas, TX

SAP ABAP Consultant

• Created DMS Journal Entry Status reports to provide management, accounting and IT staffs to view summaries and status of current pending JE; header and line item information for pending JE; posted FI document number showing the posted document
• Inserted several screen fields to add Bin Location and description to application for Create Transfer Order for Material Document
• Customized Layout Sets for Delivery and Pick Slip of Direct Goods Issue. Created subroutines from Layout Sets to execute ABAP programs

Confidential

SAP Team Lead/Technical Analyst

• Provided on-going technical support; met with functional leads and business owners for new initiatives and enhancements/fixes to existing applications on weekly basis
• Evaluated, prioritized and scheduled workloads for ABAP Team members using MS Project
• Determined training for team members based on new projects & individual development/interest
• Reviewed and approved all Transports from DEV to QA environments
• Evaluated, planned and participated in technical pre-upgrade of SAP R/3 4.5B to Enterprise 4.70 SR1 for FI, CO, MM and HR modules
• Utilized SAP RBE (Reverse Business Engineering) tool to identify custom objects and their frequency of usage for system upgrade to Enterprise 4.70 SR1
• Performed transaction CMOD, SE95, SPAU, SPDD and SNOTE to identify, analyze and cleanse enhancements and modification of SAP objects for Enterprise 4.70 SR1 pre-upgrade
• Analyzed and coded: Employee Payroll Checks; T4 Year-End Reporting; Detailed Asset Transactions Report; Corporate Vacancy Report; Benefits and Pension Confirmation Form; Asset Acquisition Commitments; PO Requisitions; Open Requisitions; PO SapScript
• Analyzed, designed and implemented templates: Conceptual Design & Technical Design Specification and Change Requests for RICEF: Reports, Interfaces, Conversions, Enhancements and Forms
• Created ABAP Performance Code Review, User Requirement Review, Data Loading Preparation Steps
• Evaluated and implemented User Change Process for Documentation and Coding for auditing purpose
• Trained team members with SapScript and MS Access

Confidential,Houston, TX

SAP Data Analyst

• HR - Employee upload, involved in Technical Design and Data Mapping sessions with Functional team and power users
• Developed HR Master Data conversion program using LSMW and SHDB. Loaded infotypes 0, 2, 1, 6, 7, 8, 9, 41, 2006, 25, 315, 105, and 17
• HR- PA and PD: Loaded Employee Data from 3.1H to 4.6C for US plants and from 4.0B to 4.6C for European plants
• HR - Time Management Module: Absence Control Incident Report, Time Evaluation Extract Report and Shift Manpower Report
• Analyzed, programmed and implemented 1099 Form and W-9 Form - both forms contain a three-step process: execution program, print program and Sap Script (Layout Set)
• Analyzed and assisted Power-Users in the data cleansing process
• Lead and responsible for a team of three members for PM Plant Maintenance module - From 3.1H to 4.6C for four US plants; From 4.0B to 4.6C for two European plants; Functional Locations, Equipment Master, Task Lists: Equipment and General
• Preventive Maintenance: Plan, Item and Schedule and Equipment BOM
• Technical Design and Data Mapping sessions with Project Lead, Functional Team and Power Users
• PM Extraction - Created custom programs (SHDB) and utilized SAP List Editing for extractions of Legacy data from six manufacturing plants (3.1H and 4.0B) into Excel Spreadsheets
• PM Upload - Created custom programs (SHDB) and utilized SAP Standard program IBIP to load data to the new SAP 4.6C system through LSMW and CATT for Functional Location; Equipment Master; General Task List (Header, Operation, Package and Long Texts); Maintenance Plan, Item & Schedule
• Utilized SHDB to load Equipment BOM and all patches after data has been loaded to Production
• SD - User-exits MV45AFZZ to display customer Regional Zone Texts description in the field incoterm2 when Sold-to is different from Ship-to
• Designed and implemented RICEF (Reports, Conversions, Interfaces, Enhancements and Forms) documentation standards: Conceptual Design, Technical Design, Data Mapping, Execution Process and Sign-Off
• Verified the final upload data for duplicates and integrity using Access and Excel
• Analyzed and coded Third Party Vendor Spend Report, YTD MRO Material Purchase Report, Safety Stock Report and Inventory Report using ALV
• Analyzed, programmed and implemented Nafta Registration Form using SmartForms
• Provided technical supports to all Functional SAP, Power-Users, Process and Team Leads
• Initiated and volunteered to gathered and generated 55+ conversions data mapping documents for FI/CO, SD, MM, PM, QM, HR, PS, PP, PROC and EH&S

Confidential,Dallas, TX

SAP Technical Consultant

• Performed and implemented as Basis in creation and modification of Data Dictionary Objects like Tables, Structures, Views, Indexes and performance retrieval for EP (IS-Oil) module
• Analyzed and coded applications for conversion and maintenance of data between EP and Razorfish systems using function modules, dialog event-triggers and ABAP List Viewer (ALV) for IS-Oil module
• Verified and corrected all requests from developers to follow SAP naming standards
• SAP Labs Internal Training Sessions for E&P IS-OIL Module (Upstream) Version 4.6B
• Production System Overview, Production Life Cycle, Volume Allocations, Calculation Methods - Theoretical Calculation Method, Graphical Tool / Energy Integration Platform, Ownership in Upstream Value Chain, Overview of Oil & Gas Industry, Land, Lease and Division Orders, Software Development Life Cycle, Quantity Conversion Interface, Production - Operations and Regulatory Reporting, Sales & Balancing - Production Control, Contract Allocation & Balancing, Joint Venture Accounting (JVA), Valuation, Contracts, Pricing and Invoicing, Revenue Distribution - Accounting and Taxes