Sanskruti Mohapatra

> Experienced in data migration and conversion from various source systems to SAP systems, executing full ETL cycles—extraction, transformation, loading, and validation.

> Utilized Azure Data Factory (ADF) for ETL processes integrating with SAP LTMC for loading and validating data in the SAP application sytems (S/4 HANA)

1. Built ADF Pipelines to migrate data from the files into the staging tables & subsequently into SAP Application layer using LTMC/LSMW Tool

2. Worked with Power Automate to run the flow created for the objects which basically automate the entire process of picking file from sharepoint- >Running the ADF Pipeline->Triggering LTMC job in SAP ->Notifying the users regarding the success/failure of load

3. Implemented dataflows with pre-validation rules to check unique key combination, mandatory field, data type,date formatting leading 0's,default value assignment etc.

4.Utilized Alteryx Designer to transform the raw files into loadable standard format provided by SAP for ADF Consumption

> Experienced in integrating SAP S/4HANA and TPM systems with the HighRadius platform using ADF ETL processes.

1. Built ADF pipelines with robust error logging notification mechanisms, and file archival logic to extract data from SAP systems and load it into HighRadius SFTP locations.

2. Utilized the HEX programs in SAP for extraction of DMS & CAA related interfaces data

3. Worked on creating custom BADI implementations in SAP to fetch the data based on requirements

4. Worked on SQL (T-SQL)scripts in synapse analytics to build the custom objects as per requirement.