SUMMARY:

• Over 10+ years of hands on experience with emphasis on Oracle Financials with core strength in all aspects of Oracle EBS expertise in P2P, O2C, Project Accounting with Oracle Grants processes Oracle Support/Global rollouts/ Upgrades.
• Hands on experience in various Oracle Financial modules GL, AGIS, CE, PO, AP, Projects, Grants, FA, OM, Pricing, AR, Collections, Credit Management, Channel Revenue, SLA, EB Tax, AGIS, Consolidation, Reconciliation.
• Completed Support and Implementation Projects Oracle EBS R11i to R12 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 Training, 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, 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.

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: receivables, Customer Data Hub (CDH)

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 - Minneapolis, MN

Oracle TCA Lead and Production Support

Responsibilities:

• Analysed and advised the optimal TCA model based on the current O2C and P2P Processes.
• Learn and understood their existing end to end business from O2C and P2P to GL with the correct accounting generated.
• Fixed and Designed the Optimal customer master structure based upon existing business model with least impact on the Oracle Processes.
• Worked on automated customer account merge for building Account merge rules and automated process to merge using Power BI to identify the Survival party and Account.
• Provide ongoing internal reporting of performance measures and service levels
• Champion and promote service improvements on an ongoing basis to continually improve the quality of services delivered and customer satisfaction
• Production support in Oracle.

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:

• Implemented AR, Collections and Channel Revenue.
• Customer master structure design and conversion.
• Open Invoice Conversion, Receipt Conversion, Offer conversion.
• Successfully completed CRP, SIT, UAT, Go Live and Go Live Support.

Confidential - Cincinnati, OH

Oracle Consultant

Responsibilities:

• Working with SMEs, Business team and Capgemini Offshore and Onshore team to Support AP, FA and GL.
• Provide support in inbound and Outbound interfaces in Oracle AP, FA and GL
• Provide in Period and Year end closing.
• Implement change requests with the Change board and schedule changes with the offshore technical team.

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 - Chandler, AZ

Oracle EBS Support Consultant

Responsibilities:

• Configuring Oracle AP, GL, AR, CE, EB-Tax to onboard the new businesses to oracle EBS R12.1.5
• GL Consolidation and completing Month end close activities
• Configuring MOAC setup for different divisions for CFO and CEO
• Configured SLA rules for AP and AR based on accounting requirement.
• Documenting the new processes for the finance team.

Confidential, Salem OR

Oracle Finance Lead

Responsibilities:

• Oracle R12 financials Support for GL, AR, PO, AP, FA, SLA, Oracle PA, Oracle Grants with many outgoing and incoming Interfaces.
• 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.
• Supported P-Card modules and POETA (Projects, Org, Expenditure Type, Task, Award) Accounting.
• Have successfully completed Customer Conversion, Customer Trend, Open Invoices - Open Receipts conversion. AP Supplier, Open Invoices data conversion, data mapping and data validation from Public Works Supplier (PWS) legacy system.
• Created Functional specification documents by gathering user requirements for existing and new OBIEE reports to report Projects financial data with specific rollups and drill down analysis.
• Modifying seeded SLA rules based on different Accounting scenarios to derive required Grants Accounting.
• Coordinating with Application Developers in developing and debugging existing and new customizations.
• Planning and conducting test cases for testing different RICE Objects and functionality.
• Prepared detailed documentation and lead training sessions for users and Super users.
• Obtaining sign offs from Key users and other stakeholders.
• Month end closing of Sub ledgers and Ledgers in post go live environment.

Confidential

Oracle Functional Support Consultant

Responsibilities:

• Support GL and Sub ledger year end and month end closing activities.
• Run Revaluation, Translation, reconcile intercompany and consolidating Ledgers for China and Canada. Support GL and Sub ledger year end and month end closing activities.
• Handling Remedy Work Queue, prioritize tickets, Analyze the User problem and criticality of the issue and assign it to respective onsite and offsite resources. Managing the finance offsite functional and technical resources.
• Supporting Users of GL, AR, PO, AP and Collections department.
• Finding gaps in the implementation. Finalizing and executing the enhancements related to configuration of Oracle EBS. Providing time and costs analysis for the implementation of the enhancement requests.
• Translate User requirements into IT deliverables. Designing and implementing tests scenarios for the request enhancements. Provide training and coaching to Users
• Prepared UCM Documentation for Receivables Manager on Resolving Auto Invoicing errors, Dispute creation errors from Collections and performance issues in Collections UWQ.

Confidential - St. Paul, MN

Oracle Functional Consultant

Responsibilities:

• Re-implementation and Go live support for GL, AR, AP, CE, Projects and Grants.
• Gathering Business requirements mapping the business processes. Analyzing the gaps and recommending the solution.
• Customer, Supplier and open Invoice data conversion, data mapping and data validation.
• Preparing Cutover plan for each phase of milestone.
• Resolved any month end related issues involving and data fixes or configuration changes.
• Modifying seeded SLA rules based on different Accounting scenarios to derive required Grants Accounting.
• Coordinating with Application Developers in developing and debugging existing and new customizations.
• Planning and conducting test cases for testing different RICE Objects and functionality.
• Prepared detailed documentation and lead training sessions for users and Super users.
• Obtaining sign offs from Key users and other stakeholders.
• Month end closing of Sub ledgers and Ledgers in post go live environment.

Confidential - Milford, CT

Oracle Functional Consultant (AR & Collections)

Responsibilities:

• Re-implementation and Production support for AR and Collections
• Gathering Business requirements mapping the business processes. Analyzing the gaps and recommending the solution.
• Customer and open customer Invoice data conversion, data mapping and data validation.
• 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.

Confidential - Chicago, IL

Oracle Functional Consultant (Support)

Responsibilities:

• Support GL, AR, AP, FA, CE in Oracle 11i
• Support Period end closing activities and reconciliation.
• Handling Remedy Work Queue, prioritize tickets, Analyze the User problem and criticality of the issue and assign it to respective onsite and offsite resources. Managing the finance offsite functional and technical resources.
• Supporting Users of GL, AR, PO, AP and Collections department.