KARUN REDDY [pic]

Hyperion Infrastructure Administrator

E-Mail:acf763@r.postjobfree.com

Mobile: 917-***-****

Work:713-***-****

SUMMARY:

. Over 11 years of total experience with Hyperion products which

includes EPM 11, System 9.3.1, 9.2 and 9.0.1 (Planning, Essbase& HFM)

Hyperion Analyzer.

. Over 10 years of experience in administering Hyperion products which

includes upgrades, security setup, performance tuning, end user

support, trouble shooting & production support.

. Over four years of experience in creating reports using Hyperion

reports, Hyperion Analyzer and AlphaBlox App. server.

. Assist in managing users and security as needed and recommend Best

Practices in the Hyperion world.

. Provide user support and other ad hoc requests and manage Hyperion

Services for up-time.

. Administration and setup of Hyperion Dev, QA, Sandbox and Production

environments.

. Over six years on scripting experience using UNIX (shell scripting)

and HTML under WINDOWS NT/XP and also extensive experience in RDBMS.

. Recommend corrective actions for issues, taking into account user

needs and IT resources.

. Basic maintenance of applications HFM, FDM, Hyperion Planning,

Essbase, & Financial Reporting. Experience in EPM trouble shooting,

tuning, disaster recovery, backup and restore

. Five years of experience in creating web forms and reports for

budgeting and forecasting using Hyperion Planning, Analyzer and

Hyperion Reports.

. Five plus years of Oracle, DB2, PL/SQL, SYBASE years of experience.

. 3+ years using Data Modeling experience using Dimensional Data

Modeling.

. Trained end users, ability to synthesize data, perform quantitative &

qualitative analysis. Excellent communication, interpersonal &

analytical skills. Have good team management & decision-making skills.

Ability to work in teams as well as independently.

. Superior communication skills, strong decision making skills,

organizational skills, and customer service oriented.

Technical Summary:

Operating MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP/03/08

Systems

Languages SQL, PL/SQL, C, C++, Java, JSP, XML, Visual

Studio.Net

Web Design HTML, MS FrontPage, Dream Weaver, Macromedia

Flash

Databases EssBase, Oracle11R2,10g,9X/8.x/7.x/6.x, MS SQL

Server 2000/7.0/6.5, MS Access 2000,

DB2,PeopleSoft,Sybase

OLAP Tools Hyperion Essbase 6.1, EAS 6.5/7.1/.3.1,

Development 9.2.03.,901& 11.1.2.x, EIS 6.5/7.0/8, MS Excel

spreadsheet add-in,Informatica5.1/6.1

Business EPM 11.1.2, System.9.3.1, 9.2.03. & 901, HFM

Intelligence 9.3.1, 9.2.03&901,

Tools Hyperion Planning 4.1.1.1, 9.2.03., 901,

9.3.1&11.1.2 Hyperion Application Link (HAL).

HPCM, DIM, FDM, Shared Services

901,,9.2.3,9.3.1, 11.1.2.1 and 11.1.2.3

Reporting System9 Financial reporting, Hyperion Analyzer

Tools 6.x, Hyperion Reports2.6, BI workspace 11.1.2.x,

9.3.1, 9.2.03. & 901, Brio SQR 8, Business

Objects 5./6.X,Alpha Blox app server

Web Servers Apache Tomcat, Web Logic Server, Web sphere

Sr. Hyperion Infrastructure Administrator-Hyperion Apr'06- Till

date

Kellogs Brown&Root, Houston, TX

Project Description:

KBR is one of the world's largest providers of products and services to the

oil and gas industries and also a leading government services contractor as

well. The objective of the project is to design the planning applications

for the purpose of planning, budgeting and forecasting for the Planners and

the End Users using the EPM modules, Hyperion Planning (System 9). Hyperion

Essbase(EAS), HFM,DRM, ODI, FDM (Hyperion Upstream) used to develop the

Planning Applications . Hyperion Reports and Essbase Spreadsheet Services

are used to develop the Reports from the Planning applications. The whole

process is automated using ESSCMD and MAXLScripts.

Responsibilities:

. Administration of Production, QA, archive& Development landscape which

includes installation, maintenance and performance tuning and user

administration using the shared services.

. Provide System Admin support for HFM, FDM, Financial reports, Hyperion

Essbase & Planning including support MEC processing, application

testing and process documentation

. Managing Windows Servers (Monitoring resources on Windows Server,

Starting and Stopping Hyperion services, Monitor app back-ups, manage

resources ( CPU, disk space and RAM) and work with Windows server team

adding additional resources whenever needed.

. Worked on the installations of EPM 11.1.2 versions and migrated

applications from 9.x to 11.1.2.1, 11.1.2.3

. Production support which includes EPM (11.1.2.1) suite Hyperion

Financial Management (HFM), Essbase and Hyperion Planning

applications.

. Installation of EPM11.1.2, System 9 Shared services/License server,

EAL, AAS, HFM 11.1.2, 9.3.1, 9.2.03& 4.1.1.1, planning 11.1.2, 9.2.03.

& 4.1.1.1& BI reports 11.1.2, 9.3.1, 9.2.03. & 901. DRM 11.1.2& Calc

Mgr

. Migration from System 9.3.1 version to EPM 11.1.2.1, 11.1.2.3( HFM,

EAS,FDM, EAL& EPMA )

. Create/Maintain system administration scripts, and maintain

responsibility for creating and updating system documentation.

. Manage projects in Oracle Data Integrator to develop interfaces,

manage repositories and other artifacts.

. Identify, implement and test patches and upgrades and maintain up-to-

date documentation of Hyperion-related configuration.

. User administration and setting up MSAD, Groups/User security for

Planning, HFM & BI reports in Shared services.

. Also involved in performance tuning for BI reports, HFM and Planning

servers.

. Monitor application performance and availability. And worked closely

with management and end-users to develop and enhance the application

processes that will result in a stable productive environment.

. Facilitate the promotion of Hyperion objects to the Development and

Production environments and create/Maintain system administration

scripts, and maintain responsibility for creating and updating system

documentation.

. Identify, implement and test patches and upgrades and maintain up-to-

date documentation of Hyperion-related configuration.

. Fine tuning of BI+ workspace reports, HFM and Essbase which includes

OS, application & web services tuning.

. Weekly server maintenance of Production, Test & Development servers

which includes backup and recycling the services. Automation of

Essbase backups using ESSCMD& Maxl scripts.

. Involved DR testing and setup.

. Setup the CITRIX environment for Planning &HFM for windows 2007 users.

. Troubleshoot issues with both client and server systems i.e. Smart

View, Excel Add-in, Web Analysis, Essbase, Financial Reporting,

Workspace, Studio, Web Logic

. Responsible for providing weekly/monthly updated information to IT

internal security audit for SOX.

Environment: EPM11.1.2 (EAL, EAL, Workspace& FDM), System 9 shared services

11.1.2, 9.3.1, 9.2.0.3& 9.01, HFM 11.1.2, 9.3.1, 9.2.0.3& 4.1.1,

Planning4.1.1 &9.2.0.3, EAS11.1.2, 9.3.1&9.01.1,Upstream, DRM11.1.2, ODI,

FDM (9.3.1& 11.1.2) BI+ workspace 11.1.2, 9.3.1, 9.2.0.3& 9.01, DIM,

Hyperion Smart view 11.1.2, 9.3.1, 9.2.0.3& 9.01, Essbase excel-addin,

OBIEE, EBS11 with BI,. Oracle 10g&11g, Web logic 8.x & 9.x, Apache

Tomcat, IIS 6, OEL (Linux5.7) and Windows-2003& 2008R2.

MIT, Boston, MA Dec'05 to March'06

Hyperion Sr.Architect

The main objective of this project is converting the existing Brio

structure into Essbase cube structure for reporting to maintain Actual

&Budget data.

Tasks Done at MIT:

. Up gradation & migration of system 9.0.1 planning& HFM applications.

. Installation of System 9 Shared services/License server, AAS, HFM

4.1, planning 4.1.1.1& BI reports 9.01. Designed the process flow

diagrams and project plan.

. Reviewed the existing Brio-reporting structure and review of Brio-

queries.

. Reviewed the SQL queries and created flat files for the new system to

load the data in Essbase Cubes.

. Requirement gathering for new cubes include: dimensions, members and

business rules needed for the Essbase cubes.

. Designed outline structure of two new Essbase cubes(Institutes-

Finance, Research and Revenue.

. Added all the required dimensions for the new cubes and added members

and aliases for the dimensions.

. Defining the Security and Filters for Groups& Users.

. Create Esscmd scripts for the batch jobs to automate load,calculate

and backup the data.

. Created rule files, calc scripts to load and calculate the data

and dimensions into Essbase cube.

. Creation of new BSO /ASO applications including planning, ledger and

reporting cubes.

. Security setup on servers-LDAP configuration of Hyperion System 9 and

EAS servers on UNIX

. Finalized the Essbase cube structure which includes review of

dimensions, members and formulas.

. Created different type of reports such as POV's,graphs, charts and

pdf using Hyperion Analyzer.

. Data load testing and Essbase user training.

Environment: Essbase (EAS), Hyperion System 9 products, Excel add-in,

Hyperion

Analyzer, HFM, Oracle9i, Brio Query and Win-NT.

Hanger Oct'05 to Nov'05.

Hyperion Senior Administrator

Hanger Orthopedic Group, Inc. is the world's premier provider of orthotic

and prosthetic services and products. This assignment is mainly focused on

Budgeting& Forecasting the Hanger financial data using Hyperion Planning.

Brief Description of my role:

. Administration of Essbase users and groups and assigned filters to the

groups.

. Updated the Essbase cubes based on the user requirement.

. Updated calc scripts and rule files to load and calculate the data.

. Validating the source data with the result data.

. Added new Groups and Users to the Planning and Synchronizing Essbase

password with planning and also associating Groups to the Planning

Forms.

. Associating Business Rules/Calc Scripts and security with the Planning

Forms.

. Created new web forms and business rules based on the user's request.

. Hyperion Forms testing includes security testing and functionality

testing.

Hyperion Reports Security:

. Created Groups and assigned Access to the groups.

. Associated Users to Groups and associating Groups to the individual

folders, books and reports.

Environment: EAS 7.1, Hyperion Planning 3.5,HAL, Hyperion reports

7.0,ESSCMD,Excel-

Add in, Sql server 2000,Windows-NT .

Morgan Stanley Jun'05 to Sept'05.

Hyperion Admin/Developer

This Financial project has various applications and the major one is IIG

(Individual Investment Group).This data is loaded from various sources like

flat files, oracle &Excel files.

Role& Responsibilities

. As a DBA my major role was upgrading the Essbase 6.5 Production &

Development server to EAS 7.2.

. Upgraded Hyperion reports 3.2 version to Reports 7.2.

. Installed EAS 7.2 with Tomcat webserver and Sql database.

. Imported all the Apps, Cubes, Scripts, outlines and Reports.

. Imported all the security which includes Users, Groups and Filters.

. Optimization of BSO cubes: Custom setting type of compression, data

cache, calculator cache settings, and allocation of dense /spare

configuration relating to hourglass model to have optimum database

block size.

. Optimization of ASO cubes - identifying views based on members,

creation of load buffer, aggregation views. Genearation of load

buffers for faster load of ASO cubes.

. Created various Expense and Revenue Web forms in Hyperion Planning

4.0.

. Implemented the Reports security in new version by importing all the

users and groups.

. Worked closely with Business users to gather the specifications for

Web forms and Reports.

. Used the functionality of point of view, pages, functions, prompts and

cell formulas to create reports.

. Created various Reports and books as per the user requirement and

scheduled batch jobs to run the reports and published on Web.

Environment: Essbase Application Manager 6.5,EAS 7.1, Hyperion System

9,Hyperion

planning 3.2& 4.1,Hyperion Reports 3.2 & 7.2,MS-Excel Add-In,

Web sphere,HAL, Sql server 2000, Unix &Windows-2000.

AITC USA

JPMorgan Chase/Bankone Nov'04-May '05

Essbase Administrator/Developer

This EDW (Enterprise data ware house) is built on DB2OLAP server which has

different data marts (credit/transactional/customer). The main scope of

this project is to merge JPM database & EDW (BankOne) into single data

warehouse for all lines of business which includes Home equity, prime& sub

prime.

My role& responsibilities:

. Created Esscmd and Maxl scripts to automate the load process.

. Involved in installation of Essbase and Hyperion planning on the

client's machine and on the new server which is built on Oracle 8.1.

. Involved in performance tuning, user administration & backups of

Essbase cubes.

. The following Essbase components were investigated & modified

appropriately:

1.Outline Structures

2.Data Load rules

3.Database Partitioning

4.Automated Scripts

5.Dynamic Calculations

. Published the reports using Alphablox app. Server and Hyperion

reports.

. Generated various reports for different channels and products for the

users.

. Used the functionality of crosstab, charts, graphs and slice and dice

as per the business requirement.

. Created web forms for user to input data and created applications

maintained folders and Business Rules.

. Setting up Application, Plan types, Dimensions, customizing time

periods, adding currencies and exchange rates, point of views, page

views and administration of users.

. Testing the functionality of the Web forms and Reports.

Environment: EssbaseApp.manager6.5, HyperionPlanning3.5, Alpha Blox App.

Server.,

Hyperion Reports 4.x, Hyperion Pillar,Excel Add-in, HAL,

DB2OLAP server, SAS, Unix, Windows2000, Acxiom, unix and

Oracle8.1.

AITC USA

Hyperion Administrator/ Developer Aug'04-Oct'04

PWC, Tampa/Fl

Role& Responsibilities:

. Created cubes for financial analysis, performance management and

customer order intelligence.

. Designed and optimized all of the outlines

. Involved in Upgrade of Essbase 6.1 to Essbase 7.1

. Responsible for the backup of the Essbase directories including

config.files, security files database and application settings,

calc.scripts, rulefiles, outlines and report scripts.

. Created various informatica mappings to transform and load the data

into database.

Environment: Essbase6.1&6.5,EIS,Essbase7.1,Oracle8.x,websphere,

Informatica6.1, Unix, Windows2000.

AITC USA

Hyperion Developer (Essbase, Planning and Reports) May'04-

July'04

Monster, NY

The Multi Dimensional (Star) Schema Financial project is developed for the

end users to maintain the Budget and Actuals data which shows all the

employee payroll, billings and Advertising, Marketing, Travel and

Entertainment expenses with the data warehouse as the base.

My Responsibilities:

. Used Hyperion Reports to generate different type of reports (Budget,

Forecast and Variance) for the users based on their requirement.

These reports are automatically scheduled and sent to customers via e-

mail in their preferred output format--PDF, Excel, text or HTML

. Involved in setting up custom dimensions, members and assigning

attributes.

. Used POV's, defined prompts conditional formats, functions and saved

objects for reports and also maintained the Repository for organizing

folders.

. Used Hyperion Planning for managing web based Planning, Budgeting and

Forecasting solutions for wide range of operational needs.

. Performance tuning of Essbase and Reports.

Environment: Hyperion Essbase6.5, Hyperion Planning3.5,Hyperion

Reports7.0,SQL

Server, BEA web logic server, Hyperion JDBC drivers, HAL, MS-

Excel, Excel Add-In, Windows NT.

AITC USA

Essbase Developer/Administrator

Goldman Sachs, New York. Aug-2002 to March'04

Global Clearance.

This Multi Dimensional (Star) Schema, Enterprise Wide Data (EDW)

project which includes Global operations such as Equities, Treasury, Fixed

income, Futures, Commodities developed for the Divisional Managers to

Analyze the Daily, Monthly, Quarterly and Yearly Business trends.

My Role and Responsibilities:

Primary Support for Equities-ABC (Activity Based Costing) Datamart system.

. Extracted and transformed the data from Metify & Ms-Access in

different regions (Asia, America, Japan and Europe) and loading into

Sybase and Essbase.

. Involved in calculating cost, hour, trade volume and activity driver

volume for different income functions and transaction types.

. Designed the outline structure by identifying different dimensions,

members and Hierarchies using Hyperion Essbase Application manager.

. Used Hyperion Analyzer to generate different reports for all regions

and periods (yearly, quarterly, monthly, weekly, daily).

. Validated the data after loading into Sybase and Essbase with the

source systems.

. Maintenance of the Backup after loading the data for all regions and

periods.

. Involved in performance tuning of Essbase.

. Involved in the meetings with the Users for gathering the requirement

for Reports.

. Assisted and managed the user group by providing Technical support for

Essbase and Metify.

Environment: Hyperion Essbase6.x, Hyperion Analyzer, Metify 1.x/2.0.5,

AlphaBlox app. server 3.5,Perl,DB2.0 7.x, Autosys, Sybase11.9,MS-Access,

Java, Jsp, Html, Jscript, Excel Add-In, Windows NT, Unix.

Education

. Bachelors degree in Electronics- Osmania University(1993-96), Hyd,

India.

. Post Graduate Diploma in Computers (NIIT).-Hyderabad(1996-98)

. Hyperion Essbase6.x certification.Oct-2005

Contact this candidate