We provide IT Staff Augmentation Services!

Financials Functional Consultant Resume

Indianapolis, IN

SUMMARY

  • A Total of 8.5 years of experience which includes Oracle e - Business Suite Financial Functional expert including in-depth experience in design, support and implementation of software applications Including experience as a Functional Consultant with expertise in Order Management, Accounts Receivables, Cash Management, Credit Management, Accounts Payable, Oracle Treasury, e-Business Tax, General Ledger, me-Procurement, Shipping, Inventory, Purchasing modules.
  • Worked with reputed Clients from different countries
  • Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities.
  • Possess strong knowledge of Finance modules of AR, Treasury, Credit Management, AP, GL, Advance Collections, e-Business Tax, Sub Ledger Accounting, Fixed Assets, Cash Management modules
  • Experience with Vertex and Sabrix.
  • Experienced in working with Oracle Applications Release 12
  • Experience in preparing Requirement Analysis Documentation, Training scripts, Functional Documentation, User Training Documents and Customization Documents.
  • Experience with Revenue Recognition systems like RevPro and RevStrem
  • Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.
  • Strong communication & leadership skills with an ability to interact with business users and lead business projects.

TECHNICAL SKILLS

ERP: Oracle Applications R12, 11i

Modules: AR, AP, GL, FA, Advance Collections, Credit Management, Cash Management, SLA, E-BTAX, me-Expense

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis IN

Financials Functional Consultant

Responsibilities:

  • As a Functional Consultant implemented the following modules AR, Credit Management, Advance Collections, AP, GL, e-Business Tax, Sub Ledger Accounting
  • Worked on the Functional mapping of data Conversions & Enhancements for AR, Credit Management, Advance Collections, AP, GL, e-Business Tax, Sub Ledger Accounting modules.
  • Worked on the setups of e-Business Tax module - including the setups of Tax Rates, Tax Codes, Tax Regimes, Regime to Rate flow - for EMEA and US.
  • Worked on the integration of Oracle e-Business Tax with Vertex module.
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Worked on the configurations of Credit Management module - defining the Credit Checklists, Setting up credit limits, assigning collectors, configuring credit check rules etc.
  • Worked on Revenue Recognition process in Oracle AR - defining the revenue rules (accounting and invoicing), worked on event based and rule based revenue recognition, worked on Customer Acceptance process for revenue recognition, worked on integrating the Revenue distributions to an external system for reporting.
  • Worked on the Dunning Letter Setups in Oracle AR module
  • Worked on the Statement Cycle setups in Oracle AR module
  • Worked on the configuration of the Advance Collections Module - defining the advance collection engine, defining the collector work queue, setting up scoring components, strategies and dunning plans, delinquency information, etc.
  • Configured Oracle AR, Advance Collections, AP, GL, e-Business Tax, Sub Ledger Accounting modules from scratch and simultaneously created BR100 documentation for the setups.
  • Involved in troubleshooting issues on Auto Invoice Import Program.
  • Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
  • Completed Multi-Org configuration by creating a new Organization Structure for Ritter Sports by creating new Business Group, Legal Entity, Set of Books and Operating Unit.
  • Conducted Regression testing to examine the TEMPeffects of a new Org on the previous Org.
  • Conducted Multi-Org Revert Testing to create an TEMPeffective Revert Plan for WVI, as and when required.
  • Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
  • Provided with useful training to the users in AR, Advance Collections, AP, GL, e-Business Tax, Sub Ledger Accounting Modules.

Confidential, St Louis, MO

Oracle Financials Functional Analyst

Responsibilities:

  • As a Functional Consultant implemented the Record to Report Business flows including FA, AR, Treasury, AP, GL, e-Business Tax
  • Performed Requirement and Gap analysis.
  • Configurations and Setups for FA, AR, Advance Collections, Credit Management, AP, GL, e-Business Tax modules
  • Worked on the setup of Revenue Recognition in AR module.
  • Setup of Accounting and Invoicing rules in AR module
  • Defined the Auto Lock Box process in AR module
  • Defined the Auto invoice process in AR module
  • Worked on Bookings, Billing and Backlog process
  • Worked on the setups of Oracle e-Business Tax module - defining the rates, regimes, rate to regime flows, tax rules, exceptions, exemptions, etc.
  • Worked on Advance Collections setups - defining the parameters for collection engine, defined the delinquency rules, defined collection strategy, dunning plans, processing promise to pay, dispute invoices, etc.
  • Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module.
  • Also, worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
  • Pre-upgrade testing and Post upgrade production live support.
  • Support Production issues on a day to day basis including month end closure p1 issues
  • Implementation and support of Accounts Receivables, Treasury and Account Payable Module
  • Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Confidential, Greenwood Village, CO

Financials Functional Consultant

Responsibilities:

  • Preparing Business Requirement Documents (BRD) with the business rules associated to archive the daily transactional data across different Operating.
  • Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
  • Worked on the entire Order to Cash Flow.
  • Performed all the setups for As a Functional Consultant implemented the Order to Cash Business flows including AR, AP, GL, Credit Management, e-Business Tax, Advance Collections
  • Performed Requirement and Gap analysis.
  • Configurations and Setups for AR, AP, GL, Credit Management, e-Business Tax, Advance Collections modules
  • Worked on the setup of Revenue Recognition in AR module.
  • Setup of Accounting and Invoicing rules in AR module
  • Defined the Auto Lock Box process in AR module
  • Defined the Auto invoice process in AR module
  • Worked on the setups of the Scoring Engine in Oracle Advance Collections
  • Worked on the definition of the scoring strategies in Oracle Advance Collections.
  • Implemented TCA - for AR customer master conversions.
  • Worked on the setups of the Payment Manager in the AP module.
  • Worked on Line Level Matching feature in oracle AP module.
  • Setup the Payment Process Profiles (PPP) and Payment Process Requests in the Payment Manager in AP Module.
  • Worked on the payment transaction file to be transmitted to the bank using the EDI 820 Payment file
  • Worked on the AR/AP netting process in AP module.
  • Worked on the AP Processes of Retainage, Recoupment, etc.
  • Worked on the defining the transaction types, financial options, tax rules in Oracle AP module
  • Worked on the Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials modules.
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module.
  • Also, worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
  • Pre-upgrade testing and Post upgrade production live support.
  • Support Production issues on a day to day basis including month end closure p1 issues
  • Implementation and support of Accounts Receivables and Account Payable Module
  • Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration modules.
  • Worked on the Revenue Recognition Process in Oracle AR module.
  • Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
  • Worked on the entire upgrade strategy to upgrade the application footprint from 11.5.10.2 to Release 12.1.1
  • Pricing Business Requirement Study and designed / documented Functional Specification.
  • Identification of Gap & put collaborative effort with the Technical team to address the same through Technical Specification.
  • Flow Testing for SCM Modules (AR, AP, GL, e-Business Tax, Advance Collections) to make sure flow is working without any issues.
  • Providing Post Implementation support
  • Worked for the Category & Mapping data migration to meet the go alive deadline.
  • Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
  • Assisted Business for Business Acceptance Testing and obtain Sign off.

Environment: AR, AP, GL, e-Business Tax, Credit Management, Advance Collections modules

Confidential, Nashville, TN

Oracle Financials Functional Consultant

Responsibilities:

  • Worked on setup configurations including Flex Field Values & Value Sets, OM Order Types & Workflows, Pricelist Shipping/Picking parameters, Release rules, profile options, lookups & module specific shared entities & objects and their integration.
  • Adapt in reviewing and analyzing the 'as-is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in the process.
  • Defined the Approval Hierarchies, Document Security, Streamlined the Receiving process, Setup the Matching Process in Purchasing module
  • Defined the Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue.
  • Worked with end users to document the business processes & functional requirements also providing them with training materials
  • Worked very extensively on understanding the proposed 100% customized business logic of the Business in building the customized solutions for Shipping on OA framework Technology based on the legacy of Oracle application E-business suite 11.5.10. All the above bases business logic was captured in OA Framework code.
  • Coordinated activities with Implementation team on creating test plans & documents, conduct unit testing, correcting bugs and re-testing while meeting project deadlines. Facilitated discussions with end-users / managers to gather functional requirements.
  • Coordinated with client through Concalls and WEBEX sessions to get the requirements and coordinating with the technical team for fixing the issues for proper deliverables to the client.
  • Provided KT sessions to the testing and the technical teams.

Environment: Order Management, AR, GL, Credit Management, Cash Management, INV, me-Procurement, Purchasing modules

Confidential, Detroit, Michigan

Oracle Financials Functional Consultant

Responsibilities:

  • Performed AS IS Analysis for the 11.5.10 setup and Identified GAPs with R 11.0.3
  • Provided detailed understanding to the users on change points and impact of moving to a Multi-Org environment through extended key user sessions
  • Involved in dealing with all the stakeholders on the project to gather requirements, firm up the requirements and then get the signed off by the stakeholders for each functional track.
  • Involved in designing the Project Plan for the individual modules
  • Involved in developing the Process flows for the Quote to Cash and Procure to Report modules.
  • Involved in the Functional Analysis of designing and developing a custom licensing module called e-licensing, which was primary designed to provide license keys for products sold and tie back to Install Base.
  • Purchasing - Worked on the configuration of the Purchasing module including the setups of the Approval hierarchies, Purchasing Options, Setting up Matching, etc.
  • Worked on the complete setup of me-Procurement module including the setups of the Approval Rules using AME, setting up the Approved Supplier Lists, Auto Sourcing, Customized the Requisition import process form me-Procurement to Purchasing.
  • Designed a Streamlined process for Fulfillment flow.
  • Conducted several sessions with key users to analyze business requirements and performed fit-gap analysis to map user requirements using AIM methodology
  • Worked on designing the power point presentations for the business requirements and solutions for the GAPs dat were identified.
  • Worked with Oracle support for Oracle functionality issues by raising Service Requests.
  • Was involved in developing Use Cases for testing of the Quote to Cash business process
  • Was involved in designing the communication plan for any changes dat were made to the system, any changed dat were made to any of the functional processes.
  • Designed and Developed the Test Plan for testing of the System as wells as testing of the entire bolt on modules and custom RICEW components.

Environment: Oracle Applications 11.5.10.2 (AR, AP, GL, AOL), Forms 6i, Reports 6i, Oracle 9i (SQL, PLSQL), TOAD, SQL Loader and HP-UNIX, Discoverer

Confidential, San Diego, CA

Oracle Applications Business Anlayst

Responsibilities:

  • Prototype the business process by mapping against the functionality of the modules in a test database installed as a part of the Oracle Applications installation process.
  • Set up OM Transaction Types, OM Parameters.
  • Set up Inventory Organization for OM related items.
  • Defined time limit for Booking of Order, Scheduling of Order, Closing Order Lines and Order Headers.
  • Set up pricing parameters/list.
  • Inventory On hand availability Checking, Pick Release Rules, and Back Ordering decision.
  • Set up Shipping Parameters/Rules, Containers, and Granting Roles to Users.
  • Document sequencing for Order Numbering.
  • Modification/cancellation of Orders/Order lines.
  • Created MD050 based on RD020 and RD050.
  • Prepared TE020, TE040 based on MD050.
  • Developing test scenarios and testing the code units developed
  • Testing the system for specific scenarios after upgrade to 11.5.9
  • Coordinating with the client for requirement related discussions.

Environment: Oracle Applications 11.5.9(AP, OM, GL, Oracle Workflow 2.6, PL/SQL)

Confidential

Oracle Applications Analyst

Responsibilities:

  • Prepared business requirement documentation by analyzing new business process design, requirements analysis, and solution design using oracle AIM methodology
  • Part of a business transformation project team and assisted the end-users in the functional configuration of Order Management, WIP, BOM and Inventory modules
  • Involved in a feasibility analysis of integrating oracle functionality and legacy system
  • Analyzing the parameters involved in physical inventory and cycle counting, and setup of ABC classes for teams to aid in implementation of counting methodology
  • Analyzed the need for sub inventories, stock locators & setup shipping networks transfer
  • Performed organizational set ups including inventory organizations, item categories, product catalogs, locations, freight carriers, item parameters etc
  • Responsible for defining and setting up complete Order Cycle setups from, order entry in order management to ship confirm in shipping execution module to support business requirements
  • Performed setups for process involving split shipment process, drop shipment process, RMA process, in Order Management.
  • Performed setups for shipping parameters like picking rules, pick slip grouping rules, release sequence rules for Order Management
  • Conducted CRP and Integration testing for related modules
  • Maintain issue tracker and coordinated with the team for debugging
  • Involved with user acceptance testing (UAT) and end user training
  • Prepared and provided comprehensive training materials and practice exercises

Environment: Oracle Applications 11.03/11i (GL, AOL, Sys Admin, Alerts), Oracle 8i(SQL, PLSQL) Forms 6i, Reports 6i, TOAD, SQL Loader and HP-UNIX, Discoverer

Hire Now