Apex Systems is seeking an intermediate Oracle Financial Specialist to work hybrid out of the Providence, RI area.
>>>> To apply, please send your resume to Hannah Abbott, [email protected] ! <<<<
Candidates with a strong understanding of the Oracle Grants / Projects Accounting Module are advised to apply.
The FMS IT Support Team :
Senior Lead Oracle Financial Specialist (Consultant)
Two State Oracle Financial Specialist Employees
Apps DBA (Consultant)
Agency IT Manager
The FMS Core Functional Users :
800 Timecard Users
5 Grants Users
6 AP Users
4 PO Users
2 Inventory Users
4 AR Users
3 GL Users
2 HR Users
2 OTL 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 5 Years 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
• Expertise in performance tuning, data analysis and reconciliation of data across systems/modules
• 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
• Performance Tuning

Preferred not Required:

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

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 are 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 functionalities, automating business processes, perform upgrades. All solutions impacting the business offices will need approval by the Chief Financial Officer and the Agency IT Manager prior to implementing the change.
Strong expertise in performance tuning, data analysis and reconciliation of data across systems/modules is required.
All our modules have a great deal of customizations. From a reporting standpoint, HR and OTL have the most custom reports written. 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.
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 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 DBAs
• weekly report on deliverables status and presentations with management

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

EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.