Job Description :
Location: NYC, NY

Job Type: 2 years contract


Scope of Service

Management and maintenance of applications that are based on Oracle-Hyperion Enterprise Performance Management products using ESSBASE, Planning, Financial reporting, SmartView and Oracle RDBMS for metadata management.

Application maintenance shall include troubleshooting and problem resolution, system/application enhancements, day-to-day system operation and recurring maintenance activities and technical assistance for the customer community.

Application modifications, enhancements or new development shall include all phases of development cycle: planning and analysis, system design, programming, testing, implementation, deployment, documentation and training for primary users.


· Under the supervision of the Corporate Application Manager the successful candidate, an experienced Hyperion programmer/developer/system administrator with solid technical skills, will ensure the operability and availability of all associated applications for the end-user community and the first-hand technical assistance to the primary customers.

· Technical support for Hyperion Planning, ESSBASE, Financial Reporting, Data Relationship Management (data & metadata), ODI tools used for building and maintaining multiyear budgeting and forecasting applications.

· System administration, installation, configuration, backup setup, disaster recovery, hardware configuration, analysis and diagnostic for upgrade of Hyperion latest supported version; particular expertise in installation and configuration of Oracle-Hyperion EPM in a distributed environment on Windows physical servers.

· Managing User and Group Security utilizing ESSBASE Shared Services.

· Migration of EPM artifacts, Load Rules, Business Rules, Forms, Calc Scripts, report scripts, etc. from Test to QA to Production using LCM.

· Collaborate with various teams for data analysis and identifying critical business problems and potential areas of opportunity for improvements and produce analysis to senior management.

· Investigate, research and evaluate new budgeting and planning practices that may enhance or improve existing applications and provide valuable business benefits to the Agency.


· Candidates must possess a bachelor''s degree in computer science, programming or engineering and at least 8 years professional experience performing Oracle-Hyperion EPM system programming/development.

· Experience in analysis, design, optimization and administration of Oracle-Hyperion EPM products

· Experience supporting and building integration methodologies using standard ETL for batch- oriented integration and real-time integration through ODI and windows batches and scheduling.

· Experience in performance tuning and optimizations for data/dimension loads, ESSBASE database restructuring (BSO/ASO), calculations, overall ESSBASE performance., restructuring cubes for defragmentation.

· Experience working with ESSBASE Shared Services, Lifecycle management, Metadata management, version control and platform support for Hyperion EPM applications.

· Exposure to the entire Software Development Life Cycle (SDLC) from Requirements, Design, Development, Testing and Production Support.

· Expertise in trouble shooting, knowledge transfer, preparing technical document and training the clients.

· Expertise supporting and maintaining multiple environments (Development, Quality, Production) for Oracle-Hyperion EPM; Involved in the migration of application artifacts, Business Rules, Forms, Calc Scripts etc. from Test to Production using LCM.

· Experience with Smart View software installation, software usage and client support.

· Experience creating and maintaining Functional and Technical documentation on business processes including process flows, use cases, functional specifications and traceability.

· Experience Supporting daily, weekly, month end and year end processes

· Experience handling daily ad-hoc service calls, troubleshooting and resolution

· Good understanding of HR, Payroll, Accounting, Finance, Planning, Budgeting and Forecasting systems.

Must possess following Technical Skills:

1. LANGUAGES: SQL, PL/SQL, Shell Scripting, ESS commands, MAXL, MDX, Windows batch scripting

2. TECHNOLOGIES: Oracle-Hyperion Enterprise Performance Management (EPM)

3. OLAP TOOLS: Hyperion Essbase, Hyperion Planning 11.2.4, Hyperion Financial Reporting, Smart View Management, Excel Add-In

4. SOFTWARE: ODI, IIS, Web Logic, EBS, Version Control, Windows Scheduler


6. INSTALL\CONFIG: Essbase, Planning, HSS, EAS, Client, EIS, HSF, ODI, OBIEE, FR, etc.

7. OS: Microsoft Windows (2012)

Similar Jobs you may be interested in ..