ERP Specialist

• 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

·       Strong communication skills to translate business needs into analytics solutions.