- Hands-on expertise with Oracle Business Intelligence Applications (OBIA) including dashboards, data visualization, and data flows
- Hands-on expertise with Oracle Analytics Cloud (OAC) including dashboards, data visualization, and data flows
- Experience with RPD development (logical, physical, presentation layers)
- Investigate performance issues related to reports, queries, agents, and data refresh jobs.
- Perform root cause analysis (RCA) and ensure permanent fixes and preventive measures.
- Design and develop Oracle BI Publisher (BIP) and OTBI reports/dashboards to meet functional and regulatory reporting requirements.
- Translate business requirements into data models, SQL queries, and report layouts, ensuring accuracy, usability, and performance.
- Build and maintain data models, templates (RTF/Excel/XSL), bursting definitions,
and subject areas aligned with Oracle Fusion data structures.
- Optimize reports for performance and scalability, including query tuning, parameterization, and efficient data set design.
- Implement and maintain security, row-level data access, and report scheduling/bursting in line with organizational policies.
- Provide production support, root-cause analysis, and enhancements for existing BIP/OTBI reports, including documentation and user guidance.
- Understanding of dimensional modelling
- Ability to design secure subject areas and implement row-level security
- Experience troubleshooting and optimizing OAC/OBIEE performance
- Solid communication skills to translate business needs into analytics solutions.
📌 ERP Specialist (Noida)
🏢 NTT
📍 Noida