SUMMARY

• 9+ Years of professional work experience in Oracle E - Business Suite 11i & R12.
• Experience in implementing, testing, training, live production supporting, on various Oracle ERP Modules like Order management(OM), Shipping, Inventory(INV), Purchasing(PO),Accounts Payables(AP), Accounts receivables(AR), Project Accounting(PA),General Ledger(GL),XML Publisher, I Supplier. Cash Management,BOM,Warehouse Management System (WMS), Trading Community Architecture (TCA), Fixed Assets, FAH, iProcurent, iExpense and iProcurement.
• Oracle Global Techno-Functional Production Support in Oracle Modules like Procure-to-Pay (P2P), Order to Cash (O2C) and I focus
• Extensive work in the functional areas like Order to Cash, P2P and Finance Modules
• Experience in Implementation, Upgradation and Customization in Oracle Applications (versions R12,11i, and 11.0.3).
• Extensive work in the technical areas like SQL plus, PL/SQL, Toad, Forms, Reports, Discoverer, Optio.
• Extensive work on testing R12 Financial modules
• Involved in two Full lifecycle Implementations including Functional setups, process, gap analysis and creating functional specifications and given post production support.
• Extensive experience in Order to Cash and Procure to Pay cycles.
• Served as one of the member in general oracle practice support team
• Strong functional and technical knowledge in interface tables and base tables of Inv, Order Management, Oracle Costing, Advanced Pricing, GL, AP, AR, CM, and Shipping.
• Provided functional test scripts for different scenarios of business
• Sound experience in Data Conversions, Data Migration, Developing Inbound and Outbound Interfaces, Customizing Forms & Reports, Developing Forms & Reports, Customizing Workflows in various Oracle Financial and Supply Chain Management.
• Hands on experience in understanding Oracle supplied TRM’s and well versed in understanding visual linking of the tables of TRM.
• Extensively worked on Inventory Conversations.
• Experienced in development and customization of Forms and Reports with sound understanding of Application Object Library (AOL), Sysadmin.
• Experienced in preparing Test Plan, Unit Testing, System Integration testing and documentation, with ability to work in across functional modules and Technical.
• Experience in supporting the production system, handling day-to-day issues and end user training
• Developed Interface/Conversion Programs, and experienced in writing Stored Procedures, Functions, Triggers and Packages using PL/SQL.
• Extensive experience in RICE components and Worked as Technical consultant for production support.
• Extensive experience in production support and ticketing systems, BMC Remedy
• Worked in multi-organization implementation that involved gathering requirements, defining solutions, and recommending best business practices and completing system set-up
• Involved in 11i patch project and given impact analysis for R12 upgradation
• Experience in AIM methodology
• Extensive Experience in OA Framework, shell scripting and Flexfields
• Closely worked with Technical teams for Customizations like reports, interfaces Oracle forms and java pages.
• Exceptional communicator - can effectively present ideas and concepts to upper management in a clear and concise manner
• Experience in Roll-Outs
• Extensive experience in Logical Apps and Form Personalization’s

TECHNICAL SKILLS

Oracle Applications: Oracle Applications (EBS) R12 12.1.3, 11i 11.5.10/11.5.9/11.03

ERP Modules: Order Management, Inventory, Purchasing, Account Receivables, Account Payables, Advanced Pricing, Cash Management, Fixed Assets, General Ledger TCA, Warehouse Management, Shipping,BOM, AOL, System Administrator, Project Accounting, OPM, Federal Administration and FAH.

Self Service Modules: iProcurement, iExpense, iStore and iSupplier

ERP cycles: Order-2-Cash (O2C), Procure-2-Pay (P2P), Finance

Databases: Oracle Database 8i, 9i,10g and 11g

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

Software Tools: Developer 2000, Forms 6i/4.5, Reports 6i/2.5, Discoverer 10g, SQL*LOADERPL/SQL, SQL*Plus, Logical apps, OptioDesignStudio7.8, Java, HTML and XML HP Quality Center

Development Tools: TOAD, SQL*Plus, SQL*Developer, Pl/Sql Developer

Operating Systems: UNIX, Windows 2000 Server/Professional, Windows NT

PROFESSIONAL EXPERIENCE

Confidential, West Des Moines IA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in the preparation of Detail Design, technical design and specification.
• Involved in Functional Testing
• Converted RDF reports to XML reports
• Personalized the standard and custom forms
• Oracle Global Techno-Functional Production Support in Oracle Modules like Procure-to-Pay (P2P), Order to Cash (O2C) and I focus
• Working on many customizations and enhancement requests based on business demand
• Involved in developing of new interfaces, customization of existing interfaces and developed new reports and customizing existing Reports and Forms to 6i to meet the business/client requirements.
• Developed interface programs, which will import all items, item categories and item attachments that are created using the Item Open Interface.
• Analysis of business needs and requirements, identifying the gaps and issues for Order managements, inventory, AR and Purchasing modules
• Worked on customizations of Pack slip and Pick Slip reports to fulfill the customer requirements
• Worked on customizations based on the user requirements and Business demand
• Used Form Personalization’s on FOB Customizations
• Worked on Inventory Conversations and enchancements.
• Working on many customizations and enhancement requests based business demand
• Working on impact analysis for separation Aviva US and Aviva Canada.
• Managed/Supported a team to fill the GAP in the Order to Cash and Procure to pay flow.
• Co-ordinate and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training conversions, customizations and documentation and implementation of modules
• Worked in R12 Post production support
• Design and developed Supplier and Item Conversations
• Worked on Data Masking, Data Trimming and Purging activities.
• Worked on Customization of XML reports
• Worked on Oracle Alerts to send Email, based on some changes in the custom table
• Developed inbound and outbound interfaces between Oracle and legacy systems
• Preparation & Execution of Test Scripts for all Financial Modules

Environment: Oracle Applications R12 INV, PO, OM, AP, AR, PA, GL,iProcurement,iExpense,Cash Management, FAH, Fixed assets, Oracle 11g,PL/SQL, TOAD, SQL*PLUS, SQL*LOADER,HP Quality Center Forms 6i, Reports 6i, Discoverer10g.

Confidential, Horsham PA

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in the preparation of Detail Design, technical design and specification.
• Responsible to debug the workflow errors like duplicate rows in modules schema and not closing the workflow, and also creating huge number workflow rows for PO, OM, AR, BOM, WIP workflows.
• Worked on customizations based on the user requirements and Business demand
• Used Form Personalization’s on FOB Customizations
• Worked on Asia and Europe roll-outs.
• Involved in developing of new interfaces, customization of existing interfaces and developed new reports and customizing existing Reports and Forms to 6i to meet the business/client requirements.
• Analysis of business needs and requirements, identifying the gaps and issues for Order managements, inventory, AR and Purchasing modules
• Worked on BMC tool for Production support to resolve the BMC tickets.
• Working on many customizations and enhancement requests based business demand
• Working on impact analysis for patch project
• Managed/Supported a team to fill the GAP in the Order to cash and Procure to pay flow.
• Co-ordinate and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training conversions, customizations and documentation and implementation of modules
• Worked on TCA Customer and Supplier modeling.
• Worked on AR Auto Lock box and Auto Reconciliation.
• Configured Payables System Options, Payable and Financial options.
• Defined Payment Terms, Payment Set ups and Distribution Sets.
• Setup Suppliers, Supplier Sites, Banks, Bank Accounts and documents.
• Used standard Oracle OE ORDER PUB API to create a new sales order and update/cancel an existing sales order in Oracle Apps System.
• Used standard Oracle OE HOLDS PUB API to apply/release holds on the sales order created.
• Core member in the project involved in Creating Invoice and Revenue Recognition.
• Worked on D/FW Printed Requisitions report after migrating from 11i to R12.
• Implemented oracle iStore integration with Order management where iStore pulls the data from Order management by using oracle API’s
• Developed interfaces between Oracle and legacy systems
• Involved in EDI process on production issues

Environment: Oracle Applications R12 and 11i INV, PO, OM, AP, AR, PA, GL,iProcurement,iExpense,Cash Management Oracle 9i,PL/SQL, TOAD, SQL*PLUS, SQL*LOADER, Forms 6i, Reports 6i, Discoverer10g.

Confidential, IL

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in functional setups as per customer requirements
• Involved in the preparation of Detail Design, technical design and specification.
• Developed an Interface program to load the item, invoices and customer data from flat files into oracle Tables which Validates the data using PL/SQL program and populated the Payables interface table through a Concurrent program, which in turn submits a standard tables Interface program.
• Created CSV, text files by using the macros for Exclusion and Inclusion purposes.
• Developed PL/SQL packages for validations of data and used API to populate the data in base tables
• Worked on AOL objects for creating custom tables, menus, responsibilities, concurrent programs, request sets etc
• User Training and production support.
• Worked on customizations of Pack slip and Pick Slip reports to fulfill the customer requirements
• Worked on Optio DesignStudio7.8 Prepared layout design for optio printing for Notice to shipment and picking and packing list.
• Developed interface programs, which will import all items, item categories and item attachments that are created using the Item Open Interface.
• Involved in developing of new interfaces, customization of existing interfaces and developed new reports and customizing existing Reports and Forms to 6i to meet the business/client requirements.
• Worked on BMC tool for Production support to resolve the BMC tickets.

Environment: Oracle ApplicationsR12 INV, PO, OM, AP, AR, PA, GL, Oracle 9i,PL/SQL, TOAD, SQL*PLUS, SQL*LOADER, Forms 6i, Reports 6i, Discoverer10g.

Confidential, IL

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Responsible for documenting technical specification as well as the Functional Specifications for requirements.
• Responsible for working on reports and creating concurrent programs in modules (OM, INV, AP, AR, GL, PO) customized and new reports.
• Worked in Inventory module on Item conversion to import items From legacy system to validate all item attributes and insures the same item accuracy as provided to the items that were entered manually.
• Developed the new reports and modified existing reports as per the user requirements.
• Developed and Customizing Standard Reports in PA, OM, and Inv - Most of the custom Reports designed and developed are from scratch.
• Developed program to load the Item on hand quantities using sql loader and Pl/sql.
• Involved in various activities like preparation of technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts, related report and form, unit level and user acceptance testing.
• Responsible for working on discoverer admin and desktop and created reports Inv Ageing Buckets report, stock balance report, Pick slip report.
• Involved in training and demonstration to end users.
• Developed interface programs, which will import all items, item categories and item attachments that are created using the Item Open Interface.
• Involved in developing of new interfaces, customization of existing interfaces and developed new reports and customizing existing Reports and Forms to 6i to meet the business/client requirements.
• Converted data from legacy systems to Oracle Applications by using Order management Order import program.
• Templates to extract legacy data. Templates show the basic setups for conversion and interface needs and column mapping between legacy and 11i applications.
• Developed program to load the Project contract using sql loader and Pl/sql.
• Templates to extract legacy data. Templates show the basic setups for conversion and interface needs and column mapping between legacy and 11i applications.
• Ensure daily activities like shipping transaction process and rectify any slippages in the transaction processing in Order management.
• Gaining knowledge on the inbound and outbound applications and resolving cross application tickets as and when knowledge expertise is achieved.

Environment: Oracle Applications11.5.10 INV, PO, OM, AP, AR, PA, GL, Oracle 9i, PL/SQL, TOAD, SQL*PLUS, SQL*LOADER, Forms 6i, Reports 6i, Discoverer10g.

Confidential, FL

Oracle Technical Consultant

Responsibilities:

• Identification and proposal of the customizations
• Development, unit and integration testing, preparation of test scripts and scenarios for System testing.
• Involved in various technical, process related and managerial activities.
• Involved in development and testing of various components which includes
• Interface to Update the Intercompany Item Cost from Legacy System - Developed an interface to upload item cost for intercompany items on a regular basis for a particular Inventory Organization of the Client.
• Inventory Aging Report to track the age of the items in a given sub inventory and split the quantity into age buckets.
• Tracking Employee Assignment Changes to comply with the SOX act and maintain the latest employee assignments in Oracle Applications. The program will capture the Employee Assignment details from the LDAP server send out an email to the Employee’s Supervisor in the event of any change in assignments. Also used Apps Extend and Apps rules to add a field to the User Definition form.
• Cost Comparison Report - Oracle Report to keep track of the difference in Actual and Market Cost.
• Used standard Oracle OE ORDER PUB API to create a new sales order and update/cancel an existing sales order in Oracle Apps System.
• Used standard Oracle OE HOLDS PUB API to apply/release holds on the sales order created.
• Commercial Invoice Report Customized the standard Commercial Invoice Report as per the client requirements
• Cogs and Revenue Report All invoice information (Invoices, DM and CM - Manual and Auto) information must be captured in the report.
• Logical Apps - Customized various Forms like ASL, PO, Item form, etc using Logical Apps Rules.
• Updated New Item Cost Report - Developed SQL Report to display all the new items that have been updated with PO cost and to mail the same to a list of users