Hyperion Essbase Developer Resume Samples

Description :

1. Obtained a detailed knowledge of the business process being followed in the project environment Extracted the business requirements from the end users keeping in mind their need for the application.
2. Involved in the performance tuning of the Essbase server.
3. Involved in migrating the application from one environment to another environment.
4. Involved in backing up the Essbase application on daily basis and restored the Essbase application whenever required.
5. Designed and developed web enabled Forms to enable users to enter data for capital costs planning, sales and marketing planning, G&A cost planning, T&M project planning etc., using Hyperion Planning Form Designer.
6. Worked on Implementation of Hyperion Planning, Hyperion Analyzer, Hyperion Reports, and Hyperion Business Rules Automated the backup process using Shell scripts and worked on UNIX shell wrapper scripts.
7. Developed Load rules for Dimension build and Rules File for loading the data from Oracle GL into Hyperion Cube.
8. Interacted with the data staging team to get appropriate data into Essbase cubes.

Experience

0-2 Years

Level

Entry Level

Education

Master's

Description :

1. Involved in requirements gathering, design, development, implementation, production testing, and implementation of HFM project.
2. Applied HFM for data management processes for gathering data, calculating, approvals, consolidations, and submissions of data.
3. Performed data loads using FDQM.
4. Translated end user requirements into application design specifications.
5. Designed and created data explorer, journal and intercompany partner matching reports.
6. Resolved issues with HFM not being able to create applications due to configuration issues, by troubleshooting Shared Services, Workspace, and HFM Set up locations, control tables and import formats for FDQM.
7. Configured users and access rights in FDQM.
8. Created an enterprise view of financial chart accounts, with the help of Hyperion DRM, with a view to govern ongoing financial management and consolidations.
9. Analyzed financial results and prepared trend reports to support business managers make profitable decisions.

Experience

10+ Years

Level

Senior

Education

BE

Description :

1. Involved in design and development of two cubes, one for budgeting and planning and the other for customer analysis.
2. Involved in dynamic dimension building and modifying outlines.
3. Developed batch scripts for automating the dynamic dim builds and data loads Interacted with the business users and administrators to gather requirements to develop required Web forms.
4. Developed Web forms for several Business process - Contingency, Line of Business transfer and Reforecasting processes.
5. Involved in designing and developing web forms using Hyperion Planning tool for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
6. Developed calc scripts, business rules using Hyperion Business rules tool.
7. Responsible for Hyperion Planning and Essbase global implementations, including Workforce Planning in version 9.3.1 and 11.1.2.0 Created the Planning application for Multi currencies.
8. Expertised in building Financial Budgeting and Forecasting OLAP applications with ESSBASE and Planning.

Experience

2-5 Years

Level

Junior

Education

Bachelors

Description :

1. Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
2. Provided integration of various data like derived, historical, and projected data.
3. Developed Rules files in order to upload data from financial system's database to Essbase cube.
4. Implemented calculation engine for computing derived data.
5. Loaded, reconciled and consolidated key financial data with Hyperion using FDQM(Financial Data Quality Manager) and HFM consolidation.
6. Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports.
7. Implemented an automated Cash Flow statement in HFM.
8. Involved in Data Loads and Calc Scripts optimization for Essbase and Planning.
9. Automated the Cube building through MaxL & shell scripts and scheduled them though Control-M Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services.

Experience

2-5 Years

Level

Junior

Education

Bachelor's

Description :

1. Involved in requirements gathering, design, development, implementation, production testing, and implementation of Hyperion Planning project.
2. Worked on installation, configuration and deployment of Hyperion Foundation services, Hyperion Planning, HFM, FDM Experience in Architecture design of Essbase Cubes using Block storage (BSO) Worked on Reporting with the help of Hyperion Financial Reporting tool.
3. Performed data loads using FDM.
4. Translated end user requirements into application design specifications.
5. Worked on installation, configuration and deployment of Oracle Data Integrator.
6. Created integration script in FDM to connect to and load data directly from PeopleSoft GL tables, instead of first exporting to a flat file and then loading.
7. Logged records with zero balances into a special file for each period, to facilitate audits without hurting performance of FDM and Hyperion Planning data load by including those records.

Experience

5-7 Years

Level

Executive

Education

Bachelors

Description :

1. Chartered and headquartered in Omaha, Nebraska, United States, First National provides corporate banking, investment banking, retail banking, wealth management and consumer lending services at locations in Nebraska, Iowa, Colorado, Texas, Kansas and Illinois.
2. Developed of Essbase components Load rules for actual and other data loads, setting up substitution variables.
3. Automated dim build, data loads, partitions creation and backup and automate Essbase application refresh process using MaxL scripts and UNIX scripts.
4. Worked on Attribute dimension and UDAs and optimized the storage, retrieval time and the report performance.
5. Involved in improving performance of the applications, optimized the various cache settings to enhance the performance of Cubes.
6. Created groups and users for different business segments and then assigned security and filters to define Essbase privileges on them.
7. Developed Calc scripts and ran them to calculate complex values using Block Storage cubes.

Experience

7-10 Years

Level

Consultant

Education

Masters

Description :

1. Develops and implements applications for business based on identified requirements
2. Develops key business processes to support a Hyperion Planning application and related technologies
3. Designs the user experience from an end user planning and reporting perspective
4. Determines data sourcing strategies and data validation approach
5. Collaborates with Functional Consultants and other Developers for the best possible solution for our customers.
6. Understands project requirements to recommend and create solutions while solving problems.
7. Supports and assists Hyperion Smart View related issues.
8. Creates functional and technical documentation.

Experience

2-5 Years

Level

Junior

Education

Masters

Description :

1. Involved with Business Users and Business Analysts to gather the requirement and Business logic.
2. Migrated Essbase server (9.3.1) into version and over UNIX host.
3. Installed Hyperion System 11 in development environment and explored migration issues.
4. Involved in creating Rule files for multi-dimensional databases, optimized Data loads and Calc Scripts.
5. Implemented Hyperion Essbase and Planning v.11 in connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports.
6. Created Users and Groups in Hyperion Shared Services v.11 and assigned privileges to them.
7. Applied security on different applications by creating filters on its dimension members.
8. Created new batch scripts to automate the transfer of the data from data server to Essbase Server.
9. Optimized structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations and debugging.

Experience

5-7 Years

Level

Executive

Education

Bachelors

Description :

1. Provides expertise in Hyperion Planning, metadata, calculations, web forms, Smartview, access controls etc
2. Collaborates with business finance users & IT BI folks to define requirements and scope of enhancements
3. Provides end user training & support
4. Effectively communicates with the project team, client, and user community.
5. Experiences coordinating with onsite offshore development & functional team members
6. Optimizes of planning applications
7. Resolves highly complex technical issues for applications software.

Experience

10+ Years

Level

Senior

Education

Bachelors

Description :

1. Provides support in the architecture, design, and development of Hyperion application, system, or process recommendations based on short- and long-term IT organization strategy.
2. May focuses primarily on the internal structure of a single application or the integration of multiple applications of moderate complexity.
3. Uses a variety of platforms to provide automated systems applications.
4. Provides expertise regarding the integration of applications across the business.
5. Determines specifications, then plans, designs, and develops software solutions, utilizing appropriate software engineering processes-either individually or in concert with project team.
6. Applies in-depth knowledge of programming languages and designing, coding, testing etc.
7. Understands and consistently applies the attributes and processes of current application development methodologies.
8. Researches and maintains knowledge in emerging technologies and possible application to the business. Applies an understanding of key business processes and practical experience to solve a range of straightforward problems.
9. Analyzes possible solutions using experience, judgment and precedents. Works under moderate supervision.

Experience

0-2 Years

Level

Entry Level

Education

Bachelor's