Oracle Fusion Grants, Awards, Projects and Project Portfolio Management (PPM) Functional Consultant Location: Arlington Heights, IL (Hybrid) Duration: 8+ Months

Interview process: 1 Panel Interview - Technical interview and social with 2 additional individuals

Job Summary

Required skills, experience, etc.: 5+ years of Oracle Fusion Cloud functional experience, strong expertise with Oracle Fusion Grants Management, Awards, Project Portfolio Management (PPM), Project Costing, Project Billing, and Project Accounting, experience supporting grants and sponsored project lifecycles from award setup through billing and reporting, knowledge of Oracle Financials integrations, strong reconciliation and troubleshooting skills, experience with Oracle Integration Cloud (OIC), OTBI, BI Publisher, REST/SOAP integrations, and experience supporting higher education, healthcare, government, research, or other grant-funded environments.

Job Description

We are looking for an Oracle Fusion Grants, Awards, Projects and Project Portfolio Management (PPM) Functional Consultant to support the implementation, enhancement, and ongoing operations of Oracle Fusion Cloud applications while partnering with Finance, Grants Administration, Project Accounting, Procurement, and technical teams to deliver scalable Oracle Fusion solutions. This position will be a full-time contract and hybrid in Arlington Heights, IL.

What You'll Do

Configure and support Oracle Fusion Grants Management functionality

Manage the end-to-end lifecycle of grants, sponsored projects, awards, and funding sources

Support configuration and maintenance of awards, sponsored projects, funding sources, award budgets, award projects, award organizations, funding controls, and award compliance requirements

Support award creation, amendments, funding changes, extensions, and award closeout processes

Work with Grants Administration and Finance teams to ensure expenditures comply with award funding requirements

Troubleshoot issues related to award and project associations, funding controls, costs, accounting, billing, and reporting

Configure and support Oracle Fusion Project Financial Management modules

Maintain and troubleshoot Project Foundation, Project Costing, Project Billing, Project Contracts, Project Control, Project Budgets and Forecasts, and Project Accounting

Support project creation, project templates, organizations, classifications, project types, transaction controls, and project lifecycle activities

Configure and support expenditure types, expenditure categories, transaction sources, document entries, and burdening

Support project budgets, forecasts, funding, cost controls, and financial plans

Analyze project costs and revenue transactions and resolve processing exceptions

Support project cost collection from Oracle Fusion modules and external applications

Analyze transactions from Payables, Procurement, Purchasing, Receiving, General Ledger, and external interfaces

Troubleshoot cost import, cost distribution, accounting, and posting issues

Support Subledger Accounting activities related to project and grant transactions

Assist with reconciliation activities involving Projects, Grants, Payables, Receivables, Procurement, and General Ledger

Configure and support project and award billing processes including contract lines, contract projects, billing plans, revenue plans, invoice generation, and revenue recognition

Troubleshoot billing and revenue generation exceptions

Support integration between Project Billing, Receivables, and General Ledger

Assist Finance teams with billing and revenue reconciliation activities

Configure Oracle Fusion PPM and Grants functionality including Business Units, Project Units, Project Organizations, Project Types, Project Templates, Project Classifications, Project Accounting Rules, Burden Structures, Funding controls, Billing Methods, Revenue Methods, and Financial Plan Types

Evaluate business requirements and recommend solutions using standard Oracle Fusion functionality whenever possible

Partner with integration teams to support Oracle Fusion integrations involving Financials, Procurement, Payables, Receivables, General Ledger, Payroll, Banks, Grants systems, Research Administration systems, and Enterprise Reporting platforms

Support integrations utilizing Oracle Integration Cloud, REST APIs, SOAP APIs, FBDI, ADFdi, ESS processes, BI Publisher, and OTBI

Develop functional requirements for Oracle Fusion reporting solutions

Support OTBI analyses, BI Publisher reports, financial reconciliations, project cost reporting, billing reporting, and award financial reporting

Perform transaction analysis and validate data across application, integration, reporting, and accounting layers

Investigate incidents, perform root cause analysis, resolve transaction processing issues, troubleshoot interfaces, and support accounting and close activities

Support month-end close, quarter-end close, fiscal year-end, grant reporting cycles, award closeouts, and production deployments

Conduct business requirement workshops, fit-gap analysis sessions, solution design activities, configuration, testing, deployment, and post-production support

Support SIT, UAT, defect management, data validation, cutover planning, and hypercare activities

What You'll Need

Required:

Bachelor's degree in Accounting, Finance, Information Systems, Computer Science, Business Administration, or equivalent experience

5+ years of Oracle ERP or Oracle Cloud functional experience

Strong experience with Oracle Fusion Cloud PPM and Project Financial Management

Experience with Oracle Fusion Grants Management and Awards

Strong understanding of project accounting concepts

Experience with Project Costing and related accounting processes

Experience supporting Oracle Fusion Project Billing, Project Contracts, Project Control, and Project Accounting

Knowledge of integrations between Oracle Fusion PPM and Oracle Financials

Experience with configuration, testing, implementation, quarterly releases, upgrades, and production support

Experience gathering requirements and translating business processes into Oracle Fusion solutions

Strong troubleshooting, analytical, and problem-solving skills

Experience supporting end-to-end project and grant transaction lifecycles

Strong communication, workshop facilitation, and stakeholder management skills

Ability to work independently on complex production support and implementation activities

Preferred:

Oracle Fusion Grants Management experience

Oracle Fusion Project Financial Management experience

Project Costing experience

Project Billing experience

Project Contracts experience

Project Control experience

Grants and Awards administration experience

Sponsored project accounting experience

Oracle Fusion Financials experience

General Ledger experience

Accounts Payable experience

Accounts Receivable experience

Procurement experience

Subledger Accounting experience

Experience with OTBI and BI Publisher

Experience with Oracle Integration Cloud

Experience with REST and SOAP integrations

Experience with SQL

Experience supporting Oracle quarterly release testing

Experience supporting higher education, research institutions, healthcare organizations, government organizations, or other grant-funded environments

Physical Demands

Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards

Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

Flexible work from home options available.