SUMMARY

• 8.3 years of IT Experience, which includes experience as Confidential Functional Consultant/Business Analyst with specialization in Oracle Financial and Distribution Systems
• Industry experience revolves around Oracle ERP Applications - Implementation, Support and Upgrade.
• Worked on all the Oracle Supply Chain Modules - Quoting, Advance Pricing, Shipping, OM, INV and PO. Have 2 full life cycle implementations in Release 12. Worked on both the “Quote to Cash” process as well as the “Procure to Pay” process.
• Exposure to VSOE and SOP-92 revenue recognition principles as well as US GAAP Principles
• Extensive experience with Training of End Users and Business Super Users using Oracle Tutor, WebEx virtual training and well as conducting of CRP’s and UAT’s. Well versed in preparing training material and training manuals.
• Responsible for testing of the functionality of Oracle ERP Application
• Conversant with documentation as per the AIM methodology.
• Involved in scoping and mapping of business requirements of clients for Oracle Financials/Distribution solutions.
• Involved Conference Room Pilots and User Acceptance Testing.
• Also, responsible for building, testing & development as per Business Requirements.

PROFESSIONAL EXPERIENCE

Confidential

Distribution Functional

Responsibilities:

• Actively involved in implementation and integration activities with modules such as- Quoting, OM, Advance Pricing, INV, PO, Shipping
• Automated procurement processes significantly and Leveraged Buyers work center and i-Procurement to perform daily procurement activities.
• Worked on all of the setups of the OM Module - including setting up the Transaction Types, processing constraints, defaulting rules, Credit Usage rules, credit profiles, custom holds, etc.
• Worked on the Advance Pricing setups of Modifiers and Qualifiers
• Worked on setting up Multi Currency Price Lists in Advance Pricing
• Worked on defining custom attributes and attribute mapping for advance pricing
• Worked on the bulk price list upload to load prices into Advance Pricing
• Worked on the Get Custom Price API for publishing of prices to external custom systems.
• Led & coordinated tasks related to conversion and mapping of requirements from Ariett & Softrax (old system) into Oracle Financials R12.
• Actively communicated with Buyers, Controllers, Budget Managers and CFO’s, to optimize the approval workflow for requisitioning within the company.
• Created and maintained all functional design documents and Visio process flow diagrams
• Identified existing gaps, worked on solutions, and collaborated with the technical team to develop workarounds and customizations to enhance efficiency of existing business process.
• Initiated Global training sessions and walk-throughs within the application.

Confidential

Oracle Distribution Functional Consultant

Responsibilities:

• Responsible of business requirements gathering and definition, gap analysis and process mapping
• Prepared detailed use cases to capture the interaction between user and software, visually present Confidential flow of business model and to determine functional design expectations during systems and environment testing
• Worked on the setups of Oracle Advance Pricing for Purchasing module
• Worked on the setups of Modifiers and Qualifiers in Advance Pricing
• Worked on the setups of Dynamic formulas in Advance Pricing
• Worked on volume based pricing in Oracle Advance Pricing.
• Worked on Coupons and Buy One Get one free pricing in Advance Pricing
• Worked on Attribute definition and Attribute mapping in Advance Pricing module.
• Worked on the setups of the TCA - including the Parties, Accounts, Account Relationships, Party Relationships, Party Sites, Account Sites, Party Relationships, etc.
• Performed all of the setups for Quoting, OM, Advance Pricing, INV, PO, Shipping modules
• Effectively designed and deployed Confidential new Chart of Accounts and Ledger structure that best supports external and internal corporate management reporting requirements, while simplifying transaction entry.
• Interacted with key stakeholders and gathered requirements to perform corporate financial consolidations, and associated reporting, for numerous corporate entities
• Work directly with the system developers to implement and maintain system changes
• Overseeing day to day performance and schedules, communication to financial community, and security administration tasks
• Issue maintenance requests for all system and balance errors
• Key responsibilities also include management of User Acceptance Testing cycles and end user documentation; Efficiently organized test plan and scenarios for functionality testing and conducted business end-to-end manual testing
• Implemented and identified improvements to the existing interfaces and processes
• Responsible of post-production support for Oracle Modules of Quoting, OM, Advance Pricing, INV, PO, Shipping

Confidential, LA, CA

Oracle Functional Consultant

Responsibilities:

• Worked on the entire Distribution (Order to Cash and Procure to Pay) business process.
• Performed all of the setups for i-Procurement, Advance Pricing, INV, Quoting, OM, Supplier Hub, INV, PO modules
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on Confidential day to day basis including month end closure p1 issues
• Worked on conducting Conference Room Pilots (CRP) and User Acceptance Testing (UAT)
• Developed Test Scripts and Executed Test Scripts.
• Worked on Mercury Quality Center to log defects and report back to the team.
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across i-Procurement, Advance Pricing, INV, Quoting, OM, Supplier Hub, INV, PO) 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

Confidential, San Diego, CA

Distribution Functional Consultant

Responsibilities:

• Understanding the existing business processes including PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing modules
• Preparing existing business process documents
• Mapping the business processes with Oracle standard functionalities and identifying the gaps.
• Giving demonstration of standard functionalities of PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing to the Business Users.
• Proposing solutions and customization for gaps and getting the approval from business users.
• Working with Technical team closely and getting done development for customizations for PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing Modules.
• Working closely with Business users to understand the criteria’s and filters for converting data from 11.0.3 to 11.5.10 for PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing
• Preparing BR100 and Completing the Setups and configurations for PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing
• Preparing the test cases for PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing modules
• Conducting CRP1, CRP2 UAT1 and UAT2 and helping the user for going through all the test cases.
• Fixing the issues collecting during CRP1, CRP2 and UAT.
• Working 24 by 7 during cutover and down time
• Providing support to users after implementation is done and fixing all issues related to set ups
• Fixing the issues for converted data for PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing modules

Environment: Oracle Apps 11.5.9/11.5.10 e-Business suite (PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing)

Confidential, Sunnyvale, CA

Distribution Functional Consultant

Responsibilities:

• Understanding the existing business processes including AR, AP, PO, i-Procurement, GL, & Cash Management
• Preparing existing business process documents
• Discussing with business users and preparing BP80 for future To Be Process documents for AR, AP, PO, i-Procurement, GL, & Cash Management
• Mapping the business processes with Oracle 11.5.10 standard functionalities and identifying the gaps.
• Giving demonstration of standard functionalities of AR, AP, GL, PO, and i-Procurement, FA & CASH Management to the Business Users.
• Proposing solutions and customization for gaps and getting the approval from business users.
• Working with Technical team closely and getting done development for customizations for AR, AP, GL, FA & Cash Management Modules.
• Working closely with Business users to understand the criteria’s and filters for converting data from 11.0.3 to 11.5.10 for AR, AP, GL, PO, i-Procurement, FA & Cash Management
• Working closely with developers to develop code for data migration using Oracle APIs and wrapper programs
• Preparing technical specification documents for AR, AP, GL, PO, i-Procurement, FA & Cash Management
• Preparing BR100 and Completing the Setups and configurations for AR, PO, i-Procurement, AP, GL, PO, i-Procurement, FA & Cash Management
• Preparing and using data loader script to load the data and completing setups for Service Request module.
• Preparing the test cases for AR, AP, GL, PO, i-Procurement, FA & Cash Management modules
• Conducting CRP1, CRP2 UAT1 and UAT2 and helping the user for going through all the test cases.
• Fixing the issues collecting during CRP1, CRP2 and UAT.
• Working 24 by 7 during cutover and down time
• Providing support to users after implementation is done and fixing all issues related to set ups
• Fixing the issues for converted data for AR, AP, GL, PO, i-Procurement, FA & Cash Management modules

Environment: Oracle Apps 11.5.10 e-Business suite- AR, AP, GL, FA & Cash Management

Confidential

Functional Consultant

Responsibilities:

• As Confidential Functional Consultant implemented financial modules: i-Expense, GL, AP, AR, i-Procurement, INV, PO and OM of Oracle e-Business Suite.
• Implemented 2 SOB’s (2 Operating Units) using multi org structure, multi currency along with 1 Consolidation SOB.
• Worked on Confidential deferred revenue customization using the Revenue Recognition process in AR.
• Functional Design for the Auto Invoice interface in AR to load invoices into AR from an external system.
• Created the Collections Administrator, Collections Manager, Collections User profiles in AR module
• Implemented internal control features using Form Personalization’s for modules GL, AP, and AR.
• Implemented TCA - for AR customer master conversions.
• Designed and developed the customer interface to load customers into the TCA Module from an external customer database.
• Implemented Auto Lock box Functionality in AR for Confidential & Royal Bank of Canada.
• Functional Designing and executing ‘Data migration’ strategy for Master and Transactional data.
• Developed different reports as per the client’s requirement.
• Trained business owners and business end-users on OM, INV, PO, AR, AP and GL modules as part of User Training Strategy.
• Conducted pilot testing, integration with other financial modules testing.

Environment: Oracle E-Business Suite 11.5.10.2

Confidential

Oracle App Functional Consultant

Responsibilities:

• As Confidential Functional Consultant implemented financial modules: GL, AP, AR, Cash Management, iExpense, Fixed Asset, 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.
• Worked on Confidential 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.
• 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, and Windows 2003 server.