SUMMARY

• Oracle Finance Functional consultant with around 7+ years of focused expertise in Financial modules of Oracle Application.
• Involved in multiple implementations, UP gradation and Post Production Support of Financials Modules in Oracle E - Business Suite R12 Oracle, 11i versions.
• Extensive noledge in providing solutions, designing, customization, implementation, configuration, thorough testing and documentation of Oracle Financials including General Ledger (GL), Account Payable (AP), Account Receivable (AR), Fixed Assets (FA), Cash Management (CE), E-Business Tax (E-B Tax), Purchasing (PO) and Sys. Admin.
• Multiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration and User Acceptance Testing, Training, Cut off, Go-live and Post-Implementation Support.
• Experience in implementing AGIS (Advance Global Intercompany System), involved in Multi-Org & Multi-Currency, re-valuation, translation and GCS (Global Consolidation System), designed and developed Financial Statements (FSG’s) as per Business Requirement.
• Expertise with business process flows in teh areas of Procure to Pay (P2P), Order to Cash (O2C), Sub-Ledger Accounting (SLA) and Acquire to Retire (A2R)
• Involved in Data Conversions/Migration and designed function specific document of data for Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and unapplied receipts from Legacy System to Oracle
• Experience in maintaining documentation and using teh Application Implementations Methodology (AIM), which includes Business Functional Requirement analysis, understanding AS-IS & TO-BE process, Gap Analysis and providing solution design and building RICE components as a part of fit gap analysis, System configuration and testing (BP 80, RD20, BR30, BR 100, BR 150, MD 50, CV 40 & TE40)
• Expert in creating SR’s with Oracle Technical Support, coordination and following on multiple issues based on priority including indentifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team
• Conducted CRP’s and provided wide range of functional training to multiple business user groups and co-ordinate UAT sessions
• Excellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings and following up on open item.

TECHNICAL SKILLS

Core Modules: General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Cash Management (CE) & Fixed Assets (FA)

Secondary Modules: Order Management, Inventory and Purchasing

Functional: Business Requirements Analysis, Gap Analysis, Process mapping andOracle Applications functional setup

Oracle ERP: OracleFinancialsR12&11i

PROFESSIONAL EXPERIENCE

Confidential, CA

Oracle Financials Functional Consultant

Responsibilities:

• As a Functional Consultant implemented teh business flows including AR, e-Business Tax, AP, GL and Cash Management modules
• Worked in teh configuration of teh AP modules
• Performed Requirement and Gap Analysis
• Worked on teh setups of e-Business Tax and Vertex module - including teh setups of Tax Rates, Tax Codes, Tax Regimes, Regime to Rate flow - for EMEA and US
• Worked on teh integration of Oracle e-Business Tax with Vertex module
• Configurations and Setups for AP, AR, GL and Cash Management modules
• Worked on teh Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules
• Preparing BR100, MD050, TE40, TE50, 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 setting up teh Approval Hierarchies in Purchasing Module
• Worked on setting up teh Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up teh Line and Header transaction flex field in AR for Auto Invoice to work
• Worked on teh Auto Lock Box process in AR
• Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
• me procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• Pre upgrade testing and Post upgrade production live support
• Support Production issues on a day-to-day basis including month end closure p1 issues
• Provide support/enhancements for teh existing Oracle and Discover Reports (across AP, FA, CM, and AR) and create new ones based on business requirements
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journals Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per teh SOD Document in System Administration

Environment: Oracle E-Business Suite 11.5.10.2/12.1.3 , Oracle DB 10.2.0.3.0 , Load Runner, Win Runner, Quality Center, Vertex Tax Software, QTP, Windows XP, UNIX, Ms-Office

Confidential, Oaks, PA

Oracle Financials Functional Consultant / Business Analyst

Responsibilities:

• Indentified Business Requirements & detailed Solution Design for GL, AP and Purchasing Modules.
• Involved in workshop sessions with GL, AP Finance users in detailing out business requirements & map business design with Oracle GL & AP configuration (12.1.3)
• Indentify & Document Gap Business Requirements for Oracle GL, Purchasing & Oracle Payables Applications
• Drafted extensive set of requirements, questionnaire and gap analysis
• Prepared Detailed Data Translation Mappings between Legacy data & Oracle Applications Data. Involved in Configuration of Oracle me-Procurement (12.1.3) for Expense items & Configuration of Oracle Purchasing for Process Items
• Developed Functional design documents to support to-be business processes
• Create & updating BR100 setup documents for GL, AP, PO & iProc.
• dis project is an implementation of Oracle R12for finance modules
• Designed and Implemented End-End process of Isupplier module for client
• Particular interest in dis project is designing Custom Invoice approval workflow for AP invoices
• Designed in Custom Invoice workflow for Non-PO invoices and invoice batches
• Gatheird business requirements for many Interfaces b/w AP and Third party systems
• Lead CRP sessions during implementation, Design and Testing
• During teh course of project several MD 50’s are delivered for different RICE elements. Assisted team in developing Process Documents and Test Scripts
• Closely interacted and assisted with users during UAT sessions in executing process documents
• Trained AP users with all teh new features of R12
• Involved in requirement gathering during to kick off workshops and performed End-End configuration of R12 AP system options, Financial options, Banks, Multi org setup, Withholding taxes etc.
• Re-engineered teh AMEX Credit Card Interface and interfaces between AP and legacy treasury system
• Configured HR information to support Purchasing Documents Approval to define Employee, Jobs & Positions, and define & assign Approval Groups to support Job Position Hierarchies & also supported Employee/Supervisor Hierarchy for PO Approvals
• Loaded, imported and auto-reconciled teh bank statement transaction against payments in Accounts Payable (AP) in Oracle Cash management modules
• Involved in design and configuration of chart of accounts, calendar and currency
• Setup Suppliers, created Purchase requisitions, Purchase Orders in Oracle Purchasing
• Setting up PO matching options, Invoice tolerances, Distributions options, Payment terms, Holds etc.
• Developed new FSG reports and customized various standard FSG reports
• Interacted and worked with teh development team to solve teh problems faced in teh test scenario run
• Prepared Integration & Customization Unit Test Plans & Supported Business / Functional users in testing Integration with Oracle GL, Purchasing & Oracle Payables Applications
• Conduct CRP’s and work on open items to accomplish within teh timelines
• Create and update test plans and test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all teh above modules.

Environment: R12.1.3 (GL, AP, PO, iProcurement, iSupplier, EXTax, iExpense, CM, XLA) SQL, SQL Developer, Windows 7, SysAID

Confidential, Chicago, IL

Oracle Financials Functional Consultant

Responsibilities:

• Interacted with business and analyzed existing business practices, Prepared and maintained business requirement gathering documents BR 100, BR 30, functional extension and design document MD 50 and indentified GAPS
• 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 CRP’s and was involved in Test Scripts preparation (TE 40), for GL & AP
• Business communications for teh system updates and meeting teh deadlines for teh implementation
• Configured 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
• Setting up Standard Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas
• Training Super users & power users before start of CRP2
• Involved in Period Closing & Reconciliation with GL
• Setting up Global consolidation & multi reporting currency & developed FSG Reports for customized Financial Statements
• Teh Cash management implementation covered teh Bank setups, teh Bank Transaction codes setups, Bank statement mapping and customization of Bank statement import process for previous day and current day bank statements, Cash positioning and Cash forecast etc.
• Designed conversion strategy for conversion of Fixed Assets from Legacy system into Oracle Assets, carried out conversion, verified and asset balances, maintained teh books for a number of periods and transitioned books to teh users for maintenance
• Setting 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 in Payment process profiles, defined banks, bank accounts & documents. Setup CE and created CE Responsibilities
• Reviewed teh current reconciliation process in Cash Management and designed business process and system TEMPhas been configured and tested to meet teh Business requirements
• Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement, Bank file integration / mapping

Environment: R12 (GL, AP, PO, CM, FA, AR, Inventory, Workflow Administrator, XML, AOL, XLA, EB-Tax), SQL, Windows XP, VSS, Smile Ticketing System

Confidential

Oracle Functional Consultant

Responsibilities:

• As a Functional Consultant, implemented following modules: AP, AR, GL, OM modules. Worked on functional mapping of Data Conversion & Enhancements for AR, AP and GL modules.
• me-Procurement - Worked on teh configuration of me-Procurement module including teh setups of teh requisition templates, setting up teh Item Catalogs and Categories, Account Generator, Etc.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with Technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications
• Configured Oracle GL, PL, AR, OM and PO from scratch and simultaneously created BR100documentation for teh setups
• Setup teh Approval Hierarchies in Oracle Purchasing module
• Involved in troubleshooting issues on Auto Invoice Import Program
• Created Test Scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all teh above modules.
• Completed Multi-Org configuration by creating a new Organization Structure for WYSE, creating new Business Group, Legal Entity, Set of Books and Operating Unit.
• Conducted Regression testing to examine teh effects of a new Org on teh previous Org.
• Conducted Multi-Org Revert Testing to create an effective Revert Plan for WVI, as and when required
• Successfully provided Technical and Functional support to teh users, testers and Business System Analysts
• Provided with useful training to teh users in GL, AP, OM, Service Contracts, Install Base, INV and PO Modules
• Created FSG Financial Reports critical to Company’s business process
• Worked on creation of MRC Setup by defining primary Set of Books and Reporting Set of Books in Oracle GL

Environment: 11.5.10.2/R12 (GL, AP, & FA, AME) SQL Developer, MS Office tools, MS projects