Sign in

Hyperion EPM suite of products

Naperville, Illinois, United States
August 28, 2017

Contact this candidate




Over 12+ years of solid experience in Design, Analysis, Implementation, Administration and Infrastructure maintenance and upgrade of Hyperion EPM Suite of Products includes but not limited to Hyperion Essbase, Hyperion Planning, Essbase Integration Service(EIS), Essbase Studio, Oracle Data Integrator(ODI), ERP Integrator, Hyperion Financial Management (HFM), Financial Close Management (FCM), Accounts Reconciliation manager (ARM), Financial Data Quality Management(FDM), FDMEE, DRM, HSF, Financial Reporting(FR), Interactive Reporting(IR), Excel Add-in and Smart View and have exposure on OBIEE.

Having strong experience in installation and configuration in clustered and High Available Environments and applying patches for the entire Hyperion EPM suite of products in Exalytics, Linux, UNIX AIX and Windows environments.

Having strong Experience on Hyperion System 11 upgrades and end to end processes update

Experience in upgrading FCM, ARM and SOA in distributed environment

Exposed to the Entire Software Development Life Cycle from Requirement Study to Development, implementation and Change Management.

Have a good understanding of finance and accounting concepts and experience with supporting periodic close, planning, budgeting, and forecasting processes.

Experience in both BSO and ASO applications of Essbase.

Strong Understanding of Dense and Sparse strategy dimension allocation, performed dynamic calculations, developed, reviewed, and optimized report queries.

Proficient in building Standard and Attribute Dimensions dynamically using dimension build methods such as Generation References, Level References and Parent-Child Method.

Well experienced in EPMA, Planning Application implementation from end to end includes architecture, designing the metadata, building and loading data.

Having strong experience in Metadata build and Data load through Essbase Rules files, ODI and FDM.

Data Validations using Smartview.

Expertise in writing Essbase calculation scripts, Load Rules, Report Script and Business Rules.

Expertise in Maintain HFM Consolidation Rules, metadata and application performance

Expertise in automation process by developing Essbase MaxL Scripts, ODI Scenarios, Task Flows, FR batches, LCM backups, batch Scripts and Shell Scripting

Expertise in developing and Administration of Financial Reports and Interactive Reports.

Strong knowledge and expertise in Database Optimization with Dimension Building, Data Loading, Indexing, Cache Management and Partitions.

Strong experience in implementing Hyperion Essbase security, dimension level and Shared services security for planning, Security Classes in HFM and Reports level Access.

Code Migration and release management activities for entire Hyperion EPM suite of Products across SDLC

Assist support teams on resolving data flow issues between Oracle ERP systems to Hyperion systems and other interface failures

Install and Configure Oracle Data Integrator(ODI), Creating Master and work repositories, creating Physical and Logical Schemas, Updating Contexts and Registering Source and Target systems through workspace

Integrate metadata and data from a PeopleSoft and Oracle Enterprise Resource Planning (ERP) source system into an Enterprise Performance Management (EPM) target applications

Having good experience in troubleshooting issues and interacting with customers and all other support teams.

Maintain and Support an open source stack of applications – Nagios, Mantis, MySQL, Control Tier, apache, Keepass, openSSL, openLDAP, PHP, Perl

Extensively worked with offshore teams for development and post production support and involved round the clock.

Flexibility to work off hours and weekends as business needs dictate

Communicate, update and analyze schedule information to project team and customer representatives.

Identify and define project risks, and communicate to project team and customer representatives.

Annual Database Password changes for all Hyperion schema

Automated the daily backup scripts and service restarts using init scripts in windows and Unix environments

Automated the scripts for WebLogic accounts passwords change procedure for jdbc connections


Operating Systems:

Windows, UNIX IBM AIX,Linux and Exalytics

Oracle ExaData Database Machine


Oracle Hyperion Essbase, Planning, Essbase Integration Service, Essbase Studio, Oracle Data Integrator(ODI), ERP Integrator, Hyperion Financial Management (HFM),FCM, FDM, FDMEE, Financial Reporting, Interactive Reporting, Excel Addin and Smart view, WebCenter, PeopleSoft FS, EPM,PHIRE, LMS, HRPC and Open Source stack of Applications


Energy Provider, Transportation, Banking, Finance and Media


Oracle, MYSQL, MS SQL Server, MS-Access

Application Server

WebSphere, Tomcat

Web Server

IIS, Apache, WebLogic

Programming Languages

C, Visual Basic, Unix Shell Scripting


Exelon Corporation, Chicago IL

Hyperion/EPM Consultant February 2016 – Present

As a Hyperion/EPM Consultant, responsible for

Technical Design, Analysis, Development, Administration, Production Support and Infrastructure maintenance for the applications using EPM Suite of products includes but not limited to Hyperion Essbase, Planning, Financial Reporting, Interactive Reporting, HFM, FCM, ARM, SOA, FDMEE, DRM and HSF.

Hyperion EPM upgrade on Exalytics and end to end processes update.

Own entire Hyperion Infrastructure maintenance and data refresh processes for all Hyperion Applications

Involved in dynamically building Dimensions, Attributes using rule files and loading Fact data for Essbase Applications by means of several build methods such as Generation, level or parent-child references.

Involved in performance tuning and optimizations for data/dimension loads, database restructuring (BSO/ASO), calculations, overall Essbase performance

Developed MaxL scripts and rules files to work with all database objects including outlines, formulas, caches, and security profiles, also designed calculation scripts, and created shell scripts to automate data load and other maintenance procedures like outline modifications

Performed the optimization and performance tuning for Reporting and analysis (RA) and other EPM Applications during EPM upgrade and during performance testing cycle.

Coordinated Hyperion Server move and Database server move activities.

Worked with Oracle Customer Engineering & Advocacy Lab (CEAL) team for best practices

Created Unix shell scripts for Daily Backups and custom restart scripts

Involved in the Application monitoring processes update in Nagios and other C&I monitoring tools

Developed/Maintained Hyperion Planning applications, Planning data forms, Business rules and other artifacts

Maintained HFM Consolidation Rules, metadata and application performance

Performed Code Migration and release management activities for Hyperion Essbase, Planning, IR, FR, HFM, FCM, ARM, FDMEE, Informatica and other EPM Products across SDLC

Have Understanding of SOA & WebLogic architecture

Applied the required patches for Hyperion Applications as and when needed

Involved Disaster Recovery process update for entire suite of Hyperion products

On Demand build and configuration of new environments

Troubleshoot issues/performance/errors – Coordinate with other teams when needed(I&O, DBA)

Fix security issues when detected

Applied SSL certificates when required

Maintain and Support an open source stack of applications – Nagios, Mantis, MySQL, Control Tier, apache, Keepass, openSSL, openLDAP, PHP, Perl

Verification & Validation of applications in scope after OS and DB Patches

Weekly Infrastructure Changes review, analyze the impact and Coordinate schedules for outages between various teams ( functional support, I&O, DBA, project teams) and communicate with Business Users/Support teams before and after the activity completions

Verify SOX rules on access and migration approvals

Work closely with SOX compliance teams auditing Hyperion systems and processes.

Maintain/Administer all maintenance and project environments

Environment refresh across SDLC for all applications

Tech support for PeopleSoft Finance and EPM, Exelon LMS (Learning Management system) and open source stack of applications

Password change processes for all the applications for every quarter/year as per the Exelon Policies and automated WebLogic password change process for EPM Applications

Troubleshooting, production maintenance and administration support

Supporting the junior/Offshore members within the team to ensure they are delivering the day-to-day BAU Requests/Incidents within Hyperion EPM Products that is being requested from the Business

Performing in-depth Root Cause Analysis (RCA) into application/system issues

Offshore/Onshore Coordination and handshake calls between support/internal teams

Help the manager in prioritization of effort to resolve the most critical tickets as per business requirements

Environment: EPM and Suite (HFM, FDMEE, Essbase, planning, Reporting...etc.), Exalytics, Windows server 2008R2 servers for DRM and HSF, Oracle Database, MySQL, MS SQL Server, IIS, Weblogic, Oracle ExaData Database Machine, PeopleSoft Financial, EPM, PHIRE, HRPC and other open source stack of applications, dSeries scheduler (CA product tool)

GE Transportation, Erie, PA

Hyperion Infra SME March 2014 – February 2016

As a Hyperion Infra SME, responsible for

Installed, Configured and upgraded Hyperion Suite of Products/applications: HFM, FDM, FDMEE, Essbase, Planning, EIS, Essbase Studio, ODI, DRM, Financial and Interactive Reporting..etc. from to across all the environments

Own entire Hyperion Infrastructure and end to end processes

Own entire data refresh process for Hyperion Applications

Essbase and Planning applications Metadata refresh using EIS, Essbase Studio and ODI Interfaces and Data Load through rule files

Maintained/Enhanced Key processes like DRM exports, HFM hierarchy Load with the DRM exports, HFM Data Load through FDM and HFM Consolidation

Monitor Daily, Monthly and Quarterly Finance Close refreshes for all Hyperion applications which runs on Appworx Scheduler and Data validations using Smartview

Assist Functional and Technical teams during month-end and quarter-end close periods

End to end support for Essbase, Planning, DRM, FDM and HFM applications and coordination with other teams like ERP, Informatica, database teams during Hyperion refresh issues and other changes.

Upgraded Accelatis for Hyperion applications monitoring with respective to Hyperion Upgrade

Worked on Disaster Recovery and Interface control testing as per the SOX compliance

Work closely with SOX compliance teams auditing Hyperion systems and processes

Instruct support teams on resolving data flow issues between Oracle ERP systems to Hyperion systems

Manage User Security for all Hyperion applications, Financial and Interactive Reports

Migrated Hyperion EPM Applications from Windows Environment (EPM to Exalytics Solaris environment (EPM including all the scripts and other processes

Converted Windows batch files to Shell scripting

Environment: Microsoft windows 2008 R2, Oracle 11g, EPM Suite, IIS, Weblogic and Exalytics, EPM Suite, Oracle ERP Source system, ExaData Database machine and Appworx scheduler

CITI Group, Warren, NJ

Technical Lead June 2009 – March 2014

Project: GFTS BI and Essbase

The Global Function Technology Services (GFTS) provides comprehensive Database Architecture, Development and Administration support for Hyperion Essbase and Planning applications. GFTS services facilitate the implementation and maintenance of production database environments for new and existing applications in high available 24 x 7 environments. Main scope of the project is Production outages, User support, Enhancements, maintenance and processing, testing, Infrastructure Support, SME(subject matter Expert) Support

As a Technical Lead, responsible for

Installed EPM suite and configured HSS, Essbase, Planning, EIS, FR, ODI 11g and Web Logic 11g on high availability servers

Migrated EPM Essbase and Planning Applications to EPM and setup end to end processes

Installed, Configured Oracle Data Integrator(ODI) and create/configure Master and work repositories, Physical and Logical Schemas, Updating Contexts and Registered Source and Target systems through workspace

Involved in Integrating metadata and data from a PeopleSoft Enterprise Resource Planning (ERP) source system into an Enterprise Performance Management (EPM) target application(Planning) through ERP Integrator and ODI

Exposure on configuring the planning applications with data rules for extraction from the GL source system to ERP Integrator, Enabling Drill Through in Reports via Financial reporting studio and Viewing Data Source Details from Financial Reporting Reports, Drill through from the EPM target Planning application and view data in the PeopleSoft ERP source system and Write-back budget data to the source system from Oracle Hyperion Planning application

Having strong experience in Metadata build and Data load through Essbase Rules files, ODI and ERP Integrator

Responsible for Daily, Month end, Quarterly and yearly Rollovers for Essbase and Planning Applications

Created new batch jobs and scheduled batch files for complete automation process for data refresh, data backup and database backups

Migrated HSS, Financial Reports, ODI, Essbase and Planning applications across SDLC.

Experienced with creation and maintenance of numerous applications with excellent balance of dimensions, developing various OLAP Models & Meta-Outlines across Block Storage (BSO) and Aggregate Storage (ASO) Essbase kernels

Involved in Hyperion applications performance analysis and optimization (Hyperion configuration settings, outline optimization, Essbase cache management, and Java applications memory management).

Implemented Hyperion Database and Security Administration tasks (applications configuration, patching, backup, recovery, and process automation) using Hyperion Shared Services, Hyperion Lifecycle Management, Hyperion Workspace, and Essbase Administration Services

Experienced in Design, develop and maintain Hyperion Planning forms, business rules, and security and in performing Hyperion Planning Administration tasks

Resolved Prod and Non-Prod issues by working with Oracle Corporation’s Hyperion support technicians.

Should have an understanding of finance and accounting concepts and experience with supporting periodic close, planning, budgeting, and forecasting processes.

Created project documents to include all processes to be performed by support teams for references and end user documentation

Production outages, User support, maintenance and processing, Infrastructure Support

Involved in regular Client interaction/Calls to identify the issues, change requests, enhancements and provided best of technical solutions.

Environment: AIX, LINUX, Hyperion system 6.x, 7.x, 9.x and 11.x {Essbase ESSCMD, MaxL, Excel Add-in, Application Manager (Outline Editor, Report Editor, Calc Script Editor, and Data Prep Editor), OLAP Server, Analytic Services, Hyperion Planning, Shared Services, Essbase Integration Service, Financial Reporting, Smartview, ODI and ERP Integrator}, AutoSys Scheduler and PeopleSoft ERP source system

Fox Interactive Media, CA

Hyperion Consultant April 2008 – May 2009

A division of News Corporation, FIM is portfolio of leading social networking, entertainment, sports and information sites that offer a platform and tools for consumers to express them, communicate with each other, and engage with media. FIM Financial Department is planning to implement Hyperion Financial Management for the effective financial reporting.

As a Hyperion Consultant, responsible for

End user support during Finance Forecasting phases in corporate for smooth turn around.

Creating and Optimizing Planning Cubes and involved in the full life cycle.

Creation and maintenance of data forms in Hyperion Planning 9.3.1

Creating and maintaining Corporate financial Reports using Financial Reporting Studio

Creating and editing corporate Business Rules/Calc scripts using AAS in Hyperion System


Adding and editing dimension members in EPMA using Hyperion Workspace 9.3.1

Created and executed data loads using H.A.L in System 9.3.1

Security Maintenance and updates using Shared Services in system 9.3.1

Maintenance and security filtering on data forms in Hyperion Planning.

Running Reports and Batches using Workspace

Modifying and editing the outline in AAS (Analytic Administrative Services) 9.3.1

Attaching Business Rules to Data Forms and performing Tests to ensure proper execution of

Business Rules

Performed regular Data retrieval tasks to test data load and aggregations.

Metadata Changes and updates in the outline and planning.

Involved in implementation, testing, production rollout, documentation, and on-going Maintenance

Environment: Hyperion System 9.3.1, AAS 9.3.1, Hyperion Planning 9.3.1, Financial Reporting 9.3.1, Shared Services 9.3.1, System 9 Workspace, Essbase Excel Add-In, Smart View, H.A.L, Windows NT 4.0/2000

Cymer Inc, San Diego, CA

Hyperion Consultant Jan 2007 – March 2008

As a Hyperion Consultant, responsible for

Installed Hyperion License Server, Hyperion Shared Services, Analytic Services, Analytic Administration Services, Planning, Financial Reporting, Web Analysis, Interactive Reporting, Smart View Provider, and Hyperion Application Link 7.0.

Prepared all the installation documentation on the above installed components.

Provided technical knowledge transfer regarding the installation to the IT support staff.

Created application and dimensions for cubes as per user requirements.

Migrated Hyperion Planning applications, for the very first from development server environment to production server environment.

Analyzed the best practice on Hyperion Backup procedure and recommended the list of things missing for better backup procedure during regular server maintenance.

Created test cases and demo and verified the backup procedure for approval.

Prepared the Documentations on Backup of Analytic Services data, Shared services security mode, Planning, Reporting and analysis.

Created Maxl Scripts which were used to automate the database import from the SQL server.

Troubleshoot all Hyperion related issues in client and server environment

Environment: Hyperion System (Analytic Services, AAS, Financial Reporting, Web Analysis, Smart View Provider), Hyperion Planning, Hyperion Application Link 7.0, Windows Server 2003, MS SQL Server 2005.

UMB Bank, Kansas City, Missouri

Hyperion Developer Nov 2005 – Dec 2006

As a Hyperion Developer, responsible for

Provided Hyperion Solutions for the clients.

Executed Data Migration from financial sources to Hyperion Essbase database.

Extensively used Hyperion Essbase 7.1.2 to create and modify outlines to meet the client's business requirements.

Performed Dynamic Dimension Building and Data Loading using Rules Files.

Created transparent, linked, and replicated partitions to improve the scalability, reliability, and performance of databases.

Created Excel-sheet reports for clients through Essbase Excel Add-In.

Customized retrieval on Excel sheets through efficient use of Essbase Query Designer.

Developed and manipulated Calculation Scripts to improve Essbase database performance.

Defined ESSCMD and MaxL automation backboned by OLAP Server to run batch scripts for backups.

Performed Essbase Optimization Tuning and administered Cache Management.

Professionally responded to demands and deadlines in a positive manner

Environment: Hyperion System 7.1.2 (Essbase, Analyzer, Essbase Excel-Add-in), Windows 20003 Server

Global Hyatt Corporation, Chicago, Illinois

Hyperion Developer Dec 2004 – Oct 2005

As a Hyperion Developer, responsible for

Support to customer during production cycles which includes resolving the issues with the submission and retrieval process especially to help the users to move the new account under Measure dimension to make the balance sheet balance on Asset and Liabilities side.

Coordinating the data submission process with the SMEs located in Asia Pacific and LAAM Region

Changing the substitution variables and UDAs on a monthly basis

Impact analysis and testing of the prioritized and approved enhancement list for the application

Creating reports as per the user's requirement

Adding members to the outline based on the user's requirement

Creating calc script for calculations on data in the cubes

Performed comparative analysis of ad-hoc reports and standard reports through Hyperion Analyzer.

Created and modified Dynamic Dimensions and optimal Data Loading.

Executed Calculation Scripts and maintained Essbase optimization tuning.

Administered user groups and privileges in Essbase.

Developed and maintained automation for all data flowing into and out of the Hyperion Essbase cube architecture using ESSCMD.

Preformed troubleshooting, diagnoses, and solve all Hyperion Essbase related issues.

Assisted end-users through direct communication and documentation.

Environment: Hyperion System 7.1.2 (Essbase, Analyzer, Essbase Excel-Add-in), Windows 20003 Server

Contact this candidate