SUMMARY:

• I have total 23 years of IT experience with more than 19 years of Oracle Applications experience working on projects in the consumer, direct channel, trade, manufacturing, petrochemical, health care and financial sectors. I have extensive experience in ERP implementations, upgrades, designing, business analysis, customization, interfacing, data conversion, development and database management on different Oracle application releases.
• Application Object Library, Order Management, Oracle Contracts, Receivable, General Ledger, Advance Pricing, Inventory, Purchasing, iProcurement, ASCP, SLA, Accounts Payable, Cash Management, Fixed Assets, WIP, BOM, Field Service, Install Base, Depot Repair and iPayment.
• I have completed 5 global full life cycle implementations, including international implementations involving multi - org, multi-currency.
• Have strong Functional experience on Order to Cash (OTC) including Oracle Advanced Pricing and Procure to Pay (P2P), Install Base and Contract Modules.
• Extensive experience in working with third party vendors, including Oracle On-Demand and internal and external (offshore) development teams.
• Conduct meetings with business users to understand the business processes and gather business requirements and prepare BR100, MD50 and MD70 for (RICEW) .
• Strong experience with APIs (PL/SQL) and have developed and modified many workflows.
• Have worked on many EBS upgrades from 11i to R12, 10SC to 11i and 11.0.3 to 11i.
• Strong experience in application configuration, writing migration/conversion strategy, interface development, system testing, user training, preparing test scripts, support users during CRPs, SIT, UAT and production support.
• Co-coordinating Integration of Oracle Applications with Non-Oracle feeder systems.
• In-depth Knowledge of Application’s Architecture and the underlying File System Structure on the Application Tier and Database Tier.
• Have worked on integrating third party applications like Vertex (Tax Software), Webshpere, Hyperion, Oracle Data Integrator (ODI), Business Object (BO), Chase Paymentech (credit card) with different flavors of Oracle EBS.
• Expertise in managing full cycle implementation, upgrade, customization, enhancements and support projects spanning Finance, Order to Cash (OTC), Procure to Pay (P2P), Install Base, Field Service and Service Contract modules.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS Functional Specialist

Responsibilities:

• Functional lead for the integration between R12 and IBM Websphere involving Oracle Order Management (Subscription Plan), Advanced Pricing, AR and TCA.
• Have strong experience with Oracle Advanced Pricing both on Trade and Consumer side of the businesses. Have setup complex modifiers, custom qualifiers, formulas to calculate discounts, promotions, surcharge and freight.
• Strong experience in setting up Order to Cash flow between Order Management, Contracts and AR modules for subscription model.
• Implemented Revenue Recognition process to recognize revenue from Subscription Program before actual billing through Contracts to AR to GL.
• Have modified Revenue Recognition workflow to meet the user requirements.
• Responsible for analyzing and fixing all production issues related to Order Management, Advanced Pricing, Install Base and Service contract modules.
• Designed of the overall conversion strategy for the conversion of balances from legacy systems onto Oracle Applications.
• Developed test plan and accommodate changes as required at different stages of implementation.
• Lead the UAT, driving test script execution for OM, Pricing, AR and iPayment modules.
• Assist technical team during the design, development and testing phases.
• Provide end user training and support to resolve application issues.
• Performed gap analysis and functional design for the implementation of Order to Cash (OTC), Install Base and Contract modules.
• Implemented interface between Fixed asset and Oracle Install base to create assets in FA for loaned equipment.
• Collaborate with different teams to explain and understand the interoperability aspects of the system.
• Implemented Order Management/AR and Chase Paymentech Credit Card integration on 11i and R12 Applications.
• Setting up alerts, system privileges, security and approvals.
• Implemented AR Lockbox integration with Chase,
• Integrated Shipment applications like Fedex and Pitney Bowes with Oracle EBS.
• Implemented Markview integration with Oracle Payables to automate the invoicing processing.
• Functional support for the Customization of Oracle standard Cost extension API to fix the gap.
• Modified many Oracle standard workflows to meet the user requirements.
• Have worked on Functional aspects of the implementation of following Data Migrations,
• From legacy systems to EBS 11i and From EBS R12 to JD Edwards 9.1
• Pitney Bowes Shipping System ( Confidential integration) -- Shipment Processing
• Thorough knowledge and experience in setting up and maintaining Oracle iPayments (IBY) module.
• Integrated Vertex Q series with EBS R12 and JD Edwards for US and Canada operations.
• Data integration between WS and Oracle EBS using ODI ETL.
• Implemented Hyperion and EBS integration using ODI ETL.
• Have developed many Confidential reports.
• Workflow administration and development.

Confidential

Oracle Applications Order to Cash Functional Consultant

Responsibilities:

• Team member responsible for preparing the conversion plan for O2C modules.
• Assist technical team during the design, development and testing phases.
• Provide end user training and support to resolve application issues.
• Responsible for preparing test plans, writing test scripts and help users during the CRPs, SIT and UAT phases of the implementation and post go-live support.
• Responsible for implementing interfaces needed for item receipts and order shipments.
• Restructured the complicated advanced pricing setup during this project.
• Collaborate with different teams to explain and understand the interoperability aspects of the system.
• Customized Oracle Standard PO approval workflow to meet the user requirements.
• Thorough knowledge of Oracle Reports, Forms and Oracle supplied PL/SQL APIs.

Confidential

Order to Cash (OTC) Functional Consultant

Responsibilities:

• Oracle Applications 11 to 11i upgrade project including integration upgrade with 3 subsidiaries.
• Conduct meeting with business users to understand the business processes and gather business requirements for BR100 for Order to Cash (OTC/O2C) Modules.
• Redesigned the currently complex Pricing structure and reduce the number of modifiers drastically, this also improved the performance of order entry.
• Prepare the conversion plan for the Order Management and AR modules.
• Help end users during the SIT, CRPs and UAT.
• Make changes to test plans and scripts based on the design change during CRPs.
• Worked with technical team to explain the functional and technical aspects of the system to better understand and resolve issues.
• Work with Oracle support to identify the bugs and coordinate with different teams to test and migrate with the help of SDLC tool.
• Post go live support.
• Integrated external order entry system with Oracle EBS to bring in Customers and Orders.
• Implemented Auto Invoice program for loading invoices, debit memos, credit memos and on account credits from legacy systems Also worked on the conversion program for AR receipts using receipt PL/SQL APIs.
• Have worked extensively on Oracle forms personalization and CUSTOM.pll for different APPS modules.

Confidential

Order Management/Pricing Functional Consultant

Responsibilities:

• Functional Lead for 11i Order Management and Oracle Advanced Pricing implementation.
• Responsible for meeting with business users to understand the business processes and gathering business requirements for BR100 and prepare MD70 and MD50.
• Prepared conversion strategy, data mapping, test scripts, reconciliation of data between legacy and 11i,
• Coordinating with other team members to ensure that interoperability is correctly established between different module’s customizations.
• Responsible for reorganizing Price List, Pricing modifiers, Formulas, custom qualifiers etc.
• Leading the CRPs and UAT, also supporting users and technical team to better understand the issues and possible causes.
• Workflow Administration and Troubleshooting.
• Worked with DBAs during the data conversion to ensure the smooth cut over.
• Have done many form personalizations to enforce the business rules during the order entry process.
• Post go live support.

Confidential, New Jersey

Oracle EBS Order Management/ Pricing Consultant

Responsibilities:

• Part of the 11.0.3 EBS implementation team.
• Techno-Functional team member for Order Management, Pricing and GL modules.
• Team member responsible for developing conversion strategy, writing, test script and prepare MD70 and MD50
• Designed, setup and implemented price lists, modifiers for trade and consumer line of business.
• Implemented Sales Order interface to upload Sales Orders from external systems.
• Working with Oracle support, creating TARs to resolve Oracle application issues.
• Functional support for the Migration of closed and cancelled sales orders and RMAs from legacy system to Oracle order management.
• Modified PO requisition workflow to suit the user requirements.
• Designed, coded and implemented AR and AP invoice interfaces using PL/SQL.
• Implemented application for Treasury to find out the daily cash flow by pulling data from AR, AP and GL systems.
• Implemented GL interface to allow any number of external applications to interface to GL.
• Implemented GL Intra-Company sweep application for two sites.
• Implemented GL chart of accounts synchronisation between 11i and 10.7 instances as part of one day close project.
• Implemented price list assignment application to assign multiple items to multiple price lists programmatically using oracle supplied API.
• Worked on many conversion processes as part of the migration from 10.7 and legacy systems to 11.0.3 Oracle application.
• Implemented an inquiry module to bring AR and Order entry transactions on a single screen.
• Implemented Order import to receive orders from third party legacy system.
• Implemented Locator/ Sub-inventory/Item tie program to automatically tie multiple items to locators and sub-inventories for Inventory module.
• Experience in Discoverer 4i and Vista Plus 4.3 .
• Have tuned data warehouse application queries in 9i IAS to parallelise the execution to improve the performance.
• Production support, trouble shooting and bug fixing.
• Monitor and maintain Decision Point Analyst (ETL tool) from Oracle EBS.

Confidential

Oracle Application Analyst Cum Sys. Admin

Responsibilities:

• Techno-Functional Lead for the entire project including, Finance and Purchasing.
• Work with business users to gather requirements, gap analysis, prepare BR100, MD50 and MD70.
• Part of the overall conversion plan and create detailed strategy for the rollout and post go live support.
• Work with technical team to explain business scenario, application functionalities and identify the gap.
• End to end testing of processes before deploy it to end users for CRP or UAT.
• Work with business users to create test scenarios, select controlled data set, prepare test scripts, and help them during the SIT, CRPs and UAT.
• Enabled Descriptive & Key Flexfields.
• Responsible for creating users, custom responsibilities, value sets, enabling flex fields, scheduling concurrent programs, system and user profiles, registering new printers.
• Monitor the application for most time consuming jobs and rectify issues if any.
• Monitor the data growth, object growth and other storage issues.
• Applied patches for Oracle Applications sending by Oracle Support.
• Have involved in troubleshooting and database tuning.
• Production support and work with Oracle support to get the right patches for bugs and test them in different instances before migrating to production.