14 January, 2019
Job ID : 20190114001
Company : Prolifics
Job Role : Sr. Essbase Hyperion DBA
Eligibility : Graduate
Experience : 8-10 Years
Job Location : Hyderabad
Salary : Not Mentioned
Vacancies : Not Mentioned
Website : www.prolifics.com
Must have worked as a Hyperion Administrator for Essbase, Planning, and Financial Reports and have experience supporting a global business community.
Must demonstrate technical knowledge of Essbase best practices in application design and deployment.
Proven ability to transform a complex set of business requirements into intuitive, scalable Essbase and Planning applications to solve business problems.
Proficient use of Smart View Excel Add-in including VBA programming in conjunction with data from Hyperion.
Proficient use of SQL scripts and batch automation scripts (MaxL and MSH).
Design, develop and deploy enterprise scale Essbase applications to meet ad hoc analysis and reporting needs based on business requirements.
Provide technical support for Essbase Administration Services (EAS), Hyperion Shared Services, Financial Reporting Studio, and Hyperion Workspace.
Develop and maintain Essbase Outlines, Calculation Scripts, Dimension Builds, Data Loads, Report Scripts, and Batch Automation Scripts (MaxL and MSH).
Perform Essbase data loads from disparate data sources including data validation and discrepancy correction.
Develop and maintain SQL scripts to facilitate data staging and loading.
Responsible for managing and monitoring Hyperion load process (ad hoc requests and nightly scheduled loads) and addressing load issues.
Perform exports of Essbase data to downstream applications & databases.
Thorough understanding of Dense/Sparse settings, dynamic calculations, and development best practices for Essbase Outlines.
Technical Knowledge of Outline development functionality such as Attribute Dimensions, User Defined Attributes (UDAs), Substitution Variables, Aggregate Storage (ASO), and Block Storage (BSO).
Optimize and tune Essbase applications to enhance performance for data loads, aggregations & calculations, and data retrievals.
Manage Security Provisioning by maintaining users, user groups, and access security privileges.
Provide support for the Smart View Excel Add-in including VBA programming.
Develop Planning & Forecasting applications and maintain business rule logic and web forms.
Design, develop, and maintain Hyperion Financial Reports.