Oracle OTBI / BI Publisher Consultant

JOB DESCRIPTION
We are seeking an experienced Oracle OTBI / BI Publisher Consultant with strong expertise in developing custom OTBI analyses, dashboards and BI Publisher reports in Oracle Fusion applications. The candidate should have experience in reporting, data modelling, SQL queries and report customization.

Key Responsibilities:

• Design, develop and customize Oracle Transactional Business Intelligence (OTBI) analyses.
  
• Develop interactive dashboards and reports based on business requirements.
  
• Create and maintain BI Publisher (BIP) reports.
  
• Develop data models, data sets and report templates.
  
• Write and optimize SQL queries for reporting requirements.
  
• Work with Oracle Fusion ERP, SCM and HCM reporting requirements.
  
• Perform report testing, validation and troubleshooting.
  
• Enhance existing reports and improve reporting performance.
  
• Work closely with functional teams to understand reporting requirements.
  
• Support report deployment, maintenance and production issues.
  

REQUIREMENTS
Required Skills:

• Strong hands-on experience with Oracle OTBI.
  
• Expertise in BI Publisher (BIP) report development.
  
• Experience creating custom analyses and dashboards.
  
• Strong SQL and data modelling knowledge.
  
• Experience with Oracle Fusion reporting and data structures.
  
• Knowledge of BI Publisher data models, templates and scheduling.
  
• Experience in report customization and performance optimization.
  

Preferred Skills:

• Experience with EBS-to-Oracle Fusion report migration.
  
• Knowledge of Oracle Fusion ERP, SCM and HCM modules.
  
• Experience with Oracle Analytics Cloud (OAC).
  
• Understanding of Oracle Fusion security and reporting roles.
  

Qualifications:
Bachelor's degree in Computer Science, Information Technology or a related field.

Location: PAN India / Remote