SUMMARY

• Solid 8+ years of Hyperion Essbase experience in advanced analytical software applications, requirements gathering, design, development, testing, administration and implementation of Hyperion EPM projects using industry accepted methodologies and procedures.
• Expertise in Hyperion Essbase, Hyperion Planning, Hyperion, EPMA, Hyperion Financial Reporting Studio, Web Forms, MaxL, Excel Add - in, Smart view.
• Extensive knowledge in HFM and FDM.
• Expertise in the installation and configuration of Hyperion products such as Hyperion Essbase, Hyperion Essbase Studio, Hyperion Planning, Hyperion Financial Reports, Shared services.
• Hands-on Experience in developing reports using Hyperion Financial Reporting.
• Experience in creation and maintenance of numerous applications with excellent balance of dimensions, developing various OLAP Models & Meta - Outlines across Block / Aggregate storage.
• Good expertise in planning and designing multi-dimensional cubes leveraging both ASO and BSO technologies.
• Created the cubes in Essbase and followed the Hour-Glass model for the dimension order on Dense /Sparse dimensions.
• Understanding of Essbase security features and ability to create user and group profiles and assign proper privileges.
• Created customized Financial Reports using different tools of Hyperion like Hyperion Financial Reporting Studio according to the Client requirements.
• Experience in creating Data Forms / Web Forms, writing Business Rules.
• Proficient in dynamically building dimensions, attributes, and shared members using rules files in an Essbase Outline; expertise in Currency conversion methodologies.
• Having broad understanding of database calculations such as implementing formulas on dimension members, dynamic calculations, developing calculation scripts and Report Scripts.
• Skilled in automation, optimization and performance tuning of Essbase application data metadata processing, upgrading, testing and migrating cubes in different Hyperion applications.
• Experience in knowledge transfer, preparing technical documentation, trained the clients
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work / project environment
• Clear Understanding of accounting concepts such as Financial Statement, Balance Sheet, Cash flow Statement

PROFESSIONAL EXPERIENCE

Confidential, Elk Grove Village, IL

Hyperion System Administrator

Responsibilities:

• Administered Hyperion System including Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, Hyperion Financial Reporting
• Involved in the requirements gathering for designing and developing Essbase cubes using Hyperion System (ASO/BSO Cubes)
• Created Load rules, Calc scripts and Report Scripts in Essbase
• Optimized/Tuning Hyperion Essbase application
• Supported and Administered 5 Hyperion Planning Global Application and 6 Essbase Applications (BSO)
• Supported 2 EPMA and 2 Classic Hyperion Financial Management in all three environments (Production, QA, Development)
• Administered Hyperion System including Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, Hyperion Financial Reporting
• Migrated FDM Application from one environment to another, changed machine profiles
• Migrated Hyperion Essbase, Hyperion Planning and Hyperion Financial Management application from environment to another environment with all Application data, Metadata and all Artifacts, deployed and tested application
• Used Smart view for Adhoc Analysis and for internal reporting
• Created various Data Form with Validation Rules according to requirement
• Uploaded data in Hyperion Planning application through Financial Data Quality Management
• Provided infrastructure support to all three environment (Development, Production, QA), make sure to keep environment up and fixed issues
• Installed Oracle Patches as needed, monthly windows patching, Servers reboot
• Created new EPMA Hyperion planning Application, created Dimension and uploaded metadata and Data, Optimization
• Wrote various Calculation scripts, Rules files, report scripts and business rules
• Automate daily Essbase and Planning application backups, LCM daily backups
• Managed shared service security, assign security to different users, groups

Environment: Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, Hyperion Reports 11.1.2.1, Hyperion Financial Management 11.1.2.1, Oracle Database 11g, Windows 2008

Confidential, Rosemont, IL

Hyperion Consultant

Responsibilities:

• Involved in the requirements gathering for designing and developing Essbase cubes using Hyperion System
• Involved in Installation and configuration of Hyperion Products such as Hyperion Essbase, Hyperion Financial Reporting, Hyperion Financial Management, Hyperion Planning
• Involved in installation of Hyperion Financial Reporting at enterprise level
• Done configuration in high availability (Clustered Environments)
• Worked on Hyperion planning to support complex applications for budgeting that are flexible to adapt to changes in the business life cycle
• Created Load rules, Calc scripts and Report Scripts in Essbase
• Design/Created Task Lists, Menu Lists, Smart Lists, Data forms, Business rules with Run-Time Prompt for Planning
• Create/Design/Modify the Reports in Hyperion Reports
• Created/Designed the command scripts to automate the batch processes
• Optimized and tuned Essbase and planning cubes to reduce calculation time and data retrieval
• Provided database optimization with Dimension building, Data loading, Indexing, Calculations, Cache Management
• Prepared Hyperion Reports for profit and loss statements, and balance sheet reporting
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge
• Automate job scheduler (setting/maintaining job schedules)
• Ticket/Issue/Problem Resolution

Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, Hyperion Reports 11.1.1.3, Excel Add-In, EAS 11.1.1.3, SQL Server 2005, Windows 2003, Shared services

Confidential, San Francisco, CA

Hyperion Consultant/Administrator

Responsibilities:

• Worked closely with the consulting team during installation, configuration, server settings, and client installations of Hyperion products such as Essbase, Planning and Hyperion Financial Reports
• Involved in development, maintenance and support of Essbase and Planning cubes
• Designed and assigned security using Shared Services for Hyperion components
• Managed object and data security in Planning
• Involved in migrating the application from development to production environment
• Developed Rules File for loading the data into ESSBASE Cube
• Used HAL (Hyperion Application Link) to load metadata into planning application
• Developed/enhanced Calc Scripts and Business Rules for aggregating the data based on the business requirements
• Involved in optimization and tuning of Essbase and planning application to bring down the calculation time
• Production support - resolving technical and functional issues in a timely manner to resume production process in time for smooth flow of monthly/quarterly process
• Designed the backup and recovery management

Environment: Hyperion Essbase 9.3, Hyperion Planning 9.3, Hyperion Reports 9.3, Excel Spreadsheet Add-In, EAS 9.3, SQL Server 2005, Windows 2003.

Confidential, Parsippany, NJ

Hyperion Developer

Responsibilities:

• Involved in the new Planning cube build process
• Configured complex rules files for attribute, alias and consolidation property associations
• Wrote new, and optimized existing calculation scripts
• Wrote batch commands and scripts in EssCmd and MaxL
• Modified Business Rules to cater to the changing business requirements
• Created users, user groups and administered security for multiple applications
• Maintained security for Planning, Business Rules and Essbase
• Performed data validation for the business rules and maintained Web Forms
• Provided Essbase administration and optimization training to resident technical resources
• Developed and administered reports with Hyperion Analyzer and Hyperion Reports
• Built simple and complex views of data; created spreadsheet reports, graphs, and pin board displays
• Supporting month end Financial Reporting activities

Environment: Hyperion Essbase 9.3, Hyperion Planning 9.3, Hyperion Reports 9.3, Hyperion Analyzer 9.3, Windows 2000, Excel Add-In

Confidential, Burr Ridge, IL

Financial Analyst

Responsibilities:

• Reconciled transactions by comparing and correcting data
• Increased productivity by developing automated applications, eliminating duplications, coordinating information requirements
• Provided information to management by assembling and summarizing data, prepared reports, made presentations of findings, analyses and recommendations
• Prepared Monthly Account summary reports using Microsoft Excel and Hyperion Reports
• Accomplished finance and organization mission by completing related results as needed
• Determined financial status by comparing and analyzing plans and forecasts with actual results