SUMMARY

• 7+ Years of experience as an Oracle Applications (E - Business Suite) Consultant and Techno functional developer.
• Expertise in the implementation and customization of Oracle HRMS Oracle Project Accounting (PA), Manufacturing and supply chain modules (BOM, OM, INV, and PO), Oracle Financials modules (GL, AP, AR, FA, PA), i-procurement, i-expenses, Cash Management, Asset Management, Fund Management and System Administrator.
• Strong working knowledge of business flows like Order-to-Cash (O2C), Procure-to-Pay (P2P) and drop ship along with the dependencies and relationships between Oracle Applications modules
• Good technical development skills in developing Reports, Interfaces, Conversions and Extensions (RICE) components.
• Involved in preparation of various documents like MD050, MD070 (functional & Technical Design) documents using AIM Methodologies.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Extensively worked on Discoverer, which includes report developments, discoverer administration, configuring discoverer and End User Layer (EUL).
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes, Shell scripting, Performance Tuning.
• Experienced in Performance Tuning and analyze using TKPROF, SQL Trace, and Explain Plan.
• Experience developing and customizing reports and forms using Oracle Forms and Reports, XML Publisher, BI Publisher and Discoverer.
• Expertise in the design and development of interfaces (inbound and outbound) and conversion programs using APIs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader, and UTL FILE.
• Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of users, responsibilities, forms, functions, menus, value sets, and flex fields.
• Experienced in customizing Oracle Forms with forms personalization using Custom.pll.
• Familiar with Oracle Applications Framework (OAF) technology, especially with personalization of existing OA Framework pages in JDeveloper 9i and 10i.
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle Applications using open interfaces and APIs.
• Very good Knowledge and understanding of Application Object Library (AOL), System Administration and Trading Community Architecture (TCA).
• Transferred and retrieved data to and from FTP Servers to Oracle Database.
• Experienced in Performance Tuning and analyzing using TKPROF, SQL Trace, and Explain Plan.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Good working experience in different environment like Agile, Water fall process.
• 24/7 Support and effectively to production & development issues and taking responsibility for seeing those issues through resolution.

TECHNICAL SKILLS

Oracle Applications: Oracle E-Business suite R12/11i OM, INV, GL, AP, AR, PO, FA, AOL, BOM, I-Procurement and System Administration.

Application Tools: Reports 10g/9i, Discoverer 10g/6i, XML Publisher 5.6.3/5.6.2 , Oracle Forms 10g/9i, TOAD, SQL*PLUS, Export, Import, SQL*Loader, Oracle JDeveloper.

Operating Systems: Windows XP/7, UNIX, Linux, MS-DOS.

Languages: SQL, PL/SQL, C, C++, Java Script, PHP, Java, HTML, XML.

Scripting Languages: Unix Shell scripts, Perl.

RDBMS: Oracle 12c/11g/10g, SQL Server 2000.

PROFESSIONAL EXPERIENCE

Confidential, CHICAGO

ORACLE E-Business APPS Technical Consultant

Responsibilities:

• Involved in the collection and analysis of product requirements from end-users.
• Developed, tested and provided support for the interfaces, conversions, reports and forms through interaction with business users for upgrading and new implementation from Oracle Applications 11i to Oracle Applications E-Business Suite R12.
• Experience designing conversion/interface implementation strategy for Accounts Payable (AP), Accounts Receivable (AR), and Order Management (OM) modules, Fixed Assets (FA), Bills of Material (BOM), Cash Management, Fund Management, Asset management .
• Worked on Oracle Application Framework (OAF) to develop custom solutions for iExpenses and iProcurement module.
• Possesses an in depth knowledge on Business Flows of Order to Cash and Procure to Pay.
• Experience in defining processes relative to Order to Cash, Procure to Pay, Close Processing, and reporting.
• Created Purchase Order Notification Report for Advanced Supply Chain Planning.
• Trained and Assisted the super users in testing.
• Handled multiple bank account receipt processing from ACH, wires and lock box.
• Implemented Oracle Cash Management for bank reconciliation.
• Used Auto Invoice Import program to design and develop interfaces to import legacy AR invoices into Oracle E-Business Suite.
• Creating functional design documents to build the new Oracle custom reports and testing the developed reports before migrating it to the other instances.
• Setting up of procurement process for frequently procured items through the internal catalog for iProcurement requisitions.
• Resolved AR accounting issues such as payment reconciliations.
• Developed an Interface Program to import Supplier Invoices from legacy system into Oracle AP.
• Customized the functionality in Pick and Ship delivery option of OM module via Forms personalization and Custom.pll.
• Set up value set, Key Flex fields, descriptive flex fields, concurrent program, printers, function, menus, Responsibility, users.
• Performing regression testing during upgrades.
• Extensively worked on Multi conversion setup in PA and AR Applications.
• Setting up of Approved Supplier List, Assignment Set and Sourcing Rules for the service Items with release generation methods “Automatic Release” for auto generation of Blanket Release and Standard Purchase Orders.
• Customized the Oracle Seeded Order Management Transaction Type workflow to add workflow functions for email Notifications when the order is booked using Workflow Builder.
• Customized the standard Workflow Items and process such as Order Headers and Order Lines.
• Developed Bar-coded Packing Slip Report and Bar-coded Package labels.
• Customized the standard Workflow Items and processes such as Order Headers and Order Lines.
• Designed and implemented Order Management (OM) outbound (855), inbound (850) EDI process through PL/SQL custom packages.
• Designed and developed custom Outbound Pricing Process for corporate customers using PL/SQL Packages, shell scripts for Aviation operating unit.
• Experience in PLSQL Interfaces, PLSQL APIs, Conversions, Customization and Development of Forms, Workflows and Reports.
• Setting up Work Flow Attributes in Oracle Purchasing Application.
• Registered several forms, menus, concurrent programs, and request sets to AOL.
• Customized existing forms by adding shortcuts to other forms and added Zoom functionality.
• Imported Requisition Details (Requisition Import) using SQL* Loader and PL/SQL.
• Wrote programs to insert update and validate values into the PO requisition Interface tables for each requisition line.
• Involved in writing Technical Design Document (MD070) as per Oracle AIM Methodology.
• Developed an Interface Program to import Supplier Invoices from legacy system into Oracle AP.
• Developed an Interface Program to import customers, locations, customer’s sites and customer contacts by using the TCA APIs.
• Customized standard AP Invoice Aging to run the report based on ‘as of date’.
• Resolved issues in AR automatic import process and manual upload to load invoices into Accounts Receivable module as part of production support.
• Setting up Work Flow Attributes in Oracle AR.
• Developed new reports for debit and credit memos in Account Receivables using XML Publisher.
• Customized and developed various reports in AR, AP, and OM modules using Oracle Report builder 10g.
• Setup the Transaction Sources, Transaction Types, Lockboxes, Transaction Formats, Customer Categories, and Customer Classes in Oracle AR.
• Defined Banks, Bank branches, Bank Accounts, Invoices Sources, Payment Formats, Payment Terms in Oracle AP.
• Integrated custom reports with the application (based on the descriptive flex fields) as per end-users reporting requirements.
• Developed new forms using TEMPLATE.FMB and customized existing forms in the OM module according to the client’s requirements.
• Customized standard AR Invoice Print report to print Project Number at invoice header.
• Designed and developed Auto Lockbox to load receipts and invoices into Oracle Receivables.
• Involved in Unit and Integration testing.

Environment: Oracle E-Business Suite (R12), Oracle 11g, Oracle Reports 10g, Oracle Forms 10g, XML Publisher, Discoverer 10g, UNIX and Workflow builder 2.8.

Confidential - WI

ORACLE E-Business APPS Technical Consultant

Responsibilities:

• Experience in implementing Oracle HRMS, Order-to-Cash and Procure-to-Pay cycles for Oracle Applications E-Business Suite (R12).
• Provided daily support for GL, AP, AR, OM, PO, INV, FA, BOM and OPM modules.
• Understanding the functional requirements and interact with client for any open issues for designing scalable and maintainable solutions.
• Created Item Categories for the various reporting and Business purposes.
• Worked on workflow notifications and re-routing the notifications to other employees based on the super user requests.
• Gathering requirements for lockbox interface, designing the lockbox bank file format, setting up the functional setup for lockbox, designing the Confidential National Bank interface validations for the lockbox load.
• Extensively worked with the development team to build the Oracle custom forms in various applications and testing the functionality before migrating it to the other instances.
• Developed Purchase Order export to Sales Order Interface program.
• Developed an extension to Release drop ship Sales Order holds.
• Designed and developed Sales Invoices Conversion program using Auto Import functionality.
• Worked extensively in Order to Cash cycle and Procure to Pay cycle.
• Customized the Blanket Sales Agreement form to let the user edit a DFF only for specific customers using Custom.pll.
• Extensively worked on RICE Components to view, transfer and modify the data in the same or different system.
• Implemented Draft & Invoice reports and customized Purchase Order reports.
• Designed wide variety of reports in Order Management with BI/XML Publisher.
• Worked with Sales Orders Open Interface in Oracle Order management module to import Sales Orders from flat files.
• Ensured accurate processing of all payroll transactions including payroll reversals, balance adjustments, costing processes, and quick pays.
• Validated payroll run results.
• Worked on Personalization of forms such as making fields mandatory, Validating fields using custom code in triggers.
• Setting up Pricelists, Qualifiers and Modifiers and defining Pricing attribute contexts to setup formulae .
• Modified Forms to accommodate new functionality such as adding buttons and texts.
• Developed Data Conversions and Interface Programs. Used SQL * Loader to load data into Oracle Database.
• Worked on numerous modules including custom applications. Some of them are mentioned below:
• Purchasing (PO) -Change PO program (create PO workflow), loading Requisitions and POs from legacy systems.
• General Ledger (GL)- GL interfaces and Journal balances in outbound interface.
• Order Management (OM)- Price List conversion, Custom Sales Order Import, Packing Slip report, Pick slip reports.
• Worked extensively on the customization of Auditor Reports using BI/XML Publisher and resolved .
• Developed many reports and designed to view output in different formats like PDF, EXCEL, RTF and HTML using BI/XML Publisher.
• Developed the auto-invoice setup functionality of transaction type, transaction source, line transaction flex field, line order rule and grouping rules.
• Developed reports in Payables to send a Notification to AP/Buyer/Requestor of Invoices on Hold.
• Involved in customer conversion from legacy system into Oracle Accounts Receivable by using Customer Interface.
• Customized various Concurrent Programs and AR Aging Reports in Oracle Receivables and Oracle Payables to run independently irrespective of Responsibility using SRW packages.
• Involved in migrating the data into Oracle Apps from the Excel Sheets using open interface / Oracle API, Oracle utilities and third party tools (Data Loader).
• Involved in performance tuning of various packages and reports and done code fixes to improve the performance in OM and AR modules using Explain Plan, TKPROF, Hints and TOAD.
• Prepared Setup documents (BR100) for Accounts Payables & Account Receivable.

Environment: Oracle Apps EBS R12 (HRMS, GL, AR, AP), PO, INV, OM, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, TOAD, Workflow Builder.

Confidential, LOS ANGELES, CA

ORACLE E-Business APPS Technical Consultant

Responsibilities:

• Worked with AR, GL, OM, CA, BOM, OPM (Oracle Process Manufacturing) modules.
• Prepare CV40, CV60 migration documents and develop code for migration of data from Oracle E-Business Suite 11.5.9 to 11.5.10.2.
• Developed functional design, technical design document, and conversion mapping documents.
• Performed extensive application tuning for Order to Cash business processes.
• Developed Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports.
• Developed the auto-invoice setup functionality of transaction type, transaction source, line transaction flexfield, line order rule and grouping rules.
• Worked with Sales Orders Open Interface in Oracle Order management module to import Sales Orders from legacy system to Oracle Order Management by using the Oracle API.
• Imported ITEMS from legacy system to Oracle Inventory by using the standard item import program through a custom package that validates individual records.
• Implemented Oracle GL, INV modules to meet Business requirements of the client.
• Performed journal import process from different legacy systems into GL interface tables.
• Worked with GL tables such as GL JE HEADERS, GL JE LINES, GL SET OF BOOKS, AR Interface, Customer Interface, and GL interface (GL INTERFACE, GL BUDGET INTERFACE).
• Involved in migration of GL custom interfaces and reports during oracle financials upgrade project.
• Developed an interface to upload the journal data into the Oracle Application's General Ledger.
• Developed a PL/SQL procedure to transfer data to interface tables after performing necessary business validation.
• Created Discoverer Reports for AR, GL, OM, BOM modules.
• Imported BOM’s and Routings from Legacy system into Oracle BOM module using the standard BOM and Routing interface program.
• Developed new forms and reports in BOM module
• Designed and customized reports like New Customer Setup report and Contract Price List report using Discoverer 10g.
• Involved in carrying over the Customizations and Extensions done on the Oracle reports, Oracle forms and PL/SQL programs using Oracle Apps version 11.5.8 to 11.5.10.
• Developed Custom Packages, Procedures for validating the Summary balances and Detail Transactions from the legacy system, imported them into interface table and submitted the Journal Import program to populate base tables.
• Worked on preparing functional and technical document (MD050 & MD070) according to client and user requirements.
• Customized the report called Backorder Detail Report which is used to review all customer orders that have been backordered using Oracle Reports 10g.
• Involved in designing various reports like Inactive items report, Bill of materials item listing reports, GL detail report using Oracle Reports 10g.
• Developed PL/SQL procedures, functions and packages, created the materialized views and also created the partitioning tables and worked on database triggers for automatically updating the tables.
• Created host programs using UNIX shell scripting for remote database access and ftp of files to the supplier site database.
• Created various lookups, Value sets, user defined tables.
• Involved in troubleshooting issues, fixing bugs, and fulfilled the new business requirements.
• Interacted with users to resolve any issues during development, production, and enhancement phases.

Environment: Oracle E-Business Suite (R12), Discoverer, Oracle 10g, Reports 10g, Workflow, PL/SQL, SQL*Loader, and Toad 8.0.

Confidential, PHOENIX, AZ

ORACLE E-Business APPS Technical Consultant

Responsibilities:

• Worked on the implementations and customizations using PO, OM, AP, AR, OPM and GL modules.
• Involved in the development of technical documentations of reports and interfaces.
• Worked closely with end-users/clients through complex problems involving deployment, testing and conversion in procure to pay (P2P) cycle.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the interface tables from the legacy system.
• Worked on Oracle's FNDLOAD utility for transferring/migrating concurrent programs and requestsets.
• Developed Invoice and Customer conversion.
• Performed unit testing, integration testing for the PL/SQL interfaces developed.
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program.
• Customized Reports like the Order Summary Report, Pick Slip Report and Packing Slip Report in Order Management using XML/BI publisher.
• Developed a Customized XML/BI Publisher report for On-Hand-Quantity available for all the items in every sub-inventory, which belonged to a particular Organization in the inventory module.
• Developed control file to load sales orders created in legacy system into staging tables using SQL * loader then validated data and inserted into Order Management interface tables.
• Customized shipping reports namely pick slip, packing list in OM, and open purchase order reports in PO.
• Customized the OM: Generate Cost of Goods Sold Account’ Workflow to generate the COGS account that meets the business requirements.
• Customized a new workflow process in Order Entry to keep track of the Sales Order and sending the notifications correspondingly.
• Released holds using OE ORDER PUB API and adjusted line adjustments.
• Developed PL/SQL Procedures for Customer interface using Trading Community Architecture (TCA) in Accounts Receivables according to Client Requirements.
• Followed (MD50) functional documents and written the technical (MD70) specifications, provided support for end users and documented the modifications.
• Involved in Auto Invoice Interface to load invoices automatically from legacy systems to Oracle Receivables Interface tables.
• Loaded the data into AR PAYMENTS INTERFACE ALL. Validated and imported the data into AR base tables.
• Customized various XML/BI Publisher Reports using RTF templates and defined their respective Templates and Data Definitions.
• Converted Supplier Payment History Report in Account Payables from Report 6i to XML/BI Publisher.
• Customized AR Aging 4 and 7 Bucket reports in Account Receivables.
• Worked extensively on System Administration responsibility by doing set ups in AR, AP and GL Modules.
• Modified Privileges for Users using System Administration responsibility depending upon various Organizations.
• Worked with Application Object Library (Defined executable, programs, linked with responsibilities, defined DFF and value sets).
• Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation.

Environment: Oracle Applications R11i, GL, AR, AP, PO, INV, FA, OM, iExpenses, Oracle 10g, D2K, Forms 9i, Reports 9i, Discoverer 6i, Workflow, XML/BI Publisher and TOAD.

Confidential

ORACLE APPS DEVELOPER

Responsibilities:

• Worked on customizations (Reports and Forms) of GL, AR, PO, INV and AP modules.
• Worked as a team member to implement and develop interfaces according to business requirements for Purchasing (PO), Inventory (INV) and Receivables (AR).
• Involved in Open Transaction Interface to import transactions from legacy system to Inventory and set up Transaction Manager as background program to import validated data from interface table periodically.
• Developed custom interface program to load inventory (INV) Adjustment data from external system into MTL TRANSACTION INTERFACE and MTL TRANSACTION LOTS INTERFACE tables as Account Alias Receipts and Account Alias Issues.
• Developed Alerts in Inventory Modules.
• Customized Reports in PO, AR and AP like Printed Purchase Order Report, Aging 4 Bucket Report etc using Reports 9i.
• Created Dependent LOVs and Message Choice Pick List on multiple pages to meet the business requirements.
• Used FND REQUEST API to submit concurrent Programs from PL/SQL program.
• Involved in setup and customization of Oracle Payables and data conversion from legacy system into Oracle Payables.
• Imported Requisitions from legacy system to Purchasing through Requisition Open Interface.
• Used SQL*Loader and UTL FILE Packages for data conversion and interfaces.
• Created new business areas, workbooks according to user requirements and also involved in creating reports using Discoverer 6i.
• Registered Reports, SQL*Loader Scripts and PL/SQL Packages as Concurrent Programs using System Administrator Responsibility.
• Developed reports for Quotation, Invoice, contracts and checks using BI/XML Publisher. Involved with Testing Team in testing and fixing all the issues that came up while testing.

Environment: Oracle E-business suite 11i(11.5.9), XML Publisher, Toad, Oracle 10g, Reports 9i, Forms 10g, Unix, and SQL*Loader.