Hyperion Essbase Consultant

ql-editor ">

Role : Hyperion Essbase Consultant

Experience Required : 5+ years

Duration : 6+ Months

Location : Remote

Time Zone : Easter Time Zone

Required Skills : Essbase Administration SQL SSIS Visual Studio VB Script/VBA SmartView Essbase Cubes

Background

Clients are changing their fiscal year to the calendar year and are needing to modify/update data connections, data integration, and reports to ensure reports/reporting tools are able to accommodate this change.

Environment

• Hyperion Essbase on prem with integrated with Lawson
• Roughly 8 cubes in their cube farm, in the process of upgrading Essbase and taking advantage of more Automation
• SQL Server databases
• SQL- Stored procedures and SSIS
• VB and Excel

Requirements

• Visual Studio - SSIS integrations
• Visual Basic coding
• SQL queries
• Hyperion/Essbase
• Data loading
• ASO Cube Calculations
• BSO Cube Calculations
• Drill down concepts
• Debugging incorrect data