SUMMARY

• 8+ Yrs. of experience in SAP Data Services (BODS) with strong exp in data migration. Data conversion and Data Integration.
• Experienced in Bods data Migration for SAP Sources like S/4 Hana (Logistics, Procurement, Purchasing, Pricing & Finance), SAP ECC, SAP MDG, SAP CRM, SAP Retail and have loaded data into SAP MDG, ECC, CRM, SALESFORCE & S4 Hana.
• Have developed Bods code designs for end - to-end developments right from FUT to Post Go-live support in data migration objects like SAP BOMs, Material Master, Open G/L, Cost Center, Routing, Purchase Order & and other Finance Objects.
• Extensively used Match, Associate & Address cleansing transformations for deduplication of master data prior to start data migration in Sap ECC/MDG & S4 Hana systems.
• Responsible for developing complexSAP Data Services Data flows / Workflowsusing different transforms like Query transform, Table compare transform, Case transform, Map operation, Merge and key generation transform based on teh business requirements.
• Provides guidance and advice on SAP Data Migration methodology.
• Provides weekly update reports and measured teh data KPI.
• Advise and assists in data extraction, data cleansing, data mapping, data harmonization, data enrichment, data consolidation, data loading and data reconciliation.
• Drive data migration strategy and process to enable quality data delivery without delays.
• Escalates cross functional issues and identified SMEs required for resolution.
• Proactively identifies project risks and created feasible solutions.
• Having strong Experience in SAP Information Steward 4.2.
• Have created score cards, Score calculation & Match review configuration in Information Steward.
• Having Expertise in working with SAP as a data source and target and have worked with IDocs (Inbound and Outbound) end to end in Data Migration, ODP and BAPI Functional Module and lsmw applications and other Standard Function modules in SAP S4 Hana, ECC, MDG.
• Having strong foundation in Bods data migration through all functionalities in SAP Data Services like Idocs, Functional modules & LSMW (Idocs, Recording & BAPI) and BDC.
• Utilizes Rapid Deployment Solution, BPDMs and customized Jobs to migrate data with SAP Data Services for following items: Purchase Orders, DMS, Inventory, PIRs, Misc. PRTs, Batch Master, Work Centers, EWM Stock Transfer, Product Master, Storage Bins, and Inspection Rules.
• Works with Information Steward to profile legacy data.
• Gathers business requirements from key stakeholders and translate them to a comprehensive data solution design.
• Responsible for data migration and conversion activities such as extraction, transforming, migrating, validating and reconciliation of data. Developed data migration approach and strategies. Provides guidance to internal IT key users to design and develop data loaders / templates to fit teh business requirements. Developed validation programs to cross check all teh data before and after teh data loading. Identifies problematic areas and conducts research to determine teh best course of action to correct data.
• Experience in production support of ETL Job failures, Bods servers, Data replication Jobs, resolving Job failures in a critical environment.
• Having worked with SOAP, REST APIs and ODATA integration with Bods.
• Migrated data for IS OIL PRA, Joint Ventures, Base DOI, Business Associates, Valuation, Delivery Networks and Well Data.
• Designed and developed ETL solutions for SAP IS OIL using SAP Data Services.
• Detailed experience in performing data quality tasks such as standardizing, cleansing, merging, deduping and harmonization for various master data projects.
• Having implemented Real time jobs for master data replication using Web service activation in Bods.
• Able to design LSMW loaders with full consistencies checked.
• In depth and hands-on development experience of using SAP BODS 4.2, LSMW, BDC & IDocs across areas of SAP FI, SD, MM, PP, QM and PM.
• Migrated legacy system to SAP S4 Hana 2020 and SAP MDG platform for master and transactional data.
• Capable of overcoming any project delays, apply proper strategies to ensure teh project schedules are on track.
• Capable of managing unstructured data team to a professional high performance data team.
• Developed migration cutover plan and worked extensively with SQL Server 2012, SSIS Packages, Stored Procedures, and Views.
• Provided business and junior consultants with knowledge of Data Profiling Information Steward, Sourcing, Cleansing, Construction, Migration, Transformation and SAP Data Services, and reporting with BO & Tableau.
• Responsible for full Migration cycle of objects across modules including SAP technical and Functional assistance on teh project.
• Builds ETL architecture and helps junior developers with best practices for data conversion.
• Having strong expertise in DQ (Address Cleansing, Match Transformations, Associate, USA).
• Hands on configuring teh SAP RFC connection and SAP ECC/SAP Hana configuration details to setup teh data store.
• Having experience with Migration technologies like SAP SLT, SAP DS, SAP SDI, LTMC etc.
• Worked with Non-Sap data sources like HDFS, flat files, CSV files, Sales Force etc.
• Having dealt with designing of a job and managed table level changes and object level dependencies and Job level dependent variables and have developed logics for Incremental loads and parallel processing.
• Have done code reviews along with functional analysts and users to find out any defects, flaws, and bugs to be fixed for end-to-end validation before deploying to production.
• Involved in coding best practices and a highest contributor in teh teams in resolving complex issues in Error handling, data loading and data cleansing.

PROFESSIONAL EXPERIENCE:

Confidential

SAP DS Data Migration

Responsibilities:

• Developing Data Migration solutions through Bods for Master data (Material, Business Partner, GL, AR/AP, COST CENTER, Asset Management, Sales Order & Fixed Assets).
• Developing Migration codes for data migration to ECC, SAP MDG & S4 Hana.
• Analyzing teh problem to provide solutions to teh user generated error incidents.
• Interacted with Business Users and Managers in gathering and collating business requirements.
• Worked with business process owners, stakeholders, and Cost Centers to understand and document teh requirements and set up business rules to redesign and reshape teh existing flows.
• Created mappings using Designer and designed workflows using Workflows to build solutions as per business rules.
• Tuned up performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows, data flows and Sql Server target system to provide maximum efficiency and performance.

Confidential

SAP BODS Data Migration

Responsibilities:

• Gathering detailed requirements for OTC, MM and HR objects for data migration & generating reports.
• Worked on Bods scripts, string functions, miscellaneous functions, Boolean expressions, date conversion functions and stored procedures for various data conversion solutions.
• Data migration for CLFMAS, CREMAS, DEBMAS & other transactional data objects through Bods.
• Having dealt with Asset accounting tables and Defect resolving and fixing data errors and sending expected data.
• Data migration from SAP to Hana and vice versa through Bods and development of Information views in Hana.
• Code reviews in different Objects like Enhancements, Bapi and ODP applications and transformed into business scenarios through Bods.
• Code development, Script handling, functions usage and hands on SAP config
• Having worked on HFM data extraction and modelling and Copa Extractions.
• Have loaded data into BW through Bods as per structures format.
• Having developed Real-time jobs and Migration processes for Mass loads in ECC.
• Supporting teh technical team for teh development of objects as per teh requirements.
• Handling incidents related to Job errors.

Confidential

SAP Bods

Responsibilities:

• Have worked in Bods Data Migration from DB2 to SAP TRM & SAP ECC.
• Migrated 20 million of Header chalan and Returns orders from IBM AIX system to SAP.
• Data migration for Sales & Purchase Order, Asset Master, SAP TRM & SD Pricing Objects through Bods.
• Having thorough experience of creating datastores for Web services API, Salesforce SIMBA Integration, Soap APIs, Microsoft Azure, Hadoop & Google Cloud storage.
• Having data extracted from Sap BPC and Sap BW for BI reports and used as a source in Information Steward for rule validations.
• Having worked on deduplication of master data for maintaining consistency and data on live systems using Match, Address & Associate transformations.

Confidential

BODS Data Migration

Responsibilities:

• Gatheird and analyzed teh requirement to replicate teh ECC content in HANA using data provisioning in BODS.
• Worked extensively with Sales & Distribution team to design data migration from Legacy system to SAP BODS.
• Having extensively worked with Information Steward in SAP MDG to create score cards and validation.
• Having used Data Quality transformations like Country ID, Match, Match Consolidate, USA Regulatory Address Cleanse, Associate, Address Cleanse for data quality.
• Developed workflows to load data into Customer Master Sale’s data (KNVV) and Partner roles (KNVP) from legacy systems.
• Developed jobs to load teh legacy system data into COND A04 IDOC (KOMG, KONH, KONP segments) by referencing SAP SD pricing job in Bods.
• Ability to interpret, configure and implement data mapping / transformation business rules into Data Services.
• Performed data modelling and developed Analytical views for teh transactional data, Attribute views for teh master data, and teh calculation views as final model in HANA Studio.
• Developed data models for teh operations, PP, Global sustainment, Quality management tables in HANA.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.2 designer.