We provide IT Staff Augmentation Services!

Oracle Financials Functional Consultant Resume

5.00/5 (Submit Your Rating)

Boston, MA

Summary:

  • Over Seven (7)& halfyears of experience as an Oracle Financial Functional Consultant, experience in full-fledged Support and involved in End-to-End Implementation projects.
  • Experience in Oracle E-Business Suite Applications including 1 years of experience in the area of Accounts & Finance.
  • Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User Training and Supporting for Oracle Financials R12/11i GL, AP, AR, CM, and FA modules.
  • Participated in multiple Oracle apps 11i implementations in multi org/multi currency scenarios, Order management and worked as areas involving Pricing, Purchasing, and Inventory.
  • RedesignedCashManagement, PaymentsBusiness Processes and IT operations.
  • Working Knowledge in P2P and O2C Cycles.
  • Created inter company Transaction, Consolidation, Elimination entries setups and configurations.
  • Designed and executed several Customizations and Setups in ERP as a part of Revenue Recognitions solutions.
  • Actively involved in all Transition activities (TCA, TCB, TCC & FPR) code migration and customizations of RAE Project.
  • Expert in preparing RD020, BP040, BP080, BR100, MD050 and TE040 documents.
  • Experience in Data mapping the external source files with oracle columns in Oracle Accounts Receivables, Accounts Payables and Fixed Assets modules.
  • Prepared Functional design documents for customizations/conversions using AIM methodology.
  • Experience in all phases of the system development/implementation life cycle.
  • Excellent team player with immense ability to grasp new concepts and apply them as per business requirements. Well organized with interpersonal and developmental skills, strong work ethics and willingness to work hard to achieve employer goals and targets.

Technical Skills:

ERP: Oracle Financials R12/11i/11.5 (GL, AP, AR, CM, OM and FA)
ToolsTOAD, ADI, SQL*Loader, Data Loader and Kintana 
Accounting Packages: Tally, Wings, Sage and MS Office
Operating Systems: Windows 95/98 /NT/2000/XP and UNIX

Experience:

Confidential, San Jose, CA
Project: GTC Intercompany RAE Project

Role: Onsite Functional consultant 
The Revenue Accounting Engine (RAE) enables those capabilities that would be common to a number of the Revenue Business Architecture systems and centralize them into a single “capabilities engine”. The RAE would be a “behind the scenes”, foundational technology layer supporting a number of Revenue Systems and capability needs.

In Cisco, revenue recognized on a sale transaction is determined or recognized based on transaction type. They are standard or Non-Standard deals. For Standard deals, revenue is recognized immediately where as Non-Standard deals, revenue is being deferred, deferral accounting handled through Accounting Engine (AE), CCRM and Manual Adjustments in GL etc., AE is not capable to handle the business requirements in deferral accounting. Hence, Cisco implemented New Deferral Accounting Engine called Revenue Accounting Engine (RAE). RAE is capable to handle the Cisco’s deferral accounting business requirements with additional features. 

Responsibilities:

  • Prepared Business and functional requirement document for the RAE project.
  • Analysis of the current system by interacting with business and cross functional team.
  • Responsible for all deliverables including Data extract programs, Reports and $U programs.
  • Mapping the Client requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of Customizations, workarounds, reengineering and form personalization.
  • Customization designs and work around for various business requirements in R12.
  • Worked on configuration changes for Brazil new entity (R12).
  • Analyzing the issues on Production System and resolving them.
  • Testing the functionality of new enhancements for new entitles in R12 (brazil entity).
  • Coordinating the Cross Functional teams for customizations and calling out key issues.
  • Giving the overview on functional modules to technical team.
  • Successfully completed all transition activities (TCA, TCB, TCC and FPR)
  • Analysis of the current system by interacting with business and cross functional team.
  • Responsible for the Kintana migration the components form one instance to other instance also using the PVCS for version control.
  • Leading the offshore technical team and working in multiple time zones for implementing the Functional and technical solutions.
  • Prepared BR100 Documents for business users and addressing training (KT) sessions to users.

Environment: Oracle Applications R12, 11.5.8 (OM, AR, GL)

Confidential, Boston, MA
Oracle Financials (GL, AP, AR, FA, CM & I-expenses) Implementation
Oracle Financials Functional Consultant

Responsibilities:

  • Gathering the Client Requirements and preparing the documents using AIM Methodology.
  • Prepare AS-IS of current State Street System, find and recommend work around of GAPS.
  • Created custom interface to integrate American Express corporate card (AMEX) with iExpenses.
  • Involved in integration between the Mark view system and Oracle AP for Non-PO invoices.
  • Implemented a Custom AME rules to approve the Non-PO invoice based on RC or Supplier or Supplier site.
  • Performed Unit testing, UAT and End-User training for Go-live.
  • Streamlining the Advance collections process to support the planning and management of collection strategies and related work items.
  • Part of Suppliers conversion from Smart stream system to Oracle Account Payables.
  • Created inter company Transaction, Consolidation, Elimination entries setups and configuration for use .The use of ADI wizards like Budget wizard, Journal wizard, report wizard simplified work with general ledger.
  • Designed and executed several Customizations and Setups in ERP as a part of Revenue Recognitions solution.
  • Provided solution for Revenue Recognition requirements by developing extensions.
  • Customized revenue Recognition rules by using API’s in Project Accounting.
  • Mapping the Client Requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of Customizations, workarounds, and reengineering and form personalization.
  • Prepared RD020, BP040, BP080, BR100, MD050 documents for each financial module.
  • Configuring the Oracle Accelerators, which can do the setups automatically in client’s targeted instance.
  • Preparing TE040 Documents, which can helpful to test the application functions.
  • Interacting with Oracle development team regarding issues resolutions.
  • Participate in Analysis, Design and Testing of the code and documentation.

Confidential, Houston, TX
Implementation/Support of Oracle Application 11i Financials
Oracle Financials Functional Consultant

This implementation was done in a time frame of 32 weeks for 19 modules of Oracle e business suite. Aim of the project is enabling business worldwide to grow and to help the customers and take advantage of opportunities that enable them to reach full potential Market. 
Responsibilities:

  • Application Enhancement and Support for AP, AR and GL modules.
  • Business process analysis and requirement gathering for new customization, report development.
  • Involved in iExpenses project costing, integration, performed configuration setups related to project accounting for expenditures types, expenditure classes and categories.
  • Setup iExpense to enable project expense reports, Setup auto accounting for iExpenses related expense types, and expense templates.
  • Conducted CRP, UAT and training for end users and production support.
  • Performing Business Requirement Study in Financials and modelling Future Process Model and preparing AS-IS (BP040) and TO-BE (BP080) documents.
  • Prepared RD020, BR100, TE040 (Test Scripts) and End User Training Manuals.
  • Forms and Reports Customization to provide functional specifications to technical team.
  • RedesignCashManagementandPaymentsBusiness Processes and IT operations for Retail and Commercial Banks.
  • Automatic bank statement reconciliations, Cash pooling, Cash forecasting and Cash positioning.
  • Performing period-end processing for Oracle Cash Management.
  • Custom P2P(Procure to pay) Process: The process of procuring material from the organization and getting paid for the process oh handling material .This process picks the PO’s which have AP invoice option defined in DFF and create Requisitions and creates against the Supplier.
  • Gross Sales Report, Report displays the Order Information, AP and AR Invoices, Customer/Supplier Information, Invoice amount details, Trips and shipment information etc….

Environment: Oracle Financials 11.5.10 (GL, AP, AR, PO, INV, and I- expenses)

Confidential 
Implementation of Oracle 11.5.10 Financials and Purchasing modules 
Role: Oracle Financials Functional Lead

Responsibilities:

  • Conducting meetings with Team members to discuss about project scope and project planning.
  • Responsible for successful roll out of Oracle applications for Financial and Purchasing modules.
  • Preparing and tracking the Project plan. Ensure the timelines are met.
  • Solution design for UK and India operating units roll out, including India localizations.
  • Performed all the financial set ups, built FSG’s for various financial statements.
  • Providing customization designs and work around for various business requirements.
  • Reviewing the documentation and responsible for sign offs.
  • Designed and executed ‘Data migration’ strategy for master and transactional data.
  • Post go-live support.
  • Month end closing procedure– design, documentation, training and issue resolution.
  • Dealt with Users from Offshore team as required for resolving the issues.
  • Done the Configuration for GL, AP, AR, and Cash Management modules as per the client needs.
  • Maintain and present the project metrics to the Management.
  • Conducting CRP, UAT and User Training for Implementation.
  • Planning, finalizing and Preparing Primary Ledgers, Reporting Ledgers, and Ledger sets as per client reporting requirements.

Confidential
Role: Oracle Functional Consultant

Responsibilities:

  • Documenting the mapping and requirements for the interfaces and conversions between the source and Oracle Applications.
  • Preparing the questionnaire and required documents by using AIM Methodology.
  • Making required setups and Customizations in corresponding modules.
  • Worked on Payables Open Interface Import to create invoices from external systems into AP Invoice tables.
  • Customized the Accounts Payable Vendor Entry Form as per requirements
  • Created Alerts to notify users on various business events
  • Developed a package to import expense information into Oracle Payables.
  • Creating custom Reports and Forms for the end users to check the details and errors.
  • Executed the Payables Transfer to GL program and resolved the issues during the process.
  • Technical and user documentation of the customizations.

Environment: Oracle Financials 11.5.9 (AR, AP, and FA)

Confidential
Role: APPS Functional consultant

Responsibilities:

  • Involved in setting up various modules of Oracle 11i E-Business with Implementation Partners.
  • Created Alerts to notify users on various business events.
  • Resolving the issues rose during the implementation life cycle.
  • Supporting solving Day-to-Day End–User problems.
  • Performing Week/Month end Reconciliation.
  • Direct interactions with users and seeking information as required for resolving issues.
  • Performing Week/Month end Reconciliation Activities.
  • Periodic Communication to Users Regarding the process on the issues being worked on.
  • Analysis of the Problem/Issue Reported on Remedy Toll and Suggesting Solutions.
  • Reporting to TL/PM on the status of the Remedy Tickets.
  • Raising SR to Oracle for Critical Issue Solution.

Environment: Oracle Financials 11.5.9 (AP, GL)

Confidential
Accountants Executive

Responsibilities:

  • Managed accounting and finance functions of the company.
  • Preparing Income and expenses statements.
  • Monitoring and Vouching Cash and bank accounts and transactions.
  • Verification of Bank Reconciliation statement.
  • Maintain customer records Reconciliation statements etc.
  • Monitoring the day to day accounts payable and accounts receivable.
  • Maintenance of accounts (manually and through tally) and Cash books.
  • Ensure compliance with relevant legislation.

Education: MS in Accounting & Finance from Confidential, London.
ACCA (Association of charter certified accountant) Confidential, London.

We'd love your feedback!