Oracle EBS Financial Specialist / Oracle R12 FMS

Position: Oracle EBS Financial Specialist / Oracle FMS 

Location: Onsite-Providence, RI 02903 

Duration: 12 Months  

Description: we are looking for  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 also work on Bridge Integrations between Oracle FMS and Workday as needed.  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 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 

The candidate must be technically strong in:  

• Oracle Application Object  

• Oracle Forms 10G and Reports 10G   

• 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 

• Java 

• JDeveloper 

• SQL Developer 

• Oracle Database 12c 

 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 

• hands-on experience in Oracle EBS R12.2.X implementations, upgrades and support  

• 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] 

• Support, Develop and Modify 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