SUMMARY

• Oracle Applications Functional Professional having around 8 years of industry experience with primary focus on Oracle Financials and Supply Chain Management 11i and R12
• Excellent exposure in Application Implementation and Upgrades spanning entire project life cycles, Business Process reviews and Requirements definition, Set up and Configuration of Development, Test and Production instances, Data Conversion and Data Validation, Unit and Integration Testing, End - user Training and Post-implementation Support
• Extensive experience in Procure to Pay and Order to Cash Business Processes
• Expertise in Oracle ERP modules - General Ledger, Payables, Receivables, Purchasing, i-Procurement
• Proficient in Inventory, Order Management, SLA, Fixed Assets, Cash Management, i-Expenses
• Well versed in System administration setups and Application Object Library concepts
• Sound knowledge and hands on experience in technical aspects such as Underlying Schema, Database Tables, APIs, Programs, Reports, Interfaces, Conversion, Extension and Workflow (RICEW components)
• Expertise in Application Implementation Methodology (AIM) documentation - RD50, BR100, MD50, TE20, TE40
• Hands on experience with Forms Personalization and OA Framework Personalization
• Experience in Approval Management Engine (AME) and Financial Statement Generator (FSG)
• Highly Quality Oriented and Customer focused professional, a strong team builder and an efficient multi-tasker with excellent analytical and problem solving skills

TECHNICAL SKILLS

Functional: Oracle ERP 11i & R12 (GL, AP, AR, PO, OM, INV, CE, SLA, FA, iProcurement, iExpenses, AOL,EB-Tax)

Technical: SQL, PL/SQL, Oracle Forms, Oracle Reports, Discoverer

Database: Oracle 9i/10g

Tools: Toad, SQL Plus, SQL Developer, SQL Loader, Web ADI, Data Loader

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Oracle Financials Functional

Environment: Oracle Applications 12.2.4 (INV, GL, AP, AR, PO, OM, iProcurement)

Responsibilities:

• Actively participated in Requirements Gathering, System Analysis, Gap Analysis, Data Cleansing, Data Conversion and Business Process mapping to Oracle Applications
• As a Functional Consultant, implemented the GL, AP, AR and iProcurement modules
• Worked in GL - Chart of Accounts design, Setting up the Accounting Calendar, configuration of the consolidation process in GL, defining cross validation and security rules, worked on translation and revaluation, enabling MRC in GL
• AP setups: Financial Options, Payable Options, Payment Terms, Distribution Sets Hold & Releases
• AR setups: System Options, Transaction types, Transaction Sources, Auto Accounting, Autolock box, Receipt Class, Standard Memo Lines
• Provided support for the Period Close Process around the GL, AR and AP module
• Worked on the Regime to Rate flow of E-Business Tax module - setup Tax Rates, Tax Codes, for EMEA and US
• Worked on the integration of Oracle e-Business Tax with Vertex module
• Authored the application setup documents BR100, functional design documents MD50 and test plan documents TE40 based on AIM methodology
• 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 Revenue Recognition process in Oracle AR - defining the revenue rules (accounting and invoicing), worked on event based and rule based revenue recognition, worked on Customer Acceptance process for revenue recognition, worked on integrating the Revenue distributions to an external system for reporting.
• Major role in troubleshooting issues on Auto Invoice Import Program
• Successfully provided Implementation and Post Production Technical and Functional support to the Business and End users, Testers and Business System Analysts
• Analyzed the existing process for creating Purchase Requisitions in a third party system and provided a consistent iProcurement solution in Oracle across the 44 operating units, that will ease the maintenance
• Performed OA Framework Personalization for the requirements; analyzed and effectively utilized the personalizations to make the configuration process less tedious, less time consuming and more effective
• Analyzed the unique localization requirements for Brazil and provided a simplified local catalog solution utilizing the existing item setups that will ease the maintenance

Confidential, Los Angeles, CA

Procure to Pay Functional Lead

Environment: Oracle Applications 12.1.3 (GL, INV, PO, AP, CE, iProcurement, Sysadmin)

Responsibilities:

• Study of Current business processes, future business flows & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company
• Implemented the Business flows for GL, PO, AP, iProcurement, and Cash Management modules.
• Prepared BR100 and MD50, involved in CRP execution, user training and coordinating with technical teams on custom design validations for integration between oracle ERP and legacy systems
• GL Configuration: Ledgers, Chart of Accounts, Value Sets, Data Access Set, Cross Validation Rules, Security Rules, Rollup Groups, Summary Accounts, Recurring Journals, Mass Allocation Journals, Journal Sources and Journal Categories
• PO Configuration: Buyers, Purchase Documents, Financial Options, Purchasing Options, Receiving Options, Approval groups and approval assignments, Purchasing Lookups
• I procurement: Designed stores and non-catalog templates. Extracted local catalog items from Inventory and Blanket Purchase Agreements
• Support Production issues on a day to day basis including month end closure issues
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across GL,PO and AP) and create new ones based on business requirements.
• Facilitate segregation of duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Confidential, Sacramento, CA

Procure to Pay Functional

Environment: Oracle Applications 12.1.3 (GL, INV, PO, AP, CE, iProcurement, iSupplier)

Responsibilities:

• Business Process analysis includes understanding the existing business process and designing future process with the standard functionality for Procure to Pay track
• Based on the analysis, developed detailed user requirements and functional specification documents
• Worked on setting up the approval hierarchies in Purchasing
• Performed AP setups: Financial Options, Payable Options, Payment Terms, Distribution Sets, Banks, Hold and Releases, Tax Codes and Tax Groups
• Responsible for validating the back-end data that was migrated
• Documented, tracked, resolved and escalated project risks and issues
• Involved in preparing the detailed Test Plan TE10 regarding the scope and focus of the testing
• Developed unit and system test scripts TE 20 and TE 40 for GL and AP
• Performed Unit testing and integration testing on Procure to Pay modues GL, PO and AP
• Documented and communicated test results to the Test and Business Management Teams
• Submitted weekly status updates and reports showing the progress of Testing
• Provided Implementation and Post - Implementation support

Confidential, Dallas, TX

Order to Cash Functional Consultant

Environment: Oracle Applications 12.1.1 (GL, INV, AR, OM, Cash Management)

Responsibilities:

• Study of AS-IS and TO-BE Business processes, identification of GAPs and proposal of solution in AR
• Analyzed the upgrade requirements and strategized the migration of customizations to R12
• Prepared documents on Business Requirements, Functional Design, Data Mapping and Functional Testing
• Worked on setting up Revenue Recognition process in AR
• Perform necessary AR configuration setups in system options, payment terms, transaction types, transaction sources and autoaccounting
• Defined accounting and invoicing rules to be used in Revenue Recognition process in AR
• RICEW Impact analysis and management of Order to Cash modules
• Responsible for training the end users on the new processes and facilitated on-the-job training
• Performed pre-upgrade and post- upgrade tasks on AR
• Conducted CRP sessions on new features such as AP/AR netting, of Accounts Receivable in R12
• Resolved CRP, System Integration Testing (SIT) and User Acceptance Testing (UAT) issues
• Performed post-upgrade standard functionality testing in order to cash modules

Confidential, Phoenix, AZ

Procure to Pay Functional Consultant

Environment: Oracle Applications 12.0.3 ( GL, PO, AP, INV, Cash Management, E-B Tax, SLA )

Responsibilities:

• Study Division specific. Procure to Pay AS-IS Business Process, analyze the impact changes, and efforts required for the upgrade
• Conceptualized solutions around the GAPs, Impacts and Requirements
• RICEW Impact analysis and management in Procure to Pay modules
• Performed Data conversion related tasks such as Data Cleansing, Mapping and Validation
• Responsible for training the end users on changes to user interfaces, terminology or concepts
• Configured the setups for new features in GL, PO and AP
• Educated the business users on new features of GL such as Subledger Accounting (SLA), Ledger sets, Accounting Setup Manager, Data access sets and Definition Access sets
• Prepared Function Specification Documents (FSD), Business Requirement Documents (BRD) and Functional Testing Documents
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in Procure to Pay Processes

Confidential, Denver, CO

Financials Functional Consultant

Environment: 11.5.10.2 (AP, AR, GL, e-Business Tax, FA, Cash Management)

Responsibilities:

• Responsible for scoping requirements, documentation and execution of assigned Oracle Implementation tasks
• Conducted several sessions with key users to analyze business requirements and performed fit-gap analysis to map user requirements using AIM methodology
• RICEW Impact analysis and management
• Educated end users on change points and impact of moving to a Multi-Org environment through extended CRP sessions
• Worked with Oracle support for Oracle functionality issues by raising Service Requests.
• Configuration setups for GL, AP and AR
• Performed Post Upgrade Unit Testing and System Integration Testing on Purchasing and iProcurement
• Responsible for Post Upgrade Production Support
• Ensured that the project tasks are being performed as planned, that the deliverables are being produced on a timely basis and that they meet the quality standards.
• Provided Post Upgrade Production Support for GL, AP and AR