SUMMARY

• Over all 10 years of IT experience wif 7 years of SAP Data Migration experience in SAP BODS - Data Services
• Worked extensively wif Data Extraction, Data Profiling, Data Quality (DQM), Data Cleansing, Data Enrichment, LSMW, BDC, and BAPI & IDocs.
• Configured and installed SAP BODS, Job Server, Central and Local repositories.
• Experienced in different SAP BODS BPDMs, Transforms & Functions.
• Proficient in creating Jobs, Workflows, Dataflows, Query and other Transforms in SAP Data Services (BODS)
• Excellent in implementing and testing of Stored Procedures, Views, Packages, Database triggers, cursors and functions at database level.

TECHNICAL SKILLS

• Strategic Business Planning
• Info Management Strategy
• Business Impact Analysis
• Enterprise Architecture
• Contingency Planning
• Change Management
• Risk Assessment
• 6 years Project Management Experience
• Go-live Cutover Plan
• Info/Data Architecture
• Solution Architect
• Data Governance
• Business Architecture
• Business Intelligence
• Big Data / SAP HANA
• SAP BODS - Data Services
• RDS - BPDM
• SAP FI/CO
• PM
• PRA
• 2 Full SAP Implementation
• Technology Development
• Data Integrity & Recovery
• Master Data Management
• Data Warehousing
• Mentoring & Coaching
• SAP 4.7 / ECC 6.0
• S4 HANA
• SAP Info Steward 4.2
• SAP - EIM (MDM
• Information Steward)

PROFESSIONAL EXPERIENCE

Confidential, St. Charles, IL

Sr. SAP Data Migration Consultant

Responsibilities:

• Created LSMW load programs
• Provided business and junior consultants wif knowledge of Data Profiling (Information Steward), Sourcing, Cleansing, Construction, Migration, Transformation and Reporting (Cransoft and SAP Data Services BODS).
• Created Users and granted privileges inCranSoft that required access to EZ Map.
• Designed and implemented SAPHANAdata modeling technics using Analytic View, Attribute View, and Calculation Views.
• Worked wif SAP Data Services (BODS) in conjunction wif DSW.
• Utilized SAP Data Services (BODS) as an ETL tool for various objects.
• SAP Simple FI the new SAP FI module on S4/HANA platform
• Used DSP to create conversion programs
• Good knowledge in Data services 4.2 and worked on different Transport method, Shared directory, RFC and custom transfer to import the data from SAP ECC.
• Worked wif Agile and Kanban methodologies to support continuous development.
• Used/Created DSP Collect packages to bring in Data from the Legacy SAP system
• Set up and used SAP Rapid Deployment Solutions (RDS) to load data via iDOCs
• Setup DSP MAP for the business to go in create mappings
• Extensively utilized LSMW to create and modify BAPI to load object.
• Able to design any LSMW loaders wif full consistencies checked.
• Worked extensively wif DSP Transform to create the rules
• Generated complex conversion rules in DSP Transform from multiple Data Sources
• Created Pre-Load and Post-Load Reports
• Generated error reports for business to rectify legacy data errors
• Created complex DSP Construct pages so that business could provide data to be loaded in ECC
• Conducted mapping meeting wif client

Confidential

Sr. SAP Data Migration Consultant

Responsibilities:

• Primarily responsible for Material Master along wif Transactional data objects under the PTP.
• Created Pre-Load and Post-Load reports for Master and Transactional objects
• Created SAP Data Services jobs for the following objects: Customer Master, Open AR/AP, and GL Balances and Asset data.
• Involved in complete life cycle of a data migration from blueprinting to go-live
• Supported team member on other Master Data Objects (Customers and Vendors).
• Worked wif SAP Supply Chain Management to provide data solutions that cover planning, networking and coordinating.
• Guided the business and SI team members in building valuable Functional Specs.
• Responsible for creating Technical Specs that will be fully understandable by offshore resources.
• Built conversion jobs that aligned to design of T-Spec.
• Responsible for developing complexSAP Data Services (BODS) Data flows / Workflowsusing different types of transforms like Query transform, Table compare transform, Case transform, Map operation, Merge, History preserve and key generation transform based on the business requirements.
• Responsible for optimizing all jobs for all conversion objects. Saving the client numerous hours of processing time.
• Creating jobs using SAP Data Services (BODS) to extract and transform data from the source systems to the target SAP and load via Winshuttle tool.
• Managed and generated complex validation rules in BODS (SAP Data Services) from multiple Data Sources to fulfill the client’s business requirement.
• Provided continuous support to business during Mock Validation
• Generate complex Workflows and Jobs in BODS from multiple data sources to fulfill business requirements
• Utilized Rapid Deployment Solution, BPDMs and customized Jobs to migrate data wif SAP Data Services (BODS) for following items: Purchase Orders, DMS, Inventory, PIRs, Misc. PRTs, Batch Master, Work Centers, EWM Stock Transfer, Product Master, Storage Bins, and Inspection Rules.
• Created Error Reports for business to cleanse legacy data issues
• Worked on transformation strategies, creating matching rules to identify material matching and identifying duplicates.
• Trained team members on the ETL processes.
• Used LSMW as the standard data loading method.
• Trained GM team members on the data extraction process and reviewed lessons learned
• Worked wif resource from GMIT, BMK and other vendors to gain knowledge of existing process and new processes under GPC command.

Confidential

Sr. SAP Data Migration Consultant

Responsibilities:

• Gathered business requirements from all functional teams and business partners for FI, MM, SD, HR, Solution Manager and BW.
• Practiced Agile methodologies to Increase business value and faster ROI
• Developed understanding of Upstream/Downstream and Energy trading processes
• Responsible for full Migration cycle of objects across modules including SAP BODS technical and Functional assistance on the project.
• Maintained and controlled the access of the project team members in SAP Data Services in all environments. (Development, Quality, Stage, Production)
• Worked wif ABAP team on custom load programs.
• Conducted code review wif team leads and piers.
• Imported custom functional modules to load into custom tables directly from Data Services.
• Identified dependencies on different objects across tracks.
• Mapped requirements for conversion objects wif data analyst.
• Designed, tested, and documented IS (Information Stewart) Projects, along wif valuable data quality rules, dimensions, and scorecards.
• Provided preload and post load reports to business for validation in a timely manner.
• Assisted business in preload and post load validation processes.
• Managed CR’s and defects for all assigned objects as prioritized by the business.

Confidential

SAP Data Migration Consultant

Responsibilities:

• Utilized Rapid Deployment Solution, BPDMs and customized Jobs to migrate data wif SAP Data Services (BODS) for following items: Purchase Orders, DMS, Inventory, PIRs, Misc. PRTs, Batch Master, Work Centers, EWM Stock Transfer, Product Master, Storage Bins, and Inspection Rules.
• Worked wif onshore and offshore team members
• Designed and developed advanced data duplication solution wif custom stored procedures for large volume for 100% data integrity.
• Assisted in creating a load program using BDC and LSMW.
• Defined target and source rules and validated reports from multiple sources for all assigned objects
• Identified individuals wif specific security based on their roles.
• Created Visio flow charts to display end to end flow between complex legacy, source and target systems. These flow charts will be utilized by the business for future releases.
• Comprehensive understanding of Purchase orders, Items, Allocation, Replenishment, Warehouse, Stores, Direct to Store, Stock Ledger, Invoice matching, e-Commerce, Drop ship, Sales Audit, Forecast history, Sales history and BI.

Confidential

Sr. Quality Assurance Lead / SAP Business Analyst

Responsibilities:

• Worked as a Deployment coordinator lead, on weekly-deployed builds from Test to Stage to Production environments.
• Successfully completed implementation and data migration process following strict compliance wif the ASAP methodology.
• Conducted Blueprint workshops to gather business requirements and make the client familiarize wif SAP processes.
• Proficient wif HP’s ALM Complete tool, to Create Test Cases, Test Sets, Defects tracking, Requirements writing/linking and traceability.
• Coordinated efforts during mocks to support validation.
• Excellent hands on experience wif End to End, functional, regression and UAT testing.
• Worked wif CS Teams, Project Management, Creative Team and Design Team to gather reports.
• Worked on Selenium automation scripts to run regression test cases on production environment.
• Provided support after the application was deployed in production. Performed performance testing and resolved issues related to environment and backend applications.
• Used SQL queries to retrieve data and perform compatible data analysis, backend to frontend.
• Worked wif Global sourcing client in different time zones and countries.
• Coordinated testing efforts and updates wif the Off-shore and off-site teams.

Confidential

Quality Assurance Analyst

Responsibilities:

• Created test plan, test sets and test cases utilizing HP’s Quality Center (ALM)
• Worked as an ALM’s backend admin to create new Domain and Projects in Site Admin along wif setting up projects, applications, users roles and permissions
• Planning estimated work hours on each PIF and creating QS timeline document to meet deliveries.
• Utilized SQL Queries to retrieve date from the databases and use cross analysis to map testing requirements. Supported and coordinated data imports and linked to data mapping
• Knowledge of various integration design patterns such as SOA Design Patterns and TEMPPrincipals.
• Supported client's UAT testing, provided assistance in resolving issues related to several backend systems.
• Analyzed the CR's (Change Request), prepared test cases and conducted internal reviews for any modifications.
• Acted as a SME for Offshore team, involved in daily and weekly online meetings to discuss risk management and migration processes. Once reports were carefully analyzed they were logged on Nfuse tracking system, and results were saved in SharePoint for future reference.
• Collected and analyzed the Test Metrics and tan submitted the reports to management.
• Setup daily meetings to discuss the status of the project and to accelerate resolution for blocking issues to meet project milestones.
• Worked closely wif the BA’s to decompose meaningful requirements defined by government agencies. Provided analytical support for administrative and clinical application.
• Designed and implemented training material for UAT team. Highlighting upgraded enhancements and new functionality