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

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

Required:

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

Required Skills:

Oracle Fusion Cloud functionalOracle Fusion Grants ManagementAwardsProject Portfolio Management (PPM)Project CostingProject BillingProject AccountingOracle Financials integrationsracle Integration Cloud (OIC)OTBIBI PublisherREST/SOAP integrationsSQL