Fusion ERP Reporting & Analytics Technical Consultant

Oracle; Bengaluru; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

Oracle in Bengaluru, India seeks a skilled Fusion ERP Reporting & Analytics Consultant with 7+ years of experience to design, develop, test, and support reports, dashboards, data models, and analytics across Fusion ERP modules. The role requires hands-on OTBI, BI Publisher, SQL, and strong knowledge of Financials with capability to translate business needs into high-performing analytics solutions.

You will collaborate with functional consultants and stakeholders to deliver valuable reporting

Qualifications

• 7+ years of hands-on 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 Financials.
• Experience with Financials modules such as General Ledger, AP, AR, Fixed Assets, Cash Management.
• Experience supporting reporting for PPM and/or Supply Chain.

Responsibilities

• Design, develop, test, and support Oracle Fusion ERP reports and dashboards across Financials, PPM, and SCM.
• Build and enhance BI Publisher reports, data models, layouts, bursting, parameters, and scheduling.
• Develop OTBI analyses, dashboards, prompts, and subject-area reports per requirements.
• Write, optimize, and troubleshoot SQL queries for reporting and performance tuning.
• Gather reporting requirements, prepare specifications, and convert needs into scalable solutions.
• Investigate and resolve reporting issues related to data accuracy, performance, and security.
• Collaborate with stakeholders and technical teams to deliver meaningful reporting outcomes.
• Develop custom extensions using Oracle Visual Builder Studio and Application Composer where applicable.

Skills

OTBI

BI Publisher

SQL

Dashboards

Data models

Report development

Oracle Fusion ERP

Tools

XML

XSLT

JSON

Web services

Job description

Job Description

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.

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 Qualifications

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

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.