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

Deloitte.

Be audacious in impact

When was the last time you thought the unthinkable defined the unfathomable or did what no one else has dared to try

At Deloitte were creating bold new frontiers for our clients and communities. Our roar echoes across India and beyond. So bring your unique self and rise louder and leap further than ever before.

Senior Consultant BI Reports I Gurugram Oracle

• Job requisition ID: 106942
• Location: Gurugram
• Entity: Deloitte Touche Tohmatsu India LLP

The team

Enterprise technology must do much more than keep the wheels turning; it is the engine that drives functional excellence and the enabler of innovation and long-term growth. Learn more about ET&P

Your work profile

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.

Key Skills Required

Oracle Fusion Reporting

• 58 years of Oracle reporting experience.
• Minimum 3 years of Oracle Fusion BI Publisher experience.
• Experience in at least 23 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

• Bachelors 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.