SUMMARY:

• A professional Oracle Apps consultant having over 8 years of overall Domain experience in IT, which involves around 8 years of experience in design, development, support, customization and implementation of Oracle Applications (ERP).
• Extensive technical and functional expertise in Oracle Applications 11i/11.0.3, R12.
• Extensive experience in defining, analyzing, designing, implementation and support for Oracle Supply Chain Management, Manufacturing and Financial modules like Purchasing(PO), Order Management(ONT), Inventory(INV), Work In Process(WIP), Bills of Material(BOM), Material Resource Planning(MRP), Costing, Shipping(WSH), Advance Pricing(QP), Accounts Receivables(AR), Accounts Payables(AP), General Ledger(GL).
• Good knowledge and understanding of Oracle Order to Cash and Procure to Pay Life Cycles.
• Experience in designing, developing, implementing and customizing RICE Components.
• Proficient in importing data from legacy systems or 3rd party tools to Oracle Applications through interface programs and conversion programs by developing PL/SQL scripts for SQL loader and writing custom wrapper.
• Proficient experience in AOL concepts and System Administration by providing support to apps users in Oracle Applications.
• Good knowledge and understanding of Oracle R12 release.
• Extensive experience in Customization and Modification of Forms, Reports using Oracle Forms 4/6i/9i, 10g Oracle Reports 3.0/6i,9i,10g.Experience in developing applications using Oracle RDBMS 10g/9i/8i.
• Excellent skills in designing and developing different types of Reports using Oracle Reports3.0/6i, Discoverer 4i,6i,9i,10g & XML Publisher.
• Good working experience in modeling, automation, and continuous improvement of business processes, routing information of any type according to user - defined business rules using Oracle Workflow 2.6.3.
• Used Oracle AIM documentation for preparing technical design documents for customization and conversions in Project Implementation Methodologies.
• Proficient in understanding the concepts and hierarchical structure of Multi Org. Good knowledge of TCA Architecture.
• Extensive experience in Oracle Back-end (server-side) PL/SQL Development using SQL*Loader, SQL developer and Toad as development tools. Created and maintained Database objects.
• Exposure of UNIX Shell Scripting to schedule concurrent programs.
• Worked in projects that involved Fine tuning of queries for faster retrieval of data and involved in resolving various Troubleshoot issues.
• Excellent Team Player with good problem solving approach having strong interpersonal, communication, leadership skills and ability to work in a time-constrained and team-oriented environment.
• Proven ability to handle multiple tasks with strong technical aptitude and learning skills to adapt the rapid changing technologies and implementing the same at work.

TECHNICAL SKILLS:

Packages: E-Business Suite Oracle Applications: Versions 11.5.3, 11.5.7, 11.5.8, 11.5.9, 11.5.10 and R12.

ERP/Modules: Oracle Purchasing (PO), Oracle Order Management (OM), Oracle Inventory (INV), Work In Process (WIP), Bills of Material (BOM), Material Resource Planning (MRP), Costing, Shipping (WSH), Advance Pricing (QP), Oracle Receivables (AR), Oracle Payables (AP), General Ledger (GL).

Processes: Order to Cash and Procure to Pay processes

Programming Languages: SQL, PL/SQL, C, C++, HTML, Java

Development Tools: Oracle Forms 4.5/6i, Oracle Reports 4.5/6i, Discoverer 6, XML Publisher, Oracle Workflow 2.6.3

Database: Oracle 8i/9i/10g

Operating System: Windows 98/NT/2000/XP, SUN Solaris 2.5/5.6, UNIX, Linux

Tools: TOAD, SQL*PLUS, SQL* Loader, SQL developer.

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Client implements various application systems to support IT. The two major areas of implementations are Oracle Applications and Distributed WMS system across each warehouse. Client is planning to upgrade Oracle 11.5.9 to R12 in mere future.
• I was involved in various enhancements in WMS as well as Oracle applications and also fixing daily issues related to Production Support at the client.
• Built a custom process in WMS for replenishing the Primary sub-inventories with corresponding secondary sub inventories. This involved building custom packages, procedures and functions for the concerned project.
• Involved in developing a custom ATO (Assemble to Order) process which integrates between WMS and Oracle. This involved in using API’s and interfaces related to various oracle modules such as OM, INV, WIP and BOM.
• Developed multiple custom Oracle reports, Sql reports and XML reports for modules such as OM, INV, QP, WIP, PO and BOM.
• Involved in eliminating Legacy WMS system and replacing with Oracle R12 instance. This involved in registering all Autosys jobs of legacy system as concurrent programs in R12 instance and migrating, validating and fixed concerned objects for new instance.
• Worked with form personalization and custom.pll for customizing Oracle forms.
• Customization of forms involved in customizing custom Sales order form, Customer and Prescriber forms and prescription form.
• Involved in upgrading forms 4i to forms 10g for R12 upgrade for all WMS Custom forms.
• Created few outbound interfaces which transferred data from Oracle to legacy WMS system.
• Involved in creating numerous code review documents, testing scripts for QA and technical documents MD 70’s for all the objects.

Environment: Oracle Applications 11.5.9, R12 (INV, PO, AR, AP, OM, QP, WIP, BOM, MRP), Oracle 10g, TOAD, PL/SQL, SQL* LOADER, Reports 4i, 10g, Forms 4i, 10g, XML Publisher.

Confidential, San Diego, CA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• The Client environment was driven by the concept of Sprint, which is short duration for a development or customizing RICE objects. It had numerous sprint teams for each Sprint. Each comprised of Dev team, functional lead and a business champion. Entire Sprint session was handled by a scrum master. I was involved in numerous sprint sessions and also supported various production issues in the maintenance team.
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components for R12 Customizations.
• Extensively worked on customizing various Oracle Custom forms which were originally derived from Oracle standard forms.
• Customization of forms involved in customizing custom Sales order form, Customer and Prescriber forms and prescription form.
• Worked with form personalization and custom.pll for customizing Oracle forms.
• Involved in custom hold process for Sales Orders. This involved in developing custom hold process to put holds in Order header and lines based on Business validation.
• Involved in developing Oracle custom reports based on AR, AP, GL, OM, INV modules.
• Involved in performance tuning of various Oracle custom reports and custom programs.
• Worked on customizing WLB (Work Load Balance) process which determines load sharing and volume of daily activity for the business process.
• Involved in customizing Price check and Adjudication process which determines amount paid by the insurance and the patient. This involved working with various modules such as AR, OM, INV.
• Worked on generating XML Publisher reports based on the modules OM, INV and AR.
• Created few outbound interfaces which transferred data from Oracle to legacy system(Rx express).
• Involved in creating numerous code review documents, testing scripts for QA and technical documents MD 70’s for all the objects I was involved.

Environment: Oracle Applications R12 (INV, PO, AR, AP, OM, QP, GL), Oracle 10g, TOAD, PL/SQL, SQL* LOADER, Reports 10g, Forms 10g, XML Publisher, Discoverer4i, UNIX, Workflow 2.6.3.

Confidential, San Diego, CA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Worked exclusively under R12 Supply Chain Implementation team in developing various RICE elements for the project.
• Involved in numerous requirement gatherings, designing, documenting and unit testing of various RICE components.
• Developed various outbound interfaces from Oracle to third party systems like MBDS, WMS, Back Office, Vendor Forecast system and iTrade Network.
• Developed 15 Outbound Extracts which involved PO Updates, Inventory Updates, Price Lists Updates etc from Oracle to other third party systems.
• Developed various custom reports for iTradeNetwork which involved XML Publisher.
• Worked on developing Custom Pricing function which involves deriving price for an item in price list definition. The QP CUSTOM.get item price function is used for deriving custom logic for item price. Static formulas are used in this user hookup.
• Involved and supported in design changes and code changes for PO conversion.
• Developed various conversions which involved data transfer from legacy systems to Oracle. This involved Purchase history, Sales history, Stock adjustments and historical promotion conversions.
• Developed vendor sites conversion to load new sites in Oracle from the legacy system.
• Developed Price list conversion for loading all the price lists from the legacy.
• Supported and fixed issues with several other conversions such as customer, item and Onhand conversions.
• Involved in form personalization for validating pricing attributes in Price list setup form.
• Customized PO Approval Workflow based on business validations.
• Developed numerous views for discoverer reports which involved reporting for inventory, OTM, PO, OM, AP, AR, ASCP, QP.
• Developed numerous custom functions for reports and interfaces in custom utility package.
• All the developed objects have been documented as per MD 70 standards and unit tested.

Environment: Oracle Applications R12 (INV, PO, AR, AP, OM, GL, ASCP, OTM, QP), Oracle 10g, TOAD, PL/SQL, SQL* LOADER, Reports 10g, Forms 10g, XML Publisher, UNIX, Workflow 2.6.3.

Confidential, Denver, CO

Oracle Applications Technical Consultant

Responsibilities:

• Worked exclusively on discoverer reports to troubleshoot the issues related to both Administrator and desktop editions. Modified the existing discoverer reports so as to work in multi org environment.
• Created End User Layer for Discoverer Reports, migrated seeded and custom business areas to the new EUL, Analyzed and migrated workbooks.
• Worked in developing reports concerned with various modules such as AP, AR, GL, INV using Discoverer 4i ex: AP Trial Balance Report, AR aging Invoice, Material trx dist summary, GL revenue recon etc.
• Customized standard oracle reports by adding new fields to the existing reports in AP, AR and GL.
• Developed a report in XML Publisher based on standard oracle report.
• Documented MD070s and Unit test scripts TE025s for test case scenario’s corresponding to reports worked on.
• Developed Item Import Interface to load the items from third party system catalyst.
• Worked on Cost Open Interface to load the item costs for the concerned items in the inventory.
• Worked on fixing numerous issues related to Material Transactions Interface program.
• Made changes to custom Accounting program in AR.
• Worked on Cost Open Interface to load the item costs for the concerned items in the inventory.

Environment: Oracle Applications R12 (INV, PO, AR, AP, OM, GL, CST), Oracle 10g, TOAD, PL/SQL, SQL* LOADER, Reports 10gi, XML Publisher, Discoverer10g, UNIX.

Confidential, San Diego, CA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Created a process for generating RFQ’s based on existing Quotation’s. The process involved in development of custom API for validating data from existing quotations and created RFQ’s in purchasing base tables.
• Created a pl/sql update script to validate the data and update hz locations table by calling standard API HZ LOCATION V2PUB. UPDATE LOCATION.
• Developed Oracle report for displaying the successful RFQ’s created in oracle.
• Developed XML templates which involved adding logos, adjusting the template to required format based on customOraclereports.
• Worked on form personalization in disabling the buttons, enabling the fields and pop up messages for specific responsibilities in OM custom forms.
• Responsible for Order import using Order Management OE ORDER PUB API to update sales order into respective base tables.
• Worked on custom.pll in customizing the standard purchase order form to suppress PO control options for Buyer/Planner’s.
• Enhanced the existing custom concurrent program by adding a purge routine procedure to delete data from custom ASCP tables and adding a parameter.
• Extensively used AOL concepts for creating value sets, registering descriptive flex fields and creating various segments in DFF.
• Worked on preparing various MD070s and Unit test scripts TE025s for testing test case scenario’s corresponding to their respective business areas.
• Involved in developing, customizing numerous pl/sql procedures and functions based on the users requirement.
• Documented the entire functionality of two custom forms in MD070’s.
• Developed Reports using Discoverer, involving creating folders, drill down reports and item classes in AP, AR, PO, INV, GL, OM. Worked indevelopment and maintenance ofEUL*s. Design materialized views & tables for use in Discoverer.
• Used hp project management tool to migrate sql packages, reports, forms and responsibilities from one instance to other.
• Used PVCS tool for version control of various oracle objects.

Environment: Oracle Applications 11i (INV, PO, AR, AP, OM, ASCP), Oracle 10g, TOAD, PL/SQL, SQL* LOADER, Forms 6i, Reports 6i, XML Publisher, Discoverer, UNIX, PVCS.

Confidential, Charlotte, NC

Oracle Applications Technical Consultant

Responsibilities:

• Involved in improving existing functionality and business processes (in the areas of Orders, Contracts, and Invoices) using TCA concepts for R12.
• Worked with the implementation team having detailed discussions with the client on system requirements and mapping on oracle applications for version change from 11.5.10.2 to R12.
• Worked with the implementation team having detailed discussions with the client on system requirements and mapping on oracle applications.
• Involved in numerous team meeting to gather the requirements, explain the functionalities to the users and give a status update on various reports that I have developed.
• Developed numerous custom reports from scratch involving modules such as PO, OM, INV, AR, AP as per user’s request.
• Customized some reports in modules such as AR, AP, GL which involved adding new columns, parameters, logos and removing some columns from the standard report.
• Developed the AP invoices Interface program, loaded the data into interface tables and calling Payable Import Program.
• Worked and coordinated with EDI team to build EDI reports which were integrated with Oracle AR information (receipts, payments, deposits etc). It was involved using custom EDI tables from which data was pulled to build a report.
• Involved in building a custom Form which loads the purchasing data in a custom table which stores the purchasing information.
• Developed custom interface programs for validating and inserting the On Hand Quantity data into interface tables. Scheduled a standard API to load data into the target base tables.
• Involved in AR Open Invoices Interface by writing a custom wrapper to validate and load the data from staging tables into AR interface tables.
• Involved in Design, Development and Customization of OAFramework PagesinOracle Sales.
• Responsible for Order import using Order Management OE ORDER PUB API to update sales order into respective base tables.
• Performed System Administrator tasks which involved creation of Users, Responsibilities, and assigning Responsibilities to Users.
• Developed XML templates which involved adding logo’s, adjusting the template to letter format based on existingOraclereports.

Environment: Oracle Applications 11i,R12 (INV, PO, AR, GL, AP, OM, WSH, QP), Oracle 10g, TOAD, PL/SQL, SQL* LOADER, Forms 6i, Reports 6i, XML Publisher.

Confidential, Dayton, OH

Oracle Applications Technical - Functional Consultant

Responsibilities:

• Worked with the implementation team having detailed discussions with the client on system requirements and mapping on oracle application.
• Developed Item Interface to load the Items data from legacy system into Oracle Applications by running standard API.
• Performed PO conversion which involved developing a custom wrapper to validate and load the PO data into purchasing interface tables and then populating the oracle base tables through standard PO interface program.
• Converted the data from legacy systems into 11i.Developed control files for SQL*Loader and PL/SQL programs for loading, data mapping, data conversions and validating the data into the interface tables of AP.
• Developed custom interface programs for validating and inserting the On Hand Quantity data into interface tables. Scheduled a standard API to load data into the target base tables.
• Involved in AR Open Invoices Interface by writing a custom wrapper to validate and load the data from staging tables into AR interface tables.
• Involved in Price formula pub and used Get price formula API to load the base tables in QP.
• Worked on the Oracle Inbound Ship Confirm Interface, which perform actions on Deliveries, Updating shipping attributes, updating the Freight costs by calling an API.
• Loaded Legacy Journals data into interface tables and then populated the base tables of GL by running standard API.
• Responsible for Order import using Order Management OE ORDER PUB API to update sales order into respective base tables.
• Good understanding and worked with MRC concepts for various set of books in GL.
• Performed System Administrator tasks which involved creation of Users, Responsibilities, and assigning Responsibilities to Users.
• Documented functional features and behavior of required customizations using AIM methodology. Prepared and involved in analyzing conversion documents CV 40 and CV 60.
• Defined payment terms, Locations, Invoice Approvals and setting up Bank Account information in Oracle Financials AP.
• Involved in creating new messages and attached them to oracle standard forms as per business requirement.
• Worked on workflow in creating messages and sending notifications in PO module.
• Customized various standard reports in PO, INV, OM, AP and created new reports as per business requirements, using Oracle reports.
• Developed XML Reports in various modules based on existingOraclereports.
• CreatedandextendedvariousAMs,VOs andEOs as per the requirement.
• Developed Reports using Discoverer6i, Created business areas, custom views, new folders, conditions and joins based on user requirements.
• Helped and involved in understanding the functionality flow of complete life cycle of Order to Cash to the users which includes defining and setting various objects pertaining to the modules.

Environment: Oracle Applications 11i (INV, PO, AR, GL, AP, OM, WSH, QP), Oracle 10g, TOAD, PL/SQL, SQL* LOADER, Forms 6i, Reports 6i, XML Publisher, Workflow 2.6.3, Discoverer6i.

Confidential, Versailles, OH

Oracle Applications Technical-Functional Consultant

Responsibilities:

• Involved in designing, developing interfaces, customizing user requests and implementation change requests. During these processes interacted with end users and implemented their requirements into the Application Systems.
• Developed Requisitions open interface, loaded data from staging tables to interface tables and called a seeded API to populate the Purchasing base tables.
• Involved in the implementation of Item Open interface and resolved related technical issues.
• Involved in BOM conversion by developing a custom interface program to load the staging table data into BOM base tables.
• Developed the AP invoices Interface program, loaded the data into interface tables and calling Payable Import Program.
• Responsible for Order import using Order Management OE ORDER PUB API to update sales order into respective base tables.
• Worked on price list API to populate base tables in QP.
• Personalization of Oracle forms like, Order Entry, Item Master, Material Transactions and various other forms using custom.pll, as per the client’s requirements, using Oracle Forms. Created Error correction forms for PO Receipts interface.
• Involved in customization of various Reports in PO, AP and OM modules using Oracle Reports.
• Extensively used AOL for Configuration of Key Flex Fields and Descriptive Flex Fields.
• Registered the automation scripts as concurrent programs and created a scheduling process that invokes the script periodically.
• Worked on preparing and reviewing MD050s and MD070s for various formal documents and transactional reports corresponding to their respective business areas.
• Developed Custom Order Hold and Discounts program using OM and Advanced Pricing module through PL/SQL.
• Developed Reports using Discoverer6i, Created business areas, custom views, new folders, conditions and joins based on user requirements.
• Customized Workflows for sending notifications using workflow 2.6.3.
• Involved in the end users on the functionality of Procure to Pay modules.

Environment: Oracle Applications 11i (PO, OM, INV, GL, AP, QP and BOM), TOAD, Oracle 10g, SQL*Plus, PL/SQL, SQL*Loader, SQL Navigator, Forms 6i, Reports 6i, Discoverer 6i, Workflow 2.6.3.

Confidential, Cleveland, OH

Oracle applications Technical Consultant

Responsibilities:

• Analyzed the Business Systems for Oracle Application integration, interacted with end users to gather and analyzed the technical requirements, designed, drafted specifications, developed and implemented Financial Modules.
• Involved in Customer Conversion to load Customer details into HZ base tables by an API.
• Developed the AP invoices Interface program, loaded the data into interface tables and calling Payable Import Program.
• Loaded Legacy Journals data into interface tables and then populated the base tables of GL by running standard API.
• Implemented and supported AR Auto Invoice import Interface program.
• Involved in Enhancement of the existing system by developing new forms for the system and integrating them with existing modules. Customized existing forms and incorporated new functionalities.
• Involved in customization of standard Oracle reports in AR, AP and GL as per client requirements using Oracle Reports.
• Customized Workflows for sending notifications using workflow 2.6.3. Prepared functional and technical specifications according to Organizational wide standards.
• Registering concurrent programs, request groups for reports and concurrent requests.
• Involved in development of customer Interface and Interacting with users to get the requirements and mappings during conversion.
• Involved in the end users in creating and modifying thereceipts, Invoices, customer detailsfrom front end andhelp them in understanding the complete process and flowof AR and AP modules.
• Performed testing while assuring smooth transition to production, wrote technical documentation, set up user- workshops and assisted with enhancements requests.
• Developed Reports using Discoverer4i, involving creating folders, drill down reports and item classes in AP, AR and GL.

Environment: Oracle Applications Release 11i (11.5.9), AR, AP, GL, OM, PO, WIP Toad, PL/SQL, SQL Plus, Forms 4.5, Reports 6i,SQL* Loader, Workflow 2.6.3, Discoverer 4i.

Confidential, Dallas, TX

Oracle Technical Consultant

Responsibilities:

• Involved in improving existing functionality and business processes (in the areas of Orders, Contracts, and Invoices) using TCA concepts.
• Converted the data from legacy systems into 11i. Developed control files for SQL*Loader and PL/SQL programs for loading, data mapping, data conversions and validating the data into the interface tables of AP.
• Wrote a Program to insert data into Item Transaction Interface tables based on different Transactions and populated the base tables by calling a seeded API.
• Worked on the Oracle Inbound Ship Confirm Interface, which perform actions on Deliveries, Updating shipping attributes, updating the Freight costs by calling an API.
• Populated customer base tables in AR by implementing customer Interface program.
• Involved in customization of standard Oracle reports in OM, AP as per client requirements using Oracle Reports.
• Involved in customization of schedule order form and moved Promise Date from one canvas to another, using Oracle Forms.
• Designed and developed numerous packages and procedures using various APIs to load data from staging tables into Oracle base tables.
• Developed OM queries to Count Orders by Order Types, Order Source. Identified, demonstrated and documented Order Entry, drop shipments, Internal Orders.
• Updated Profile Options for related modules and successfully upgrade to Multi-org functionality.
• Hands on experience in Oracle Applications System administration, involved in setting up user responsibilities, privileges of users, administering concurrent managers/transaction managers (activate/deactivate, request priorities), registering various Forms and Reports.
• Took part in the entire phase of the project which includes, initial operations analysis, business process re-evaluation, testing,, conversions, customizations and documentation and implementation of modules.

Environment: Oracle Applications Release 11i (11.5.9), AR, AP, INV, OM, WSH, GLToad, PL/SQL, SQL *Plus, Forms 4.5, Reports 6i, SQL* Loader.