Contract Position Oracle Functional Specialist - Reporting

People Prime Worldwide; Hyderabad; Hybrid; INR 2,000,000 - 3,500,000; Full time

Job summary

People Prime Worldwide is seeking an Oracle Fusion Reporting Consultant for a hybrid role in India. The candidate will lead reporting initiatives across FI, HCM, Payroll, and other modules, delivering BI Publisher and OTBI solutions with strong SQL/PLSQL.

You will gather business requirements, design reporting solutions, optimize performance, and provide production support, collaborating with stakeholders and global teams on complex financial and management reports.

Qualifications

• 8+ years of experience in Oracle Fusion Reporting, with strong expertise in BI Publisher, OTBI, SQL/PLSQL, Financial Reporting Studio (FSR/FRS), and Oracle reporting solutions.
• Proven experience in multiple end-to-end Oracle Fusion implementation and support projects, delivering reporting solutions across Finance, HCM, Payroll, SCM, and PPM.
• Strong hands‑on experience in developing BI Publisher reports, including Data Models, SQL, Layouts, Bursting, Event Triggers, Security, and Performance Optimization.
• Expertise in OTBI report and dashboard development, including cross-subject area reporting, Request Variables, Deep Links, DFF enablement, and security.
• Strong SQL/PLSQL skills with the ability to develop, optimize, and troubleshoot complex queries for reporting and data analysis.
• Experience in developing and supporting Financial Reporting Studio (FSR) reports, financial statements, management reports, and executive dashboards.
• Good understanding of the Oracle Fusion data model, reporting security, Descriptive Flexfields (DFFs), and integrations across Oracle Fusion modules.
• Ability to gather and analyze business reporting requirements, design reporting solutions, troubleshoot reporting issues, and provide production support.
• Excellent communication and stakeholder management skills, with the ability to engage directly with business users, functional consultants, and client leadership.

Responsibilities

• Develop BI Publisher reports including Data Models, SQL layouts and bursting.
• Develop OTBI reports and dashboards including cross-subject area reporting.
• Develop and optimize SQL/PLSQL queries for reporting and data analysis.
• Develop and support Financial Reporting Studio (FSR) reports and executive dashboards.
• Gather and analyze business reporting requirements and provide production support.
• Engage with stakeholders and manage client communications.

Skills

Oracle Fusion Reporting

BI Publisher

OTBI

SQL/PLSQL

Descriptive Flexfields (DFFs)

Reporting security

Stakeholder management

Communication skills

Tools

FSR/FRS

Data Models

Bursting

Event Triggers

Security

Job description

Job Description

Our client is a trusted global innovator of IT and business services. They help clients transform through consulting, industry solutions, business process services, digital & IT modernization and managed services. Our client enables them, as well as society, to move confidently into the digital future. We are committed to our clients long-term success and combine global reach with local client attention to serve them in over 50 countries around the globe.

Job Title: Oracle Fusion Reporting Consultant

Location: Pan India

Experience: 8+ yrs.

Employment Type: Contract to hire

Work Mode: Hybrid

Notice Period: - Immediate joiners

Roles & Responsibilities

POSITION OVERVIEW

Oracle Fusion Reporting Consultant

Key Requirements

• 8+ years of experience in Oracle Fusion Reporting, with strong expertise in BI Publisher, OTBI, SQL/PLSQL, Financial Reporting Studio (FSR/FRS), and Oracle reporting solutions.
• Proven experience in multiple end-to-end Oracle Fusion implementation and support projects, delivering reporting solutions across Finance, HCM, Payroll, SCM, and PPM.
• Strong hands‑on experience in developing BI Publisher reports, including Data Models, SQL, Layouts, Bursting, Event Triggers, Security, and Performance Optimization.
• Expertise in OTBI report and dashboard development, including cross-subject area reporting, Request Variables, Deep Links, DFF enablement, and security.
• Strong SQL/PLSQL skills with the ability to develop, optimize, and troubleshoot complex queries for reporting and data analysis.
• Experience in developing and supporting Financial Reporting Studio (FSR) reports, financial statements, management reports, and executive dashboards.
• Good understanding of the Oracle Fusion data model, reporting security, Descriptive Flexfields (DFFs), and integrations across Oracle Fusion modules.
• Ability to gather and analyze business reporting requirements, design reporting solutions, troubleshoot reporting issues, and provide production support.
• Excellent communication and stakeholder management skills, with the ability to engage directly with business users, functional consultants, and client leadership.
• Willingness to work in the UK shift and support business‑critical reporting activities.