Jewish Information Technology: [itroundtable] MY CLIENT NEEDS ASAP Hyperion Planning Developer

Friday, March 29, 2013

[itroundtable] MY CLIENT NEEDS ASAP Hyperion Planning Developer

Hyperion Planning Developer

Description:
3-5 plus years’ recent experience of Hyperion Essbase and Planning implementations, having worked as a technical lead on these projects, and have an understanding of the associated technologies such as Financial Reporting, SmartView and ETL technologies such as EPMA. Knowledge of SAP ERP system and HFM a plus as both will interface with HPM.

The position is responsible for the installation, design, build, testing and deployment of the following Hyperion Products:
• Hyperion Planning
• Reporting (Financial Reporting)
• Smart View

Design and Build Responsibilities: (primary responsibility)
• Define and document requirements
• Develop detailed Planning and Reporting application(s) design
• Develop and confirm metadata design (e.g., chart of accounts, entities, etc.)
• Finalize calculations and user input requirements
• Develop data interface design
• Define users, roles, security and approach to workflow/approvals
• Define data conversion, training, testing, and support Strategy

Build and Test
• Possible applications, subject to outcome of requirements definition and design phase are:
1. Workforce planning
2. 4 other work cubes
• Dimensions
1. Define and build dimensions
2. Define and build formula/calc scripts
3. Map dimension members to data source(s)
4. Assess the need for User Defined Variables (UD's)
• Security
1. Validate security matrix
2. Build security matrix
3. Test security matrix by job functions/roles
• Reports
• User forms – data entry/manipulation
• Data interfaces/integration. Known data sources include:
1. HFM – actuals
2. SAP – actuals
3. Commercial systems – margin forecasts
4. Real-time integration between operational cubes and the consolidated/reporting cube
5. MS Excel/CSV upload files
6. Load and validate base/initial data for all sources
7. "Define and setup data load jobs for automated interfaces (day, time, frequency, error handling)"
• Data conversion, load and validate initial/base data from data sources.
• Conduct performance/stress testing
• Conduct UAT – plan, develop test scripts, coordinate, document results

Assist with Training and Deployment of application.

Installation (Experience a plus, assist with)
Install, configure, patch, and validate Hyperion Planning 11.1.2.1 in development, test, and production environments. The following are the software to be installed during this phase:
• Oracle Essbase Release 11.1.2.1
• Oracle Essbase Client Release 11.1.2.1
• Oracle Essbase Administration Services 11.1.2.1
• Oracle Hyperion Provider Services 11.1.2.1
• Oracle Essbase Studio 11.1.2.1
• Oracle Essbase Server 11.1.2.1
• Oracle Hyperion Planning Release 11.1.2.1
• Oracle Hyperion Smart View Release 11.1.2.1
• Oracle Data Integrator 11.1.1.6.0

Assist with:
• Documentation of installation and configuration process.
• Documentation of patching process.
• System troubleshooting and common errors.
• System backup/restore processes.
• System start/stop procedures and scripts.