• Developed Electronic invoice with generate QR code for the invoice using 10g Reports.
• I am part of a team how is responsible for a new system implementation in HIS.
• Create WEB service to send SMS from APEX using API and procedure.
• Developed multiple systems in front office development using Forms 10g/9i/6i,Reports 10g/9i/6i, XML Publisher, SQL, PL/SQL, Oracle 11g/10g/9i/8i for Data modeling.
• Experience in implementing RICE Oracle Reports / Forms, Interfaces, Conversions, Extensions components, XML Publisher Reports.
• 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.
• Customize r12 & 11i Financials standard reports using Oracle Reports as per the user requirements for Supply Chain reports too.
• Design interface programs to facilitate transfer of large volumes of legacy data from flat file to oracle Apps.
• 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 extending support/troubleshooting of Oracle Apps Financials Techno Functional Consultant activities.
• worked on the development of interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports.
• Expertise in Vendor Management to ensure consistency and standardization of IT
Infrastructure across sites and resource base. Responsible for managing and improving the quality and established network of resources and contact in the localization