SUMMARY

• 10 years of Functional and Business experience in Oracle ERP in a variety of Projects with Full Life Cycle Implementations, Upgradation and Post Production Support of Financials Modules in both R12 and11i versions of Oracle E - Business Suite.
• Excellent communication skills and leadership qualities with analytical problem-solving abilities which include playing a vital role in coordinating multiple business meetings.
• Experience withAIMMethodology, including preparing documentation of BP80, RD20, BR30, BR100, MD50, CV40 andTE40. Business Functional Requirement analysis, understanding AS-IS and TO-BE processes,Gap Analysis and providing solution design and building RICE components as a part of fit gap analysis.
• Extensive knowledge in providing solutions, designing, customization, implementation, configuration, thorough testing and documentation of Oracle Financials including General Ledger (GL), Account Payables (AP), including Payments, Account Receivables (AR), Fixed Assets (FA), Cash Management (CE), E-Business Tax (E-B Tax), Purchasing (PO), I-expense, I-supplier, I-procurement, and Sys Admin.
• Multiple project life cycles experience with Initiating, Planning, Executing, Supporting, Monitoring, Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing(UAT), Training, cut off, Go-live and Post-Implementation Support.
• Involved in Multi-Org & Multi-Currency,re-valuation, translation and GCS (Global Consolidation System)designed and developed Financial Statements (FSG’s) per business requirement.
• Expertise with business process flows in the areas of Procure to Pay (P2P), Order to Cash (O2C Cycle), Sub-Ledger Accounting (SLA) and Acquire to Retire (A2RCycle).
• Involved in Data Conversions/Migration and designed function specific document of data for Suppliers, Customers, Assets, and GL Balances.
• Create Service Request (SR) with Oracle Technical Support, coordinated and followed up on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
• Conducted CRPs and provided functional training to multiple business user groups and coordinated UAT sessions.

TECHNICAL SKILLS

Oracle ERP: Oracle Financials R12&11i - GL, AP, AR, CE, FA, E-B Tax, PO, i-expense, i-supplier, i-procure, Sys Admin, SLA, P2P, O2C and A2R.

Languages and Tools: Web ADI, Toad, Data Loader, Discoverer, OBIE, SQL*Loader, SQL*, Microsoft Office, MS Visio, MS Project, MS SharePoint

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Oracle Financials Business Analyst

Responsibilities:

• Created users and granted responsibilities to the defined users.
• Set up legal entity, business group and operation unit.
• Set up AP payable system options, financial options, payable options, suppliers and operating units.
• Defined invoice attributes, payment attributes - Approve, hold and release, special calendar, payment formats, pay group, payable document.
• Worked on Payment process profiles, defined banks, bank accounts & documents.
• Supported month end closing for AP.
• Configured HR information to support Purchasing Documents Approval to define Employees, Jobs and Positions; defined and assigned Approval Groups to support Job Position Hierarchies; also supported Employee/Supervisor Hierarchy for PO Approvals.
• Designed and configured charts of accounts, calendar and currency.
• Set up PO matching options, Invoice tolerances, Distributions options, Payment terms and Holds
• Assessed the 12.1.3 upgrade by developing complex test cases across Procure to Pay modules in delivering the upgrade testing required.
• Performed complex data analysis, configurations and complex design solutions in partnership with program stakeholders.
• Involved with UAT testing of the systems and made sure that all the processes worked before moving to production.
• Designed and developed production checkout strategies and steps in readiness for production go-live.
• Worked closely with the technical teams involved with the conversion process. Provided direction on the various approaches to the conversion process and ensured that all conversion items were completed and balances reconciled with the legacy system.
• Provided support for production issues, ensured that issues were closed out in a timely manner, and followed up with Oracle Support in case of any SR raised.

Confidential, Kansas City, Kansas

Oracle Financials Functional Analyst

Responsibilities:

• Configured three Oracle system Financialsmodules -Accounts Payable(AP), Cash Management (CE), and Fixed Assets (FA) - according to business needs. Occasionally assisted with Inventory, OM, GL, and Receivables modules.
• Worked on STAT tool for Change Management process and migration of setup data from development to production.
• Performed Requirements Analyses - gathered requirements, performed impact analysis and documented requirements.
• Developed and implemented the application per the requirements and design as discussed with the business users.
• Developed test scripts and test cases for Opening invoices, 1099 Invoices, and supplier setups as well as performing testing of the setups done in the system.
• Responsible for conversion and migration of fixed assets from the Legacy system into Oracle.
• Conducted production and post go live issue troubleshooting processes.

Confidential, Chicago, IL

Oracle Financial Functional Analyst

Responsibilities:

• Identified business requirements & detailed solution design for GL, AP and Purchasing modules.
• Conducted workshop sessions with GL and AP Finance users to discuss business requirements & map business design with Oracle GL & AP configuration (12.1.3).
• Identified&documented Gap Business Requirements for Oracle GL, Purchasing & Oracle Payables applications.
• Drafted extensive sets of requirements, questionnaires and gap analyses.
• Prepared detailed data translation mappings between legacy data & Oracle Applications data.
• Designed and developed Oracle I Procure and Purchasing Inbound & Outbound Integration with Lawson Legacy Systems.
• Configured Oracle i-Procurement (12.1.3) for expense items & Oracle Purchasing for process Items.
• Integrated PO and AP modules for Invoice and PO matching.
• Set up Suppliers, created Purchase requisitions and PO in Oracle Purchasing.
• Matched the AP Invoices (3-way) to the purchase orders in PO modules.
• Developed functional design documents to support to-be business processes.
• Created& updated BR100 / setup documents for GL, AP, PO & iProcure.
• Configured HR information to support Purchasing Documents Approval to define Employees, Jobs and Positions; defined and assigned Approval Groups to support Job Position Hierarchies; also supported Employee/Supervisor Hierarchy for PO Approvals.
• Designed and configured charts of accounts, calendar and currency.
• Set up PO matching options, Invoice tolerances, Distributions options, Payment terms and Holds.
• Developed new FSG reports and customized various standard FSG reports.
• Interacted and worked with the development team to resolve issues faced in the test scenario run.
• Prepared Integration & Customization Unit Test Plans & supported Business / Functional users in testing Integration with Oracle GL, Purchasing & Oracle Payables Applications.
• Conducted CRPs and worked on open items to accomplish within the timelines.
• Created and updated test plans and test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Coordinated with Oracle support for high priority open issues to facilitate speedy resolution.

Confidential, Atlanta, GA

Oracle Financial Functional Analyst

Responsibilities:

• Carried out operational analysis (AS-IS),solution design (TO-BE), Building Stage along with configuration of Oracle Financials GL(General Ledger) and AP (Accounts Payable)
• Coordinated CRPs and was involved in Test Scripts preparation (TE 40) for GL & AP.
• Business communications for the system updates and meeting the deadlines for the implementation.
• Configure Accounting setup manager, COA Structure, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies.
• Expertly defined, configured and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers.
• Set up Standard, Statistical & Recurring Journals, and Suspense Account and Mass Allocation formulas.
• Trained Super users & power users before start of CRP2.
• Assisted with Period Closing & Reconciliation with GL
• Set up Global consolidation & multi reporting currency & developed FSG Reports for customized Financial Statements.
• Created users and granted responsibilities to the defined users.
• Set up legal entity, business group and operation unit.
• Setup AP payable system options, financial options, payable options, suppliers and operating units.
• Defined invoice attributes, payment attributes - Approve, hold and release, special calendar, payment formats, pay group, payable document.
• Worked on Payment process profiles, defined banks, bank accounts & documents.
• Supported month end closing for AP.
• Setup CE and created CE Responsibilities
• Reviewed the current reconciliation process in Cash Management, designed business processes, configured and tested the system to confirm that it met business requirements.

Confidential

Oracle Functional Lead

Responsibilities:

• Gathered business requirements, developed interface to load GL data from Oracle 11i to Hyperion
• End to End implementation of GL, AR and AP and CM applications from user requirement gathering phase to implementation support phase
• AIM documentation viz. BP 40, BP 80, BR30, BR10, BR 100, CV 40 and MD50
• Successfully conducted 2 CRPs and 3 UATs
• Configured CRP, UAT and production instances for GL, AP, AR and CM
• Successfully managed Customer, Supplier master data and open AR invoice data migrations from legacy systems.
• Set up payment terms, tolerances, distribution sets, hold names and reasons, payable options, purchasing options, tax codes, bank, positive pay, payment program, and formats in AP.
• Prepared MD 50 extension documents for customizations for Positive Pay file, customer invoice, sales commissions’ calculations and MIS reports.
• Helped in data migration for open sales orders and MD 50 documentations for OM related reports
• Conducted End User Training for diverse teams