Hyperion Planning/Essbase consultant with 6.4years of experience

Ankit K Shah

Email: **************@*****.*** Phone: +91-992*******

Summary

Ankit has about 6.4 years of professional work experience as Hyperion consultant, most of which

is on requirement analysis, design, training, development, maintenance and support across

different domains with Hyperion as Business Intelligence tool

His areas of expertise include Oracle Hyperion Essbase, Hyperion Planning, Hyperion Financial

Reporting and Web Analysis

He has developed Essbase Custom defined functions (CDF) and Essbase JAVA API to cater to

client's complex requirements

He is a certified Oracle Hyperion Planning 11 Implementation Specialist

He has created Essbase – OBIEE integrated reporting point of view

Technical skills

Hyperion Planning, Hyperion Essbase, Hyperion Application Link, Hyperion

Tools

Analyzer (Web Analysis), Hyperion Interactive Reporting, Hyperion Financial

Reporting, IBM Cognos Command center, IBM Cognos Integration server (star

analytics) and OBIEE

Windows (2003/2008 server), Linux (Solaris/Red Hat)

Operating System

Education

2003 2007 University of Mumbai, India

B.E. in Computer Engineering First Class with Distinction

Courses undertaken were database management system, Advance database management system and

others

Certifications

2013 Oracle Hyperion Planning 11 Certified Implementation Specialists

2009 Hyperion Certified Planning Administrator 9.3 (Oracle Certified Expert)

2008 Hyperion Certified Essbase Developer 9.3 (Oracle Certified Expert)

Work Experience

DELOITTE CONSULTING INDIA PVT LTD

OCT ’11 TO TILL DATE

Designation: Consultant

Project 1 Implementation of Budgeting and Forecasting System

Studying and understanding the requirements of planning application.

Developing Planning data web –forms, business rules using calculation manager

Designing Essbase Custom defined function (CDF)

Developed customized Essbase JAVA API to cater to client's requirement (as

feature requested by client was not available in Essbase v11.1.2.1)

Designing ASO Reporting cube, designed MDX formulae

Building data transfer interface using IBM Cognos command center(Star

Analytics)

Developing reports using Hyperion Financial Reports tool

Helping onsite team members in understanding HFR tool and promptly resolved

FR related issues raised by client/onsite team members offering best possible

solution

Responsible for sending daily status emails to project team from offshore stand

point.

Optimizing code of a calculation script to reduce overall execution time

SYNTEL LTD

OCT ’10 TO OCT’ 11

Designation: Analyst Programmer

Project 2 Implementation of Global Finance Architecture

Performing installation & configuration of EPMA, HPCM, Essbase, Reporting and

Analysis for 11.1.2.1

Designing monthly archival process for Essbase cube so as freeze structure and

data after end of each month

Performing activities such as Essbase filter creation/modification, user

provisioning, resolving production service issues

Project 3 Hyperion Essbase Production support

Optimizing the ASO application data load to reduce overall data load time

Monitoring & resolving error for Production batch jobs

Troubleshooting data variances between source destination systems

Performing month end & yearend maintenance task such as month/year rollover

LARSEN & TOUBRO INFOTECH LTD

JULY ’07 TO OCT’ 10

Designation: Sr. Software Engineer

Project 4 Hyperion Planning System Maintenance and Redesign

Studying and understanding existing application design

Automation of data loading, metadata extraction, dimension building using MaxL

and batch scripting

Setting up email notification for automated processes

Project 5 Implementation of Hyperion Workforce and CapEx Planning

Primarily worked from client location as onsite offshore coordinator

Understanding requirements and implementing in it prebuilt model

Creating Scope, to be process and technical design document

Developing Planning data web –forms, business rules using calculation manager.

Developing Balance Sheet, P&L, Income Statement, Cash Flow and other reports

using FR

Project 6 Up gradation and Migration of Hyperion Products

Providing approach and methodology for the entire upgrade process from version

9.3.1 to 11.1.1.3

Installing and configuring Hyperion system 9.3.1 and 11.1.1.3 in Unix environment

for test/dev/production servers

Performing migration/up gradation of 2 Planning applications,1 Essbase ASO

application and 90 FR reports

Project 7 Reporting System for Multidimensional Analysis

Performing installation and configuration of Hyperion Essbase/Shared

services/IR/FR 9.3.1 for Test/Dev/Prod environment

Studying and analyzing requirement for building Essbase BSO application

Performing basic activities for Essbase like dimension building, and data loading

using administration services console

Automating the Essbase dimension building and data loading activity through

MaxL

Performing POC for showcasing “Essbase partition” feature

Designing static reports (monthly/annual) using Hyperion Financial Reporting tool

Dashboard designing as per user requirement using Hyperion Interactive Reports

and Hyperion Web Analysis tools

Imparting training to End Users for better understanding of Hyperion Data,

Reports and Graphs

Contact this candidate