SUMMARY

• Over Seven years design, analysis, development and implementation of various OLAP applications in client/server environment using Hyperion System 11, Hyperion system 9, Essbase Integration Services, Hyperion Reports, Hyperion Analyzer andEssbase Excel Add in.
• Extensive Experience in Hyperion Interactive and Financial Reports, Hyperion Planning and Hyperion Analyzer.
• Extensively worked with Off-shore teams for development and post production support and involved almost round the clock.
• Also involved in client interactions during projects, for enhancements in the existing application and for supporting purposes.
• Working knowledge in OBIEE.
• Experience working on SQL server Analysis Services.
• Experience in loading data into Meta outlines using Essbase Integration Services from various RDBMS.
• Extensive experience in End-to-End development process till product implementation and support process.
• Strong understanding of dense and sparse dimensions, data loading, dynamic calculations and optimization.
• Experience working with ESSCMD, Essbase Excel Add-in, Financial Reports, Forms and Web Analysis.
• Experience working with Hyperion FDM and ODI.
• Experience in performing Upgrade, Maintenance, Database Backups, and Performance Tuning.
• Developed and maintained Rule Files and Batch Scripts.
• Worked on Financial reporting systems and Decision Support Systems (DSS) using Hyperion Essbase and developed Financial Budgeting and Forecasting OLAP applications.
• Expertise in writing ESSCMD and MaxL Commands.
• Proficient in creating, manipulating and maintaining Essbase Calculation Scripts (Calc Scripts).
• Strong knowledge and expertise in Database Optimization with Dimension Building, Data Loading, Indexing, Cache Management and Partitions.
• Excellent business communication and presentation skills.

TECHNICAL SKILLS

OLAP Tools:Hyperion System 9 Analytic services, Hyperion System 9 Analytic administration services, Hyperion System 9 Planning, Hyperion Essbase 7.0/6.x, Hyperion Financial Management 3.51, Essbase Integration Services 7.0/6.x, Essbase Administration Services 7.x, Essbase Deployment Services 7.x. Business Intelligence Tools:Hyperion Interactive Reporting Studio 9.3/9.2, Brio 8.3/6.5,Hyperion Analyzer 7.0/6.x, Hyperion Reports 7.0/6.x,  Hyperion Planning 3.3.x, Hyperion Application Link (HAL).Web Server:IIS 6.0/5.0, Web Logic Server 7.0/8.1Languages:Java, C++, C, Visual Basic 6.0, SQL, PL/SQL, XMLRDBMS:Oracle 10g/9i/8i, MS SQL Server 2005/2000, MS-AccessOperating System:Windows NT/XP/2000, Linux, UNIXInternet Technologies:ASP, JSP, Java Script, HTML, DHTML, XML, VB Script

Education:M.S Electrical and Computer Engineering

Trainings Underwent in Oracle University:Hyperion Planning 9.3.1. Installation and Configuration
Hyperion Financial Reporting 9.3.1 for Essbase and Planning
Hyperion Smart View 9.3.1. for Essbase
Hyperion Planning 9.3.1. for Interactive users
Hyperion Financial Management for administrators 11.1.1.3
Hyperion Financial Data Quality Management 11.1.1.3 for admins.

PROFESSIONAL EXPERIENCE

Confidential Mar 2012 – till date
Hyperion Admin/Developer
Roles and Responsibilities:

• Created planning application in Work force module
• Created classic planning applications for the budgeting for the hotel group
• Migrated web planning forms from test environment to PROD
• Created ODI routines and packages to update metadata for several Planning apps.
• Developed calc scripts to perform database calc
• Worked with the Oracle on demand team to schedule maintenance jobs
• Meetings with the business users to understand the requirements for any new deliverables.

Confidential Jan 2011 – Feb 2012
Hyperion LeadRoles and Responsibilities:

• Developed Web forms in Planning.
• Tested the web forms for the UAT
• Work with the off-shore team.
• Developed test scripts for the business users to test the forms.
• Involved in meetings with business users to gather the business scenarios to create the forms.
• Developed reports in Financial Reporting studio.
• Performed new enhancements in the existing Planning outline.
• Trained users in using the Web forms in Planning.

Environment : Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, Hyperion Financial Reporting 11.1.1.3, Windows XP

Confidential, TX Aug 2010- Jan 2011
Hyperion Developer/AdminRoles and Responsibilities:

• Performing weekly maintenance of the Essbase cubes.
• Developing new Essbase outline and adding new members to the outline.
• Loading data into Essbase using rules files.
• Monitoring the Essbase jobs in the Informatica Power Monitor.
• Writing SQL Queries to query the Oracle database for data reconciliation.
• Created new rules files for both loading and dimension building.
• Created reports in Cognos which are sent to the business users.
• Created security filters on the cube.
• Developed calc scripts for the database calculations.
• Optimized the database calculation and loading performance.

Confidential, OH Mar 2010 – July 2010
Hyperion Programmer AnalystRoles and Responsibilities:

• Providing users with access to the required applications.
• Load data into Essbase using rules files.
• Creating new rules files for data loads.
• Created new load rules for dimension building in the outline.
• Created procedures and triggers using Oracle PL/SQL.
• Monitoring the Essbase database performance.
• Involved in optimizing the database restructure.
• Optimized the database performance.
• Providing the audit with the list of users in the Hyperion system.
• Involved in production support.
• Involved in updating the Planning forms with any changes made to it.
• Gathering requirements for the upgrade to system 11.1.1.3.

Environment : Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, Hyperion Financial Reporting 9.3.1, Hyperion Interactive Reporting 9.3.1, Hyperion FDM, Hyperion Strategic Finance, Hyperion HFM, Windows server 2003 R2, Windows XP.

Confidential, NJ May 2009 – Feb 2010
Hyperion Essbase Developer/Admin
Roles and Responsibilities:

• Worked on the hyperion services when there are any server issues.
• Worked on performance tuning of the reports.
• Created users and groups and assigned security to those.
• Developed Total Daily sales reports and Topline reports for each sector.
• Training business analysts in creating reports.
• Involved in regression testing for the Canadian Integration project.
• Involved in resolving helpdesk tickets for Essbase issues.
• Involved in gathering requirements from Users and developing reports.

Environment: Hyperion Financial reporting studio 7.2, Hyperion Essbase 7.2, Hyperion Planning 7.2, Hyperion Analyzer 7.2, Web Analysis Studio, SQL server 2005,Windows XP, Excel Add-in.

Confidential, TX Oct 08- April 09
Hyperion Developer/Lead
Roles and Responsibilities:

• Installed and configured Hyperion system 9.3BI.
• Installed and configured Hyperion system 11.1.1.1 in the Test environment.
• Created Hyperion dashboards pivots, charts, reports using Interactive Reporting Studio.
• Developed reports using Hyperion Interactive and Financial Reporting 9.3.1.
• Implemented Workforce Planning for headcount.
• Created HAL jobs for Dimension build and data loads.
• Worked with the business users to understand and implement the business strategies.
• Created web forms to include supporting details in the cells in Hyperion Planning Workspace.
• Published dashboards to workspace and maintained the user and group activity in Shared Services.
• Created complex dashboards by getting the actual data into the dashboards.
• Extensively worked on the implementation details taking into account the business risks and fall back strategies.
• Involved in assigning security and creating user groups for the HFM applications.
• Created Essbase cube for the budget of 2009.
• Created and executed calculation scripts for automation of shipments, actual and forecasting data.
• Developed reports were published and scheduled jobs in Hyperion Portal and given access to the user groups.
• Tuning and Performance of Data Loads and Calculation Scripts.
• Developed batch files to automate the load process by using ESSCMD and MDX scripts.
• Maintained Essbase applications.
• Created batch files using VB scripts and executed these batch files using Windows Scheduler.
• Created web forms using Hyperion planning 9.3.1.1.
• Involved in production support.
• Involved in the functional documentation.

Environment: Hyperion Interactive reporting studio 9.3/8.3, Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1, HAL 7.3, Web Analysis Studio, HFM 9.3.1.,SQL server 2005/ 2008,Windows XP, Excel Add-in 

Confidential, NY Jul 07 – Sept 08
Hyperion Essbase Lead/ Developer
Confidential utilizes the Money Market and Foreign Exchange Settlement Application for the recording and settlement of FX transactions and money market business. In order to support the new features such as ownership code and global delivery code, business components like budget forecasting and efficiency of the financial model along with the new features are evaluated. As part of this; Data from various online transaction processing (OLTP) applications and other sources is selectively extracted and transformed into a new business model highlighting the advantages of the same. In this process Hyperion Essbase OLAP server is used to provide Business impact and Intelligence Analysis Services. The end users can use this business model to forecast the efficiency and assess the worth of every new feature that is going to be added to the existing process. 
Roles and Responsibilities:

• Worked on the initial requirements and mapped the same to the current business model. Was involved in the conception of the project.
• Worked in configuring Hyperion system 9.
• Involved in Workforce planning for compensation planning.
• Developed financial reports using Hyperion Interactive Reporting Studio 9.3.1.
• Developed customized routine (ETL system) to capture and load data from external (Oracle 9i, MS-Access Flat files) data sources into Oracle database using SQL*Loader PL/SQL procedures.
• Involved in cube population using SQL scripts and MDX scripts.
• Developed batch jobs to refresh plan cubes using HAL executables.
• Developed the HAL routines to automate the dimension building.
• Prepared Documentation with New features Hyperion System 9 BI for the training and support.
• Worked with Hyperion Financial Management (HFM) for financial analysis and reporting.
• Created cubes using transparent partitions to reduce cube update time and provide quicker retrievals for end-users.
• Migrated Security files from HFM and Planning systems to Hyperion System 9 Shared Services.
• Created different Master data models for different Bqy’s as per the requirement.
• Developed Complex Reports, changed the Data Functions and done formatting changes to get the required output using IR studio.
• Worked on various forms using Hyperion Planning 4.0.1.
• Involved in creating databases, entities along with import and export maps in Hyperion Strategic finance.
• Drill down functionality applied for most of the Pivots from top to bottom and bottom to top level.
• Developed Custom Hyperion Query reports with complex user interface (Dashboards) to provide real time reporting capabilities using Hyperion Interactive Reporting 9.3.1.
• Worked with Hyperion System 9 BI interactive Reporting to query relational database and produce charts and pivots from the retrieved result set.
• Worked closely with business users to design, develop and enhance Hyperion queries.

Environment: Hyperion system 9.0, Hyperion OLAP (Essbase) 9.3.1, Hyperion Interactive Reporting 9.3.1.,Web Analysis, HAL 7.3, Hyperion Planning 4.0.1, SQL server 2005, Java Scripts, Oracle 9i, Hyperion HFM 9.0, UNIX, Windows XP, Excel Add-in.

Confidential, New York, NY Jan 06 – May 07
Essbase Admin/ Lead
Confidential is one of the biggest multinational banks in the world which is headquartered in NY. Project involved implementing Hyperion Essbase for their online confirmation of foreign bank transactions. Confirmations are generated first for the online transfers with the details of payee and payer. In the later stage a direct debit is posted on to payer’s bank. The process involves an active time window of 3-4 business days for the debit transaction to be processed. With the new business model analyzed and developed using Hyperion analyzer and report generation process, a new medium of immediate debiting/clearing was introduced. Using Hyperion analyzer the advantages of the new model like speedy processing and speedy settlement of the foreign bank transactions was analyzed. The project involved planning, designing, testing and deploying the product for end users. 
Roles and Responsibilities:

• Involved in the analysis of existing business model, requirements and mapping the traceability of the same.
• Involved in configuring and migrating from Hyperion system 7 to system 9.0.
• Used Hyperion Essbase Application Manager to develop new database Outline, Load Rules Files, and Calc scripts and Java scripts.
• Set up partitions to eliminate redundancy of data.
• Used SQL scripts to query the SQL and Oracle databases.
• Tested HAL jobs and MAXL Scripts for the migrated applications.
• Used Hyperion Application Link (HAL) to establish connection between an Essbase database and a PeopleSoft System, developed data flow diagrams for the same.
• Developed translation rules and used them with the translation adapter in HAL.
• Held accountability for system maintenance, supporting and monitoring, capacity planning, finance management, evaluating and implementing upgrades and patches.
• Loaded data from text files into Essbase cubes for analysis and forecasting.
• Assisted with the integration of financial reporting along with streamlining of process/method improvement for data collection using HFM and Hyperion Planning.
• Created a Database on MS Access and Lotus Notes for the Global Headquarters of the Company in the Middle East.
• Designed and developed predefined management reports using Hyperion Financial Management.
• Used Dashboard Studio Optimize Utility features to edit the Interactive Reporting documents for Move, Show or Hide, Lock and Unlock, Rename, and Delete SECTIONS.
• Used various types of Calculations such as Dynamic calc, Two-Pass Calc, Intelligent calc for Outline Calculations
• Generated customized reports that represented financial and operational views and deployed the Reports using Hyperion Interactive Reports to view in the web browser.
• Involved in performance tuning to improve the query performance and also involved in performing database tuning by setting appropriate index, data and calc cache.

Environment: Hyperion Essbase 9.1, Hyperion Planning 3.5.2, Financial Report Studio and Interactive Report Studio, Web Analysis, Oracle 10g, Java Scripts, HAL, Hyperion HFM, Windows XP, Excel Add-in.

Confidential, OH July05- Dec 05 
Essbase Developer 
Confidential is a division of Sterling Jewelers Inc., headquartered in Akron, Ohio. Together with Signet Group plc, their London-based parent company is one of the largest specialty retail jewelers in the world. Executive leadership needs management reporting system to obtain all relevant information to assist in decision making and to understand the feasibility of fusing new business models in the current system. This management reporting system is used to draw analysis of the current business scope and strategize the formal execution of new models and make the business model more effective. Report generation system is user friendly for the end users to assess the new models and the respective functionality in terms of implementation.
Roles and Responsibilities:

• Provided specialist level functional and development knowledge in designing Hyperion System 9 solution to meet business requirements and maintained the interface points between Hyperion System 9 and other applications.
• Involved in complete life cycle of cube from specification requirement to production move of the cube.
• Worked with Aggregate Storage Outline (ASO) and Block Storage Outline (BSO) to store different types of multidimensional data.
• Maintained Hyperion Financial Management system and assisted in administration consolidation of monthly financial information.
• Developed Enterprise Planning forms using Hyperion Enterprise Planning.
• Extracted data manually from different sources to combine different sources into one business report.
• Automated sources of data to minimize manual entry.
• Involved in Project Planning and Management meetings.
• Defined and developed Load rules (including Hierarchies), Functions, Report Scripts to perform cube build and data load.
• Optimized the cubes memory by changing Dense/Sparse configuration.
• Developed Hyperion Analyzer Reports and Views for online access by the Executives and Users.
• Combined VBA with Essbase to generate a powerful and flexible reporting system.
• Used Visual Basic Application Programming Interface to develop customized applications.
• Knowledge of other Hyperion products like HAL and HFM.

Environment: Hyperion Essbase 6.5.4, Hyperion Enterprise Planning 6.5.0, Hyperion HFM, Hyperion Interactive Reports 7.0, SQL Server 2000, Hyperion Analyzer 7.0, Windows XP.