Fusion ERP Reporting & Analytics Technical Consultant

Key Responsibilities

• Design, develop, test, and support Oracle Fusion ERP reports and dashboards across Financials, Project Portfolio Management, and Supply Chain business areas.
• Build and enhance BI Publisher reports, including data models, layouts, bursting, parameters, and scheduling.
• Develop and configure OTBI analyses, dashboards, prompts, and subject-area-based reports aligned to business requirements.
• Write, optimize, and troubleshoot SQL queries for reporting, reconciliation, data validation, and performance tuning.
• Gather and analyze business reporting requirements, prepare technical specifications, and convert functional needs into scalable reporting solutions.
• Investigate and resolve reporting issues related to data accuracy, performance, security, integrations, and report output formats.
• Collaborate with functional consultants, business stakeholders, technical teams, and support teams to deliver accurate and meaningful reporting outcomes.
• Develop custom extensions using Oracle Visual Builder Studio and Application Composer where applicable.

Mandatory

• 7+ years of hands-on experience in Oracle Fusion ERP reporting and analytics.
• Strong experience with OTBI, BI Publisher, SQL, dashboards, data models, and report development.
• Solid understanding of Oracle Fusion ERP business processes, especially in Financials.
• Experience working with Financials subject areas and developing reports for modules such as General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cash Management, or related areas.
• Experience supporting reporting needs across Project Portfolio Management and/or Supply Chain business areas.
• Ability to create technical specifications based on business reporting requirements.
• Strong SQL development and troubleshooting skills, including performance tuning.
• Experience with XML, XSLT, JSON, and web services.
• Ability to analyze data issues, validate report outputs, and resolve reporting defects.
• Strong communication skills with the ability to work effectively with functional consultants and business stakeholders.

Career Level - N/A