SUMMARY

• More than 10 years of experience in all phases of Implementation, Product development, Migration and Support of Oracle Applications R12/11i Financials.
• Expertise includes Business process design/re - engineering, application build, Testing and Documentation.
• Extensive experience on solution design/architecture for various business processes across many modules of Oracle Applications including Account Payables (AP), Account Receivables (AR), Fixed Assets management (FA), Cash Management (CM), Oracle Payments (Disbursement and Capture), Tax Management (EBTax), Purchasing (PO), Order Management and Inventory management.
• SME for Procure-To-Pay, Order-To-Cash, Accounting to Financial Report (A2FR) and Tax Solutions.
• Proficient on new features of Release 12 (R12) of Oracle Financials including E-Business Tax (EB Tax), Sub-Ledger Accounting Method (SLAM), Multi-Org Access Control (MOAC), LE Configurator, Bank Model, Trading Community Architecture (TCA), Payment Capture and Disbursement, etc.
• Expert in solution design and process architecture for Oracle Business Accelerators (OBA) for various businesses across countries.
• Have worked on E-Business Tax Localizations for US, UK, Latin America(Argentina & Mexico) and Russia
• Proficient designing chart of accounts, modeling Organization structure and business accounting
• Expert on functional design/process design for System Integrations including various interfaces around Oracle Applications.
• Involved in various phases of implementation including Requirements gathering, GAP analysis, Design, Configuration, Documentation and Testing
• Worked closely with users during requirements gathering, solution designing, solution build, testing and production support.
• Act as a liaison between business and technical team (Onsite-Offshore model)
• Worked on Level 2 support of Financial modules (AP, AR, GL, FA and CM)
• Conversant with tools like Kintana, PVCS (versioning) and CQSR (Clear Quest) .
• Prepared RD050, BR30, BR100, MD-50, MD-70 and other AIM documents to address the requirements
• Prepared Test Cases (TE-40) during the various stages like Unit Test, System Test, Integration Test & UAT
• Produced key documents, both in writing and presentation format, such as Project plan, requirement validations, Requirements specifications and design artifacts.
• Prepared User Manual, Operations Manual and provided Training to the End Users on the various Oracle Financial modules and custom applications
• Developed FSG (Financials Statement Generator) reports according to the business requirements.
• SME for R12 Financials for consulting team.

TECHNICAL SKILLS

Tools: Oracle Business Accelerators (OBA), FSG (Financials Statement Generator), Report 6i, SQL Loader, Toad, SQL Navigator and Data loader

PROFESSIONAL EXPERIENCE

Confidential

Business Systems Manager

Responsibility:

• Interacting with the business, documenting the requirements, gap Analysis, translating those to the IT development team to enable software build and working with the users on designing acceptance test cases and rolling out the applications
• Serve as SME in all aspects of Oracle Financials and integrations to legacy systems (PTMS, SLIM and TRECS)
• Configuring business solutions in Oracle E-business suite R12 Financials including Oracle Payables, Oracle Fixed Assets, Oracle General Ledger and Oracle Cash Management.
• Create and deliver presentations to educate/influence business partners on IT strategy
• Create documents using Oracle AIM methodology (BR100, MD20, MD50, TE40)
• Provide Techno-Functional support to business team on Oracle ERP issues/enhancements

Environment: Oracle Application R12, Oracle General Ledger, Oracle Payables and Oracle Fixed Assets

Confidential, Redwood Shores, CA

Oracle Financials Functional Consultant

Responsibility:

• Identify audit controls on financials modules in Oracle EBS R12
• Solution design for various audit controls in R12 Financials
• Preparation of Use cases to test the audit controls
• Coordination with technical team to build the controls in GRC system
• Preparation of test scripts and testing the controls

Environment: Oracle Application R12, Oracle General Ledger, Oracle Payables and Oracle Fixed Assets

Confidential, Mountain View, CA

Oracle Financials Functional Consultant

Responsibility:

• SME for Procure-to-Pay flow management including Asset Management.
• Requirement gathering and gap analysis for new enhancements
• Solution design and implementation of new enhancements on Customer Payment portal (iReceivables and Oracle Payments),
• Implementation of AGIS (Advance Global Intercompany).
• Interact with business users for requirement gathering for enhancement/ support and roll out
• Create BR100, create test script, create training document and assistance to UAT
• Analysis and Design of Fund Capture functionality to receive payments from the B2B Customers using iReceivables and Oracle Payments.
• Conduct User training and preparation of user guides for enhancement
• Preparation of Test Scripts

Environment: Oracle Application R12, Oracle General Ledger, Oracle Payables, Oracle Fixed Assets, General Ledger and AGIS (Advance Global Intercompany System), Oracle Payments, Oracle iReceivables.

Confidential, Santa Clara, CA

Oracle Financials Functional Consultant

Responsibility:

• SME for Procure-to-Pay flow and Inventory - Asset Integration.
• Conduct meetings with the client for requirement analysis
• Identify gaps between the business and the applications
• Solution design for integration between Inventory and Fixed Assets process.
• Solution design for Use Tax processing for Inventory Movement across US.
• Preparation of solution design / Functional specification documents pertaining to the requirements on integration between Inventory Management and Fixed Assets.
• Preparation of functional spec for new customizations
• Application configuration on CRP instances, UAT and PROD instance(with FA and Inventory)
• Preparation of business Use Cases.
• Thorough testing on Inventory to Asset process, Asset life cycle and Material Transactions impact on Assets.
• Conduct CRP and UAT with business users.
• Engaged in Cut-over activities during project Go live
• Conversion of legacy Assets in Oracle Applications
• User Training/Desktop Procedures
• Full assistance to the Technical team for building custom functionality

Environment: Oracle Application 11.5.10.2, Oracle General Ledger, Oracle Payables, Oracle Fixed Assets and Oracle Inventory.

Confidential, Fremont, CA

Oracle Financials Functional Consultant

Responsibilities:

• Preparation of models for requirements gathering for Financial modules.
• Involved in requirements gathering sessions with the client.
• Identification of Gaps between the requirement and Oracle Application
• Convert the requirements in to documents RD50, BR100 and BR30.
• Translated business requirements into functional specifications for the development team and ensure development results match the identified requirements
• Model design for CRP1 and CRP2 sessions
• Led the Conference Room Pilots for the site implementation
• Functional Design for the interfaces in Financials modules.
• Configurations of Financial Modules on project instances and build the Production instance.
• Preparation of Functional Test cases for AP, AR, FA, GL and CM
• Worked on Bank Statement Interface and Statement reconciliation solutions
• Designed Cash Forecasting and Cash Positioning
• Assistance to UAT
• Training to End Users

Environment: Oracle Application R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Fixed Assets and Oracle Cash Management.

Confidential, Sebastopol, CA

Oracle Financials Functional Consultant

Responsibilities:

• Preparation of models for requirements gathering for Fixed Assets.
• Involved in requirements gathering sessions with the client.
• Identification of Gaps between the requirement and Oracle Application
• Convert the requirements in to documents RD50, BR100 and BR30.
• Translated business requirements into functional specifications for the development team and ensure development results match the identified requirements
• Led the Conference Room Pilots for the site implementation
• Configurations on various instances involved in the process of implementation.
• Setup and configuration for ADI
• Preparation of Functional Test cases for Fixed Assets
• Assistance to UAT
• Training to End Users

Environment: Oracle Application 11.5.10, Oracle Fixed Assets.

Confidential, Parsippany, NJ

Oracle Financials Functional Consultant

Responsibilities:

• Client discussions on new business requirements about the Interfaces, Conversion, Extracts and Check format customization due to the merger of Budget Truck application
• Responsible for design of Conversions and Interfaces between Budget Truck system and Confidential Car Rental system.
• Preparation of MD 50 and review of MD 70 documents Conversions, Interfaces and Extracts
• Preparation of Functional Test cases for AP and GL Conversions, AP, iPayment and GL Interfaces, AP Extracts and Check format change
• Performing Functional Testing for Vendor Conversion, Invoice Conversion, Vendor Interface, Invoice interface, Payment Interface, Extracts to Legacy systems (DivTrak, ACS, Damage Control, CDR, and AP Recovery) and Check image modification.
• Preparation of BR100 for the new setups required to be configured for the Conversion, Interface, Extracts, and Check image customization
• Configuration migration to various instance
• Assistance to UAT
• SME for R12 Financials for the consulting team.

Environment: Oracle Application 11.5.10/R12, Oracle General Ledger, Oracle Payables, Oracle Fixed Assets.

Confidential

Oracle Financials Functional Consultant

Responsibilities:

• Requirements gathering, Analysis, Design, Solution, Testing and Delivery
• Managing Pre-Project, Mid Project and Post Project review with Oracle Partners and Clients
• Upgrade from R12.0.5 to R12.1.2 version of Oracle Applications.
• In corporation of US specific new business functions in to the solution with the help of RCDs during upgrade.
• A2FR (Accounting to Financial Reports) solution for United States General Business with Accounts Payable, Accounts Receivable, General Ledger, Cash Management and Fixed Assets.
• Implemented US, UK, Argentina, Russia taxation for General Business through E-Business Tax.
• Design and Implementation of MOAC (Multi-Org Access Control) for General Business.
• Analysis of Localization and Business specific requirements and functionalities
• Design and QA of the following business flows
• Supplier Invoices to Payments (AP, Oracle Payment)
• Customer Invoice to Receipt (AR)
• Bank Statement to Cash Reconciliation (CM)
• Receipts to Asset (Fixed Assets)
• Assets to Depreciation (Fixed Assets)
• Subledger Journals to Post (GL)
• Period End close to Financial reports (GL)
• Preparation of Test Scripts (TE 040) for the above business flows to test the General Business US solution.
• Preparation of Post Install setup document and Functionality overview document

Environment: Oracle Application 12.1.2, GL, AP, AR, CM, E-Business Tax, SLAM (Sub ledger Accounting Method), Payment Administrator, Multi-Org Access Control

Confidential

Oracle Financials Functional Consultant

Responsibilities:

• Client discussions on new business requirements or enhancements
• Functional and Technical support in the applications (AP,AR, GL and Contracts)
• Worked on issue fixing on AR Invoice interface, and GL Interface.
• Worked closely with the Client users during the phase of understanding and issue fixing.
• Assistance to Vertex teams during issues on the AR invoice interfacing.
• Preparation of MD 70 and MD 50 for customizations.
• Functional assistance to the technical team.
• Developed Financials Statement Generator (FSG) reports in GL.
• Maintained the custom scripts in PVCS, storage of documented work by creating various folders for reference by future testers and users.
• Worked with Kintana, for registration and compilation of the Packages & SQL scripts in the various instances before moving into Production server on hierarchy of approval.

Environment: Oracle Application 11.5.10, GL, AP, AR, Financials Statement Generator (FSG)

Confidential

Oracle Financials Functional Consultant

Responsibilities:

• Understanding the present business system, testing, analysing requirements pertaining to the needs of the project
• Performed GAP analysis
• Created RD 050, BR 030, BR100 for new modules lined up for implementation
• Solution design, configuration and management of Oracle General Ledger, Oracle Payables and Oracle Receivables.
• Involved in requirements gathering, configuration, documentation and testing for business roll out across new circles and warehouses in India.
• Configuration and management of Oracle Payables for new circles.
• Inventory configuration for warehouses.
• Application security using System Administration in Oracle Applications for new users on new circles.
• UAT support for AP, AR and GL transactions testing.
• Responsible for importing, reconciling and posting journals from different modules to GL.
• Designed new FSG reports in GL to get balance sheet for each entity within the organization in order to help month-end reconciliation.
• Data Interfacing (GL, AR)
• Support to the Technical Team.
• Training the End-Users of GL, AP, AR, PO and Inventory transactions
• Trial Balance upload through Interfaces
• Functional assistance to Customer data Interfacing
• Bug fixing in AR Auto Invoice

Environment: Oracle Application 11.5.9, GL, AP, AR, PO and Inventory

Confidential

Oracle Financials Functional Consultant

Responsibilities:

• Understanding the present business system, application configuration, testing and documentation
• Configuring Oracle General Ledger.
• Configuring Oracle payables.
• Support to Technical Team.
• Post Implementation support on GL, AP and AR transactions
• Managing Oracle Financial Modules using Applications System Administration
• Report Customization: