Oracle Functional Consultant

Fusion ERP Reporting & Analytics Technical Consultant

About Oracle Customer Success Services

Oracle Customer Success Services is a One Oracle approach to helping customers achieve long-term success through a broad portfolio of services and solutions. Supported by certified and experienced implementers, the team helps accelerate the customer journey by combining customer-centric delivery with support-integrated services in close collaboration with Oracle Development.

Within Customer Success Services, this role supports Oracle Fusion ERP customers by delivering reliable, scalable, and meaningful reporting and analytics solutions across key business areas such as Financials, Project Portfolio Management, and Supply Chain.

Job Summary

We are looking for a skilled Fusion ERP Reporting & Analytics Consultant with 7+ years of experience in Oracle Fusion reporting and analytics. The role is responsible for designing, developing, testing, troubleshooting, and supporting reports, dashboards, data models, and analytics solutions across Oracle Fusion ERP modules.

The ideal candidate will bring strong hands-on expertise in OTBI, BI Publisher, SQL, Financials subject areas, dashboards, data models, and report development, along with the ability to translate business reporting needs into accurate, high-performing, and user-friendly analytics solutions.

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.

Qualifications & Skills

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.

Good-to-Have

• Experience with Oracle Visual Builder Studio and Application Composer for custom extensions.
• Experience with report migration, security configuration, role-based access, and production support.
• Familiarity with ERP integrations and downstream reporting dependencies.
• Oracle Fusion ERP or reporting-related certifications.
• Experience working in customer-facing consulting, managed services, or support-integrated delivery environments.

Self-Assessment Questions

• Do you have 7+ years of hands-on experience designing and developing reports in Oracle Fusion ERP
• Have you independently built BI Publisher reports, OTBI dashboards, SQL-based data models, and reporting layouts
• Can you troubleshoot report performance, data accuracy, subject area, and SQL issues across Fusion ERP modules
• Have you worked on reporting requirements for Oracle Fusion Financials, and preferably PPM or Supply Chain
• Are you comfortable working directly with business stakeholders and functional consultants to translate reporting needs into technical solutions