We provide IT Staff Augmentation Services!

Hyperion Resume

Bannockburn, IL

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, EssbaseASO, and BSO,Planning,Financial Reporting,Essbase StudioandODI.
  • Worked with many ETL tools such asHAL, DIM, SSIS, ODI, SQL interface, FDMetc.
  • Very good experience on writingMember Formulas, Calc Scripts, BR’s, MDXfor calculations, allocations, aggregations etc.
  • Expertise inAutomations, Optimizations, Converting BSO to ASO, Database backups, Partitioning, ESSCMD, MAXL, MDX, VBscriptingetc.
  • 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 dayadministrative tasks.
  • Involved in managing the Hyperion security infrastructure by assigning proper privileges to users and groups, Scheduling daily batch processes usingCONTROL-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

Confidential Mar2012 –Present.
Bannockburn, IL.

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
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 Navigationfor 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

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 therepositorymodel with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
  • CreatedDimensional Hierarchyfor all Dimensions,Level based MeasuresandAggregate navigationin BMM layer.
  • Developed Dashboards/Reportsusing 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 usedGuided Navigationfor user friendly reports.
  • ImplementedColumn Level securityfor specific users who can access a part of the tool, like just answers and Dashboards.
  • Implemented Security by creating roles & web groups usingExternal tables Authentication.
  • Enhancedperformanceof 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, Beloit, WIAug’08 to Feb’10
Role: Hyperion Consultant

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

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

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.

Certifications

Hyperion Essbase Consultant.
Hyperion Planning Consultant

Hire Now