•Expertise in Oracle SQL, PL/SQL. Skilled in Application development using Oracle Forms and Reports with knowledge in master-detail blocks, forms triggers, system variables, multiple form applications, menus, alerts and LOV's.
•Expertise in implementation of Oracle API’s, Alerts, Forms Personalization,
AIM (Application Implementation Methodology) Documents, Data Conversion and Data Migration, Testing, Training, Support, Troubleshooting.
•Worked on solving the behavioral difference issues between 6i and 10g forms debugging the errors.
•Work on the Report Builder & XML reports like Pay slip report, Employee Details, Pay Advice report, Al HR related reports, Status Change Advice, Gosi report, Packing slip report, Sales Invoice reports, quotation reports, Purchase Order reports to make sure they are upgraded from 6i to 10g and displaying the same output as in 6i.
•Create Database Objects like Stored Procedures, Views, Triggers and functions.
•Create PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
•Supervised project team, evaluated performance and suggested improvement.
•Acquired significant experience in SQL Loader, Data Loader and Toad, SQL*PLUS and Oracle PL/SQL, Package Body, Package Specification and PL/SQL Libraries, Procedures and Functions, Database Triggers, Forms and Reports Triggers as well as