Oracle Financial Functional Analyst

Odaa Pauline

Oracle Financials Functional Consultant

Cell: 813-***-****

E-MAIL: *************@*****.***

PROFESSIONAL SUMMARY

Oracle E-Business Suite Financial Functional Consultant Professional with 9+ years of experience

4 years of specific experience in implementation, configuration, testing and maintenance of Maximo 6x and 7.x

Expertise:

ERP Functional Consulting, Oracle E-Business Suite Release 11i and R12, Financial Modules – General Ledger, Purchasing, Payables, Receivables, Cash Management

Functional experience in configuring and testing of General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets & Purchasing

Full cycle implementation of 2 IBM Maximo Enterprise asset Management Software projects

Extensive experience in completing 3 full cycle implementations of Oracle Financials.

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

●Experienced in conducting Functional Requirement Analysis, Gap Analysis, Production Support, Training Business Users, Testing, and Project Documentation

●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

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

●Excellent Working knowledge with General Ledger, Accounts Receivable, Accounts Payable, and Fixed Assets in the integration point of view.

●Configuring the application based on solution design, performed gap analysis and designed workaround solutions. Excellent knowledge on Functional Analysis and Implementation, Techno/Functional analysis on Interfaces/Legacy conversions, Views, Reports.

●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.

●Experience as a key resource assisting in the definition of systems strategy, gathering and documenting business requirements, leading fit-gap analysis, as-is and to- be business process designs, conference room pilots (CRPs) functional configuration, testing, client user training.

●Knowledgeable in Sarbanes-Oxley (SOX) compliance requirements and measures.

●Expertise in manual testing including Black Box and White Box testing.

●Experienced in working with offshore/remote team.

●Excellent business and interpersonal skills, a fast learner, motivated Team Player with positive attitude, and Goal Oriented

●Strong Team Player having good verbal and written communication skills. From my 15 + years of professional client interaction, I have acquired strong interpersonal and analytical skills.

Technical skills:

Platforms: Windows 95, 98, 2000, XP, Vista, Server 2000, 2003, Linux

Languages: Visual Basic, SQL, C++, HTML and XML

Software: MS-Office, MS-Project, MS- Visio, PeopleSoft, primavera P6,Maximo,Websphere,TOAD

Database: Microsoft SQL Server, MySQL, Oracle RDBMS, MS Access, IBM DB2.

Reporting: BIRT, QBR,Actuate, Brio SQR,Business Objects, Crystal Reports, RXi Report, FSG Reports, Oracle XML Publisher,Oracle Reports.

Test tools: WinRunner 7.5, LoadRunner 6.5, Quick TestPro 9.0. Rational Test Manager, HPQC, Oracle Test Manager, Oracle Load Testing Suite for Oracle Applications.

QA Methodologies: CMM, CMMI, TQM,OUM,AIM

Other: Beyond compare, Bare trail, HermesJMS, uPerform, SPSS

ERP: Maximo Asset Management, Oracle EBS

EDUCATION

Bachelor (BSc) in Health Informatics

Higher Diploma in Information Technology and Management

PROFESSIONAL EXPERIENCE

Rogers Communications Boston MA Jun 2017 – Date

Role: Oracle EBS functional consultant

Description: Upgrade/Re-Implementation of Oracle Applications Financials from 11.5.9i to R12.2.3 (GL, AP, AR, FA & CE) with Customization and Production Support. (Full project cycle)

Responsibilities:

Perform internal analysis and implementation of R12 EBS

Analyzed Business process flows for AR and AP and identify the gaps

Presented the identified gaps and work with business owners/users in the design sessions.

Functional mapping of gaps identified for technical team reference and designing.

Testing business scenarios for processes mapped in Oracle Apps.

Involved in preparation of Conversion Templates, and power point presentation documents for both configuration and process steps with navigations for end users.

Loading accounting codes Through Data Loader and Trail Balance Journal and Assets through ADI.

Prepared documents by following OUM Methodology like RD030, RD011, DS030, TE020, TE050, and AN100 and user manuals.

Providing the suggestions/options of the best way to implement their need in Oracle Applications with the SOX approval

Performed testing for setups configured AP, AR, FA & CE modules

Tested extensively in Revenue Recognition functionality considering accounting and audit requirements

Worked with the technical team for Testing customer interface, transaction conversion from legacy systems and Auto Lockbox interface

Tested system options, Accounting Option, Lookups, Define suppliers, Payment Terms, customers Accounting rules and Receivables transaction source, transaction types

Worked on Vendor sourcing rules, Blanket Purchase Agreements, Purchase Order Release methods in Oracle Purchasing

Creating the Training material documents on various applications in Oracle

Sonus Networks Inc., Boston MA Jun 2015 – May 2017

Role: Oracle Apps functional consultant

Description: Oracle project Roll Out (15 Countries)Oracle Financials R12.2.2 (AP, PO, iProcurement, CM and FAConsultant Oracle Applications production support in Inventory, Purchasing, and Order Management, Account Payables, Account Receivables, in R12 environment.(Full project cycle)

Responsibilities:

Develop project documentation including BR100 and Project Functional Design Documentation (MD50)

Mapped the future state process requirements in GL, AP and AR

Defining the new responsibilities and users as part of the function security and segregation of duties

After configuring the Application completed the setup Documents for all Financial Applications.

Involved in the Data Migration activities to prepare data templates and to collect the data from the key users.

Conducted the Training for GL, AP, AR, CM, FA, P2P Cycles, O2C Cycle.

Configured the system into Multi-Org environment as per the customer business requirements

Conducted CRP1, CRP2 and tested the customized components

Configured the Sub ledger Accounting (SLA) rules to ensure new R12 process functionality was working.

Completed the Configuration for Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Cash Management, and Oracle Assets.

Worked on the R12 New Features like Data Access set, Definition Access Set, Multi Org Access Control (MOAC), AP/AR Netting, Bank Model, Payment Manager, Line Level Cash Application, and Customer Refund Process Automation.

Extensively worked and resolved the issues on OM, Shipping Execution, INV, PO, AP and AR Applications

Monitoring the business users screen to understand the issues and fixing it by guiding them to complete the process effectively

Analyzing the issues and finding out the root cause of the problem to get a permanent fix for the issues in various applications

Willis Towers Watson, PA July 2013-Jun 2015

Role: Oracle EBS Financial functional analyst

Description: Implementation of Oracle Applications General Ledger (GL), Oracle Global intercompany System (GIS), Fixed Assets (FA), Accounts Payables (AP), Accounts Receivables (AR), Order Management (OM) and Cash Management (CM) Modules and Security features including System Administration (SA) activities. All processes of project life cycle are documented as per Oracle Application Implementation Methodology (AIM). (Full project cycle)

Responsibilities:

Gathered and analyzed business requirements including process reengineering. Documented functional requirements pertaining to financial modules and security features.

Carried out Gap Analysis between business requirements and application standard functionalities and bridged them with RICEW components (R-Reports, I-Interfaces, C-Conversions, E-Extensions and W-Workflows).

Prepared functional specifications for Reports, Interfaces, Conversions, Extensions and Workflows (RICEW).

Worked for Project as offshore team member For Financials Implementation

Modules Setup and Configurations have been done in the system to meet the business needs based on the oracle financials application functionality and oracle implementation methodologies.

Worked as an interface between the business super users, onsite consultants and the technical team to develop the custom components in the project.

Set up of Organization structure i.e. Business group, Legal Entities, Operating units and Inventory Organizations in CRP1, CRP2 and in UAT instance.

Closely working with technical person on Data Conversion Strategy.

Involved in testing the converted data into the application.

Defining Invoice Attributes - Payment Terms, Distribution sets, Pay groups, Special calendars for Recurring Invoices, Entering Vendor and Site information

Working on workflow builder 2.6 to modify the PO REAPPROVAL workflow to meet the client requirements

Archer Daniels Midland Company (ADM), Chicago, IL May 2011- July 2013

Role: Project Lead for Maximo/ Oracle Integration

Description: Implementation of Maximo project and ensure smooth integration with Oracle EBS Applications. All processes of project life cycle are documented as per Oracle Application Implementation Methodology (AIM) and waterfall SDLC. (Full project cycle)

Responsibilities:

Configured and Administered Cron tasks and escalations using specific Applications in MAXIMO.

Administered Maximo business objects such as organizations, classification, communication templates, sets, calendars and reports.

Worked on implementation, configuration, testing and maintenance of Maximo 6x and 7.x

Created and modified database objects and attributes using database configuration application.

Prepared application test case documents and user training documents.

Workflow Administration and Workflow Designing,

Created Organization, Domains, SETs, GL Accounts.

Created Asset classifications and specifications hierarchies.

Migrated and converted data from Maximo 6.2 system into test Maximo 6.2 and Oracle 11i

Gathered requirements analyzed RICEW components. Did GL Conversion. Reconciled AR open invoices and Deferred Revenue.

Setup Multi Org, GL, AR and system configuration for CRP1, CRP2, UAT and Production. Trained users in UAT.

Wrote Setup Documents, prepared test scripts and training documents for CRP’s and UAT.

Development and maintenance of the functional design documents for Reports, Interfaces, Conversions, Extensions and Workflows (RICEW).

Wrote functional specifications for RICEW components and coordinate with technical team for development.

Developed Interface functional specifications for GL historical transactions data and AR Invoices

Developed Conversion functional specifications for GL closing balances and transactions for the period.

Worked with teammates in diagnosis and fixing of issues faced in configuration, deployment and production environment.

United States Gypsum (USG). Chicago, IL May 2010 - May 2011

Role: Oracle Functional Consultant

Description: Finance Team member for Oracle R12.1.2 upgrade project from 11.5.9 for modules GL, AR, AP, and E-business Tax including integrated modules

Responsibilities:

Conducted study on current business process, defined future state functional requirements in GL, AP, PO and CM.

Designed solution for Procure to Pay business cycle.

Conformed setups for GL, AP, PO and CM.

Prepared the Test Scripts document to test the various scenarios in GL, AP, CM and PO modules.

Performed QA, unit testing and system integration testing of GL, AP, PO and CM using the test scripts.

Performed the functionality test by running the test scripts for various scenarios of General Ledger, Account Payables, Cash Management and Purchasing.

System test has been done to meet the desired business process of procure to pay cycle.

CRP and user acceptance test (UAT) was carried out for the above modules. Trained the end users resolve problems during UAT.

The project is to implement Oracle 11.5.8 Financials for 2 companies which Quest recently acquired. Played a lead role for implementing GL and AR

Gathered requirements analyzed RICEW components. Did GL Conversion. Reconciled AR open invoices and Deferred Revenue.

Setup Multi Org, GL, AR and system configuration for CRP1, CRP2, UAT and Production. Trained users in UAT.

Wrote Setup Documents, prepared test scripts and training documents for CRP’s and UAT.

Development and maintenance of the functional design documents for Reports, Interfaces, Conversions, Extensions and Workflows (RICEW).

Wrote functional specifications for RICEW components and coordinate with technical team for development.

Developed Interface functional specifications for GL historical transactions data and AR Invoices

Developed Conversion functional specifications for GL closing balances and transactions for the period.

D&H Distributing Inc. Harrisburg, PA June 2009 – July 2010

Role: Oracle EBS Functional Consultant

Description: Involved in Implementation of Oracle EBS .Applications. Worked as an Oracle Super user. Involved in Month end and Year end Closing, GL, FA, OM, PO, AP AR andprovided end user support.

Responsibilities:

Provided ongoing systems support and problem resolution to end-users, including data access, query generation, report generation, etc.

Supported Oracle business users with all business / process related questions anconcerns.

Researched application issues and provided first level support to Oracle end users

Diagnosed and fixed problems with Oracle Applications configurations and setups.

Troubleshoot application problems

Raised Service Requests (SRs) and follow up with Oracle support team for resolution

Maintained historical records of problems solved to build a knowledge base for future issues.

Supported new and on-going development efforts on all Oracle modules.

Automated business user functions and processes where applicable.

Liaison with technical support team on behalf of end users

Available for on call support during the critical system-processing period (i.e., month-end and year-end closing, and any Oracle related severity one issues).

Worked with Oracle users to develop procedures for regular system processing and report generation; includes determining which processes need to be run and developing a schedule for ongoing processing.

Helped maintain systems' procedures manual (work instructions).

Assisted in the development and implementation of training content to End Users

Underwriters Lab, Northbrook,IL May 2007-May 2009

Role: Oracle EBS Financial functional analyst

Description: Providing Post Implementation Support for Oracle financial modules (GL, FA, AP, AR, CM and PO)

Responsibilities

Providing Post Production Support for GL, FA, AP, PO and INV

Diagnosed and fixed problems with Oracle Applications configurations and setups.

Analyzed and resolved post-production issues

Raised Service Requests (SRs) and follow up with Oracle support team for resolution

Addressed operational problems, concerns and questions raised by business users

Trained end users in using the application in efficient way

References Upon Request

Contact this candidate