Oracle Financial Specialist

Job Description

HCH Enterprises, LLC is seeking an Oracle Financial Specialist. This is a full-time position with HCH Enterprises, LLC and a contract position with the state of Rhode Island.

The Oracle Financial Specialist – Senior position will lead and assist 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 Receivable, Oracle Purchasing (PO), Oracle Account Payable (AP), Oracle General Ledger (GL).

• The contractor Technical Lead will be responsible for enhancing and supporting the Oracle R12 Financial Management System (FMS) processes and address new areas of work.
• The contractor Technical Lead will work with the WorkDay HCM/Payroll and the Financial integration team on Data Mapping and Integrations. FMS is slated to sunset in October 2025.
• The contractor Technical Lead will also work on Bridge Integrations between Oracle FMS and Workday between now and July 2025. These New integrations from Oracle ERP include transaction on Purchase Orders, Invoices, GL, Grants, AR, Projects. Currently these integrations are between RIFANS an Oracle Financial ERP system with its own Chart of Accounts and DOTs Chart of Accounts in FMS.
• As a result of the Bridge Integrations from FMS to Workday, the contractor Technical Lead will also be required to develop new reports and update existing FMS Oracle reports.
  
  

It is expected this person to have extensive experience in designing and developing high level custom solutions including Interfaces 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 12c, and Oracle tools [JDeveloper, SQL Developer].

Required Experience 10 Years Experience

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

• Well-versed with Procure-to-Pay modules and General Ledger (including SLA) - SLA is a new functionality introduced in EBS R12. SLA is a powerful and flexible rules-based accounting engine, with a centralized data model and repository that generates accounting entries based on source transactions for all Oracle Applications transactions.
• An understanding on how Oracle Grants/Projects works and its integration with other Oracle modules like Purchasing, Payables, OTL
• Basics of Oracle HRMS, Oracle Time and Labor
• Technically strong in R12.2.x architecture and tech-stack
• Prior experience on developing Oracle integrations for Workday Projects is desired
  
  

The candidate must be technically strong in:

• Oracle Application Object
• Oracle Forms 10G and Reports 10G
• SQL, PL/SQL
• UNIX Shell Scripting
• Oracle Applications Framework
• Oracle Database 11g and 12c
• XML Publisher Reports
• BI Publisher Reports
• Linux/Unix
• Scripting (Unix Shell, SAMBA, Client, JavaScript)
• Puddy
• Toad
• Workflow
• Java
• JDeveloper
• SQL Developer
• Oracle Database 12c
• Test Plans and User Guides
  
  

Preferred Not Required

• OBIEE Reports
  
  

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 12c, 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 DBAs
• weekly report on deliverables status and presentations with management
• Work with the WorkDay integration team for Data Mapping and Integrations from Oracle ERP over to the State’s Workday System going live October of 2025
• Developing Bridge Integrations from FMS Oracle ERP to the State’s Workday ERP.
• Develop New Oracle FMS Reports and Update existing Oracle FMS Reports with the Bridge Integrations from Oracle FMS to Workday ERP
  
  

Implement and roll-out Projects

The state has multiple projects in the pipeline to add values to their current business or process, lower their cost base, perform effective risk management, and automate third-party integrations etc.

The consultant’s role will be to

• examine and analyze the benefits, risks of up taking the project for the organization
• discuss with key stakeholders and assist them in decision making
• define project plans, estimates and milestones
• implement effective risk management strategies
• discuss with users to gather requirements and inputs
• analyze the requirements in detail and map the requirements onto Oracle EBS
• design, develop and deliver the projects on-time with quality deliverables
• document test plans and results, deployment plans
• update project repository using industry documentation standards
• review projects and coordinate with the Lead Consultant
• review project status weekly or as needed with the Agency IT Manager
  
  

Projected start date TBD. Estimated length of contract is one year with possible extension. The position can either be onsite or remote. Onsite is preferred. If the candidate is relocating to be onsite, the state offers a very flexible work schedule. Three days on site and two remote days. Annual compensation range is $132k-$144k.

Company Overview

HCH Enterprises, LLC (HCH) is a solutions-oriented staffing, consulting, project management and IT service provider. Our mission is to help governments and partners make life better for everyone by centering equity in the delivery of our consulting, staff augmentation, and information technology services. HCH is certified as a Minority Owned, Disadvantaged and Small Business Enterprise (MBE/DBE/SBE). We hold security clearance with the U.S. Government and have the ability to provide our services in classified environments. At HCH, we believe our work benefits from the diverse perspectives of our employees. As such, HCH celebrates inclusion and is committed to being an Equal Opportunity Employer.

#ZR