We provide IT Staff Augmentation Services!

Oracle Futional Analyst Resume

0/5 (Submit Your Rating)

NC

SUMMARY:

  • 8 plus years of experience as an Oracle Apps Financial Functional which includes Implementation, up gradation, Testing and Production support on Oracle Apps 11i, R12.
  • Having 7+ years Techno - Functional experience in Oracle Application Modules which includes General Ledger, AGIS, Order management, Payables, Receivables, Advanced Collections, Cash Management, Fixed Assets, E-Business Tax, Purchasing, iProcurement and iExpense.
  • Excellent configuration experience on Procure to Pay, Order to Cash, and Assets to GL Cycle’s Using Multi-Org.
  • Conducted requirements gathering workshops, prepared AS-IS(BP-040),TO-BE(BP080), GAP analysis, Application setups (BR-100), Functional design (MD050) documents and Conducted CRP,SIT, UAT sessions and user training for accounting professions and users using AIM methodology.
  • Worked on R12 Financial Modules and SLA, MOAC, TCA, E-Business Tax.
  • Trained the client’s super users and users on the application and conducting Pilot testing, integrated testing, design validations and setups of the Distributed ERP applications.
  • Functional documentation for configurations (setups), User Training documents and customization.
  • Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports
  • Experience testing Conversions, Interfaces, Data Migration, RICE customizations.
  • Good Team player and leading key business scenarios meetings with coordinating and getting signoff from business for the proposed business scenarios.
  • Worked in Onsite and Offshore model projects including coordinating and leading offshore team
  • Experience in project go-live and post-implementation support.
  • Production Support - Order Management, iPayment, Inventory and Accounts Receivables.
  • Prepared Test cases TE-020,030,040 for Financials modules (AP, AR, FA, CM, OM, PA and GL).

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications 12i/11i

Oracle Modules: GL, AP, AR, Advanced Collections, FA, CM, PO, INV, PA, OM, AOL, SLA, EBTax, iExpense, iProcurement and FAH.

Database: Oracle 11/10g/9i/8i

Tools /Utilities: TOAD, SQL Loader, Data Loader, SQL, PLSQL

Operating Systems: Sun OS/Solaris 2.x, HP-UX, Linux and Windows

PROFESSIONAL EXPERIENCE:

Confidential, NC

Oracle Functional Analyst

Environment: Oracle Applications R12 (GL, AP, AR, FA, CM, PA, INV, OM, Purchasing, iExpenses, EB Tax), Oracle 10g, (SQL, PL/SQL), TOAD.

Responsibilities:

  • Implementation of Oracle Payables including setup of payment options, payment terms, distribution set, payment format, banks, expense report templates, matching options, tax codes.
  • Worked with R12 implementation team in AP, PO, EB Tax, GL & iExpenses modules in Multi-Org Environment.
  • Liasoned between the technical staff and the users (staff and management). Was also responsible for interdepartmental co ordination between the various teams involved
  • Prepared the data collection sheets for inventory, purchasing and Order Management modules.
  • Involved in the setup of tax configuration using the Regime to Rate flow and setup the tax rules.
  • Implementation of Oracle Fixed Assets module using AIM methodology, which included Asset categories, asset locations, book controls, depriciation methods, security profile, asset calender, fiscal year, quick codes and system controls.
  • Worked on setting up of accounting method builder (AMB) for Financial accounting hub.
  • Prepared Functional design document (MD50) and Functional Setup documents (BR100), Test Scripts (TE020) as per AIMS Methodology.
  • Supported Procure to pay and FA issues with month end and additional configurations.
  • Participated in user testing and helped in migration to production for BAU activities.
  • Providing production support of Oracle financials, including following up SR’s with Oracle Meta link.

Confidential, CA

Oracle Functional Analyst

Environment: Oracle Applications 11.5.9(GL, AP, AR, FA, CM, PA, Purchasing, iExpenses, EB Tax), Oracle 10g, (SQL, PL/SQL), TOAD.

Responsibilities:

  • Involved in the Up-gradation of the Application for all financial modules like GL, AP, AR, FA, CM, PA, Purchasing and the Self-Service Modules Like iExpenses.
  • Prepared and updated BP 40, CV40, BR100 documents and created MD 50 for all RICE components
  • Designed and created new CHART OF ACCOUNTS and set of books.
  • Created users and modified the privileges for users, rollup group and summary accounts.
  • Created suspense accounts for automatic balancing journal entries from particular sources and categories.
  • Created budget, budget organization, master detail relationship, budgetary control and budgetary control groups.
  • Developed several FSG reports, including balance sheet and income statements.
  • Set-up supplier and supplier sites for suppliers in payables.
  • Set up banks, receipts, transactions, plus training for invoicing, receipts, adjustments, and period close.
  • Created updating adjustment of invoices, debit memos, credit memos.
  • Defined banks, customers, receipt classes, collectors.
  • Involved in setting up Project resources and roles to the project, Jobs and organizations for project Organizations, creating and maintaining Project budgets and worked on PA costing Import Process as part of project costing and billing.
  • Conducted orientation training, CRP, UAT and Rollouts strategies for System up gradation.
  • Provided production support for day to day business issues and worked on SRs with Oracle.
  • Provided daily user support for Fianancial modules and applied patches as and when required to resolve the Application issues.

Confidential, Menlo Park, CO

Oracle Applications Functional Consultant

Environment: Oracle Applications R12 - (GL, AP, AR, CM, FA, Purchasing, iProcurement), Oracle 10g, (SQL, PL/SQL), TOAD.

Responsibilities:

  • Resolved all the functional and technical issues for AR, AP, CM, FA, GL, PO and iProcurement Modules.
  • Preparation and modification of documents like MD050, BR100 as part of project Deliverables for the change requests for functional and technical configuration changes.
  • Post production support and maintenance of the Application and resolved user queries.
  • Involved in the month end closure and reconciliation activities to close the periods on respective financial modules.
  • Provided production support for day to day business issues and worked on SRs with Oracle.
  • Provided daily user support for Fianancial modules and applied patches as and when required to resolve the Application issues.
  • Log, view, access, monitor, follow up and close Service Requests (SRs) online through Oracle Metal ink and Oracle Applications Patch Management.

Confidential, San Diego

Oracle Applications Functional Consultant

Environment: Oracle Applications 11.5.3 - (GL, AP, OM, AR, CM, PA, FA), Oracle 10g, (SQL, PL/SQL), TOAD.

Responsibilities:

  • Played significant role in the Upgrade Patch set analysis in identifying the impacted components.
  • Interacted with Oracle to get the issues addresses by logging SRs.
  • Developed Training Material for OM and AR modules and prepared impact analysis for critical issues.
  • Tested the revised Customer Interface that takes the new Customer Type into account by enabling to load customer data for both Organizations and Individuals.
  • Responsible for preparation of test scripts and monitoring UAT.
  • Worked on HP Quality Center to create Test Scripts, Test Cases and testing various Functional activities.
  • Responsible for Retrofitting and re-building custom components post execution of standard features testing.
  • Involved in the Bridge Calls during Cut-over/ Go-live phase.

Confidential

Oracle Functional Analyst

Environment: Oracle Applications 11.5.10 - (GL, AP, AR, CM, INV, Purchasing), Oracle 10g, (SQL, PL/SQL), TOAD.

Responsibilities:

  • Worked as an Asst. Functional Analyst for Oracle management, Receivables, Inventory.
  • Studied and evaluated functionalities of various modules.
  • Prepared Setup documents (BR100) for OM & Accounts Receivable.
  • Created Responsibilities with menu exclusions as part of SOD & tested all the menus & functions.
  • Configured Financial Statement Generator (FSG) Reports for financial reporting by defining Row Set, Column Sets and Content Set.
  • Prepared functional Design Documents for application extensions and conversions (MD.050).
  • Prepared Test Scripts for Integration Testing (TE040).
  • Handled post go - live user support.

We'd love your feedback!