Associate Software Engineer
Mumbai Area, India
Moderate experience in Data Conversion, Report Generation and Developing Interfaces within several modules in Oracle Applications.Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.Worked with the business functional areas to research and identify the best technical solution to support business processes.Responsibilities :Developed PL/SQL Packages, Procedures, Functions for validating the invoices and… Show more Moderate experience in Data Conversion, Report Generation and Developing Interfaces within several modules in Oracle Applications.Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.Worked with the business functional areas to research and identify the best technical solution to support business processes.Responsibilities :Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import programand populated into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables.Used Custom PL/SQL API’S for converting open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AR Invoices, Open Purchase Orders from legacy system (Mainframe) to Oracle Applications.Worked on SQL*Loader Scripts to migrate the invoice data from the flat files and populate the staging tables before implementing auto invoice interface.Developed PL/SQL procedures, functions and packages for validating the invoice data before importing it into Account Receivables interface tables. Show less