Worked on Packages,Functions,Stored procedure.Used Bulk Collections for better performance and easy retrieval of data.Created PL/SQL script to extract data from Database into simple flat text file using UTL_FILE package.Used Pragma Autonomous Transactions to avoid mutating problem in database trigger.Extensively used the advanced features of PL/SQL like Records,Tables,Object Types and Dynamic table.Developed code fixes and enhancements for inclusion in future code releases and patches.

Developed Advanced PL/SQL packages,procedures,triggers,functions,indexes and collections to implement business logic using SQL.Extracted data from .csv file and loaded into the database.Designed and Developed oracle Form and Reports.Involved in the continues enhancements and fixing of production problems.Designed, Implemented Interfaces using PL/SQL.

Wrote conversion script using SQL,PL/SQL,Stored procedures,functions and packages to migrate the data from SQL Server database to oracle database.Worked on Oracle Apps module SCM(Supply Chain Management) PO,INV,OM and AR.Used SQL*LOADER as an ETL tool to load data into the staging table and used Oracle standard API to migrate the data into Oracle APPS base tables.Worked on Customer conversion,Supplier Conversion,FA conversion and GL Interface.Worked on tables,views,Materialized view,cursor,procedure,packages using oracle tools like TOAD,PL/SQL,SQL*LOADER,SQL*PLUS and handled exceptions.

 Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling. Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation. Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions. Designing & Coding of Procedures, Functions and Packages.