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 productive 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 Data
📍 Noida