Oracle EBS Financial Specialist

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

 

 

 

 

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

 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

§   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