Hyperion Planning & Essbase Consultant Resume New York, NY - Hire IT People

Professional summary

Over 5 years of experience in Hyperion applications using Hyperion Essbase, Essbase Administration Services, Hyperion Planning, Hyperion Financial Reporting, Smart View for Office, Hyperion Web Analysis, ESSCMD, MaxL and Essbase Excel Add-in.
Extensive experience in designing and developing OLAP cubes from a conceptual level.
Expertise in Calc scripts, MaxL, ESSCMD, Hyperion business rules, Dimension build rules, Partitioning, Data load rules and report scripts.
Functional knowledge of financial statements, budgeting, forecasting and planning processes that facilitate creation of powerful Hyperion solutions.
Versatile team player with excellent leadership and inter-personal skills.

Technical Skills:
OLAP and BI Tools: Hyperion Essbase 11.x/9.x/7.x/6.x, Hyperion Planning, EPMA, Essbase Integration Services (EIS), Essbase Studio, Workspace, Smart View for Office, MS Excel Add-In
Reporting Tools: Hyperion Financial Reporting (FR), Web Analysis and Hyperion Reports
Office Tools: MS Office Suite 2007/2003/2000
Languages: ESSCMD, MaxL, MDX, SQL, PL/SQL, C, C++, VB, Java
Databases: Oracle 11g/10g/9i/8i, MS SQL Server, MS Access, DB2
Operating Systems: Windows NT/2000 /XP/Server 2003, UNIX

Professional Experience

Confidential, USA New York, NYJuly 2010 to CurrentEnvironment: Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, EPMA 11.1.1.3,Hyperion, Shared Services 11.1.1.3, Workspace, Hyperion SmartView, Hyperion Financial Reports 11.1.1.3, MS SQL Server 2005, Windows XP
Role: Hyperion Planning & Essbase Consultant

Involved in requirement analysis and documentation leading to an effective Hyperion solution incorporating user needs of converting Excel based Budgeting and Forecasting Process to Hyperion Planning in-order to increase efficiency. Created business rules that replicate the functionality of complex formulas existing in excel. Developed Dynamic Web forms for various users with POVs and Pages. Designed the overall workflow of the budgeting and forecasting process with kick-off, reviews and approval states. Maintained and supported Hyperion Planning applications also implemented application security process, created users/groups, security profiles and application access to different groups using filters. Involved in scripting and automation of Essbase Commands using EssCMD and maxL. Created Aggregate Storage (ASO) application from the Block Storage (BSO) applications for executive level reporting.

Confidential, Teaneck, NJ August 2009 to June 2010
Environment: Hyperion Planning 11.1, EPMA, Essbase Administration Services (EAS),
Hyperion Shared Services, Hyperion Web Analysis, Hyperion SmartView,
Oracle Database 10g, Windows Server 2003, MS Excel 2003
Role: Hyperion Planning & Essbase Consultant

Gathered user requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations. Developed Rules file for Dimension Building and performed Metadata and Data loading. Developed business rules and 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 the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data. Created reports using Hyperion Web Analysis Studio and SmartView for monthly, quarterly and annual data. Created and maintained ASO/BSO cubes as per user requirements and performed 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.

Assisted the manager in creating and managing project schedules and plans (Cube build and calc script development, General Expense/Allocation model, Balance Sheet budgeting, P&L Budgeting, Workforce Planning and CapEx Planning)
Provided day to day functional support/system administration of the internal reporting systems that enable management/financial reporting and financial planning, via Hyperion Planning, and native Essbase Applications.

Confidential April 2006 to August 2008
Environment: Oracle 8i, Oracle Forms 6i, Reports 6i, Toad and Windows 2000/NT
Role: Oracle PL/SQL Developer

Designed, developed and supported financial and management cubes and reports.
Developed Rules file and perform Monthly loading of metadata and data.
Developed and implemented Dimensions and member Attributes.
Used Hyperion planning to create Planning Applications with Business rules and data forms.
Uploading metadata to Hyperion planning and data to Essbase.
Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.

Confidential May 2004 to March 2006

Environment: Oracle 7, SQL*Loader, UNIX

Role: Oracle PL/SQL Developer

Developed EIS OLAP Models and Meta outlines for the cube.
Restructured and redesigned previous Essbase cubes.
Extensively used MaxL, ESSCMDS for creating batch files for automation.
Created Hyperion Planning applications and data forms to replicate sample Excel Mock Up’s.
Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting using Hyperion Reports and Hyperion Analyzer.
Involved in defining requirements, functional specifications and designing.
Responsible for providing training to the end users.

EDUCATION:

MS Financial Engineering, Confidential Institute
MS Mathematics, Confidential University

We provide IT Staff Augmentation Services!

Hyperion Planning & Essbase Consultant Resume

New York, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship