Professional Summary:

• Over 7years of experience in design, analysis, development and administration of various applications in Hyperion Suite of Technologies.
• Extensive experience of technical and functional experience in analysis, design, development, application architecture and administration, design, development of various financial applications using Hyperion Essbase 11.x/9.x/7.x/6.x, Hyperion Financial Reporting, WebAnalysis Reporting, Hyperion Planning 11.x/9.x/7.x/6.x, Essbase Administration Services EAS , Essbase Spreadsheet Add-in, Hyperion Smart View, Essbase Query Designer, Unix and Linux environments. Well-versed in SDLC Software Development Life Cycle .
• Experience in creating, maintaining, and supporting all application objects including outlines, calculation scripts, rule files for dimension builds and data loads through both Essbase Administration Services EAS and MaxL scripts.
• Sound experience innumerous cubes and multi-dimensional databases both ASOand BSO in Essbase with excellent balance of dense and sparse dimensions allocation strategy, arranged in an hourglass fashion. Developed several partitions for the Essbase applications.
• Extensive infrastructure experience of various Hyperion products installation andconfiguration in UNIX and windows environments.
• Extensive experience in planning, design, analysis, implementation, testing, quality assurance and administration in a client-server environment with expertise in developing business applications in Relational RDBMS and Multi-Dimensional MDBMS Databases.
• Experience in Essbase Cube Analysis, Design and Maintenance, Essbase Database Administration Upgrades, Performing Database Backups, Performance Tuning, and Optimization.
• Experienced in Financial Reporting by using different tools of Hyperion such as: SmartView, Spreadsheet Add-In, Hyperion Interactive Reporting Studio and Hyperion Financial Reporting Studioaccording to the Client requirements.
• Experienced in Agile Methodologies.
• Experience with Hyperion System 11.x/9.x in Interactive Reporting Studio, Dashboard Studio, JavaScript, and HTML.
• Expert in developing application security process, creating users/groups, reporting folder security, security profiles and application access to different groups using filters and also by using Import Security Utility.
• Expert in Hyperion Planning application for budgeting and forecasting requirements. Worked with business analysts for requirement gathering and creation of design documentation.
• Experienced in Creating and managing data forms, involved in implementation of decided budgeting process involving planning units, starting review process, and entity hierarchy and workflow notifications.
• Experiencedin Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Excellent analytical and research skills along with conceptual skills and demonstrated experience on documentation presentation. Demonstrated ability to adapt to changing tools and technologies as well as changing business needs.

TECHNICAL EXPERTISE:

Confidential

Responsibilities:

• Involved in developing design specifications of ESSBASE cube with Customers.
• Developed Aggregate Storage Cubes A.S.O cubes using ESSBASE.
• Extensively involved in designing and modifying the outlines for ESSBASE Cubes.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
• Designed and developed several ad-hoc and financial reports using Hyperion Analyzer and Hyperion Interactive Reports.
• Create MKDIR ,VAR.FILE , TAR UNTAR the file in Unix.
• Developed and created spreadsheets for users to input the data into ESSBASE cube through Hyperion Planning.
• Developed Calc scripts to calculate values like hourly wages, depreciation, benefits and revenue.
• Involved in migration of Hyperion Reports and Analyzer Report groups from one environment to another environment.
• Used ESSBASE Integration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of ESSBASE Servers.
• Optimized the applications to bring down the runtime and database size considerably.
• Involved in production support and maintenance of existing cubes.
• Worked as a team member in Hyperion ESSBASE Planning Implementation.
• Involved in database and security refreshes in Hyperion Planning.

Environment:

Hyperian System 11.1.2, Hyperion System 11.1.2, Hyperion ESSBASE 11.1.2, Hyperion Planning 11.1.2.2, Hyperion Analyzer, Excel Spreadsheet Add-In, Hyperion Reports, Windows 2008, SQL Server 2008.

Confidential

Responsibilities:

• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• Hyperion Planning project lead responsible for the implementation of a corporate planning system for budgeting, forecasting, and management reporting using Hyperion Planning, Essbase, FDM, ODI and Smart View.
• Understands dependencies and interrelationships between functional components of Hyperion Planning among forms, business rules, calculation scripts, variables and Essbase databases
• ASO and BSO Essbase application development/configuration and support including metadata design and metadata update administration, complex calculation/rule development, web form and reporting.
• Notifying the team members via email regarding loading process.
• Involved in the development of calc scripts, rules files for loading budget and actual data to the Essbase cube.
• Developed and maintained Rule files, MaxL Shell Scripts, Reports MDX Scripts Calc Scripts to calculate very complex values.
• Fixing the errors a raised while loading Data in the Essbase cubes.
• Check the log files to find out fail over of the script files and solve the problems by taking help from project leader or database administrator.
• Documented the recovery process in the event of disaster recovery.
• Provided production support and dealt with the user issues.
• Performed migrations between the Production, QA, and Dev.environments using the Life Cycle Management utility integrated in the shared services console provided in 11.1.1.3 version.
• Implemented various troubleshooting procedures to recover databases.
• Developed and created Data forms for users to input the data into Essbase cube through Hyperion Planning.
• Provided the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and then adding users to the groups.
• As a part of team developed the Essbase outlines, member formulas and data load rules for the Planning Application.

Environment:

Hyperion Essbase 11.1.2.2, Hyperion planning 11.12.2, EAS Administration services, Hyperion Financial reports, Hyperion Planning desktop, Smart View, Oracle 11g, MS Excel Spreadsheet Add-in.

Confidential

Hyperion Planning Consultant

Responsibilities:

• Involved in Installation and Configuration of Hyperion 11.x. system consisting of Planning, Essbase and Financial Reporting Studio, Shared services and Workspace.
• Used Classic administration and EPMA environment to create planning cubes with dimension library, application library by importing GL information from ETL processed data mart.
• Developed and created Web forms for users to input the data into ESSBASE cube through Hyperion Planning.
• Created Applications, including the use of Workforce and Capex plan types.
• Designed and developed new Essbase cubes for corporate reporting framework using Aggregate storage ASO and Block storage BSO .
• Involved in the development of calcscripts, rules files for loading budget and actual data to the Essbase cube.
• Provided the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and then adding users to the groups.
• Used MaxL in an interactive and batch mode to load data files and automate Essbase operations.
• Developed and maintained rules files, calc scripts, MaxL scripts and reports.
• Optimized the cubes performance by changing Dense/Sparse configuration.
• Created and scheduled batch jobs for complete automation processes for application refresh and backup.
• Developed batch scripts to automate the process of taking backups of the planning application, Essbase database, shared services and reports on a nightly basis using the Life cycle management command line utility.
• Performed migrations between the Production, QA and Dev environments using the Life Cycle Management utility integrated in the shared services console provided in 11.1.1.3 version.
• Developed HBR Hyperion Business Rules with Run-Time Prompts for realizing various business functionalities like creating a project, enter the planned amount for the project and consolidating to the upper level of the hierarchy.
• Involved in the development of various variance reports and regional reports using the Hyperion Financial Reporting Studio and adhoc reports usingSmartview.
• Involved in the automation of nightly backups, extraction of data and loading data.
• Responsible for monthly maintenance of the hierarchy by loading the hierarchy using the outline load utility, maintenance of the application in sync across various environments by migrating the artifacts using LCM utility, production support thereby troubleshooting user issues.

Environment:

Hyperion Essbase 11.1.x, Hyperion planning 11.1.x, Hyperion Financial reports 11.1.x, Smart view, Essbase Spreadsheet add in, Essbase Administrative Services, Hyperion Shared Services 11.1.x, Hyperion Workspace 11.1.x, and Windows 2003.

Confidential

Hyperion Developer

Responsibilities:

• Involved in themigradation of Essbase from 9.3 to 11.1 and identified database settings on Windows platform.
• Catalogued client's current system to meet the requirements of new System 11.
• Responsible for BI Server Upgrades, Migrations, Clustering and Consolidations from 9.x to 11.x on Windows and Solaris platforms.
• Created the database outlines, re-arranged the dimensions to meet the optimal performance of the database and conducted daily routine maintenance.
• Worked on procedures related to Planning, Allocations with finance and business users to understand requirements and translated them into Essbase tasks and vice versa for other Essbase users.
• Applied Hyperion Planning 9 to provide a framework for perpetual planning, managing volatility, reporting on frequent planning cycles involving both short and long term planning.
• Involved in providing security authentication for the users of Hyperion Planning and maintaining workflow management process
• Worked Extensively on Admin Services, Essbase, Planning, and Shared Services version 9.3.1.
• Performed monthly and quarterly data loads and verifications
• Developed Allocation Business Rules using Hyperion Planning and created data entry web forms using Hyperion Planning.
• Worked on the performance tuning Cube Optimization of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulas and Calc scripts.
• Worked with Data warehousing in utilizing the power of Hyperion ESSBASE OLAP Server with SQL queries.
• Worked on Oracle data integration ODI platform that covers all data integration requirements from high-volume, high-performance batches, to event-driven, trickle-feed integration processes, to SOA-enabled data services.
• Meta data is developed in Hyperion Planning for the actual or Budget data and loading the data through HAL, ODI, and DIM.
• Implemented the Drill-Thru functionality to drill back to the detail data using Essbase Studio.
• Involved in writing business rules for planning and financial management applications.
• Designed Aggregate storage cubes ASO for faster data load.
• Created, defined, and customized drill-through reports using Essbase Studio.
• Using the Essbase studio console performed various tasks required for cube building and Deployment.
• Automation of cube refresh through MaxL, batch and shell scripts.
• Optimized the applications to bring down the runtime considerably.
• Worked extensively on security and access settings for the reports and cubes in Workspace and Shared Services.
• Created various reports depending on the requirements and used report scripts.

Environment:

Hyperion System 11.1/9.2/9.3, Essbase Studio, ODI, DRM, Hyperion Planning 11.1, Hyperion Essbase 11.1,EASv7.1.5/9.x/11.x, FDQM, Oracle 10g, DRM, Solaris/Aix UNIX, Essbase Excel-Add in, Hyperion Shared Services, Hyperion Workspace, EPMA 11.1, BI Financial Reports, Web Analysis Reports , SQL Server.

Confidential

Hyperion Planning Essbase Consultant

Responsibilities:

• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• As a Hyperion Administrator involved in Installation and Configuration of Hyperion products such as Planning, Essbase and reporting tools.
• Worked on Hyperion system 9 planning to support complex financial applications for budgeting and Forecasting.
• Created web forms in Hyperion planning for users to input forecast, budget, actual, accounting changes and other variance explanations data.
• Developed HBR Hyperion Business Rules with Run-Time Prompts.
• Involved in designing reports and snapshots using Hyperion Reports/Financial Reporting.
• Created Financial Budgeting and Forecasting OLAP applications with Hyperion planning.
• Used Hyperion Planning 9 to create EAS applications / security filters, modify existing and develop new database outlines, business rules, setting up dimensions, users / user groups and security rights.
• Worked on Hyperion system 9 BI to create various ASO and BSO applications for budgeting planning and forecasting for higher management of decision support system.
• Modified existing outlines for addition, deletion and movement of members both through manually and used dimension build methods.
• Developed batch scripts using for building dimensions dynamically and load data into cubes and scheduled to run on a periodic basis.
• Involved in estimating and tuning the Essbase database performance.
• Hands on experience in backup and recovery of database.
• Provided security for various levels of users using Hyperion Shared Services.

Environment:

Hyperion Essbase 9.3.1, Hyperion planning 9.3.1, EIS Integration services, Hyperion Reports 7.0, Hyperion Web analyzer, Oracle 9i, SQL, PL/SQL,MS. Excel spreadsheet Add-in.