Hyperion Planning, Essbase, Financial Reports

Mukundsree Gelli

Senior Consultant (Oracle Hyperion)

Oracle Hyperion Planning 11 Certified Implementation Specialist

PROFESSIONAL EXPERIENCE:

Highlights of Experience

. Almost SEVEN years of experience in implementing Hyperion Business

Intelligence/ Hyperion Business Performance Management solutions.

. Expertise in Hyperion tools including Planning, Essbase, Financial

Reporting, Web Analysis.

. Completed six Hyperion Planning implementations (4 new and 2

enhancement), and three Essbase implementations (2 new and 1 enhancement)

and few support projects.

. Worked extensively on Hyperion Business Rules, Load Rules, Calc Script,

outlines development and optimization

. Worked on integration tool like ODI to build interfaces, packages,

scenarios and batch jobs to automate the same.

. Worked as offshore project lead and offshore -onsite coordinator

Key Accomplishments

. Leading offshore team (3 resources) for project deliverables

. Independently delivered modules like Opex, Revenue, Balance Sheet, Cash

Flow, Profit and Loss etc.

. Designed. Developed and delivered ODI interfaces, packages for metadata

updates.

. Offshore consultant for planning implementation project

. Hyperion Developer & Analyst for implementing Hyperion Planning, and

Oracle Essbase

. Hyperion Consultant for requirement gathering, design and development

financial reports

. Data integration across cubes (BSO & ASO) using MAXL and batch automation

. Offshore consultant for a maintenance project, providing 24 X 7 support

to US, APAC and Europe regions

Relevant Work Experience

ADI Strategies, Pune, India.

Senior Consultant

2010

Apr to present

Offshore Lead for Gogo LLC. [ Current]

(Classic Planning)

Formerly known as Aircell, Gogo has quickly become the world's leading

provider of inflight connectivity, and has revolutionized travel with our

unique brand of exclusive in-air experiences. Gogo is the only company

authorized by the FCC and FAA to use cellular frequencies for in-flight

communication. Using Gogo's exclusive network and services, passengers with

laptops and other Wi-Fi enabled devices can get online on all domestic

AirTran Airways and Virgin America flights and on select Air Canada, Alaska

Airlines, American Airlines, Delta Air Lines, Frontier Airlines, United

Airlines and US Airways flights - as well as on thousands of business

aircraft - bringing the total to more than 6,000 Gogo equipped aircraft to

date. Gogo is implementing Oracle Hyperion Planning solution for doing

companywide budgeting and reporting of P&L, Balance sheet, Cash Flow,

Workforce, Capex and revenue

- Team lead in phase1-UAT, phase-2 and phase-2 extension

- Requirement gathering, design sessions with Client and Onsite PM for

various modules

- Design document for Cash Flow, BA Revenue, CA Revenue and Installation

Modules

- Design, develop,test and deliver Cash Flow Module and Smart View

reports

- Redesign Capex, Opex, INSTALL, Revenue, P&L and Balance Sheet Modules

for LTM (Long Term Model)

Offshore Lead for Dexcom.

(Classic Planning)

DexCom's roots stem from 1967 research on implanted glucose sensors at

the University of Wisconsin, and started with a focus on creating an

implantable sensor that the body would not reject and that would perform

for a long period of time.[1] With over 40 patents,[2] Dexcom's Sensor

technology is based on this research.. Dexcom is upgrading their existing

Oracle Hyperion Planning system from 11.1.1.3 to 11.1.1.4. Along with

upgradation they are fine tuning the existing process and artifacts to

simplify the planning process. Thye have Capex, Workforce, P&L and balance

Sheet modules.

- Analyze and optimize existing processes

- Optimized business Rules/ calcscripts

- Data and metadata automations

- Migrating data load process from ODI to Essbase load rules

Offshore Consultant for WILTON Enterprise Inc.

(EPMA Planning, HFM, FDM)

Wilton Enterprises, based in Woodridge, Illinois, and founded in 1929, is

the leading food crafting company in the industry, with the number one

position in cake decorating, bakeware and tea kettles. Today, Wilton

Enterprises offers the industry s most comprehensive and innovative

selection of baking, cake decorating, candy making, cookie making, wedding,

baby, party, seasonal, kitchen and hydration products. Wilton is

implementing Oracle EPMA solution for doing companywide budgeting and

reporting of P&L, Balance sheet & Cash Flow

- Design document for Cash Flow Module

- Created Outline members / hierarchy for Cash Flow

- Web forms to input and report Cash Flow (Forecast and Actual)

- Business rules to compute Cash Flow

- Develop and test the module.

Offshore Consultant for SECURITAS INC.

(Classic Planning, Essbase, ODI, Automation)

Securitas services a wide range of customers in a variety of industries and

customer segments. The protect homes, workplaces and society. Their core

business is security services and is specialized in guarding, mobile

security services, monitoring and consulting and investigation services.

Securitas operates in North America, Europe, Latin America, the Middle

East, Asia and Africa. They have four business segments viz. Security

Services North America, Security Services Europe, Mobile and Monitoring,

Security Services Ibero-America. Securitas is implementing Oracle Hyperion

solution for doing companywide budgeting and reporting of P&L, Balance

sheet & Workforce.

- Designing & developing Planning cubes

- Rules / Calc scripts for running business logic in Calc manager

- Creating ODI interfaces to integrate Hyperion with PeopleSoft

hierarchy.

- Data & Metadata integration between PeopleSoft, and Hyperion (BSO and

ASO)

- Automation with MAXL, ODI packages and Batch scripts

- UAT for Balsheet Module, ODI and automation.

Offshore Consultant for FLUOR

(Classic Planning, Essbase, ODI, Reports, Automation)

Fluor is a FORTUNE 500 company that delivers engineering, procurement,

construction, maintenance (EPCM), and project management to governments and

clients in diverse industries around the world. For nearly a century,

clients have selected Fluor as their company of choice to complete

challenging projects in remote parts of the world. FLUOR is implementing

Oracle Hyperion solution for doing companywide budgeting and reporting of

P&L, HR and Capex.

- Designing & developing Planning cubes

- Rules / Calc scripts for running business logic in Calc manager

- Metadata updates using load rules

- Data integration between planning, staging and reporting cubes

- Data validation after integration

- Automation with MAXL

Offshore Consultant for Rambus

(EPMA Planning, Essbase, Reports, Automation)

Rambus is one of the world's premier technology licensing companies. As a

company of inventors, Rambus focuses on the development of technologies

that enrich the end-user experience of electronic systems Rambus licenses

both its world-class patent portfolio, as well as its family of leadership

and industry-standard solutions. Rambus has offices in California, North

Carolina, Ohio, India, Germany, Japan, Korea, and Taiwan. Rambus wanted to

use Hyperion to perform their annual Budget, mid yearly forecast and

management reporting for P&L, HR and CAPEX.

- Designing & developing Reporting cubes

- Creating complex load rules to load data from SQL (mapping,

rejections, etc.)

- Load & validate historical data for 10 years

- Rules / Calc scripts for running business logic in Calc manager

- Data integration between planning and reporting cubes

- Data validation after integration

- Designing Financial reports

- Post implementation support

Offshore Consultant for Harmonic Inc (Monthly Rolling Forecast Process)

(Planning, Essbase, Automation)

Harmonic is a leading provider of video delivery solutions to broadcast,

cable, satellite, Internet, mobile and telco video service providers

worldwide. Harmonic wanted to leverage existing planning system to perform

their monthly rolling

forecast. Goal was to keep the forecasting process very similar to the

existing annual planning cycle so that users are can use the system without

much training.

- Developing web forms to input data for 2 years

- Rules / Calc scripts for running business logic across years

- Load rules for integration between planning cubes

- Data movement from planning to Actual cube

- Automation of the entire process

- Data validation

- Documenting admin activities for the process

Offshore Consultant for AMCOR

(Essbase, Reports, Automation)

Amcor is a global leader in responsible global packaging solutions

supplying a broad range of plastic (rigid & flexible), fibre, metal and

glass packaging products to enhance the products consumers use in everyday

life. AMCOR was upgrading the system to latest version of Hyperion and

wanted to restructure, optimize and create its Planning applications and

optimize the existing processes.

- BSO Cube Migration

- ASO Cube Creation

- MAXL Scripts for automating monthly tasks on essbase cubes.

- Creating and redesigning Web Analysis Reports

- Data Validation

Offshore Consultant for Levi Strauss & Co.

(Planning, Essbase)

Levis Strauss & Co. is 150 year old company into business of retail

garments with worldwide presence. Levis has a huge Hyperion setup to

support its business worldwide and was broadly divided as US, Europe and

APAC region. Applications involved were Hyperion Essbase, Financial Data

Quality Management, Financial Management, Financial Reports, Web Analysis,

SmartView and Excel Reports.

- On call support for high severity issues 24x7.

- Problem troubleshooting

- Performance improvements and software tuning

- Maintain and modify metadata, formulas and security access

- Maintain and modify the Hyperion Essbase Application cubes

AlHoshan Consultants, Riyadh, Saudi Arabia

2008 Oct - 2010 Mar

Consultant

Onsite Consultant in Saudi Telecom Company (STC) (Hyperion Financial

Planning & Budgeting)

(Hyperion Essbase, Reports, Automation)

STC is the leading national provider of telecommunication services in the

Kingdom of Saudi Arabia. Every year STC has many projects from various

Business Units and Functional Units. There is SPED department for

evaluation and study of the proposed projects. Hyperion implementation

helps them analyze the data of different projects on ROI, Pay back, IRR,

Cash Flow etc. The complicated computations for analysis are done in

Hyperion calc scripts. It also reduces the time required to create periodic

management reports for Board meetings with the help of Hyperion Provider

Services.

- Assisting Project Lead for Requirement gathering

- Designing outline Prototype and actual outline

- Designing Calc Scripts for forecasting, budgeting and consolidations

- Designing Load rules to load metadata and data from Oracle Views

- Designing Financial Reports

- Responsible for UAT

- Project coordinator in absence of Project Lead (PL used to travel

frequently)

- First point of contact for users for any issue (onsite for complete

implementation)

Thirdware Solution Ltd, Mumbai, India

2006 Sep - 2008 Aug

Senior Software Engineer

Onsite Developer for Vedanta Resources Plc (Planning)

(Hyperion Planning. Essbase Reports)

Vedanta is a FTSE 100 metals and mining company with principal operations

located throughout India and additional operations in Zambia and Australia

and their operations are carried out through its Various Subsidiaries

(entities).Vedanta has their annual budget process carried out in excel

model. Data used to come from all entities there use to be discrepancy in

data and model file which was very difficult to consolidate. Hyperion

Planning builds a common model where all Entities (Subsidiaries) put in

data which corporate validate and then use for consolidation and report

generation. Being a multi dimensional database it also helps to analyze

data very fast and focused.

- Creating Outline

- Creating / Testing / Optimizing business Rules

- Design Financial Reports

- Setup UAT plan and single point of Contact for UAT (all subsidiaries)

-

Offshore Developer for General Mills (Forecast Process)

(Hyperion Essbase)

General Mills India Pvt. Ltd. currently plans the demand of its various

product families and SKUs on different time lines. Currently, the task is

accomplished in excel sheets, which provides limited analytical

capabilities. The objective of the project is to enable a consistent system

based centralized sales forecasting and planning process. Also, it will

provide a multidimensional database which facilitates the analysis by

slicing and dicing of information.

- Assisting the onsite team with various activities like testing,

optimization, R&D etc. from offshore.

Offshore Developer for Duty Free Shopping (Management Reports)

(Hyperion Financial Reports)

Duty Free Shopping (DFS) has businesses spread across large geographical

regions in multiple countries like America, Singapore, New Zealand etc.

Also they have a portal from where customer can buy anything on Internet.

In such wide spread business scenario and today's competitive world, DFS

corporate management needs to keep track of their business across all

regions for any strategic decision to be made. So to make them available

all historical data, to take management level decisions fast as per the

business needs, Hyperion has been implemented as business intelligence

tool.

- Designing and testing Hyperion Financial Reports

EDUCATION

. Bachelor of Engineering in Computers (4 years), Mumbai University, India

(2006, Gross Avg.: 60.71%)

Contact this candidate