Dionsista Corera

SAP BODS Consultant with 8 years of experience in ETL and DATA warehousing

1. Creating/Modifying BODS job to fetch data from different source systems and transform them as per Business requirement and load to the desired target.
2. Involved in daily status call and requirement gathering.
3. Used SAP BW, SAP HANA, Teradata, Oracle, MS SQL Server and Flat File as source and target systems.

1. Designed complex transformations involving hierarchy flattening, history preserving, case, map operation, while loop, table comparison, sql, pivot, validation transform etc.

1. Used scripts within a job to send email notification to the user on the job status along with its details and also attached validation files when required.

1. Created SFTP scripts to send files to server.

1. Performed Unit Testing in DEV and QA environments, documented the results.

1. Executed BODS jobs from Management Console and also automated the jobs to run through AUTOSYS Scheduling tool and also provided technical assistance for automating job in Autosys

1. Worked on defects to resolve various data issues and bug fixed in ETL logic.

1. Optimizing the design to enhance the performance and execution time.

Created Change Request and Service request in Service Now portal for code migration.

B.E degree in ComputerScience & Engineering at KCG College of Engineering, Chennai with a CGPA of 8.13 or 81.3 %.