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, I-Procurement, Shipping, Inventory, Purchasing modules.
• 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, i-Expense

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis IN

Financials Functional Consultant

Responsibilities:

• As a Functional Consultant implemented teh following modules AR, Credit Management, Advance Collections, AP, GL, e-Business Tax, Sub Ledger Accounting
• Worked on teh Functional mapping of data Conversions & Enhancements for AR, Credit Management, Advance Collections, AP, GL, e-Business Tax, Sub Ledger Accounting modules.
• Worked on teh setups of e-Business Tax module - including teh setups of Tax Rates, Tax Codes, Tax Regimes, Regime to Rate flow - for EMEA and US.
• Worked on teh 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 teh configurations of Credit Management module - defining teh Credit Checklists, Setting up credit limits, assigning collectors, configuring credit check rules etc.
• Worked on Revenue Recognition process in Oracle AR - defining teh 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 teh Revenue distributions to an external system for reporting.
• Worked on teh Dunning Letter Setups in Oracle AR module
• Worked on teh Statement Cycle setups in Oracle AR module
• Worked on teh configuration of teh Advance Collections Module - defining teh advance collection engine, defining teh 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 teh 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 teh 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 teh TEMPeffects of a new Org on teh 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 teh users, testers and Business System Analysts.
• Provided with useful training to teh 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 teh 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 teh setup of Revenue Recognition in AR module.
• Setup of Accounting and Invoicing rules in AR module
• Defined teh Auto Lock Box process in AR module
• Defined teh Auto invoice process in AR module
• Worked on Bookings, Billing and Backlog process
• Worked on teh setups of Oracle e-Business Tax module - defining teh rates, regimes, rate to regime flows, tax rules, exceptions, exemptions, etc.
• Worked on Advance Collections setups - defining teh parameters for collection engine, defined teh delinquency rules, defined collection strategy, dunning plans, processing promise to pay, dispute invoices, etc.
• Worked on teh 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 teh Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module.
• Also, worked on setting up teh 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 teh SOD Document in System Administration.

Confidential, Greenwood Village, CO

Financials Functional Consultant

Responsibilities:

• Preparing Business Requirement Documents (BRD) with teh business rules associated to archive teh daily transactional data across different Operating.
• Preparing business test scripts with teh business rules associated with it to test teh data integrity of archived data.
• Worked on teh entire Order to Cash Flow.
• Performed all teh setups for As a Functional Consultant implemented teh 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 teh setup of Revenue Recognition in AR module.
• Setup of Accounting and Invoicing rules in AR module
• Defined teh Auto Lock Box process in AR module
• Defined teh Auto invoice process in AR module
• Worked on teh setups of teh Scoring Engine in Oracle Advance Collections
• Worked on teh definition of teh scoring strategies in Oracle Advance Collections.
• Implemented TCA - for AR customer master conversions.
• Worked on teh setups of teh Payment Manager in teh AP module.
• Worked on Line Level Matching feature in oracle AP module.
• Setup teh Payment Process Profiles (PPP) and Payment Process Requests in teh Payment Manager in AP Module.
• Worked on teh payment transaction file to be transmitted to teh bank using teh EDI 820 Payment file
• Worked on teh AR/AP netting process in AP module.
• Worked on teh AP Processes of Retainage, Recoupment, etc.
• Worked on teh defining teh transaction types, financial options, tax rules in Oracle AP module
• Worked on teh 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 teh Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module.
• Also, worked on setting up teh 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 teh SOD Document in System Administration modules.
• Worked on teh Revenue Recognition Process in Oracle AR module.
• Worked with teh Business team to baseline teh ‘As Is’ Process and derive ‘To Be’ flow.
• Worked on teh entire upgrade strategy to upgrade teh 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 teh Technical team to address teh 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 teh Category & Mapping data migration to meet teh go alive deadline.
• Jointly worked with teh QA team in formulating teh 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 teh 'as-is' business scenarios, processes and activities, evaluating end user requirements and custom designing solutions and troubleshooting any problems in teh process.
• Defined teh Approval Hierarchies, Document Security, Streamlined teh Receiving process, Setup teh Matching Process in Purchasing module
• Defined teh Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue.
• Worked with end users to document teh business processes & functional requirements also providing them with training materials
• Worked very extensively on understanding teh proposed 100% customized business logic of teh Business in building teh customized solutions for Shipping on OA framework Technology based on teh legacy of Oracle application E-business suite 11.5.10. All teh 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 teh requirements and coordinating with teh technical team for fixing teh issues for proper deliverables to teh client.
• Provided KT sessions to teh testing and teh technical teams.

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

Confidential, Detroit, Michigan

Oracle Financials Functional Consultant

Responsibilities:

• Performed AS IS Analysis for teh 11.5.10 setup and Identified GAPs with R 11.0.3
• Provided detailed understanding to teh users on change points and impact of moving to a Multi-Org environment through extended key user sessions
• Involved in dealing with all teh stakeholders on teh project to gather requirements, firm up teh requirements and tan get teh signed off by teh stakeholders for each functional track.
• Involved in designing teh Project Plan for teh individual modules
• Involved in developing teh Process flows for teh Quote to Cash and Procure to Report modules.
• Involved in teh 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 teh configuration of teh Purchasing module including teh setups of teh Approval hierarchies, Purchasing Options, Setting up Matching, etc.
• Worked on teh complete setup of i-Procurement module including teh setups of teh Approval Rules using AME, setting up teh Approved Supplier Lists, Auto Sourcing, Customized teh Requisition import process form i-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 teh power point presentations for teh business requirements and solutions for teh 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 teh Quote to Cash business process
• Was involved in designing teh communication plan for any changes dat were made to teh system, any changed dat were made to any of teh functional processes.
• Designed and Developed teh Test Plan for testing of teh System as wells as testing of teh 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 teh business process by mapping against teh functionality of teh modules in a test database installed as a part of teh 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 teh code units developed
• Testing teh system for specific scenarios after upgrade to 11.5.9
• Coordinating with teh 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 teh end-users in teh functional configuration of Order Management, WIP, BOM and Inventory modules
• Involved in a feasibility analysis of integrating oracle functionality and legacy system
• Analyzing teh parameters involved in physical inventory and cycle counting, and setup of ABC classes for teams to aid in implementation of counting methodology
• Analyzed teh 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 teh 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