• 9 years of working experience in SAP Data domain with implementation and production support in interpreting and analyzing data including Data Analytics, Data Warehousing and Data Migration in ETL project.
• Expertise work experience to perform as SAP Data Migration Lead and manage migration project for large manufacturing company.
• Expertise experience and knowledge to migrate data into SAP S4 HANA system from legacy systems and SAP ECC systems.
• Experience in ETL Process of Data Warehouse and Data Migration Project such as Data Extraction, Transformation and Loading into Target Warehouse Database.
• Involved in project preparation phase: Scope document, AS-IS, TO-BE, Fit gap analysis, Audit source system, mock load, prepare fit-gap report.
• Expert level experience in solving Data quality and Data loading issue while executing Data migration project.
• Act as a bridge between source team and functional team and ensuring smooth data migration process.
• Requirements gathering from client as per business, conclude blueprinting, analyze the system requirements, provide technical solution by Data Migration strategy, design architecture as per business requirement and provide best possible solution to customer.
• Very good knowledge of Data Modelling, KPI, data analysis, data cleansing,
• data archiving and data validation.
• Very good knowledge of Master data, transaction data and configuration data. Worked on Green field and Brown field projects.
• Support the cut-over planning in different projects. Monitor data and cut-over progress and communicate to the project manager, functional consultant, and business analyst.
• Very good functional knowledge of SAP SD and an overall knowledge of SAP MM, PP, FI, and CO modules.
• Good knowledge of various migration objects of SAP FI, CO, SD, MM, PP and
• Good communication skills while dealing with international clients of USA, UK, Australia, and Europe.
• Performed as Data Migration lead while performing Project manager role in multiple project phase and manage migration team.
• Involved in calls with Business analyst to get the clarity on the requirement.

Software & Tools

• Advance Excel ? Power Query - Very Good
• SQL - Very Good
• SAP BODS 4.2- Excellent
• SAP ABAP 4.0 - Very Good
• SAP LSMW- Excellent
• SAP S4 HANA Cockpit - Excellent
• SAP BW - Good
• SAP S4 HANA Sales -  Good
• Java Script Very Good
• SAP Information Steward -  Good
• SAP Analytics Cloud -  Good

Professional Experience

SAP Data Migration skills ? LSMW & Migration Cockpit

• Worked in LSMW and HANA Migration cockpit to design and development of data migration project for master data and transactional data into SAP ECC and S/4 HANA(target systems) from legacy system, and SAP ECC (source system).
• Applied expert level knowledge of Power Query with the help of advance excel to perform data cleansing and data validation for preparation of source file of LSMW and Migration cockpit.
• Involved in defining the validation rules and bind those rules to against the specific columns of SAP check tables with help of ABAP code.
• Worked on LSMW direct input and IDOC method to load bulk data into SAP target system.
• Use rule and write ABAP code to handle complex transformation.
• Worked on Migration objects in LTMC and Fiori apps.
• Created user defined custom migration object in LTMOM to handle the complex custom function module in target SAP system.
• Adding Z-filed(custom field), hiding fields in the standard migration object in LTMOM.
• Load bulk data into staging tables from flat files using HANA Studio.
• Worked on the debugging of ABAP code in LSMW.
• Build Data Reconciliation reports and IDOC error report.

Data Cleansing & Data Quality ? Power Query

Applying the use of Advance excel and Power Query formula is specially required when we do not have scope to use a 3rd party tool(like SAP BODS) for data cleansing and data quality improvement

• Capable to extract data from various legacy source system such as csv, excel, XML, website, database, and cloud storage into power query editor.
• Cleans the data(bad data) and improve data quality by applying standard function of power query. Write custom M code to handle complex data transformation.
• Change data quality by applying Pivot, V-lookup, Join, split, replace, decimal conversion, append, group by etc.
• Handle format validation and mandatory validation by applying custom if then else logic.
• Finally prepare cleaned structured source files for LSMW and Migration objects.

SAP Data Migration skills ? SAP BODS

• Worked in SAP BODS to design and develop Data Conversion jobs for migration of master data and transactional data into SAP ECC and S/4 HANA(target systems) from legacy system and SAP ECC(source system).
• Post data directly into S4 HANA from SAP BODS by calling BAPI and IDOC.
• Experience in publishing Batch Jobs and implementation of Performance Tuning on Dataflows, Source and Target.
• Create multiple data store configuration in Data services local object library with different database to create unified data store.
• Working experience knowledge of Data quality and Data quantity and act accordingly while executing the project.
• Involved in preload validation before data migration & post load validation after data migration.
• Prepare Reconcile report by using BODS job, which help to reconcile data after migration.
• Worked on various transformation available in SAP BODS such as Query, Case, Merge, Row_Generation, Key_Generation, Pivot, Reverse Pivot, Validation and Lookup_ext. Write SQL transformation to handle the complex business logic.
• Handled XML file by using XML Pipeline and Query transform.
• Cleansed, map, and perform data analysis on all data being extracted by defining data validation rules. Excellent working experience to resolve data missing issue.
• Used ABAP Data flows and Data partitioning method to handle the huge volume of data.
• Worked on repositories configuration to establish the connection with source systems.
• Scheduled jobs, managed users and repositories in Management Console.
• Extract SAP tables using BODS, validate and transformed data and
• load into target system or generate LSMW files for target SAP system.
• Worked closely with ABAP team members to deliver needed data for testing, reporting, and to deliver the solution to client.
• Data load into staging table using SAP BODS.
• Build Data Reconciliation reports and IDOC error reports.

Agile Project Management and other skills

• Working experience in Agile methodologies to track development progress and update the project manager on the progress of the project.
• Patriciate in Agile Sprint backlog grooming, sprint planning and Sprint review in Sprint Retrospective.
• Used Jira as Scrum tool for Scrum task board and work on user stories.
• Work with Business stakeholders to define project scope, objectives, and prioritization.
• Responsible for participating and driving effective scrum ceremonies including daily scrum, backlog grooming, sprint planning, review, and retrospectives.
• Creation of POCs, Functional Documents, Technical Design Documents, and Unit Test documents as per business requirements.

Employment History & Designation

07/2023 ? 02/2024:

Customer: Arcondis ? Thesis - Frankfurt, Germany 

12/2021 ? 06/2023:

Customer: SAP ? Par-Time - Walldorf, Germany 

03/2016 ? 09/2021

Role: Consultant, India

Customer: HCL Technologies LTD

01/2012 ? 03/2016:

Role:  System Engineer, India

Customer: Tata Consultancy Services