SUMMARY:

• Oracle E - Business (R12) - Financials/P2P/B2R/O2C - Functional Consultant/Subject Matter Expert/Project Lead/Project Manager
• 15 years’ functional experience in implementing Oracle (R12, 11i) Financial applications in the role of subject matter expert, lead consultant, and project manager with emphasis on business analysis, design, implementation, and problem resolution.
• Upgraded two Oracle R12 Financial projects acting as GL lead for one project and P2P lead for the other project (R12.2.3 - 1 year and R12.1.3 - 2years).
• 15+ Years’ experience as Subject Matter Expert/Functional/Business Analyst/Project Manager
• Strong Oracle General Ledger, WebADI, Purchasing, Accounts Payable, Accounts Receivable, Sub Ledger Accounting (SLA), Reconciliation, Period Close, and Year Close experience.
• AP, PO, AR, GL, FAH,FV, INV, OM, FA, PA, iProcurement, iExpense, Advanced Collections, Payroll, Loan, EBTax, SLA, PRISM (3rd party PO).
• R12 upgrade, Business Requirement/GAP Analysis, Business Process Design, Application Configuration & Setup, Module Design (RICE), Data Conversion, Business System Testing & CRP, Change Management and Production Support.

TECHNICAL SKILLS:

Technology, Methodology, and Tools used: AIM, Six Sigma, SCRUM, CMM, ISO 9000, SOX, ClearQuest, ClearCase, eRoom, HP Quality Center, BMC Remedy, MS project, Visio, ER Modeler, Discoverer, ADI, OBIEE, SeeBeyond, WebSphere, Oracle Workflow, Oracle Forms, Oracle Reports, PL/SQL, SQL, C++, HP OuterBay, Unix Shell script.

PROFESSIONAL EXPERIENCE:

Confidential, Chesapeake, VA

Senior Oracle Financial Systems SME

Responsibilities:

• Performed Business Requirements gathering and Solution Design Specifications sessions.
• Prepared Functional Specification documents, BR100, MD 50, and Test Scripts (HP QC) documents.
• Configured GL module.
• Configured Journal approval process and workflow. Defined approval hierarchies.
• Verified and validated SLA accounting for all modules. Defined reconciliation process between subledger modules, SLA, and GL.
• Defined period close and year close processes for GL, PO, AP, AR, INV, PA, and FV modules.
• Conducted CRPs, SIT, and UATs. Prepared production cut over plans.

Confidential, Bethesda, MD

GL Functional Lead

Responsibilities:

• Performed Business Requirements gathering and Solution Design Specifications sessions.
• Prepared Functional Specification documents, BR100, MD 50, and Test Scripts (HP QC) documents.
• Configured GL, PO, AP, Payments and FV modules.
• Implemented secondary ledger with different chart of account. Re-configured COA (increased the length of SGL and OC accounting flexfield segments) for the new secondary ledger. Generated treasury mandated reports out of secondary ledger.
• Implemented Journal approval process and custom fund check process.
• Configured FAH (for Payroll and Grants interface), FV, PO, and AP SLAs. Verified and validated SLA accounting for all modules. Defined reconciliation process between modules, SLA, and GL.
• Defined period close and year close processes for GL, PO, AP, AR, INV, PA, and FV modules.
• Configured additional DFF segments on Journal Entry form to capture GTAS attributes and TAS/BETC
• Configured WebADI and defined new templates. Implemented WebADI upload process.
• Configured Journal approval process and workflow. Defined approval hierarchies.
• Configured GTAS attributes, Treasury Account Symbols and Business Event types, Trading Partner TAS and Trading Partner BETC.
• Defined and executed budget upload for appropriations, apportionments, allotments, and operational budgets.
• Conducted CRPs, SIT, and UATs. Prepared production cut over plans.
• Project adopted SCRUM sprint daily standup meetings and Scrum of Scrum meetings; Project used Panaya tool to identify technical objects that require R12 code migration.

Confidential, Washington, DC

Functional lead

Responsibilities:

• Performed Business Requirements gathering and Solution Design Specifications sessions.
• Prepared Functional Specification documents, BR100, MD 50, and Test Scripts documents.
• Configured PO, AP, and Payments modules. Implemented roles and security for PO documents. Configured SLAs related to requisition, purchase orders, invoices, and Payments.
• Conducted functional testing (including CRP/test rounds)
• Implemented various functional enhancements (Commitment accounting, Federal Vendor SGL, and Active Lines) to Procure-To-Pay business process. Carried out the implementation and integration of PRISM procurement systems into P2P.
• Carried out daily operational support, resolve escalated tickets, PO-AP-PA-GL reconciliation, creation of WebADI & adjustment journal entries, year-end Mass Cancellation processing, vendor merge, vendor setup, project and task setup, Invoice Reclass, Project/Task/Fund maintenance.

Confidential, Elkridge, MD

Project lead and lead Functional Consultant

Responsibilities:

• Project Lead for a) AR Treasury Reporting, b) IRS 1099 Tax Reporting and c) Archival and Purging of Oracle Applications using HP OuterBay product.
• Business Analyst for the implementation of the following projects: Payment Process (837 inbound claim processing and 835 outbound payment processing), AR/AP Netting, ERS (Loan), AR CNC Automation, AR Treasury Reporting, AR-GL Financial Reconciliation, Advanced Collections, Revenue Recognition, AutoInvoice, Oracle Loans, OBIEE on Health Care Transaction Base (HTB), and Release 11.5.10 upgrade.
• Conducted working group meetings, requirement gathering meetings, and solution design meetings with end users and other stake holders.
• Delivered GAP Closure Analysis, Business Scenarios and Rules, Business Process change, Design Decision Alternatives, Functional Specification, BR100 (Configuration and Setup), and Test Scripts & Scenarios.
• System Administration: Creating Users & Responsibilities, Registering applications, concurrent programs, request sets, Flexfields, creating user builds, and application configuration.
• Configured and Setup application modules in development and Alpha testing instances and Conducted CRPs, SIT, and UATs.

Confidential, Atlanta, GA

Business Process analyst and SME

Business Modules: Oracle E-Business Suite (11.5.10) - AP, PO, iProcurement, iExpense, INV

Responsibilities:

• Conducted process simplification, requirement analysis, business process flow modeling (used flow diagramming extensively), business solution design, configuration and setup, and CRP
• Designed solution for Global Procurement and Sourcing. The solution included integration with iProcurement, shared vendor base, and customer base
• Designed solution for Accounts Payable, Payment System, and integration with Cash Management. The solution included design for European VAT compliance, including tax advantage drawn from various European entities, and mapping to central Global GL instance
• Conducted meeting with current process owners from Europe and North America. Coordinated with European team to validate the As-Is-Process, To-Be-Process, and to finalize the global Procure-to-Pay process
• Assisted client management in planning and executing project activities such as System Integration Testing, Pre-cutover and Cutover cycle, Data conversion strategy preparation and simulation, etc.
• Documented RD10 (Financial and Operating Architecture), Business Base Line, Requirement Definition, GAP Analysis, CF 250 (Integration), BR100 (Configuration and Setup), and Test Scenarios and Scripts; Implemented EBTax
• Documented functional specification for RICE components
• Carried out the implementation, CRP, and the production transition. Project conformed to Six Sigma quality compliance with SOX control

Confidential, St Louis, MO

Functional Consultant

Business Solutions: Oracle E-Business Suite (11i) - GL and FV

Responsibilities:

• Configured & setup Oracle Federal Finance to implement RCAP transfers, Program Distribution, Prior Year Conversion for Cancellation & Restoration of funds, and Policy targets for USDA Farm Service Agency and Rural Development.
• Documented requirement matrix, design decision alternatives, business scenarios and rules, functional specification, BR100 (configuration and setup), test scripts, and test scenarios
• Analyzed and documented interface requirements (MD.050) for legacy RULSS, GLS, and DLOS systems. Guided developers to implement customizations (forms, reports, concurrent programs, MQ Series, XML data)
• Created Summary Accounts, Rollup groups, Funding Budget, Budget Organization, US SGL Transaction Codes
• Created Federal Administrator Fund groups, Account Symbol, Appropriation parameters, Treasury Symbols, Agencies, Funding Budget Distribution, Budget Transaction Codes, Budget Transaction Types, Budget Levels, Budget Users, Security Group and Approval hierarchy
• Created budget levels for fund appropriation, allotment, allocation, sub-allotment, obligation, de-obligation, and reservation
• Controlled build of customization, & extension of forms, reports and workflows, and interfaces. Carried out code walkthrough and System Test for interface and extensions
• Conducted CRP1. Carried out system test for customized solutions

Confidential

Project Manager

Business Modules: Oracle E-Business Suite (11i) - GL and AP

Responsibilities:

• Re-structured the accounting and business practices of the Confidential, b) Implemented Oracle GL and AP modules to support the functions of Finance, Secretariat, Foreign Finance, Domestic Operations, Treasury, Provident Fund, and Currency Production & Circulation departments, and c) Integrated the Oracle Application with the Real Time Gross Settlement System (RTGS), Script-Less Security Settlement System (SSSS), and the SWIFT Banking software.
• Prepared Project Management Plan, Software Configuration Management Plan, Software Test Plan documents. Guided development of coding standards and test plan documents. Facilitated user meeting and reviews.
• Carried out Requirement Definition, Gap Analysis, and Business Process Design for the above functionalities. Correlated Banking Accounting Practice and Oracle GL and AP. Restructured single entry legal system accounting to double entry Oracle Financial Accounting. Documented Gap, Business Process Design (BP90) and Configuration and Setup (BR100) documents for GL and AP.
• Installed Oracle Application, Converted to MO and MRC. Created Business Unit, Legal Entity, Multiple Operating units and Inventory. Implemented German Localization for journal reconciliation purpose. Implemented average balance processing.
• Configured, Setup, and Implemented GL & AP. Created Chart of Accounts, SOB, Sources, Category, Summary Accounts, Rollup groups, Funding Budget, Budget Organization, Banks, Suppliers, Financial and AP options, withholding tax, check-printing, Invoice, Payments and Payment Group. Used ADI for journal entry, Data Loader for initial data loading, OFA for financial analysis, and FSG for reporting purposes.
• Prepared and documented Test Scripts and Test Data (TE 40). Conducted CRP.
• Integrated Treasury with Bloomberg for real-time deal information.
• Execute delivery of integrated solution, and customized and extended reports, programs and forms
• Production Transition

Confidential

Oracle 11i Procure to Pay Functional Consultant

Business Modules: Oracle E-Business Suite (11i) - PO, iProcurement, INV, GL, AP and AR

Responsibilities:

• Implemented PO and iProcurement modules, for telecom wholesale and retail business, in the existing installation of GL, AP, AR, OM and INV
• Configuring PO and implemented position hierarchy approval workflow & notification mailer system for purchasing documents to control create/view/modify/approve/close/final close access roles and security.
• Conducted requirement analysis for RFQ, Quotes, Purchase Requisition, Purchase Orders, Receipts, billings and payments.
• Conducted requirement analysis for interfacing catalogs, requisitions, and quotes from external systems.
• Documented RD20 (Requirement Definition), BR100 (Configuration and Setup), MD 40 (RICE components), and TE 40 (Test Scripts)
• Configures and Setup PO, iProcurement, Budget & Fund Checking, FA, AP invoice matching process, and Receiving inventory organizations.
• Created position hierarchy and approval limits.
• Implemented encumbrance accounting and on-line fund checking for purchase documents. Created Budgets, budget organizations, and budgetary controls.
• Implemented catalog loading from Oracle Inventory and external sources using XML.
• Implemented Punch-out from Oracle iProcurement directly to supplier-hosted Catalog (XML).
• Implemented purchasing of assets, inventory and expensed items.

Confidential, PA

Functional Consultant

Business Modules: Oracle E-Business Suite (11) - Order Management, Account Receivables, Purchasing, and Inventory Modules

Responsibilities:

• Carried out the business requirement analysis, process mapping, solution design, configuration & setup, CRP, and the production transition.
• Documented RD10 (Financial and Operating Architecture), RD20 (Requirement Definition), RD50 (GAP Analysis), MD 40 (RICE components), BP90 (Business Process Design), BR100 (Configuration and Setup), and TE 40 (Test Scripts). Implemented EBTax (Vertex)
• Carried out the implementation, Conducted CRPs, SIT, and UATs, and the production transition.