Hyperion Essbase /Planning / DRM Consultant Resume Example Pittsburgh Public Schools

HYPERION ESSBASE /PLANNING / DRM CONSULTANT

Professional Summary

Over 7+ years of diverse experience in information technology with emphasis on Analysis, Finance & Planning, EPM and OLAP tools. Experience in design, analysis, architecture, development, implementation, reporting and administration for Hyperion Essbase, Hyperion Planning, Essbase Integration Services and Hyperion Reporting Modules on Windows, UNIX/Linux environments. Designed and developed numerous Essbase applications with excellent balance in dense and sparse dimensions, various OLAP models and meta-outlines across Block/Aggregate storage. Expertise in providing security for Planning and Essbase applications and ability to create user and group profiles for assigning proper privileges. Expertise in building Financial budgeting and Forecasting with OLAP Applications as Hyperion Planning using forms, business rules, menus and troubleshooting. Expertise in developing Business Rules and Calculation Scripts using Calculation Manager. Created and customized several financial reports using various tools of Hyperion like Hyperion Interactive Reporting Studio, Hyperion Financial Reporting Studio as per client requirements. Experience in working with Oracle Data Integrator (ODI). Experience in working with DRM, Classic and EPMA type of applications. Skilled in automation, optimization and performance tuning of Essbase applications. Expertise in metadata processing, upgrading, testing and migrating cubes in different environments. Expertise in dynamically building Dimensions, Attributes using rule files in Essbase Applications. Expertise in using Multiple sources for metadata / Data Load into Essbase Applications.

Skills

OLAP Tools
Hyperion Essbase 11.x/9.3.x, Hyperion Planning 11.x/9.3.x, Hyperion Shared Services 11.1.x/9.3.x, Excel spreadsheet Add - in, Hyperion System Smart view.
Reporting Tools
Hyperion Interactive Reporting, Financial Reporting (Reports), Web Analysis (Analyzer) and Smart View.
ETL
Oracle Data Integrator(ODI), HAL (Hyperion Application Link).
Database
Oracle 9i/10g/11g/12c, MS-Access, SQL Server 2005/2008, Sybase 11.2.3.
Programming Languages
XML, SQL, PL/SQL.
Testing - tools
Manual Testing, Win Runner, Load Runner, Quick - Test Professional, Test Director.
Operating Systems
Windows, Unix/Linux.

Work History

Hyperion Essbase /Planning / DRM Consultant, 09/2014 to Current
Pittsburgh Public Schools – Pittsburgh, PA

Worked on Detailed Design Documents with step by step instructions to develop an entire hierarchy for multiple currency EPM suite applications.
Created Properties, Property Definition and Property Category as per the requirement of ASO reporting application.
Worked on imports for one time build in DRM.
Further, Creating Hierarchies and version from the import file from stage Area.
Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Hyperion Planning, Essbase, Relational Database Management servers (including Oracle RDBMS, SQL Server, and IBM DB2), flat files (including CSV, Excel, & XML file formats), and web services (SOAP, WS-I Security).
Integrated ODI mappings and translations with Oracle Data Relationship Management (DRM) web services to support meta-data management approach to maintaining account and entity hierarchies.
Created the hierarchies using oracle DRM.
Created versions in DRM with different hierarchies and blended the data.
Export/Import data from DRM using the DRM migration modules.
Worked on custom exports as per the requirements by different target systems.
Automating the whole end-to-end process by using tool internal ability.
Implementing security using tool internal ability and external authentication in DRM.
Worked on standard exports and automating the process of export generation and transferring it to target systems to SQL tables.
Created .bat trigger file for FDM Mapping table results through send, receive or error encountered emails for "SQL Stored Procedure" to notify Hyperion Development and Admin Team.
Worked on Auto-Sys as part of refresh Scheduling.
Developed complex MDX formulas in income statement, balance sheet, debt analysis, cash flow and investment income moving data across different dimension members.
Masked Data in ASO reporting application for the OBIEE dashboard demo purpose.
Developed in ASO, BSO and Implemented Multi-Dimensional Database applications using Essbase.
Worked on performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
Developed Profitability Reports, which detail Unit Cost, Price and Volume Trends, and Expense Variances over prior periods.
Worked on using Outline Load Utility as well as ODI for loading metadata into planning.
Developed Report Scripts including user defined intersections dynamically.
Worked in development of MDX formulas in ASO reporting application.
Developed MAXL Scripts for Masking the ASO data.
Developed Business Rules to copy data from one version to another version using Run-time prompts.
Responsible for monitoring Application performance and tuning.
Worked as a team member in Hyperion ESSBASE & Planning App Migration from windows Prod to Exalytics.
Worked as a team member in Hyperion ESSBASE & Planning Implementation Involved in database, security refreshes in Planning.
Involved in Upgrading and Configuration of Hyperion products such as Planning, Essbase, and Reporting Studio.
Ensured that the dimension members and properties are updated in Planning Exalytics.
Environment: Hyperion 11.1.2.x/11.1.2.x, Hyperion Exalytics, DRM 2.4, Hyperion Planning, Oracle 11g, Oracle Data Integrator, MS-Excel 2010 Spreadsheet Add-In, Smart View, Oracle SQL Developer, Autosys.

Hyperion Essbase /Planning/FDM Consultant, 10/2013 to 08/2014
National Oilwell Varco – Houston, TX

Extensively involved in gathering business requirements during business meetings and translated them into project technical requirements.
Worked on Detailed Design Documents with step by step instructions to develop an application.
Involved in developing end to end process flows/Road Maps for the Projects/Release.
Developed various applications based on business requirements using Block Storage as well as Aggregate Storage Options.
Worked on various SHELL scripts for cube builds and data extracts as a part of Automation.
Developed Report Scripts including user defined intersections dynamically.
Worked on development and optimization of calculation scripts.
Responsible for monitoring Application performance and tuning.
Worked in development of MDX formulas in ASO applications.
Worked on performance tuning of BSO and ASO applications.
Worked on partitioning as a part of performance tuning.
Involved in supporting the Forecast model of the firm.
Build reports using different tools like Financial Reporting Studio, web Analysis and smartview.
Responsible for implementing LCM Utility to migrate application artifacts between different Environments.
Supported Administration issues on Hyperion Strategic Finance.
Involved in Disaster Recovery Test and responsible for documenting the process of DR Test.
Worked on developing report books using Financial Reporting Studio in both excel and pdf format.
Worked on performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation.
Worked on functional design documentation and specifications for the reporting modules.
Developed customer user-friendly reports and graphs self-contained in financialmodels.
Enhanced/modified existing financial reports as per changes in reporting requirements.
Developed Profitability Reports, which detail Unit Cost, Price and Volume Trends, and Expense Variances over prior periods.
Created custom calendars using Job Utilities menu to support the events and jobs scheduled to run the IR reports.
Worked on Auto-Sys as part of refresh Scheduling.
Worked on development and support of planning applications.
Developed different types of data forms for users to input the data into Essbase cube through Hyperion Planning.
Experienced in developing scripts using Business Rules Involved in debugging Business Rules from Calc Manager.
Responsible for developing Business Rules with run time prompts.
Created and Registered Planning Applications in Hyperion System Workspace.
Created applications including Capex and Workforce plan types of Planning.
Worked on using Outline Load Utility as well as ODI for loading metadata into planning.
Worked on various objects of Planning like Task Lists, Work Flow and Menu etc., Worked on Hyperion Shared Services for maintaining security to Essbase, Planning.
Extensively involved in Budgeting and Forecasting process.
Developed Task lists in order to complete the Budgeting process on time.
Installation and Configuration of the Development server consisting of Hyperion System 11 Essbase, Hyperion Planning, Hyperion Shared Services, Hyperion Application Link, Financial Reports, Web Analysis and Workspace.
Environment: Hyperion 11.1.1.x/11.1.2.x, Hyperion Strategic Finance, Hyperion Planning, Oracle 11g, Oracle Data Integrator, MS-Excel 2010 Spreadsheet Add-In, Smart View, Oracle SQL Developer, Auto-sys.

Hyperion Consultant, 12/2011 to 04/2013
Citi Bank – Bangalore

Developed and created Web forms for users to input the data into ESSBASE cube through Hyperion Planning.
Worked on Outline Load Utility of Hyperion Planning to load Meta data into planning application.
Worked extensively on Budget process and Budget Administrative tasks.
Involved in Migration of Hyperion Reports and Analyzer Report groups from one environment to another environment.
Created Complex and Dashboard reports using Interactive Reporting.
Used ESSBASE Integration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of ESSBASE Servers.
Worked as a team member in Hyperion ESSBASE & Planning Implementation.
Involved in database and security refreshes in Hyperion Planning.
Developed User-defined Reports using Web Analysis and Financial Reporting Studio.
Developed financial reports involving Budget Allocations, Retained Earnings, forecasting of profit and loss and the reported implied changes in balance sheets as well as cash flow statements.
Developed in ASO, BSO Implemented Multi-Dimensional Database applications using Essbase.
Developed outline for various cubes and Created filters depending on the user requirements.
Used MaxL in both Native and Shared services mode to load data in to the cubes.
Developed and Maintained Rule files, MaxL scripts, MDX scripts and Reports.
Developed and created Web forms for users to input the data into ESSBASE cube through Hyperion Planning.
Used Shared Services for activities such as filter creation, creation of users and creation of groups.
Created and scheduled Batch Jobs for complete automation processes for application refresh and backup.
Designed and created a security plan to manage security at the user and group layer, the global access layer and the server level.
Implemented various Optimization techniques to improve the performance of the cube.
Responsible for Performance Monitoring, Security, Backup and Recovery of the cube.
Worked closely with management and end-user to develop and enhance the application processes that will result in a stable productive environment.
Involved in documentation on all Hyperion Planning processes for all business groups and technical documentation on business rules and calc scripts.
Developed easily understandable training material.
Provided On Call support.
Environment: Hyperion Essbase 9.3, Hyperion Reports, Hyperion Planning 9.2, SQL, Hyperion Application Link (HAL), MS-Excel 2007 Spreadsheet Add-In, Windows NT 4.0, SQL Server 2003, MS SQL Server.

Hyperion Consultant, 09/2009 to 10/2011
Tesco Group – Bangalore

RESPONSIBILITIES: Analyzed and designed software and database solutions.
Created the structure of the model and cube in MS Analysis Services Involved in extracting the data using SSIS from OLTP to OLAP.
Created partition function, schema and file groups for fact tables.
Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
Wrote T-SQL code for creating cursor and handling the data validations.
Designed and implemented stored procedures and triggers for automating tasks.
Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
Created new XML tags in order to execute new business rules.
Created several lookup tables and updated couple of existing lookup tables.
Analyzed existing Forms on the system and uploaded those in to the new system.
Created several repeated blocks in order to same XML tags into different parts.
Environment: MS SQL Server 2005, SQL Server Reporting Services 2005, SSIS, Front Office 8.3 / 10.2 /10.3, Windows XP/ NT / 2000, MS Office 2003.

Resume Overview

Companies Worked For:

Pittsburgh Public Schools
National Oilwell Varco
Citi Bank
Tesco Group

Job Titles Held:

Hyperion Essbase /Planning / DRM Consultant
Hyperion Essbase /Planning/FDM Consultant
Hyperion Consultant

Hyperion Essbase /Planning / DRM Consultant Resume Example

Resume Score: 70%

DISCLAIMER

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes