SUMMARY

• Over 8+ years of IT experience in data warehousing with major focus on design, analysis, development and implementation of various Hyperion applications using Hyperion Essbase, Essbase Administration Services, Hyperion Planning, Hyperion Financial Reporting, Smart View for Office, Hyperion Web Analysis, ESSCMD, MaxL and Essbase Excel Add - in.
• Experience in all stages of Software Development Life Cycle (SDLC) with comprehensive knowledge of business and requirements analysis, Business Process Modeling, Project planning and Creation of use cases as well as user stories.
• Hyperion Essbase 9.3 Developer Certified Expert from Oracle.
• Extensive hands-on experience in developing Hyperion Essbase application by gathering business requirements, writing calculation scripts, business rules, webforms and furnishing reports.
• Solid understanding of Aggregate Storage Outlines and migrations of existing Block Storage Cubes.
• Experience in designing and developing numerous Essbase applications with excellent balance of dense and sparse dimensions, developing various OLAP models and outlines.
• Demonstrated knowledge of backup and disaster recovery procedures.
• Expertise in dealing with the BSO and ASO storage options for better performance and optimization.
• Skilled in automation, optimization and performance tuning of Essbase/planning application data/metadata processing, upgrading, testing and migration of cubes in different environment.
• Adept in using Hyperion Essbase Outline Editor, Report Editor, Calc Script Editor, and Data Prep Editor.
• Proficient in dynamically building dimensions, attributes using rules files and loading fact data in Essbase applications by means of several build methods such as generation, level and parent-child references.
• Troubleshooting application related issues from business users. Resolving the issue through teamwork - discussing, identifying the cause of the issue, analyzing and sharing the work with the team.
• Extensive involvement in maintenance, automation, backups, Performance tuning and Optimization of Essbase cubes, calc scripts and applications to facilitate effective business decision making.
• Capable of managing organization’s data, assess and fulfill its reporting needs and develop powerful solutions that have true impact on the performance of a company.
• Experience in managing security, permissions, users and groups, controlling access to database cells through managing filters, filters: creating, copying and assigning filters.
• Experience in Support user training, documentation and rollout of new projects.
• Proficient in writing Stored Procedures and Triggers using SQL and PL/SQL on Oracle and SQL Server databases.
• Good understanding of coding in PL/SQL and very strong in performance tuning and database design.
• Highly dedicated towards work goals and creative in new development as well as solutions to critical issues.
• Possess excellent analytical abilities in using technology to create elegant and flexible solutions for complex business problems.
• Excellent communication skills and better understanding of business requirements and software development cycle in the Hyperion Essbase environment.

TECHNICAL SKILLS

Hyperion Tools: Hyperion System 11.1.1.x,/9.x (Essbase, Reporting and Analysis, Smart View, Analytic Services), Essbase 6.x, 7,Hyperion Planning 3.x/9.x/11.x, Hyperion Reports 3.x/7.x, ESSCMD, MaxL, Excel Add-in, Application Manager (Outline Editor, Report Editor, Calc Script Editor, and Data Prep Editor), and OLAP Server, ASO/BSO

Reporting Tools: Hyperion Reports, Hyperion Spread sheet Add-In, Hyperion Planning, Interactive Reporting (Sys9), web Analysis (Sys9), Hyperion Workspace Business Objects, Brio.

Databases: Oracle 11g/10g/9i, Essbase, SQL, PL/SQL.

Languages: C, C++, SQL, PL/SQL, SQL*Plus 3.3/8.0.

Project Management Tools: MS Visio

Operating Systems: Win 95/98/2000/XP/Vista, Windows Server 2003/2008.

PROFESSIONAL EXPERIENCE

Confidential, Maitland, FL

Sr. Hyperion Planning/Essbase Consultant

Responsibilities:

• Application lead for three different applications.
• Gathered business requirements from the business users, brainstorming with the team to apply the ideas developed through analysis and discussions into cube designs and definitions.
• Involved in designing and modifying the outlines for ESSBASE cubes.
• Developed rule files for data loading and dimension building.
• Extensively used MaxL and ESSCMD to develop batch scripts to automate data load from relational systems database to ESSBASE cube.
• Involved in installation of Hyperion Planning on Windows environment.
• Designed and developed Web forms for users to input the data into ESSBASE cube through Hyperion Planning.
• Performed the performance tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.
• Created Business Rules using calculation manager to assign them to Planning Web forms and also to launch them on demand.
• Troubleshooting and resolving issues directly sent by the business users and SMEs.
• Optimization of the existing cubes, calc scripts, business rules for higher efficiency.
• Regular maintenance of the environment like installing security patches, java updates, removal of files to reduce hard disk size for optimal performance.
• Responsible for Loading of data using ODI, migration of securities and defragmentation of cubes
• Updated user access, privileges, creating new users or deleting old users.
• Furnished reports through excel add-in, installing of Smartview across the environment.
• Digging into log files and data cells to resolve data-related issue.
• Presented the IT solutions of the requirements to the business teams and explaining the new efficient procedures - demonstrating excellent oral and presentation skills.
• Worked with the business users and providing training on new procedures.
• Tested the application for bugs and resolving the issues working with the business users. Writing documentation for the application disaster recovery, manual for maintenance, presentation decks for business, release notes - demonstrating excellent writing skills.
• Provided training to new resources about the GM IT architecture and procedures for form submissions, changes to the applications and maintenance.

Environment: Hyperion Essbase 9.3.3, Hyperion Planning 9.3.3, EPMA, Essbase Administration Services (EAS), Hyperion Shared Services, Hyperion Web Analysis, Hyperion SmartView, Oracle Database 10g, Windows Server 2003, MS Excel 2003.

Confidential, Houston, TX

Sr. Hyperion Planning and Essbase Consultant

Responsibilities:

• Gathered user requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations.
• Developed Rules file for Dimension Building and performed Metadata and Data loading.
• Developed business rules and calc scripts to derive complex calculations such as cash cost per user, YTD commitment, variance, capital expenditure forecast and budgeted cash flow statements.
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Created reports using Hyperion Web Analysis Studio and SmartView for monthly, quarterly and annual data.
• Created and maintained ASO/BSO cubes as per user requirements and performed optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning etc. and optimization of calc scripts and tuning of calc cache.
• Designed Task lists and workflow process for all the Planning applications
• Created Hyperion Security by creating Users, Groups and Filters for Analytic Services and Hyperion Reports in Shared Services.
• Created documentation for the users and provided required training for data entry and reports.
• Created webforms, assigning business rules and assigning securities.
• Optimized specific business rules, cutting down the run time and enhancing the performance.

Environment: Hyperion Essbase 11.1, Hyperion Planning 11.1, EPMA, Essbase Administration Services (EAS), Hyperion Shared Services, Hyperion Web Analysis, Hyperion SmartView, Oracle Database 10g, Windows Server 2003, MS Excel 2003

Confidential, Atlanta, GA

Hyperion Developer

Responsibilities:

• Designed and developed the Essbase cube from a conceptual stage.
• Developed EIS OLAP models and meta outlines including custom user defined tables, hierarchies and EIS automation.
• Developed Multi-Dimensional Database applications using Essbase that stored and maintained company’s financial and marketing data for loading and manipulation of the data into the database using Load Rules.
• Wrote Report Scripts to develop Income & expense statement analysis reports. Developed Revenue and Quantity Reports.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Extensively involved in development of all Essbase database objects - Outlines, Calc Scripts, Report Scripts & Load Rules.
• Developed database objects Outlines, Load Rules, Calc and Report Scripts, designed and developed monthly, quarterly and yearly retail P&L Cubes.
• Maintained security in Hyperion Analytic Services (Essbase), Hyperion Financial Management and Hyperion Performance Scorecard.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedures, Update Strategy and others.
• Developed SQL Server database objects like tables, views and stored procedures to transform legacy data into parent child or generation format data suitable for building hierarchies using EIS.
• Developed complex MDX formulas, ASO dynamic and stored hierarchies, rules files and other objects for various Aggregate Storage (ASO) cubes.
• Created Drill-through reports in EIS to enable users to drill down to detailed level data in SQL Server.
• Developed automation for cube build, data load, updating partitions using MaxL and windows batch scripts.
• Created automation to export out the budget and forecast data to load back into Oracle.
• Redesigned existing reports, cubes and processes.

Environment: Hyperion Essbase 11.1.2, Hyperion Planning 11.1.2, EPMA, Essbase Administration Services (EAS), Hyperion Shared Services, Hyperion Web Analysis, Hyperion SmartView, Windows Server 2003, MS Excel 2003.

Confidential, Richmond, VA

Hyperion Planning Consultant

Responsibilities:

• Created Budgeting and Forecasting applications using Hyperion Planning for the Finance department
• Identified planning metadata requirements and loaded metadata
• Developed Load Rules to automatically validate the data and feed into Essbase
• Extensively involved in creating web forms and business rules
• Designed reporting and input templates and developed numerous Financial Reports like Profit & Loss Reports, Income statement Reports, Expense Reports & Revenue Reports using Hyperion Financial Reporting
• Interacted with end users on a regular basis to capture business requirements
• Supported existing cubes, problem identification, resolution and documentation
• Provided user training on data entry and report generation steps
• Optimized cubes by altering the Dense/ Sparse settings for the different Dimensions
• Developed outlines, ESSCMD scripts, Calc scripts, data load rules for loadings
• Created various rules files for dimension building, data loading
• Created reports in Excel by accessing data through relational, multidimensional, BI sources and refreshed them periodically using Smart View.
• Created queries using Essbase Query Designer to retrieve dimensions, database members into worksheet.

Environment: Hyperion System 9, Hyperion Planning 9.2.0.2, Hyperion Financial Reporting 9.2, Hyperion Shared Services 9.2, Hyperion Smart View, Workspace, Windows NT, Oracle 10g

Confidential

Essbase Administrator/Developer

Responsibilities:

• Involved in design and implementation of the Planning and Closing Applications.
• Involved in defining requirements, functional specifications, designing documentations and testing for creating budgeting and forecasting tool.
• Migrated all the application from older Hyperion environment to System 9 by creating them in the new environment from the scratch (as suggested by Oracle Hyperion Support Team
• Creating reports using Hyperion Reports
• Designed and developed web forms for data inputs as per the business requirements using Hyperion Planning.
• Developed the HAL routines to automate the dimension building
• Developed numerous simple to complex Business Rules and attached them to the web forms.
• Extensively worked with Shared services to configure External LDAP and provisioned Externally Authenticated groups directly to the ESSBASE applications. Created required users and Groups in the Native directory.
• Resolved issues related to the security, server issues, database corruption and business rules.
• Created several reports, charts and dashboards using Hyperion Analyzer using Essbase and Relational data sources
• Created Calc scripts and member formula, these formulas would be daily updated in the outline using SQL
• Setting up users and groups according business department and Assigning security to users and groups..
• Developed batch files using MaxL and ESSCMDs and rule files to upload data from System’s database to Essbase cube.

Environment: Hyperion Essbase 7.x/9.0, EAS 7.x, Hyperion Planning 4.x, Hyperion Reports 7.x, Hyperion Analyzer 7.x, HAL 7.x, ESSCMD, SQL Interface, Excel Add-in Essbase API, Unix, Unix Shell Scripting, Oracle 9x.

Confidential

Essbase Developer

Responsibilities:

• Involved in creating databases, outlines, applications and generated calc scripts necessary and report scripts for better decision support.
• Created Database outlines and optimized the outlines arranging the Dimensions.
• Gathered and documented business requirements
• Extensively involved in changing the outlines for cubes on a regular basis.
• Migrating Essbase server into newer versions and newer operating systems
• Developed Data load rule files using the Data Prep-Editor for loading data.
• Developed MaxL scripts for automation Scheduled Essbase processes' automations using AutoSys job management system.
• Developed the reports by providing the user-friendly features such as drill down in to data and viewing data from different perspectives
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/ annual report generation
• Created Calc Scripts using the Calc Script Editor for calculating databases and subsets of Databases
• Involved in collection of raw data from disparate systems for Hyperion Enterprise.
• Developed systems configuration and setup provided the production support.

Environment: Essbase OLAP Server 6.5,Hyperion Planning 3.5.1,Essbase Integration Services 6.2, Hyperion Reports 2.5, Hyperion Application Link, ESSCMD, Essbase Excel-Add-in.