Previous Job
Hyperion consultant
Ref No.: 18-03826
Location: Los Angeles, California

At KAYGEN, we are always looking for dynamic, talented and experienced individuals. We invite you to join our team of talented IT professionals, consulting at client locations across the globe. Our culture is team-orientated; we strive to stand by our core values of respect, honesty and integrity. Our team of experienced staffing experts will work with you to find you the best opportunity. For more information please visit us at

Technical Skills

  • Proven experience with a large scale implementation of Hyperion Planning version 11 or high
  • Extensive experience developing and maintaining Hyperion Planning and Essbase applications
  • Strong understanding of ASO/BSO cube development
  • Experience in data transformation using ODI, SQL, FDMEE and FR Reporting
  • Experience in Hyperion Upgrade
  • Experience working on Windows and a Unix/Linux platforms
  • Knowledge of writing basic SQLs
  • Experience with Smart View, web forms and reports, mxl, and Unix shell scripting
  • Oracle Relational Database experience is a plus
  • Experience in PBCS and upgrade projects is a plus
  • Deep functional and technical knowledge of financial systems and business processes, especially around planning, budgeting, & forecasting


Roles & Responsibilities

  • Responsible for creating, documenting, and implementing scalable solution design and implementation plans
  • Preparation of key deliverables such as requirements documents, design documents, test plans,  training materials and solution delivery
  • Supervise, develop, and mentor junior consultants throughout project life cycles
  • Apply structure knowledge to solve problems, break down issues and identify solutions
  • Must be able to manage changes to metadata, calcuation maintenance and will be able to resolve data descripancies and any other Hyperion application issues.      
  • Good communication skills and ability to work in a team


Tools and Technologies:

Oracle Hyperion Planning, Oracle Hyperion Financial Reporting, Oracle Hyperion Essbase, Oracle Financial Data Quality Management, Oracle Data Integrator, MAXL (Hyperion Script Language), Visual Basic scripting, Microsoft SQL Server, Microsoft SQL Server Studio, Oracle Smartview, PowerShell Script

Job Duties:

1)       Develop business logic for system enhancement and upgrade (20%)

2)       Provide ongoing application support to HMD application (10%)

3)       Design and generate application reports, security audit reports (20%)

4)       Enhancing the existing system, process times (20%)

5)       Requirement gathering, system and user test (30%)