SUMMARY

• Over 12 years of experience in Administration, implementation, support and performance tuning of Hyperion System 9 and Release 11 applications.
• Experience of over 100 Hyperion upgrades and implementations.
• Excellent Hyperion troubleshooting skills.
• Experience setting up Hyperion for customers with global high availability needs.
• Extensive experience of integrating Hyperion with 3rd party tools.
• Extensive experience in performance tuning HFM consolidations, Essbase calculations.
• Strong experience of working with Finance users and explaining technicalities in simple English.
• Strong experience of writing Essbase calculations, writing Maxl scripts.
• Strong experience with Management Ledger applications on HPCM.
• Strong experience of Hyperion Smartview.
• In - depth knowledge of relational databases: Cursors, Triggers, Stored Procedures, SQLPL/SQL.
• Exceptional knowledge in designing the Hyperion infrastructure architecture and providing an ptimum solution.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• ITIL certified.
• Worked on multiple ticketing tools like BMC Remedy.
• Strong analytical and problem-solving skills.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Hyperion Architect

Responsibilities:

• Serving as an Independent consultant.
• Served as a technical consultant to facilitate migration from On Prem to PBCS.
• Migration of Hyperion 11.1.2.2 to 11.1.2.4
• Conversion of FDM to FDMEE (11.1.2.2 to 11.1.2.4)
• Performance tuning of Hyperion applications at the application levels.
• Set up automations using EPM automate.
• Worked on converting Standard to Management Ledger in HPCM module.
• Worked with EPMA applications including HFM, Planning and Essbase.
• Worked with FDMEE, FCM and PBCS.
• Working on creating DRM application to potential replace EPMA
• Preparing for the 11.2 upgrade stated to come out in Sep’19.
• Designing and conducting Disaster Recovery drills.
• Setting up ETL processes via ODI/FDMEE.

Confidential, Frisco, TX

Sr. EPM Consultant

Responsibilities:

• Managing and supporting multiple EPM environments.
• Setting up cloud solutions using Google cloud, Azure and AWS for customers having across the globe Hyperion environment.
• Architecting High availability, high performance Hyperion environment on Linux/Windows servers.
• Ensuring timely delivery of Hyperion projects and support.
• Performance tuning of Hyperion applications via app/web servers Weblogic, OHS and IIS level.
• Performance tuning of Hyperion applications at the application levels.
• Setting up SSL connections across entire Hyperion stack.
• Troubleshooting issues related to Workspace, HFM, Planning, Essbase, FCM, DRM, FDMEE, Smartview from v11.1.1.3 till 11.1.2.4.
• Working with Oracle on potential bugs and known issues.
• Setting up load balanced, OHS deployment ODI agent/environment.
• Setting up third party tool like Dodeca or log parsers.
• Regularly researching on Hyperion patches and applying them.
• Extensive performance tuning of HFM and Essbase applications.
• Building and migrating SSIS data load solutions for Essbase dimension build and customer load.
• Helping customer troubleshoot functional aspects of Essbase, Planning and HFM applications.
• Building new EPM solutions for different customers.
• Designing disaster recovery procedures.
• Working with new tools to enhance productivity of Hyperion applications.
• Implementing custom solutions for different EPM needs on a global scale.
• Designing disaster recovery procedures.

Confidential, Plano, TX

Sr. Hyperion Consultant / EPM Lead / EPM Project Manager

Responsibilities:

• Managed all day-to- day technical aspects of Global Hyperion environments: Technical Support, End-User Support, Environment Optimization, Product Updates/Patching, Utilities, and Application Copies/Backups.
• Performed backups of the all the Hyperion products, Planning, HFM, Essbase, Shared services, and Reporting Server. Worked with LCM, traditional utilities for backups.
• Worked with business to provide Financial models in a timely manner.
• Acted as primary and secondary Hyperion production support engineer.
• Installation and Configuration of various environments, ranging from version 9 till 11.1.2.4, including Essbase, HFM, Planning, FDM, HSF, Reporting products, DRM, ODI.
• Performance tuning of various Hyperion products and versions.
• Migrating HPCM Standard app from Prod to Non-Prod environments.
• Upgraded multiple customers successfully from version 9 to 11.1.2.1.
• Upgraded multiple customers successfully from 11.1.2.1 to 11.1.2.3/4.
• Created/Updated EIS models/meta outlines.
• Created SQL scripts and batch processes for Finance cubes.
• Worked on automation of application processes using ODI scenarios and MAXL.
• Automated the data load process by using ESSCMD and Maxl Scripts.
• Worked on enhancing Planning application to incorporate effect of exchange rate in profits.
• Worked on implement Disaster Recovery strategies depending on the customer needs.
• Installed and configured active passive clustering for Hyperion v11.1.2.1 - v11.1.2.4.
• Worked with the Presales team to respond to RFPs, preparing cost models for implementation and post implementation needs.
• Migrated Hyperion planning, HFM applications from different environment using LCM.
• Provided training to end users in Smartview to load data and the basic concepts of multidimensional databases.
• Wrote daily back up script for Hyperion Essbase applications.
• Supported Essbase on AS400.
• Worked strongly in accordance to ITIL principles.
• Worked in configuring high availability environment, except Essbase.
• Worked on various RDBMS, application and web servers.
• Worked in setting up of environment with SSL needs.
• Worked in supporting and setting up of DTS/SSIS packages.

Confidential, Wixom, MI

Hyperion Implementer/Trainer

Responsibilities:

• Worked as a contractor, travelling to various customer site.
• Managed various upgrade and implementation projects for Hyperion products.
• Installation, configuration and implementation of Hyperion products on Windows 2003/ 2000 server.
• Installation, configurations of Essbase (7.0/9.2), Hyperion Planning (4.0/9.2), Hyperion Financial Management (HFM 9.2) Financial Reporting (v7.2/9.2), Financial Data Quality Management (FDM) Shared Services, License server and EAS.
• Installation and configuration of HAL 9.2, Planning and Essbase and other set of adaptors.
• Migrating Hyperion Planning Applications, Business Rules and Hyperion Reports from one server to another.
• Maintaining FDM security.
• Developing FDM scripts for Reporting.
• Upgrading Hyperion Planning in Pre system 9 and post system 9 environments.
• Designed FDM workflow user interface to load Actuals from General Ledger to Hyperion.
• Assigned security for newly deployed and migrated reports in new version.
• Maintained security through Shared services (9.2)
• Involved in upgrade of Hyperion Enterprise from 5.1.3 to 6.1.4.
• Upgrading HAL Projects from version 7.0 to 9.2.
• Installed and Configured Hyperion Financial Management 4.0
• Created New Business Rules in Hyperion Planning 4.0
• Production Support for Essbase on applications and databases
• Data Loading and Reconciliation of Databases
• Upgraded Essbase 6.5.1 to Essbase 7.1.2
• Migrated Essbase Cubes and Security Files from 6.5.1 to 7.1.2
• Configured EAS 7.1.2 on SQL Server 2000.
• Maintenance of the existing Upstream (FDM) scripts to load data in HFM.