We provide IT Staff Augmentation Services!

Sr. Oracle Financials Functional Consultant Resume

Durham, NC

PROFESSIONAL SUMMARY:

  • Oracle Finance Functional Consultant having overall 13 years of experience in which 5 years of Domain Experience in Finance area and 8 years of Global ERP consulting experience in ERP transformational and maintenance engagements which includes Oracle Applications Implementation, Post Implementation Support, Enhancements, Roll out projects.
  • Expertise in implementing and maintaining ERP based business solutions and best practices across process areas of Procure - To-Pay and Order-to-Cash.
  • Involved in E2E activities like requirement gathering, GAP Analysis and mapping the requirements with Standard functionalities, Configuration, Documentation, Regression, QA and End user testing, Preparation of End user manuals and End user training.
  • Carried out Full Life Cycle Implementation of Oracle Finance Modules and Support in different industries and various versions of Oracle R12 (12.1.3 and 12.2.6) and 11i (11.5.10).
  • Prepared Implementation Life Cycle Documents based on AIM Methodology.
  • Solid knowledge in General Ledger, Account Receivable, Account Payables, AGIS and iExpense modules.
  • Hands on experience in supporting Oracle Applications Fixed Assets, Cash Management, EBTax, Advanced Collections, Purchasing, Subledger Accounting, AME, and Trade Management modules and Sabrix Tax integration.
  • Proficient in Procure to Pay (P2P) and Order to Cash (O2C) tracks.
  • As an Onsite functional consultant, worked with business users and technical teams in successfully translating business requirements into functional specifications and deliverables.
  • Worked in Onsite and Offshore model projects including coordinating and leading offshore team.
  • Well versed with the integration and architecture of Multi-Org (MOAC), Sub-ledger accounting (SLA) and use of Web ADI.
  • Good analytical and problem-solving approach with appropriate decision analysis and resolution.
  • Worked well with people at various levels in the project like Business analysts, project managers, programmers, functional and technical lead etc.
  • Proficient in Data retrieval using SQL queries and supporting the necessary service requests logged with oracle. Ability to assist and guide technical team in Technical Design and Development of business requirements.
  • Have gone through Fusion Financials training sessions and have good idea on Fusion financials.

TECHNICAL SKILLS:

Oracle Applications: Oracle 11i & R12 -GL, AP, AR, PO, CE, FA, AGIS, iExp., AME and EBiz - Tax and Trade Management.

Documentation: AIM Methodology

Database: Oracle 10g/11g, SQL

Operating Systems: Windows ( XP, 98, 2000, 2003, 2007, Mac) Other Tools MS Office, Use of SQL Developer, WebADI, Data loader and UPK.

PROFESSIONAL EXPERIENCE:

Sr. Oracle Financials Functional Consultant

Confidential, Durham, NC

Responsibilities:

  • Involved in E2E activities like requirement gathering, GAP Analysis and mapping the requirements with Standard functionalities, Configuration, Documentation, Regression, QA and End user testing, preparation of End user manuals and End user training.
  • Working on the issues occur during the day to day business transactions raised by the Business users in R2R (Record To Report) track, which covers the Oracle Financial modules like Account Receivables, Account Payables, General Ledger, Fixed Assets, Cash Management and i-Expenses. Additionally, supporting Trade Management.
  • Responsible for Monthly/Quarterly and Yearly closures for AP, AR, PO, INV & GL.
  • Maintaining the SLA (Service Level Agreement) and the turnaround time in responding and closing the tickets.
  • Working with the Vendor-Oracle Support team on any issues or bugs in the Oracle product by raising service requests, get solution/fix and apply the same in the business application.
  • Working on the new project enhancements and providing ideas to Client to use the Product Efficiently.
  • Working closely with the Client's Business Analyst team to gather requirements, understanding the new requirement and working towards that to ensure all the requirements are met as per the project goal.
  • Participating in DOU (Discussion of Understanding) calls with functional owners and the Business Analyst team.
  • Preparing the FDD (Functional Design Document), setup document and UTP (Unit Test Plan) document for the projects.
  • Steady follow-up until the project is getting signed-off by the Business.
  • Providing Functional expertise & domain knowledge to the non-functional project team. Also expected to guide and help the junior team members in the team.
  • Act as a bridge between the Client's Business Analyst team and the technical consultants to get the expected outcome.
  • Will also work on need basis with O2C (Order-to-Cash), D2D (Demand to Deliver) and Q2C (Quote-to-Cash) track issues which are very close to R2R (Record To Report) tracks.
  • Coordinating and supporting the cross module functional owners when they require any financial functional support.
  • Client Liaison, Status Tracker Maintenance, Quality Coordination and Interaction with the Client’s core team.
  • Have to attend the scheduled status calls, Scrum Call and other need basis calls without fail, share the inputs and update the status of progression.
  • Coordinating with Offshore Team and work with Business to resolve the issues which occur on a daily basis.

Environment: Oracle Application 12.1.3 and 12.2.6, Oracle Financials, GL, AP, AR, CM, FA, Iexpense, SLA, AGIS, Advanced Collections and EBtax.

Oracle CRM Test Analyst

Confidential

Responsibilities:

  • Configuring workflow definitions and DFFs based on BR100 in test Instance for testing various business scenarios.
  • Executed the End to End test scenarios as part of functional integration testing.
  • Identified several issues in testing the flow and following up with the Functional/Technical Team to fix the issues.
  • Ensure the timely deliverables for Project.

Environment: Oracle Application 11.5.9, Oracle CRM Modules Opportunity, Quote, Order Management.

Oracle Financials Functional Consultant

Confidential

Responsibilities:

  • Involved in updating Setup (BR100) documents.
  • Configuring test Instances for testing various business scenarios.
  • Defining DFFs where ever required in AR module for various Custom Objects.
  • Reviewing, analyzing the Business Requirements, Functional Specs (MD050) and preparing the Test scripts (TE-40) against the same.
  • Developed the Test Cases and Test Data as needed and reviewed the same with Functional & Business teams.
  • Executed the tests and followed the Defect Management Process to track the defects and its resolution.
  • Functional and INT testing done for various RICEW Objects in Oracle AR and CM Modules.
  • Raising the Defects against failed scenarios and following up with the Functional/Technical Team to fix the Defect.
  • Ensure the timely deliverables for Project.

Environment: Oracle Application 12.1.3, Oracle Financials, GL, AR, CM, FA.

Oracle Financials Functional Consultant

Confidential

Responsibilities:

  • Involved in updating Setup (BR100) and Functional Flow (MD050) documents.
  • Involved in defining and testing the Cross-Validation Rules and Mass Allocations.
  • Configured and tested the Journal approval hierarchy.
  • Involved in AME Setup for AP Invoices and Purchase Requisition and tested the workflow.
  • Tested the Period End accrual auto Reversal procedure for Expense Items.
  • Configuring different Instances for testing various business scenarios.
  • Prepared the Responsibility Matrix for GL and AR modules.
  • Defining DFFs where ever required in AP and AR modules for various Custom Objects.
  • Defining Payment Instructions in AR.
  • Defining standard AP setups like Supplier, Payment Terms, and Pay Groups.
  • Defining standard AR Setups like Payment Terms, Customers, Banks, Transaction Types, Sources, Receivable Activities and Adjustment and Receipt Write off and approval limits to the users.
  • Importing Employees, defining collectors, assigning roles to collectors, defining Collector Groups and assigning Collectors to the Groups.
  • Helped the Technical Team in updating the code for RICEW Objects from Functional perspective.
  • Reviewing, analyzing the Business Requirements, Functional Specs (MD050) and preparing the Test scripts (TE-40) against the same.
  • Developed the Test Cases and Test Data as needed and reviewed the same with Functional & Business teams.
  • Executed the tests and followed the Defect Management Process to track the defects and its resolution.
  • Done Regression Testing for several Custom Objects in various Instances.
  • Functional and INT testing done for various RICEW Objects in Oracle PO, AP, AR, OM, and GL Modules also by using various testing tools like SOAP UI, OCCU and WinSCP.
  • Raising the Defects against failed scenarios and following up with the Functional/Technical Team to fix the Defect.
  • Training given to newly hired Team members & Knowledge Transfer for Business Process Team Members on various Objects.
  • Helped the QTP Automation Team in automating the script for various Objects.
  • Ensure the timely deliverables for Project

Environment: Oracle Application 12.1.3, Oracle Financials, GL, AR, AP, PO, OM.

Process Developer/Oracle Financials Functional Consultant

Confidential

Responsibilities:

  • Played an active role in process migration of E2E AP Project held in Singapore and prepared Standard Operating Procedures as required by process.
  • Processing of invoices in multiple currencies and handling Customer and Vendor calls on daily basis for timely resolution of problem invoices and holds.
  • Monitoring the aging report on weekly basis to ensure that the Vendors paid on time.
  • Coordinating with the GL and Treasury teams in clearing the bank reconciliation items.
  • Handling weekly soft close, month close and quarter close activities individually.
  • Responsible for reconciliation of month-end/Quarter end reports.
  • Preparing the daily and weekly Dash Boards.
  • Review of monthly reconciliations which include reconciliation of Invoice Aging and Trail Balance and Account Analysis reports.
  • Preparing Accrual JVs manually on Quarterly basis.
  • Implemented Lean process - A Quality initiative.
  • Involved in configuring the AP and PO modules as part of Roll out project.
  • Have provided support on AP and PO modules.

Environment: Oracle Application 11i(11.5.10.2), Oracle Financials AP, PO.

Finance Executive

Confidential

Responsibilities:

  • Preparation of Purchase Orders and Bank Guarantees.
  • Preparation of MIS Reports and Payment Advise for Sub Contract Payments
  • Maintenance of Books of Accounts and Preparation of Various Ledgers like purchases & stores
  • Preparation of Monthly Receipts and Payments statements.
  • Monitoring the Confidential statements and periodical report

Hire Now