Oracle Financial Functional Analyst

BASIL ODIRA

Oracle Financials Functional Consultant

Phone: 813-***-**** *****.********@*****.***

SUMMARY:

Over 9 years of IT experience in Requirement Analysis, Implementation, Development, Testing & Customization of Oracle Applications R12, 11.5.10 in the modules of General Ledger, Account Receivables, Accounts Payables, Order Management, INV and Oracle Purchasing.

●Extensive experience in completing several full cycle implementations of Oracle Financials, which include Accounts Payable, Accounts Receivables, Fixed Assets, Claims Management, Vendor Rebate Management

●Involved in Implementation, Re-Implementation, Upgrade and Support of Oracle Financials Modules

●Experienced in Order to Cash (O2C), Procure to Pay (P2P) business flows

●Good working expertise in designing functional documents (BP080, MD50, CV40, TE040) using AIM Methodologies

●Strong understanding of party centric model in TCA (Trade Community Architecture)

●Strong Understanding of Integration of MarkView & KTM with Oracle EBS

●Experience in designing and testing of complex customizations in Finance Modules such as Custom Rebate Holds, Bulk Invoice upload, Extracting 1099 data for ‘1099 pro’ an external system, OAF personalization on Supplier screen, Invoice upload through ‘Web ADI’

●Tested data flows and scripts against sample data and real data.

●Expertise in Functional Testing, System Testing, Integration testing, Performance Testing

●Gathering, Understanding and analyzing user requirements, business process, and business scenarios.

●Designed the Test Plan, Test Cases and Test Scripts based on the Test Requirements.

●Logged defects in the defect-tracking tool HPQC, tested and maintained trailing history of the defects found in the ETL process.

●Experience in System Administration tasks related to Menus/Functions, Responsibilities and Users.

●Good experienced in preparing Requirement Analysis Documentation, Training Scripts, Functional Documentation, User Training and Customization Documents.

●Strong Exposure in preparation of high-level functional design documents for custom application development, Conversions, Interfaces & Reports.

●Worked on Onsite and Offshore model projects and coordinating offshore team.

●Adaptability to any new business environment. Excellent team player and excellent communication and inter-personal skills.

●Experienced in developing functional requirements to support end user and business needs, develop and conduct training sessions, and develop and execute system test plans and process.

●Confident and resourceful with a willingness to learn new concepts and apply them to yield successful results.

●Implemented Oracle Applications in all aspects of Software Development Life Cycle i.e. from executing CRP sessions, business requirement gap analysis, solution requirement gathering for custom interfaces, reports and conversions, QA Testing, Integration testing, user acceptance sign off, writing and reviewing QA, UAT test scripts and training documentation.

TECHNICAL SKILLS

ERP:

Oracle Applications R12, 11i

Modules:

GL,AR, AP, FA, Cash Management, SLA, E-BTAX

Tools:

PL/SQL, TOAD,Web (ADI), Financial Statement Generator (FSG), Discoverer, AME, Data Load, Visio, Excel, Share Point.

PROFFESSIONAL EXPERIENCE

PPG Industries, Harrisburg, PA October 2015 – To Present

Project: Implementation of Release 12.1.3 of Oracle e-business suite (AR, Oracle Project Accounting, AP, GL, Sub Ledger Accounting, e-Business Tax, OM, INV and PO)

Role: Oracle Financials Functional Analyst

Responsibilities :

As a Functional consultant implemented financial modules: AR, AP, Oracle Project Foundation, Project Billing, Project Costing, GL, e-Business Tax, FA and CE

Performed Requirement and Gap analysis. Configurations and Setups AR, Treasury, AP, GL, Project Foundation, Project Billing, Project Costing, e-Business Tax, FA and CE

Configured Taxation for US Sales Tax, Canadian GST and VAT Tax in EMEA in e-Business Tax module. Involved in the configuration of Tax Content Service, Tax Determination Services, Tax Users, Look Up Codes, TCA Geography Hierarchy, TCA Classifications for Tax, Tax Classification Codes, Tax Accounts and Tax Accounting Information.

Worked on the data conversion from 11i to Release 12 for all financial 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.

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 Cash Management and Account Payable Module

Provide support/enhancements for the existing Oracle and Discoverer Reports (across AP, FA, CM, and AR) and create new ones based on business requirements.

Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex Field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options

Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Hass Consulting, West Chester PA, August 2012 – September,2015

Role: Senior Oracle Financial Consultant

Modules used (Oracle 12.1.2): AP, PO, AR, Inventory, iProcurement, Purchasing, Projects, Payments, PRISM.

Responsibilities:

Lead Functional consultant responsible for R12 implementation of Procure to pay prototype for International Financial Services Corporation. This implementation included Purchasing, Payables and procurement module deployment, documentation and Testing Script scenarios.

Lead Functional Consultant responsible for implementation of Order Management, Inventory and Accounts receivable for large Pharmaceutical Distributor. The primary project focus was to implement Order Management in conjunction with the legacy system to expedite billing. All of the data was mapped and imported through staging tables and standard Oracle API’s.

Functional consulting role responsible for problem resolution a Telecommunication company preparing to issue an Initial Public Offering. Assisted external Accounting Firm with reconciliations, development of financial statements using Oracle’s Financial Statement Generator. Also developed based on the Applications previously implemented developed appropriate internal controls and procedures.

Functional Consultant responsible for onsite Functional support and Issue Resolution for large multi-national printer manufacturer. The primary focus of the three month engagement was functioning as an internal liaison for end user questions regarding Accounts Receivable, Invoicing and Order Management for each international location.

Functional Consultant responsible for Procure to Pay R12re-implementation. Lead role for re-implementing Purchasing, Inventory and Cost Management. It was an 11 months long project which included two CRPs for which I designed the test scripts and end user Training material.

Lead Functional consultant for a successful implementation of a R12 prototype for large Financial Services within the Procure to pay functions. This implementation included I- procurement as well as Payables, Inventory and Purchasing.

Harsco Corporation, Camp Hill, PA June, 2011 – July 2012

Project: Oracle Applications Release 12.1.3 Upgrade from version 11.5.10.2

Role: Oracle R12 Upgrade Analyst

Environment: Oracle Applications Release 12.1.3 (General Ledger, Account Receivables, Account Payables, Order Management, Credit Management, E-business Tax, Procurement, Inventory, PO, Fixed Assets), PL/SQL, MS Visio

Responsibilities:

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.

Completed Multi-Org configuration by creating a new Organization Structure by creating new Business Group, Legal Entity, Set of Books and Operating Unit.

Worked on the Configurations of AP, GL, AR, Cash Management, I-Expense, I-Receivables.

Conducted Regression testing to examine the effects of a new Org on the previous Org.

Successfully provided Technical and Functional support to the users, testers and Business System Analysts.

Communicated with business users about the implementation and requirement gathering questionnaire, explaining oracle’s functionality extension from R12 vs. 11.5.10.2 within oracle financials

AP- Defined invoicing information including payment terms, invoicing and accounting rules, territories and invoice sources. Defined accounting options, methods of accounting, realized gain / loss account, unallocated revenue account, auto cash rule set.

Setup Oracle Payables includes Payment Terms, Banks and Bank Accounts, Define Quick codes, Define Financial Options and Payable Options and Defined Corporate books, fixed assets categories, assets keys etc.

AR - Defined receivable activities for misc. receipts, finance charges, bank charges, defining distribution sets. Worked on receipt class, specifying creation method, payment method, defining collectors and aging buckets. Created customer profile classes, attaching payment terms, collectors, matching receipts, statement cycle to profile classes.

Set up transaction types, invoices, guarantee, deposit, and credit memos, debit memos.

Customized collector’s portal to add additional transactions and customer information in Advanced Collections.

Preparing of all the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.

Worked in the process of unit testing, System Integration Testing (SIT), performance testing, regression testing.

Documented Functional Design, Applications Setups & User Manuals Provided with useful training to the users in GL, AR, OM, INV and PO Modules.

Owens and Minor, (Washington, DC ) March 2009 – May 2011

Project: Upgrade/Re-Implementation of Oracle Applications Financials from 11i to R12.1.3(GL, AP, AR, FA & CE)

Role: Oracle Financial Functional Consultant

Responsibilities:

●Implemented R12 Financial Modules (GL, AP, AR, FA & CE), Acquire to Retire (A2R), Procure to Pay (P2P), iExpenses and integration of Account Receivable module with legacy billing system.

●Implemented iSupplier and iProcurement as per new solution design including punchouts and configured AME for requisition approvals.

●Interact with the Business and understand the requirements for their various business flows and arrive at the configuration that would be needed like Order Types, Defaulting Rules, Holds, System Parameters, Processing Constraints, etc.

●Prepared BR100 document for the setups done like Custom Holds definition, new Order Types, Lookups, Profile Options, etc.

●Performed a Proof of Concept to all the business users on the various business scenarios like IR/ISO, Inter Company, Drop Ship and Back-to-back order cycles

●Identified gaps and addressed them actively in collaboration with the project team through documentation (BR010), Oracle Tutor and MS Office.

●Provided Support the ERP initiatives in design, development and implementation of plans to translate enterprise information system objectives into functional business systems.

●Prepared solution design/To-Be document as per client requirement and best practices embedded in the application using Oracle Tutor tool and AIMs Methodology.

●Conducted User Acceptance training (UAT) sessions, prepared UAT scripts (TE040) and obtained user acceptance after providing feasible solutions to issues raised within UAT sessions.

●Configured of Oracle application setup of respective modules and prepared BR-100 setup document.

●Conducted training sessions for users and prepared guides on User Productivity Kit.

●Reviewed the existing reports and collected requirements to develop additional custom reports.

●Executed SQL queries on PL/SQL server tables to view successful transactions of data and for validating data.

●Responsible for Data gathering on given templates and upload activity on systems.

●Providing post implementation support to users.

●Documents all business processes, needs, flows and diagrams

Contact this candidate