PROFESSIONAL SUMMARY

• Over 7+ years of extensive experience in analysis, design, development, implementation, support, and maintenance of Oracle Applications (ERP) 11i/ R12 which includes Financial Modules (GL, AP, AR), Oracle Manufacturing & Distribution (PO, OM, INV), I procurement and I Expenses.
• Implementation and technical expertise in Accounts Receivables, Accounts Payables, Inventory, General Ledger, Iprocurement and IExpenses, Purchasing and Order Management modules.. Good exposure to Order-to-Cash and Procure-to-Pay life cycles.
• Expertise in RICE (Reports, Interfaces, Conversions, Enhancements) Components..
• Experience in Creation of the Interfaces to external systems. Creation of Conversion programs to transfer data from a legacy system to the new system.
• Involved in developing auto lockbox interface program to load customer’s payments information into receivables base tables by using SQL loader.
• Expertise in Enhancements (or extensions) to the existing system to add additional functionality to existing system without disturbing the core software functionality of the system.
• Good working experience in Forms 4.5/6i, Reports 6i, PL/SQL, Oracle Database and RDBMS Concepts.
• Experienced in Reports Customization using XML Publisher.
• Extensively worked on Data Conversion, Migrations and Interface Programs (Outbound/Inbound).
• Worked with System Administrator and AOL modules for creating Concurrent Executable, Concurrent Programs and Setting Profile Options as per the requirements.
• Good Knowledge of Oracle Trading Community Architecture (TCA).
• Experienced in Developed Technical Design Documents (MD120, MD70 and CV40) based on

Functional Design Document (MD50, BR100) using Application Implementation Methodology (AIM).

TECHNICAL SKILLS

ERP Modules: Oracle Applications 11i/11.5.6/11.5.7/11.5.9/11.5.10 Application Object Library (AOL), General Ledger (GL), Accounts Payables (AP), Accounts Receivables (AR), Purchasing (PO), Order Management (OM), Inventory (INV),Fixed Assets (FA), I procurement and I Expenses.

Oracle Tools: Developer 4.5/6i, Discoverer 4i/10g, XML Publisher, Workflow 2.5/2.6, SQL*Loader, TOAD, SQL Navigator, SQL Developer, SQL*Plus.
Database: Oracle 7.x/8i, 9i, 10g.
Languages: C/C++, SQL, PL/SQL, and JAVA.
Operating Systems: Windows NT/2003 Server, Windows XP, UNIX, Linux, Solaris.

WORK EXPERIENCE

Client

Confidential,Greens Ville, SC

Duration

01/2011 – Till Date

Role

Oracle Conversion Developer

Environment:

Oracle Applications 11.5.10,R12 (GL, AR, AP, OM, INV, PO, Procurement), Oracle 9i, UNIX, XML Publisher, Workflow 2.6, SQL, PL/SQL, Developer 6i, Forms10g, Reports6i,SQL* Loader, SQL Developer, Shell Scripting

Assigned as Oracle Conversion Developer to design, develop, implement and customize Oracle by understanding business requirements Implemented Order to Cash and Procure to Pay Life Cycles with Inventory modules..

Responsibilities:

• Worked on UTL_FILE Package and SQL*LOADER for the interfaces and conversions.
• Developed the Inventory Outbound interface Program to extract the inventory item data from base tables to flat file using UTL_FILE package.
• Worked on Items, Item Locators, Item Inventory Cross reference, Item Catalogs to extract the data from the source system applied all business rules.
• Developed Generic Packages using PL/SQL to build flat files to migrate data from Legacy to Oracle Systems. Scripted Error handling routines, Cursors, Packages, Functions, and Triggers etc.
• Interacted with users to resolve any issues during Interfaces.
• Collaborated with onsite team and QA team to code application to meet business requirement, discuss technical requirement and trouble shoot options.
• Worked on Interfaces loading the data from source system 11i to R12.
• Imported historical Customer information from the existing AR system into Oracle Receivable Applications for collection needs and better customer management by keeping track of customer, contacts and call details for future references using PL/SQL and SQL*Loader.
• Designed and developed interface program to Import Orders from legacy system into interim tables using SQL Loader and developed a PL/SQL program to validate the data and send to Interface tables.
• Customized Backorder Detail Report to review all customer orders that have been Backordered.
• Migrated .fmx executable file to $AU_TOP on forms server of Client.
• Tuned SQL queries and report queries to improve the performance.
• Customized Oracle standard reports like AP and AR Reports changed the output format to XML and created new templates for XML Publisher to display in pdf.

Client

Confidential,Redwood City, CA

Duration

11/2009 – 06/2010

Role

Oracle TechnoFunctional Consultant

Environment:

Oracle Applications 11.5.10,R12 (GL, AR, AP, OM, INV, PO, Procurement) , Oracle 9i, UNIX, XML Publisher, Workflow 2.6, SQL, PL/SQL, Developer 6i, Forms10g, Reports10g,SQL* Loader, SQL Developer

Assigned as Oracle Applications Techno Functional consultant to design, develop, implement and customize Oracle by understanding customer requirements Implemented Order to Cash and Procure to Pay Life Cycles.

Responsibilities:

• Developed test scripts and training documents for the above R12 upgrade and international rollout and conducted training sessions in GL, AR, AP, CM, Advanced Collections of AGIS modules for various IT and user groups in the U.S., Europe and Asia.
• Experienced in Procure to Pay, Order to Cash, and Assets to GL Cycle\'s Using Multi-Org.
• Worked on R12 Financial Modules and SCM, MOAC, TCA.
• Entering journals, Setting up Budgetary Control, defining Mass Allocations
• Developed Customization of Reports, Interfaces, Conversions as per client requirements.
• Involved in Implementation of Procure to pay (P2P) cycle which includes Items and Catalogs, Requisitions/Quotations, Purchase Orders, Receiving, Inventory, and processing Invoices.
• Involved in development of reports based on business requirements and registered them in Oracle applications.
• Defined value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures, and Packages.
• Worked on the Payables Open Interface. Activities involved creation of Loader File, Importing Invoices into the AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE tables using SQL*Loader and then using Payables Open Interface to import data into the actual tables.
• Worked on General Ledger interface program for creating journal entries into oracle General Ledger by validating required fields.
• Development and customization of Workflow as per customer requirements.
• Proficient in Configuring Oracle Workflow components and Workflow Administration activities.
• Performed Requisition import interface and PO receipts interface by validating required fields.
• Involved in developing various reports like Inactive items report, Bills of material item listing reports, GL detail report, monthly customer sales Report, and daily sales report.
• Created and registered a new Form using TEMPLATE.FMB.
• Involved in the development of interfaces/Conversions to import the data from legacy system into Oracle application base tables.
• Worked on UTL_FILE Package and SQL*LOADER for the interfaces and conversions.
• Customized Oracle standard reports like AP and AR Reports changed the output format to XML and created new templates for XML Publisher to display in pdf.

Conversions:

• Developed Customer Conversion to load historical data into Oracle base tables.
• Developed Sales Order Conversion to load Historical Orders Data into Oracle Base Tables.

Interfaces :

• Designed and developed custom program to interface daily all invoices from different systems into AR

Using Auto invoice, with validation and audit report.

• Developed the Inventory Outbound interface Program to extract the inventory item data from base tables to flat file using UTL_FILE package.

Reports:

• Purchase Report Detailed Item wise allows you to have a detail study of purchases Made during a given

Period using XML publisher.

• Developed Purchase order and Account Payables Invoice Report to display the PO and corresponding Invoice Details.
• Developed Supplier Payments Report using XML Publisher.

Forms:

• Migrated .fmx executable file to $AU_TOP on forms server of Client.
• Created and registered a new Form using TEMPLATE.FMB. Gateway File Business Process Maintenance Form which validates the data coming from legacy system against the setups made in the form for the security of the firm.
• Customized Sales Order Form.

Client

Confidential,Melville, NY

Role

Oracle TechnoFunctional Consultant

Environment

Oracle Applications 11.5.9 and R12(AR, OM, GL, AP, AOL, and PO , Iprocurement and I Expenses, Oracle 9i, UNIX, PL/SQL,Forms10g,Reports10g, SQL*Loader, SQL Navigator, Developer 6i, Workflow 2.6, XML Publisher, UNIX Shell Scripting

Duration

11/2008 – 10/2009

Assigned as Oracle Applications Technical Consultant, I was involved in Oracle Applications 11i and R12 implementation team, successfully implemented GL, AR, OM and PO; provided Production Support. Analyzed and defined the specifications for Conversions, Interfaces and Reports.

Responsibilities:

• Reviewed the Business Process Flows, Descriptive Flex fields, Forms and other Customizations, Custom Reports in Oracle 11i to use them during the implementation.
• Involved in Auto Invoice interface to load invoices automatically from legacy systems to AR tables and also involved in customer conversion from legacy to AR by using customer interface.
• Customized standard GL reports like Journal Entry report, Account Analysis Report, Accounts Hierarchy report as per business needs.
• Setting up the Key Flexfields for GL, INV, FA and Chart of Accounts.
• Setting up Set of Books.
• Designed and developed Custom Vendor Interface for import of vendor information into the system. Used SQL*Loader for import into interface tables and PL/SQL block for complete validation of data.
• Defined Legal Entity, Operating units and Inventory Organization and locations for Multi-org Environment.
• Customized standard forms with CUSTOM.pll library to build new functionality.
• Designed and developed PO requisition interface to load PO requisitions from the legacy system into purchasing interface tables.
• Worked on Order Import APIs to load the orders from legacy system into OM.
• Customized various reports in Order Management, Inventory and Shipping. Some of the reports are Pack List, Bill of Lading, Sales Acknowledgement Report, Order Holds Report, Delivery Detail Report using XML Publisher.
• Developed custom interface programs to import sales orders for Multi-Org, Inter-Company Data Transaction. Payment solution was implemented where customers will pay through credit card after checking out from the shopping cart in i Store module
• Implemented iSupport in order to manage product configurations, track orders, payments shipments
• Developed interfaces to create new Parties, Customers, Customer Addresses and Customer Contacts through TCA API from Legacy system into Oracle.
• Developed conversion scripts for address imports to existing parties using TCA API’s
• Widely used Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms, Reports as concurrent programs, set up Application Users, and assign responsibilities.
• Worked on fine-tuning of SQL queries for improved performance.
• Created Credit Card Invoice Issuer Report for i Expenses module.
• Debug Workflows. Data fix for workflows.

Client

Confidential,Ramsey, NJ

Role

Oracle TechnoFunctional Consultant

Environment

Oracle Applications 11.5.7 (AP, AR, GL, FA, INV , Iprocurement and IExpenses, Oracle 8i, Reports 6i/Forms 4.5, Windows2000/NT, UNIX, PL/SQL, SQL*LOADER, SQL*Plus, TOAD

Duration

09/2007 – 10/2008

Assigned as Oracle Applications Technical Consultant, I was involved in the implementation of
Oracle Apps 11.5.7. Developed and customized various Forms and Reports based on the requirement.

Responsibilities:

• Imported Customer Items and Item cross references using Interface Programs.
• Imported journals into GL from legacy system using GL journal import interface program. Used SQL*Loader to load that data into staging tables. The journals are imported by running the program periodically.
• Created a custom invoice report. The custom invoice report is a requirement for orders being shipped. It is printed at the time of ship confirmation, and is created along with the bill of lading.
• Wrote queries for summaries of AR aging reports.
• Customized Pick Slip, Packing List, Bill of Lading reports based on functional specification.
• Developed a Custom Travel Application using Forms 4.5 and PL/SQL.
• Developed forms using ZOOM functionality that pops up appropriate form. Modified CUSTOM.pll to activate zoom.
• Gathering Business Requirements and setting up Business Processes within the Applications GL, PO and FA.
• Developed interfaces to create new Parties, Customers, Customer Addresses and Customer Contacts through TCA API from Legacy system into Oracle.
• Created Technical Design Documents (TDD) and wrote interfaces for Customer Data creation using TCA APIs (AR).
• Written PL-SQL Package code and the SQL Loader Scripts (Control files) for Orders data conversion to the Customer from legacy system using wrapper APIs which internally calls the TCA public APIs
• Customizing already existing Forms by using Form level Trigger, Item Level Trigger and Block Level Triggers in several modules such as GL, AR, AP, FA and OM.
• Registered the shell scripts as concurrent programs and created a scheduling process that invokes the script periodically.
• Involved in Customization of Standard Oracle Reports in purchasing and order management as per client requirement
• Worked on modules of Oracle Applications namely (PO, AP and AR).
• Developed various interfaces and conversions in INV and OM.
• Developed SQL * Loader Control Files for uploading Data from Flat Files to Oracle Database Tables.
• Developing high-level technical design documents MD070 and released documents MD120.
• Reviewed the Existing System and prepared Loader Scripts to migrate the data from Existing System to new Oracle System.
• Uploading Master data like Titles, Customer, Supplier, Item into Master table using SQL Loader with the help of import program.

EDUCATIONAL QUALIFICATIONS

• Bachelor of Computer Science