Oracle Financial Functional Consultant

PROFESSIONAL SUMMARY

●* years expertise in Functional aspects of Oracle Applications 11i/R12 Financials modules which includes General Ledger (GL), Account Payables (AP), Account Receivables (AR), Cash Management (CE), Fixed Assets (FA), System Administrator (Sys Admin), Purchasing (PO) and E-Business Tax (E-B. Tax).

●As a Functional Consultant and an Oracle Application Expert, have rich experience in Requirements Gathering, GAP Analysis, Business Process Re-Engineering, Functional Design, Modeling Business Structures, Modeling Tax Structures, Configuration, Testing, User Training, and create User Manuals.

●Expertise in Financial modules with strong experience in Order to Cash (O2C), Procure to Pay (P2P), Acquire to Retire (A2R) including Record to Report (R2R) cycles.

●Well versed with R12 SLA (Sub ledger Accounting), MOAC (Multi-Org Access Control), COA (Chart of Accounts) and Secondary Ledger and Reporting Currency Ledger.

●Experience in requirement gathering and mapping business requirements to Application features.

●Experience in implementing Oracle E-Business Tax (E-B.Tax) module at various configuration levels such as Global Configuration Level and at Operating unit level based on business requirement.

●Worked on request group, users, menus, flex fields configurations, responsibility creations required for customization through System Administrator.

●Good exposure and experience in the preparation of Application Implementation Methodology (AIM) documents such as RD020, BP040, BR30, BP080, BR100, MD050 and TE040

●Extensive knowledge and expertise of business process flows in Sub-Ledger Accounting (SLA).

●Conduct CRP’s, provide wide range of functional training to multiple large business user groups and co-ordinate UAT sessions.

●Hands on experience in troubleshooting Production Issues in various modules.

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

●Expertise in coordinate large business user group and offshore team. Coordinate Offshore Team for timely deliverables with respect to development of RICE components and Data Conversion and Data Migration strategy etc.,

●Coordinate Oracle Technical Support for quick resolution of high prioritized issues.

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,

EB-Tax, i Expenses

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,

EDUCATION

Bachelor of science

Associate in applied science

Diploma in marketing

Client: Electronic Arts, SFOAug 2016 – 'Till Date

Role: Oracle Apps Financial Functional consultant

Responsibilities:

●As a Functional Consultant reviewed and analyzed current business processes for Oracle Receivables, Oracle Payable’ s, Fixed Assets, General Ledger, SLA, Cash Management.

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

●Coordinated the effort for the Monthly Releases (Release Management) with EADP- Fusion - ERP

●Coordinated with the team for the Monthly Release Regression testing.

●Worked Closely with business for Conducting UAT for Expansion of Cash Card Providers (ePay, Incomm, Blackhawk) to different European Countries.

●Worked closely with the Vendors in Re -designing the Remittance file format.

●Involved in gathering requirements for New Payment methods where Electronic Gaming Expanded.

●Worked closely with the business users on Finance Month End & Year-End close Issues (AP, AR, GL, FA).

●Involved in technical discussions for migrating the code and validated the code by testing in Test and QA before moving the PPM Packages to Production.

●Worked Closely with offshore team for Testing and Development work.

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

Client: Cigna, PA JAN2015–AUG 2016

Role: Oracle Apps Functional consultant

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

Responsibilities:

●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_distrubtions table for some refunds.)

●Worked closely with the business on Quota Allocation, Claim Research, Claim Settlement.

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

●Involved in technical discussions for migrating the code and validated the code by testing in Test and QA before moving the PPM Packages to Production

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

Client: Amway Ada, MINOV 2012- DEC 2014

Role: Oracle Finance Functional Lead

As a lead I worked closely with the business users on Finance Month End & Year-End close Issues (AP, AR, GL, FA).Worked closely with Audit Team in Understanding the Cross-Currency Suspense Accounts in R12.

Responsibilities:

●Worked as an Oracle ERP Analyst Re implementing/upgrading R12 Fixed Assets

●Involved in Redesign of refund process (Refund Issue on returns, Refund Issue on edit cancels, Order entry form, Calculation and display of available AR)

●Worked on the Root cause for the incorrect accounting for Refunds (No accounted amount is being populated in AR distributions table for some refunds.

●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 for Year-end close

●Involved in Redesign of refund process (Refund Issue on returns, Refund Issue on edit cancels,

●Involved in resolving the Currency Translation Issues (Reporting Ledger)

●Perform User Acceptance Test (UAT) & Training for the end user on business process and procedures based on Financials modules

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

●Coordinated with the Development teams, testing teams (offshore) and provide them the functional designs and helped them to understand the design. (Functional Specs)

●Worked on SEV 1 SR’s for critical Month End Production Issues (Receipt Accrual, Payment, and Upload Journals through -WEB ADI).

●As a part of Implementation/ On Going Production Support Project Responsible for Maintenance and Updating the BR100’s. For Account Payables, Fixed Assets, Account Receivables. & General Ledger.

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

●Help the business users in understanding the Key Reports (Accounts Payable Trial Balance Report, Account Analysis report and Depreciation Project Report, Uninvoiced Receipt Report, Invoice Hold Report).

●Worked closely with Business users in Understanding the Report Manager Functionality.

●Involved in technical discussions for migrating the code and validated the code by testing in Test before moving the PPM Packages to Production.

CVR Energy, Kansas City, KansasNOV 2011– JUN 2012

Oracle Financials Functional Analyst

11i (11.5.9) AP, CE, FA – Business Integration.

Worked with CVR energy on their Business integration project from requirement gathering till go live.CVR Energy group is a petroleum refining and fertilizer manufacturing company whose headquarters is based in Sugarland, Texas. Was mostly responsible for CE, AP and FA modules but occasionally worked on GL, Inventory, OM and Receivables, Modules

Responsibilities;

●Configuring the Oracle system financial modules namely Account Payables (AP), Cash Management (CE), and Fixed Assets (FA) according to business needs.

●Occasionally helped out on other modules namely, inventory, OM, GL, and Receivables working on STAT tool for Change management process and migration of setup data from development instance all the way to the production instance.

●Performing Requirement Analysis – gathering requirements, performing impact analysis and document requirements.

●Design - Attend design meetings, document high level design and detailed design.

●Development and Implementation of the application as per the requirements and design as discussed with the business users.

●Developing test scripts and test cases for Open invoices, 1099 Invoices, and supplier setups as well as performing testing of the setups done in the system.

●Responsible for conversion and migration of fixed assets from the Legacy system into oracle.

●Involvement in production and post go live issue troubleshooting process.

D&H Distributing Inc. Harrisburg, PA Feb 2011– Nov 2011

Oracle Financial Functional Analyst

R12 (12.1.3), AP,i-expense, and FA –Implementation

Working with D&H Distributing Inc, a wholesale distributor of computer and peripheral products in North America, as an Oracle Financial Functional Analyst from phase requirement gathering through to UAT and responsible with, AP and FA.

Responsibilities:

●Configured Payables System Options, Payable and Financial options

●Defined Payment Terms, Payment Setups and Distribution Sets

●Setup Suppliers, Supplier Sites, Banks, Bank Accounts and documents

●Setup book controls, corporate book and tax book.

●Setup purchasing for standard functionalities like converting purchase requisitions into standard purchase orders and blanket releases.

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

●Training Super users & power users before start of CRP

●Conducted Training to User and super User for AP, and FA

●Conducted CRP’s and trained end users for, AP and FA

●Extensive unit and integrated testing done before CRP & UAT

●Did configurations on the i-expense and i-procurement web portal and oracle payments sub module.

Schneider National - Green bay, WIMay 2010 – Jan 2011

Oracle Financials Functional Analyst

R12 (12.1.1) GL, AP, AR,-Post-Production support

Worked with Schneider National a global leader in logistics and transportation services as an oracle Financial Functional Analyst.

Responsibilities:

●Involved in Month-end support for close and reconciliation for AP and AR modules

●Prepared impact analysis for critical issues

●Resolved issues that occurred in the production

●Have followed up with the business for approval of the resolved issues

●Worked with the business to develop updated business policies based on issues resolved

●Actively involved in troubleshooting various issues especially with oracle payments, auto lock box and auto invoicing.

●Resolved all the issues which were raised in Bugzilla

●Interacted with Oracle Support to resolve critical issues through SR/TAR

●Followed up with pending business input or issue resolutions as part of status meeting.

●Involved with running the AR revenue recognition program to determine when revenues and receivables are recognized

American Commercial Lines (ACL), Jeffersonville, INJun2009 – Apr 2010

Oracle Financial Functional Analyst

Workedat ACL designed, mapped and implemented Oracle Financial solutions for different business process for client.

R12 (12.1.1) AP, AR, SLA, i-expense& CE- Upgrade

American Commercial Lines Inc. (ACL) is leader in the transportation and manufacturing markets. Worked with ACL as an Oracle Financial Functional Analyst from phase CRP1 through to UAT and responsible with AP, AR, SLA and CE.

Responsibilities:

●Assisted in upgrade of Oracle Financials (AP, AR and CE) across the organization.

●Created general settings and completed specific configuration related to Company Code, Bank transaction codes, Bank accounts and bank reconciliations

●Loaded, imported and auto-reconciled the bank statement transaction against payments in Accounts Payable (AP)/Accounts Receivable AR in Oracle cash management modules.

●Involved with extensive configuration of oracle payments sub module

●Conducted CRP1, CRP2 and tested the customized components

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

●Created the test scripts and test cases for use on the upgraded instance

●Facilitating end-user training and developing the various user training manuals and conducted the UAT.

●Involved with performing the pre-upgrade steps for the cloned 11i instance also developed and performed post upgrade steps for the cloned R12 instance

Contact this candidate