Data Migration Sap Bods

AMIT KASHYAP

SAP DATA MIGRATION CONSULTANT

Gurugram, Haryana, IN *****************@*****.*** +91-870******* SUMMARY

SAP Data Migration Consultant with over 5 years of experience in data migration, ETL process design, and cross-functional team collaboration. Proficient in data mapping, job scheduling, performance tuning, reconciliation reporting, and error handling using tools such as SAP BODS, SAP GUI and SAP Migration Cockpit. Demonstrates a strong focus on documentation, communication, and teamwork to ensure successful strategic data migration. Proven track record in optimizing SAP BODS Jobs and enhancing system performance, with a commitment to staying current with the latest technologies. EXPERIENCE

• Experience in end-to-end data migration projects from SAP ECC to S4 HANA using SAP BODS and LTMC for ETL processes, mock loads, and reconciliation reporting

• Conducted pre-migration analyses, data mapping, and validation of transformation rules.

• Proficient in administering SAP BODS environments, managing repository configurations, job migrations, system upgrades and user security management.

• Skilled in implementing data extraction, transformation, and loading from legacy systems to target systems using SAP BODS and SLT Server.

• Expert in configuring and optimizing data stores and system configurations.

• Experienced in executing, monitoring and scheduling BODS job using DSMC.

• Skilled in implementing error handling and recovery strategies for BODS jobs.

• Effective in coordinating system maintenance/downtime and minimizing project disruptions.

• Proficient in decommissioning outdated BODS jobs and servers and Information Steward (IS) rules.

• Capable of preparing detailed documentation for data migration and ETL processes.

• Experienced in collaborating with stakeholders, functional teams, and IT departments to align requirements.

• Provides training and support on SAP BODS and data migration best practices.

• Proficient in managing service requests, incidents, and change requests using ServiceNow and BMC Remedy.

• Experience tracking project progress using Azure Boards and participating in Scrum meetings and sprint reviews.

• Awarded the Delivery ACE Award for automating development processes and consistently meeting deadlines.

• Honoured with the "Star of the Quarter" award for exceptional production support and problem resolution.

SKILLS

• Tools: SAP BODS 4.2, SAP SLT Server, SAP GUI, SAP Migration Cockpit, LSMW

• Databases: MS SQL Server, Interactive SQL, Hive/Impala, Cloudera Data Lake, Amazon S3

• Collaboration: Azure ADO Board, ServiceNow, BMC Remedy, WinSCP

• Platforms: Windows

EDUCATION & CERTIFICATIONS

• Bachelor of Technology in Computer Science & Engineering - (2015-2019)

• Certification :

o SAP Certified Application Associate – Data Integration with SAP Data Services 4.2 o OpenSAP – Generative AI at SAP

o Cognizant Certified Frontline Leaders People Leadership Program o Microsoft Azure Fundamentals & Azure Data Fundamentals PROJECTS

Project #1

Project title : Philips ADM Migration

Duration : August 2024 – Present

Role : SAP Data Migration Consultant

Tools Used : SAP LSMW, SAP GUI, Syniti ADM, SQL Server Roles and responsibilities:

• Utilized batch input recording with SAP LSMW for Installed Base and Service Contracts updates, and conducted data comparisons with Excel, delivering reports to stakeholders.

• Supported ADM job execution and Informatica workflows for weekly report generation.

• Generated data validation reports using Syniti ADM and SQL Server. Project #2

Project title : Brightspeed Data Migration

Duration : September 2022 – July 2024

Role : SAP Data Migration Consultant

Tools Used : SAP BODS 4.2, 4.3, SAP Migration Cockpit, SAP GUI, ServiceNow Roles and responsibilities:

• Developed ETL processes for migrating Profit Center, Cost Center, and GL Accounts, managing end-to-end data migration with SAP BODS and SAP Migration Cockpit (LTMC) from SAP ECC to S4 HANA.

• Conducted pre-migration preparations by analyzing source and target structures, and validated mapping conditions and validation rules based on the Functional Mapping Document.

• Designed and implemented data extraction, transformation processes, and staging table population using SAP BODS, loading enriched data into the SAP S4 HANA via LTMC.

• Configured data stores for seamless connectivity between source, staging, and target systems.

• Utilized Data Services Management Console to execute/monitor jobs and effectively manage the data migration workflow.

• Performed multiple mock loads and a dress rehearsal with progressively larger datasets before the production go-live.

• Generated valid and invalid reports, as well as preload and reconciliation reports using BODS.

• Managed system upgrades and downtime, coordinating with IT teams to minimize impact on migration projects.

• Conducted comprehensive testing and troubleshooting of data migration processes.

• Executed mock loads for Fixed Assets using LTMC, focusing on the loading process.

• Monitored overnight data loads, diagnosing and resolving issues, and rerunning jobs as needed.

• Prepared detailed Technical Specification Documents for various data migration objects. Project #3

Project title : Sanofi IMS Support

Duration : Dec 2021 – August 2022

Role : SAP BODS Admin & Support

Tools Used : SAP BODS, SAP DSMC, SAP CMC, BMC Remedy Roles and responsibilities:

• Configured Central and Local repositories in SAP Data Services Repository Manager and CMC, and managed user passwords, including changes when expired.

• Administered user roles, security, and access controls for Designer, Repositories, Information Steward, and DSMC Console as required.

• Managed BODS job migrations via ATL files in Designer, while scheduling, monitoring, and optimizing job execution and resource usage through Data Services Management Console

(DSMC).

• Configured BODS Job Servers, monitored their status and performance, and implemented multiple servers for load balancing and failover.

• Configured, managed, and updated data stores as part of service requests.

• Managed address directories across development, QA, and production environments.

• Decommissioned BODS jobs, Information Steward Rules, and BODS Servers.

• Deployed jobs and rules, and set up scorecards in SAP Information Steward.

• Performed server maintenance and monitoring, ensuring system stability.

• Documented system configurations, procedures, and changes, and provided training to team members on BODS features, best practices, and troubleshooting techniques.

• Led service and incident management through BMC Remedy, consistently meeting SLA targets. Project #4

Project title : SAP Data Ingestion Service Line

Duration : Aug 2019 – Nov 2021

Role : SAP BODS Developer

Tools Used : SAP BODS, SAP SLT Server, SAP GUI, Interactive SQL, ServiceNow Roles and responsibilities:

• Designed and developed ETL jobs, workflows, data flows, data stores, transforms, and functions using SAP Business Objects Data Services (BODS) 4.2. Implemented data extraction from diverse sources and loaded them into target systems, including Amazon S3 buckets, HDFS, and Azure Blob Storage, leveraging SAP ECC as the primary data source through SAP SLT.

• Configured data stores, file formats, global & local variables, parameters, substitution parameters, and system configurations within SAP BODS.

• Collaborated closely with business stakeholders to comprehend complex business logic and successfully implemented it.

• Implemented robust error handling mechanisms and managed data recovery from failed sessions.

• Utilized the Data Services Management Console (DSMC) for scheduling, executing, monitoring, and managing ETL jobs, including comprehensive error handling and system oversight.

• Managed ETL job migrations through Central Repositories and ATL files.

• Maintained thorough documentation of ETL processes. Utilized tools like ServiceNow to manage incidents, service requests (SR), and change requests (CR).

• Contributed to service improvements by actively engaging in housekeeping activities, system upgrades, transport, downtime activities, and monitoring system performance.

Contact this candidate