Oracle Financial Functional Consultant

PROFESSIONAL SUMMARY

*+yearsof experience as an Oracle Functional Consultant with multiple EBS projects in Oracle Implementation, Upgradation projects, and Post Production Support in both 11i and R12 versions.

Expertise in core modules setups and functionalities: General Ledger (GL), Payables (AP), Receivables (AR), Cash Management (CE), Assets (FA), System Admin

Configured and implemented applications as per the business requirement and best practices in the industry.

Knowledge of Procure to Pay (P2P), Order to Cash (O2C), Acquire to Retire (A2R) business cycles and cross functional integration

Well versed with the integration and architecture of Multi-Org Access Control (MOAC), Financial Statement Generator (FSG), Sub-ledger accounting (SLA) and Web ADI

Experienced in GAP, Fit-Gap analysis and solution designing to the RICE components.

Extensively worked on AIM (Application Implementation Methodology) documentation including RD.020, BP.080, BR.100, MD.050, TE.040 and CV.040 including preparing documentation for Change Management process with Impact analysis from the function perspective.

Developed test cases, test plans and testing process and conduct core team and end user training.

Experience in User Training, preparation of User Manuals and Oracle UPK (User Productivity Kit)

Interaction with Oracle support to resolve application issues through SR/TAR

Strong problem solving and analytical skills, fluentin written and verbal communication, great presentation skills, a team player and very comfortable interacting with all levels of business management.

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, iExpenses

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, Oracle User Productivity Kit (UPK),

EDUCATION

MBA (Masters of Business Administration)

Starkey Hearing Technologies, Eden Prairie, MN April 2017 – Till Date

Oracle Functional Analyst

Responsibilities:

Founded in 1964, Starkey Hearing Technologiesdevelops, manufactures, and distributes hearing aids. The company offers wireless hearing and digital hearing aids, including made for iPhone, invisible products, receiver-in-canal, completely-in-canal, behind-the-ear, in-the-canal, tinnitus, and hearing amplifiers. It sells its products through hearing professionals, including audiologists, hearing aid specialists, and ENT doctors worldwide.

Responsibilities:

Designed test cases, test scenarios and test scripts based on the business requirement document (BRD)

Understood the business process and thereby prepared the test scenarios

Executed test scripts in QA and Development environments and made sure the proper working of the functionality

Defined users, employees and Resource Groups.

Assigned employees to the users and to respective resource groups defined for different territories and for third party organizations.

Assigned Collections Agent and Sales Representative member role to the resources defined.

Thoroughly tested the functionality in accordance to the business requirement.

Created defects in Quality Center and worked with the developer to resolve the issues.

Worked with key business users to train them on the different functionalities during the UAT.

Reviewed the existing business processes to assess its fitment with respect to the functionality provided by the Applications

Followed up with the business for approval of the resolved issues

Involved in creating and follow up on Service Request (SR) with Oracle support

Provided status updates to PMO and follow up with pending business input or issue resolutions as part of status meeting

Participated in daily defect meeting and discussed the defects found and follow up on resolving the same.

Cumberland Farms, Marlborough, MA Aug 2015 – Mar 2017

Oracle Financials Functional Analyst

Founded in 1939, Cumberland Farms is a regional chain of convenience stores based in Westborough, Massachusetts, operating primarily in New York, New England and Florida.Cumberland Farms operates roughly 600 retail stores, gas stations, and a support system including petroleum and grocery distribution operations in 11 states, including Connecticut, Florida, Massachusetts, Maine, New Hampshire, New York, Rhode Island, and Vermont.

Responsibilities:

•Studying the requirements, performing risk analysis and mapping the business processes.

•Analyze the gaps and conduct client interviews to complete the business process analysis.

•Prepare the business requirements documents, performed Gap analysis and recommend the necessary customizations.

•Configuring the modules, designing reports and add-ons and coordinating with the technical team to monitor development and implementation progress.

•Responsible for the documentation (BR.030 -Business Requirements Mapping, BR.100 -Application Setup)

•Responsible for solving technical and functional issues related to GL, AP, AR, FA modules.

•Raise service request with Oracle technical support and coordinate in speedy resolution of high prioritize issues.

•Provide functional impact analysis based on the nature of the issue and coordinate with Business users for manual work around solutions wherever possible.

•Coordinate onsite and offshore technical support team on proposed new custom objects developments, testing, documentation, and migration to production instance.

•Develop approval rules based on invoice amount for the following transaction type Payables Invoice Approval using Oracle Approval Management (AME) and configured action types, actions and set up the profile option to work for Payables only and the required setup through Payables Options form.

•Created organizations, inventory items, catalog RFQ, got approval from supplier in Procure to Pay (P2P) cycle and customized the Purchase requisition and auto creation of a standard purchase order based on a quote and generated receipt.

•Designed, tested and delivered custom reports in GL: Journal Batch Summary Report, Account Analysis Report and AP: Invoice on Hold Report, Supplier Paid Invoice History Report.

•Identify the patches that need to be applied to prepare the Release 12.1.3 environment for implementing Oracle mobile expenses.

•Involved in Functional, Regression and UAT Testing.

•Performed extensive defect fixing and support during the client pre-production testing phase, identifying issues and tracking them through HP quality center.

•Provided Period Close Support for all the financial modules.

•Conduct numerous business meetings to understand and analyze the issues.

•Designing of user-manuals for the modules and training the end users.

Cigna, PA Jan 2013 – July 2015

Role: Oracle Apps Functional Consultant

Founded in 1792, Cigna is a health services organization. Its insurance subsidiaries are major providers of medical, dental, disability, life and accident insurance and related products and services, the majority of which are offered through employers and other groups (e.g. governmental and non-governmental organizations, unions and associations).

Responsibilities:

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

•Offered industry best practices and assisted the client with the road map definition

•Coordinated the effort for the Monthly Releases (Release Management).

•Coordinated with the team for the Monthly Release Regression testing

•Worked on the Root cause for the incorrect accounting for Refunds (No accounted amount is being populated in ar_distributions table for some refunds.)

•Involved in data cleanup for the year end closing (Remittance Account, Cash clearing Account, Prepayment Account, Revenue Account)

•Prepared issues list, Risk plan, change request forms and regular client status reports.

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

•Worked on clearing the errors from the AR interface tables

•Worked on Functional Specs(Additional Requirements from Users )

•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)

•Worked on data fixes for the month End activities (Deleting Orphan Records, Refund Accounting)

•Worked on SEV 1 SR’s for critical Production Issues

•Worked closely with Banks, Bank Accounts for internal purpose and Payment Formats for Manual Check and Electronic Fund Transfer (EFT) in single and multiple currencies.

•Involved In Accounts Reconciliation.

ACT, Iowa City, IA Feb 2012 – Feb 2013

Oracle Financials Functional Analyst - GL, AP, AR and P2P

Founded in 1959, ACT is an independent, not-for-profit organization that provides assessment, research, information, and program management services in the broad areas of education and workforce development. Worked on enhancement project with sole responsibility of P2P and GL team. Involved in project from CRP2 through to GO-live and Post Production Support.

Responsibilities:

Provide complete business to-be processes for Intercompany transactions, intercompany funding process, month-end period close

Conducted UAT and successful cut-over for Go-Live

Train the business users on Global Translations, Revaluations and Consolidation of Multiple Ledgers

Writing TE.040 Test Scripts for Functional Testing of GL, AP, AR and developing Guided Navigations

Developing Training Material for AP, AR modules

Conducted end user training sessions and User manuals

Post implementation support and maintenance – performed successful three month end and period close activities in the newly implemented modules

Design and Configure Financial Statements Using FSG

Maintain issue tracker using Bugzilla and issue resolution

Define new responsibilities, menus, request groups, form personalization

Provided functional design documents for custom Reports and Personalization. Worked with technical team for development of the same

Conduct successful month-end process after Go-Live

Assisted in Secondary ledgers implementation for 10 countries, including 10 Chart of accounts implementation

Assisted in Transition of Oracle AR structure from single-org to multi-org. Part of setup of 21 new operating units in Receivables module

Coordinated with the Business Team for month end close process.

Use of HP Quality Center for UAT, functional testing and issue resolution. Prepared test documents, test scripts (functional, unit and regression testing)

Conduct business meeting whenever required based on issues and new functional requirements

Prepare documentation for change management process along with impact analysis on the proposed solution

Create and follow up on Service Request (SR) with Oracle support

Earned business appreciation for clear and lucid Super User Training Session, Org readiness training and cut-over procedure

Follow up with Oracle Technical Support and conducted OWC for quick resolution of high prorated open issues

Client: Confidential, Solon, OH July 2010 to Jan 2012

Role: Oracle Applications - Functional Consultant

Confidential designs, develops, manufactures and markets complex electronic instruments and systems geared to the specialized needs of electronics manufacturers for high-performance production testing, process monitoring, product development and research. The Company has approximately 500 products used to source, measure, connect, control or communicate direct current (DC), radio frequency (RF) or optical signals. Product offerings include integrated systems solutions, along with instruments and personal computer (PC) plug-in boards that can be used as system components or stand-alone solutions. The Company's customers are engineers, technicians and scientists in manufacturing, product development and research functions.

Responsibilities:

•Identifying the functional specs, preparing the documentation setups and maintaining Business Requirement Documents, Setup Documents (BR100) and other design documents as MD050

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

•Troubleshooting the production issues on various applications (Work in Progress, Bill of Materials, Purchasing, Inventory, Material Planning, etc.), replicating the issues in TEST environment, and testing the fix prior to apply in Production instance.

•Extensively worked on preparing test scenarios, test scripts on different applications to help the users for better understanding the application

•Troubleshooting and fixing the issues on Oracle Standard Costing setups - Copy Item Costs, Month end, Quarter end, Year-end processes

•Troubleshooting and fixing the issues in Order management application -Tax code, Customer credit check, Backordering, Return Material Authorization issues

•Created Oracle service requests and fixed the bugs in Oracle Work in Progress application with the help of Oracle support. Tested the fix in TEST instance prior to apply in other instances.

•Trained the super users by providing documents using VISIO flow diagrams for better understanding.

•Extensively worked on Extra compliance screening functionality with the integration of ITM (International Trade Management) Adapters and OTM (Oracle Transportation Management) application

•Prepared the functional design documents to explain the functionality of the custom concurrent programs in Oracle Costing application by analyzing the PL/SQL programs

•Extensively worked on troubleshooting, fixing the issues on Internal requisition, Approved Supplier list, Request for Quotes in Oracle Purchasing

•Troubleshooting and fixing the PO Approval issues, Stuck Purchase Orders from the Workflow utilizing the standard scripts from Oracle

•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

•Creating Inter-org transfer setups for Inventory application in Oracle R12

•Troubleshooting the order management, invoices, intercompany, WIP transactions, etc. issues using SQL statements in Oracle

•Preparing training and knowledge sharing materials on Costing, Item Revisions, View Potential Shortages for the item using Microsoft PowerPoint

•Training the super users by giving demonstrations on various process flows in oracle applications and helping them to understand the process in a better way

•Preparing business requirement, functional design documents and working with the development team to build the custom reports in various applications in Oracle, testing the report and migrating it to the other instances

•Extensively worked with Oracle Metalink on a few SRs (TARs) to fix the issues in Oracle Supply chain management, Financials, Manufacturing areas

•Troubleshooting the issues on Service Contract (on returns, exchanges, repairs) application and providing the fix, solution to resolve the issues

•Troubleshooting the issues on Telesales, CRM applications.

•Gathering the requirement details from the super user and enhancing the Oracle custom report (in PL/SQL) in Bill of Material (BOM) application

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

Client: Clopay Corporation - Baltimore, MD Mar 09- June 10

Role: Oracle EBS Financial Functional Consultant

Clopay Building Products Company is the nation's largest residential garage door manufacturer. It is also the preferred manufacturer and supplier of commercial overhead sectional doors among architects, specifiers and building professionals. Core strategy of creating successful partnerships with dealer and retail customers is driving favorable performance throughout the company.

Responsibilities:

Interaction and discussing AS IS business processes and organization structure with SME

Gathering Requirements by Conducting JAD Sessions

GAP Analysis and Mapping Business Requirements

Configuring/Updating Functional Setups of GL, AP, AR, PO and OM modules

Develop BR100 Application setup documents for GL, AP, AR, PO and OM

Develop Unit (TE.020) and System Integration Test Scripts (TE.050)

Perform Conference Room Pilot (CRP) and User Acceptance Testing (UAT)

Developing GL, AP, PO, AR and OM Training Guides using UPK

Perform Train-the-Trainer and End User Training on Financials Modules

Develop/Update Discoverer Reports for Month End Reports

Support Business Users in Month End Close Process

Consolidations of Ledgers for Financials Reports

Post Go-Live Production Support and Resolving issues during Production

Create and follow up Service Requests from Oracle

Contact this candidate