SUMMARY

• Hyperion Technical consultant with more than 8 years of experience in design, analysis, development and implementation of various applications in Client/Server environment using Hyperion Essbase, EAS, EIS, Hyperion Planning, ODI, HFM, EPM, FDM, ESSCMD, MaxL, Essbase Query Designer, Hyperion intelligence, Hyperion Analyzer, Hyperion Reports, Hyperion Financial Reporting, Web Analysis, Essbase Excel Add - in and Smart view under Windows 2000/NT4.0, Linux and UNIX environment
• Experience in developing OLAP models and metadata outlines for loading dimensions and data into Essbase Cubes.
• Experience in creating business rules, manipulating and maintaining calculation scripts.
• Experience in design, development and implementation of various applications using Hyperion Essbase 11.1.1.x/9.x/7.x, Hyperion Planning, Hyperion Reporting and Analysis, ESSCMD, MaxL, Essbase Excel Add-In, on both Windows and Unix environment VBScript.
• Participated in the development of Multi-Dimensional Data Marts using Hyperion Essbase technology and the development of analytic reporting of Business Performance Measurements using the Hyperion suite of products including Hyperion Analyzer, Hyperion Reports, Hyperion Planning and Hyperion Financial management.
• Excellent command over ESSCMD, MaxL for total automation of the process.
• Experience in Essbase Integration Services (EIS).
• Experience in optimization of Dimension building and Data loading
• Experience in providing support and maintenance for Hyperion Essbase Systems including both client/server level services and consulting.
• Expert in creating SQL Scripts for creating tables, views and stored procedures, loading data into tables.
• Worked in various environments of Development, Production-Support and Maintenance projects with excellent result-oriented approach.
• Worked on Database Optimization, Data Partitioning, Database Backups, performance tuning of Essbase application Data/Metadata processing, upgrading, testing and migrating of cubes in different environments.
• Expertise knowledge in Memory analysis, cache tuning, Configuration settings tuning, Performance tuning, Optimization, Dense/Sparse settings, partitioning, etc
• Extensive exposure to Hyperion Planning, web forms, business rules, Hyperion Financial Reports, Analyzer/Web analysis
• Experience in handling data load through ODI, DIM, EIS, SSIS and FDM
• Empowered various departments of business with Budgeting, Forecasting, Planning, and Reporting with the Hyperion Technologies such as Hyperion Planning, Essbase, HFM, FDM, ODI & Hyperion Reports
• Experience in process automation using MaxL, ESSCMD, and Batch and UNIX scripts.
• Experience in writing queries, creating tables in Oracle/ SQL Server.
• Investigating the latest version of Oracle Essbase 11.X and Essbase Studio.
• Excellent technical and communication skills coupled with firm commitment to quality and team spirit.
• Developed Web forms using Hyperion Planning web client for the end users to input values and Forecast, Budget and Actual.
• Involved in Migration of Reports from development server to production server.
• Excellent communication skills and time management skills
• Excellent analytical and problem solving skills
• Resourceful and energetic in any given task
• Learn and apply new skills quickly - take advantage of resources and tools
• Open to new responsibilities challenging my capability.

TECHNICAL SKILLS

Business Intelligence: Hyperion Essbase (6.5, 7.3, 9.3,11.1.x), Hyperion Planning (3.5, 9.3,11.1.x).

Tools: Hyperion Administration Services, Hyperion Financial Management(HFM) Shared services, Hyperion Data Relationship Management (DRM) / Hyperion Master Data Management (MDM), Integration Services, SQL, TOAD, Smartview for Office, Excel Add-In, Financial Reports, Quality Center, Crystal Reports, OLAP, MS Office

Scripts: MaxL, Microsoft Excel, VBScript, Shell Scripts, Perl, Batch Scripts & Excel Macros

Tools: Rational Rose clear case, clear quest, Quality Center, QTP, Visio

Functional Areas: People Soft, Supply Chain Management, HRMS, eCommerce, OMS

Database: Oracle 11g/10g/9i, MS Access, SQL Server and mySQL

Productivity Tools: TOAD, Unix Shell scripts, PL/SQL, SQL*Plus, Send Master

Languages: C, C++, VC++, VB.NET, PL/SQL, HTML, XML

Operating Systems: Win NT, Win 98/2000/XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Hyperion Essbase / Planning/HFM Consultant

Environment: Hyperion Planning V 11.1.2.1, Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, Essbase Administration Services (EAS), Shared Services, Hyperion Financial reporting 11.1.2.1, FDM, Oracle Hyperion Financial Management (HFM) 11.1.2, Oracle Database 10g.

Responsibilities:

• Actively participated in defining requirements, functional specifications, design documentations and test strategies.
• Developed EPMA application in Hyperion System 11.1.2.1, Configuring Hyperion Essbase
• Involved in creating Rule files for dimension building and data load process and created scripts in MAXL for automating these processes
• Created Organizational detailed and Financial reports for 10 year Depreciation projections using Hyperion Reports and Financial Reporting Studio.
• Wrote new, and optimized existing calculation scripts for SLN Depreciation calculations, Transfer of Assets and Retirements.
• Integrated FDM to HFM and Planning for loading Data.
• Creation of multiple dimensions in different applications, loaded members in Hyperion Planning and HFM using Hyperion Application Link (HAL)
• Created webforms for showing 10 year projecitons of Forecast/Plan, Project ID creation, Variance Reporting and Summary Reports.
• Assisted with maintenance functions of existing HFM implementation, updating Web Forms, HFM Value retrieval.
• Trouble shoot Hyperion application issues by root cause analysis, debugging, bug fixing, production support and maintenance and provide resolution
• Performance Tuning of Calculation scripts.
• Conducted in-depth financial analysis for data reconciliation and consolidation across over 50 subsidiaries using HFM data generated reports. Reports were designed using Hyperion Financial Reporting obtained from Workspace.
• Applied HFM to create dynamic Balance Sheets, Cash-Flow statement, financial and market forecasting through data retrieved from Essbase.
• Provided training to end users in using the Samrtview add-in and Web forms to enter data.
• Assigned accesses and privileges to various end users in different planning applications using Shared Services.
• Specific role as Essbase Administrator involved Shared Services security development for Essbase, HFM and Planning.
• Worked with the Infra team to assist with migration of Applcation from one environment to another, Generated dimension outline extract using LCM.

Confidential, Chicago, IL

Sr. Hyperion Essbase / Planning Consultant

Environment: Hyperion Planning V 11.1.2.1, Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, Essbase Administration Services (EAS), Shared Services, Hyperion Financial reporting 11.1.2.1, HFM, FDM, ODI, Oracle Database 10g.

Responsibilities:

• Actively participated in defining requirements, functional specifications, design documentations and test strategies.
• Designed, developed and implemented the planning and reporting system for the financial department.
• Developed application in Hyperion System 11.1.2.1, Configuring Hyperion Essbase,
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass Model.
• Involved in creating Rule files for dimension building and data load process and created scripts in MAXL for automating these processes.
• Designed Reports against HFM.
• Created Budget and Financial reports using Hyperion Reports and Financial Reporting Studio.
• Wrote new, and optimized existing calculation scripts
• Wrote batch commands and scripts in EssCmd and MaxL
• Wrote the Rule file for translations and calculations in HFM Application
• Extensive experience in Essbase retrievals, Lock and Sends, Multi form retrievals.
• Responsible for dimension builds, Parallel calculations, Business Rules and member formulas.
• Performance Tuning of Calculation scripts.
• Designed data integration using Oracle Data Integrator (ODI) by setting up sources and targets using ODI Topology Manager, creating Designer models, developing integration interfaces and additional components
• Experience in Building dimensions using Load Rules File, Load data using Rules files, two pass calculations.
• Trouble shoot Hyperion application issues by root cause analysis, debugging, bug fixing, production support and maintenance and provide resolution
• Developed Data Loads and numerous Calc Scripts and optimized them.
• Designed, developed and implemented the planning and reporting system for the financial department.
• Created planning applications using EPMA and Planning studio.
• Created and managed numerous Web Forms and created Business Rules for multiple applications.
• Generated reports relating to Income statement and Balance sheet using Financial Reporting Studio
• Provided training to end users in using the Samrtview add-in and Web forms to enter data.
• Assigned accesses and privileges to various end users in different planning applications using Shared Services.

Confidential, Chicago, IL

Sr. Hyperion Essbase / Planning Consultant

Environment: Hyperion Planning V 11.1.1.3, Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, Essbase Administration Services (EAS), Shared Services, Hyperion Financial reporting 11.1.1.3, HFM, FDM, ODI, Hyperion Interactive reporting 11.1.1.3, Oracle Database 10g.

Responsibilities:

• Actively participated in defining requirements, functional specifications, design documentations and test strategies.
• Developed application in Hyperion System 11.1.1.3, Configuring Hyperion Essbase, Essbase integration services, for the end users.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass Model.
• Hyperion Planning application to consolidate the Planning data from all its markets across the globe.
• Managed Enterprise Performance Management Implementation practice.
• Coordinated with DRM and ETL team.
• Involved in creating Rule files for dimension building and data load process and created scripts in MAXL for automating these processes.
• Created Data integration process to load data from file systems into Hyperion Planning using Oracle Data Integrator (ODI).
• Created Budget and Financial reports using Hyperion Reports and Financial Reporting Studio.
• Wrote new, and optimized existing calculation scripts
• Wrote batch commands and scripts in EssCmd and MaxL
• Extensive experience in Essbase retrievals, Lock and Sends, Multi form retrievals.
• Responsible for dimension builds, Parallel calculations, Business Rules and member formulas.
• Performance Tuning of Calculation scripts.
• Experience in Building dimensions using Load Rules File, Load data using Rules files, two pass calculations.
• Creation of planning models, data integration components.
• Trouble shoot Hyperion application issues by root cause analysis, debugging, bug fixing, production support and maintenance and provide resolution
• Designed data integration using Oracle Data Integrator (ODI) by setting up sources and targets using ODI Topology Manager, creating Designer models, developing integration interfaces and additional components
• UtilizedODIto load data from Oracle GL and Legacy systems intoplanning. Responsible for setting up all dimensions, members and measures.
• Configured ODI agent and leveraged LKM modules to define workflow and task automation.
• Used Journalization feature of ODI in-order to keep track of changes in data at the source level
• Used Operator GUI to schedule and automate data load processes through ODI
• Developed Data Loads and numerous Calc Scripts and optimized them.
• Designed, developed and implemented the planning and reporting system for the financial department.
• Created planning applications using EPMA and Planning studio.
• Created and managed numerous Web Forms and created Business Rules for multiple applications.
• Generated reports relating to Income statement and Balance sheet using Financial Reporting Studio and Interactive Reporting Studio.
• Generated reports relating to Revenue analysis using Web Analysis Studio.
• Redesigned currency conversion scripts to facilitate reporting in more than one currency.
• Provided training to end users in using the MS Excel spreadsheet add-in and Web forms to enter data.
• Assigned accesses and privileges to various end users in different planning applications using Shared Services.

Confidential - Farmington Hills, MI

Sr Hyperion Consultant

Environment: Hyperion Essbase 6.5, Hyperion Planning 3.5.1, Hyperion Reports 7.0, HFM, ODI, FDM, Hyperion Analyzer/Web Analysis, Windows 2000, Web Logic, Excel Add-In, Business Objects, MaxL & VB Script, Microsoft Project, MS Excel, Office, Calculation script, Visio, SQL, PL/SQL, ETL, SQL Server, PowerPoint, SharePoint, Rational clear case, clear quest.

Responsibilities:

• Created numerous reports in Financial Reporting Studio on Income Statement, Statistics, Net Revenue, Net Income and Expenses to calculate Budget and Actual: Summary and Detailed reports, Monthly and Quarterly reports, Consolidating and combined reportsExtensively worked with Excel Add-In, Smart View, Hyperion Workspace, Hyperion Reports and Hyperion Analyzer
• Provided technical support to all business units, offered suggestions and proposed solutions to resolve issues
• Managing monthly load of actual from source systems.
• Developed the HAL routines to automate the dimension building
• Recommend improvements/changes to HFM member lists, Planning/Essbase User Defined Attributes, Alternative Reporting Hierarchies
• Modified Business Rules to cater to the changing business requirements
• Strong knowledge and experience on Administrating of Hyperion Essbase, Planning, HFM, FDM, Workspace, Shared Services
• 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
• Ensuring proper collection and consolidation of data for reporting.
• Design, code and testing functions, technical requirements Hyperion planning and budget module.
• 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
• Developed various MaxL and Shell Scripts to automate data loads and partitions
• Created Essbase outlines based on report specifications and schema delivered
• Performed member and data loads in Essbase Integration Services
• Involved in setup and security measures and granted access to users and assigned then to specific user groups through Shared Services based on their needs
• Provided Essbase administration and optimization training to resident technical resources
• Developed and administered reports with Hyperion Analyzer/Web Analysis and Hyperion Reports. Built simple and complex views of data; created spreadsheet reports, graphs, and pin board displays; set traffic lighting; and managed formats
• Supporting month end Financial Reporting activities

Confidential - EDINA, MN

Hyperion Planning/Essbase/Reports Consultant

Environment: Hyperion Planning V 11.1.1.3, Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, Essbase Administration Services (EAS), Shared Services, Hyperion Financial reporting 11.1.1.3, HFM, FDM, ODI, Oracle Database 11g, Windows Server 2008, MS Excel 2010.

Responsibilities:

• Optimized and rewrote MDX codes in ASO member formulas in Hyperion System 11.1.1.3.
• Restructured ASO cubes as a part of optimizing ASO applications to bring down runtime and database size considerably.
• Changed Compression Dimension and used TB properties to enhance performance.
• Designed and materialized aggregation using query tracking and ratio method and automated the aggregated view creation.
• Wrote aggregation script in MaxL. And was involved in the Automation using MAXL Scripts and scheduling the batch scripts.
• Involved in the creating Filters and assigning filters to users in Essbase for ASO Cubes.
• Extensively involved in performing DBA activities like performance tuning the Calculations scripts, database tuning, and taking the Essbase backups and maintenance of previous Essbase cubes.
• Loaded the Actual Data on monthly basis into Consolidation Application.
• Worked on financial reporting. Build various reports using Prompts, User POV, Grid POV, Conditional Suppression, and Conditional Formatting and used formula in it according to the recipe provided by users.
• Worked on creating Smartview reports. Build complex Smartview reports which had complex formulas, display sheet used to pull data from various other sheet which were for data retrieval or for complex formulas. An input sheet was provided for reducing the effort for user to change the month and year in each cell, helping reducing the error caused by them in changing and providing fast and accurate reports.
• Changed solve order in ASO Cube for easier maintenance and support two pass calculation accordingly.
• Updated ASO cubes to synch with new changes in production, Performed unit testing and bug fixing.
• Assisted migration of cubes from staging to production servers.
• Documented all changes made to the ASO cube as a reference for the end users and for easier maintenance.