SUMMARY:

• Over 7 years of experience in Oracle Applications Implementation, Customization and Supporting Projects.
• Expertise includes customization and testing of applications involving Oracle Applications Order Management, Payables, Accounts Receivable, General Ledger, Purchase Order,INVENTORY.
• Good knowledge in AOL modules like System Administrator and Application Developer in registering concurrent programs, forms, functions, menus, reports and creating value sets,DFF’s, profile options, printers in providing support to Business Users in resolving technical issues.
• Experienced in developing Interface/Conversion Programs in AP, AR, OM, INV, GL, PO Modules in importing data from legacy systems to oracle base tables using SQL * Loader andUTL_FILE Packages.
• Experienced in Developing API’s like OM API to import orders from legacy system to OM base tables and TCA API to import Customer Information from legacy system.
• Responsible for understanding and analyzing RICE (Reports, Interfaces, Conversions, Extensions) Component Methodologies.
• Experience in Developing and customizing Reports using Reports 10g/9i/6i, XML Publisher and Discoverer 10g/9i/4i.
• Expertise in Customizing Oracle Forms with Forms Personalization, Custom.pll, Template.fmb on Forms 10g/9i/6i.
• Experienced in Customizing Workflows in Oracle OM Module.
• Good exposure to P2P and O2C cycles.
• Strong programming knowledge in creating Procedures, Functions, Packages, Triggers, Cursors and registering them as Concurrent programs and other database objects using SQL, PL/SQL and UNIX Shell Scripts.
• Wrote Technical Documentation Specifications like MD070 and Conversion Mapping CV060 using AIM Methodology.
• Good programming knowledge in Oracle 8i/9i and pl/sql using TOAD, SQL * plus, SQL Navigator and also having good knowledge in Shell Scripts.
• Good debugging skills and good at using Exceptions and Error Handling.
• Strong Analytical, Diagnostic and Troubleshooting skills and ability to work in a dynamic, team-oriented environment.Worked as a single point of contact for Reporting projects.

ERP Modules: Oracle Applications R12, 11.5.10, 11.5.9, 11.5.4, (OM, AR, PO, AP, GL, Inv)

Database: Oracle 11g/10g/9i/8i.

Tools: Work flow Builder 2.5/2.6, Developer 2000/10g(Forms, Reports), Discoverer 10g/9i/4i, XML Publisher, TOAD, SQL * Loader, SQL Navigator, SQL * Plus.

Utilities: Secure CRT, Winscp, Putty, Humming Bird.

Languages: SQL, PL/SQL, Shell Scripts, C, JAVA, HTML and XML

Operating Systems: UNIX, Sun Solaris, Windows-95, 98, 2000, 2003, 2007, Linux, Windows-NT

Professional Experience:

Confidential Aug ’11-TillDate
Atlanta GA
Role: Oracle Applications Developer
Responsibilities:

• Involved in conversion/interface programs to validate and to load data from staging table to interface tables related to Order to Cash Cycle.
• Imported order information from legacy system to OM base tables using SQL * Loader with API’s and Interface Programs.
• Involved in importing Customers from legacy system to Oracle base tables using SQL * Loader and Customer Conversion interface.
• By using SQL * Loader program the data from third party source was moved to base tables with the help of staging tables and also API’s.
• Expertise in using UTL_FILE Package in moving data from legacy system to Oracle Base tables.
• Responsible for importing some of the items in the inventory module using Mtl_System_Items_Interface.
• Worked on workflows in doing customizations in sending Message notifications.
• Responsible for creating concurrent program Scheduling mechanism.
• Custom report development & modified to existing ones in different modules.
• Designed and developed Pick Slip Labels report, Packing slip Labels report according to the requirement.
• Developed and customized Reports as per business requirements in Accounts Receivables, Order Management using Repots 6i and XML publisher
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM)
• Extensively worked on Discoverer Admin and Discoverer Client Machine in generating reports as per the requirement.

Environment: Oracle Applications 11.5.10 (GL, AR,OM, INV), Windows, Unix, Window NT, Oracle 9i, Reports 6i, Forms 6i, Discoverer 10g, TOAD, SQL*Loader, PL/SQL, SQL* Plus and XML publisher .

Confidential Jul ’10 – Jul ’11
Louisville KY
Role: Oracle Applications Technical Consultant
Responsibilities: 

• Developed packages to validate and to load data from staging table to interface tables related to procure to pay life cycle
• Developed interface program to import items from the legacy system to Oracle Inventory by creating staging tables
• Developed an interface to load external data from legacy system using SQL* Loader into AP_SUPPLIERS_INTERFACE and AP_SUPPLIER_SITES_INTERFACE Interface Tables
• Developed GL Interface for importing journals from Legacy systems to load into GL_INTERFACE table
• Responsible in creating new suppliers, supplier groups, Pay groups, and Payment terms as per payable options along with Bank Accounts in Accounts Payables (AP)
• Responsible in creating updated information of customer from data files using TCA API
• Customized forms in AP, Purchasing, Inventory modules using custom.pll and form personalization
• Developed and customized Reports as per business requirements in Accounts Payables, Purchasing and General Ledger using Repots 6i and XML publisher
• Worked on Suppliers payment history report, Invoice Aging Report ,Invoice Audit Report in AP.
• Extensively worked on XML Publisher, and used APIs in XML publisher to generate custom reports
• Extensively involved in developing Technical Design Documents (MD70) using Application Implementation Methodology (AIM)

Environment: Oracle Applications R 12.1.3 (GL, AP, Purchasing, INV), Unix, Oracle 10g, Reports 10g, Forms 10g, Discoverer 10g, TOAD, SQL*Loader, PL/SQL, SQL* Plus, XML publisher

Confidential Sep ’09-Jun ‘10
Indianapolis IN
Role: APPS Developer
Responsibilities:

• Extensively worked on EDI Oracle e-Commerce Gateway in the integration between the Oracle E-Business Suite and third party application using Translator ASC X12.
• Developed both inbound and outbound programs.
• Developed interfaces and custom packages based on the clients requirement and also involved in setting up of system for testing purposes.
• Interfaces were developed for data migration into temporary tables from the Legacy system, and later into the respective Oracle Application tables
• Report Development and modifications to existing ones
• Created an executable for reports and registered it as Concurrent Program and then attached it to the request security group.
• Custom report development & modified to existing ones in different modules.
• Designed and developed Pick Slip Labels report, which prints the pick slip labels on a pre formatted stationary in a continuous format.
• Designed and developed orders on hold shipped report.
• Wrote coding for Out Bound Interface for Open Orders
• Daily Open orders extract procedure is coded using UTL_FILE that will write all the order details, reservations.
• Developed Reports with XML Publisher according to the client’s requirement.
• Designed and developed inventory aging report to show the aging details in inventory.
• Designed and developed inactive and other report.
• Developed Reports Order Management using Oracle Reports 6i and Discoverer9i.

Environment:Oracle Applications 11.5.9(OM, AR, INV, AOL), Oracle Workflow 2.6, Oracle Reports 6i, Discoverer 9i, TOAD, SQL * Loader, UNIX, PL/SQL and Oracle 9i.

Confidential, St. Paul’s, MN Jun ‘08– Aug ‘09Role: Oracle Applications Technical Consultant.Responsibilities:

• Developed PL /SQL packages, procedures, functions for interface program to validate the data for AR, and AP, GL modules
• Involved in entire process of development and testing of AR_Customer_interface
• Developed PL/SQL script to Import Customer Invoices into Invoice Interface tables and imported into base tables using Auto Invoice Import Program
• Worked on Auto Lock box Conversion Program in Account Receivables
• Converted the customer information from legacy system into oracle Applications using custom programs and APIs to effect the HZ tables in TCA
• Developed an interface to load external data from legacy system using SQL* Loader into AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE Interface Tables
• Developed PL/SQL Program to load Journals from the legacy system(Pro business) into GL Interface Tables
• Integrated customized forms into Oracle Applications and added new forms and registered in Oracle applications
• Worked on Journal batch summary report, Trial balance report in GL
• Customized Aging bucket and Customer reports, invoice_Payment_Report in Accounts Receivables module
• Collected reporting requirements for implementing Discoverer 4i, created end user layer, 
  business areas and various reports using Discoverer

Environment: Oracle Applications11.5.3 (PO, AP, GL, INV, AR) Oracle 8i, SQL* Plus, SQL*Loader, PL/SQL, TOAD , Reports 6i, Forms 6i, Discoverer9i, Windows 2000 and UNIX.

Confidential NOV 06-MAY 08Role: Oracle Applications Technical Consultant.Responsibilities:

• Responsible for developing PL/SQL Procedures, Functions, Packages, Cursors and Triggers.
• Developed stored procedures using advanced PL/SQL Packages, Nested Tables, Index Tables, Varrays, Record Types, and Dynamic SQL.
• Responsible for Registering Reports as Concurrent Programs and created value sets as parameters as per the requirement.
• Interacted with Business Users in solving technical issues.
• Created tables, Synonyms, Sequences, Views, PL/SQL Stored Procedures and triggers.
• Expertise in using SQL * Loader to Extract data from flat files.
• Involved in writing Conversion programs for importing data from Legacy System to Custom Tables.
• Expertise in using Oracle Advanced Collections like BULK Collections and Bulk Binds in improving the performance of the programs.
• Preparation of Documentation for developed objects helpful for end users.
• Customized Customer, Invoice Register Reports in Oracle Applications according to the client requirement and registered as a Concurrent Program.
• Involved in writing Packages and Procedures for Conversion of data from legacy System to Oracle Base tables.
• Extensively worked on UTL_FILE Packages in Reading and Writing Data to Flat files.
• Developed Various UNIX Shell Scripts in executing various Concurrent jobs.
• Environment: Oracle Applications Release 11.5.4 Oracle 8i, UNIX, Forms 6i/Reports 6i, PL/SQL, SQL*Loader and Toad.

Confidential APR 05-OCT 06Role: Oracle Programmer.Responsibilities

• Responsible for creating the Database tables, indexes, constraints in Oracle 8i.
• Involved in Study and Design of Database.
• Extensively worked on UTL_FILE Packages in Reading data from data files and put them in database tables.
• Developed PL/SQL Packages, Procedures, Triggers, Cursors and Functions according to the requirement.
• Involved in writing triggers in validating the data while importing it from data files.
• Created Database tables, views and indexes.
• Invoices are imported from the Excel sheets to the Oracle Database using SQL * LOADER
• Developed Reports as per client requirement.
• Involved in creation of SQL scripts.
• Developed Forms as per client requirement.
• Tested the objects and matched them with the desired results.
• Expertise in Debugging Skills in handling Exceptions and error handling.

Environment : Forms 6i, Reports 6i & Oracle 8i, Toad, SQL * Loader.