SUMMARY

• Dedicated Software professional, with 9 Years of experience in design, analysis, development, implementation and support of various Oracle Hyperion Business Intelligence applications.
• Expertise in Hyperion Essbase, Hyperion Planning, EPMA, Calculation Manager, ESSCMD, MaxL, Excel add - in, Smart-view, Web Forms, and Hyperion reports, Oracle Data Integrator, Workspace, Shared Services, Interactive reporting studio and Financial reporting studio.
• Expertise in creation and maintenance of numerous Essbase Multi-dimensional database applications using Block/Aggregate storage and partitioning.
• Configure FDM by setting up Adapters using workbench, define import formats, create locations, mappings, validation rules and groups and load data into HFM.
• Proficient in dynamically building dimensions, attributes using rule files and loading fact data in an Essbase application by means of several build methods such as Generation, Level and Parent-Child references.
• Expertise in writing custom Essbase Calculation Scripts and automating the Essbase cubes using MaxL, ESSCMD.
• Experience in developing Hyperion Planning applications including data forms, business rules, menus, capex, workforce, task lists, smart lists and application migration as well as application management and troubleshooting.
• Used Outline Load Utility to load metadata for classic planning applications.
• Expertise in building Financial Budgeting and Forecasting OLAP applications with Hyperion Planning.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Expertise in loading Metadata to EPMA Library using profiles.
• Expertise in loading data to Planning applications using Data Synchronizer.
• Understanding of Essbase security features and ability to create user and group profiles and assign proper privileges using both Native security and Shared Services Modes.
• Created customized Financial Reports using different tools like Hyperion Interactive Reporting Studio, Hyperion Financial Reporting Studio according to the client requirements.
• Hands on expertise in using Essbase Excel add-in and smart view add-in.
• Performed several Administrative tasks like installation and troubleshooting of Essbase Administrative services, shared services and planning on server machines.
• Well versed with using Life Cycle Management utility to migrate artifacts from one environment to the other and also to use it during upgrades.
• Good team player possessing excellent communication skills, motivated and ability to lead implementations. quickly adapt and work under minimal supervision.

TECHNICAL SKILLS

OLAP Development Tools: Hyperion version 11.x Product Suite, Hyperion System 9 BI+(Analytic Administration Services), Hyperion Essbase 11.1.x.x/9.3.x/7.1.x, EAS, Hyperion Planning 11.x/9.3.x/4.0/3.5, Hyperion Financial reports 11.1.x.x, Hyperion Shared Services 11.1.x.x/ 9.3, Essbase Integration Services, Workspace, Excel Spread sheet Add-in, Smart view, ESSCMD, MaxL and MDX.

Reporting Tools: Hyperion Interactive Reporting, Financial Reporting Studio, Excel Spreadsheet Add-in and Hyperion Smart view.

Dimensional Modeling: Star-Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables, Physical and logical data modeling.

Oracle Data Integrator (ODI): Oracle Data Integrator and Data ware housing experience.

Web & Application Servers: Tomcat Apache, Microsoft IIS 6.0/5.1, Web Logic, Web Sphere.

PROFESSIONAL EXPERIENCE

Confidential - NC

Hyperion Consultant

Responsibilities:

• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• Involved in Installation and Configuration of Hyperion 11.1.2.2 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.
• Enhanced/modified existing financial reports as per changes in reporting requirements.
• Created Applications, including the use of Workforce and Capex plan types.
• Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Develop data extracts from the data warehouse environment using ODI.
• Designed and developed new Essbase cubes for corporate reporting framework using Aggregate storage (ASO) and Block storage (BSO).
• Involved in the development of calc scripts, 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.
• Designed Hyperion Financial Management (HFM) Reporting Infrastructure including System Infrastructure, Metadata Layer Infrastructure, and Data Acquisition and Data Distribution Infrastructure.
• Loaded the data into HFM using Hyperion Financial Data Quality Management (FDM).
• Developed Data Forms and Data Grids using HFM.
• 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 using Smart View.
• 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.2.2, Hyperion planning 11.1.1.3, Hyperion Financial reports 11.1.1.3, Smart view, Essbase excel add in, Essbase Administrative Services, Hyperion Shared Services 11.1.1.3, Hyperion Workspace 11.1.1.3, and Windows 2003.

Confidential - St. Louis

Hyperion Consultant

Responsibilities:

• Involved in developing design specifications of ESSBASE cube with Customers.
• Developed Aggregate Storage Cubes (A.S.O) cubes using ESSBASE
• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• Skilled in architecture design of Essbase cubes using Block/Aggregated storage and Partitioning.
• Design and developed monthly, quarterly and yearly profit and loss Cubes.
• Responsible for performance tuning, regular backup and recovery cubes.
• Responsible for identifying problems, resolutions and documentation.
• Created new users and groups, assigned existing users to those groups and grant access to the users and groups as per their specific needs to access the cubes.
• Designed developed and supported financial and management cubes and reports
• Uploading metadata to Hyperion planning and data to Essbase.
• Involved in the development of calc scripts, rules files for loading budget and actual data to the Essbase cube.
• Used Filtersto control the access of those users and groups to individual data within the database to provide security at the detailed level.
• Developed andmaintained Rulefiles, MaxL Shell Scripts, Reports MDX Scripts & Calc Scripts to calculate very complex values.
• 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 torecover databases.
• Analyzed all dimensions and members in the Essbase outline.
• Involved in conducting technical, functional and UAT testing ofHFMapplications.
• Migrated Planning andHFMapplications from Development to Production Server.
• 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.
• Responsible for providing training to the end users.

Environment: Hyperion Essbase 11.1.2, Hyperion planning 11.1.2, EAS Administration services, Hyperion Financial reports, HyperionPlanning desktop, Smart View, Oracle 10g, MS Excel spreadsheet Add-in, Windows 2008 R2

Confidential, Lincoln, NE

Hyperion Consultant

Responsibilities:

• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• Installation and Configuration of the Development server consisting of Hyperion System 11 ESSBASE, Hyperion Planning, Hyperion Shared Services, Hyperion Application Link, Financial Reports, Web Analysis and Workspace.
• Involved in loading Meta data for planning using ODI.
• Created web forms in Hyperion planning for users to create, modify the plan details and also web forms for the capital controllers to allocate amount among various plans.
• Developed HBR (Hyperion Business Rules) with Run-Time Prompts to create new plans, modify created plans, and modify the amount allocated by the capital controllers.
• Assisted with the development of Hyperion Planning for P&L and Workforce Planning.
• As a part of team developed the Essbase outlines, member formulas and data load rules for the Planning Application.
• 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.
• 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 reports for users to view the data in the planning applications using Financial Reports and Web Analysis.
• Developed batch scripts using for building dimensions dynamically and load data into cubes and scheduled to run on a periodic basis.
• Created users, groups, filters and assigned different kinds of Security access to users in Hyperion Planning Applications using Hyperion Shared Services.
• Developed batch scripts to automate the process of taking backups of the planning application, shared services and reports on a nightly basis using the Life cycle management command line utility.
• Documented the recovery process in the event of disaster recovery.
• Provided production support and dealt with the user issues.

Environment: Hyperion Essbase 11.1.1.3, Hyperion planning 11.1.1.3, EAS Administration services, Hyperion Financial reports, HyperionPlanning desktop, Smart View, Oracle 10g, MS Excel spreadsheet Add-in, Windows 2000

Confidential, Manhattan, NY

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, Hyperion Planning desktop, Oracle 9i,SQL, PL/SQL,MS Excel spreadsheet Add-in, Windows 2000.

Confidential, Jersey city, NJ

Essbase Developer

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.
• Created Complex and Dashboard Reports using Interactive Reporting.
• 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: Hyperion System 9, Hyperion System 9 BI+, Hyperion ESSBASE 9.1, Hyperion Planning 4.1.1, Hyperion Analyzer, Excel Spreadsheet Add-in, Hyperion Application Link, Hyperion Reports, Workspace, Windows 2003 Server, SQL Server 2000.

Confidential, Schenectady, NY

Hyperion Developer

Responsibilities:

• Designed, developed and maintained multi-dimensional databaseapplication using Essbase & Planning.
• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• Developed and created Data forms for users to input the data into Essbase cube through Hyperion Planning.
• DevelopedOutline for both Aggregate Storage (ASO) & Block Storage (BSO) applications.
• Used ESSCMDin an interactive and batch mode to load data files.
• Developed andmaintained Rulefiles, MaxL Shell Scripts, Reports MDX Scripts & Calc Scripts to calculate very complex values.
• Developed andoptimized Data Loads and Calculations.
• Analyzed all dimensions and members in the Essbase outline.
• Involved inPerformance Tuningto minimize data load time and tuned the cube by changing theDense/Sparse settings.
• Designed several custom reports using Financial Reporting Studio for Corporate reporting processes (Monthly, Quarterly and annual).
• Responsible forPerformance Monitoring, Backup and Recovery of the cube.
• Implemented various troubleshooting procedures torecover databases.

Environment: Hyperion Essbase 7.1.2, Hyperion Planning 3.5, Essbase Integration Services 7.x, Microsoft Excel 2003, MS SQL Server 2005, Windows NT/2000, UNIX.