We provide IT Staff Augmentation Services!

Sr. Functional Consultant, Oracle Finance Resume

Cleveland, OH

SUMMARY:

  • Over 10+ years of hands on experience with emphasis on Oracle Financials with core strength in all aspects of Oracle EBS expertise in Financials, P2P with Oracle Grants processes in Public sector financials. Oracle Support/Global rollouts/ Upgrades.
  • Hands on experience in various Oracle Financial modules GL, AP, AR, Collections, Credit Management, Cash Management, AGIS, PO, projects, Grants, FA, Channel Revenue, SLA, Consolidation, and Reconciliation.
  • Completed Support, upgrade and Implementation Projects Oracle EBS R11i to R12.1.3 in State, County, Distribution and Retail industry with Agile/SCRUM, SWIM, AIM and OUM methodologies
  • Worked on Requirement Gathering, mapping Oracle processes and Identifying GAPS.
  • Successfully delivered CRP, SIT, UAT, Parallel run testing, Key UAT, End - to-End Testing, User, Go live cutover plans and Go Live Support.
  • Oracle Master data conversion (Customer, Open Transactions, Open Receipt, Customer Trend, Supplier, Supplier Invoices and payment) and data analysis from Non-Oracle to Oracle systems.
  • Worked closely with various business stakeholders like CFOs, CEOs and Group Directors.
  • In Oracle Support roles worked closely with the Oracle Support, technical team and Key users to resolve the issue.
  • Oracle Patch analysis, testing and progressing patches to different Oracle instances and offer timely resolutions.
  • Managed global projects, on and offshore resources and coordination of variety of initiatives.
  • Planning, leading and executing test activities for Oracle ERP P2P,O2C, Projects and Grants Processes.
  • Work with the business and IT management to maintain and discuss daily RAID Issue log.
  • Creating and maintaining Configuration documentation like BR100s and DS30.
  • Prepare and maintain MD50, AN100s for different RICE Objects which includes Reports, Integration, Conversions, Extensions, and Workflows.

TECHNICAL SKILLS:

Oracle Programming: Oracle 10g/9i/8i, SQL, PL-SQLTools: Developer, TOAD, UI Path, Config Snapshot and HTML Data Loader

Programming Language: C, C++ (Procedural and Object Oriented), HTML5, Java Script, Python.

Reporting Tools: OTBI, OBIEE

Oracle EBS R11i/12 Modules: Oracle GL, AGIS, Oracle CE, Oracle PO, Oracle AP, FA, Projects and Grant Accounting Oracle AR, Oracle Advanced Collections, Oracle Credit Management, ChRev,Oracle SLA, Oracle EB Tax, Oracle ChRev

Oracle I: receivables, Customer Data Hub (CDH)

Core Skills/Experience: Analyzing functional requirements, Identifying GAPS, Writing functional specs for RICE objects, any customizations and Personalization, Proposing appropriate solutions for the tasks. Data analysis for Customer conversion, Supplier conversion, Open Invoices conversion, Open Receipts conversion, Trend data, Resolving critical Production support issues, coordinating with various teams to fix Remedy Issues.

OnsiteOffshore Co: ordination in providing quality deliverables on time, Managing the offshore deliverables and the cutover activities, Managing RAID List, prioritize tasks and converting RAID Lists to Action items, Enhancement Requests, Onsite-Offshore Co-ordination in providing quality deliverables on time for next released.

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Sr. Functional Consultant, Oracle Finance

Responsibilities:

  • Perform compliance and audit functions which includes meeting with auditors and presenting application functions and reports being audited
  • Planning and testing of application, configuration and Application data changes, and work with Oracle Support to get the required patches and update production support documentation.
  • Trouble-shooting production incidents requiring detailed analysis of issues with third party and homegrown systems.
  • Maintain and Schedule daily, weekly and monthly concurrent Processes.
  • Analyse production issues to determine root cause and provides fix recommendations to the development team
  • Support applications in production. Note interruptions or bugs in operation and perform problem solving exercise to determine problem and ensure continued use of the application
  • Create, develop, and track solutions to application errors reported and help develop early warning systems.
  • Note interruptions or bugs in operation and carry out mitigation / problem management

Confidential, Cleveland, OH

Sr. Functional Consultant, Oracle Finance

Responsibilities:

  • Process design/GAP analysis and process mapping for AR, Collections and Credit Management with AME for EMEA (UK and Ireland).
  • Design and build the processes which can be implemented in future waves of other countries. Improve the Global footprint.
  • Work closely with stakeholders (Superusers, Group Directors, AR Credit managers, Collection Managers) to understand the existing business processes and suggesting the best of breed business processes in Oracle ERP Practice.
  • Implemented and supported AR, Collections, Credit Management, AME for EMEA.
  • Designing MD50s/AN100s, Test Scripts for RICE objects and coordinate with Technical teams and DBA Teams to test and implement the same.
  • Investigate and verify PL/SQL custom code for OCM Additional Data points and Collection Scoring components.
  • Responsible for Customer master data analysing and Customer Master Data conversion with open Invoices and Receipts data analysis and Conversion. Customer Trend Data Conversion including SLA customization.
  • Communicates Project status to key IT contacts and risk analysis,
  • Configured Oracle AR, Collections for Mexico Operating Unit.
  • Coordinated with Oracle on fixing multi-currency in Collections and Data point sequencing related bugs in OCM.
  • Helped identifying and fixing bugs in Oracle Cloud Financials

Confidential, Seattle, WA

Oracle Functional Consultant

Responsibilities:

  • Mapping Legacy processes of mainframe with Oracle and provide customized solutions for the functionality which is not part of the Oracle seeded functionality.
  • Configured AR, Collections and Oracle channel revenue Management.
  • Customer structure design
  • Customer Conversion, Open Invoice Conversion, Receipt Conversion for last 1 year from Mainframe.
  • Complete AR Implementation with Collections and Oracle channel revenue management
  • BR100, TE040, MD50 Documentation for different processes.
  • Lead SIT for AR, Channel revenue and Collections and Credit Management.
  • Reconciliation Payments and Receipts in Cash Management.

Confidential, St. Paul, MN

Oracle Consultant

Responsibilities:

  • Provided Production support in GL, AR, AP, i-Expense, CE, SLA, Oracle Projects, Oracle Grants in WIRES R12.1.3.
  • Supported custom Cash App Interfaces, Supplier Open Interface and Supplier Open Interfaces with legacy and home-grown systems.
  • Work with the Change board to implement changes in the Oracle PROD instance.
  • Handling Interface issues and implementing changes in the interface to fix the issues.
  • Handle day to day issues in Oracle Finance and provide timely Solutions with the help of technical team and Oracle Support.
  • Work with the Office of Sponsored Projects to support Oracle Grants and Projects module.
  • Log remedy tickets and understand the impact and discuss the issue with cross functional teams to implement the needed solution in a timely manner.
  • Prioritizing and work with Oracle Support on different remedy issues. Patch Analysis and Co-ordinate with DBA and technical teams to implement Patch in DEV environments and progressing the patch to PROD environments.
  • Implement Enhancement Request in GL, AP, AR, Collections.
  • Ensure smooth Period end closing for AP and PA Reconciliation activities.

Confidential, Salem, OR

Oracle Finance Lead

Responsibilities:

  • Worked on R12 upgrade for GL, AR, PO, AP, CE, PA, IEX and Interfaces.
  • Holding meetings with Business. Analyzing and evaluating Business systems and user needs.
  • Reengineering the business processes related to P-Card, P2P and O2C Business Processes. Documenting each of these Business Processes and mapping the same to the current functionality in Oracle E-Business Suite R11i and in Oracle R12.
  • AP Supplier, Open Invoices data conversion, data mapping and data validation from Public Works Supplier (PWS) legacy system.
  • SLA customization, Account Derivation rules, Mapping, Custom sources, Journal Line Types Setups and descriptions.
  • Identify the obsolete functionality in the new Oracle EBS R12 environment. Documenting and communicating the same with all stakeholders in a timely manner for the smooth transition.
  • Retiring some existing customizations, mapping obsolete functionality to the seeded functionality in the new functionality in Oracle EBS R12.1.6
  • To test all the processes in each conversion cycle and document their results to provide visibility to all Stakeholders.
  • Detailed documentation and lead sessions for users and Super users.
  • Month end closing of Sub ledgers and Ledgers in post go live environment. s:
  • Completing all deliverables in time.
  • Helped the IT Managers in suggesting third party tools and saving Confidential thousands in Projects cost and saving hundreds of man hours in time so that we can meet the deadline of 30 June 2013.
  • Transformation of five interfaces and three home grown modules to retire and changed to seeded functionality in R12.1.3 using AP/AR Netting, SLA Customization, Advanced Collections, replaced home grown software "ROSCO" for project costing.
  • Eliminated customized Web Apps module by customizing SLA Account derivation rules for Receivables, Payables, Purchasing and P-Cards.

Confidential, St. Paul, MN

Oracle Functional Consultant

Responsibilities:

  • Completed full Setups in Oracle GL, AR, AP, E-Business Tax, IEX, CE.
  • Gathering Business requirements, performing risk analysis and mapping the business processes. Analyzing the gaps and recommending the necessary customizations.
  • Customer and open customer Invoice data conversion, data mapping and data validation.
  • Designing and implementing various tests, debugging the software and providing post-live support.
  • Multi Org and COA structure development, Calendars, DFF, Data Access set, Security rules, Cross Validation rules, Consolidation and Elimination setups, Mass Allocation functionality to distribute cost across different cost centers, Period end processing.
  • Handled Leading Issues in the COA Flex Field Values issues to interface it with PeopleSoft SWIFT Implementation at state level.
  • Worked on Data migration, Customer workbenches, transaction types, Transaction Sources, Auto accounting, SLA, Revenue Recognition policy, bank setups, Payment methods, Approval limits, Receipt workbench, month end closing for AR and bank reconciliation.
  • Facilitating end-user and developing the various user manuals.
  • Coordinating project management activities by working closely with the testing and development teams.
  • Reviewing technical documents for standards, design and technical accuracy.
  • Resolved any month end related issues involving and data fixes or configuration changes.
  • Go live support for GL, AR, AP, and IEX.

Confidential, Milford, CT

Oracle Functional Consultant

Responsibilities:

  • Handling CRP sessions in GL, Receivables, Collections, Cash Management and E-Business tax, applications. Demonstrating all Oracle Standard Business processes in and One to one matching of requisitions in the requirement document where possible.
  • Test Scripts TE040 for GL, AR, Collections.
  • Completed full Setups in Oracle AR, E-Business Tax and Collections. Providing Third Party Collection company access to the UWQ.
  • Providing Test Scripts for Receivables and Collections.
  • Worked on Customer, transaction types, Transaction Sources, Auto accounting, SLA, Revenue Recognition policy, bank setups, Payment methods, Approval limits, Receipt workbench, month end closing for AR and bank reconciliation.
  • Used seeded Scoring components, Custom Scoring Engines, Customer handling, Configuring tasks & work items, Handling of disputes, Promise-to-Pay, Strategies, Aging Buckets.
  • Customized Accounting with SLA for Suppliers and Customers using Accounting method builder.
  • Loaded, imported and auto-reconciled the bank statement transaction against payments in Accounts Payable (AP)/Accounts Receivable AR in Oracle cash management modules.
  • Implemented New AR 12.1 functionality of Late Charges, Bank Setups, Tax Calculation functionality in AR.
  • Resolved any month end related issues involving and data fixes or configuration changes.

Hire Now