SUMMARY

• Oracle Hyperion Planning 11 Certified Implementation Specialist
• Oracle Hyperion expert with over 8 years of IT experience including 7+ years in administration, design, analysis, development, migrations, installations and implementation of BI solutions using Essbase 11.x/9.x/7.x, Planning 11.x/9.x, Financial Reporting, EPMA, ESSCMD, MaxL, Smart View, Essbase Excel Add - In on Windows environments
• Experience with full Enterprise Software Project Lifecycle from initiation through requirements, analysis, design, development, testing, deployment and administration (support and maintenance).
• Expertise in writing Calc Scripts, Report Scripts and Load rules.
• Extensive Knowledge of ESSCMD, MaxL scripts, Member Formulas and Essbase Analytic Services.
• Strong experience on Essbase Cube analysis, design and development, Essbase database administration and performed Upgrades, Maintenance, Database backups, Performance tuning, Optimization of BSO/ASO Cubes, Dense/Sparse settings, Partitioning etc.
• Proficient in using LCM Utility to migrate Hyperion applications
• Extensive experience in building Financial Budgeting & Forecasting, Contribution Margin, Sales, profit margin, variance calculations, exchange rate calculation application with Hyperion Planning (Forms, Security, Meta Data Maintenance, Business Rules and Essbase Excel Add-In), and Reports.
• Having extensive experience in integrating Business Analysis, Multi-Dimensional Modeling using Hyperion Essbase, creating, manipulating and maintaining calculation scripts (Calc Scripts) using Planning, Business Rules and creating reports using Hyperion Reports to halp financial facilities and other business logics in an organization.
• Executed data migration between different Hyperion applications.
• Created templates and ad-hoc reports using Excel Add-in, Smart view for budget and forecast analysis
• Managing security, permissions, users and groups, controlling access to database cells through creating, copying and assigning filters.
• Creating innovative solutions to automate processes.
• Monitoring and support Hyperion Essbase Business Intelligence applications and batch load processes to ensure teh highest level of system availability.
• Experienced in developing Data warehouse/Data Marts, Star Schema, Snowflake Schema
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Created user training manuals, documentation and provided training to teh end users on Hyperion tools.
• Excellent interpersonal, presentation and communication skills with teh ability to work in a team and a stand-alone environment.
• Acted as a liaison between offshore and on-shore team.

TECHNICAL SKILLS

OLAP and BI Tools: Oracle Hyperion Planning 11.x/9.x, Oracle Hyperion Essbase 11.x/9.x/7.x, Essbase Administration Services (EAS), EPMA, Essbase Integration Services (EIS),Workspace, Smartview for Office, MS Excel Add-in, Essbase query designer

Reporting Tools: Financial Reporting, Spreadsheet Add-In, Smart view, Interactive Reporting, Web Analysis

Languages: MaxL, MDX, ESSCMD, SQL, PL/SQL, C, C++, Shell Script

Client Tools: MS Office Suite 2013,2010, 2007, 2003, 2000.

Modeling Tool: Star Schema, Dimension and Fact tables, Logical and Physical Modeling.

Databases: Oracle 11g/10g/9i, MS SQL Server (2003, 2005,2008,2012), MS Access

O.S.: Windows N.T /2000/XP/Server 2003/Server 2008/Server 2012

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Hyperion Planning/Essbase Consultant

Responsibilities:

• Participated in defining requirements from teh end user, functional specifications, design documentations and test strategies.
• Upgraded teh system 11.1.2.4
• Developed Planning application in Hyperion System 11.1.2.3
• Installation of teh Hyperion product, Configuring Hyperion Essbase and Planning, Essbase integration services for teh end users.
• Created schema/user for teh Hyperion database and managed teh Hyperion servers.
• Designed and developed Planning application facilitating Budgeting and forecasting.
• Involved in creating teh load utility files for teh dimension member loading and teh data loading into teh application.
• Created web forms for teh user inputs which were tuned by creating teh attribute and substitution variables.
• Designed, developed and implemented teh planning and reporting system for teh financial department.
• Created classic planning applications using Workspace.
• Created and managed numerous Business Rules and Member formulas for application.
• Developed Data Load and MaxL scripts. Created data load files for loading client and department data. Also MaxL scripts were created to automate teh same.
• Created Shell Scripts for automation of data load
• Designed currency conversion Rule to facilitate reporting in more TEMPthan one currency.
• Provided training to end users in using teh MS Excel spreadsheet add-in and Web forms to enter data.
• Involved in user access provisioning and teh security filter on teh system. Assigned accesses and privileges to various end users in different planning applications using Shared Services.
• Responsible for developing Financial & Management Reports using Hyperion Financial Reporting Studio and Hyperion Smart-View.
• Design Operating and CIP Budget Book using Hyperion Financial Reporting Studio.
• Build teh financial reports for various end-users based on Program, Department and Project.
• Used different functionality of FR as Conditional Suppression, Conditional Formatting.
• Validate metadata and data using Hyperion Smart-View.
• Responsible to keep teh structure of teh Report folders in sync in different environments for teh report migration purpose.
• Developed reports in Excel using Smartview function: HsGetValue.
• Created Reports with Multiple Database Connections.
• Used teh Conditional Suppression functionality to suppress teh rows/columns to display dynamically based on Prompts, User POV & grid POV.
• Developed Books from teh Financial Reports and documented all financial reports.
• Involved in teh Automation of teh Reports to run in PDF, HTML formats.
• Publish and Test all teh reports in Hyperion Workspace.
• Responsible for solving teh reports issues related to tool with teh halp of Hyperion tech support
• Assign teh security permissions and provisions to teh Reports in Hyperion Workspace.
• Maintain security by creating, managing, and assigning provisions to teh users in teh shared services.
• Act as a Liaison between teh tech team and teh business users to promote teh financial reports from teh development to production environment.

Environment: Oracle Planning 11.1.2.3 /11.1.2.4, Oracle Essbase 11.1.2.3/11.1.2.4, Essbase Administration Services (EAS), Oracle Financial Reporting, Shared Services, Oracle Database 11g, Windows Server 2008/2012, Windows XP, MS Excel 2010/2013.

Confidential, Farmington, CT

Sr. Hyperion Planning/Essbase Consultant

Responsibilities:

• Upgraded system from 9.3.3 to 11.1.2.2.
• Designed and developed Essbase applications with excellent balance of dense and sparse dimensions, arranged in a hourglass Model.
• Maintenance of user security and troubleshooting user access issues as they arise.
• Developed data forms, task lists, calculation scripts, and menu lists for teh users to enable them to enter financial data into teh system.
• Created business rules dat replicate teh functionality of complex formulas existing in excel.
• Created Aggregate Storage (ASO) application from teh Block Storage (BSO) applications for executive level reporting.
• Responsible for developing Financial & Management Reports using Hyperion Financial Reporting Studio and Hyperion Smart-View.
• Design Year to year, Current LRF V/S FCST Comparison, Current LRF V/S Budget Comparison, and Current LRF V/S Prior LRF Comparison using Hyperion Financial Reporting Studio.
• Validate metadata and data using Hyperion Smart-View.
• Created Reports with Multiple Database Connections.
• Used teh Conditional Suppression functionality to suppress teh rows/columns to display dynamically based on Prompts, User POV & grid POV.
• Developed Books from teh Financial Reports.
• Documented all financial reports.
• Involved in teh Automation of teh Reports to run in PDF, HTML formats.
• Publish and Test all teh reports in Hyperion Workspace.
• Created Smart view Reports such as Revenue, Current LRF and Prior LRF, 2 Year actual V/S 3 year LRF Comparison.
• Created Lock & Send Template for users to submit teh data to system.
• Actively involved in User Acceptance Testing (UAT) and training.
• Assign teh security permissions and provisions to teh Reports in Hyperion Workspace.
• Maintain security by creating, managing, and assigning provisions to teh users in teh shared services.
• Act as a Liaison between teh tech team and teh business users to promote teh financial reports from teh development to production environment.

Environment: Hyperion Planning 9.3.3/11.1.2.2, Hyperion Essbase 9.3.3/11.1.2.2, EPMA, Shared Services, Hyperion Financial Reporting 11.1.2.2, Workspace, Oracle Database 10g, Windows Server 2008, MS Excel 2010.

Confidential, Wilmington, DE

Sr. Hyperion Planning/Essbase Consultant

Responsibilities:

• Gatheird user requirements and then transformed them into Dimensions and members.
• Optimized Aggregate Storage Option and Block Storage Option outline.
• Developed Rules file for Dimension Building and Data Loading.
• Created reports using Hyperion Financial Reports & Hyperion Smart view.
• Designed and developed web forms as per teh business requirements using Hyperion Planning.
• Developed Calc scripts to derive complex calculations such as cash cost per user, YTD commitment, variance, capital expenditure forecast and budgeted cash flow statements.
• Developed web forms using Hyperion Planning web client for teh users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Performed performance tuning and database optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning etc. and optimization of Calc scripts and tuning of Calc cache.
• Designed Task lists for planning applications.
• Created Hyperion Security by creating Users, Groups and Filters for Analytic Services and Hyperion Reports.
• Redesigned currency conversion scripts to facilitate reporting in more TEMPthan one currency.
• Lead teh Hyperion training program at teh company aimed at providing initial overview of Planning features to teh power users and navigating teh application
• Providing technical guidance and support to end-users by developing appropriate documentation

Environment: Hyperion Planning 11.1.1.3, Hyperion Essbase 11.1.1.3, Essbase Administration Services (EAS), Hyperion Financial data Management (FDM), Shared Services, Oracle Database 10g, Windows Server 2003, Windows XP, MS Excel 2008.

Confidential, Atlanta, GA

Sr. Hyperion Planning/Essbase Consultant

Responsibilities:

• Created web forms for teh user inputs which were tuned by creating teh attribute and substitution variables.
• Designed, developed and implemented teh planning and reporting system for teh financial department.
• Created classic planning applications using Workspace
• Restructured ASO cubes as a part of optimizing ASO applications to bring down runtime and database size considerably.
• Changed Compression Dimension and used TB properties to enhance performance.
• Involved in teh creating Filters and assigning filters to users in Essbase for ASO Cubes.
• Extensively involved in performing DBA activities like performance tuning teh Calculations scripts, database tuning, and taking teh Essbase backups and maintenance of previous Essbase cubes.
• Created Budgeting and Forecasting applications using Hyperion Planning for teh Finance department
• Identified planning metadata requirements and loaded metadata
• Extensively involved in creating web forms and business rules
• Worked on financial reporting and build various reports using Prompts, User POV, Grid POV, Conditional Suppression, Conditional Formatting, and used formula in it according to teh recipe provided by users.
• Worked on creating Smart view reports. Build complex Smart view reports which had complex formulas, display sheet used to pull data from various other sheet which were for data retrieval or for complex formulas. An input sheet was provided for reducing teh effort for user to change teh month and year in each cell, halping reducing teh error caused by them in changing and providing fast and accurate reports.
• Changed solve order in ASO Cube for easier maintenance and support two pass calculation accordingly.
• Updated ASO cubes to sync with new changes in production, Performed unit testing and bug fixing.
• Assisted migration of cubes from staging to production servers.
• Documented all changes made to teh ASO cube as a reference for teh end users and for easier maintenance.

Environment: Hyperion Planning 9.3.1, Hyperion Essbase 9.3.1 Essbase Administration Services (EAS),Shared Services, Hyperion Financial Reporting 9.3.1, Oracle Database 10g, Windows Server 2003, MS Excel 2003.

Confidential, Denver, CO

Hyperion Essbase/Planning Consultant

Responsibilities:

• Participated in business requirements gathering & determining teh project scope.
• Developed & support appropriate programs & system documentation according to teh established IT standards.
• Developed complex formulas and Calc scripts reflecting teh business users requirements on teh Cube
• Created Rule Files for loading teh data and for building teh Dimensions dynamically.
• Used various types of Calculations such as Dynamic Calc, Two-Pass Calc, and Intelligent Calc for Application outlines.
• In EPMA loaded all dimensions from Ads files, built teh App & deployed it to planning.
• Migrated planning applications from development to production environment.
• Created teh workflow in Accounts with smart list “Approved”, “Rejected”
• Developed Web forms, Menus, Task lists, financial reports in ROI project.
• Extensively worked with Shared services in provisioning access permissions to users for planning, Essbase & FR reports. Created required users and roups in teh Native directory.
• Developed reporting cube & created transparent partitions to Budfcst cubes for reports.
• Created reports to compare QTD, YTD data of different years.
• Collecting teh new requirements/enhancements from teh users and make changes.
• Worked on teh validation of Reports & data.
• Developed financial reports using Prompts, User POV and Grid POV.
• Used different functionality of FR as Conditional Suppression, Conditional Formatting.
• Developed Ad hoc reports in Excel using Smartview.
• Created Reports with Multiple Database Connections.
• Created alternate hierarchies in EPMA for reporting & deployed teh applications.
• Developed Books from teh Financial Reports

Environment: Hyperion Planning 9.3.1, Hyperion Essbase 9.3.1, EPMA, Essbase Administration Services (EAS),Shared Services, Hyperion Financial Reporting 9.3.1,, Oracle Database 10g, Windows Server 2003, MS Excel 2008.

Confidential, Cincinnati, OH

Hyperion Essbase/Planning Consultant

Responsibilities:

• Analyzed user requirements and involved in teh process of finalizing dimensions for cubes.
• Extensively involved in designing and modifying teh outlines for Essbase Cubes Optimized Aggregate Storage Option and Block Storage Option outline.
• Developed Rules file for Dimension Building and Data Loading.
• Created reports using Hyperion Financial Reports & Hyperion Smartview.
• Designed and developed web forms as per teh business requirements using Hyperion Planning.
• Extracted data manually from different sources to combine different sources into one business report.
• Developed Calc scripts to derive complex calculations such as cash cost per user, YTD commitment, variance, capital expenditure forecast and budgeted cash flow statements.
• Developed web forms using Hyperion Planning web client for teh users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Performed performance tuning and database optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning etc. and optimization of Calc scripts and tuning of Calc cache.
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
• Developed web forms using Hyperion Planning for users to input data.
• Designed Task lists for planning applications.
• Created Hyperion Security by creating Users, Groups and Filters for Analytic Services and Hyperion Reports.
• Worked on month-end procedures on Essbase cubes for Expense, Budget, Metrics, etc. related tasks and reporting.

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 9.2, Oracle 9.2, Hyperion Smartview, Workspace, Windows NT, Oracle 10g.

Confidential

Hyperion Essbase Developer

Responsibilities:

• Coordinated with Client and Business Analyst to understand and develop an Optimized Cube.
• Designed teh environment and flow of teh business for teh company setting up teh overall architecture.
• Developed Block Storage Cubes (B.S.O) cubes
• Developed load rules for dimension build and data load.
• Created various filters as per user requirements in EAS
• Retrieve reports using Excel add-in and generate reports in Hyperion Reports.
• Involved in dynamic dimension building and modifying outlines.
• Developed batch scripts for automating teh dynamic dimension builds and data loads.
• Assured optimal match between cube design and report specifications.
• Optimized dense and sparse database settings for improving retrieval times.
• Responsible for granting users access based on their specific needs and assigned them to specific groups.

Environment: Hyperion System 9 BI+ Analytic Services 9.2.0.2, Hyperion System 9 BI+ 9.2.0.2, Hyperion Financial Reporting 9.2, Hyperion Shared Services 9.2, Hyperion Smartview, Workspace, Windows NT, Oracle 10g.