Wrote Package containing several Procedures and Functions in PL/SQL.• Created the indexes and analyzed the table for better performance.• Involved in the continuous enhancements and fixing of production problems.• Created PL/SQL stored procedures, Cursors, and Triggers as per the Businessrequirements.• Created scripts to create new tables, views, queries for new enhancement.• Providing application maintenance and enhancement support to the client

Coordinated with the front-end design team to provide them with the necessarystored procedures and packages and the necessary insight into the data.• Worked on SQL*Loader to load data from flat files obtained from various facilitiesevery day.• Involved in the continuous enhancements and fixing of production problems.• Generated server-side PL/SQL scripts for data manipulation and validation.• Developed PL/SQL triggers and master tables for automatic creation of primary keys.• Created PL/SQL stored procedures, function sand packages for moving the data fromstaging area to data mart.• Used Pragma Autonomous Transaction to avoid mutating problem in databasetrigger.