We provide IT Staff Augmentation Services!

Sr. Sap Data Migration Consultant Resume

5.00/5 (Submit Your Rating)

Houston, TX

SUMMARY:

  • Over all 10 years of IT experience with 7 years of SAP Data Migration experience in SAP BODS - Data Services
  • Worked extensively with 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
  • Data Services
  • BPDM
  • SAP FI/CO, PM, PRA
  • 2 Full SAP Implementation
  • Technology Development
  • Data Integrity & Recovery
  • Master Data Management
  • Data Integration
  • Mentoring & Coaching
  • SAP 4.7 / ECC 6.0
  • S4 HANA
  • SAP Info Steward 4.2
  • EIM (MDM, Information Steward)

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SAP Data Migration Consultant, Houston, TX

Responsibilities:

  • Perform Master Data Management daily operations and projects (e.g. SAP rollout) across the key dimensions of Governance, Daily Maintenance, Data Quality, and Operational Requests/Projects.
  • Worked on Data migration from legacy systems to SAP S/4 HANA Systems. Data migration using SAP’s BODS (Data services) and LSMW.
  • Responsible for testing new functionality, work with the architect to test and implement enhancements/new functionality as determined. Work with the architect to monitor workflows, run test scripts, clean data objects in the master data management system
  • Strong understanding of SD/OTC/PTP as well as integration points with FI/CO and WM.
  • Developed complex mappings in SAP BODS to load the data from various sources into the Data Mart using different transformations like Query, Table Comparison, Merge, Pivot, Reverse Pivot, Lookup, Key Generation, Data Generation, History Preserving, Map Operation and Validation.
  • Experienced with Data Quality Management Metadata Management, Master Data Management, Process Modeling, Data Dictionary, information Stewardship, Data Profiling, Data Quality, and Data Model Standards.

Confidential

Sr. SAP Data Migration Consultant, St. Charles, IL

Responsibilities:

  • Created LSMW load programs
  • Provided business and junior consultants with knowledge of Data Profiling (Information Steward), Sourcing, Cleansing, Construction, Migration, Transformation and Reporting (Cransoft and SAP Data Services BODS).
  • Created Users and granted privileges in CranSoft that required access to EZ Map.
  • Designed and implemented SAP HANA data modeling technics using Analytic View, Attribute View, and Calculation Views.
  • Worked with SAP Data Services (BODS) in conjunction with 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 with 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 with full consistencies checked.
  • Worked extensively with 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 with client

Confidential

Sr. SAP Data Migration Consultant, Austin, Tx

Responsibilities:

  • Primarily responsible for Material Master along with Transactional data objects under the PTP Modules.
  • 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 Data Integrations.
  • 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 with 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 complex SAP Data Services (BODS) Data flows / Workflows using 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 with 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 with 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, Houston, TX

Responsibilities:

  • Gathered business requirements from all functional teams and business partners for FI, MM, SD (PTP), HR, Solution Manager and BW.
  • Practiced Agile methodologies to Increase business value and faster ROI
  • Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
  • 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 with ABAP team on custom load programs.
  • Imported custom functional modules to load into custom tables directly from Data Services.
  • Mapped requirements for conversion objects with data analyst.
  • Designed, tested, and documented IS (Information Stewart) Projects, along with 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.

Confidential

SAP Data Migration Consultant, Houston, Tx

Responsibilities:

  • Utilized Rapid Deployment Solution, BPDMs and customized Jobs to migrate data with 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.
  • Designed and developed advanced data duplication solution with 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 with specific security based on their roles.
  • 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, San Antonio, Tx

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 with the ASAP methodology.
  • Conducted Blueprint workshops to gather business requirements and make the client familiarize with SAP processes.
  • Proficient with Confidential ’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 with End to End, functional, regression and UAT testing.
  • Worked with CS Teams, Project Management, Creative Team and Design Team to gather reports.
  • Used SQL queries to retrieve data and perform compatible data analysis, backend to frontend.

Confidential

Quality Assurance Analyst, Nashville, TN

Responsibilities:

  • Created test plan, test sets and test cases utilizing Confidential ’s Quality Center (ALM)
  • Worked as an ALM’s backend admin to create new Domain and Projects in Site Admin along with setting up projects, applications, users roles and permissions
  • 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 Principals.
  • Supported client's UAT testing, provided assistance in resolving issues related to several backend systems.
  • 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 .
  • Collected and analyzed the Test Metrics and then submitted the reports to management.
  • Designed and implemented material for UAT team. Highlighting upgraded enhancements and new functionality

We'd love your feedback!