We provide IT Staff Augmentation Services!

Oracle Financials Functional Consultant Resume

5.00/5 (Submit Your Rating)

Houston, TX

PROFESSIONAL SUMMARY:

  • 9+ years of experience with multiple EBS projects in Oracle Implementation, Upgradation, and Post Production Support in both 11i and R12 versions. Expertise working extensively on General Ledger (GL) including AGIS, Accounts Payable (AP) including Payments, Accounts Receivables (AR), E - B.Tax, Cash Management (CE), Fixed Assets (FA), Purchasing (PO), Order to Cash (O2C Cycle), Procure to Pay (P2P Cycle) and Acquire to Retire (A2R Cycle) and Sub Ledger Accounting (SLA).
  • A team player with exceptionally good organizational, analytical,, trouble shooting, functional and interpersonal communication skill, a key team player.
  • Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User and Supporting for Oracle Financials R12/11i GL, AP, AR, CM, FA, PO, FAH, WMS and modules.
  • Experience preparing BR 100, BP-80, and MD-50, RD20, and TE40 documents. Business requirement gathering, GAP Analysis including SQL database queries and components documentation and configuration of financials modules.
  • Expertise in Implementation of Oracle General Ledger, Accounts Payable, Accounts Receivables, Fixed assets, Cash Management, E-Business Tax, Sub ledger Accounting
  • Experience preparing Functional design documents for customizations/conversions using AIM methodology.
  • Preparation of documents for CRP (conference room pilot), UAT (user acceptance test).
  • Functional knowledge on other modules like Oracle Internet expenses and Reporting tools like BI (GL AP AR and FA).
  • Expertise working with Oracle Support to resolve inconsistencies in Accounts Payable Trial Balance & Purchasing Accrual Reconciliation Report.
  • Experience working on various implementation and transformation projects which involve Multi-org, Multi-Currency configurations.
  • Experience working on request group, users, menus, flex fields configurations, responsibility creations required for customization through System Administrator.
  • Experience in working to coordinate Offshore Team for timely deliverables with respect to development of RICE components and Data Conversion and Data Migration strategy etc.,
  • Experience working extensively on oracle application module like GL, AP, AR and FA.
  • Experience Interacting with Oracle support to resolve application issues, bugs, and SR management.
  • Experienced in all phases of the system implementation life-cycle such as As-is/To-be process definition, requirement analysis, map and gap identification, system configuration, implementation, and post implementation support.

TECHNICAL SKILLS:

Oracle Applications: R12(12.0.3, 12.0.5, 12.0.6, 12.1.1 and 12.1.3) GL, AP, AR, FA,CE, E-BTax, I Expenses11i (11.5.8, 11.5.9, 11.5.10 and 11.5.10.2)

Languages and Tools: PL/SQL, Discoverer Viewer, Web ADI, SQL Loader, Data Loader, Oracle 11g, Hyperion; Microsoft Office, MS Visio, MS Project, MS SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle Financials Functional Consultant

Responsibilities:

  • Participated in multiple business meetings for Fit-Gap Analysis and Solution.
  • Assisted functional lead analyst to conduct CRP1 and CRP2.
  • Prepared BR.100 Application setup and MD.50 Application Extensions Functional Design documents according to AIM.
  • Involved in configuration of CRP1, UAT and test instance.
  • Trained Super Users and troubleshooting during UAT (User Acceptance Test).
  • Used the System Administrator responsibility to define users and assign responsibilities and set profile options
  • Define Organization Structure (MOAC), Users and Responsibilities, Security Profiles and Flex Fields
  • Set-ups and maintenance, converted the headers, lines and line locations from the legacy system to Oracle Payables
  • Involved in setup for Payables, Inventory, Purchasing, Inventory, General Ledger based on deep understanding of the functional processes.
  • Design & Develop FSG reports in GL
  • Set up AP bank accounts, bank documents, bank codes and expense report templates
  • Configured Sub-ledger Accounting to meet custom accounting needs and provide additional information on reports.
  • Defined profile options to specify certain implementation parameters
  • Set up Recurring journals template, recurring journals and Auto-reversal in GL.
  • Set up suppliers, locations, and purchasing quick codes.
  • Setup payment terms, invoice distribution, matching of invoices against PO.
  • Configured Financial Options and Payables Options in AP.
  • Created custom Customer invoice print templates
  • Configure System Options in CE.
  • Reconcile AP with bank statement in Cash Management.
  • Activation of various flexfields in the forms to gather the additional information.
  • Participated in testing, user accepting testing in test instance and worked with certain key super users.

Confidential, Ada, MI

Oracle Financials Functional Consultant

Responsibilities:

  • Worked closely with the business users on Finance Month End & Year-End close Issues (AP, AR, GL, FA).
  • Worked closely with Audit Team in Understanding the Cross-Currency Suspense Accounts in R12.
  • Worked as an Oracle ERP Analyst Re implementing/upgrading R12 Fixed Assets
  • Involved in Redesign of refund process (Refund Issue on returns, Refund Issue on edit cancels, Order entry form, Calculation and display of available AR)
  • Worked on the Root cause for the incorrect accounting for Refunds (No accounted amount is being populated in AR distrubtions table for some refunds.
  • Worked closely with Banks, Bank Accounts for internal purpose and Payment Formats for Manual Check and Electronic Fund Transfer (EFT) in single and multiple currencies.
  • Involved in Accounts Reconciliation for Year-end close
  • Involved in Redesign of refund process (Refund Issue on returns, Refund Issue on edit cancels, Order entry form, Calculation and display of available AR)
  • Involved in resolving the Currency Translation Issues (Reporting Ledger)
  • Performed User Acceptance Test (UAT) & for the end user on business process and procedures based on Financials modules
  • Coordinated the effort for the Monthly Releases (Release Management).
  • Coordinated with the Development teams, testing teams (offshore) and provide them the functional designs and helped them to understand the design. (Functional Specs)
  • Worked on SEV 1 SR’s for critical Month End Production Issues (Receipt Accrual’s, Payment’s, and Upload Journals through -WEB ADI).
  • As a part of Implementation/ On Going Production Support Project Responsible for Maintenance and Updating the BR100’s. For Account Payables, Fixed Assets, Account Receivables. & General Ledger.
  • Prioritize the tasks for the team based on feedback from the client meetings, number of defects and Project progress.
  • Help the business users in understanding the Key Reports (Accounts Payable Trail Balance Report, Account Analysis report and Depreciation Project Report, Un- Invoiced Receipt Report, Invoice Hold Report).
  • Worked closely with Business users in Understanding the Report Manager Functionality.
  • Involved in technical discussions for migrating the code and validated the code by testing in Test before moving the PPM Packages to Production.

Confidential, Kansas City, Kansas

Oracle Functional Analyst

Responsibilities:

  • Configured the Oracle system financial modules namely Account Payables (AP), Cash Management (CE), and Fixed Assets (FA) according to business needs. Occasionally helped out on other modules namely, inventory, OM, GL, and Receivables
  • Working on STAT tool for Change management process and migration of setup data from development instance all the way to the production instance.
  • Performed Requirement Analysis - gathering requirements, performing impact analysis and document requirements.
  • Attend design meetings for both the client teams and Project Development team; document high level design and detailed design.
  • Worked closely with Development team to ensure Implementation of the application as per the requirements and design as discussed with the business users.
  • Developed test scripts and test cases for Open invoices, 1099 Invoices, and supplier setups as well as performing testing of the setups done in the system.
  • Responsible for conversion and migration of Fixed Assets from the Legacy system into oracle.
  • Involved in production and post go live issue troubleshooting process.

Confidential, Atlanta, GA

Functional Consultant

Responsibilities:

  • Assisted/reviewed Payables and Cash Management.
  • Determine business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting.
  • Setup instance for new acquisitions.
  • Developed the new chart of accounts.
  • Provide post upgrade support.
  • Work with the developers to develop conversions, interfaces, reports (MD50’s).
  • Involved in the Functional implementation of Oracle Applications Financial including GL, AP, AR and CM modules.
  • Involved in Functional analysis, understood limitations of existing database (data tables) and proposed solution for implementation Oracle Applications modules.
  • Involved in requirement gathering and analysis and design of the application.
  • Gap Analysis & Mapping the business process with the standard functionality of Oracle Application.
  • Documented custom processes by using AIM Methodologies.
  • Designed Auto Invoice Import process and documented the import process in AR.
  • Corrected wrong currency problem in AR Invoice, Dr. Memo & Cr. Memo.
  • Setting up and customizing dunning letter, statement cycle in Accounts Receivable module.
  • Involved in Setting Up Oracle Advanced Collections and also involved in preparing Implementation Check list.
  • Performed implementation tasks like Set up scoring, create scoring components, Creating new score engines.
  • Entering parameters for Functional Variables, Set up Delinquency Status score ranges.
  • Set up Dunning plan aging bucket and setting up Collections dunning level and creating Dunning plans.
  • Creating strategy level and its template and updating the template.
  • Set up Oracle Advanced Collections Profile Options.
  • Wrote functional specification for reporting requirements in AP.
  • Developed month end procedures under changed environment.
  • Designed organization structure, territory / location flex field structure.
  • Defined Customers, Payment terms, Customer profiles, Statement cycle, Dunning Letters, Banks, lock box etc.
  • Created Responsibility and Assigning to users, Set the Profile Options.
  • Performed system integration testing and user acceptance testing.

Confidential, Bethesda, MD

Functional Consultant

Responsibilities:

  • Involved in implementing the Oracle applications for Accounts payable, Accounts receivable and General Ledger.
  • Facilitate meetings to gather functional requirements
  • Responsible for Full Life Cycle implementation of Purchasing and iProcurement.
  • Prepared documentation like Business requirements, Functional and Technical specifications, test cases, and data flow mapping.
  • Defined value sets, profile options, executables & concurrent programs.
  • Developed interfaces to load purchase orders and receipts using Purchasing Documents Open Interface and Receiving Open Interface.
  • Set up the complete Procure to Pay business flow starting from requisitions creation in iProcurement, using Auto create functionality to create purchase order or Sourcing Event, visibility of PO in I Supplier portal, ASN creation in I Supplier portal, Receiving in iProcurement and payment in AP. Most of the items were set for Auto Sourcing.
  • Responsible for Purchase Order and Item Conversions.
  • Auto creating Purchase Orders once the Requisitions are approved set ups were done using PO Create Workflow document type.
  • Worked with the functional department to design and implement new business processes around requirements.
  • Participated in providing Procure-to-Pay (P2P) life cycle support.
  • Setup and Configured GL, AP, CM, ADI, version R12.
  • Implemented Oracle Cash Management for bank reconciliation
  • Setting up Oracle receivables and enabling AR transactions summary tables.
  • Creating employee locations and organizations.
  • Involved in implementation tasks for Advanced Collections like set up custom tabs, metrics, work flow for promise approval.
  • Creating accounts, invoices, Delinquencies.
  • Involved in processing a credit card payment, bank EFT payment and collection activities.
  • Involved in Invoice letter template and various dunning letters.
  • Set up new account combinations and cost centers in the Oracle application.
  • Developed new chart of accounts.
  • Performed hands on configuration setups for GL and AP, including budgets, multi-org & multi reporting currency.
  • Participated in setting up of MOAC for managing multi-org setups.
  • Defined Sub Ledger Accounting Methods.
  • Creating a New Expense Report, Itemizing an Expense Line, Withdrawals, Updating an Existing Report
  • Delete an expense report.
  • View the Approval Status of an existing Expense Report
  • Responsible for internal travel and expense reports.
  • Defined currency translation, conversion, revaluation and set the profile options for GL.
  • Defined GL budgets and budget organization.
  • Defined the approval limit for new employees.
  • Setup Multi Org Structure including new Ledger setups based on 2 Legal Entities, and 2 Operating units.
  • Setting up FSG reports and custom views.
  • Participated in interacting with all concerned end users to achieve proper guidance to design customized forms, reports and to perform interfacing.

Confidential, Cupertino, CA

Functional Consultant

Responsibilities:

  • Defined currency translation, conversion, revaluation and set the profile options for GL.
  • Defined GL budgets and budget organization.
  • Defined the approval limit for new employees.
  • Setting up of suppliers and supplier sites by defining payment terms, distribution sets and tolerances.
  • Developed the customer invoice, statements and dunning letters.
  • Supported and modified existing purchasing and receiving interfaces in PO and Auto Invoice in AR.
  • Modified PO requisition workflow, AR notification workflow as per business requirement.
  • Involved in requirement gathering and analysis and design of the application.
  • Worked with the client team to understand the current Business Process.
  • Developed test plans and scripts and conducted testing for quality assurance.
  • Performed set up GL, AP, AR modules for 11i.
  • Designed Auto Invoice Import process and documented the import process in AR.
  • Corrected wrong currency problem in AR Invoice, Dr. Memo & Cr. Memo.
  • Setting up and customizing dunning letter, statement cycle in Accounts Receivable module.
  • Corrected customer Profile class setup & statement to avoid multilingual statement printing.
  • Configured and scheduled Standard Request Submission for standard APIs wherever required.
  • Configured the setups for prepayment to employees and defined employee expense report.
  • Developed FSG Reports in GL like (Income statement, Dept Expenses, Inter Company Summary).
  • Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.
  • Created and maintained User Menu objects.
  • Created responsibilities assigned to users and set profile option.

Confidential, Houston, TX

Financials Functional Consultant

Responsibilities:

  • Discussing AS IS business processes with SME’s
  • Define Accounting Key Flexfields /Chart of Accounts, - Value Sets, Segments and Segment Values
  • Define Accounting code cross validation rules
  • Configuring Currencies - Multi Currency
  • Define Accounting Calendar
  • Configure Human Resource Key Flexfields
  • Define Organization Structure
  • Define Locations and Organizations
  • Modifying default SLA rules to run transactions through to confirm that auto-accounting rules are correctly reflected in the SLA tables.
  • Map custom reports, such as custom reconciliation reports, to the new SLA tables
  • Configuring Common Apps and Core Financials Setups of AP, AR, CM, PO and OM
  • Define AP and AR Payment Methods/Terms, Lookup/Quick Codes, Payable System Options and Financials Options
  • Configure AR Transaction Types, Sources, Accounting Rules and Approval Limits
  • Define Receivable Activities, Standard Memo Lines, Receipt Classes and Receipt Sources
  • Identifying Payment Methods, Bank Account Defaults for Manual Receipts
  • Define State, County, City, Tax Regimes, Tax, Tax Rates and Tax Rules in eBusiness Tax module
  • Defining Bank and Bank Branches and Bank Accounts and Payment Documents
  • Configure Cash Management System Parameters
  • Defining Purchasing System Options and Purchasing Document Types
  • Setup and Assign Purchasing Approval Groups to HR Jobs
  • Define OM Price Lists, Pricing Formulas, Modifiers, Shipping Methods, Transaction Types and Document Sequences
  • Develop Functional Design Specs for Conversion of Customers and Suppliers
  • Write a Test Scripts for CRP and UAT
  • Performing CRP and UAT
  • Documenting BR100 Application Setups of GL, AP, AR, CM, PO and OM
  • Train the End Users during UAT
  • Prepare and Configure Setups for Production Instance
  • Production Support
  • Module: GL, AP, AR, CM, Payments, eBTax, SLA, OM and PO

Confidential, Baton Rouge, LA

Functional Consultant

Responsibilities:

  • Interaction and discussing business processes with SME
  • GAP Analysis and Conducting JAD Sessions
  • Functional Setups of all Financials Modules
  • Prepare and Conduct CRP1, CRP2 and CRP3
  • Functional Testing of all Financial modules
  • Developing Material with Navigational Instructions of Order2Cash, Procure2Pay with UPK tool
  • Designing and Validating Financial Statements Using FSG
  • Developing Student Guides for Users
  • Delivering Financials modules to Train-the-Trainer
  • Support the Business Users in Month-End Process and Consolidation Using FSG.
  • Support and Train the Business Users in UAT.

We'd love your feedback!