Hyperion

VIJAY PADMA

SUMMARY

 Over eight years of diverse experience in Information Technology with emphasis on Data warehousing OLAP tools.

 Over seven years of diverse experience in OLAP design, analysis, architecture, development, implementation, reporting, administration, and migration of various applications in client/server environment using Hyperion Essbase, Hyperion Planning, Essbase Integration Services, Hyperion Reports, Hyperion Analyzer, Essbase Spread Sheet Add-in, Essbase Query Designer under Windows and UNIX environments.

 Investigated the latest version of Fusion Edition (11.1.1), Oracle Essbase 11.1.1 and Essbase Studio

 Experienced Hyperion System 9.3 modules (Hyperion System 9 BI+ Analytic Services, Hyperion System 9 Planning, Interactive Reporting, Financial Reporting, Production Reporting and Dashboards)

 Extensive knowledge in Hyperion Business Rules (HBR), Hyperion Application Link (HAL), Essbase Calculation scripts, Essbase Commands and Essbase functions.

 Developed performance Dashboards enabling business intelligence reporting (BI) including benchmarking, metric identification, performance measurement and target setting

 Created OLAP Models and Meta outlines using Essbase Integration Services (EIS) to populate Essbase database.

 Performed Dense/Sparse settings, Optimization of Data load and Optimization of Calculation scripts and Business Rules.

 Expert level knowledge and understanding of ESSCMD and MAXL scripts used for automation and partitioning.

 Experienced Oracle Data Integrator (ODI) and Data Integration Management (DIM) to load both metadata and data

 Experienced in working with Aggregate Storage Outline (ASO) and Block Storage Outline (BSO).

 Experience in SDLC that included duties like providing documentation on design, testing and migration from development to production.

 Highly organized with proven ability to prioritize, manage multiple tasks, and meet deadlines with deliverables

 Excellent communication and interpersonal skills and outstanding team player with an aptitude to learn.

TECHNICAL SKILLS

OLAP TOOLS Hyperion System 9 BI+ Analytic Services 9.3, Hyperion Essbase 7.x/6.x, Hyperion Planning System 9.3, Hyperion Planning 3.0/4.0, Hyperion Workspace 9.3

REPORTING TOOLS Hyperion Financial Reporting release 9.3, Hyperion Interactive Reporting release 9.3, Hyperion Production Reporting release 9.3, Hyperion SmartView 9.3, Hyperion Reports 7.2, Hyperion Excel Spreadsheet Add- in, Hyperion Analyzer7.2.x, Crystal Reports

PROGRAMMING LANGUAGES SQL, PL/SQL, C, C++, Jdk1.3, Perl, Visual Basic 6.0/5.0/4.0.

DATABASES Hyperion Essbase, Oracle 9.x/8.x/7.x/6.x, DB2, MS SQL Server 2000 7.0/6.5, Teradata 6.5, MS Access

THIRD PARTY SOFTWARE TOOLS SQL *Plus, TOAD, SQL Navigator

WORK EXPERIENCE

GAP Inc., San Francisco, CA Dec 2008 – Present

Sr Hyperion Developer

PROJECT: Corporate Legal Entity project

GAP Inc., one of the largest apparel retailers, wanted to convert their corporate BSO applications into ASO applications and also include a new dimension to their existing applications to improve calculation and retrieval performance. This project also involved in designing partitions from each of their brand applications into the corporate applications and scheduling various processes using MaxL.

RESPONSIBILITIES:

 Designed the architecture and the maintenance processes for the new ASO applications.

 Converted all the BSO member formulas and calculation scripts to the appropriate MDX formulas and correct solve-order

 Design partitions from each of the five brand applications into the corporate applications

 Leverage existing load rules to build dimensions and load data

 Designed aggregations using aggregation scripts and materialized various views to improve the retrieval performance

 Optimized MDX formulas and improved calculation time

 Held responsibility for maintaining the Corporate ASO applications

 Developed and scheduled various maintenance processes like data refresh, Re Org, aggregations etc using MaxL and Batch scripts

 Migrated applications from one environment to another

 Prepared technical design document and Administrator’s guide for the complete project

ENVIRONMENT: Essbase Administration Services 7.1.6, Hyperion Essbase 7.1.6, Essbase Excel Add-in, Windows NT

Camelbak Products, Petaluma, CA Jun 2008 – Nov 2008

Sr Hyperion Administrator

PROJECT: Hyperion System 9 Planning: Budgeting and Forecasting

Camelbak Products, wanted to implement the web based Hyperion Planning System 9 to complete their budgeting, forecasting and reporting process, replacing their existing complex myriad of excel spreadsheets. This phase of the project focused on the budgeting and forecasting of the Operating Expenses, Workforce Planning, and Sales forecasting with Gross Margin Analysis. This project also focused on completing their reporting needs using the Hyperion System.

RESPONSIBILITIES:

 Led the complete implementation of Hyperion Planning System right from scratch to the production move.

 Designed and supported the complete architecture, installation and configuration of the entire Hyperion system

 Held accountability for system maintenance, supporting and monitoring, capacity planning, resource management, evaluating and implementing upgrades and patches, performance tuning as well as security maintenance.

 Worked closely with business stakeholders to correctly identify their requirements and ensured the design satisfies the requirements.

 Created projects and interfaces to load metadata and data into the Hyperion Planning applications using both Planning and Essbase Knowledge Modules (KMs) in Oracle Data Integrator (ODI)

 Streamlined data movements/interfaces across different plan types and applications using XREFs and DATAEXPORT options

 Created and maintained interfaces to move data into and out of Hyperion cubes

 Built complex Business Rules, fine tuned them and attached to web forms

 Tuned and optimized Essbase outlines and cubes by setting the correct order of dimensions, dense sparse settings and compression method

 Designed and implemented Workflow to facilitate the budgeting process in Planning applications

 Implemented the Hyperion Workforce Planning module and customized it to fit the business requirements and the company needs

 Administered and implemented the Migration, Back-up and Restore procedures of the entire Hyperion environment using MaxL scripts

 Defined and maintained the security of users and groups for various Hyperion components using the native OpenLDAP and User directories in User Management Console of Hyperion Shared Services

 Performed ad-hoc analysis and reporting using Hyperion Smartview for Essbase and Planning

 Created the existing Budget Book reports using Financial Reporting Studio and Web Analysis

 Created various Dashboards enabling a high-level view of performance success for the business units using Hyperion Web Analysis.

 Investigated the latest version of Oracle Essbase 11.1.1 and Essbase Studio

 Prepared training material and well designed documents covering both the functional and technical aspects of the project

ENVIRONMENT: Hyperion System 9 BI+ Analytic Services 9.3.1, Hyperion System 9 BI+ 9.3.1, Hyperion System 9 Planning 9.3.1, Hyperion System 9 Workspace, Hyperion Web Analysis 9.3.1, Hyperion Financial Reporting 9.3.1, Hyperion SmartView, Hyperion Shared Services, Oracle Data Integrator (ODI), Oracle 10g,

Advanced Auto Parts, Roanoke, VA December 2007 – May 2008

Sr Hyperion Developer/Admin

PROJECT: Hyperion System 9 Planning and Budgeting: Phase II

This project is Phase II implementation and extension of the Hyperion Planning and Hyperion Essbase, the primary financial analysis and consolidation tools, as a budgeting and forecasting solution to workforce, capital expense, store sales and store payroll processes. The result of this project is to simplify and streamline various processes related to planning into a fully integrated web-based application. This project focused on accelerated information flow, data management, metadata management, business rules, web forms and reporting.

RESPONSIBILITIES:

 Worked with business users to identify requirements and translate requirements into developing the right solution for customer analytical solutions.

 Experienced Hyperion Application Link (HAL) and Data Integration Management (DIM) to perform dimension build for all the plan types.

 Defined and developed Load rules and Report Scripts to perform dimension build and data load.

 Worked closely with business stakeholders to ensure the design satisfies the requirements.

 Developed and optimized many complex business rules to meet the business’ calculation requirements

 Worked with Aggregate Storage Outline (ASO) and Block Storage Outline (BSO) to store different types of multidimensional data

 Designed and implemented Workflow to facilitate the budgeting process in Planning applications

 Maintained interfaces between Hyperion System 9 and external systems like Oracle, DB2 and People soft Financials

 Developed SQL queries to communicate with Oracle and DB2 databases

 Performed ad-hoc reporting and analysis using Hyperion Reporting and Smart View.

 Redesigned and fine tuned various business rules and data forms built in Phase I

 Developed and scheduled MaxL scripts for overnight batch processes

 Gathered and documented functionality from native Essbase applications and ensured that all the functionality is included in the new planning applications

 Created well designed documents of all the processes during both the design and build stages

ENVIRONMENT: Hyperion System 9 BI+ Analytic Services 9.3.0.1, Hyperion System 9 BI+ 9.3.0.1, Hyperion System 9 Planning 9.3.0.1, Hyperion System 9 Workspace, Hyperion Financial Reporting 9.3, Hyperion SmartView, Hyperion Shared Services, Hyperion Application Link (HAL), Data Integration Management (DIM), Oracle 10g, Websphere 6.1.0.5, AIX

PriceWaterhouseCoopers, Tampa, FL Jun 2007 – November 2007

Hyperion Administrator/DBA

PROJECT: FIN US National Budget Application

The purpose of this project is to replace the current Excel based system with a more robust and technologically advanced application that would offer standardized solutions to the current budgeting, forecasting, and reporting challenges now and in the future. This solution is part of a multi-phase implementation. This project will provide PwC with more powerful multi-dimensional reporting capabilities and be used as a dynamic tool for creating Budgets and Forecasts.

RESPONSIBILITIES:

 Primarily responsible for upgrading, administering and monitoring the Essbase Database and Hyperion environments for Financial Reporting, Planning the forecasting and budgeting system.

 Involved in the load test of Business rules and Financial reports emulating the realistic production workload using Load Runner test scripts

 Played an integral part of the installation, configuration, upgrade and support of PwC's Hyperion solution.

 Migrated and took back ups of different Hyperion applications across Development, Test and Production environments

 Held responsibility for stopping and starting of different Hyperion services, applications and databases for various Hyperion products

 Maintained the configuration settings, Oracle schemas, startup scripts, and various log files

 Interacted, coordinated and provided technical support for the Development, Weblogic, Oracle and Unix teams for the continuous and smooth running of the Hyperion applications

 Maintained the security of users and groups for various Hyperion components using the native OpenLDAP and User directories in User Management Console

 Provided all the required Hyperion Administration and DBA support of all Hyperion components of the Essbase, Planning and Reporting systems - database servers, application servers, batch job servers, and file servers for the development, test and production environments.

ENVIRONMENT: Hyperion System 9 BI+ Analytic Services 9.2.0.2, Hyperion System 9 BI+ 9.2.0.2, Hyperion System 9 Planning 9.2.0.2, Hyperion Financial Reporting 9.2, Hyperion Shared Services, Hyperion Interactive Reporting, Hyperion Application Link, Oracle 9.2, Weblogic 8.1.4, Windows NT and Sun Solaris 9.

Bank of America, Charlotte, NC Jan 2006 – May 2007

Consultant-Technical

PROJECT: Associate Data Information Management (ADIM)

ADIM is converting the legacy systems of the newly acquired business units to Bank of America integrated system. The system is using Teradata database to build multidimensional Essbase cubes. Hyperion Analyzer is the reporting tool and Spread Sheet Add-in is in use as ad-hoc reporting tool for the business users and analysts respectively. These modules will make more information readily available to the users than ever before, discounting the need for ad hoc reporting.

RESPONSIBILITIES:

 Designed and developed Hyperion Web forms & reports

 Developed OLAP Models and Meta outlines in EIS for all the Essbase cubes in requirements of the business logic.

 Developed the load rules (Hierarchies), member functions to perform dynamic calculations for the Essbase cube build.

 Developed .cbs files for scheduling Dimension Build and Data Load processes.

 Developed calculation scripts and tuning of calculation scripts was performed.

 Optimized the Essbase cubes and calculation scripts.

 Designed and developed Hyperion Analyzer Reports for the purpose of accessing the on line reports by the users.

 Monitored the system to check the performance issues and do necessary modifications in the Essbase functions.

 Raised, documented, and helped resolve any project issues

 Trained and helped the users to access the online Hyperion Analyzer Reports.

 Involved and designed user manuals and documented the entire cube specifications.

ENVIRONMENT: Essbase Administration Services 7.1.2, Essbase Integration Services 7.1.2, Hyperion Analyzer 7.2, Essbase Excel Add-in, Tomcat 4.1.3, Teradata 6.5, Windows Pro and UNIX.

Citigroup, Tampa, FL Jan 2005 – Dec 2005 Senior Analyst/Developer

PROJECT: FinanceOne Global Information System-FRS

The main purpose of Financial Reporting System (FRS) is to replace all internal reporting systems with new systems constructed around a common set of software tools and using consistent data standards. The three major modules of this system are data collection, consolidation and reporting. The reporting and inquiry processing is handled by Essbase Cubes. FRS is fully web based and can be accessed by Citigroup’s intranet through web browser- Internet Explorer. The inbound data is uploaded and processed into the Data Warehouse. The data from the warehouse is periodically processed into Essbase. The predefined Hyperion reports access the multidimensional data in the cubes for historical and other types of analysis. Hyperion Analyzer and Essbase Excel Add-in is in use to generate ad-hoc reports from data in the Essbase cubes. Hyperion Planning Cube is in use for budgeting and forecasting.

RESPONSIBILITIES:

 Involved in defining requirements, functional specifications, design documentation and test strategy.

 Involved in Capacity Planning meetings and project management meetings.

 Involved with customers and data analysts in design of data flow, integration and transformation of data into data marts.

 Designed and developed OLAP Models and Meta outlines in EIS for all the Essbase and HyperRoll cubes in requirements of the business logic.

 Extensively used ESSCMD & MAXL Scripts to run batch jobs on UNIX systems.

 Responsibilities include gather requirements, design, implement, test, and deploy planning and forecasting system that allows finance users to gather and allocate labor expenses, and other expenses to projects.

 Defined the load rules, functions and performed dynamic calculations

 Help business analysts and customers in providing solutions for the data validation.

 Build information reporting/budgeting systems using VBA, Excel, and Essbase.

 Designed and developed predefined management reports using Hyperion Reports and Hyperion Analyzer, and also generated ad hoc reports using Hyperion Essbase Excel Add-in.

 Worked on building client dashboards using Hyperion Analyzer for generating reports.

 Involved in developing and maintaining Currency Conversion Applications.

 Worked on migration of Hyperion Essbase from version 6.5.1 to version 7.1.

 Involved in migration of the Hyperion cubes from Sun Solaris to IBM.

 Setup filters and user roles, administrative privileges to access applications, reports and databases.

 Responsible for application infrastructure and maintenance of Hyperion Suite

ENVIRONMENT: Hyperion Essbase 6.5/7.1, Hyperion Planning 4.0, Hyperion Analyzer 6.5/7.2, Hyperion Reports 2.5/7.0, Essbase Integration Services 6.5./7.1, Essbase Excel Add-in, WebSphere 5.0, HyperRoll 4.0, Oracle 9i, PeopleSoft (EPM) 8.x, Windows Pro and Unix.

Williams Group, Tulsa, OK Nov 2003 – Dec 2004

Essbase Developer

PROJECT: ACES INTEGRATION WITH ESSBASE

Advanced Commercial Energy System (ACES) was a new system, which was being implemented to provide data to the data warehouse and to the end users across the country through Essbase cubes. The cubes provide earning statements, Net income statements, Earned net income and various other business segment reports, which are dependent on the nightly Essbase batch process. Developing calculation scripts depending on the accounting business logic was one of the various challenges in the project. Visual Basic and Essbase Integration Services was used to load and update the Essbase cubes. Developed, designed, implemented, tested, and deployed Hyperion Planning cube for forecasting and budgeting for finance users. Intensive troubleshooting was one of the requirements since the data load was dependent on various processes and the cubes were supposed to be available to the users 24/7.

RESPONSIBILITIES:

 Performed SQL tuning to minimize data load time. Excellent gain in performance recorded.

 Involved in defining requirements, functional specifications, design documentation and test strategy.

 Involved in weekly status meetings, documentation and status reporting.

 Developed calculation scripts and tuning of calculation scripts was performed.

 Worked with Business users in developing Hyperion Planning Cube along with Essbase Cubes.

 Enforced Business Rules for budgeting and forecasting for the Planning Cube.

 Developed forms for the purpose of input of data for the Planning cube.

 Developed reports using Hyperion Analyzer and Hyperion Reports.

 Implemented various troubleshooting procedures to recover databases.

 Developed procedures, which loaded data to various tables in the data warehouse, which then was used update the outline.

 Extensive troubleshooting of each piece of process, which played part in providing data to the Essbase cube, which included, Essbase Integration Services, the data warehouse procedures and the Essbase cube itself.

ENVIRONMENT: Hyperion Essbase 7.0, Hyperion Planning 3.0, Hyperion Analyzer 7.0, Hyperion Reports 2.5, Essbase Integration Services 7.0, WebSphere 5.0, Oracle 8i, Windows NT 4.0, Unix.

American Electric Power (PSO), Tulsa, OK May 2002 – Oct 2003

Essbase Developer

PROJECT: INSIGHT

The project involved charging the various revenue producing BUs with the actual fixed and variable expenses incurred by the Service Provider BUs each month, vis-à-vis the ‘budget’ expenses planned in the ‘Indirect Budget’. The invoice provides a detailed guideline to measure the financial performance of their SBU by comparing their actual expenses vs. the ‘budgeted’ expenses in the plan.

RESPONSIBILITIES:

 Developed batch files and rules files to upload files from financial system and data warehouse system to Essbase cubes.

 Assisted in creating rules files for multidimensional databases

 Developed Data Load Rules, Calc Scripts & Report Scripts.

 Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.

 Analyzed financial results, compared Actual Vs Forecasts, Current Vs Prior year, and prepared trend reports to provide business managers an effective tool to make profitable decisions about their business.

 Prepared Hyperion profitability reports, which detail unit cost, business volume trends, and expense variances over prior periods, for all BUs across the organization

 Through internal training and practical experience, got familiarized with budgeting system, mainframe applications and the General Ledger database.

ENVIRONMENT: OLAP Data Warehousing using Hyperion Essbase 6.5, Hyperion Analyzer 6.5, Essbase Excel Add-In and MS- Access.

ALCOA, Pittsburgh, PA Jun 2001- Apr 2002

Essbase Developer/Analyst

Alcoa serves the aerospace, automotive, packaging, building and construction of commercial transportation and industrial markets. Alcoa always is in need of numerous web-based financial reports as well as their in-house financial reports for its widespread international markets as well as domestic businesses. Hyperion Essbase, Hyperion Analyzer had been extensively used to generate these reports. With the help of these Hyperion products, financials are deployed online and managers can see the numbers on a daily basis.

RESPONSIBILITIES:

 Build and maintained two new Essbase cubes, one for Alcoa’s international markets and the other one for its domestic markets.

 Analyzed user requirements and involved in the process of finalizing dimensions for cubes.

 Used Essbase administrative activities such as creating filters, assigning users and groups to the filters and maintaining Essbase Servers.

 Optimized the applications to bring down the runtime and database size considerably.

ENVIRONMENT: Hyperion Essbase 6.2, Hyperion Analyzer 6.2, Hyperion Reports 2.0, Essbase Integration Services 6.2, Microsoft Excel 2000, Oracle, Windows NT 4.0, Unix

Contact this candidate