Oracle Financial Functional

Aravinda Dinavahi

Fairfax, VA ***** ac12p4@r.postjobfree.com 408-***-****

* ***** ** ********** ** consultant in Oracle ERP Implementations, Upgrades and Support mainly in General Ledger, Receivables, Payables, Purchasing, Inventory, Cash Management, Tax, Order Management and Fixed Assets modules. Well experienced in implementation processes esp. Gap Analysis & developing Custom components as per business requirements.

Experience Summary

Worked as a Functional Analyst in Implementations, Upgrade and Post Production Support of Oracle EBS in various industries like Banking, Pharmaceutical and Manufacturing.

Full life cycle Implementations and upgrades in 11, 11i and R12 with GL, AP, PO, OM, AR, CM, FA, Inventory, iProcurement, iExpenses, EB-Tax, SLA, FAH, Depot Repair.

Designed solutions to enhance standard oracle processes - Order to Cash, Procure to Pay,

Inventory, TCA, Credit Card Transactions, GL Accounting processes.

Proficiency in AIM Methodology to enrich project management and documentation processes.

Expertise in preparing BP040, RD020, BR30, BR100, MD050, TE020 and TE040 documents.

Proficient in analyzing the ‘As-Is’ Business Processes, Redesigning and Developing Business Process Flows.

Worked on Federal Financials.

Good understanding of Federal General Ledger, Budgeting, Federal GL reports, Federal Payables, Prompt payments, third party payments, Document Cross-Referencing, Federal PA reports.

Worked on GTAS implementation in R12.

Configuration of DFF’s for GTAS attributes as needed in different operating units.

Wide experiences in requirement analysis, GAP analysis, design of the ‘To-Be’ process, Process Mapping, Data Conversion Management, Testing (unit/integration/system).

Collaboration with the Business users during the various stages of project lifecycle.

Designed the Functional solutions to the Key Gaps through Interface, Extension,

Customization, and Reports.

Good understanding in designing and requirements analysis for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion, Data Migration.

Highly experienced in post implementation, support and training the end users.

Good experience with Application Tools SQL DEVELOPER, TOAD, Data loader, ADI & WebADI.

Proficient Database Management understanding AR, AP, GL, CM tables predominantly.

Interpersonal skills, self-motivation, communication and quick adaptation to new applications and technologies.

Expertise with Trading Community Architecture (TCA), Data Quality Management (DQM) in Oracle.

Firm understanding of integration of Oracle Applications modules, Flexfields, MRC Setups, Multi Org, Revenue Recognition and AGIS.

Experience with Approval Workflow (AME) configuration and customizations.

Expertise in Reconciliation of Sub-Ledger modules with GL, R12 SLA, R12 Accounting Setup Manager, Inter Company Accounting and MOAC.

Good experience with Oracle Business Intelligence Enterprise Edition.

Proficient concept and implementation understanding of Multiple Reporting Currencies.

Experience in Oracle Project Accoutning.

Good knowledge about Credit Management.

Excellent communication skills.

Well versed with SDLC, Agile Methodologies and AIM.

Technical Skills

ERP: Oracle EBS R12, Oracle EBS 11i

Modules: General Ledger (GL), Account payable (AP), Purchasing (PO), Account Receivable (AR), Cash Management (CM), Fixed Assets (FA), Inventory (INV), Financial Accounting Hub (FAH), Order Management (OM), Project Accounting (PA) and E-Business Tax.

Operating Systems: Windows 7, Vista, XP

Office Applications: MS Outlook, MS Visio, MS Project

Database Tools: TOAD, SQL Loader, Data Loader, SQL Developer

Reporting Tools: Discoverer, XML, Hyperion

Processes: Order to Cash (O2C), Procure to Pay (P2P), Budget to Report (B2R)

Marsh & McLennan, Hoboken, NJ Apr-2016 to Till Date

Oracle Functional Consultant

Summary of Role: Functional Consultant for R12.1.3

Key member in configuring systems and solving production issues.

Worked on FAH, GL, AGIS, MOAC, AP, AR, iExpenses, Markview, Vertex, SLA, WebADI, Dataloader, PO, EBTax, iProcurement.

Worked on Catelgoues, Punchounts, Content zones, P-Cards.

Resolved issues with Requisitions, Purchase Orders.

Worked on FAH to GL - external interfaces.

Worked on 11i interfaces to FAH.

Resolved issues encountered by Tax calculation in Vertex.

Worked on customizations pertaining to Payment Process Profiles, XML templates.

Resolved issues with different interfaces – GL, AP, AR.

Writing/executing SQL scripts, understanding custom PL/SQL codes.

Performed Sanity tests, created TE20/TE40.

Performed and assisted Regression tests.

Suggested and implemented improvement of their business processes.

Gathered requirements, designed, assisted development, tested and supported new enhancements.

Worked on Knowledge Capture Documents, Business Process documents, MD50s / Functional specs, Test scripts.

Round the clock support during rollouts and AP, GL, AR, PO month-end processes.

FedEx, Dallas, TX Nov-2014 to Mar - 2016

Oracle Functional Consultant

Summary of Role: Functional Consultant for R12.1.3

Was responsible in configuration of Accounts Receivable, General Ledger, Accounts Payables, Sys Admin and in various instances.

Have configured for Project Costing and Project Billing - Project Templates, Tasks, Transaction Controls, Cross Charges, Bill Rates, Rate schedules.

Defined several AutoAccounting rules, Burden schedules, Transfer Price schedules, Cross charge schedules.

Evaluated expenditures, compared to budgets and revenue to track project’s progress and profitability.

Configured tax rates, multiple jurisdictions, tax statuses, tax regimes etc.

Integrated EBiz Tax with Accounts Payables, Accounts Receivables to calculate taxes on the invoices.

Designed FAH to GL interfaces.

Worked FAH Journal reversal processes per client’s requirements.

Worked on General Ledger and Subledger Accounting Method (SLA) Configurations.

Resolved issues in FAH / SLA on priority.

Worked on resolving issues with Advanced Collections and Territory Management.

Configured on System Book controls, Prorate conventions, asset books, depreciation rules (Fixed Assets).

Resolved issues with Reconciliation and Accounting associated with different Operating Units.

Created and deployed SQLs to effectively monitor the job status like long running requests, requests waiting beyond acceptable time limit and errored out requests.

Configured resources, resource groups, roles, role types through CRM module.

Worked on Application Object Library (AOL).

Resolved issues with custom Payment upload tools.

Also worked with Depot Repair team in configuring instances, SLAM.

Worked on Revenue Recognition process.

Provided continuous support and enhanced GL, AR period close processes.

Was involved extensively in End-to-End Testing cycles.

Responsible for knowledge transition to offshore as Lead.

Participated in Training sessions and created Knowledge Transaction documents, SOPs. And updated the same time to time.

C&S Wholesale Grocers, Keene, NH Dec-2013 to Oct-2014

Oracle Functional Consultant

Summary of Role: Functional Consultant for R12.1.3

Key member in solving production issues.

Worked on created and issues resolution on Purchsaing i.e. Purchase Order, Receipts, Requisitions.

Worked on interfaces to FAH.

Configured FAH.

Worked on Order to Cash. Resolved issues as well.

Solved issues with Sales Order in Order Management (OM).

Worked on Revenue Recognition process.

Good working knowledge on Invoicing rules and Accounting rules.

Experience with Data Quality Management (DQM), Trading Community Architecture (TCA).

Resolved issues with Customer Master, Invoice interface, Customer Interfaces.

Worked on Lockbox enhancements.

Resolved critical issues caused due to problem with Direct Debit files and Lockbox files.

Supported production environments and users on daily basis by responding to emergency requests.

Experience with MOAC Multi-Organization Access Control, Security Profile.

Designed, coordinated development, tested and resolved issues Customer Statements to suit different business needs.

Customized Sub-ledger Accounting (SLA) per the business requirements in both AP and AR.

Worked round the clock during AR, AP Period close process.

Quick in SQL, PL/SQL queries inorder to fetch data per user’s needs for analysis purposes.

Worked on Custom reports massively inorder to accommodate different columns from customer accounts, customer transactions, receipt applications, tables etc.

Have setup Transaction sources and types, Memo lines, Receipt Methods per business needs.

Resolved Lockbox, custom cash application, receipt netting, AP AR Netting issues.

Was extensively involved in decision making regarding the development needed to be done based on the business needs.

Worked on Vertex integration with Oracle.

Resolved issues encountered by Tax calculation in Vertex.

Coordinated Functional testing, UAT testing and Regression testing.

Created MD50s, Test Scripts, Change requests for the enhancements and change requests.

Documented processes through MS Visio, MS Power Point.

BMC Softwares, Houston, Texas Oct-2013 to Dec-2013

Oracle Functional Consultant

Summary of Role: Functional Consultant for R11.5.10 and R12

Contribution:

Acted as key member in gathering and understanding business requirements.

Lead the implementation team.

Created and generated FSG (Financial Statement Generator) reports.

Configured MRC for multiple countries in various instances.

Prepared documentation for the business requirements, configuration, testing. Also consolidated issues for future troubleshooting.

Actively participated in the decision-making activities with business inorder to determine the rates to be used for conversion.

Resolved issues encountered during GL balances conversion.

Resolved issues during AP, AR, FA period close process.

Customized GL balances load and transactions loads as per business requirements for different periods.

Assisted technical team in developing custom program that would meet with the business requirements.

Resolved issues caused by customizations.

Analyzed impacts of customizations in 11i for R12 upgrade and also ability to eliminate any of the customizations after R12 upgrade.

Analyzed and documented user functionality changes like payments manager, supplier maintenance, and customer master maintenance.

Proposed new functionalities in R12 for implementation after initial assessment for Customer Refunds, AP third party payments and AP-AR Netting.

Analyzed and documented the usage of FSG reports in Client ADI and the need to migrate to Oracle Reports Manager and it new functionalities.

Had worked on the Legal Entity Architecture, Multi-Org of R12 to accommodate the current structure in 11i.

Trained business and users on MRC configuration and functionality.

Communicated with Oracle Support round the clock inorder to get the issues resolved quickly.

Dish Network, Denver, Colorado Aug-2012 to Sep-2013

Functional Consultant

Summary of Role: Functional Consultant: R11.5.10.2 to R12.1.3 Upgrade (Financials and Distributions)

Contribution:

Acted as key member in R12 upgrade and thus played a significant role in stabilization of the application.

Performed analysis on the impact from current version of 11.5.10.2 to R12 upgrade for General Ledger, Payables, Receivables and Collections, Inventory, Assets and Cash Management.

Configured AutoAccounting setups to ensure error free interface process.

Resolved issues in AR Interface during AutoInvoice process and Tested the functionality.

Delivered documentation to gather the user requirements for new features. And developed detailed test scenarios and test scripts.

Customized Sub-Ledger Accounting’ accounting rules to meet the business requirements for Revenue Recognition.

Assisted throughout during Record to Report process.

Implemented Procure to Pay process, Order to Cash process.

Customized standard XML reports.

Configured E-Business Tax in R12.

Configurations of additional taxes in eBiz-Tax in R12 for Payables and Receivables.

Implemented Balance forward billing and consolidated all of the customer’s activity for a specific period.

Configured and Maintained collections through Oracle Advanced Collections.

Managed Dunning letters through Advanced collections.

Managed disputes and claims more efficiently through Advanced Collections.

iExpenses setup with multi level approval and paperless streamlines process.

iExpenses travel policy definition and audit procedures.

Handled functional testing and regression testing.

Coordinated UAT testing.

Conducted CRP sessions with end users.

Manulife Financial, Boston, MA Feb-2011 to Jul-2012

Sr. Functional Consultant

Summary of Role: Scope is to implement and support P2P, O2C, R2R and other financial modules, optimize the usage of ERP, introduce best practices and establish controls live on R12 using all financial and supply chain modules.

Contribution:

I have been associated with the project from the inception, Preparation of client presentation, and Interacting with the client for various information requirements.

Prepared AS-IS document and provided initial demo to the client/super users to gather system requirements for General Ledger, iExpenses, Purchasing and Inventory, Payables and Receivables modules.

Understanding requirements for AS-IS document for eBiz tax for Payables and Receivables.

Setting up the CRP instance for training/ demo as per the requirements gathered during the business process study. Demo to the customers on the flow of business process based on the TO BE scenarios presented.

Mapped the Client requirements with Oracle standard functionality, found gaps, prepared setup Documents (BR 100) and delivered the solutions in terms of Customizations, workarounds, re-engineering and form personalization.

Writing/executing scripts using SQL Navigator, SQL Developer to perform various extracts from database.

Data conversions for AR Customers (Customer Interface), AR Invoices and Receipts (Auto Invoice and Lockbox), Suppliers Master conversion and Vendor Invoices. Both open and closed invoices converted.

Created the conversion document (CV10) and assisted the technical team in developing the conversion and Interface program for GL and AR.

Participated in the financial accounting Month-end close process to ensure financial sub-ledgers.

Experience with MOAC Multi-Organization Access Control.

Worked on Balance forward billing by creating several billing cycles, assigning them to customer profiles and generating them time to time.

Managed collections through Oracle Advanced Collections.

Efficiently managed Dunning letters through Advanced collections.

Setup of Policy schedules such as Accommodations, Meals and Entertainment, Rental Car, Airfare, Mileage, Relocation, other travel expenses as part of iExpenses roll out.

Implemented iProcurement and enforced various purchasing policies.

Implemented revenue recognition to recognize the revenue into various periods.

Trained, Conducted Practice & Additional Business Requirements sessions.

Have taken part actively in functional and regression testing.

PennEnergy, Pittsburgh, PA Jul–2010 to Jan-2011

Functional Consultant

Summary of Role: Scope of the project was to support and upgrade the application version from 11.5.8 to 12i. I was responsible for all financial modules.

Contribution:

Worked on R12 upgrade from 11.5.8 along with daily production support. Prepared financials module test scripts and tested the R12 upgraded system for setup and functionality. Tested custom programs, which are converted from 11.5.8 to R12.

Implemented iExpenses to US operating unit.

Designed and implemented the changes to the existing customizations ( GL daily rates load, GL data extract to ODS, GL data extract from Order to cash databases)

Prepared test cases for R12 upgrade testing and coordinated with QA team for test case execution

Supported for iProcurement and iExpenses.

Coordination with DBA team, offshore developers, cross-functional teams, release management team, performance tuning team, SOX compliance team, Org adoption team.

Coordination with Oracle support for resolution of R12 bugs.

Trained users on the new R12 new features especially new R12 modules.

Suggested new period closing procedures because of R12 changes.

Weekly status meetings to communicate progress on system support issues to management and user groups

Berry plastics, Evansville, Indiana Jun–2009 to Jun-2010

Functional Consultant

Summary of Role: As a Functional Consultant I implemented P2P, O2C, Inventory, and Costing Methods. Involved in identification of business process scenarios, gap analysis, configuration, Creation of test scripts, CRP testing and implementation.

Contribution:

Functional Consultant for Purchasing (PO), Payables (AP), Receivables (AR) and Responsible for Supplier master modules.

Gap Analysis and gap resolution for PO / AP / AR / INV.

Involved in setting up meetings with Business users to gather requirements information.

Followed AIM Implementation methodology.

Gap and Fit analysis done based on the business requirements.

Involved with Purchasing setups: Payment Terms, PO Lookups, Purchasing Options, Buyers, Financial Options, Transaction Reasons, Receiving Options, Suppliers, Sourcing Rule, Position Hierarchies and Employees.

Implemented Back-to-Back orders in Configured scenario where purchasing activity is involved.

Implemented the pick sources using the global sourcing rules.

Implemented the transit time calculation using internal locations, regions and zones.

Working on issues related to Freight Charges from suppliers.

Involved in setting up Cost types, Future, Engineering and additional Cost types, Defined material sub-elements, Defined Overheads, Material overhead defaults, Defined Category accounts, Associate WIP account class with Category accounts.

Involved in the Creation of test script documents for CRP and UAT.

Providing functional inputs to coordinate between client and Technical consultants related to application issues.

Involved in setting up Out-Side processing flow.

Captured the business processes in form of scenario matrix for testing various process alternatives followed as part of Bill of Material/Work in Progress/Costing/Quality and Planning.

Designed and implemented a third party tool for handing massive intercompany transactions across multiple companies to handle ‘Transfer pricing’ and ‘Cost plus’ business functions.

Contact this candidate