Oracle Cloud BI & OTBI Specialist

Key Responsibilities

Lead the implementation and support of Oracle Cloud projects, focusing on SCM, OM, and Finance modules.

Develop and maintain Oracle BI & OTBI reports, dashboards, and data models, including drill-down hierarchies and deep links.

Configure Value Sets, Personalization, report scheduling, and BI Publisher security roles.

Design, create, and modify reports using BI Publisher with Excel, RTF, and online templates.

Perform performance tuning of BI Publisher reports to optimize system functionality.

Execute advanced SQL queries and utilize RDBMS skills to extract, manipulate, and validate data.

Collaborate with project teams and clients to assess business needs and deliver customized reporting solutions.

Test system changes thoroughly including unit testing, integration testing, and performance testing.

Support data loading using Oracle Cloud tools such as HDL, PBL, and Extracts.

Ensure high-quality deliverables and maintain documentation for system changes, reports, and dashboards.

Stay updated with Oracle SaaS technical features including Security, Workflow, Fast Formula, BI & OTBI, Value Sets, UDTs, and Personalization.