SUMMARY

• Over 8 years experience working with consolidation, budgeting and financial reporting applications.
• Extensive experience in design, analysis, development and implementation of various applications using Hyperion Essbase, Hyperion Planning 11.1.2.1, Essbase Integration Services (EIS), Hyperion Reporting, Hyperion Analyzer, Interactive Reporting, and Hyperion Planning using Windows XP/ 2003/2000/2008 and UNIX environments.
• Excellent experience in design, analysis, development and implementation of various applications in Client/Server environment using Hyperion Essbase 11x/9.X/7.X, Hyperion Web Analysis, ESSCMD, Maxl, Essbase Spreadsheet add - in, Essbase Query Designer.
• Strong Understanding of dense and sparse settings, performed dynamic calculations, developed, reviewed, and optimized report queries in Microsoft Excel, loaded data from various database to cubes.
• Proficient in writing Stored Procedures and Triggers in SQL and PL/SQL on Oracle/SQL Server databases.
• Implemented multiple Hyperion System 9 solution. Well experienced in analyzing source system and Star schemas to suit Essbase architecture.
• Expertise in optimizing Data Loads, Indexing, MDX formulas, Calculation Scripts and Cache Management.
• Meet with clients to understand business processes and to gather system requirements with subsequent application design and implementation using best practice implementation techniques.
• Good Knowledge of building Aggregate and Block Storagecubes via Oracle data integrator (ODI).
• Proficient in software documentation, technical report writing, decisive with strong leadership qualities, flexible in work schedules.
• Commendable Knowledge and experience in automation and Essbase cube designing, partitioning and optimization of report queries in Microsoft Excel.
• Thorough Knowledge of the SDLC and also the entire life cycle of Data warehouse design, development and implementation.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in work/project environment. Versatile team player with excellent analytical, presentation and inter-personal skills.

TECHNICAL SKILLS

Olap Tools: Hyperion System 11, Hyperion Essbase 11.x/9.x, Workspace, Smart View Excel Add-In, Essbase Integration Services 9.3.1/7.1, Essbase studio, ESSCMD, Essbase Administration Services, Hyperion Planning

Operating systems: Windows Server 2003 and 2008, Windows XP ProfessionalWindows 2000 Server/Professional

Databases: Essbase, Oracle 10g, SQL Server 2000/2005, and Microsoft Access.

Reporting Tools: Hyperion Reports, Hyperion Analyzer, Web Analysis, Financial Reporting Studio, Interactive Reporting.

Dimensional Modeling: Star Schema Modeling, Snowflake Modeling, Fact and Dimensional TablesPhysical and Logical data modeling, Erwin 6.0.

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Hyperion Planning and Essbase Application Tower Lead

Environment: Oracle Hyperion System 11.1.2.1, Oracle Enterprise Performance Management System, Oracle Data Integrator 10.1.3, Smart View,Hyperion Financial Management, Hyperion Financial Reports, Hyperion Enterprise, SAP BO KPI Dashboards, Data Staging application, Part Search tool, Team Track and Web Time sheet

Responsibilities:

• Handling new client enquiries and acting as the face of the business.
• Upgraded Hyperion System 9.3.3 to 11.1.2.1 and configured all the environments
• Migrated Essbase and Planning applications, Financial reports from Dev to Test, QA and Prod environments
• Full life cycle development with Hyperion Planning, in creating applications, managing the application security and system users
• Loaded the metadata into the Planning Applications using the Interfaces, Procedures, and Packages and ran preload Business Rules using Oracle Data Integrator
• Developed MaxL scripts and rules files to work with all database objects including outlines, formulas, caches, and security profiles; also designed calculation scripts, and batch files to automate data load and other maintenance procedures like outline modifications
• Application development using Hyperion Planning for Performance and Capacity Planning and creating Web Forms and Business Rules
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data
• Involved in the recruitment of new staff, mentoring and training up junior and new staff.
• Maintain appropriate levels of technical and procedural documentation, ensuring all administrative and IT records are entered and updated correctly.
• Share / spread knowledge throughout the Support Team and relevant areas, from development through to support

Confidential, Cincinnati, OH

Principal Consultant: Hyperion Planning/Essbase Analyst

Environment: HyperionEssbase 9.3.3, Hyperion Planning 9x,, Hyperion Financial reports, Hyperion Enterprise, Smart view, Web logic BEA, Excel Add-in, HFM, Web Analysis, Oracle Data Integrator (ODI), HAL, Web analysis.

Responsibilities:

• Involved in the installation and deployment of Oracle EPM 11.1 systems in the patch environment which included Shared Services, Essbase Hyperion Financial Management, Hyperion Planning and Web analysis, Financial Reports Hyperion Workspace and Oracle Data Integrator (ODI) and configured the installed products using EPM System Configurator
• Full life cycle development with Hyperion Planning, in creating applications, managing the application security and system users
• Loaded the metadata into the Planning Applications using the Interfaces, Procedures, and Packages using Oracle Data Integrator.
• Involved in the installation and deployment of Hyperion system 9 in the patch environment which included Hyperion Essbase, Hyperion Planning, Shared Services, Web analysis, Financial Reports, Hyperion Workspace, Hyperion Application Link and Oracle Data Integrator (ODI)
• Performed Optimization using Hour glass design technique, during Data Loads and while calculating members in the cube.
• Performed Performance tuning by using the dense/spares settings and developed the required alternate rollups for reports.
• Involved in writing calculation scripts, report scripts with developers with respect to BRD for Beginning Balance and Allocation of capital for different business segments among the members of the cube
• Developed Automation Scripts based on the members in the cube for adding or dropping the members.
• Developed Maxl Scripts, report scripts, calscripts, dimension builds for the cube
• Worked on HFR (Hyperion Financial Reports) for developing Income Statement, Balance Sheet, Contribution Margin, and Enterprise Wide Allocation Reports using multiple grid tools and with drill down to Account level Capabilities.
• Helped Power user with the usage of Essbase Excel Add-in and Smart View to perform Ad Hoc Analysis and Hyperion Workspace to navigate through the data.
• Used Hyperion Planning for Forecasting & Budgeting.
• Worked on ODI and followed step by step procedure to follow data loading.
• Worked on Work Force Planning and used same BSO cube with default dimensions of Planning.
• Create instances and data source for the planning application using configuration utility.
• Worked on ODI load data to planning application.
• Add and moved members in outline and refresh the planning.
• Performed tuning, Optimization using Hour glass design technique.
• Designed and created new server substitution variables thereby narrowing down the management of a single calc script for current and prior month/year.
• Applied system patches and service fixes to upgrade the system from 9.3.1 to 9.3.1.3 and to resolve the issues encountered by Hyperion system 9 bugs.

Confidential, Rochester, NY

Hyperion Essbase Developer

Environment: Hyperion Essbase 111.1.1.3(ASO & BSO), Oracle 10.2.0.4, Essbase Spreadsheet Add-In, Windows 2003, Hyperion Shared Services, Web Analysis, Essbase Integration Services, Hyperion Workforce Planning, Workspace and SmartView, WebLogic 9.2.3, IIS 6.0.

Responsibilities:

• Participated in Requirement analysis phase and gathered reports in several format, analyzed the reports to design a Hyperion Essbase Cube for Sales Analysis.
• Implemented rules for safe data loading from the back up files, and repopulated the new databases. Also utilized source files provided by the ETL tools to load into the new databases.
• Involved in defining data mart to support Hyperion Essbaseand created reports Financial reports and web Analysis.
• Designed and developed numerous complex Essbase applications with excellent balance of dense and sparse dimensions.
• Excellent understanding of different storage in Essbase and their usage. Created really large cubes using ASO options. Also, created BSO application to support Financial Budgeting and Forecasting.
• Developed and maintained Rule files, Calc Scripts (BSO), Maxl Scripts, MDX member formulas (ASO).
• Tested Data load rules, fixed errors from the error log files, resolved issues of data retrieve from Excel, Developed Excel reports using the advanced member selection techniques.
• Setting up MaxL scripts to batch outline updates, data loads, and Calc Scripts executions and automating hyperion load as well as reporting mechanics.

Confidential, New York City, NY

Hyperion Essbase Developer

Environment: Hyperion Essbase 9.3.1, Essbase Administration Services, Essbase Integration Services, Excel Add-In, BI+ applications, Web Analysis, Windows server 2003, Hyperion Financial Reports, Workforce Planning.

Responsibilities:

• As a team member of Essbase development, participate in gathering requirement and performing requirements analysis. Worked closely with DBA to create Star schemas to support Essbase Multidimensional database, defined the business dimension and created outline for the analysis.
• Involved in user testing and fixed the issue, interact with business users to understand the issue and troubleshoot and also migrated test environment to production environment.
• Developed Batch files and Rules files to upload data from financial system’s database to Essbase cube.
• Configured and maintained users from Microsoft Windows Active Directory (MSAD) by setting it up in Hyperion Shared Services.
• Involved in creating Rule files for multi-dimensional databases.
• Developed Data Loads and Calculations.
• Monitoring production runs for the daily drivers loading, monthly actual loading, dimension maintenance and the forecasting cycling processes.
• Maintained the currency and YTD/HTD/QTD/MTD and more of accounting information.
• Developed Analyzer OLAP views and sophisticated what-if scenarios for the end users.

Confidential, Delray Beach, FL

Hyperion Essbase Developer

Environment: Hyperion Essbase 7.1.2, Essbase Administration Services, Interactive Reporting/Brio, Essbase Integration Services, Excel Add-In, Windows server 2003.

Responsibilities:

• Acted as a liaison between the Essbase team and the financial team in which business ideas were modeled into working Essbase cubes for design and development.
• Analyzed the reports to design a Hyperion Essbase Cube for Counts Analysis. Developed Hyperion Essbase application for files tracking and helpdesk system
• Created complete Essbase database which included Developing Outline & Data load rules, calculation scripts, and Maxl Scripts for automated outline and data loading. Optimized Outline, Data load rules and Calculation Scripts
• Developed a multi-dimensional database (MDDB) application using Essbase that stored and maintained company's financial and marketing data and performed the loading and manipulation of data into the database using Load Rules files.
• Automated theEssbase CubesusingEsscmdand Batch Scripts.
• Optimization and performance tuning for Data Load/Calculations.
• Manipulated data columns to suite Dimension builds, Tested Data load rules, fixed errors from the error log files, resolved issues of data retrieve from Excel
• Maintained cubes and took regular backups.
• Provided technical guidance and support to end-users about by developing documentations required.

Confidential, Lake Success, NY

Essbase Developer

Environment: Essbase 6.5, Essbase 7.1.2, Essbase Administration Services, Essbase Integration Services, Excel Add-In, Windows server 2003, Interactive Reporting.

Responsibilities:

• Migrated Essbase cubes from 6.5 to 7.1, which includes Essbase outlines, rule files, calculation scripts.
• Coordinated with offshore team for Software Development Life Cycle (SDLC) to migrate the Planning applications, Hyperion Reports, Business Rules and other EssbaseObjects.
• Developed Essbase cubes for sales and marketing group at Confidential .
• Extracted data from SQL Server 2000 and perform data manipulation using DTS packages.
• Loaded data using SQL interface.
• Updated/ modified the existing Calc scripts, MaxL scripts, UDA’s, Load Rules and Attribute dimensions as per the requirements of the business analysts.
• Wrote calculation scripts member formulas to calculate Essbase database.
• Wrote Maxl to automate Essbase daily and weekly cube refresh.

Confidential, NY

Junior System Analyst

Environment: Essbase Spreadsheet Add-In, Windows 2003, Workspace and Smart View.

Responsibilities:

• Participated in Requirement analysis phase and gathered reports in several format, analyzed the reports to design a Hyperion Essbase Cube for Sales Analysis.
• Implemented rules for safe data loading from the back up files, and repopulated the new databases. Also utilized source files provided by the ETL tools to load into the new databases.
• Involved in defining data mart to support Hyperion Essbaseand created reports Financial reports and web Analysis.
• Designed and developed numerous complex Essbase applications with excellent balance of dense and sparse dimensions..
• Tested Data load rules, fixed errors from the error log files, resolved issues of data retrieve from Excel, Developed Excel reports using the advanced member selection techniques.
• Setting up MaxL scripts to batch outline updates, data loads, and Calc Scripts executions and automating Hyperion load as well as reporting mechanics.
• Performed efficient coding and effective calc scripts such as time-series calculations and variance reporting, forecasting and budget analysis. This resulted in better performance and round up time.
• Design SQL Data Transformation Services Package for data loads and SQL stored procedures for data mapping.
• Used Essbase Administration services to assign filters and wrote Maxl and esscmd scripts to perform Automation of cube building process which includes Building Outline, running load rule, running calculations scripts and partitioning.