SUMMARY

• Around 8 years of experience as Oracle Financials Functional Consultant with expertise in Oracle Applications versions 11i and R12
• Worked on multiple Implementations, Upgrade and Support projects, including full life cycle implementations in Oracle ERP 11i (11.5.9, 11.5.10, 11.5.10.2) and R12 (12.0.5, 12.0.6, 12.1.1, 12.1.3)
• Have an extensive years of cutting - edge experience in the core modules setups and functionalities: GL (General Ledger), AP (Payables), AR (Receivables), e-Business Tax, CE (Cash Management), FA (Assets), Sys Admin and thorough knowledge of Purchasing (PO), Procure to Pay (P2P), Order to Cash (O2C), Acquire to Retire (A2R) business cycles and the Integration functionality in Oracle
• Experience in all phases of full life cycle Oracle Financials implementation i.e. Requirements Definition, GAP Analysis, Fit-gap analysis, Application Configuration, System Testing, User Training
• Experience in Global Implementation including AGIS (Advanced Global Intercompany System), Multi-Currency and Translation
• Expertise in creating financials reports with Financial statement generator (FSG)
• Well versed with the integration and architecture of Multi-Org (MOAC), SLA (sub-ledger accounting) and Web ADI
• Experience in Upgrade and Conversion/Migration of data from legacy systems to Oracle Systems
• Help business maintain a future-ready platform for bigger and more complex future projects
• Was involved in multiple CRPs and coordinated UATs with technical team
• Experience in using Oracle AIM of project implementation methodologies particularly Gather Business Requirements RD.020, BP.080, MD.050, Application Setup Documents BR.100 deliverables, Test Cases TE.040 and CV.040
• Interaction with Oracle support to resolve application issues through SR/TAR.
• Excellent communication skills and interpersonal skills
• Knowledge in using Microsoft Office applications, i.e. Word, Excel, PowerPoint, Project and Visio

TECHNICAL SKILLS

Oracle Applications Financials (Functional) 11i and R12: General Ledger (GL), Fixed Assets (FA), Accounts Payables (AP), Accounts Receivables (AR), E-business Tax (E-BTax), Cash Management (CE), Advanced Global Intercompany system (AGIS)

Knowledge of modules: Purchasing (PO), P2P, O2C, A2R

Other Tools: Data Loader, SQL Loader, Web ADI, XML publish, Toad, Discoverer, Hyperion, OBIEE

Microsoft Office Suite: MS Word, Excel, PowerPoint, Visio, Project

Operating Systems: Windows 95/98/NT/XP/Vista/7/Macintosh

Programming: PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis MN

Oracle Financials Functional Analyst

Environment: Implementation & post-production support on GL, AP, FA (version 12.1.3)

Responsibilities:

• Determine BR.100 setups for both GL and AP modules
• Conducted user acceptance test (UAT)
• Did weekly status reporting to client
• Provided functional design documents for custom Reports
• Performed manual work around using Sub Ledger Account (SLA)
• Worked with technical team for customization
• Conduct successful month-end process
• Part of setup of new operating units in Accounts payable module
• Assisted business end-users in month-end closing processes
• Assisted in configuring CRP instance using TE.040
• Helped prepare a test script with more scenarios
• Assisted in preparing CV.040
• Helped in reducing efforts on accounting, reconciliation and consolidation through a scalable Chart of Accounts, organization structure and ledger structure
• Supported end users to reduce non value added manual activities
• Worked with DBA for fixing bug and applying patches
• Involves in identifying issues with the applications or other opportunities for improvement in the ERP
• Earned business appreciation for clear and lucid Super User Training Session

Confidential, Miami FL

Financial Functional Analyst

Environment: Implementation & Post-Production support on GL, AR, CE (version 12.1.1)

Responsibilities:

• Gathered business requirements and prepared RD020
• Prepared Future Business Process (BP080) based on the requirement gathering done
• Prepared project plan and schedule for all activities involved in implementation
• Configured multi-org business structure in Oracle, Ledger Setup, Legal Entity, Establishment Setups, MOAC security
• Set up Multi-Currency environment
• Involved in Creating BR100 documentation for GL, AR, SLA (Sub ledger Accounting)
• Carried out the setup for CRP with the help of setup documents
• Performed Oracle sys Admin Tasks like Creating users, defining Concurrent Requests, Programs and Value Sets etc.
• Configured Bank statement reconciliation in Cash Management
• Prepared Test Scripts (TE040) for UAT sessions and Training Documents with screenshots for end users
• Developed and documented training manual for end users on operational functionality in oracle application
• Provided various custom solutions for client’s specific needs
• Provided with post-production support after go live

Confidential, Cupertino CA

Oracle Financials Functional Consultant

Environment: Upgrade Project on GL, PO, AP, AR, FA and CE (version 11.5.10.2 to version 12.0.6)

Responsibilities:

• Understanding installed components, system sizing information and also National Language Support (NLS) architecture
• Prepare for upgrade using Upgrade Manual Script (TUMS)
• Train the business users on Global Translations, Revaluations and Consolidation of Multiple Ledgers
• Writing TE.040 Test Scripts for Functional Testing of GL, AP, FA and developing Guided Navigations
• Assisted the technical in the process of upgrading the database and also in applying patches through auto Patch
• Assisted in creating approval hierarchy and assignment of approval groups
• Set up suppliers and its site which made the users much easier for payments and also billing
• Defined approved suppliers list
• Created releases for the POs and agreements
• Developing Training Material for AP, FA modules
• Conducted end user training sessions and User manuals
• Design and Configure Financial Statements Using FSG
• Maintain issue tracker using Bugzilla and issue resolution
• Conduct business meeting whenever required based on issues and new functional requirements
• Prepare documentation for change management process along with impact analysis on the proposed solution
• Create and follow up on Service Request (SR) with Oracle support
• Worked for post-upgrade team on completing the upgrade process by applying RUP patches to keep the system most current

Confidential, Fort worth TX

Oracle Financials Functional Analyst

Environment: Postproduction support on GL, AP and PO (version 12.0.6)

Responsibilities:

• Training and assisting business end users
• Working with the technical team for custom reporting requirements of the business users across different business departments of the various functions within the organization
• Involved in preparing BR100 for GL module
• Assisted any further changes through Change management Process
• Develop Test scripts and Business scenario for CRP and UAT
• Functional assistance for custom interface for importing purchasing invoices from the STAR external invoicing system to Oracle Payables module and email the status reports to the department heads
• Conduct various PowerPoint presentation on client’s needs
• Redefining approved suppliers list
• Create and follow up on Service Request (SR) with Oracle support
• Creating various complex FSG reports for business users
• Involved in web conference meetings with the Oracle support team

Confidential, Houston TX

Oracle Financials Consultant

Environment: Postproduction support on GL, AP, AR, CE, AGIS, E-BTax, FA, PO & I-Expense (version12.0.6)

Responsibilities:

• Include evaluating the design and development needs of the client
• Writing functional specifications and technical specifications
• Debugging and testing, functional & technical support and issue resolution
• Executed best practice business procedures and processes in application analysis and design
• Designed custom interfaces, process and reports to meet client’s requirements in General Ledger, Payables and Purchasing, AP invoice fixes, Invoice Import
• After the CRP session changes are applied through Change Management Process
• Conduct Oracle web conference with Oracle support team
• Provided AIM Document forBR100 for GL. AP, & CE
• Develop Test scripts and Business scenario for CRP and UAT
• Managed Oracle Service Requests and testing of Patches

Confidential, Cambridge MA

Oracle Financials Functional Consultant

Environment: Upgradation of FA, AR & CE (11.5.10.2 to R12.0.5)

Responsibilities:

• Involved in the implementation of Fixed Assets module globally throughout the entire business in a phased manner
• Assisted the technical team on developing & data migration from older version to newer version
• Review of changes/upgrades to any of the Interface design and code, responsible for creation of Test cases and Test plans for business unit testing
• Run open period, applying the receipt to the transaction and create accounting for accounts receivables
• Changing payables option for accounts payables for CE
• Creating Clearing account in GL and also create account for CE
• Updating the interface design documents with the latest changes/upgrades
• Preparing the business requirement documents, related functional specification documents to satisfy the clients basic business needs in Oracle Financial modules
• Reproduce the bug & patch fixing scenario in Vision instance to check whether it works
• Involved in support and maintenance of various modules in Oracle Applications R12 Oracle Account Payables, General Ledger
• Assisted in preparation of BR100 documentations for FA, AR & CE
• Involved in debugging and troubleshooting of various forms and reports issues as part of support and provided the solutions for the same
• Helped prepared the test script with more scenarios
• Interact directly with the end-users and clients, Interact with the users of legacy systems to get invoice and payment issues resolved ASAP

Confidential, Delray Beach FL

Oracle Financials Functional Consultant

Environment: Implementation & Postproduction support on PO, AP, FA (version 12.0.3)

Responsibilities:

• Prepared MD.50 application extension functional document after GAP analysis of RICE components
• Configured CRP1 and UAT instances for AP and FA modules
• Set up Financial option & Payable option in AP
• Set up of PO document types
• Assisted in defining suppliers approved list
• Defined payment terms, invoice approval hierarchy
• Created mass additions, worked on Mass additions program and Asset workbench
• Defined the prorate calendars, depreciation rate and calendars, fiscal calendars and book controls
• Conducted training sessions for the financial modules AP, FA. Aim of the training session was giving an overall flow of the Oracle system to the business users
• Coordinating with the users for the user acceptance testing
• Provided support for the client’s production instance post Go-Live
• All the collected data entered into the system, by using ADI, SQL loader, Data loader (Such as open invoices of AR, Fixed Assets through ADI)
• Involved in changing the suppliers and its site for its payments and billings
• Involved in the post production support phase for trouble shooting issues and helping development team in bug fixing

Confidential, Moberly MO

Oracle Financials Functional Consultant

Environment: Postproduction support on GL, AR (version 11.5.10.2)

Responsibilities:

• Diagnosed, analyzed and solved issues relating GL and AR
• Interactions with client/end users and updating the status
• Interaction with DBA on applying patches for the bug
• Training the end users and preparing end user training material
• Interaction with other modules consultants

Confidential, Sunnyvale CA

Oracle Financials Functional Analyst

Environment: Upgrade project on GL, AR, CE (version 11.5.8 to version 11.5.10.2)

Responsibilities:

• Setting up Project Plan and Mile Stones in the upgrade process
• End Training on the new features and functionalities
• Assisted in creating BR 100 documentation for AR and CE module
• Responsible for creating Unidentified and Unapplied receipts
• Created AR and CE transfer to GL program
• Preparation of Solution Document, Design and Migration documents
• Assisted in configuring data migration
• Prepare for upgrade using upgrade manual script
• Recreating custom programs, modifications and running RICE components
• Conducting testing and CRP sessions
• Conduct various PowerPoint presentation for the users

Confidential, Danbury CT

Oracle Financials Functional Consultant

Environment: Implementation & Postproduction support on GL, PO, AP, AR, CE (version 11.5.10)

Responsibilities:

• Gathered requirements from the business according to the current business flow and process as a part of preparing AS IS and TO BE documentations
• Participated in team meetings with client
• Performed mapping and GAP analysis for each module responsible
• Set up of COA, Calendar, Currency and creating Ledger at Accounting Manager
• Creating responsibilities through System administrator
• Set up of Recurring and Mass allocation
• Set up of Transfer and consolidation
• Set up Suppliers site, location, Bank accounts, defined payment terms, payment process profile and Transfer to GL
• Set up transaction type, memo line, receipt class and receipt method
• Run Transfer to GL program from AR
• Set up Bank reconciliation
• Involved in setting up of PO documents types
• Worked on different PO types
• Assisted in setting up of suppliers and creating site for payments & billings
• Involved with writing and executing test scripts
• Co-coordinated with technical team for Conversion of historical data.
• Conduct PowerPoint presentations for the training session to the business users
• Assisted in developing GL, AP, AR and CE Training Guides using UPK
• Assisted in configuring CRP, test instance
• Worked with Oracle Support to resolve application issues, bugs and TAR management
• Provided post-production support and helped in period close process.

Confidential, San Diego CA

Oracle Financials Functional Consultant

Environment: Implementation of PO, AP, AR, CE, (version 11.5.10)

Responsibilities:

• Involved with Super User Training and resolving post UAT issues.
• Re-defined system parameters and Bank Statement Mapping in CE
• Corrected the system configuration to take care multi currency invoice entry and payments
• Developing AP, AR and CE Training Guides
• Worked on different PO types like Standard PO, Blanket Purchase Agreement, Plan PO and laso Contract Purchase Agreement
• Assisted in creating releases for the POs and agreement
• Setup the Auto Cash rule set according to client requirements
• Support Business Users in Month End Close Process
• Resolve the Reconciliation issues with Sub ledgers to GL
• Prepared documentation at various phases.
• Solution to complex issue through Metalink

Confidential

Oracle Financials Functional Consultant

Environment: Implementation of GL, AP (version 11.5.9)

Responsibilities:

• Gathered and prepared requirements from Business Users
• Prepared AS IS documentation on business requirements and mapping process
• Assisted Co-workers on running GAP and preparing TO BE documentation
• Run smoke test while preparing CRP
• Assisted in configuration of CRP1, test instances using Test script
• Creation of COA, Calendar, Currency for the Set of books in GL
• Coordinated with Payables in creating suppliers and setting up Invoices and Payments
• Conducted numerous PowerPoint presentation on Oracle functionality to the users
• Performed configuring on test instances