Integration Lead (ADF, SAP BODS and IICS ) – Level-3
Strong Experience in SAP Data Integraion,DataQuality and Migration using
SAP BODS,SAP EIM, Hana , ADF and SQL. :
Designed, Developed, and supported complex SAP BODS and ADF jobs which extract data from S4Hana, ECC application and load the data feeds to load into Azure SQL db.
Co-ordinated with SAP functional team to develop the extraction logic and data analysis from s4hana and ECC.
Handled several change requests and tested the jobs in all SIT, UAT and deployed the jobs in Production also supported the AMS team post-production and gave training on ETL jobs.
Optimized the performance of complex ETL jobs which extract data from SAP Application. Reduced the execution time from hours to minutes and some jobs to seconds
Designed and developed the ETL jobs with exception handling , error handling and start up recovery.
Loaded the data to S4Hana using LTMC, IDOC Methods (BODS)
Profiled the source system data for finding the data quality issues and resolved the data quality issues using BODS and Information steward.
Developed stored procedures to load, cleanse and standardize the data.
Took the complete ownership of end-to end production support for daily ETL loads and resolved the data issues.
Created batch files and SQL scripts for automation of daily ETL loads.
Worked very closely with SAP functional experts and developed ETL jobs on the fly