Oracle Fusion Grants, Awards, Projects and Project Portfolio Management (PPM) Functional Consultant

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.
Interview process: 1 Panel Interview - Technical interview and social with 2 additional individuals

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