SUMMARY

• Over 8 years of IT experience as Financial Functional Consultant in Oracle Applications E - business suite.
• Worked on Multiple Oracle ERP Implementations, Upgrade and Post Production Support projects in Release 11i & R12 .
• Involved in one full life cycle implementation of Oracle applications Release12 and two full life cycle implementations of Oracle applications 11i.
• Strong knowledge on various financial modules such as General Ledger, Accounts Receivable, Accounts Payable, Cash Management, Fixed Assets, Advanced Collections and integrations with other modules of Oracle applications.
• Strong understanding of integration of Oracle Applications modules, Multi Org, Revenue Recognition, Multiple Reporting Currencies (MRC) setups, AGIS, Global Intercompany Accounting System (GIS), Global Consolidation System (GCS), and Flex field setups.
• Excellent R12 Oracle Financial Functional knowledge with Sub-Ledger Accounting, E-Business Tax, Multi Org Access Control and TCA.
• Experience with Order to Cash (O2C) and Procure to Pay (P2P) Cycles.
• Solid understanding of the Business Processes across various business domains.
• Expertise in requirement analysis, document/review Use Cases, Process mapping, GAP analysis, conference room pilot, Design the ‘to be’ process, Data Conversion Management, Testing (unit/ integration/system), Cutover and Transition strategies including post go live /production support.
• Experience in reviewing Test Procedures, defining Test Cases, reviewing and maintaining Test Scripts, analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT).
• Experience in Process Analysis, Solution Design Integration, Implementation, Roll-out, System Upgrade, Integrations, Process Re-engineering, System setups, Interfaces, Extensions and User Training.
• Proficient in designing and requirements for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion and Data Migration.
• Experience in End to End Implementation of Business Process flows by using Application Implementation Methodology (AIM).
• Experience with Oracle documents and implementation practices, covering Business Process Architecture (BP), Business Requirements Definition (BRD), and Business Requirements Mapping, Module Design & Build documents (BR-100, MD-50, MD-60, RD20, BP80, and TE40).
• Experience in configuring Financials for Multi Currency, Multi Operating Units and Multi Ledgers.

TECHNICAL SKILLS

Oracle E-Business Suite: Oracle Applications R12, 11.5.10.2, 11.5.8, 11.5.5 & 11i

Oracle ERP Modules: GL, AP, AR, CE, FA, Sub Ledger Accounting, E-Business Tax, Multi Org Access Control, TCA, iProcurement.

Oracle E-Business Components: Oracle Financial Statement Generator (FSG) & Oracle Approval Manager (AME)

Databases: Oracle 8i/9/10/11g, My SQL, SQL server

Development Tools: Oracle SQL, PL/SQL

Frontend Tools: Discoverer

General Tools: Toad, SQL Loader, Microsoft Office, XML Publisher, web ADI

OS Platforms: Sun Solaris, Oracle Linux, Windows NT/XP

PROFESSIONAL EXPERIENCE

Confidential, Louisville,KY

Oracle Financial Functional Consultant

Environment: Oracle 12.1.3

Responsibilities:

• Implemented the Supplier Invoice to Payment, Customer Invoice to Receipt, Bank Statement to Cash Reconciliation, Sub ledger Journals to Post, Period End to Close Financial Reports business Flows using Oracle Business Flow Accelerator.
• Participated in the financial accounting Month-end and Year End close process to ensure financial sub-ledgers, Accounts Payable (AP), Accounts Receivables (AR) General ledger (GL) close successfully.
• Assisted in the transition of accounting systems from Oracle.
• Monthly cash flow analysis and reporting, including commentary on significant variances.
• Implemented financial applications using Oracle’s Business Flow Accelerator.
• Assisted with the preparation, analysis and finalization of financial reporting based upon SEC guidelines.
• Involved in requirements study, interaction with business users and preparing design documents.
• Prepared BR 100 capturing the functional configuration and MD.050 Application Extension Functional Design Documents for Financial modules.
• Used AIM to document configuration changes and create training material for end users
• Created Profit & Loss, Balance Sheet through FSG reports considering the Oracle GL functionality.
• Defined Cross Validation Rules and Segment Security to satisfy internal control requirements.
• Maintaining/supporting end user issues for the Procure to Pay Cycle and Order to Cash Cycle.
• Resolved any month end related issues involving and data fixes or configuration changes.

Confidential, Houston, Texas

Oracle Applications R12 Consultant

Environment: Implementation of R12

Responsibilities:

• Worked with the client to understand the business process.
• Executed initial setup of General Ledger, Payables, Assets, Ebusiness Tax and iExpenses.
• Followed SOX rules in designing the responsibilities and restricting access accordingly to various functions as per the business requirement
• Developed solution designs for financial related customizations and reports including SLA modifications and TCA setup.
• Developed a custom process for Fixed Assets as per the clients capital assets policy - Involved form customizations in Purchasing, Payables and Assets & custom reports.
• Developed a data conversion strategy for Fixed Assets, Accounts Payable, General Ledger and Purchasing.
• Configuring/Updating Functional Setups of GL, AP, AR and OM modules
• Develop BR100 Application setup documents for GL, AP, AR and OM.
• Developing GL, AP, AR and OM Training Guides using UPK.
• Implemented Cash Management for bank reconciliation and integrating bank accounts from AP, AR and Payroll
• Set-up, facilitate and assist client in carrying out User Acceptance Testing (UAT), including assisting with creating and executing UAT test cases as requested.
• Designed the Custom Extensions to meet the client’s specific needs and GAP’s in areas of AR Collections, AR Refunds, and Custom Reports.
• Worked on Reconciliation of Sub-ledger modules with GL, R12 Sub ledger accounting, R12 Accounting setup manager.
• Prepare unit test plans for RICE objects. Conduct System / Integration tests on configured Oracle applications system and custom built reports, interfaces, extensions in Financials modules before go live.
• Performed the end user training in areas of AR Invoicing, Receipts, Remittance, ipayment, AP Invoicing, Check Printing, and FA Mass Additions.
• End-to-end testing of the Customizations and Oracle Modules (SIT, End2End, UAT, Rifle shot).
• Provided Post-Production support after go-live for GL, AR and Cash Management Modules.

Confidential, Jacksonville, Fl

Oracle Apps Business Systems Analyst

Environment: Implementation of 11i

Responsibilities:

• Implemented the Mexico Operating Unit in the existing system which has US and Spain orgs already
• Participated in requirement gathering, design, supporting the CRP and UAT testing.
• Worked on Spain, France localization enhancements. Also involved in resolving the Prod issues.
• Also prepared the BR100 (Setup documents for GL, AP, FA, AR), MD050, CV040 and MD63 documents.
• Created foreign currencies and Revaluation journals for Receivables and Payables.
• Supported the AP and AR taxation with integration of vertex.
• Setup MOAC for Payables module to restrict access to different operating units.
• Participated in Customer, AR invoices, AP invoices conversions and Lockbox interface design and implementation, troubleshooting the AR Lockbox Errors.
• Setups included Multi Language, Multi Reporting Currency, and Multi Organization.
• Credit Card Functionality using iPayments. Analysis on Mexico Localizations part.
• Performing CRPs .Prepare and conduct weekly status reports with IT manager on the Project Progress.
• Worked on integrating Oracle financials with Order management and Costing.
• Prepare and Configure Setups for Test and Production Instance. Production Support on iExpenses module apart from core financials modules.
• Implemented and Supported both Order to Cash and Procure to pay cycles.
• Responsible for conducting the complete cycle of testing in Financials modules before go live.
• Worked with the Audit & Control team to develop internal controls (based on SOD) and security (audit trail etc), for Oracle Applications.

Confidential, Fl

Oracle Financial Analyst

Environment: Upgrade of 11.5.8 to 11.5.10.2

Responsibilities:

• Responsible for gathering Business Requirements, Solution Design, Gap Resolution, Application set-up and functional specifications for RICE components for financial module.
• Prepared AS-IS understanding document for AP and AR modules.
• Preparation of New features document for all the financials modules (AP, AR, GL, and FA).
• Carried out test cases in the Upgraded Version (Test Instance as provided by the client) to provide the stability to the client of the upgraded version and to simultaneously show how the system functions in the new version.
• Responsible for end-to-end testing of the ‘Procure to Pay’ and ‘Order to Cash’ business cycles.
• Coordinated the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, documentation and implementation of modules.
• Worked on setting up ADI and uploading data into the application using it.
• Performed process analysis, solution design, build, test, delivery, and post production support for enterprise-wide General Ledger and related documentation/deliverables.
• Worked on various inbound & outbound interfaces for Financials modules.
• Designed the Customization of the Oracle seeded AP Check Printing Report to generate checks that are to be paid to suppliers. Tested various scenarios on custom check stock of client including and underflow and overflow of invoices tied to payment batches.
• Created multiple Financial Statements and ad-hoc reports using Financial Statement Generator(FSG)

Confidential, Irvine, CA

Oracle Applications Techno-Functional Consultant

Environment: Implementation of 11.5.10.2.

Responsibilities:

• Worked on preparation of AS-IS understanding document for AP and AR processes.
• Worked with business super user to understand the process flow and created process flow documents.
• Prepared functional design document and Test case document for custom enhancements.
• Responsible for identification, analysis, documentation, configuration, set up and testing for Payable and receivable process for this project.
• Prepared Requirement definition document and BR.100 document to capture requirement and configuration and set up respectively.
• Performing functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Transferred the transactions for common expenses recorded in one set of books to another set of books through the GCS system
• Prepare issue and risk tracker and submit to client weekly basis.
• Coordinated the entire phase of the project for Oracle Payable and Oracle Receivable which included initial of analysis, business process re-evaluation and solution design.
• Maintained and corrected Approved Supplier List and Outside Processing functionality for companies marking and plating processes.
• Created new Bank Statement Mappings for the Banks. Worked on the Bank Transaction Codes for all Bank Accounts.
• Coordinated with the technical team of developers to deliver key custom reporting deliverables across Accounts Payable, Receivables, Fixed Assets, General Ledger and Purchasing.
• Supported Purchasing functionality for Standard and Blanket Purchase Orders through the receiving process.
• Analyze and redo MRP setups. Enabled Min Max Planning and constrained MRP plans.
• Supported issues encountered in setups and usage of Oracle Apps in the BOM, WIP, INV, MRP, AR, AP and GL modules.

Confidential

Oracle Functional Consultant

Environment: Implementation of 11.5.8

Responsibilities:

• Created and maintained Chart of Accounts, Set of Books, Recurring and Formula Journals, Budgets and FSG Reports.
• Configured Revaluation and Translation Foreign currency reporting balances.
• Set up and ran Consolidation (GCS).
• Implemented Global Intercompany system (GIS).
• Worked on Upgrade and Conversion/Migration of data from legacy systems to Oracle Systems.
• Reviewed and analyzed users’ needs setting up SOB (set of books), Chart of Accounts (COA) etc.
• Configured and setup for automatic import of Invoices from order Management Modules.
• Setup Auto Accounting, Transaction types, Transaction sources, Tax processing, Receipt class, Payment Methods, Remittance Processing etc.
• Configured and setup Payables options, financial options for entering basic Invoices, Matching Invoices to Purchase orders (2 way, 3 way and four way matching), entering credit and debit memos, processing expense reports, entering recurring invoices etc.