Professional Summary:

• 7 years of overall functional and technical experience in implementing and supporting BI solutions from mid-size to Fortune 100 Companies.
• Involved in every aspect of development lifecycle from requirements gathering, design docs to development, implementation and maintenance.
• Certified Essbase Consultant, Certified Planning Consultant.
• Specialized in Hyperion Application Development and administration using Hyperion System 11x, Essbase ASO, and BSO, Planning, Financial Reporting, Essbase Studio and ODI.
• Worked with many ETL tools such as HAL, DIM, SSIS, ODI, SQL interface, FDM etc.
• Very good experience on writing Member Formulas, Calc Scripts, BR’s, MDX for calculations, allocations, aggregations etc.
• Expertise in Automations, Optimizations, Converting BSO to ASO, Database backups, Partitioning, ESSCMD, MAXL, MDX, VBscripting etc.
• Experience in Hyperion System9 modules (Planning, Capital Expense Planning, Workforce Planning, Interactive Reporting, Financial Reports, and Dashboards)
• Expertise in buildingFinancial Budgeting and ForecastingOLAP applications with ESSBASE and Planning.
• Experience in installing and maintaining infrastructures. Performed day to day administrative tasks.
• Involved in managing the Hyperion security infrastructure by assigning proper privileges to users and groups, Scheduling daily batch processes using CONTROL-M
• Good understanding of data warehousing architecture in terms of Logical model, Physical model, RDBMS, ETL, Reports.
• Expertise in design documentation and testing strategies.
• Involved and handled many client meetings with many diverse teams during development process.
• Hands on experience with Hyperion V 11.x Essbase, Planning.
• Hands on Experience with user training on planning, FR, Smart view etc.

Technical Summary
OLAP Tools : EPM 11x, EPM 9.3.1 and PreSystem9x.
ETL : HAL, FDM, EIS, Essbase Studio.
Databases : Oracle Fusion/10g, MS-Access, SQL Server, DB2.
Reporting Tools : FR, Web Analysis, Smart view, Report Scripts, Drill through etc
Automation Scripting : MAXL, ESSCMD, BATCH, Shell, PERL, Control – M.
and Multimedia Web Design.
Operating Systems : Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential,Mar2012 –Present.
Bannockburn, IL.
Confidential,serves as a leading provider in customer care outsourcing solutions with global BPO services. Hyperion ESSBASE and PLANNING is implemented for their Profitability and financial analysis. BSO cubes were used for the Revenue and Quantity. Historical data is stored in the ASO cubes and the Workforce planning in which the BSO cubes where stored the employee’s hours and designation.

Responsibilities:

• Involved in design and development of the new cubes as per the business requirements.
• Developed the rule file and also the SQL script for pulling and modification in the rule file as per the business requirements.
• Involved in automation of the daily loads by creating the MAXL SCRIPTS and scheduling them using the windows scheduler.
• Was also involved in the daily production issues and the requests from the users.
• Involved in creating the complex Calc script for the Corp ops allocations, Variance ,Cash flow , P&L Reports, Forecast scripts, etc.
• Was involved in developing the work force applications which captures the labor expenses and the head count and the number of billed hours and break hours for the variance analysis and for the daily analysis.
• Developed the various Calc scripts and the Business rules for the planning applications for the variance
• Involved in developing the report scripts for the pulling the actuals, flash and forecasted data.
• Educating the user on the smart view and also about the reporting options in the smart view.
• Involved in optimization of the calc scripts and also modifying them according to the user requirements.
• Worked on restructuring the database outlines to get the best performance of Essbase Server.
• Developed the batch scripts and also the MAXL scripts for the daily loads to automate the process.
• Was involved on developing the various web forms and business rules as per the user requirements.
• Involved in developing the security at the user, group and cost center level using the Hyperion shared services and also using the ESSBASE.
• Implemented the column level security for the user so that they can enter the values using the web forms.
• Implemented the cost center level and dimension level security for the user to lock and send the values to the ESSBASE BSO applications.
• Was involved in developing the scripts for extracting the flat files as per the user requirements.
• Was also involved in the adding developing the queries for the checking the addition of the new clients and the cost center into the essbase and planning cubes.
• Was closely working with the CFO, VP, Director of the company and was making the changes according to their requirements.
• Was also involved in upgrading the ESSBASE and PLANNING from version 9.3.1 to 11.1.1.2.
• Involved in various production issues like the calculation and data load issue and optimizing them.
• Developed the transparent partition from BSO cube to the ASO for the data transfer.
• Worked on Excel Add-in Tools to generate various reports to analyze the business.
• Was closely working with the SAP team ,also the other finance and the data ware house team in order to get the data in a consolidated and aggregated manner for the ESSBASE feeds.
• Involved in solving the print server issue and also configuring the ghost script in order to print the web forms or any other reports through planning and HFR.
• Was involved in the daily metadata updates and how the data changes or addition of new cost centers in the ESSBASE.
• Created a detailed documentation on the production and the developing issues and how they are fixed.

Environment:
Hyperion Planning and ESSBASE 11.1.1.3 and 9.3.1, ESSBASE studio, Oracle 10.2.0, Web Analysis, FR reporting, Smart view, Windows 2003, .

Confidential,Oct2011- Mar 2012
DALLAS, TX
Confidential,is a global leader in the heating, air conditioning and refrigeration markets. Hyperion is implemented for their different cost centers and also for the services and producing the products. We used BSO cubes for the planning and also where using the ASO in ESSBASE and ESSBASE STUDIO. Used Hyperion Financial Reporting for the reports.
Responsibilities:

• Involved in solving the various production issues.
• Experienced in using the remedy to access the tickets and updating the response and resolution of the tickets.
• Involved in solving the tickets like the actual are not populating and calculating .issues been solved by checking the calc scripts and substitution variables and etc.
• Was involved in creating the various balance sheet ,P&L Reports, cash flow reports and many user specific reports using the financial reporting
• Was involved in developing the BSO cubes for cost centers, restructuring and for residents which were also used in the planning.
• Created replicated and the transparent partition as per the user requirements for the smart view reports.
• Developed the Maxl script for the creating dropping and refreshing the replicated and the transparent partition.
• Involved in developing and monitoring the batch files also the Maxl scripts for the daily loads and aggregating them.
• Worked on calculation scripts to optimize the calculation time and also modified the existing ones to meet the end user requirements.
• Tested and Cross tested (System testing) all the reports before publishing. And documenting all the errors occurred and how they are been resolved.
• Designed the Security Policy at User, Group, and Entity Levels using Hyperion Shared Services.
• Implemented Column Level security for specific users who can access a part of the tool, like just answers and Dashboards.
• Implemented Security by creating roles & web groups using External tables Authentication.
• Involved in loading metadata into planning by using DIM and Oracle Data Integrator (ODI).
• Involved in developing the web forms and the business rules as per the user requirement.
• Involved in the installation of the various suites of Hyperion like smart view and the EAS console and the excel add-ins on the user systems.
• Provided on call Production support during budgeting and forecasting for Hyperion Applications.
• Was involved in developing the batch script for the start and stop the services. When the workspace goes down.
• Was involved in solving the issues when two different versions of HFR jar files were used.
• Extensively used Guided Navigation for user friendly reports.
• Involved in taking the back ups and also in the monitoring of the batch if the update fails was involved in fixing the data load process.
• Was involved in assigning the security for the dimension without the admin access. By creating a member and then add all the children to that and them assign the access to the group only the one dimension. Both in planning and essbase.

Environment:
Hyperion Planning and ESSBASE 9.3.1,Hyperion Financial Reporting, ODI, FDM, DRM, ESSBASE, SQL Server 2008, smart view, windows 2003.

Confidential,TX Mar‘10 to Oct’11
Role: Essbase/Planning Consultant

Confidential,is a leading Financial Institution and provides various products like general banking, wealth management, investment banking etc. Hyperion applications were implemented for profitability and financial analysis. There are three phases of project implementation that includes redesigning and development of new applications to accommodate new structures. We used Planning, Essbase and Essbase studio for building both ASO and BSO applications. Challenges include 1.7 Million client locations, 1 billion test transactions an year, multiple source systems.

Responsibilities:

• Involved in designing and creating multidimensional database cubes for financial and analytical business queries.
• Worked on building dimension from multi source interfaces.
• Developed many Calc script and Business Rules to calculate complex values like Cash Cost/ User and YTD commitment, Variance, Capital expenditures forecasts, Budgeted cash flows etc.
• Created and developed planning applications to support budgeting process and ASO cube for reporting via Essbase studio.
• Created flexible workflows, task lists that pertains to the budgeting and planning process
• Created and modified rules files for accommodating data format changes and enabling cube loading.
• Developed complex matrix and logic for move data between cubes. Also used many cross ref functionality between the cubes.
• Implemented mathematical functions for computing derived data and worked on optimization of data loads and calc-scripts.
• Developed batch scripts and Maxl for automating and scheduling month end routines, backups, aggregations etc.
• Leveraged the LCM functionality to create complete artifacts backups by developing automated XML scripts.
• Designed the Security Policy at User, Group, and Entity Levels using Hyperion Shared Services.
• Developed workforce application using Hyperion that captures Labor related expenses and headcounts. This application also provides the additional variance analysis.
• Worked on calculation scripts to optimize the calculation time and also modified the existing ones to meet the end user requirements.
• Responsible for tuning the multidimensional cubs to optimized calculations time by using the calculation scripts using the combination of ESSCMD and MaxL.
• Minimized the data load redundancy by loading rules files object in-terms of performance and optimization data source files.
• Worked on restructuring the database outlines to get the best performance of Essbase Server.
• Worked closely with stakeholder, Steering team and SME’s in project management activities.
• Created P&L statement, Balance Sheet, Cash flow statements and many user specific reports using FR, Web Analysis.
• Involved in loading metadata into planning by using DIM and Oracle Data Integrator (ODI).
• Created numerous templates to generate various reports and for Adhoc reporting.
• Developed end user training documentation and conducted numerous training sessions for end users.
• Developed a procedure for bursting the reports by Dept and Entity.
• Implemented various troubleshooting procedures to recover databases.
• Tested and Cross tested (System testing) all the reports before publishing.
• Provided on call Production support during budgeting and forecasting for Hyperion Applications.
• Created ODBC connections and imported the Physical tables, Views, keys and foreign keys as per the Business Requirements.
• Created the repository model with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Created Dimensional Hierarchy for all Dimensions, Level based Measures and Aggregate navigation in BMM layer.
• Developed Dashboards/Reports using the Oracle Business Intelligence platform for requirement analysis.
• Developed Complex Reports by using the Different Views like Table, Pivot, Chart, Static View, Narrative View, Column Selector, View Selector and Combined with Similar Requests.
• Extensively used Guided Navigation for user friendly reports.
• Implemented Column Level security for specific users who can access a part of the tool, like just answers and Dashboards.
• Implemented Security by creating roles & web groups using External tables Authentication.
• Enhanced performance of Reports / Dashboards by implementing the Materialized Views, Table partitions, re-building of indexes and managing Cache etc.

Environment: Hyperion Planning and Essbase 11.1.1.3, ODI, DIM, Essbase studio, Oracle 10.2.0, SQL Server 2008, Web Analysis, FR reporting, Smartview, Windows 2003 and UNIX, OBIEE 11g.

Confidential,WI Aug’08 to Feb’10
Role: Hyperion Consultant

This project was completed in three phase including migration from 9x to 11x. The applications developed in this project include, Workforce budgeting, Revenue & Expense budgeting and forecasting, five year Revenue modeling, Reporting cube with ASO partitioning and Sales/customer application. The main challenges faced in this project are the complex structures of reporting, huge bulks of data and lot of performance tuning. Implementation for this project is done by the INTELLIGROUP.

1. Development of Hyperion planning applications for various usage
2. Development of Essbase ASO cube for profitability analysis.
3. Upgrade of Hyperion environment from Version 9.3.1 to 11.1.1.3 version.

Responsibilities:

• Involved in most of the phases of the project from requirements gathering to production support.
• Designed a Labor budgeting process and labor variance reporting process.
• Defined and developed Load rules, Functions, Report Scripts to perform cube build and data load.
• Created and executed calculation scripts.
• Design and creation of ASO / BSO cubes for OLAP in Hyperion Essbase.
• Designed a partitioning model for ASO write back capability.
• Developed ESSCMD scripts for Dimension Build and Data Load processes.
• Developed ETL procedures for loading data and metadata followed by aggregations.
• Optimized Data Loads, Calc Scripts, aggregations and retrieval performances etc.
• Developed various forms using Hyperion Planning.
• Support development activities with on site-Off shore.
• Worked on Excel Add-in Tools to generate various reports to analyze the business
• Developed many ESSCMD and Maxl scripts for automation.
• Involved in loading metadata into planning by using DIM.
• Worked on restructuring the database outlines to get the best performance of Essbase Server.
• Implemented robust data-access security and user management.
• Developed numerous reports during the support process.
• Automating of cube refresh through MaxL and UNIX scripts.
• Restructured as well as maintained existing Essbase cubes.
• Optimized the applications to bring down the runtime considerably.
• Applied about 31 patches just for 11.1.1.3 version and numerous for earlier versions.

Upgrade from 9.3.1 to 11.1.1.3 version:

This is the New Implementation with few new additional requirements from the Old design.

Roles & Responsibilities:

• Extensively involved in designing and developing the dimensions for planning Cubes.
• Build the dimension load and data load procedures in DIM for the cube building.
• Developed, modified and optimized the SQL queries for RevExp and Projects and workforce module.
• Involved in the Designing and developing a logical procedure for data movement from Workforce to RevExp.
• Involved in the Designing and developing a logical procedure for data movement from Projects to RevExp.
• Developed the Web forms, Business Rules, Smart lists and task lists for RevExp.
• Design the P&L, Balance Sheet, Cash flow statements in financial reporting with new change requirement.
• Designing and Developing CSS allocation procedure in Workforce and RevExp cubes.

Environment: Hyperion Essbase 11.1.1.3,Hyperion Planning 11.1.1.3, Hyperion System 9, Hyperion System 9 BI+, Hyperion Essbase 9.3.1, Web Analysis, Spreadsheet Add-in, DIM, Hyperion Application Link, Workspace, Web Sphere, Informatica, Windows 2003 Server, SQL Server 2000 , Windows XP and Unix.

Confidential,Vernon Hills IL. Mar’07 to Aug’08
Role: Hyperion Essbase Consultant

Confidential,based in Vernon Hills, IL is one of the largest banking chains in the United States. Washington Mutual is a diversified financial services company that provides a broad range of banking, asset management, wealth management, and corporate and investment banking products and services. The project included the design and development of new Essbase cubes for Corporate Reporting Framework. In addition, the role involved the design and development of 100 reports, creating Books, scheduling batches using Hyperion Reports connected to HFM and HP.

Responsibilities:

• Designed and developed new Essbase cubes using Aggregate Storage (ASO) and Block Storage (BSO) cube.
• Involved in automation of the cube build through MaxL/Shell scripts and scheduler.
• Involved in optimized Data Loads and Calculations.
• Involved in setting up robust security frame work.
• Extensively involved in installation, configuration, server settings, backups, and client installations of Hyperion products such as Essbase, Essbase Integration Services (EIS), Hyperion Analyzer and Hyperion Reports on both Windows and UNIX environments.
• Upgraded and migrated all the applications and databases from older version, Hyperion Essbase 7.1.2 to newer version, Hyperion Essbase 9.3.
• Created around 100 reports using Hyperion Financial Reports and Smart view (Excel Add-In) for HFM (Hyperion Financial Management), Essbase and HP (Hyperion Planning) applications.
• Developed various reports such as Income statement, Balance Sheets, Cash Flows, Expense, and Operations Reports for different entities.
• Used various functions like Range, Variance, Relative Member, Percent of Total, and If Then to write reports.
• Implemented various troubleshooting procedures to recover databases.
• Developed a testing strategy for all the reports before publishing.
• Support development activities with On site-Off shore.
• Maintained User and Groups for reports defining users and groups and assigning them roles/access privileges.
• Designed and developed various kinds of reports like Trend, Detail and Summary versions for all the divisions and entities.
• Created Books for various reports setting dimensions from Book POV and added reports to the Books accordingly.
• Defined and Scheduled Batches to process sets of reports and Books using Batch Editor and Batch Scheduler.

Environment: Hyperion Essbase 7.1.2, Essbase Integration Services 7.1.2, Hyperion Analyzer 7.2, Hyperion Financial Reports System 9, Hyperion Financial Management, Hyperion Planning, Hyperion Essbase System 9, Essbase Excel Add-In, MaxL, ESSCMD, Web Sphere, Oracle 9i.

Confidential,Dayton OH. Apr’06 to Feb’07
Role: Hyperion Developer

Confidential,deliver information technology, software solutions, and professional services that support every aspect of automotive retailing. Reynolds & Reynolds is in the business of helping automobile dealers sell cars and take care of customers. Data from various online transaction processing (OLTP) applications and other sources is selectively extracted, transformed and loaded into the Oracle data warehouse using PL/SQL. Then the transformed data from data warehouse is loaded into Hyperion Essbase OLAP server to provide Business Intelligence Analysis Services. The end users can drill through the information using Hyperion Analyzer technology and Excel Add-in over intranet/internet. The whole process is completely automated.

Responsibilities:

• Interacted with users to gather requirements, understand business needs and ensured applications met the required changes.
• Designed and developed new Essbase cubes for corporate reporting framework using Aggregate storage (ASO) and Block Storage (BSO) cube.
• Automated periodic data loads and calc scripts using MaxL and Batch Scripts.
• Developed load rules for loading data files and for dimension build and Implemented robust data-access security and user management
• Developed complex financial reports involving Budget Allocations, Retained Earnings, global forecasting of profit and loss and the reported implied changes in balance sheets as well cash flow statements.
• Developed reports using Hyperion Reports, Hyperion Analyzer and modified existing reports to incorporate global operations.
• Involved in front end design using Hyperion Analyzer and Excel templates using VBA.
• Developed reconciliation framework for validated reporting data.
• Involved in high performance tuning and optimization of cubes – sparse/dense configuration, block density and compression, outline structure strategies, batch update streamlining, load optimization (load rules and transformation), and calc script optimization.
• Involved in system installation, configuration and software upgrades from Essbase version 7.X to system 9
• Used a myriad of Hyperion tools including Hyperion Essbase, Hyperion Reports, Hyperion Analyzer, and Hyperion Planning in order to fulfill maintenance requirements.

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

Confidential,India Mar ‘05 – Feb ‘06
Intelligence Innovation
OLAPDeveloper

Confidential,of the leading Cell operator in India. Its daily thoroughfare sales and marketing information in all the four states in South India of its operations and the analysis and reporting deals with all pre paid and post paid subscribers of Airtel.

Responsibilities

• Involved in data acquisition from business users and project planning.
• Involved in Requirement Analysis, Data Warehouse design, loading of data in warehouse under ETL phase using Informatica.
• Data delivery and Information Analysis.
• Break down the information system into functional areas.
• Creating and Maintaining Universes.
• Querying and planning scope of analysis.
• Analyzing and presenting data in Drill, slice and Dice mode.
• Developed and created classes with Dimension, Detail & Measure Objects, and user-defined objects.
• Resolved loops by using Aliases and Context.
• Specified Joins and cardinalities checking.
• Analyzing and presenting data of product sales.
• Creating reports of all the four regions using Business Objects to analyze data of distributor and connect centers movements.
• Escalated technical and management issues to Project Leader at right time.
• Training Users on the various issues of reports.
• Reports into the market variations, comparisons with its earlier movements and move with different schemes so as to make it unique in the market by analyzing and report the activities of the sales and marketing.
• Reports about accounts receivable invoices of sales of various magic currencies, Airtel prepaid and postpaid cards are generated after performing calculations.

Environment
Informatica Power Center5.1, Business Objects, Oracle8i, Erwin4, WinNT.

Hyperion Essbase Consultant.
Hyperion Planning Consultant