Data Project

Preeti Yerra

abktiy@r.postjobfree.com

Direct: 614-***-****

Summary

. 9 years of extensive experience in application designing and development

using Oracle Hyperion Essbase 11.x/9.x/7.x/6.x, Hyperion Web

Analysis/Analyzer, Hyperion Financial Reporting/Reports, Essbase

Integration Services, ESSCMD, MAXL, Excel Add-In.

. Extensive experience on the configuration, server settings, backups,

client installations of Hyperion products such as Hyperion Essbase,

Hyperion Web Analysis/Analyzer, Hyperion Financial Reporting/Reports on

both Windows and UNIX environments.

. Extensive knowledge of Aggregate storage, Block storage, partitioning,

and conversion of Block storage cubes to Aggregate storage.

. Extensive experience in creating Calc Scripts, Load Rules and Report

scripts.

. Commendable knowledge and experience in Automation using Batch scripts

and UNIX Shell Scripts, Essbase cube designing and partitioning and

optimization of report queries in Microsoft Excel.

. Experience in creating OLAP models & meta-outlines using Essbase

Integration Services.

. Proficient in DBA operations such as Database tuning, backup and recovery

on different servers and operating systems.

. Created trend reports using a combination of Hyperion Web

Analysis/Analyzer and Hyperion Financial Reporting/Reports.

. Expertise in building Financial Budgeting and Forecasting OLAP

applications with Essbase.

. Excellent communication skills and better understanding of business

requirements and software development cycle in the Hyperion Essbase

environment.

. Highly dedicated towards work goals and creative in new development as

well as solutions to critical issues.

. Experience in writing documentation relating to design, statement of work

documents, work plans and development standards among others.

SOFTWARE SKILLS

OLAP Tools : Hyperion/Oracle Essbase System 11.1.1.3/9.3.1, Hyperion

Essbase 11.x/9.x/7.x/6.x, Hyperion Web Analysis

11.1.1.3/9.3.1, Hyperion Financial Reports

11.1.1.3/9.3.1, Essbase Administration Services

11.x/9.x/7.x, Essbase Integration Services 11x/7x,

Hyperion Analyzer 7x/5x, Hyperion Reports 2x/7x, Excel

Add-In,

RDBMS : Oracle 9i/8i/7.x, SQL Server 2000/2005/2008

Operating : Windows NT/XP/2000/2003/2008, Unix (HP, Sun OS 2.7/8,

System: AIX), DOS

Languages : SQL, VBA, VB

Web Tools : HTML, JavaScript,ASP

Scheduling Tools : Cron, Autosys, Tivoli Workload Scheduler

Tools : SQL Plus, SQL Loader, Load Runner

EDUCATION

. BS in Computer Science Engineering Osmaina University, India

EXPERIENCE

State Farm Insurance, Bloomington, IL

Aug 09-Current

Role: Oracle Hyperion Developer/Administrator

Project Scope: State Farm is a leading provider of Auto, Home and Life

insurance. The project involved installing Essbase 11, migrating Essbase 7

applications to Essbase 11 and creating a consolidated cube for Auto, Home

and Life Insurance business segements.

Responsibilities:

. Installed and configured Oracle Essbase 11.1.1.3 Provider/Shared

Services, Essbase Server, Essbase Administration Services, Essbase

Client, Essbase Integration Services, Financial Reporting and Web

Analysis.

. Migrated weekly, monthly and historical (50) applications and security

from Essbase 7.x environment to Essbase 11.x environment. Utilized

migration utility to migrate applications. Created automation scripts for

loading data in new environment. Utilized replicated partitions between

7.x and 11.x historical applications to copy data.

. Automated ASO export and BSO automatic backup and recovery in Essbase

11.x (New features).

. Involved in designing and developing of Consolidated Reporting Cube for

Auto, Home and Life Insurance business segments to support Budgeting,

Forecasting and Reporting.

. Held discussions with business users to derive requirements. Lead design

sessions and created functional and technical design documents.

. Authored 'As-is' blueprint of all Functional Requirement Document (FRD)

and Business Level Specifications (BLS).

. Technical design document included the specifications/requirements for

Sql Server and Essbase.

. Created Essbase Source and Target cubes as per design documents.

Automated dim build, data loads, partitions creation and backup using

MaxL scripts. Created transparent partitions between source and target

applications to support load of actuals, budget and forecast data.

. Created groups and users for different business segments and then

assigned security and filters to define Essbase privileges on them.

. Designed the budgeting and year-end process for Corporate and Divisions.

. Worked closely with the End users to understand their Reporting needs and

updated the essbase applications accordingly.

. Designed and implemented Balance sheet in an existing cube based on the

user requirements.

. Modified the existing Essbase Applications to reduce the calc time and

maintenance required for it. Designed/Modified the Essbase Cubes based on

reporting needs of the users. Responsible for the design, development,

enhancement, and maintenance of the various BSO cubes used for

forecasting and strategic decision-making.

. Created batch scripts using MaxL to automate Essbase application refresh

process (dimension building, data loading and calc scripts).

. Created partitioning and also used cross database function to load slice

of data from other remote cube. Used Essbase partitioning to improve

performance of Essbase Application.

. Developed Calc Scripts for allocation of expenses for the budgeting

process. Developed Calc Scripts for complex calculations and optimized

them.

. Recovered application from its backup.

. Optimized the various cache settings to enhance the performance of Cubes.

. Responsible for production support and training business users.

Environment: Oracle Hyperion Essbase 11.1.1.3/7.1.5, Essbase Administration

Services 11.1.1.3/7.1.5, Hyperion Web Analysis 11.1.1.3/ Hyperion Analyzer

7.2.1, MAXL, MDX, Hyperion WorkSpace 11.1.1.3, Essbase Excel Add-In

11.1.1.3, Hyperion Shared Services 11.1.1.3, Hyperion Financial Reporting

Studio 11.1.1.3/7.2.1, Windows Server 2008/2003, SQL Server 2008/2005.

Total System Services, Alpharetta, GA

Jan 08 to Jul 09

Role: Oracle Hyperion Developer/Administrator

Project Scope: Total System Services provides electronic payment

processing, merchant services, and related services to financial and non-

financial institutions in the United States and internationally.

The project involved design and development of Hyperion Essbase

applications for budgeting & forecasting purpose.

Responsibilities:

. Design and development of Essbase ASO & BSO cubes.

. Involved in development and enhancement of Enterprise Income Statement

& Balance Sheet cubes, Budgeting and Forecasting Cubes.

. Involved in development of a Data Mart to support building of outlines

using EIS & loading data into cube using SQL Interface.

. Automated Cube build and load process using Maxl and Shell scripts.

. Design and development of OLAP model and Metaoutlines for Essbase cube

build using Essbase Integration Services.

. Optimization of Essbase cube refresh cycles by reducing time to load

data using Parallel data loading.

. Development of EIS Drill-Through reports to support drill to detailed

level data from summary level data.

. Developed numerous calculation scripts for allocation, forecasting,

datacopy between versions and scenarios.

. Responsible for security provisioning using shared services across the

entire Hyperion environment.

. Restructured and redesigned previous Essbase cubes including a

conversion from Block Storage (BSO) to an Aggregate Storage (ASO)

database.

. Executed DBA duties like automation of Outline build and data loads

for cube refreshing, updating substitution variables, performing month

end and year end maintenance, ongoing performance tuning, de-

fragmenting, taking regular backups, restoring Essbase objects or

complete applications in case of a server crash.

. Created Budget Variance Report, Prior Period Trending Report, Year on

Year Trending Report and Trial Balance Reports in Hyperion Financial

Reports and Hyperion Web Analysis.

. Created Shell scripts to support back up of Hyperion objects & data.

. Used Autosys & created box jobs for automating script execution.

. Created all the required documentation like design, process flow and

production support for all the applications developed.

Environment: Hyperion Essbase 9.3.1, Essbase Administration Services 9.3.1,

MAXL, MDX, Hyperion System 9 Work Space, Hyperion System 9 Smart View for

Office, Essbase Excel Add-In 9.3.1, Hyperion System 9 Shared Services,

Essbase Integration Services 9.3.1, Hyperion Financial Reporting 9.3.1,

Hyperion Web Analysis 9.3.1, Windows Server 2003, Oracle 10g, PeopleSoft

9.0.

Verizon Business, Irving, TX

May 06 to Dec 07

Role: Oracle Hyperion Developer/Administrator

Project Scope: Verizon Business is a leading provider of global IT,

security and communication solutions for enterprises and government

agencies around the world. The project involved

design and development of Hyperion cubes, development of Hyperion Planning

application for budgeting purpose.

Responsibilities:

. Design and development of Essbase ASO & BSO cubes.

. Involved in development and enhancement of Income statement, balance

sheet, efficiency report, performance, caymart cubes.

. Automated Cube build and load process using Maxl and Shell scripts.

. Design and development of OLAP model and Metaoutlines for Essbase cube

build using Essbase Integration Services.

. Development of Oracle stored procedures, packages and oracle objects

to support automation of Essbase security process.

. Optimization of Essbase cube refresh cycles by reducing time to build

and load data and using back end cube.

. Development of custom Excel Add-in VBA code to support drill to

detailed level data from summary level data.

. Developed numerous calculation scripts/business rules for allocation,

forecasting, datacopy between versions and scenarios

. Responsible for security provisioning using shared services across the

entire Hyperion environment

. Assisting users in set up, installation and usage of Essbase client.

. Design and development of a process to extract data from several

upstream cubes and feed to a downstream cube.

. Design and development of reports using Hyperion Financial Reports.

. Support production system to resolve all the assigned tickets.

. Responsible for monthly maintenance of Essbase cubes.

. Created all the required documentation like design, level of effort,

project schedules, process flow and production support for all the

projects involved.

Environment: Hyperion Essbase 9.3.1, Essbase Administration Services 9.3.1,

Hyperion System 9 Web Analysis, MAXL, MDX, Hyperion System 9 WorkSpace,

Essbase Excel Add-In 9.3.1, Hyperion System 9 Shared Services, Essbase

Integration Services 9.3.1, HAL 9x, Hyperion Financial Reporting Studio 9x,

Solaris, Windows Server 2003, Oracle 10g.

Capital One, Richmond, VA Aug

05 - May 06

Role: Hyperion Consultant

Project Scope: Capital One is a leading international bank, which had a pre-

existing Hyperion Essbase cube required some additions to the existing

suite of main applications for its local usage for approving loans and

credits to its consumers and departmental analysis for which various

reports were generated through Hyperion Reports and Analyzer. In addition,

I was also intensely involved in developing Calculation Scripts, which

would allocate Plan, Actual and Forecast data values to various locations.

Responsibilities:

. Involved in gathering requirements from business users and developing a

project plan.

. Involved in defining requirements, functional specifications, designing

documentations and testing for creating budgeting and forecasting tool.

. Implemented star schema and used EIS to interface with the company's

existing Oracle data warehouse.

. Created users and groups, assigned privileges to them, and applied

security on different applications using filters.

. Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase

Integration Services.

. Created OLAP Model Cube Using Analysis Services.

. Loaded dimensions & data using Essbase Administrative Services Console.

. Carried out timely updates for refreshing the ASO & BSO cubes.

. Designed and developed numerous Essbase applications with excellent

balance of dense and sparse dimensions, arranged in an hourglass fashion.

. Partitioned cubes/database to improve data retrieval efficiency

. Installed Hyperion Essbase Integration Services and created OLAP model

. Implemented robust data-access security and user management.

. Developed Excel Templates for user interface in Essbase database.

. Prepared templates for achieving quarterly forecasts, annual budget, ad-

hoc reporting and management reporting by working with the business

managers

Environment: Hyperion Essbase 7.1, EAS 7.1, EIS, Excel Spreadsheet Add-In,

Hyperion Analyzer 7.2, Hyperion Reports 7.2, VB 6.0, and Windows 2003.

Allstate Insurance, Northbrook, IL

Jun 04 - Jul 05

Role: Hyperion Developer

Project Scope: Allstate Corporation is the second largest property and

casualty insurer in the United States. Started in 1931, Allstate has built

its business around its own strengths, a huge network of company and

independent brokers. For effective analysis and consolidated reporting,

Allstate used Hyperion Activity Based Management's robust set of tools.

Responsibilities:

. Coordinating with Client and Business Analyst to understand and develop

an Optimized Cube.

. Involved in preparing optimized data source.

. Developed Block Storage Cubes (BSO) cubes using Essbase 6.5.

. Optimized Data Loads and Calc Scripts.

. Retrieve reports using Excel add-in and generate reports out the batch in

Hyperion reports

. Created Macros to filter the data and retrieve the data.

. Implemented robust data-access security and user management.

. Optimized the applications to bring down the runtime considerably.

. Created various filters as per user requirements in EAS.

. Automated cube refresh through MaxL and UNIX scripts.

. Retrieve reports using Excel add-in and generate reports out of batch in

Hyperion Reports.

. Utilized Java web-client user interface of Hyperion Analyzer 6.5 for

creating Marketing Analysis reports.

. Routine maintenance of the OLAP application and took regular backups.

. Provided technical guidance and support to end-users by developing

documentations required.

Environment: Hyperion Essbase 6.5, Hyperion Analyzer 6.5, EIS 6.5,

Hyperion Enterprise Services, Hyperion Reports 2.6, Microsoft Excel 2000,

Oracle 9i, VB 6.0 and Windows 2000 Advanced Server.

Satyam Computers, India

Jan 02 - May 04

Role: Essbase Developer

Responsibilities:

. Installation of Essbase family products in both Windows 2000/NT and UNIX

(Sun-Solaris) environments.

. Responsible for producing the functional design documents and

specification for the Essbase modules.

. Maintenance of two pre-existing Essbase cubes.

. Involved in script writing for dynamic dimension builds and data loads.

. Worked on performance tuning of data loads and calculation times.

. Design and development of calculation scripts.

. ESSCMD is extensively used to run these calc scripts.

. Developed the Load Rules to automatically validate the data and feed into

Essbase new structure.

. Developed report scripts to populate data, which was fed into the other

cube.

. Created batch files to run calc scripts, data load and data calculations.

. Extensively worked with Hyperion Reports and Hyperion Analyzer.

Environment: Hyperion Essbase 6.1/6.0, ESSCMD, Hyperion Analyzer, Excel Add-

In, Oracle, Windows NT/2000, Hyperion Reports, Sun-Solaris UNIX

Contact this candidate