Oracle Fusion Grants Awards Projects and Project Portfolio Mgmt

DEW Softech Inc•Chicago, IL

9d•Hybrid

About The Position

The Oracle Fusion Grants, Awards, Projects and Project Portfolio Management (PPM) Functional Consultant supports implementation, enhancement, and ongoing operations of Oracle Fusion Cloud applications. The consultant partners with Finance, Grants Administration, Project Accounting, Procurement, and technical teams to deliver scalable Oracle Fusion solutions. This is a full-time contract position with a hybrid work arrangement in Arlington Heights, Illinois, for a duration of 8+ months. The role supports the end-to-end lifecycle of grants, sponsored projects, awards, funding sources, project financial management, costing, billing, contracts, controls, budgets, forecasts, and project accounting. It also involves configuration, integration and reporting support, transaction analysis, reconciliation, troubleshooting, implementation activities, testing, deployment, production support, and financial close and grant reporting cycles.

Requirements

Bachelor's degree in Accounting, Finance, Information Systems, Computer Science, Business Administration, or equivalent experience.
At least 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.

Nice To Haves

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.

Responsibilities

Configure and support Oracle Fusion Grants Management functionality and manage grants, sponsored projects, awards, and funding sources throughout their lifecycles.
Maintain and support award setup, budgets, projects, organizations, funding controls, compliance requirements, amendments, funding changes, extensions, and closeouts.
Work with Grants Administration and Finance to help ensure expenditures comply with award funding requirements.
Troubleshoot award and project associations, funding controls, costs, accounting, billing, and reporting issues.
Configure and support Oracle Fusion Project Financial Management, including Project Foundation, Project Costing, Project Billing, Project Contracts, Project Control, Project Budgets and Forecasts, and Project Accounting.
Support project creation, templates, organizations, classifications, types, transaction controls, and lifecycle activities.
Configure expenditure types, expenditure categories, transaction sources, document entries, and burdening; support budgets, forecasts, funding, cost controls, and financial plans.
Analyze project cost and revenue transactions, resolve processing exceptions, and 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, distribution, accounting, and posting issues.
Support Subledger Accounting activities for project and grant transactions and reconcile Projects, Grants, Payables, Receivables, Procurement, and General Ledger.
Configure and support project and award billing, including contract lines, contract projects, billing plans, revenue plans, invoice generation, and revenue recognition.
Troubleshoot billing and revenue generation exceptions and support integrations between Project Billing, Receivables, and General Ledger.
Assist Finance teams with billing and revenue reconciliation.
Configure Oracle Fusion PPM and Grants components, including business units, project units and organizations, project types and templates, classifications, accounting rules, burden structures, funding controls, billing and revenue methods, and financial plan types.
Evaluate business requirements and recommend solutions using standard Oracle Fusion functionality where possible.
Partner with integration teams to support integrations involving Financials, Procurement, Payables, Receivables, General Ledger, Payroll, Banks, Grants systems, Research Administration systems, and enterprise reporting platforms.
Support integrations using Oracle Integration Cloud, REST and SOAP APIs, FBDI, ADFdi, ESS processes, BI Publisher, and OTBI.
Develop functional requirements for Oracle Fusion reporting solutions and support OTBI analyses, BI Publisher reports, reconciliations, project cost reporting, billing reporting, and award financial reporting.
Analyze transactions 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, quarter-end, and fiscal year-end close; grant reporting cycles; award closeouts; and production deployments.
Conduct requirements workshops, fit-gap analysis, solution design, configuration, testing, deployment, and post-production support.
Support SIT, UAT, defect management, data validation, cutover planning, and hypercare activities.