Hyperion ESSBase - Techno Functional

Job Title: Hyperion ESSBASE - Techno Functional
Experience: 8+ years of experience
Job location: Bangalore / Chennai
Position ID: J0626-2577
Work Type: Hybrid
Employment Type: Full Time / Permanent
Qualification: Bachelors or Masters degree in Computer Science, Engineering, or a related field.

Oracle Hyperion Essbase (Essbase 21c) & Smart View Skills
• Outline & Hierarchy Management: Ability to manage, build, and modify sparse/dense dimensions
• Calculation Scripting: Expertise in writing, debugging, and validating complex calculation scripts
• UDA & Substitution Variables: Proficiency in using User-Defined Attributes (UDAs) and substitution variables
• MaxL Scripting: Ability to write and run MaxL commands to automate administrative tasks
• Smart View Proficiency: Ability to leverage Smart View to support business users

JET Administration
• Task Automation & Configuration: Ability to manage JET task lists, connections, and actions
• Variable & Parameter Customization: Knowledge of creating and configuring JET variables

Database & SQL Proficiency
• SQL Transformations: Ability to write SQL queries

Cloud & Infrastructure (AWS & Linux Server Administration)
• AWS Console & Services: Familiarity with AWS Accounts, S3 buckets (for storing, replicating, and restoring backup files across environments)
• Linux Server Administration

Functional Financial
• Financial Controlling Lifecycles: Understanding of standard controlling processes: Actuals, Budget, Forecast, and LTP

Support, Governance & User Provisioning
• Security Filter Administration: Managing and updating user group security in Shared Services and assigning activity-based write/read restrictions.