Apply now »

Job Title:  Senior Consultant | (BI Reports, OTBI, FRS, SmartView) | Gurugram | Oracle

Job requisition ID ::  106942
Date:  Jun 18, 2026
Location:  Gurugram
Designation:  Senior Consultant
Entity:  Deloitte Touche Tohmatsu India LLP

Position

Senior Consultant – Oracle Fusion BI Publisher (BIP) Reports

Experience

5–8 Years

Location

Gurgaon (Client Office)

Role Overview

We are seeking an experienced Oracle Fusion BI Publisher (BIP) Senior Consultant to design, develop, and support enterprise reporting solutions within Oracle Fusion Cloud applications. The consultant will be responsible for developing operational, statutory, management, and analytical reports using BI Publisher, OTBI, and Fusion reporting tools.

The ideal candidate should have strong expertise in Oracle Fusion data models, SQL, reporting frameworks, and business processes across Finance, Procurement, Projects, SCM, and HCM modules.

Key Responsibilities

Report Development

  • Design, develop, and deploy BI Publisher reports for Oracle Fusion Cloud applications.
  • Create Pixel Perfect reports including:
  • Operational Reports
  • Management Reports
  • Regulatory Reports
  • Audit Reports
  • Invoice and Document Templates
  • Project Reports
  • Develop reports using XML, RTF, Excel, PDF, and eText templates.
  • Create bursting reports for automated distribution to stakeholders.

Data Model Development

  • Design and develop BI Publisher Data Models.
  • Develop SQL queries and datasets using Fusion subject areas and database structures.
  • Create parameter-driven and dynamic reports.
  • Optimize report performance and execution times.
  • Develop data extraction reports for integrations and downstream systems.

Oracle Fusion Reporting

  • Develop reports across:
  • Financials
  • Procurement
  • Project Portfolio Management (PPM)
  • Supply Chain Management (SCM)
  • Human Capital Management (HCM)
  • Configure security and data access controls for reports.
  • Support custom reporting requirements and business analytics.

OTBI & Analytics

  • Develop OTBI analyses and dashboards.
  • Convert OTBI analyses into BI Publisher reports where required.
  • Collaborate with business users to define KPIs and reporting requirements.
  • Support management dashboards and executive reporting.

Integration & Data Extraction

  • Develop extract reports for:
  • Oracle Integration Cloud (OIC)
  • Primavera Unifier
  • Primavera Cloud (OPC)
  • Third-party systems
  • Support file generation in XML, CSV, Excel, PDF, and Text formats.
  • Develop scheduled reporting and automated report delivery mechanisms.

Testing & Support

  • Prepare technical design documents and report specifications.
  • Perform unit testing and support UAT activities.
  • Troubleshoot report issues and optimize performance.
  • Support quarterly Oracle updates and regression testing.

Required Skills

Oracle Fusion Reporting

  • 5–8 years of Oracle reporting experience.
  • Minimum 3 years of Oracle Fusion BI Publisher experience.
  • Experience in at least 2–3 Oracle Fusion implementation projects.
  • Strong expertise in:
  • BI Publisher (BIP)
  • OTBI
  • Financial Reporting Center (FRC)
  • Smart View

Technical Skills

  • Strong SQL and query-writing skills.
  • Experience with:
  • XML Publisher
  • Data Models
  • RTF Templates
  • Excel Templates
  • eText Templates
  • Bursting Controls
  • Scheduler Jobs
  • Knowledge of XML, XSD, XPath, and XSLT.
  • Understanding of Fusion Security and Role-Based Access Controls (RBAC).

Functional Exposure

Experience supporting reporting requirements across:

  • General Ledger (GL)
  • Accounts Payable (AP)
  • Accounts Receivable (AR)
  • Fixed Assets (FA)
  • Cash Management (CM)
  • Procurement
  • Project Costing
  • Project Billing
  • Contracts
  • SCM
  • HCM

Preferred Skills

  • Experience with Oracle Primavera Unifier reporting and integrations.
  • Experience supporting Oracle Primavera Cloud (OPC) reporting requirements.
  • Knowledge of Oracle Integration Cloud (OIC).
  • Experience in data migration and reconciliation reporting.
  • Exposure to Oracle Analytics Cloud (OAC) is an advantage.
  • Experience in EPC, Infrastructure, Utilities, Construction, or Water Industry projects.

Qualifications

  • Bachelor's Degree in Engineering, Computer Science, Information Technology, Commerce, or related discipline.
  • Oracle BI Publisher and Oracle Fusion certifications preferred.

Key Competencies

  • Strong analytical and reporting skills.
  • Excellent SQL troubleshooting and optimization capabilities.
  • Strong communication and client-facing skills.
  • Ability to independently manage reporting workstreams.
  • Strong documentation and requirement-gathering abilities.
  • Experience mentoring junior consultants and developers.

Apply now »