SUMMARY

• Over 8 Years of experience in analyzing designing developing Implementing tuning and supporting the Hyperion suite of tools
• Extensive experience using Oracle Hyperion Essbase11 x/9x/7 x/6x,Hyperion Web Analysis/Analyzer, Hyperion Financial Reporting/Reports, Essbase Integration Services, ESSCMD, MAXL, Excel Add-In, Smart View
• 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
• Experience in building Aggregate storage(ASO), Block storage(BSO), partitioning, and conversion of Block storage cubes to Aggregate storage
• Extensive experience in creating Calc Scripts, Load Rules and Report scripts
• Extensive Experience in Automation using Batch scripts and UNIX Shell Scripts, Essbase cube designing and partitioning and optimization of report queries in Microsoft Excel
• Expertise in building an online analytical processing (OLAP) system/multi dimensional database (MDDB) & 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

SKILL SET

OLAP TOOLS – Hyperion Essbase 11x/9x/7x/6x, Hyperion Web Analysis 11.1.1.3/9.3.1, Hyperion Financial
Reports 11.1.1.3/9.3.1, Essbase Administration Services 11x/9x/7x, Essbase Integration Services
11x/7x, Hyperion Analyzer 7x/5x, Hyperion Reports 2x/7x, Excel Add-In, Smart View
RDBMS – Oracle 10g/9i/8i/7x, SQL Server 2000/2005/2008, DB2
LANGUAGES – SQL, PL/SQL, C, C++, VB, VB .NET
OPERATING SYSTEMS – Windows, UNIX (HP, Sun OS 2.7/8, AIX)
SCHEDULING TOOLS - Cron, AutoSys, Tivoli Workload Scheduler, Control M
WEB TOOLS - HTML, JavaScript, ASP
GUI TOOLS - TOAD, VMWARE, MS-VISIO
TOOLS - SQL Plus, SQL Loader, Load Runner

PROFESSIONAL EXPERIENCE
Confidential,Bloomington, IL Sep’ 10 - Current
Application Developer/ Administrator
Project Scope: 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 segments. .

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 export ASO 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

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 actual, 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
• Responsible for security provisioning using shared services across the entire Hyperion environment
• 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 WorkSpacej11.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
Confidential,Minneapolis, MN Dec’ 08 – Aug’ 10
Essbase Developer
Project Scope: The aim of the project was to provide the top management and end users, a fully functional data warehouse for each of the business segments separately and as per the user requirements. Development of various cubes, developing calc scripts, developing load rules forecast and budgeting for the next 24 months, combining various cubes, SQL performance tuning, optimization of calc time, were few of the performed tasks.
Responsibilities:

• Designed, developed, and implemented multi-dimensional databaseapplication using ESSBASE
• DevelopedOutline for both ASO & BSO applications and created various filters as per user requirement
• Used ESSCMDin an interactive and batch mode to load data files
• Developed andoptimized Data Loads and Calculations
• DevelopedCalc Scripts to calculate various figures for the outline of a BSO cube
• ConfiguringODBCEnvironment Variables
• PreparingRelational Data Sources, Consolidating Relation data & developed the OLAP model & Meta -Outlines,Implemented Star Schemaand usedEIS to interface with the company’s existing Oracle data warehouse
• Developed andmaintained Rulefiles, Calc Scripts, MaxL Scripts & Reports
• Developed theCalc scripts to calculate complex valueslike Acquisition Cost, Gross Margin / Inventory Turn, Revenue / Payroll Hr, Total Head Count, Revenue per QTY, Revenue per Square Foot, Return on Assets, Property, Plant & Equipment, Cash Cost Per User and YTD Commitment & Variance
• Involved inPerformance Tuningto minimize data load time
• Analyzed all dimensions and members in the ESSBASE outline
• Performed tuning by using theDense/Sparse settings and developed the required alternate rollups for reports
• Responsible forPerformance Monitoring, Backup and Recovery of the cube
• Implemented various troubleshooting procedures torecover databases
• Developed thePL/SQL stored proceduresfor implementing the business logic
• Constructed Oracle DatabaseTriggers and Indexes
• Responsible for CodeReviews and PL/SQL Code Tuning
• Gained a thorough understanding of thebanks products, services and SBU structureto analyze the performance of various businesses, and prepare financial reports for management

Environment: Hyperion ESSBASE 9x, ESSBASE Integration Services 7x, Microsoft Excel 2000, MS SQL Server 7.0, Windows NT/2000, UNIX, Oracle 10g , PL/SQL, SQL*Loader

Confidential,Apr’ 08 – Nov’ 08 Oracle Hyperion Developer/Administrator
Project Scope: 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 Met-outlines 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 cube
• 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 Work Space, 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

Confidential,IL May’ 07 – Mar’ 08

Essbase Developer

Project Scope: The project consists of developing, managing, and optimizing cubes. Also helping the financial team to observe and manage performance of their company.

Responsibilities:

• Involved in defining requirements, functional specifications, designing documentations and testing strategies
• Developed outlines, Calculation scripts, Load rules for loading data, and Esscmd Scripts for Automation
• Used Autosys for automation
• Developed two cubes one For Loans and one for Credits
• Created batch files using ESSCMD and rule files to upload data from the source System to Essbase cube
• Implemented UNIX Shell scripting
• Implemented ETL process for extraction of data for building cubes using SQL Jobs, packages, stored procedures, etc
• Extensively involved in designing and modifying the outlines for Essbase Cubes
• Debugged and optimized data loading by grouping and positioning
• Produced ad-hoc reports using Hyperion Reports
• Planned and coded complex reports developed in Excel using VBA and the Essbase API
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers

Confidential,IL Oct’ 05 – Apr’ 07
Essbase Developer
Project Scope: The project involved Hyperion Essbase suite of tools to implement a central reporting application. Data from Mainframe system is loaded into an Oracle data-mart. Using Essbase Integration Services (EIS), Essbase cubes are built to support drill-thru reports.
Responsibilities:

• Analyzed user requirements and actively involved in the process of finalizing views for the existing cubes.
• Involved in developing the star schema for the EIS OLAP model.
• Developed Meta-Outlines for ESSBASE BSO cubes.
• Created Data Load Rules for manipulating records and loading the Enterprise data Ware house using rules files.
• Developed drill-thru reports using EIS.
• Automated the entire cube build process using MaxL. The MaxL scripts build the dimensions, load data, calculate the database and to define partitions. MaxL scripts were also used to do scheduled extraction of data from Essbase cubes using Report scripts. The MaxL scripts are invoked through Batch files on a schedule.
• Analyzed and created the user views for internal and external users and maintained securities on those views using Hyperion Analyzer.
• Trained the users in administration of Hyperion Analyzer.
• Developed Executive information Systems interface reports for end users using Hyperion Dashboard Studio.
• Developed the Daily Sale Reports using Interactive Reporting going against Sales system.

Environment: Hyperion Essbase, Hyperion Analyzer, Hyperion Interactive Reporting, Essbase Integration Services (EIS), Excel Add-in and Windows 2000

Confidential,India Apr’ 03 – Aug’ 05
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

EDUCATIONAL QUALIFICATIONS
B-Tech (Computer Science Engineering)