Demo

Senior Oracle Financial Specialist

Global Information Technology Inc.
Providence, RI Full Time
POSTED ON 1/25/2025
AVAILABLE BEFORE 4/23/2025

Job Description

Job Description

Rhode Island Department of Transportation (RIDOT) is requesting an Oracle Financial Specialist Senior position to 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].

Statement of Understanding

Rhode Island Department of Transportation ( RIDOT ) 2 Capitol Hill, Room 342 Providence, RI 02903 has requested an Oracle Financial Specialist Senior position to 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.
  • The FMS IT Support Team :

    Senior Lead Oracle Financial Technical Specialist (Consultant)

    Two State Oracle Financial Specialist Employees

    Apps DBA (Consultant)

    Agency IT Manager

    The FMS Core Functional Users :

    800 Timecard Users

    3 Grants Users

    5 AP Users

    5 PO Users

    2 Inventory Users

    3 AR Users

    2 GL Users

    2 HR Users

    10 Project Managers

    2 Auditors

    Work Schedule and Environment :

  • Full-Time on-site 35 Hour Work Week
  • SSL / VPN access will be provided in the event additional work (Upgrades / Updates) is needed to be done during off hours
  • State Computer, Desk Phone & Cubicle will be provided
  • Reports to the Agency IT Manager
  • 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
  • Scope of the Work

    Assisting the Existing Oracle Senior Financial Specialist and the Two Supporting Technical State Employees in supporting FMS for the Department. Currently 800 employees utilizing OTL. The proposed Scope of Work describes the tasks to be performed by the consultant on the Oracle R12 Financial Management System for the RIDOT in making improvements to the current R12 application. The Scope is based on performance improvements to concurrent programs / functions and adding additional program functionality. All solutions impacting the business offices will need approval by the Chief Financial Officer and the Agency IT Manager prior to implementing the change.

    All our modules have a great deal of customizations. From a reporting stand point, HR and OTL have the most custom reports. Whereas Grants, OTL and AP have the most customizations impacting functionality.

    Candidates need to keep in mind this is for Public Sector and having a strong Technical background in the Core Modules of Oracle Financials is required. Having a strong technical background in Grants, OTL and HR are in need to support our department.

    Scope of Services

    Oracle Financial Specialist Senior Position Role :

    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

    RIDOT FMS 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.
  • Client Name : RI Department of Administration

    Position : Hybrid

    RTR : Attached

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Senior Oracle Financial Specialist?

    Sign up to receive alerts about other jobs on the Senior Oracle Financial Specialist career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $75,004 - $94,003
    Income Estimation: 
    $95,426 - $117,847
    Income Estimation: 
    $117,871 - $153,580
    Income Estimation: 
    $131,745 - $167,716
    Income Estimation: 
    $144,503 - $184,592
    Income Estimation: 
    $102,541 - $137,871
    Income Estimation: 
    $153,752 - $200,235
    Income Estimation: 
    $95,426 - $117,847
    Income Estimation: 
    $115,392 - $147,123
    Income Estimation: 
    $115,392 - $147,123
    Income Estimation: 
    $153,719 - $192,342
    Income Estimation: 
    $144,503 - $184,592
    Income Estimation: 
    $150,756 - $194,140
    Income Estimation: 
    $172,191 - $221,861
    Income Estimation: 
    $114,549 - $164,025
    Income Estimation: 
    $153,752 - $200,235
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Global Information Technology Inc.

    Global Information Technology Inc.
    Hired Organization Address Providence, RI Full Time
    Job Summary : The MFP program aims to assist individuals with disabilities and older adults in transitioning from instit...
    Global Information Technology Inc.
    Hired Organization Address Southfield, MI Full Time
    Administrative Assistant We have an immediate need for a motivated Administrative Assistant with at least two years of p...
    Global Information Technology Inc.
    Hired Organization Address Lansing, MI Contractor
    Job Title: System Analyst 6 Job Location: Lansing, MI (Hybrid) Job Type: Contract Job Description/ Requirement: Automati...
    Global Information Technology Inc.
    Hired Organization Address Southfield, MI Contractor
    Job Title: EDI Claims Analyst Job Location: Remote Job Type: Contract Job Description: The EDI Claims Analyst is respons...

    Not the job you're looking for? Here are some other Senior Oracle Financial Specialist jobs in the Providence, RI area that may be a better fit.

    Oracle Financial Specialist - Senior

    Information Resource group, Inc., Providence, RI

    AI Assistant is available now!

    Feel free to start your new journey!