SUMMARY:

• Oracle e - Business Suite Functional expert with 8.7 years of experience in design, support and implementation of software applications. Expertise in Oracle core modules including Order Management, Inventory, Service Contracts, Install Base, Purchasing, i-Procurement, BOM, WIP and Advance Pricing.
• Extensive experience in the functional aspects of Oracle applications 11i, Release 12.1.3 and 12.1.1. Worked across different modules of Supply Chain Management suite including Oracle Purchasing, Oracle Inventory, BOM, Oracle Order Management and Advanced Pricing.
• Experience with Business Intelligence and Data Warehousing concepts.
• Adept in reviewing and analyzing the as-is business scenarios, processes and activities, evaluating end user requirements, custom designing solutions and troubleshooting any problems during the process.
• Strong communications skills and leadership skills with an ability to interact with business users and lead business projects.

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Procure to Pay Functional Consultant

Responsibilities:

• Performed all Configurations and Setups for Order Management, Service Contracts, Install Base, Inventory, Purchasing, i-Procurement, BOM, WIP and Advance Pricing Modules
• Preparing BR30, BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications from BAAN & D1.
• Created New FSG Reports, using multi currency features including foreign currencies for multi org structures.
• Worked on Service Contracts and Install base module - Setup the QA Checklist, Main Contracts Billing program, Counters for usage based billing, Contract Templates, Contract Approvals, Auto and Manual Contract renewals, etc.
• Worked on Modifiers, Qualifiers, Price Lists, formulas for Oracle Advance Pricing module.
• Worked on a customization for Deferred Revenue in AR using Revenue Recognition process.
• Configured Item import process to import Part Number data from the non-Oracle ERP instance in Japan.
• Implemented Cycle counting, ABC Analysis in Oracle Inventory.
• Worked on Min Max and Reorder Point Planning in Oracle Inventory.
• Worked on the configuration of the 6 Key Flex Fields in Oracle Inventory
• Worked on the Setup of Transaction Types, Defaulting Rules, Processing Constraints, cascading attributes functionality in oracle OM
• Worked on the setup of Deferred COGS in Oracle INV
• Worked on the setups of the Inventory Orgs, Sub Inventories, Locators and Lots in Oracle INV module.
• Establish the best practices and controls in Oracle like... Security, Segregation of duties.
• Unit & Integration testing on all cross modules.
• Provided post Implementation support.

Environment: Order Management, Inventory, Purchasing, i-Procurement, BOM, WIP and Advance Pricing modules.

Confidential, San Diego, CA

Business Analyst / Oracle Functional Consultant

Responsibilities:

• Preparing business requirement documents for three different projects with the business rules associated to integrate the new company acquired by Petco into the original system and the new Oracle - SAP setup.
• Preparing business test scripts with the business rules associated with it to test the data after integration and related development for all the projects and signing it off for the Oracle Team as the Lead to the PM.
• Performed all the steps for Order Management, Service Contracts, Install Base Inventory, Purchasing, i-Procurement, BOM, WIP and Advance Pricing modules.
• Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
• Worked on the functional design of the Data warehouse for reporting of financial reports.
• Worked on the OBIEE Schema - to ensure that the Extract, Transform and Load process was optimal.
• Identification of Gap & put collaborative effort with the Technical team to address the same thro Technical Specification.
• Flow Testing for SCM Modules (Order Management, Service Contracts, Install Base, Inventory, Purchasing, i-Procurement, BOM, WIP and Advance Pricing) to make sure flow is working without any issues.
• Conducting Pre Project Review & Post Project Review.
• Managed the complete testing activities SIT, UAT and Oracle QA.
• Obtained and signed off documents and tests from Oracle ERP side.
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Environment: Order Management, Inventory, Service Contracts, Install Base, Purchasing, i-Procurement, BOM, WIP and Advance Pricing modules.

Confidential, San Diego, CA

Oracle Functional Business Analyst.

Responsibilities:

• Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
• Performed all the setups for OM, Advanced Pricing, Purchasing, Install Base, Shipping, i-Procurement, AR, Inv modules.
• Worked on the entire upgrade strategy to upgrade the application footprint from 11.5.10.2 to Release 12.1.1.
• Flow Testing for SCM Modules (AR, Service Contracts, Install Base, Order Management, Inventory, Purchasing, i-Procurement, BOM, WIP and Advance Pricing ) to make sure flow is working without any issues.
• Conducted Pre Project Review & Post Project Review.
• Provided Post Implementation support.
• Worked for the Category & Mapping data migration to meet the go alive deadline.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.

Environment: Order Management, Inventory, Purchasing, Service Contracts, Install Base, i-Procurement, BOM, WIP and Advance Pricing modules.

Confidential, San Jose, CA

Financials Functional Consultant

Responsibilities:

• As a Functional Consultant implemented the following modules Order Management, Inventory, Purchasing, i-Procurement, Service Contracts, Install Base, BOM, WIP and Advance Pricing.
• Worked on the Functional mapping of data Conversions & Enhancements for Order Management, Inventory, Purchasing, i-Procurement, Service Contracts, Install Base, BOM, WIP and Advance Pricing modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured Oracle Order Management, Inventory, Service Contracts, Install Base, Purchasing, i-Procurement, BOM, WIP and Advance Pricing modules from scratch and simultaneously created BR100 documentation for the setups.
• Setup the Approval Hierarchies in Oracle Purchasing module.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Completed Multi-Org configuration by creating a new Organization Structure for WYSE by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Conducted Regression testing to examine the effects of a new Org on the previous Org.
• Conducted Multi-Org Revert Testing to create an effective Revert Plan for WVI, as and when required.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in GL, AP, OM, INV and PO Modules.
• Created FSG Financial Reports critical to company’s business process.

Environment: Order Management, Service Contracts, Install Base, Accounts Receivables, PO, Inventory, i-Procurement, i-Expense, Purchasing modules.