Job Summary:
The Oracle Functional Consultant will lead functional analysis, design, testing, and support for Oracle EBS Projects, Fixed Assets, and Payables modules. The role requires hands-on Oracle Fixed Assets implementation experience and strong knowledge of Oracle Projects, including Project Accounting, capital project lifecycle management, asset capitalization, and construction-in-progress (CIP) processes. The consultant will support end-to-end financial processes, reporting, reconciliations, integrations, and production activities while collaborating with Finance, Accounting, IT, and business stakeholders.
Key Responsibilities:
• Lead functional analysis, design, testing, and support for Oracle EBS Projects, Fixed Assets, and Payables modules.
• Serve as the subject matter expert for Project Accounting, capital project lifecycle management, asset capitalization, CIP processes, and Fixed Asset accounting.
• Analyze and resolve end-to-end process issues across Oracle Projects, Payables, Fixed Assets, General Ledger, and integrated boundary systems.
• Support project-to-asset capitalization flows, including Generate Asset Lines, Interface Assets, Mass Additions, and asset creation processes.
• Work closely with business stakeholders to gather requirements, document functional designs, and support UAT and production deployments.
• Validate accounting flows, reconciliation processes, month-end close activities, and subledger-to-GL integrations.
• Partner with technical teams to identify root causes and implement solutions for reporting and data-related issues.
• Support defect triage, production support, hypercare activities, and continuous process improvements.
• Support project cost collection, capitalization, asset additions, transfers, retirements, adjustments, and depreciation processes.
• Support AP-to-Projects and Projects-to-Fixed Assets integration flows.
• Work with POET accounting structures and project-related invoice processing.
• Support month-end and year-end financial close activities.
• Analyze and troubleshoot Oracle Analytics Server (OAS) reports, dashboards, and data validation issues.
• Perform Oracle BI Repository (RPD) development and maintenance.
• Analyze backend Oracle EBS tables, views, and data relationships supporting Projects, Fixed Assets, Payables, and GL reporting.
• Perform data lineage analysis from Oracle transactional tables through OAS reporting layers.
• Validate financial data across Oracle EBS modules using SQL.
• Reconcile transactional data, identify data discrepancies, and support report validation.
• Collaborate with Finance, Accounting, IT, and external vendors to resolve functional and technical issues.
Required Qualifications:
• 8+ years of Oracle EBS functional consulting experience.
• Hands-on Oracle Fixed Assets implementation experience.
• Strong functional knowledge of Oracle Projects (PA), Fixed Assets (FA), Payables (AP), and General Ledger (GL).
• Deep understanding of Project Accounting, project cost collection, capitalization, asset additions, transfers, retirements, adjustments, and depreciation processes.
• Experience with AP-to-Projects and Projects-to-Fixed Assets integration flows.
• Strong understanding of POET accounting structures and project-related invoice processing.
• Experience supporting month-end and year-end financial close activities.
• Strong experience with Oracle Analytics Server (OAS) reporting solutions.
• Hands-on knowledge of Oracle BI Repository (RPD) development and maintenance.
• Strong SQL skills and ability to validate financial data across Oracle EBS modules.
• Understanding of Oracle EBS data models, interfaces, and integration architecture.
• Ability to analyze backend Oracle EBS tables, views, and data relationships.
• Strong analytical and problem-solving skills, including data reconciliation and discrepancy resolution.
• Excellent communication skills and ability to work directly with business and executive stakeholders.
Preferred Qualifications:
• Experience supporting large-scale finance transformation or ERP modernization initiatives.
• Experience with Oracle Fixed Assets enhancements or migrations.
• Experience supporting OAS reporting environments and Oracle BI Repository development.
• Experience with Oracle Cloud Financials.
• Knowledge of Oracle BI Publisher, ODI, and data warehouse reporting solutions.
• Experience supporting audit, compliance, and reconciliation reporting requirements.
• Experience in airline, transportation, or large enterprise finance systems.
Key Requirement: Candidates must have hands-on Oracle Fixed Assets implementation experience along with strong Oracle Projects knowledge. General Oracle experience alone will not be sufficient.
