HYPERION ORACLE CERTIFIED

Christian Too

Phone: 813-***-****

Email: ac66dd@r.postjobfree.com

SUMMARY:

8+years of experience as Hyperion Consultant with extensive experience in OLAP software systems design and implementation.

Experienced in all phases of SDLC like analysing the business requirements, developing the application using industry best practices, deploying into different environments (production, test and development).

Involved in Hyperion Financial Reporting.

Analyzed, designed, developed, and implemented applications using Essbase 11.x/9.x, Planning 11.x/9.x, Hyperion Financial Reports, HFM, Essbase Studio, and Essbase Spreadsheet Add-In, & Smart view

Experience in DRM (Data Relationship Management)

Extensive experience in FDMEE (Financial Data Quality Management Enterprise Edition).

Expertise in using Smart View to analyse data and create ad hoc reports.

Extensively worked on data extraction, transformation and loading from various sources like Oracle, SQL Server, DB2, COBOL and Flat files.

Experience in diverse ERPS such as PeopleSoft, EBS/eEBS/Fusion and JD Edwards.

Experience in ETL and reports development in Informatica, SQL Server, SSIS (SSIS 2012 & 2016).

Hands on experience of dense and sparse settings, performed dynamic calculations, developed, reviewed, and optimized report queries in Microsoft Excel, loaded data from various database to cubes.

Expertise in design, development, performance tuning, and optimization of Essbase databases. Well versed in Essbase architecture, Calculation Scripts, Business Rules, Aggregate Storage Option (ASO), Block Storage Option (BSO), MDX Member calculations, ESSCMD, MaxL for batch scripting, and shell scripting.

Proficient in software documentation, technical report writing, knowledge transfer, and possess strong leadership qualities along with communication and interpersonal skills.

Sound understanding of Essbase security feature with experience in creating user/group profiles, and assigning proper privileges using native security, and shared services mode.

Extensively worked on Dimension building, Data Loading, Database Optimization, Database backups, Dense/Sparse settings.

Experienced in Calc scripts, Report scripts, MaxL, and ESSCMD

TECHNICAL SKILLS:

Multidimensional Database

Hyperion Essbase 11.x/9.x

EPM Tools

Hyperion Planning 11.x/9.x, Studio, Hyperion Profitability and Cost Management (version 11.1.2.4),

Reporting Tools

Hyperion Financial Reporting 11.x/9.x, Web Analysis, Hyperion System 9 Smart View 11.x/9.x

Hyperion Scripts

Calc Scripts, Report Scripts, MaxL, MDX and ESSCMD

Programming Language

Java, PL/SQL

Web Technologies

HTML, DHTML, XML, CSS, Java Script

Operating Systems

Windows, UNIX

Databases

Oracle 9i/10g/11g, SQL Server 2008, Teradata

GUI Tools

TOAD, SQL Developer, VMWARE, MS-VISIO

WORK EXPERIENCE:

Hyperion Financial Reports Consultant Dec 2017 to April 2018

ATCO Energy, Edmonton, Alberta Canada

Responsibilities

Developed reports using Hyperion Financial Reporting studio

Provided technical support and advice on the definition and strategy of best practices of development Hyperion Financial reports for the client

Involved in documentation of the Hyperion Financial Reports, design document and test Approach Documents

Ensuring data access security to the correct roles and service accounts.

Experience in loading metadata into Essbase application using outline load command lines utility.

Developed reports using Hyperion Fusion cloud for EBS (Enterprise Business suite)

Gathered requirements for building of reports from business users and senior management.

Used Web Analysis, Financial Reporting and Interactive reporting to prepare quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.

Hyperion Consultant Jan 2016 to Nov 2016

Change Healthcare, Nashville, TN

Responsibilities

Designed BSO application and ASO application as per the reporting requirement of the company.

Provided technical support and advice on the definition and strategy of best practices of development EPM Hyperion for the client

Involved in analysis, development, implementation, documentation of Functional requirements forHyperion Planning ESSBASE, ODI, OBIEE and Financial Reporting implementations

Designed Rules Filesfor the purpose of loading data from flat files to the dimensions in outline using several build/load methods such as generation, level and parent-child references.

Utilized FDMEE to integrate Hyperion to source system.

Designed, developed and implemented Analytics solutions using Tableau and Power BI

Responsible to build Data Mart using Informatica PowerCenter.

Used Informatica PowerCenter to develop ETL mappings involving medium to complex logic using various power centre transformations such as Source Qualifier, Expression, Filter, Aggregator, Sorter, Java transformation, Router, Update Strategy, Sequence Generator, Look up and Joiner.

As a part of team developed the Essbase outlines, member formulas, and data load rules for the Essbase Applications.

Analyzed and documented client requirements and developed/implemented customizations for Hyperion Planning and Forecasting Application.

Used DRM (Data Relationship Management) to manage organization’s metadata.

Experience in loading metadata into Essbase application using outline load command lines utility.

Involved in Hyperion Profitability, and Cost Management EPM implementation.

Used MaxL in an interactive and batch mode to load data files and automate Essbase operations.

Developed and maintained rules files, calc scripts, MaxL scripts and reports.

Ensuring data access security to the correct roles and service accounts.

Developed and customized Data Forms in Hyperion Essbase for users to input forecast, working data, and accounting changes, and other variance data.

Developed load rules for loading data files and for dimension build and implemented data-access security and user management. Developed Calc Scripts to calculate various Metrics for the outline.

Designed and created a security plan to manage security at the user and group layer, including global access layer and the server level.

Involved in troubleshooting and production support.

Developed several ad-hoc reports using Smart view.

Involved in performance tuning to minimize data load and calculation time using the dense/sparse settings and developed the required alternate roll ups for reports.

Sr. Hyperion Consultant Aug 2014 to Dec 2015

Zions Bank, Salt Lake City, UT

Responsibilities:

Designed BSO application and ASO application as per the reporting requirement of the company.

Provided technical support and advice on the definition and strategy of best practices of development EPM Hyperion for the client

Involved in analysis, development, implementation, documentation of Functional requirements forHyperion Planning ESSBASE, ODI, OBIEE and Financial Reporting implementations

Designed Rules Filesfor the purpose of loading data from flat files to the dimensions in outline using several build/load methods such as generation, level and parent-child references.

Ensuring data access security to the correct roles and service accounts.

Designed, developed and implemented Analytics solutions using Tableau and Power BI

Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected and unconnected Lookups, Filter, Router, Sequence Generator, Sorter, Joiner, and Update Strategy

Provided technical support and advice on the definition and strategy of best practices of development EPM Hyperion for the client

Involved in analysis, development, implementation, documentation of Functional requirements forHyperion Planning ESSBASE, ODI, OBIEE and Financial Reporting implementations

Involved in UAT/SIT testing

Used DRM (Data Relationship Management) to manage organization’s metadata.

Designed Data forms/Web forms, Menus and Smart lists to allow users to key in the data for the drivers that business requires, also attached business rules with these data forms to calculate several accounts.

Utilized FDMEE to integrate Hyperion to source system.

Involved in Hyperion Profitability, and Cost Management EPM implementation.

Designed a replicated partition to transfer a portion of data from one cube to another, which significantly increase the performance for the excel-retrievals.

Created MaxL and batch scripts to automate process of updating cubes daily.

Supported existing P&L application (consisting of Balance Sheet, Consolidated and Workforce databases)to plan several employee related expenses like salaries, bonuses, vacation days, vacant and filled positions, report Net income, Net Sales, Profit and Loss etc.

Hyperion Planning/Essbase Consultant Jul 2013 – Aug 2014

JP Morgan Chase, Austin, TX

Responsibilities:

Involved in design and development of two cubes, one for budgeting and planning and the other for customer analysis.

Led design, build and tuning of all Hyperion objects according to business requirements

Involved in analysis, development, implementation, documentation of Functional requirements for

Hyperion Planning ESSBASE, ODI, OBIEE and Financial Reporting implementations

Developed both ASO and BSO applications depending on the requirement of the application.

Used SQL Server Integration Services (SSIS 2012) for integration services

Creating and modifying Hyperion Planning Web forms.

Designed, developed and implemented Analytics solutions using Tableau and Power BI

Used DRM (Data Relationship Management) to manage organization’s metadata.

As a part of team developed the Essbase outlines, member formulas, and data load rules for the Planning Application.

Utilized FDMEE to integrate Hyperion to source system.

Experience in loading metadata into planning application using outline load command lines utility.

Used MaxL in an interactive and batch mode to load data files and automate Essbase operations.

Developed and maintained rules files, calc scripts, MaxL scripts and reports.

Developed the necessary calculation scripts to calculate complex values, such as acquisition cost, gross margin/inventory turnover, revenue/payroll hr, total head count, and return on assets, properties, plants, and equipment, cash cost per user and YTD commitment and variance.

Hyperion Consultant Jun2012- Jul2013

Nationwide Mutual Insurance, Columbus, OH

Responsibilities:

Designed and developed new Essbase cubes for corporate reporting framework using both Aggregate storage (ASO) and Block Storage (BSO) cube as per the requirement.

EPM Hyperion Full cycle implementation.

Involved in Hyperion Profitability, and Cost Management EPM implementation.

Worked with Essbase and Teradata, which included metadata changes, revising data forms and creating Balance Sheet schedules. Loaded data through Essbase and created and resolved any mapping kick outs.

Used DRM (Data Relationship Management) to manage organization’s metadata.

Developed and customized Data Forms in Hyperion Essbase for users to input forecast, working data, and accounting changes, and other variance data.

Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.

Developed load rules for loading data files and for dimension build and implemented data-access security and user management. Developed Calc Scripts to calculate various Metrics for the outline.

Developed application to create reports for income statements, balance sheets, key metrics, operating and admin expenses, consolidation, corporate P&L, Functional P&L and Revenue for different markets.

Loaded actual data into Hyperion Essbase to drive actuals, forecast and budget numbers.

Utilized FDMEE to integrate Hyperion to source system.

Hyperion Consultant Feb 2011- May 2012

Verizon Wireless, Irving, TX

Responsibilities:

Designed and developed Essbase cubes for corporate reporting framework using both Aggregate storage (ASO) and Block Storage (BSO) cube as per the user requirement.

Developed and customized Data Forms in Hyperion planning for users to input forecast, working data, accounting changes and other variance data.

Involved in end to end Hyperion Profitability, and Cost Management EPM implementation.

Used DRM (Data Relationship Management) to manage organization’s metadata.

Participated in gathering business and functional requirements details during business meetings and translated them into program specification documents.

Developed load rules for loading data files and for dimension build and implemented data-access security and user management.

Prepared ETL design document and deployment documents.

Utilized Informatica PowerCenter for ETL

Used complex queries and stored procedures to create reports.

Created and maintained the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and adding users to the groups.

Wrote calculation scripts and business rules to perform allocations based on different drivers.

Involved in database and security refreshes in Hyperion Planning.

Participated in optimization of the cube by analysing and modifying various aspects such as dense/sparse configuration, modifying member storage properties etc.

Utilized FDMEE to integrate Hyperion to source system.

Participated in the planning and execution of integration test, system test, and user acceptance test activities, including developing and documenting test plans. Involved in documentation on all Hyperion Planning processes for all business groups and technical documentation on business rules and calc scripts

Hyperion Consultant July 2009 – Feb 2011

United States Steel Corporation, Pittsburgh, PA

Responsibilities:

Built metadata using outline load utility and developed load rules to load data into the application.

EPM Hyperion Full cycle implementation.

Used DRM (Data Relationship Management) to manage organization’s metadata.

Wrote SQL scripts for retrieving the data.

Involved in gathering business requirements.

Worked with different sources such as Oracle, MS SQL Server, flat files and others. Import data from various Sources, transformed and loaded into Data Warehouse Targets using informatica.

Designed the Planning Process using the Hyperion Planning Workflow.

Developed Reports using Financial Reporting against both Essbase and Planning data sources.

Created input control mappings to validate the flat files being sourced from Mainframes using Power Exchange Navigator

Wrote SQL queries and stored procedures to query the database and create reports

Utilized FDMEE to integrate Hyperion to source system.

Developed the security matrix and security model for Shared Services provisioning in consultation with the client.

Developed Reports using Financial Reporting against both Essbase and Planning data sources.

EDUCATION & SKILLS:

Western Governors University – MBA

University of Great Falls - Bachelor of Science

Hyperion Oracle Certified

Contact this candidate