Oracle OTBI Reporting Consultant

WillWare Technologies; Hyderabad; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

WillWare Technologies in Hyderabad is seeking an experienced Oracle OTBI Reporting Consultant to lead OTBI reporting activities for Oracle Fusion Cloud implementations. You will deliver analyses, dashboards, prompts, and role-based reports while ensuring data accuracy and alignment with business requirements.

You will collaborate with functional and technical teams across SIT/UAT, regression testing, cutover, and go-live to ensure successful deployment and hypercare support.

Qualifications

• Minimum 7+ years of Oracle reporting/analytics experience with hands-on Oracle Fusion OTBI implementation exposure.
• Strong OTBI report development using analyses, dashboards, subject areas, filters, prompts, calculated fields, views, and drill-downs
• Experience in Oracle Fusion Cloud reporting for Finance, Projects/PPM or related modules
• Ability to understand business reporting requirements and translate them into report specifications, data mapping, and validated report outputs
• Experience in report validation, reconciliation, performance review, catalog migration, folder security, and role-based access setup
• Ability to prepare report inventory, functional/technical specifications, unit test evidence, user guides, and reporting deployment documents
• Experience working with testers for SIT, UAT, regression testing, defect analysis, retesting, and closure
• Good communication skills, stakeholder coordination, analytical thinking, attention to detail, and ownership of reporting deliverables

Responsibilities

• Lead OTBI reporting activities for Oracle Fusion Cloud implementation and reporting workstreams.
• Conduct report requirement workshops and convert business requirements into report specifications, data mapping, and build approach.
• Develop OTBI analyses, dashboards, prompts, filters, calculated measures, views, drill-down reports, and role-based reporting folders.
• Work with functional consultants to understand business processes, source transactions, subject areas, data definitions, and validation rules.
• Support BI Publisher reporting where required, including data model design, RTF template layout, scheduling, bursting, and output validation.
• Configure and validate catalog folders, permissions, role-based access, report migration, and environment-specific reporting setup.
• Support SIT, UAT, regression testing, cutover, go-live, and hypercare; coordinate with testers for test execution, defect analysis, retesting, and closure.
• Validate report outputs against transactional data and support reconciliation with business users and functional teams.
• Prepare report inventory, design documents, unit test documents, user guides, deployment notes, and knowledge transition materials.
• Provide regular status updates and participate in report walkthroughs, defect review meetings, and project governance discussions

Skills

OTBI reporting

SQL

PL/SQL

BI Publisher

Oracle Fusion

Data mapping

Dashboard development

Role-based reporting

Tools

BI Publisher

Job description

Role Descriptions: Oracle OTBI Reporting Consultant

~HYDERABAD~

SNo Required Information Details

• 1 Role Oracle OTBI Reporting Consultant with strong reporting, analytics, and implementation experience across Oracle Fusion Cloud applications

2 Required Skill Set

• Hands-on implementation experience in Oracle Transactional Business Intelligence (OTBI) reporting in both standard and custom
• Experience in developing OTBI analyses, dashboards, prompts, filters, views, drill-downs, and role-based reporting
• Strong understanding of Oracle Fusion subject areas across ERP, PPM, Finance or related modules
• Must have experience in SQL, PLSQL, Implementation and Enhancement activities.
• Experience in report requirement gathering, report design, data mapping, report build, unit testing, and business validation
• Experience in BI Publisher reports, data models, RTF templates, bursting, scheduling, and report migration is preferred
• Experience in Oracle security, roles, data access, folder permissions, catalog migration, and report access troubleshooting
• Ability to validate report output with source transactions and reconcile report data with business expectations
• Ability to work with functional consultants, technical teams, and testers across SIT, UAT, regression testing, cutover, go-live, and hypercare

3 No. of Requirements 3

3

4 Desired Experience Range Minimum 7+ years

Minimum 7+ years

Desired Competencies (Technical/Behavioral Competency)

Must-Have

• Minimum 7+ years of Oracle reporting/analytics experience with hands-on Oracle Fusion OTBI implementation exposure
• Strong experience in OTBI report development using analyses, dashboards, subject areas, filters, prompts, calculated fields, views, and drill-downs
• Experience in Oracle Fusion Cloud reporting for one or more areas such as Finance, Projects/PPM or related modules
• Ability to understand business reporting requirements and translate them into report specifications, data mapping, and validated report outputs
• Experience in report validation, reconciliation, performance review, catalog migration, folder security, and role-based access setup
• Ability to prepare report inventory, functional/technical specifications, unit test evidence, user guides, and reporting deployment documents
• Experience working with testers for SIT, UAT, regression testing, defect analysis, retesting, and closure
• Good communication skills, stakeholder coordination, analytical thinking, attention to detail, and ownership of reporting deliverables

Good-to-Have

• Oracle Fusion Cloud reporting or analytics certification
• BI Publisher development experience including data models, RTF templates, bursting, scheduling, and parameterized reports
• Knowledge of Oracle Fusion SQL, OTBI subject area joins, BI catalog administration, and report migration between environments
• Experience with Agile delivery models, global implementation projects, and cross-module reporting requirements

Role descriptions / Expectations from the Role

• Lead OTBI reporting activities for Oracle Fusion Cloud implementation and reporting workstreams.
• Conduct report requirement workshops and convert business requirements into report specifications, data mapping, and build approach.
• Develop OTBI analyses, dashboards, prompts, filters, calculated measures, views, drill-down reports, and role-based reporting folders.
• Work with functional consultants to understand business processes, source transactions, subject areas, data definitions, and validation rules.
• Support BI Publisher reporting where required, including data model design, RTF template layout, scheduling, bursting, and output validation.
• Configure and validate catalog folders, permissions, role-based access, report migration, and environment-specific reporting setup.
• Support SIT, UAT, regression testing, cutover, go-live, and hypercare; coordinate with testers for test execution, defect analysis, retesting, and closure.
• Validate report outputs against transactional data and support reconciliation with business users and functional teams.
• Prepare report inventory, design documents, unit test documents, user guides, deployment notes, and knowledge transition materials.
• Provide regular status updates and participate in report walkthroughs, defect review meetings, and project governance discussions.