Badhrinath S

Sr Hyperion Essbase Developer

PROFESSIONAL SUMMARY:

> 8+ years of IT experience as a Developer, Analyst and Module lead in

building up Enterprise Data Warehouse, Real time reporting, Decision

systems in Insurance and Airlines sector

> My technological forte is Hyperion Essbase (11x, 7x, 6.5x) and SAP-

Business Objects (Universe Designer, Business Views, Crystal Reports,

Infoview, CMC).

> Tremendous knowledge in Insurance and Airlines Domains

> Experience in working with end users, mostly decision making managers, in

collecting requirements, bridging the technology and manufacturing

functionalities.

> Worked on end to end project estimation leveraging onsite offshore

efforts aligned towards the project objective and financial goal.

> Has been involved in the migration of Hyperion Essbase from 6x version to

11 x versions.

> 3 years and 5 months of experience in Production application support for

applications developed in VB 6.0.

> Experience in estimating the effort required for giving production fix in

Essbase applications from the developers perspective.

> Experience in getting Knowledge Transfer of applications and sharing the

same with team through Knowledge Transfer sessions.

> Good knowledge and experience in supporting and developing SSIS packaged

applications.

> Experience in training freshers in Hyperion Essbase 6.5.5 version for

three weeks.

> Good Understanding of Airlines Domain with a valid basic certification of

the same.

> Good understanding of Insurance domain with a valid basic certification

in insurance domain.

> Good analytical skills with ability to fix an issue with the root cause

analysis.

> Good communication skills with an experience of 4 years and 10 months in

communicating with both UK and US clients.

> Good team player and also has the ability to work individually..

> Experience in designing and developing SSIS and DTS packages.

TECHNICAL SKILLS:

> Databases : Hyperion Essbase, MS Access,

SQL Server 2000/2005/2008, DTS

Packages with SQL Server 2000, SSIS Packages

with SQL Server

2005/2008

> Reporting tools : SAP Business Objects, Crystal

Reports 2008, Business View Manager,

Basics of Universe Designer, Infoview, CMC

> OLAP : Hyperion Essbase, Hyperion

Spreadsheet Addins

> Operating Systems : Windows OS .

> ETL Tools : Basics of Ab-inito and SSIS

Packages

> Programming Languages : VB Script, Oracle SQL, PLSQL, SQL

> Batch Scheduler/Other Tools : Tivoli Batch Scheduling Console,

IBM Mainframes.

PROFFESSIONAL EXPERIENCE

Client: Southwest Airlines, Dallas, TX

Mar- 2012 -Till date

Role: Sr Hyperion Essbase consultant

Roles & Responsibilities:

. Worked with Subject Matter Experts (SME), business analysts, business

users and with other team members in gathering business requirements,

functional specifications, testing strategies and planning the

project.

. The Ab Initio system which is the source system for the Essbase cubes

has been upgraded from SIRAX to LINUX version. It produces .txt format

data and dimension input files to the Essbase cubes that are critical.

These text files helps in building the Essbase cubes daily, monthly

and quarterly through batch files. These batch files are triggered

through a batch scheduling console TIVOLI.

. Data Load Performance Tuning in the Essbase ASO cubes

. To Create an Error Handling process when the batch job fails or if the

source files are not available.

. Addition of New members for the Metric Roll Up measures and including

them to the rule files to be picked up from the Source file.

. To create a Crystal Report that pulls the Flight Details such as

Flight Date, Number, Origin, Destination, Out Time, In Time, Departure

Gate, Arrival Gate, Flight Type etc for the selected Date from the

Teradata and schedule the report through Infoview to email the

customers on a daily basis.

. Have to create many BO/Crystal reports as per Customer requests and

requirements

. Create a new BO report that provides the customers with the Delayed

and Cancelled flights on a daily basis.

. Create a report to find the Passenger Name Records (PNR) created

between 7 and 14 days ago where the 1st departure date is more than 3

days after the booking date and greater than the report date based on

the entered Pseudo City Code value. PNRs that have been ticketed via

Point Of Sale (POS) or Ticketless or show a form of payment have been

excluded.

. Analyze the business requirement.

. Estimate the effort required by the developer to complete the work.

. Convert the business requirement into technical design.

. Creating a TEST Application and Database with the latest outlines in

the PRODUCTION

Environment.

. Requirement gathering by directly interacting with end users.

. Preparing user requirement document and sign off.

. Development coordination with offshore team.

. Check the quality of the deliverable.

. Develop / review test plans.

. Tracing the requirement with development and test cases.

. Creating status reports and reporting to internal manager and client

side manager.

. Unit Testing

. System Testing

. User acceptance testing.

. Code migration and post migration checks

. Application Support Post.

Environment: Hyperion Essbase 7x, Hyperion Essbase Spread Sheet Addins,

Teradata, Oracle 11g Database, Business Objects, Infoview, Crystal Reports

2008.

VISA INC, Foster city, CA

Apr 2010

to Feb 2012

Senior Hyperion Essbase Developer

Major scope of the project is to Implement Essbase in connection with

financial budgeting, sales forecasting and marketing analysis to produce ad-

hoc reports.

Responsibilities:

. Translated end-user requirements into application design

specifications.

. Assured optimal match between cube design and report specifications.

. Develop new Essbase cubes and database objects or update existing ones

to meet new business requirements.

. Optimized outline structure, loading and calculations through

appropriate dense and sparse settings of dimensions, storage

allocations and by dynamic calculations and debugging.

. Optimized cache settings, established user security, managed

applications migration, established substitution variables and

settings for dynamic time series, asynchronous processing, and

editing/validating scripts.

. Developed and designed cubes using Essbase Integration Services.

. Managed system upgrades and client installations based on users

requirements.

. Developed Batch files using MaxL, and Rules files to upload data from

financial systems Database to Essbase cube.

. Handled performance tuning, weekly back-ups and monthly consolidations

of data and automated monthly/quarterly/annual report generation.

. Developed Analyzer OLAP views and sophisticated what-if scenarios for

the end users.

. Documented and issued procedures pertaining to Essbase applications.

. Provided business analysts with advice and options on opportunities to

leverage the tool and increase usage.

Environment: Hyperion Essbase 7x, Hyperion Essbase Spread Sheet Addins,

Teradata, Oracle 11g Database, Business Objects, Infoview, Crystal Reports

2008.

Client: AXA Sun-life Insurance, Bristol, United Kingdom

Oct 2008- Mar 2010

Role: Software Engineer- Essbase Support

. We have been using the Hyperion Essbase version 6.5.5 for all the

applications and databases. But, now we have to migrate all the

Applications and the databases from the old server with Hyperion

Essbase version 6.5.5 to the new server of the latest version of

Hyperion Essbase 11.1.1

. The financial data will be downloaded from the IBM Mainframe systems

into a .txt file format. This text file is then fed into MIST system

through an interface system called THAT system and from there it is

loaded into Essbase through automation panels. Addition of a new

member to the outline and go through end to end testing through

Essbase.

. Business needs to amend a SSIS package in the production Database

inorder to process an additional input file produced by the business

on a weekly basis, by creatin few more temporary tables in the

database with the help of stored procedures and amend the data along

with the existing Output file that would be provided to the them on a

weekly basis.

. Touch Stone Change in IDM-SDR :

. The financial data without any touch stone code generally flows into a

code named xxx, however the business wanted this to be changed. A new

touchstone code called 90 has to be created and all the data that

comes in without a touchstone code has to flow under this code.

. VB Applications Support.

. Analyze the business requirement.

. Estimate the effort required by the developer to complete the work.

. Convert the business requirement into technical design.

. Creating a TEST Application and Database with the latest outlines in

the PRODUCTION

Environment.

. Requirement gathering by directly interacting with end users

. Preparing user requirement document and sign off.

. Development coordination with offshore team.

. Check the quality of the deliverable.

. Develop / review test plans.

. Tracing the requirement with development and test cases.

. Creating status reports and reporting to internal manager and client

side manager.

. Unit Testing

. System Testing

. User acceptance testing.

. Code migration and post migration checks

. Application Support Post Migration

Environment: Oracle Hyperion Essbase 6.5.5, Oracle Hyperion Essbase 11.1.1,

Hyperion Essbase Spread Sheet Addins, MS Access, SQL Server 2000/2005/2008,

DTS Packages with SQL Server 2000, SSIS Packages with SQL Server 2005/2008

Tata Consultancy services, INDIA

July 2006 Sep 2008

Hyperion Essbase Developer

This application is developed for Lehman Brothers is a global investment

bank serving the financial needs of corporations, institutions, governments

and high net worth investors worldwide. Lehman Brothers deals with variety

of services ranging from Credit Risk Management, Equities, Fixed Income,

Global Economics, e-Commerce, Investment Banking, Lehman Brothers Bank, Ops

& Corp Services, Private Client Services and Private Equity. This purpose

of this project was to automate Listed Derivatives (Futures and Options)

processing, involving Futures Operations Department, Product Data Quality

Group, Trading Systems, Equity Operations Desk, etc. This system enhances

the use of Lehmans Electronic Trading Services.

Responsibilities:

. Designed efficient and effective outlines and calculation scripts and

created rules files to automate dimension building and data loading.

. Used standard Essbase practices of building outlines and partitions,

including level and parent references.

. Expertise in building cube Financial Budgeting and Forecasting OLAP

applications with Essbase Involved in optimization of Essbase server

settings for the best performance, created queries using the Essbase

query designer, created calc scripts.

. Extensively involved in changing the outlines for cubes.

. Child methods of building outlines. Developed calc scripts to derive

complex calculations such as cash cost per user, YTD commitment,

variance, capital expenditure forecast and budgeted cash flow

statements.

. Developed scripts to automate daily backup and consolidations of

monthly data.

. Performed performance tuning and database 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.

. Created ESSCMD scripts to update outlines in batch, load data and

execute calc scripts, during maintenance.

. Involved in administrative activities such as installation and upgrade

of software products including ESSBASE, setting up users, security

groups and access filters to set the security policy and to ensure

maximum security.

. Involved in day-to-day administrative activities such as managing

users on the Essbase server, backing up cubes, identifying and

resolving problems.

. Coordinated with users in getting signoff on the changes

additions/deletions. Involved in the migration of Essbase from version

6.5x to 7.1.6

. Designed and developed Quality Assurance standard and processes to all

levels of project team

. Documented the defects and their trailing history in ClearQuest and

helped developers identify the modules and code sections to be fixed

by executing the related scenarios with different combinations of data

. Identified risks, methods (inspection, review), baseline acceptance

criteria and deliverables

Environment: Hyperion Essbase 7.1/6.x, Hyperion Reports, shell scripts,

Oracle SQL, IBM AIX, UNIX, Shell Scripting, PL/SQL and Oracle 8i.

Contact this candidate