Position: Oracle Functional Consultant Projects, Fixed Assets & OAS Reporting
Location: Remote/Occasional Travel to client place
Duration: Long term contract
Experience: 15+ Years
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 spanning 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.
Oracle Functional Expertise
- Strong knowledge of Oracle Projects (PA), Fixed Assets (FA), Payables (AP), and General Ledger (GL).
- Deep understanding of project cost collection, capitalization, asset additions, transfers, retirements, adjustments, and depreciation processes.
- Experience with AP-to-Projects and Projects-to-Fixed Assets integration flows.
- Understanding of POET accounting structure and project-related invoice processing.
- Experience supporting month-end and year-end financial close activities.
Reporting & Analytics Expertise
- Strong experience with Oracle Analytics Server (OAS) reporting solutions.
- Ability to analyze and troubleshoot OAS reports, dashboards, and data validation issues.
- Hands-on knowledge of Oracle BI Repository (RPD) development and maintenance.
- Strong understanding of backend Oracle EBS tables, views, and data relationships supporting Projects, Fixed Assets, Payables, and GL reporting.
- Ability to perform data lineage analysis from Oracle transactional tables through OAS reporting layers.
Technical & Analytical Skills
- Strong SQL skills and ability to validate financial data across Oracle EBS modules.
- Understanding of Oracle EBS data model, interfaces, and integration architecture.
- Ability to reconcile transactional data, identify data discrepancies, and support report validation.
- Experience working with cross-functional teams including Finance, Accounting, IT, and external vendors.
Preferred Qualifications
- 8+ years of Oracle EBS functional consulting experience.
- Experience supporting large-scale finance transformation or ERP modernization initiatives.
- Prior experience with Oracle Fixed Assets implementations, enhancements, or migrations.
- Experience supporting OAS reporting environments and Oracle BI repository development.
- Strong communication skills with the ability to work directly with business and executive stakeholders.
Nice to Have
- Experience with Oracle Cloud Financials.
- Knowledge of Oracle BI Publisher, ODI, and data warehouse reporting solutions.
- Experience supporting audit, compliance, and reconciliation reporting requirements.
- Airline, transportation, or large enterprise finance systems experience.