What are the responsibilities and job description for the Senior Oracle Financial Specialist position at Global Information Technology Inc.?
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 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 :
Required Experience 10 Years Experience
The candidate must be (60%) Technical and (40%) Functional and possess the following skill-sets :
The candidate must be technically strong in :
Preferred not Required
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
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
Client Name : RI Department of Administration
Position : Hybrid
RTR : Attached