Job Description :
Location: NYC, NY
Job Type: 2 years contract
Description:
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.
A. JOB RESPONSIBILITIES
· 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.
B. EXPERIENCE AND QUALIFICATIONS
· 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 11.1.2.4, 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
5. DATABASES: ESSBASE 11.1.2.4, Oracle RDBMS 12G
6. INSTALL\CONFIG: Essbase, Planning, HSS, EAS, Client, EIS, HSF, ODI, OBIEE, FR, etc.
7. OS: Microsoft Windows (2012)