SUMMARY

• Highly competent Oracle Supply Chain Business Analyst and Logistics Execution (LE) functional consultant with around 5 years of experience.
• Experienced in full life cycle implementation with AIM methodology - Scoping, Project Preparation, Business Blue Printing, Realization, Final Preparation, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities, Go-Live and continuous support including AS IS - TO BE and Gap analysis.
• Extensive experience with the Procure to Pay (P2P) and Order to Cash (O2C) process flows.
• Possess strong knowledge of Supply Chain Management modules of Oracle Applications, with major focus on OM, Advance Pricing (QP), WMS, Advance Pricing, PO, INV
• Expertise in analyzing and extracting core issues in complex business and technical processes as well as providing guidance and supervision to large and small groups.
• Experience in writing Functional Specifications for customizing RICEW and working experience with conversion and transfer of master and transactional data from legacy to ERP systems.
• Experienced in Post Implementation Production Support and training the end-users.
• Performed Unit Testing, Integration Testing and also assisted end users in User Acceptance Testing to validate the business scenarios using quality tools such as HP Quality Center.
• Experience with Oracle Business Accelerators for e-Business Suite Release 12 and AIM methodology. Handled Service Request (TAR)’s with Oracle.
• Efficient team member with excellent work/time management skills, excellent leadership

PROFESSIONAL EXPERIENCE

Confidential, Minnesota, MN

Oracle O2C Business Analyst

Responsibilities:

• Requirements gathering from end users, Requirement analysis.
• Worked on the entire Order to Cash business process.
• Performed all of the setups required OM, WMS, Advance Pricing (QP), PO, INV modules.
• Worked on the setups of Transaction types, Processing Constraints and Defaulting rules in Oracle OM Module
• Worked on the Inventory module - setup the Item Master, Item Attributes, Planning (Min Max and Re Order Point Planning), Cycle Counting, ABC Analysis, etc.
• Worked on the setups of the Inventory Orgs, Sub Inventories, Catalogs, Categories, Locators, Lots and Serial Control in Oracle INV module.
• Developed several enhancements to the Business Processes on the SCM side.
• WMS - Worked on the setups of the WMS Rules for Put Away, Picking rules, worked on cartonization, label printing rules, LPNs.
• Worked on Modifiers and Qualifiers in Oracle Advance Pricing
• Coordinated all rounds of CRP and SIT testing with the business users.
• Supervised and helped business users in UAT (User Acceptance Test) testing.
• Support Production issues on a day to day basis including month end closure p1 issues
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Categories, Document Sequence Assignment, Profile Options.
• Preparing the BR030, BR100, To-Be Document.
• Prepared MD050 functional design document.
• Prepared the test script documents TE040, TE050 & TE130 for SIT & UAT testing.
• Prepared i-procurement training manual for the Ship users and the Casino Managers.

Environment: Oracle EBS 12.1.3/11.5.10 , OM, INV, Advance Pricing, WMS

Confidential, Seattle, WA

Oracle O2C Business Analyst

Responsibilities:

• As a Functional Business Analyst implemented the O2C Functional Modules including OM, Advance Pricing, WMS, INV, AR and Shipping modules
• Performed Requirement and Gap analysis.
• Configurations and Setups for Purchasing, e-Business Tax, i-Procurement, AP, Inventory, Procurement Contracts
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials 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.
• Worked on setting up the Transaction Types, Defaulting Rules, Processing Constraints in Oracle OM Module.
• Worked on the Drop Ship, Back to Back Order and IRISO Process flows in Oracle OM
• Worked on the setups for Reverse Logistics process to handle RMAs.
• Worked on setting up the Modifiers and Qualifiers in Oracle Advance Pricing module.
• Worked on the setups in Oracle WMS
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on a day to day basis including month end closure p1 issues
• Implementation and support of Accounts Receivables and Account Payable Module
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across OM, INV, PO and AR) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Environment: Oracle E-Business Suite 12.1.3, OM, AR, WMS, Advance Pricing, INV, PO, Manual Testing, Win runner, Load runner, Test Director and Windows 2003 server.

Confidential, Berkeley, CA

Oracle O2C Functional

Responsibilities:

• As a O2C Functional Consultant implemented financial modules: OM, INV, BOM, WIP, WMS, Advance Pricing and PO Release 12 of Oracle e-Business Suite.
• Worked on the setups of Purchasing, e-Business Tax, i-Procurement, AP, Inventory, Procurement Contracts
• Created New FSG Reports, using multi currency features including foreign currencies for multi org structures.
• Worked on Oracle OM Module - defining the Drop Ship, Back to Back, IRISO process, setting up the Transaction Types for header and line flows, defining the price lists, discounts, surcharges, freight charges, etc.
• Implemented internal control features using Form Personalization’s for modules CM, GL, AP, and AR.
• Implemented the WMS module
• As part of Production Support team was involved in supporting the users for issues with performance, data and training. Was also involved in support the month end and quarter end process including helping reconcile and fixing of interface issues.
• Implemented Outbound interfaces for AP for creating payment outbound file for uploading into banks.
• Used Mercury Quality Center to define and execute test scripts.

Confidential, Houston, TX

Oracle Functional Consultant

Responsibilities:

• Performed all the setups for Purchasing, e-Business Tax, i-Procurement, AP, Inventory, Procurement Contracts modules.
• As a Functional Consultant implemented financial modules: Purchasing, e-Business Tax, i-Procurement, AP, Inventory, Procurement Contracts Release 12 of Oracle e-Business Suite.
• Worked on the setups of Purchasing, e-Business Tax, i-Procurement, AP, Inventory, Procurement Contracts module.
• Involved in the Business requirement gathering for Purchasing, e-Business Tax, i-Procurement, AP, Inventory, Procurement Contracts
• Supporting financial system changes to support new product launch following SDLC methodology for Project Management
• Understanding the business process changes with new product launch, documenting the new Business requirements
• Designed changes required in the downstream process (AR/IB/SC) modules as new product involved a concept of nested BOMs.
• Developed new processes and forms to accommodate changes in the Order Management and RMA side of the business.
• Prepared Business Requirement Documents (BRDs) and Functional Requirement Documents (FRDs)
• Mediate between end users, business sponsors, developers and testers to make sure there are no communication GAPs
• Conducted Conference Room Pilots (CRPs), and monitoring UATs.
• Working on TOAD and Oracle 11i system

Confidential, Chicago, IL

Oracle App Functional Consultant

Responsibilities:

• As a Functional Consultant implemented financial modules: GL, AP, and AR, OM, INV and PO Release 11.5.10.2
• Performed all the Configurations and Setups for INV, PO, OM, AR, AP and GL 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 a customization for Deferred Revenue is AR using Revenue Recognition process.
• Implemented internal control features using Form Personalization’s for modules GL, AP, and AR.
• Configured Auto Invoice in AR to import data from the non Oracle ERP instance in Japan.
• Implemented TCA - for AR customer master conversions.
• Implemented the Data Quality Management (DQM) in TCA.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks.
• Designing and executing ‘Data migration’ strategy for Master and Transactional data. Migrated GL Balances, Budgets, Suppliers, AP open Invoices, Customers, AR open Invoices, Fixed Assets by using ADI tools and loader scripts.
• Establish the best practices and controls in Oracle like... Security, Segregation of duties.
• Unit & Integration testing on all crosses modules.

Environment: Oracle E-Business Suite 11.5.10, Manual Testing, Win runner, Load runner, Test Director and Windows 2003 server.