Client: ICICI bank pvt ltdProject: OFSAA• Code Changes from gathering the User Requirements to the deployment of code.• ELT process monitoring for Data dump using ELT (ODI) tool.• Possess sound understanding of data warehousing concepts.• Developed CTL files for large set of Data load in Oracle database.• Well versed in writing SQL queries and PLSQL procedures.• Involved in Performance tuning on Cursors, Backend updates converted into mapping etc. on UAT and same has been deployed on Production(as per business requirements).• Developed target tables according to the user requirements and migrated data using SQL Developer Export/Import utility.• Developed Packages, Mappings, Procedures, Variables, Loadplans, SQL and PL/SQL codes according to business requirements.• Developed Unix shell Script to automate mailers and facilitate data processing activities.• Developed DIH connectors for Credit Card on UAT and same has been successfully deployed on Production.

I Interned for Bajaj Finance (Client).Developed complex data handling procedures built in PL/SQL.I was also a part of Data Migration Team(CRM Project) for Induslnd Bank where I have Migrated the data from Microsoft DB to Oracle DB.