Oracle EPM / BI Consultant

Srinav; Hyderabad, Chennai District, Bengaluru; Hybrid; INR 1,800,000 - 2,400,000; Full time

Job summary

Srinav in India is seeking an experienced Oracle EPM / BI Consultant to design, implement and support budgeting, forecasting and reporting solutions within the Oracle stack. You will leverage Hyperion Planning, Essbase, ODI and OAS to deliver scalable analytics for Finance and IT stakeholders.

Key attributes include 10+ years in IT, strong SQL/PLSQL, and the ability to translate business needs into technical design.

Qualifications

• Proficient in Hyperion Planning, Essbase, ODI and OAS with hands-on implementation experience.
• Strong SQL/PLSQL development and Oracle database knowledge.
• Experience translating business requirements into technical solutions for budgeting, forecasting and reporting.
• Ability to work with Finance and IT stakeholders in complex environments.

Responsibilities

• Support and maintain Oracle EPM and BI applications.
• Develop and enhance Hyperion Planning and Essbase solutions.
• Develop and maintain Essbase Business Rules and Calculation Scripts.
• Design, develop and maintain ODI mappings, packages, variables and scenarios.
• Develop and maintain OAS dashboards and reports.
• Perform Oracle database query optimization and performance tuning.
• Collaborate with Finance, Controlling and IT teams to deliver improvements.

Skills

Hyperion Planning

Essbase

ODI

OAS

Advanced SQL

PL/SQL

Oracle Database

Business Rules

Essbase Calculation Scripts

Metadata & Dimension Management

Smart View

Dashboard & Reporting

Education

Bachelor's or Master's degree in Computer Science, Engineering or a related field

Job description

Job Title: Oracle EPM / BI Consultant

Position: Senior Consultant

Job Location: Bangalore / Chennai / Hyderabad

Work Mode: Hybrid

Employment Type: Full Time / Permanent

Job Description

We are looking for an experienced Oracle EPM / BI Consultant with strong hands-on expertise in Hyperion Planning, Essbase, ODI, Oracle Analytics Server (OAS), Oracle SQL and PL/SQL.

The consultant will be responsible for supporting and enhancing budgeting, forecasting, reporting and management control applications within the Oracle ecosystem and will work closely with both Finance and IT stakeholders.

Key Responsibilities

• Support and maintain Oracle EPM and BI applications.
• Develop and enhance Hyperion Planning and Essbase solutions.
• Develop and maintain Essbase Business Rules and Calculation Scripts.
• Perform metadata and dimension management.
• Support data loading processes and Smart View.
• Design, develop and maintain ODI mappings, packages, variables and scenarios.
• Monitor and troubleshoot ODI data integration processes.
• Develop and maintain Oracle Analytics Server (OAS) dashboards and reports.
• Develop and optimize complex SQL and PL/SQL components.
• Perform Oracle database query optimization and performance tuning.
• Analyze functional and technical issues and identify root causes of data discrepancies.
• Support Finance users during budgeting, forecasting and reporting cycles.
• Translate business requirements into functional and technical solutions.
• Work closely with Finance, Controlling and IT teams.
• Contribute to application enhancements and continuous improvement initiatives.

Mandatory Technical Skills

• Hyperion Planning
• Essbase
• Oracle Data Integrator (ODI)
• Oracle Analytics Server (OAS)
• Advanced SQL
• PL/SQL
• Oracle Database
• Business Rules
• Essbase Calculation Scripts
• Metadata & Dimension Management
• Smart View
• Dashboard & Reporting

Functional / Domain Skills

• Finance
• Budgeting
• Forecasting
• Management Reporting
• Financial Planning
• Controlling
• Finance & IT stakeholder management

Candidate Profile

• 10+ years of overall IT experience.
• Strong hands-on experience in Oracle EPM / BI environments.
• Proven experience with Hyperion Planning, Essbase, ODI and OAS.
• Strong SQL and PL/SQL development experience.
• Good understanding of Finance, Budgeting and Forecasting processes.
• Strong analytical, troubleshooting and problem-solving skills.
• Excellent communication and stakeholder management skills.
• Ability to work independently and bridge business and technical teams.
• Bachelor's or Master's degree in Computer Science, Engineering or a related field.

Key Skills

Oracle EPM | Hyperion Planning | Essbase | ODI | Oracle Data Integrator | OAS | Oracle Analytics Server | SQL | PL/SQL | Oracle Database | Business Rules | Calculation Scripts | Smart View | Budgeting | Forecasting | Finance | Controlling | Reporting | AnalyticsRole & responsibilities