SUMMARY

• Over 8 Years of experience in analyzing designing developing Implementing tuning and supporting the Hyperion suite of tools
• Extensive experience using Oracle Hyperion Essbase 11 x/9x/7 x/6x,Hyperion Web Analysis/Analyzer, Hyperion Interactive reporting, 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
• Excel in Essbase studio

SKILL SET

OLAP TOOLS – Hyperion Essbase 11x/9x/7x/6x, Hyperion Web Analysis 11X/9X, Hyperion Financial  Reports 11X/9X, 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
LANGUAGES – SQL, PL/SQL, C, C++
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, Parsippany, NJ Nov 11’ - Current 
Hyperion Developer/Admin

Responsibilities

• Coordinated Installation, Configuration and supported the Overall Maintenance of entire Hyperion system
• Analyzing the raw data and converting it into valuable business information by design & development of appropriate cubes & reports provided seamless integration of historical ,projected and derived data
• Involved in designing and implementing new cubes. Worked with existing cubes , also maintained historical data and launched new products based on the analysis of budget reports and overall database outlines performance and optimization
• Provided hands on Document which explains the functionality of each and every Cube and Reports which helps end user to understand what they can do with Cubes and Reports
• Worked closely with Finance stakeholders to correctly identify their requirements and ensured that all their requirements are met
• Involved in designing and developing of ASO and BSO cubes to support Planning, Forecasting and Reporting
• Automated dim build, data loads, partitions creation ,backup and automate Essbase application refresh process using MaxL scripts and Unix scripts
• Involved in improving performance of the applications, optimized the various cache settings to enhance the performance of Cubes by adding new dimensions and optimized data retrieval by creating materialized views.
• Responsible for the design, development, enhancement, and maintenance of the various BSO cubes used for forecasting and strategic decision-making
• Involved in developing MDX formulas, Report scripts , Data export commands to export the data and created and updated substitution variables
• Extensively used calculation commands and functions to improve the performance of applications developed Calc Scripts for complex calculations and optimized them and Recovered application from its backup
• Created groups and users for different business segments and then assigned security and filters to define Essbase privileges on them
• Executed automation of Outline build and data loads for cube refreshing, updating substitution variables, performing month end and year end maintenance, ongoing performance tuning, defragmenting, taking regular backups, restoring Essbase objects
• Responsible for security provisioning using shared services across the entire Hyperion environment.
• Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers
• Supported and monitored upgrades, patches and batch jobs which automate Data Loads,
• Handled performance tuning, weekly back-ups and monthly and Yearly consolidations of data and automated monthly/quarterly/annual report generation
• Developed Excel Templates for user interface in Essbase database and Performed ad-hoc analysis and reporting using Hyperion Smartview and excel
• Involved in testing the performance of the scripts in UAT and preparing test cases and results.
• Involved in migrating scripts from Dev to UAT and from UAT to Prod.
• On time completion of all assigned tasks and desirables meeting the business expectations and timelines.

Environment: Hyperion 11.1.2.1, Hyperion Essbase, Hyperion, Hyperion Smartview, Hyperion Workspace, Financial Reports, Hyperion Shared Services, Windows Server 2008/2003, SQL Server 2008

Confidential, Bloomington, IL Sep’ 10-Aug’2011 
Application Developer/ Administrator

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, partition 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 WorkSpace11.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

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 values
• 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, TX Apr’ 08 – Nov’ 08 Oracle Hyperion Developer/Administrator 

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
• Developed numerous calculation scripts, 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 May’ 07-Mar’ 08

Essbase Developer

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, Vernon Hills, IL Oct’ 05 – Apr’ 07
Essbase Developer

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 Apr’ 04 – 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),