We are seeking experienced Oracle Cloud Reporting Consultants with expertise in BI Publisher, OTBI (Oracle Transactional Business Intelligence), and Smart View. The role focuses on designing, developing, and supporting enterprise reporting and analytics solutions across Oracle Fusion applications (ERP, HCM, SCM, EPM). · Develop, customize, and maintain reports using: o BI Publisher (BIP) o OTBI (Oracle Transactional BI) o Smart View (Excel-based reporting) · Design and build: o Data models using SQL (Joins, subqueries, aggregations) and data templates o BI Publisher templates (RTF, Excel, XML) · Create OTBI: o Analyses, dashboards, KPIs o Custom subject areas (if applicable) · Develop Smart View reports: o Ad-hoc queries o Financial and management reports · Work with SQL queries for data extraction, Logical and physical data layers · Manage Report security and role-based access, Scheduling and bursting in BI Publisher · Perform Data validation and reconciliation, Performance tuning of reports · Handl
