Oracle Financials Specialist -Providence, RI

Oracle Financials Specialist - Grants/Project Accounting

Client: Stonewall Solutions/State of Rhode Island

Job Location: Providence, RI (Hybrid - On-Site 2-3 days/week)

Duration: 1-Year + Work Schedule: M-F first shift, 40 hours/week

Job Description

We are seeking an Oracle Financial Management System (FMS) Specialist for our client, a leading technology consulting company to the public sector. This Oracle Financial Specialist will support the Rhode Island Department of Transportation (RIDOT) to assist with the goal of leading in supporting, maintaining and developing the Department's Oracle EBS Financial System known as FMS. The Oracle ERP Modules include: Oracle Grants Management, Oracle Inventory, Oracle HRMS, Oracle Time and Labor (OTL), Oracle Accounts Receivables (AR), Oracle Purchasing (PO), Oracle Account Payables (AP), Oracle Subledger Accounting (SLA), and Oracle General Ledger (GL). The consultant will be responsible for enhancing and supporting the Oracle R12 Financial Management System (FMS) processes and address new areas of work.

Candidates with a strong understanding of the Oracle Grants / Projects Accounting Module will only be considered.

Required experience: (The candidate must be (60%) Technical and (40%) Functional and possess the following skill-sets:

• Well-versed with EBS modules - Inventory, Purchasing, Payables, Receivables, Sub-Ledger Accounting and General Ledger
• An understanding on, how Oracle Grants/Projects works and its integration with other Oracle modules like Purchasing, Payables, Receivables and OTL
• Basics of Oracle HRMS, Oracle Time and Labor
• Technically strong in R12.2.x architecture and tech-stack

The candidate must be technically strong in:

• Oracle Application Object Library
• Oracle Forms and Reports Developer - 10g
• Oracle Workflow
• SQL, PL/SQL
• Java, J2EE
• Oracle Applications Framework
• Oracle Database 12c, 19c
• Scripting (Unix Shell, SAMBA Client Scripting, JavaScript)
• XML Publisher Reports
• Oracle Business Intelligence
• Servers - Linux/Unix
• Toad
• JDeveloper
• SQL Developer
• Test Plans and User Guides
• OUM Documentation standards

Preferred not Required:

• OBIEE Reports
• Web Services Development
• Azure Devops for Source Control

The Consultant Is Responsible For

• Supporting the business activities through active work on client engagements, understand our business model, business processes, suggest improvements and map the requirements for the Oracle EBS environment
• Support and assist the internal IT team with support issues and key development areas
• Prepare project plans, estimates and milestones, task plans, test plans and defect tracking mechanisms to deliver and manage projects, customizations & enhancements
• Hands-on experience in Oracle EBS R12.2.X implementations, upgrades and support
• Possess sound knowledge of multiple Oracle EBS modules like HRMS, Time and Labor, Inventory, Purchasing, Payables, Grants, Subledger Accounting, and General Ledger
• Ability to design, develop and deliver high level custom solutions using SQL, PL-SQL, RICE Objects [Interfaces, Conversions, Integrations and Extracts], Oracle Application Object Library, Oracle Forms 10g, Reports [Oracle Reports 10g, Discoverer Reports 11g, XML and BI Publisher Reports, OBIEE Reports and Analytics], Workflows, Oracle Application Framework, Java, XML, Scripting [UNIX Shell, SAMBA Client, JavaScript], Oracle Database 19c, and Oracle tools [JDeveloper, SQL Developer]
• Perform gap fixes and performance tuning, support new implementations and upgrades, develop and deliver customizations and extensions
• Perform unit testing and coordinate with users for integration and system testing
• Manage and coordinate issue resolutions and escalations
• Coordinate with Oracle on product bugs, patches and service request resolutions
• Work with the DBA's
• Weekly reporting on deliverables status and presentations with management