Maintenance Planning

Raghavendra Alla

Phone: 270-***-****

Email:***********@*****.***

Hyperion Technical Consultant with more than 7 years of extensive

technical expertise in Administration using Hyperion Suite of

products Essbase, Planning, HFM, FDM, Financial Reporting, Web

Analysis, EIS, DIM & EPM Architect

SUMMARY:

. Full technical understanding and know-how on Hyperion System 9

and 11 EPM Suite of products

. Oracle's certified professional in Hyperion Essbase.

. Oracle's certified professional in Hyperion Planning.

. Strong experience with Hyperion environment Administration

including Creating and Configuring Clusters in Planning & HFM

Servers, upgrades, Maintenance, database backups, Performance

tuning, Optimization, Dense/Sparse settings, partitioning, etc

. Hands on experience on installing and configuring Hyperion

suite of Products including, Hyperion Essbase, Planning, HFM,

FDM, DRM, EAS, EIS, HPS, Shared Services and BIPlus.

. Experience in configuring MSAD and LDAP with Hyperion Shared

Services for user provisioning.

. Experienced in development of hybrid Hyperion applications

using latest ASO and BSO applications through partitions.

. Well experienced in backup/recovery process.

. Experience in troubleshooting technical issues with various

Hyperion products.

. Good hands on experience in automating all Hyperion related

jobs with MAXL, ESSCMD, PERL Shell and windows Batch scripting.

. Good experience in ETL tools like ODI, FDM and EIS.

. Proficient in software documentation, technical report writing,

flexible in work schedules.

. Experience supporting 24*7 production computing environments.

Experience providing on-call and weekend support.

. Strong conceptual, business and analytical skills.

. Highly motivated team player with immense ability to grasp new

concepts and apply them.

AREA'S OF EXPERTISE:

Hyperion Hyperion Essbase 11/ 9/7.x/6.x, Hyperion Shared

Services 11/9, EAS 11/9/7.x, EIS 11/9/7.x

Hyperion Planning 11/9/4.x, Hyperion Performance

Scorecard 11/9, Hyperion Visual Explorer(HVE),

Smart View for Hyperion, Hyperion Web Analysis,

Financial Reporting, MS Excel Spreadsheet Add-in

(Hyperion System 9)

ETL HAL, DIM, ODI

ERP Oracle Applications 11i/11.0.3(GL,OM, INV,AP,AR)

Programming Languages SQL, PL/SQL, SQL*Loader, C

RDBMS Oracle 8i/9i/10g/11g, MS SQL Server 2005, MS Access

2007

GUI &Reporting Tools Hyperion Visual Explorer(HVE), Hyperion Financial

Reports and Web Analysis, SQL Developer, SQL

Navigator, TOAD, Workflow 2.6

IDE EAS, FR Studio, Toad

Internet Tool HTML, DHTML, XML

Operating Systems Windows 2000/2003,XP/Vista, UNIX, LINUX

EDUCATION:

Masters in Computer Sciences

Bachelors in Electronics and Communications Engineering

Experience:

Fanniemae

Oct 10 to Present

Reston, VA

Hyperion System Admin

Fannie Mae is a government-sponsored Mortgage enterprise with three

lines of business - Single-Family, Multifamily and Capital Markets -

that provide services and products to lenders and a broad range of

housing partners. Fanniemae implemented Hyperion suite of products

for their forecasting and reporting needs. Actual data is loaded

from Peoplesoft GL to HFM, Planning and Reporting applications.

Budget data will be entered yearly once and forecast data will be

entered monthly. These applications will allow fanniemae to generate

the income statement and balance sheet fir Go-Forward and Legacy

activity. The environment includes 5 HFM, 9 Planning, 8 FDM and 3

Reporting applications

Responsibilities:

Installation and Configuration of all Hyperion Products including

Shared Services, Essbase, EIS, EAS, Planning, HFM, FDM, DRM, ODI.

Creation, maintenance and support of Essbase, Planning, HFM and FDM

application.

Migrating applications and application components between Prod, UAT

and DEV environments.

Working with Oracle for any identified bugs and apply patches as

recommended.

Follow change management procedures for any Production change.

Developed Maxl/Shell scripts with combination of Perl for routine

administration tasks like backup, scheduling calcs on server,

purging app/server logs, data export/imports.

Participated in HAL to ODI implementation by installing and

configuring ODI and migrated ODI components between environments.

Developed Custom program to encrypt passwords which are used in EIS

scripts.

Document Password change process for all the system accounts and

database accounts used by Hyperion environment and follow the

process yearly to change the passwords.

Troubleshooting all technical issues

Upgraded 11.1.1.3 environment in Sandbox to 11.1.2.1

Maintenance of user security and troubleshooting user access issues

as they arise

Install client tools like Excel-Addin, SmartView, FR Studio, IR

Studio, HFM for users

Closely worked with business users to troubleshoot and resolve

issues as and when they surfaced

Schedule jobs through Autosys.

Track tickets through REMEDY and ensure timely resolution.

Work with Internal audit team in removing unnecessary access to

users as per the SOX requirement.

Defined and documented the steps to migrate applications in the

Hyperion Planning, Essbase, HFM and FDM between Prod, QA, and Dev

environments

Environment: Hyperion Essbase 11.1.1.3/9.3.1.x, Planning

11.1.1.3/9.3.1.x, Hyperion Reporting & Analysis 11.1.1.3/9.3.1.x

(FR, WA, Workspace), Hyperion Shared Services 11.1.1.3/9.3.1.x, HFM,

FDM, Web logic 9.1, Oracle 9i/10g/11g, Oracle Application Server

10g, Windows 2000 server, Windows 2003 server IIS, EIS

11.1.1.3/9x/9.3.1 & HAL, Toad 9.0, Putty, Smart view, Excel Add-In

11.1.1.3/9.3.1.x

Alcoa Inc.

Feb 08 to

Sep 10

Pittsburgh, PA

Hyperion DBA

Alcoa implemented almost all the Hyperion BPM suite products like

Hyperion Planning, Hyperion Essbase, Financial Reports, WebAnalysis,

ODI, EIS, FDM and HFM for thier BU and Corporate Planning &

Forecasting needs. The actual data is loaded from GDW to Hyperion

Planning applications which were developed at BU level for

department level Planning and one at Global level which consists of

all the BU data at certain high level. Again once Planning or

forecasting is complete in BU applications, they push forecast data

into GDW at certain high level. This is loaded into Global Planning

application for corporation planning and reporting needs.

Responsibilities:

. Install and configure system 9 products like Shared Services,

Essbase, Planning, HFM, ODI, FDM, EAS, EIS, BIPlus

. Creation and maintenance of Essbase cubes, Planning, HFM and FDM

application.

. Migration of applications between environments.

. Performance tuning and Optimization of the Applications for the

fast data loads, better calculation times of the cubes and fast

retrieval of the reports using the Dense/Sparse settings, Cache

settings, Outline formulas..

. Managing hierarchy changes as part of COA (Chart of Accounts)

process as well as updating calc scripts, business rules, web

forms and reports according to changes.

. Infrastructure Support - Server Maintenance like File system Space

Management, moving Backups to staging server, Exports and OS

Patches.

. Developed Maxl/Shell scripts with combination of Perl for routine

administration tasks like backup, scheduling calcs on server,

purging app/server logs, data export/imports.

. Functioning as a single point of contact for the clients/BPO's on

all production related support and maintenance issues.

. Maintenance of user security and troubleshooting user access

issues as they arise.

. Backup and Recovery of Hyperion applications. Scheduling daily

backups.

. Converted more than 4 BSO cubes into ASO and regular support for

ASO applications like hierarchy changes and data loads.

. Participated in HAL to ODI implementation by installing and

configuring ODI and migrated ODI components between environments.

. Monitoring the current Production environment servers for

performance and stability.

. Maintenance and Support for Essbase, HFM and FDM Applications.

. Upgraded 9.3.1 environment in Sandbox to 9.3.3

. Participated in the application testing, while monitoring the

system performance, thereby reporting any anomalies in the

application.

. Performed UNIT testing and USER ACCEPTANCE TESTING (UAT) the final

step before Rolling out of the Application.

. Defined and documented the steps to migrate applications in the

Hyperion Planning, Essbase, HFM and FDM between Prod, QA, and Dev

environments.

. Worked with Hyperion Support on a number of issue resolutions.

. Documented all the application and user issues and the

corresponding resolutions in order to facilitate easy knowledge

transfer.

. Installation, configuration and Administering of TempDR and DR

environments.

. Handling infrastructure related tickets.

. Training end users

Environment: Hyperion Essbase 9.3.1.x, Planning 9.3.1.x, Hyperion

Reporting & Analysis 9.3.1.x (FR, WA, Workspace), Hyperion Shared

Services 9.3.1.x, HFM, FDM, Web logic 9.1, Oracle 9i/10g, Oracle

Application Server 10g, Windows 2000 server, Windows 2003 server

IIS, EIS 9x/9.3.1 & HAL, Toad 9.0, Putty, Smart view, Excel Add-In

9.3.1.x

Brightpoint,

Dec 06 to Jan 08

Indianapolis, IN

Hyperion Technical Administrator

Brightpoint is a cell phone manufacturer located in Indianapolis

implemented Hyperion System 9.3.1 suite of products for various

applications. The environment includes 3 Planning applications, 3

native Essbase applications, 1 HFM application and, 2 FDM

applications, 1 strategic finance applications. There are around

1000 users across the globe.

Responsibilities:

. Installation and configuration of Hyperion Products.

. Applying Hyperion security patches.

. Technical trouble shooting and maintenance.

. Upgrade of Hyperion Essbase, planning, HFM and BI+ Financial

reports, WebAnalysis reports from 7x to 9.3.1

. Installed FDM 9.3.1

. Testing of the tools after the upgrade.

. Trouble shooting the migration and technical issues,

escalation to Hyperion.

. Patch installation for Bugs

. Preparation of startup and other maintenance scripts.

. Documenting the processes and installation steps.

. Designing and development of the planning application model

and outline.

. Meta data management in custom dimensional repository.

. Setting up security in planning and assigning access to

Forms, Rules and Reports.

. Migration of planning applications from Test to Production.

. Design and development of financial reports on this Planning

application.

. Testing, documentation and user training.

Environment: Microsoft 2003 Windows Server, Hyperion System 9.3.1.

EIS, DIM, BEA Weblogic 8.1/9.1, Strategic Finance, HFM, FDM

Oakley

Sep 05 to Nov 06

Lake Forest, CA

Hyperion Technical Consultant

Oakley, Inc. is a sport and lifestyle brand, with diversified range

of products including high performance sunglasses, prescription

lenses and frames, goggles, apparel, footwear, and accessories The

project is to implement new Hyperion Planning application and

provide support for existing Planning and Reporting applications.

Responsibilities:

. Closely worked with the functional and the business analyst

team during the pre-implementation phase of the applications.

. Developed Planning dimensions and Essbase outline

. Developed Planning Workflow and task flows.

. Developed Essbase calc scripts and partitions.

. Develop Essbase reporting cube on top of planning cube.

. Defined and setup the application security in Hyperion

Planning, Hyperion Essbase, HFM and Essbase Integration

Services.

. Developed Cron-scripts in Solaris and windows for the building

of the application.

. Setup automated scripts for weekly backup of the application.

. Participated in the application testing, while monitoring the

system performance, thereby reporting any anomalies in the

application.

. Performed UNIT testing and USER ACCEPTANCE TESTING (UAT) the

final step before Rolling out of the Application.

. Defined and documented the steps to migrating applications in

the Hyperion Planning, Essbase as well as the HFM environments

in Prod, QA, and Dev.

. Migration of Planning Applications from Test to Production.

. Closely worked with business users across the globe to

troubleshoot and resolve issues as and when they surfaced.

Environment: Hyperion Planning 7.x, Hyperion Essbase 7.x, EAS 7.x,

Hyperion Reports 7.x, Essbase Add-in, Smart View, HFM Add-in, HFM

4.x, Oracle 9i/10g, Solaris, Windows 2000 Advanced Server, Windows

2003, Veritas Cluster Manager, IBM Websphere, Eclipse, and Apache

Tomcat.

Cardinal Health

Oct 03

to Aug 05

Columbus, OH

Hyperion Administrator

This is a Hyperion Planning implementation project for Cardinal

Health Corporate planning, Forecasting & Budgeting needs. Developed

Planning models (Sales, payroll, Capex and Main) by replacing the

existing Spread sheet models. Actual data from EDW, JDEdwards and

Peoplesoft has been transformed using Informatica and fed to these

Planning applications through HAL. After input and calculations are

completed the data in other applications will be consolidated to

main application that will be used for balance sheet calculations

and Budget Reporting. I have been involved in full life cycle of the

project starting from requirements gathering.

Responsibilities:

. Migrated existing applications from Hyperion Essbase 6.5.4

to Hyperion System 9 Environment

. Integrated the Hyperion System 9 environment with the

Microsoft Active Directory application of VSD and designed

the security of Essbase applications in the new environment.

. Testing, documentation and user training.

. Installation of Hyperion software on Windows servers.

. Development of Planning Webforms and dimensions.

. Development of few Business rules and Calc Scripts.

. Development of interfaces using DIM tool.

. Setting up security in Planning and assigning access to

Forms, Rules and Reports.

. Migration of Planning applications from Test to Production.

. Design and development of financial reports o this Planning

application.

Environment: Hyperion System 9, Hyperion Essbase 9.2.3, Analytic

Administration Services 9.2.3, Hyperion Financial reporting 9.2.3,

Essbase excel Add-in 9.0, Hyperion Smartview 9.2, MDM, Clarity 6,

Oracle 9i/10g, HP UNIX, Windows 2003 Advanced server, IBM

Websphere, Ascential Datastage 8.0, Hyperion Interactive Reporting

Contact this candidate