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.