Project Manager

Omi Kaul

Summary Solution-Oriented, Highly analytical Business Intelligence

professional; with extensive experience in analysis, design and

development of various Hyperion reporting solutions for diverse

clients.

Over eight years of experience in Developing and

Maintaining Planning, Budgeting and Forecasting application using

Oracle EPM and BI suite of tools comprising Essbase, Hyperion

Planning, Shared Services, DRM,HAL and EPMA

Strong knowledge of Essbase Functionalities. Knowledge of Essbase

elements & objects -- outlines, dimensions, measures, members,

Calculation Script, Load Rules and Report Scripts - Creation,Update

and maintenance.

Experience in handling migration, enhancements & change requests in

Hyperion Planning, Essbase, Planning and DRM

Knowledge in automating the process using the batches, MAXL & ESSCMD

Experienced in Migrating the versions from system 9 to EPM 11

Designed and developed Essbase and Planning cubes for various

critical reporting solutions

Loaded data manually and using Automation techniques using MAXL

Scripts into the outline developed for data cube.

Maintained outline, metadata, and member formulas as business

requirement changes.

Worked on automation of dynamic dimension building & Loading in to

the Cube using MAXL Scripts.

Excellent working knowledge in writing calculation scripts & MAXL

statements commands in Essbase

Worked on Optimization of Cubes while loading, retrieving and

calculating using different techniques (Hourglass method, Cache

Settings, Buffer settings, Configuration file settings & others).

Used Security using Shared Services to create Users & giving

Provisions and restricting permissions.

Part of the Training campaign for the end-users to provide knowledge

on how to work with Web forms, smart views, business rules to analyze

the data or entering the actual values

Strong experience in interacting effectively with business

stakeholders and technical teams

Excellent analytical and communication skills, verbal and written,

including the ability to articulate complex technical concepts to

non-technical clients

In-Depth work experience on all stages of Software Development Life

Cycle (SDLC) such as developing, testing, Migrating, Administrating,

security management and production support

Regular Interaction with customers to determine business/technical

requirements, analyzing business process and workflows and suggest

improvements.

Demonstrated leadership abilities and team work skills and provide

high quality deliverables.

Excellent analytical and problem solving skills with understanding of

project management.

Good time management skills possess excellent communication &

interpersonal skills.

Have executed various projects for various major Retail &

Pharmaceuticals clients in UK and US

Certification Hyperion Essbase Certified

s HFM Certified

Professional Client: Mondelez International

Experience Oct 2012 - Till Date

Project Name: Support and Enhancements on Essbase Apps

Role: Sr. Developer/ Onsite Lead

Description of the Project:

Mondelez International Inc. is an American multinational

confectionery, food and beverage conglomerate, employing around

100,000 people around the world. It comprises renowned global

snacking and food brands. Mondel?z International makes some of the

best-known snack brands around the globe. The Essbase Support team is

required to provide support to all Essbase Applications and is

accountable for the precision of Key Financial Metrics .The reports

from Essbase are reviewed by Top Level Management .Enhancements in

some Essbase Applications are also in scope.

Responsibilities

Onsite Lead and Coordinator for all Essbase Applications at Mondelez.

Managing a team of more than 10 at offshore to support weekly/monthly

processes of all Essbase Applications and look into data issues,discrepancies, reporting of Essbase Applications

Single point of contact for all Mondelez clients and stakeholders.

Provide weekly updates to client on Essbase Performance and issues

Ensure all support processes are carried out on time and there is no

impact to deliverables

Streamlined and optimized support processes to make them efficient

and Robust.

Was involved in gathering Functional Requirements and converting them

to Technical design and processes, also created the High Level Design

Doc.

Designed new functional processes,created load rules and calculation

scripts in Essbase

Created Validation Templates to ensure the data flow is successful.

Created Report scripts for sending outbound data to BI systems.

Created critical Sales Reports for the Top Brands of Mondelez. These

reports provided detailed insight to the Business on the Market

trends and inclinations.

Designed the process for Incentive payouts in Essbase helping the

user with accurate and fast reports as compared to the old process of

calculating the Incentives in Excel,which was time consuming and

error prone.

Lead Automation and process simplification for many applications

Software:

Excel Add in, Essbase 11.1.2.2

Client: Kraft

Feb 2013 - Aug 2013

Project Name: ROC Overlay Process Implementation

Role: Onsite Coordinator

Description of the Project:

Implement a process to copy Gross Revenue Estimates from a planning

essbase application to ROC Essbase application. Designed templates to

accept Overlays which would add up to gross revenue. Calculated data

is exported to a third application

Responsibilities

Managed team to design overlay templates using essbase API's in VB

based excel

Upgraded the hierarchy to sync up with the source application

Developed report scripts and rule files to move gross revenue

estimates

Modified calculation scripts to include overlays along with member

formulae

Prepared validation reports and exception reports

Implemented batch scripts to automate the process

Worked with users during UAT to ensure smooth functioning of the

project.

Resolved defects and provided continuous support till GO-LIVE

Software:

Excel Add in, Essbase 11.1.2.2

Client: Kraft

Feb 2012 - Oct 2012

Project Name: Essbase Upgrade and Business Split

Role: Offshore Coordinator and Technical Lead

Description of the Project:

Kraft foods Inc. is an American Grocery manufacturing and processing

conglomerate. On 1 October 2012, Kraft Foods Inc. split into

confections business which was taken over by a new company called

Mondel?z International, Inc. and North American grocery business

taken over by a new company called Kraft Foods Group. It was required

to first upgrade the existing Hyperion Applications from V7 to v11 to

enable the Organization to potentially benefit from the latest

functionalities available in the new Version of Essbase. Later, it

was required to split each of the Applications by function and Parent

Company.

Responsibilities

Realized Complex Technical Upgrade of Essbase from v7.1.3 to

V11.1.2.1 across more than 20 production applications and 25

historical applications.

Migrated applications using migration utility and validation of the

objects and data in v11.This required validation and remediation of

existing calc scripts, load rules, report scripts and also creation

of reconciliation templates to verify the data.

Reformed and optimized the entire automation process of data loads,

running of scripts and nightly backups to suit the new server

landscape. This required in-depth understanding of the business

processes and functionality.

Suggested different security migration options for moving complete

security from V7 to v11

Migrated native essbase security/groups/privileges/filters via MaxL .

Requirements were gathered and Products were split between Grocery

Co. and Snacks Co. Calculations, formulas, load rules and reports

were remediated as needed w.r.t split

Essbase VB api based reports upgraded and made compatible with the

target version of Hyperion Essbase

Upgraded and modified the Custom Toolbar used in Excel Add-in

according to target version of Hyperion Essbase with minimal

documentation.

Involved in User training, UAT and Application Support

Software:

Excel Add in, Essbase 11.1.2.2, Essbase 7,VB Reports

Client: AstraZeneca

Aug 2009 -Jan 2012

Project Name: AZ - Problem and Change Management

Role : Change Manager/Problem Manager

Description of the Project:

AstraZeneca Problem and Change management teams are involved in the

problem resolution for the BI related applications. Also involved

in getting the applications into the BAU mode for smooth production

support and service enhancement requests for various applications

Responsibilities:

Change manager - to ensure defect free delivery of the requested

enhancements within the scheduled timelines and SLA.

Problem Manager - to provide appropriate root cause analysis for

recurring problems to avoid issues in the applications

Interacted with customers to determine business/technical

requirements, issue resolution.

Was involved in Planning and tracking the requirements through the

entire life cycle.

Defect analysis and Support in the Testing and deployment phases.

Implemented native security in Essbase.

Software:

Hyperion Essbase, Hyperion Planning, HAL, DRM.

Client: Starbucks

Mar 2009 - August 2009

Project Name: Starbucks EPM Applications

Role Offshore Team Lead

Description of the project:

Starbucks Corporation is an American global coffee company and

coffeehouse chain based in Seattle, Washington. Starbucks is the

largest coffeehouse company in the world, with 20,891 stores in 62

countries. Starbucks, California wanted to centralize the flow of

Metadata across the EPM products by using EPMA and automate their

Reporting in Essbase/Planning and HFM

Responsibility

Lead the team to produce hierarchies in EPMA using Flat files and

Interface Tables.

Helped team to resolve errors to deploy the hierarchies as a part of

Hyperion Planning and HFM Applications.

Defining flow of data to be loaded in different Hyperion systems.

Automated the process using Batch Client Utility

Loaded Data into the HP and HFM cubes

Created ICP Transactions in HFM and submitted reports for ICP's.

Software:

Hyperion Planning, Essbase, HFM, EPMA

PRIOR EXPERIENCE OUTSIDE INFOSYS

Company worked for: GENPACT INDIA

Years of Work : May 2005 to 23 Jan 2009

Worked As: LEAD ASSOCIATE CONSULTANT May 2007

to 23 Jan 2009

Project Name: GE Aviation Project

Client: GE Commercial Aviation Services

Role: Offshore Team Lead

Description of the project:

GECAS is a leading global player in commercial aircraft leasing and

finance. They have 28 offices and over 225 customers around the

world. The Financial Metrics of the Company were being computed/

Planned in Hyperion Essbase and Planning which was the source of

their Balance Sheet and P&L statements too

Responsibility:

Managed the various Planning Sessions (budget/forecast) for GECAS

Hyperion users.

Also taking care of month-end Closes and Quarter Closes

Stabilized and optimized some the most important and frequently used

processes in the system.

Mentored new team members to bring them up to expectations of

customer.

Hardware: UNIX /Windows

Software: HP, Essbase, HAL, Excel Add-in

Project Name: CDF Hyperion Integration

Jan 2007 to May 2007

Client: GE Commercial Finance

Role: Onsite technical resource

Description of the project:

The CDF Integration project involved the merging of CDF business with

the CAPITAL Solutions cube so as to provide one consolidated

Reporting structure.

Responsibility:

Worked as Onsite technical resource (3 months-from Jan to Mar) and

maintained metadata, first in the form of HMA and later MDM (Master

Data Management- this tool has replaced HMA)

Designed complex MDM Automators required in building the hierarchy.

Effectively managed/maintained Closing cube which is Hyperoll based.

Maintained the Complete Wing-to-Wing process for consolidation cube

(involving MDM/HMA, Staging area, HAL, Planning and Essbase)

Developed logic for loading business-specific data from one cube to

the other.

Prepared recon templates and did detail level Reconciliation.

Set up security of users and groups with different access in Planning

and Essbase.

Created the Issue -Tracker Template for all Hyperion/Staging and MDM

related issues

Hardware: Unix/Windows OS

Software: Hyperion Essbase, Planning, MDM, HAL

Project Name: Tax Hyperion Implementation

Dec 2006 to Mar 2007

Client: GE Commercial Finance

Role: Onsite technical resource

Description of the project:

At GE Commercial Finance, the computation of task was manual and

error prone. It was required to automate the Tax Calculation in

Essbase for Long Tem/Short term and Middle term accounts

Responsibilities:

Developed an automated system to Calculate TAX for Tax users in GE

Commercial Finance.

Created Calc Scripts to calculate Functional Interest based on the

nature of

Account (Long Tem/Short term and Middle term accounts)

Created Optimized report scripts to extract data from Tax cube.

Designed load rules to load data into a different cube where TAX

numbers were required to be submitted.

Design of outline for optimized performance.

Wrote MAXL Scripts for Creation of users and groups.

Reconciliation of data between Hyperion Essbase and Templates

provided by Tax users to validate numbers in Hyperion.

Created an automated Appworx chain for the entire Wing-to-Wing

process

Design & Review of test cases.

Hardware: Unix/Windows OS

Software: Hyperion Essbase

Project Name: Capital Solutions Hyperion Implementation

Jan 2006 to Dec 2006

Client: GE Commercial Finance

Role: Offshore Team - Development/Onsite Team - UAT

Description of Project:

The Capital Solutions Implementation project was an integration of 4

GE Business into one. This would help in one Consolidated Reporting

for Corporate Teams rather than looking into many individual reports

with partial data.

Responsibilities:

Suggested Transparent Partioning for Two Databases in Capital

Solutions as the cubes had very large size, as it was merger of 4

different businesses into one. Tested the different design options

(of dense-sparse settings, load time, calc time and Block density) to

get optimized performance.

Designed load rules, report scripts in Essbase to load and extract

data. Reduced execution time of reports by optimizing them.(from 3

hours to 10 minutes)

Designed HAL jobs to build metadata in Planning; built HAL exe's to

make the HAL jobs platform independent.

Automation of data movement process from one application to another,

created appworx Chain. The process was automated to move all level 0

and higher-level data from one application to the other.

Build the user interface (forms) for users; created 50+ webforms,

also giving right access to more than 600 users was very important.

Assigned access on the dimensions thus allowing users to only view

the data and metadata relevant to the business.

Single handedly managed and resolved all UAT issues and bugs (related

to data and metadata) as the technical person from onsite (3 months

Onsite-from Aug to Nov).

Prepared reusable reconciliation templates for data validation and

did detail level reconciliation to check if all data is correct at

the Business levels and HQ level.

Independently handled Complete Wing-to-Wing Process for the

Consolidation cube (used to submit numbers to Corporate and for

Planning and Budgeting), which involved HAL, Planning, Essbase and

Appworx.

Created Process documentation and provided all necessary details

required to support the Application, created User manual, Operational

manual and Appworx document which are very important for the upkeep

of the Application, understanding the business requirements and

implementing them.

Hardware : Unix/Windows OS

Software : Hyperion Essbase, Hyperion Planning, HAL

Project Name: CFS Hyperion Essbase and Planning Implementation May

2005 to Dec 2005

Client: GE Commercial Finance

Role: Offshore Team -Software Developer

Description of Project:

The load of numbers to Corporate had to be accurate and precise. The

CONSOLIDATION cube was a summary level Essbase model which took

inputs from detailed level Essbase model and realigns it for

submission to Corporate.

Responsibilities:

The project was to do Planning and Budgeting for CFS US (Commercial

Financial Services) and to finally send to Corporate.

It involved two Hyperion Applications -one to do the Variance

Analysis and Planning and the second to submit numbers to GE

Corporate.

Designed load rules and report scripts in the Essbase Consolidation

cube to load data and extract numbers from Consolidation cube

Assigned security in Essbase and Planning

Also modified existing Calc scripts of GE Corporate to meet the

requirements in CFS.

Made user manual and Click-stream documents to simplify the

understanding of the users.

Hardware: Unix/Windows OS

Software: Hyperion Essbase, Hyperion Planning, HAL

Contact this candidate