Oracle Techno Functional Consultant

Position: Oracle Techno functional Consultant

Duration: 12 Months – Approx.(35 Hrs/ Week)

Location: Hybrid- Providence, RI -- three days onsite /two remote

Job Description

client 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.

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