We provide IT Staff Augmentation Services!

Oracle Financial Functional Consultant Resume

4.00/5 (Submit Your Rating)

Sacramento, CA

PROFESSIONAL SUMMARY:

  • Confidential has7 years of IT Experience, which includes experience as a Functional Consultant/Business Analyst with specialization in Oracle Financial and Distribution Systems
  • His industry experience revolves around Oracle ERP Applications - Implementation, Support and Upgrade.
  • He is well conversant Oracle Financial Modules - AR, AP, GL, FA, Revenue Recognition, Cash Management, OM, INV and PO.
  • Have 2 full life cycle implementations in Release 12.
  • He well understands for both the “Quote to Cash” process as well as the “Procure to Pay” process.
  • He is very much conversant with Configuring Oracle Application modules as well as understanding the underlying schema, which give me a better insight into converting user requirements into functional and technical specifications.
  • Extensive experience with Training of End Users and Business Super Users using Oracle Tutor, WebEx virtual training and well as conducting of CRP’s and UAT’s.
  • Well versed in preparing training material and training manuals.
  • He has been actively responsible for testing of the functionality of Oracle ERP Application.
  • He is well conversant with documentation as per the AIM methodology.
  • He has also been involved in scoping and mapping of business requirements of clients for Oracle Financials/Distribution solutions.
  • He is actively involved Conference Room Pilots and User Acceptance Testing.
  • His responsibilities also include building, testing & development as per Business Requirements.

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

Oracle Financial Functional Consultant

Responsibilities:

  • Understanding the existing business processes including AR, AP, GL, Revenue Recognition & Cash Management
  • Preparing existing business process documents
  • Discussing with business users and preparing BP80 for future To Be Process documents for AR, AP, GL, & Cash Management
  • Mapping the business processes with Oracle 11.5.10 standard functionalities and identifying the gaps.
  • Worked on setting up of Revenue Recognition process in AR Module
  • Defined the Accounting and Invoicing rules to be used in Revenue Recognition process in AR.
  • Giving demonstration of standard functionalities of AR, AP, GL, FA & Cash Management to the Business Users.
  • Proposing solutions and customization for gaps and getting the approval from business users.
  • Working with Technical team closely and getting done development for customizations for AR, AP, GL, FA, Revenue Recognition & Cash Management Modules.
  • Working closely with Business users to understand the criteria’s and filters for converting data from 11.0.3 to 11.5.10 for AR, AP, GL, FA, Revenue Recognition & Cash Management
  • Working closely with developers to develop code for data migration using Oracle APIs and wrapper programs
  • Preparing technical specification documents for AR, AP, GL, FA, Revenue Recognition & Cash Management
  • Preparing BR100 and Completing the Setups and configurations for AR, AP, GL, FA, Revenue Recognition, & Cash Management
  • Preparing and using data loader script to load the data and completing setups for Service Request module.
  • Preparing the test cases for AR, AP, GL, FA, Revenue Recognition & Cash Management modules
  • Conducting CRP1, CRP2 UAT1 and UAT2 and helping the user for going through all the test cases.
  • Fixing the issues collecting during CRP1, CRP2 and UAT.
  • Working 24 by 7 during cutover and down time
  • Providing support to users after implementation is done and fixing all issues related to set ups
  • Fixing the issues for converted data for AR, AP, GL, FA, Revenue Recognition & Cash Management modules

Environment: Oracle Apps 11.5.10 e-Business suite- AR, AP, GL, FA, Revenue Recognition & Cash Management SQL*Loader, Data Loader, file loader, Toad, Windows NT, HP UNIX.

Confidential, LA, CA

Oracle Financial Business Analyst

Responsibilities:

  • Interaction with business users as a part of As - Is Study for clients legacy application D3 Pick for (AR, AP, GL, FA, Revenue Recognition, Cash Management, Oracle Purchasing, Oracle Payables, i-Procurement, Order Management)
  • Setup the Work Execution flow and Preventive Maintenance Flow in Enterprise Asset Management.
  • Worked on the Revenue Recognition process in AR including setting up the deferred revenue rules.
  • Performed all the setups for AR, AP, GL, Revenue Recognition OM, Inventory and PO.
  • Setup Modifiers/Qualifiers in Advance Pricing.
  • Business Requirement, Scope Management Documents Preparation
  • Fit Gap Analysis for (AR, AP, GL, Revenue Recognition, OM, INV, PO) & preparation for Fit Gap Document
  • To Be High Level & Detail Documents Preparation
  • Module Configuration Documents Preparation AR, AP, GL, FA, Cash Management OM, INV, PO, Shipping, i-Procurement modules setup
  • Worked on a deferred revenue customization using the Revenue Recognition process in AR.
  • User Training as a part of CRP1, CRP2, CRP3
  • Data Migration requirement gathering for (BOM, Routings, Items, Open PO, Suppliers)
  • Data Migration functional specification documents creation
  • Design Creation & Validations
  • Application testing w.r.t individual module
  • Issues Tracking & Customer Sign off

Confidential, Miami, Florida

Oracle Financial Functional Consultant

Responsibilities:

  • Requirement Gathering for (AR, AP, GL, FA, Revenue Recognition, Cash Management, OM, INV, PO)
  • Functional Specification Creation for AR, AP, GL, FA, Revenue Recognition, & Cash Management.
  • Worked on the Revenue Recognition process, including setting up the Accounting and Invoicing Rules for daily Revenue Recognition.
  • Design Creation & Validations of all the interfaces and conversions.
  • Issues Tracking & Customer Sign off
  • Led the UAT and CRP Testing.
  • Led the training effort for the end users, business users, power users as well as functional resources.
  • Prepared training materials for all Financial modules like AR, AP, GL, FA & Cash Management
  • Conducted the UAT and CRP for training purposes.
  • Used WebEx for training the remote users in China.
  • Used a combination of Word Documents and Powerpoint slides to provide the training.

Confidential, San Diego, CA

Oracle Financial Functional

Responsibilities:

  • Setting up Multi-Org Environment for the New Operating Units
  • Setting up Approval hierarchies for the application
  • Customizing Approval hierarchies as per Unisys business flow
  • Have created Data Loading scripts for PO/Requisition loading into Unisys Apps from legacy system
  • Configured AR, AP, GL, FA, Revenue Recognition, Cash Management, Order Management, Inventory, i-procurement, iStore and Quoting.
  • Worked on a customization for Deferred Revenue is AR using Revenue Recognition process.
  • Have worked on Auto Shipment
  • Have done setting up of Vendors/Banks
  • Troubleshooting critical issues
  • Key Point of Contact for (AR, AP, GL, FA, Revenue Recognition, Cash Management)
  • Work on Critical Enhancement’s & Bug fixes
  • Maintaining Unisys Purchasing/Payment operations
  • Client Interaction
  • Have done Due Diligence & created SPP/SOW/Risk Plan/DPP for the project
  • Maintaining SLA’S for project
  • Establishing & Controlling delivery processes to maintain quality & quantity of deliverables

Technology Environment: Oracle Apps 11.5.8, Oracle PL/SQL, Developer 2000, Toad and SQL navigator as tools for SQL queries

Confidential, Chicago, IL

Application Lead

Responsibilities:

  • Key Point of Contact for (AR, AP, GL, FA, Revenue Recognition, Cash Management)
  • Process Architecture & Enhancement.
  • Worked on Revenue recognition in AR.
  • Worked on key tasks such as Sub-Inv. Transfer, Costing for Inv.
  • Worked on Writing and Customizing Interfaces.
  • Worked on Auto Shipment
  • Created Inventory Organizations
  • Developed the Revenue Recognition process in AR for Deferred Revenue and Regular Revenue for Product and service.
  • Done Repair Blanket PO SET UP for WIP Jobs.
  • Populated Items By Using Templates
  • Worked on Performance Tuning using SQL TRACE/TKPROF/EXPLAIN PLAN
  • Done Complete Automation of Opening AR/ AP/ GL/ OM/PO/INV Periods.
  • Have Enabled Segment9 for Accounting Flex Field
  • Involved in Database upgrade from 7.3 to 9i.
  • Complete Process flow knowledge on AR, AP, GL, FA, Revenue Recognition, Cash Management
  • Concurrent Manager Administration, Interface monitoring.
  • Involved in Tracking/downloading/Applying patches
  • Have Experience in Configuring Concurrent manager/Setting up printers
  • Concurrent Programs, reports, Request groups Creation, registration, scheduling
  • Application Users creation.
  • Performance Tuning for Reports & Interfaces.
  • User’s Training on Key issues.
  • Root Cause analysis for reoccurring problems on AR, AP, GL, FA, Revenue Recognition, Cash Management

Technology Environment: Oracle Apps (10.7sc/11I), Oracle PL/SQL Developer 2000, and PL/SQL, Using Toad and SQL navigator as tools for SQL queries

We'd love your feedback!