Oracle Financial Functional Analyst

Rose Mina

Oracle Financials Functional Consultant

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

PROFESSIONAL SUMMARY

8years of expertise in functional aspectsof Oracle Applications which include Implementation, Upgradation projects, and Post Production Support in both 11i and R12 versions. Worked extensively on various models including General Ledger (GL), Accounts Payable (AP) Payments, Accounts Receivables (AR),and Fixed Assets (FA).

Strong experience in Order to Cash (O2C), Procure to Pay (P2P) and Acquire to Retire (A2R) cycles.

Involved in documentation of Future Business(BP-80), present business requirements (RD-20), Conversion(CV-40), and Function extension design document (MD-50), Test Scripts (TE-40) and System Set Up document (BR-100) as per AIM Methodology.

Participated in Requirement gathering, current business process analysis, designing of business process, system configuration and system testing in various cycles.

Experience in performing User Acceptance Test (UAT) and training for the end user on business process and procedures based on Financials Modules.

Experience in supporting/enhancing the Oracle E-Business Suite, Release 11i for Oracle Financials.

A team player with exceptional good organizational, analytical, training, trouble shooting, functional and interpersonal communication skill, a key team player.

Extensive knowledge on FSGreports configurations and experience on change management tools such as STAT quest.

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

11i (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,Microsoft Office, MS Visio, MS Project, MS SharePoint

Education: Bachelor of Business Administration, Finance

Client: ParaxelInternational, Waltham, MA Feb2017- Till Now

Project: Oracle R12 Implementation

Role: Oracle Financials Functional Analyst

Paraxel International is a multinational, life sciences consulting firm and contract research organization. The project is an Oracle Apps implementation to update their business process and to streamline their operations.

Responsibilities:

Worked on Oracle EBS where modules of implementation include General Ledger, Account Payables and Account Receivables.

Setting up of Chart of Accounts, Cross Validation Rules, setting up of Security Rules in GL and Assigning to different responsibilities.

Creation of users,responsibilities, menu, request groups, Key Descriptive Flexfield segments, Values, Security Rules, Cross validation rules, Categories and Profile Options.

Creating Mass Allocation by preparing the formula for mass allocations and generating the mass allocation journals.

Created New FSG reports using multi-currency features including foreign currencies for multi org structures.

Performed general Payables setups like Financial Options, Payables Options, Banks & Bank Accounts, Supplier, Supplier Sites, Payment Terms and Profile Options and Payment setups like Payment Format, Payment Process Profile and Internal Bank Payable Documents.

Involved in the design and development of XML reports.

Gathering Business requirements from the Data integration team and Business users.

Preparation of Setup documents (BR-100).

Providing training for local core users and help develop training materials for end users where required.

Client: Ascena Retail, Mahwah, NJ Feb 2016-Jan 2017

Project: Oracle R12 Implementation

Role: Oracle Financials Functional Analyst

Worked with Ascena Retail Group Inc. for their implementation of Oracle R12.1.3. Ascena Retail is a leading retailer in women’s clothing, shoes and accessories under various brand names with stores throughout the US, Canada and Puerto Rico. Involved in all stages of project implementation to include Requirements Gathering, Analysis, Design and Go-Live phases.

Responsibilities

As a Functional Consultant reviewed and analyzed current business processes for Oracle Receivables, Oracle Payables, Fixed Assets, and General Ledger.

Worked on Account Payables invoices and Account Payables payment setups.

Performed Account payables setups which included creating vendors, payment terms and bank accounts.

Designed and developed various FSG reports such as Income Statement by summary/detail, Income Statement Actual, Budget and Forecast profit/loss summary for reporting.

Conduct Demos of oracle Fixed Assets to introduce functionality of system.

Performed general Receivables setup like System Options, Payment Terms, Transaction Types, Receipt Sources, Receipt Classes, Payment Methods, Auto-Accounting, Approval Limits, Customers, Aging Buckets and Profile Options.

Performed General Ledger setups such as Accounting setup manager, Rollup group, secondary ledger, Mass Allocation and Consolidation.

Requirement gathering for AS-IS and TO-BE process.

Prioritize the tasks for the team based on feedback from the client meetings, number of defects and project progress.

Worked closely with the users in creating a new bank account and setting up the new receipt method for Mobile shops.

Supported Users to resolve the critical issues for closing the periods (AR, AP)

Client: AT&T, Ramsey, NJ Sep 2015 – Jan 2016

Role: Oracle Financials Functional Consultant

Requirement Gathering and document AS-IS and TO-BE process.

Involved in Designing the configuration documents BR100's for (GL and AR Modules).

Assisting the business users in CRP3 testing and UAT.

Was involved in the complete set up of Oracle Receivable, the important aspects being: Defining System Options, Transaction Types, Payment Terms, Invoicing and Accounting Rules, Auto Accounting, Adjustment Types.

Set up System option, Financial option, Payment Terms and Distribution Sets, profile options and System options.

Set up Vendors, Banks, Transactions Types and Receipts Classes, dunning letters, Receivables options, Auto Invoices and remittance.

Setting up of Chart of Accounts, Cross Validation Rules, Setting-up of Security Rules in GL and Assigning to different responsibilities.

Setup of Items, Employees, Customers, Suppliers.

Client: Xylem, Seneca Falls, NY Sep 2014 – Aug2015

Project: Implementation of Oracle R12.1.3

Role: Oracle Financials Functional Analyst

Worked with Xylem Inc. for implementation of Oracle R12.1.3. Xylem is a global leading provider of technologies and equipment solutions for water. The company has operations in North America, Europe, Middle East and East Asia. Key responsibilities included setting AP module for different Operating Units and creating test documents for AP, FA and GL.

Responsibilities:

Worked with the client team in understanding the business processes to prepare the business requirements definition document (BRDs) for the financial modules.

Mapped the future state process requirements.

Setup the AP Module for different Operating Units.

Defined different types of invoices: standard, debit memo, credit memo, recurring invoices and prepayment invoices.

Defined suppliers, Payment Terms, customers Accounting rules and Receivables transaction source & types.

Performed and documented systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality.

Created test documents, performed unit, End to End and User Acceptance Tests for AP, FA, GL and PO.

Defined Rules and Responsibilities per Xylem super users’ guideline.

Involved in post-production troubleshooting, bug fixes,and working with DI and Oracle Support for escalating issues and finding resolutions.

Client: HACO Industries December 2012-August 2014

Project: Oracle Re-implementation

Role: Oracle Financials Consultant

HACO Industries Kenya Ltd., is a FMCG company which has its business in Kenya and EAST AFRICAN region. HACO had implemented Oracle Applications with OPM manufacturing modules for productions and was not able to implement and run the system quite comfortably. I was involved in the process of re-implementation of various modules.

Responsibilities

• Worked on implementation of General Ledger, Fixed Assets designing key Flex fields • Also documented the entire Gaps and its Resolution/Recommendation.

• Participated in System analysis and gathered requirements.

• Defining additional information on each assets and Functional Design MD050 for custom reporting based on the attributes

• Used AIM methodology for project documentation.

• Worked closely with technical team and given inputs for integration testing.

• Functional/Integration Testing/System Testing and User Acceptance Testing.

• Analyzed 3rd Party applications which are integrating with oracle apps and provided solutions to the integration points.

• Business study and Prepared Process Analysis Questionnaire.

• Worked on implementing AIM methodology, This includes functional specifications (MD50) and testing (TE40)

Client: Kenol/Kobil December 2010- November 2012

Role: Oracle Financials Analyst

Kenol/Kobil is a largest petroleum-based products manufacturing and trading company in Kenya and having its presence in EAST AFRICAN region. Kenol/Kobil sells petroleum, lubricant and associated fuel products, at wholesale and retail level.

Gather and document functional requirements for Configuration of GL, AP and Cash Management Modules.

Conducting Gap analysis.

PreparingBR-30, BR-100, MD-100, documents.

Developing solution design.

Testing (Unit testing, System testing, Integration Testing).

Training manuals preparation.

Facilitate and participate in functional design meetings with key process team members and Business Users.

Worked on AP: Supplier, Inter-company Suppliers, setup: invoice, payment, accounting, tax, options, payment methods: wire transfer, electronic fund transfer (EFT), Recurring Invoices, Payment Process Profiles, Payment Templates, Payment Formats, Creating Folders, Setting Up Batch Invoices Profile etc.

Worked on Cash Management: System Parameters, Banks, Bank Transaction Codes and System Profiles.

Worked and assisted users on period end close process for Accounts Payable Module during UAT.

Conducted Status meetings with onsite and offshore team at the different stages of implementation (CRP3, UAT, Post production support process).

Contact this candidate