Oracle Consultant

Job description

Oracle Technical Specialist

Job Description

T023 - Oracle Technical Specialist - Journeyman

Hybrid role - local candidates preferred

The Contractor personnel shall perform the following duties and responsibilities:

a. Design and develop business rules, including Groovy rules for financials, workforce, projects, and custom cubes.

b. Configuring and developing with EPM Cloud Planning workforce module and associated business rules, forms, and integrations with PeopleSoft.

c. Design, develop, and deploy EPM Planning forms and associated components, including dimensional design, Planning workflows, navigation, and approvals.

d. Design and develop reports, packages, doclets, using narrative reporting for annual financial reports and Budget book reports.

e. Configuring Financial close and consolidation modules in integration with Oracle ERP General ledger for developing annual financial reports.

f. Design, develop, and deploy EPM Planning, and Narrative reporting RestAPI using Groovy Scripting and business rules.

g. Expertise in Python scripts utilizing the EPM cloud RESTAPI and EPM Automate to extract, transform, and load ERP data into EPM planning using. Experience working with the Oracle ERP OIC as needed.

h. Design, develop, and support data integrations using data management, data exchange, and loading data for EPM cloud.

i. EPM planning integrations for ERP General ledger, budgetary control, and projects and awards modules, as well as experience integrating with PeopleSoft.

j. Analyze, debug, and interact with Oracle Support to resolve Oracle Planning environment and development issues.

k. Provide ongoing support throughout the SDLC process, including the development and maintenance of Oracle planning artifacts.

l. Assess the impact of potential changes and implement solutions to mitigate negative outcomes.

Education:

- Bachelor’s Degree in MIS, Computer Science, Math, Engineering or comparable major.

- Solid foundation in Computer Science, with strong competencies in data structures, algorithms and software design.

Qualifications:

a. Professional experience with 3 large Hyperion, EPM Cloud, and Oracle Planning implementations at the State/Local or Federal level.

b. Minimum (12) years of technical experience with Oracle Budget Applications such as Hyperion, EPM Cloud, EPBCS, Planning Narrative reporting, data integrations, and data management.

c. Minimum (12) years’ experience developing planning forms, data management integrations, business rules, reports with EPM cloud and/or EPBCS planning, narrative reporting, and Financial close and consolidation applications.

d. Minimum (8) years’ experience developing and supporting Oracle EPM cloud, EPBCS, financials, workforce, and project modules along with the Oracle ERP budgetary control, and PPM modules.

e. Minimum (8) years’ experience developing and supporting Oracle EPM cloud, Financial Close, and consolidation application supporting the creation of Annual report along with the Oracle ERP budgetary control and PPM modules.

f. Minimum (8) years’ experience implementing Oracle EPM Groovy business rules utilizing RESTAPI, and EPM Automate for planning.

g. Minimum (8) years of technical experience with Oracle EPM, Hyperion, EPM Automate and Python to load/extract data and associated scripts.

h. Minimum (8) years’ experience with FDMEE, data integration, loading data to EPM cloud, and integrating with ERP cloud and PeopleSoft applications.

i. Minimum (8) years’ experience developing and supporting Oracle EPM cloud, EPBCS, financials, workforce, and project modules for Federal, state/local budgeting entities.

j. Experience implementing three or more of Oracle Hyperion/Planning and Budgeting Cloud modules, EPM Modules such as: Financials, Line-item, Workforce, Position and employee-based budgets, Projects/awards/capital budgeting, for a Federal, public/private universities or State/Local entity.

k. Strong understanding of Business Process framework and a strong history of implementing solutions

l. Ability to interact with stakeholders, manage expectations, provide regular updates and conduct requirement definition sessions.

m. Experience with at least three of the following modules: Programming Skills: EPM Cloud or EPBCS, EPM Cloud Planning, Workforce, financials, Financial close and Consolidation, Narrative reporting. Groovy Scripting, Python Scripting, EPM Automate, EPM Data management, EPM Data integration, EPM business rules, EPM Groovy Business rules, Narrative reporting, Financial Reports, Oracle ERP Budgetary control, Oracle ERP Project Portfolio Management.

Skill

Required / Desired

Required Experience

Actual Years of Experience

Last Used Year

Professional experience with 3 large Hyperion, EPM Cloud, and Oracle Planning implementations at the State/Local or Federal level

Required

Experience with Oracle Budget Applications such as Hyperion, EPM Cloud, EPBCS, Planning Narrative reporting, data integrations, and data management

Required

12

Experience developing planning forms, data management integrations, business rules, reports with EPM cloud and/or EPBCS planning, narrative reporting

Required

12

Developing and supporting Oracle EPM cloud, EPBCS, financials, workforce, and project modules along with the Oracle ERP budgetary control, and PPM mod

Required

8

Oracle EPM cloud, Financial Close, and consolidation application creating of Annual report along with the Oracle ERP budgetary control and PPM mods

Required

8

Experience implementing Oracle EPM Groovy business rules utilizing RESTAPI, and EPM Automate for planning.

Required

8

Technical experience with Oracle EPM, Hyperion, EPM Automate and Python to load/extract data and associated scripts

Required

8

Experience with FDMEE, data integration, loading data to EPM cloud, and integrating with ERP cloud and PeopleSoft applications.

Required

8

Experience developing and supporting Oracle EPM cloud, EPBCS, financials, workforce, and project modules for Federal, state/local budgeting entities

Required

8

Strong understanding of Business Process framework and a strong history of implementing solutions

Required

Experience with at least three of the following modules: EPM Cloud or EPBCS, EPM Cloud Planning, Workforce, Financial close and Consolidation,

Required

Job Types: Full-time, Contract

Pay: $60.00 - $85.00 per hour

Expected hours: 40 per week

Schedule:

• 8 hour shift

Ability to Commute:

• Washington, DC 20001 (Preferred)

Ability to Relocate:

• Washington, DC 20001: Relocate before starting work (Required)

Work Location: Hybrid remote in Washington, DC 20001

Salary : $60 - $85