Udit Sharma

Infosys Limited

Pune, Maharashtra

02.2018 - Current

Extracted data from Database, transformed it and loaded the data to S/4 HANA.
Developed the jobs as per the requirement and provided the data in Flat file format.
Loading of data into S/4 Hana from Flat files, Excel Sheets and XML files.
Extensively used the Query, Case, Validation, Merge and Row Generation Transforms to transform source data to desired output.
Used Substitution parameters, Global variables, Local variables and Parameters to define the values which will be defined for various objects in BODS.
Developed workflows to reconcile the valid data to move them to the right target folder.
Enhanced the jobs performance to load the data into existing tables.
Experience in implementation of Recovery Mechanism for unsuccessful batch jobs execution.
Created Batch daily jobs to load the delta data on Hourly basis so that the end users consume the data very frequently.
Performed Error Handling by using try and catch to identify various kinds of issues.
Designed and developed ETL routines in BODS using JAS.
Develop ADHOC JSFs to execute SPs.
Develop time based and event based JSF to execute a BODS job to load data from flat file.
Fixing production support issues related to multi-provider mapping, data inconsistency, and job failures.
Creating SPs in Hana as per user requirement.
Prepared detailed reports on updates to project specifications, progress, identified conflicts and team activities.