Oracle Financial Functional Consultant Resume
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 ConsultantResponsibilities:
- 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