Job: Oracle Fusion Grants, Awards, Projects - (PPM) Functional Consultant Location (if onsite/hybrid): Candidates must be local to Arlington Heights, IL and be willing to go onsite to client office three times per week. Expected duration: 8 months from candidate's start date
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
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
