SUMMARY:

• I am having 17 plus years of experience in Oracle Apps as a Techno - Functional and is being presented for the role of Oracle Consultant/Permanent role.
• Expertise in the following aspects of Oracle Applications (OM (Order entry, Shipping Execution & Advanced Pricing), Advanced Supply Chain Planning, Inventory, Purchasing, Oracle Process Manufacturing, Oracle Payables, Oracle Receivables, AOL).
• Worked extensively with Account Generator for P2P Cycle including iexpense and iProcurement.
• Solid Oracle Applications experience as Techno-functional consultant in the various modules.
• Extensively worked on Oracle Workflows, Forms Personalization,Inventory Client Extension and OAF.
• Worked extensively on preparing AIM documents like MD50, MD70 and MD120.
• Expert knowledge of efficient SQL query design (query optimization techniques, hints, etc)
• Worked on XML Publisher.
• Extensively worked in Oracle Reports and Discoverer 4i.
• Extensively used Business Process Execution Language (BPEL) with the help of JDeveloper 10g tool, for the development of the various Interface programs in Financial and Fixed Asset Modules.
• Customized the complex Extension components like Account Generator workflows in P2P cycle during the implementation.
• Developed various wrapper Interfaces programs which include the basic functional validation, user friendly error description and using standard API’s call, in the modules like Order Management and Financial modules.
• Good knowledge in functional aspects of Oracle Applications Purchasing, Inventory, ASCP, OPM and Financials.
• Knowledge of Oracle Database Administration (Schema Architecture, SQL Performance tuning, etc).
• Responsible for various phases of software development such as System Study, Analysis, Coding Testing and Documentation.

TECHNICAL SKILLS:

Packages: Oracle 11.5.8, 11.5.9, 11.5.10, 12i.

Modules: Account Payables, Account Receivables, Confidential Import, Oracle Purchasing, Order Management, Shipping, Advanced Pricing, Advanced Supply Chain Planner (ASCP), OPM, Inventory, iExpense, iProcurement

Languages: Oracle Developer suit (Forms 10i, Reports 10i), Oracle Discoverer, SQL, PL/SQL, BPEL, PASCAL, C, C++, Core JAVA.

Database: Oracle 8i/9i.

Tools: OAF, Workflow builder, JDeveloper, Translation Builder, Forms Builder, Reports Builder, Toad, Discoverer 9i (Administrative and Desktop Builders).

O/s: UNIX, Windows NT, Windows 2000, Windows XP.

PROFESSIONAL EXPERIENCE:

Confidential, Ohio

Responsibilities:

• Oracle Vendor Consignment implementation 12.1.3 OPM
• Support the R12 modules and adhere to ad hoc user requirements.

Environment: R12 OPM, Oracle Applications Supply Chain and distribution (Inventory Management, Order Management, Purchasing, ASCP, Order Management & Shipping Execution), Advanced Pricing. EDI

Confidential, Cleveland, Ohio

Responsibilities:

• This project is Oracle R11 Support and R12 implementation with SCM modules.
• Worked on the Interface to automate Intercompany P2P cycle (PO Requisition, Internal Sales Order, PO receipt) with the legacy application (data in flat file).
• Worked extensively with the Inventory intercompany (Setups and Interface to load from flat file) and transfer pricing.
• Worked on the Oracle Procurement Form Personalization & Customization on the standard forms to fulfill the business needs.
• Worked on the Shipping Network and Sourcing Rules setups.
• Worked extensively with on SQL tuning (Forcing a plan, SQL optimization, etc).
• Used to pl-sql analytical functions for efficient and effective code and performance.
• Design the Functional design and Technical design documents.
• Involve in GAP analysis for the Integration between the legacy applications and Oracle Apps (Order Entry, PO Requisition, Autocreate PO, PO Receipts).

Environment: R12/R11 Oracle Applications Supply Chain and distribution (Inventory Management, Order Management, Purchasing, iProcurement, Order Management & Shipping Execution), Accounts Receivables, General Ledger, Advanced Pricing

Confidential, San Jose, CA

Responsibilities:

• This project is Oracle Apps R12 project mainly with Order Management and Advanced pricing modules
• Gather business requirements, feasibility analysis, participate in scheduling the implementation timelines.
• Interact with Development team- making team understand the business solution thru the Functional design and technical design documents.
• Help Development team on need basis by assisting them with pseudo logic and SQL performance recommendations.
• Design the Functional design and Technical design documents.
• Involve in GAP analysis.

Environment: R12 Oracle Applications Accounts Receivables, General Ledger, Oracle Purchasing, Order Management, Advanced Pricing, HRMS, Inventory Modules

Confidential, Chicago, IL

Responsibilities:

• I was involved in the development, design and preparing design documents for the following conversion objects: Item conversion, Suppliers, Purchase Orders, AR Receipts and AR Open Invoices
• Attend daily status meeting hosted by the Project Manager.
• Analyzing the existing Oracle objects (includes PL-SQL packages, Forms and Reports).
• Invoiced in writing design document for PO Approval Workflow, Defining sourcing rules.
• Worked on the AP Check printing Using XML Publisher.
• Worked on the Employee Assignments Interface.
• Worked on the Employee Load using WebAdi.
• Worked on the AR ACH and PCard processing.
• Worked on the Bank Statement Reconciliation process.
• Interaction with Off-shore development team

Environment: R12 Oracle Applications Accounts Receivables, General Ledger, Oracle Purchasing, Order Management, iProcurement, HRMS, Inventory Modules

Confidential, Sunnyvale, CA

Responsibilities:

• Perform the feasibility study by requirement gathering from the Business personal, IT Team and through GAP analysis.
• Attend daily status meeting hosted by the Project Manager.
• Analyzing the existing Oracle objects (includes PL-SQL packages, Forms and Reports).
• Worked on the XML Reports in purchasing module (Prepayment application).
• Develop the Functional design document.
• Develop the Technical design document.
• Co-ordinate with off-shore team and help them in coding as per the Confidential standards.
• Worked on Oracle Procurement Workflows (PO Approval (process: Can Owner approve), PO Document Copy)
• Worked internal PO Requisitions for Intercompany transactions.
• Prepared User Guide manual for AR and Purchasing Module.
• Preparation of MD50, MD70 and UAT documents for all the interface modules.
• Worked on the ASL and Sourcing setups, Automatic of PO Release form blanket Agreement.
• Involved in Playbook setup for PO, Inventory and AR for an Operating Unit.
• Worked on Open Interface for Purchase Orders import.
• Worked Advance Pricing (Primary pricelist and secondary pricelist import).
• Extensively worked on the Data conversions using SQL Loader and FND FILE utilities

Environment: R12 Oracle Applications (Accounts Receivables), Oracle Purchasing, Order Management, Aceva Collection Module

Confidential, Sunnyvale, CA

Responsibilities:

• Confidential Inc. is implementing the Blue Store Order valuation process for various Items categories such as Service items, Software items & Hardware items. The modules involved in this implementation are Order Management and Advanced Pricing
• Understanding of the Blue Coat Order processing & advanced pricing modules.
• Implementation of the WANOp discount using Advanced Pricing and Dynamic formula
• Gathering Business Requirements from End User and project team
• Prepared the BRD’s, Functional Design Documents and Technical Design Documents
• Worked on functional setups such as defining a new modifier, dynamic formula and defining new OM Holds
• Worked on customization of order line workflow
• Involved in Customization of Shipment Details report and Order Discounts report
• Involved in Oracle Form Customization to define the WANOp discount
• Perform through testing of the interface and provide support on moving it to QA and production environment
• Monitor the performance in Production and provide the support

Environment: R12 Order Management Advanced Pricing, R12 General ledger,XML Publisher, Perforce

Confidential, San Jose, CA

Responsibilities:

• Confidential has implemented the Single Trading Company (Operating Unit) for better taxation & accountability. Hence impacts the various existing components and new developing components to fulfill this requirement
• Worked in the Inventory Accounting includes Intercompany Account, Advanced Replacement Sales Orders and Product Returns.
• Virtual Trader (third party tools) is used to oracle accounting.
• Developed the Functional Design and Technical design for the Common Utilities functions (includes the Sub-Inventory for a transaction, Virtual Trader Entity Details, Getting the Operating unit short name, Product groups (defined in the DFF)) .
• Designed the functional and Technical design for Write-Off report for the Sales Order Shipping lines.
• Participated in various Transition meetings and Quarterly/Monthly released.
• Worked on the PO Receipts (Receipts and Delivery) Interface program.
• Worked on the Advanced Replacement report for a sales order transaction.
• Worked on the Design & Architecture of the CTS VT Reconciliation Report.
• Participated in quarterly and monthly transition meetings/releases.
• Worked on the SQL performance tuning for the Reconciliation Report.
• Worked on the Pricelist Interface program For Brazil, For Spares in C3 Instance. Spares pricelist includes End of Life Items.
• Worked on the Playbook setups for UK Home & Brazil Operating Unit setups (includes Inventory, Advanced Pricing, Receivables & Payables).

Environment: Inventory, Oracle Purchasing and Order Management, Virtual Trader (Third Party tool, Looks like other Oracle Application modules), R12 General Ledger

Confidential, Palm Desert, CA

Responsibilities:

• Confidential is an Advertising company, implemented Oracle Applications 11i
• Understanding of Collaborative Workbend.
• Developed the Oracle Report to show the forecast qty in the weekly bucket (includes the past due and future dates) for an item /sales channel combination, using the table’s sales data and mdp matrix. The report output will be generated in .csv format.
• Worked on Supply Chain Planner and Engineering modules.
• Developed some of the very complex ASCP Reports such as MRP Summary and Excess Inventory Reports.
• Good Exposure in ASL (Approved Supply List), Sourcing Rule, BOM Substitute, Item Relationship form, constraint based planning (CBO).
• Developed majority of the ASCP Reports.
• Developed the Forecast Upload Interface program for Domestic, Internal and International along with the exception handling form.
• Daily interaction with the client to gather functionality and for additional information related to the customization.
• Good Functional knowledge about the planning cycle and planning options.
• Extensively used PL/SQL Packages to generate weekly Horizontal Plan similar to the ASCP Work-Bench.
• Used SQL Loader in the Forecast Upload Interface program.
• Worked on Physical Inventory Custom Form. This Form captures the actual inventory item wise at the sub-inventory level.
• Done the post product user-support.
• Worked on Internal Sales Order Report.

Environment: Oracle Applications 11i (Demantra, Advanced Supply Chain Planning, Engineering, Inventory, Purchasing and Order Management), SQL Loader

Confidential, Houston, TX

Responsibilities:

• Confidential is the Oil and Gas dealer and recently implemented 11i E-Business Suit. Few of the interfaces and gaps need to be developing to interface with the existing legacy systems
• Worked on AR Invoice Interface using Auto Invoice import program.
• Worked on AR Adjustment using standard API (Ar Adjust pub).
• Worked on AP invoices using Payables Open Invoice Interface.
• Developed AP invoice Interface program along with the project information.
• Worked with OM Advanced Pricing Interface (Modifier list creation /updation, Qualifier Rule Creation)
• Daily interaction with the client to gather functionality and for additional information related to the customization.
• Extensively used BPEL in all the interfaces developed, primarily to integrate the legacy databases and to schedule the program.
• Intensively worked on Dynamic triggers.
• Worked on event based Oracle Alerts.
• Worked on Conversions and Data Migration for AR Invoices (Used Auto Invoice import program), AR Adjustment (Used API (Ar Adjust pub), AR Receipts (Used API (AR receipt pub)) to transfer data from legacy system.
• Used UTL FILE utility for Data Conversion to create a file and to read the file from the server.
• Prepared MD70 and MD120 documents for each of the component developed.
• Used PVCS for deliverable files version control

Environment: Oracle Applications 11i (AR, AP, Confidential import), OM Advanced Pricing, XML Publisher, PVCS.

Confidential

Responsibilities:

• Inventory Costing Account Generator (Using Client Extension).
• Customization of Inventory Client Extensions.
• Extensively used Form Personalization in “Quick Sales Order” Form.
• Customization of following Oracle Workflows:
• PO Create Documents: Copying the Requisition Attributes to the PO.
• PO Approval: “Do Document Changes Require Re-approval in?” (Process) and customized “Can Owner Approve” function in “PO Approval” Process.
• AP Invoice: Customized the notification.
• Intensively used Oracle Reports and developed complex reports like Customer statement Report, Wire payment Report (AP), etc.
• Extensively worked on Discoverer 9i.
• Worked on Forms Customization using Custom PLL and Forms Personalization.
• Worked on RICE components.
• Developed the White paper on Account Generator and Customization.
• Customization of standard Batch Creation Form (OPM, Process Execution) using Forms Personalization.
• Daily interaction with the client to gather functionality and for additional information related to the customization.
• For every object developed or customized MD70 and MD120 was prepared.
• Used PVCS for version control

Environment: Oracle Applications 11i (PO, AP, INV, I Procurement, I Expense, OPM, Oracle Workflows, AME), Window XP, Oracle 8i, TOAD, PL/SQL, SQL* Plus, PVCS

Confidential, San Diego, CA

Responsibilities:

• This project is an Up-gradation project. The major activities were performed in core business areas such as manufacturing, finance and planning.
• Developed interfaces in Order Management used the OM API’s to Auto-Allocate, Auto-Pick and ship-conform.
• Worked on Order Import in OM.
• Customized few of the Shell Scripts.
• Worked on customizing the standard reports in OM, AR using Reports 6i.
• Involved in the Form Development in oracle Applications environment using Forms 6i.
• Prepared the following document for every deliverable: code review checklist, Technical Design document (MD70), Installation document (MD120).
• Up gradation of OPM Reports like Item Re-order Level, Ingredient Reporting report.
• Daily Client Interaction.
• Used PVCS for Version Control tools.

Environment: Oracle Applications 11i (OPM, OM, AR, INV), UNIX, Window XP, Oracle 8i, TOAD, PL/SQL, SQL* Plus, PVCS.

Confidential

Responsibilities:

• Confidential is Coating, glass and chemical manufacturing company and its divisions are spread across the Europe and Asia pacific (APAC) regions.
• Extensively worked on Advanced Pricing and the following were the Interfaces Developed:
• Pricing interface: This interface was developed for the various Qualifiers (Customer, Item Category, etc) along with the secondary pricelist. Standard Pricelist, Qualifier API’s were used while coding.
• Modifier-list interface: Standard modifier-list API’s was used.
• Developed the following Order Management Interfaces using standard OM API’s for Order Creation and Auto-Allocate
• Migration of 10.7 AR reports objects to 11i.
• Worked on Issues with Auto Invoice.
• Involved in Form Development in Oracle Application environment.
• Frequent Interaction with client to gather additional information and incase of any clarification.
• Involved in the preparation of MD50, MD70 and MD120 and code review checklist

Environment: Oracle Applications 11i (AOL, OM, PO, AR, AP), UNIX, Window XP, Oracle 8i, TOADPL/SQL, SQL* Plus, PVCS

Confidential

Responsibilities:

• Confidential is a milk product manufacturing company. My employer had a contract to upgrade the existing system and to develop the extensions.
• Involved in customization of “Lot Allocation” (Order Management responsibility) standard Oracle Form.
• Worked on Journal Import in Confidential .
• Worked Extensively with the Process Execution Module (OPM).
• Worked on Asset Conversion in FA.
• Worked on Custom PLL to call another form from the customized LOT ALLOCATION Form within the OM Responsibility.
• Involved in OM and OPM reports migration from 10.7 to 11i.
• Used Translation Builder to generate the form in French.

Environment: Oracle Applications 11i ( Confidential, AP, AR, FA, OM, OPM), UNIX, Window XP, Oracle 8i, TOAD, PL/SQL, SQL* Plus, PVCS, Translation Builder.