Essbase Hyperion Planning Senior Developer/Architect

7 to 10 + years of Hyperion Essbase Planning experience.

Extensive experience developing and working with FP&A planning models.

Ability to Develop Hyperion Essbase Planning cubes, Including Outlines, Load Rules, Calculation Scripts, Partitions, Web Forms, And Security

Experience with all EPM Planning objects, including rules, forms, integrations, data management objects, dimensions, dashboards, security models, variables, and reports.

Have experience designing, performance tuning, and maintaining Planning Essbase ASO and BSO application databases.

Strong Command of Block Storage (BSO) Concepts, Including Implications Of Dense/sparse Dimensionality

Hands-on knowledge of creating and updating existing integrations with FDMEE.

Advanced Level Experience in Migration Of All Hyperion Artifacts (metadata, Data, Security, Code) Across Multiple Environments And Across Different Versions Of Oracle EPM, Using Oracle-provided Tools (lcm, Export, Copy, Scripts).

Able To Develop System Automation Using Esscmd, Maxl Scripts, Perl, Unix Scripting, Windows Batch

Design and implement security models and protocols to ensure data integrity and confidentiality within the Essbase environment.

Ability to Tune and Optimize Planning Applications And Essbase Databases For Optimal Data Load, Calculation, And Query Performance

Hands-on Experience With Implementation, Upgrade, And Tuning Of Large Oracle Hyperion And Data Warehouse Environments

Expert In Data Modeling Olap and Oltp-based Data Warehouse Systems.

Develop various reporting structures and created system and user documents.

Hands-on knowledge of creating Smart View ad hoc sheets for troubleshooting, data analysis, and reporting