Hyperion Senior Consutant

VINIT CHAWLA MOBILE: +91-704******* E-MAIL:*****.**********@*****.***

CAREER PRÉCIS

Total IT Experience of around 6.4 years, including 6 years of experience with Infrastructure, design, development and implementation of Hyperion Planning & Essbase applications.

Hyperion Essbase 11 Essentials Certification (2013)

Hyperion Planning 11 Essentials Certification (2011)

Red Hat Certified Engineer (2008)

Industrial training done with Hewlett Packard, Noida (Jan’ 2009 – May’ 2009) in Dot Net

Attended summer training with IIT Kharaghpur (2007)

Proficiency in implementing Hyperion Suite of products as well as support, maintenance & migration projects

Active involvement in pre-sales activities like preparing presentations, configuring POC/Demos etc.

Expertise in providing training and preparing training material for team members/Business Users

An effective communicator with excellent relationship building & interpersonal skills. Strong analytical, problem solving & organisational abilities.

TECHNICAL SKILLS

EPM Suite Hyperion Essbase

Hyperion Planning

Hyperion Shared Services

Hyperion Smart View

Excel Add-in

HFM

FDM

EPMA

OBIEE

Reporting Tools Hyperion Financial Reporting

ETL Tool Oracle Data Integrator (ODI)

Operating System Linux, Solaris, Windows

Language PL/SQL, SQL

RDBMS Oracle 10g, SQL SERVER

CAREER SCAN

Notable highlights:

Received Star Performance for outstanding performance in ADI Strategies

Winner of Thank You competition.

Received appreciation mails from clients for outstanding performance

Recipient of “Young Star” Excellence Award at Zensar Annual Function 2010.

Got “Spot Award” for outstanding performance in very first project at Zensar Technologies. Package Solution Consultant, IBM India – Oct 2014 till date 1. EPM 11.1.2.3 and 11.1.2.2.0 Support and Enhancement – Technologies – EPM 11.1.1.3 and 11.1.2.3.500

Project Profile:

Working as a Team Lead for Support team for Hyperion EPM System

Providing Status Reports of the Team Activities, Task Accomplishments and Issues to the Associated Business Owners and Managers & Ensure deliverables are prepared to satisfy the project requirements and schedule.

Initiate sub-teams as appropriate to resolve issues and perform tasks in parallel.

Involved in weekly service refresh and Co-ordination with server management team for server reboot quarterly

Created automation scripts for service refresh in both windows and Linux environments

Involved in to patches for EPM System for HFM, Essbase, planning, FDM, shared services etc.

Provided 24/7 Infrastructure technical supports to all business units for Complete EPM System

Automation and documentation for Hyperion Process Senior Consultant, ADI Strategies India – Feb 2012 till Oct 2014 2. EPM 11.1.2.3 Implementation –

Technologies – Hyperion Planning 11.1.2.3.500

Project Profile:

Requirement Gathering and Enhancement in Planning

Developing data forms and Business logics

Knowledge transfer and leading offshore team

Documentation

3. EPM 11.1.2.2 Installation & Planning Implementation of CAPEX Module: Technologies – Hyperion 11.1.2.2

Project Profile:

Installing and configuring of Hyperion system 11 on Prod and Dev environments.

Worked on Building of CAPEX and Revenue module

Designing and Creating Data Forms

Designing calculation logics and writing the rules.

Unit Testing of rules

Reports development using Hyperion Financial Reporting

Responsible for SIT, UAT and Provided Admin training to Client 4. EPM 11.1.2.3 Upgrade and Enhancement –

Technologies – Hyperion Planning upgrade from 11.1.1.4 to 11.1.2.3 Project Profile:

Installing and configuring of Hyperion system 11 on Prod, Dev and Test Server

Hyperion planning upgrade from 11.1.1.4 to 11.1.2.3.500

ODI upgrade from 10g to 11g

Requirement Gathering and Enhancement in Planning

Application conversion from Classic to EPMA

Tune applications, databases and calculation scripts to improve performance

Documentation and UAT

To conduct a basic as well as an advanced training program for the end users & management heads 5. EPM 11.1.2.3 Upgrade

Technologies – HFM/FDM upgrade from 9.3.1 to 11.1.2.3 Project Profile:

Installing and configuring of Hyperion system 11 on Prod and Dev Server

Technical Upgrade from HFM and FDM 9.3.1 to 11.1.2.3

To conduct an advanced training program for the IT Head

Documentation

6. EPM 11.1.2.3 Installation & Configuration Projects: Technologies – Hyperion 11.1.2.3

Project Profile:

Installing and configuring of Hyperion system 11 on Prod and Dev Server

Installed Shared Services, EPMA, Calc Manager, FR, Planning, Essbase and ODI.

Documentation

7. EPM 11.1.2.2 Reporting Development:

Technologies – Hyperion 11.1.2.2

Project Profile:

Development of Reports on Hyperion Financial Reporting 11.1.2.2

Developed over 30 Reports, like monthly P&L, BS etc

Development of Books

Scheduling of Books using batch Scheduler

8. EPM 11.1.2.2 Installation & Configuration Projects: Technologies – Hyperion 11.1.2.2

Project Profile:

Installing and configuring of Hyperion system 11 on Prod, Test, Dev environments.

Worked on over 25 Installations for Hyperion 11.1.2.2

Expertize is providing Architecture and Server sizing for Hyperion System

Hands on Experience on Installations of Informatica as well. 9. EPM 11.1.2.2 Essbase Implementation:

Technologies – Hyperion 11.1.2.2

Project Profile:

Installing and configuring of Hyperion system 11.1.2.2 on Production and Development environments.

Creating Essbase applications and data load using Rule Files

Automating the process of data load and backup using batch scripts

Designing and creating Ad-hoc reporting using Smart view 10. Trainings:

Technologies – OBIEE 11.1.1.6 and Informatica

Project Profile:

Installation and configuration of OBIEE and Informatica

Creating Repositories using Oracle BI Admin tool

Security with Oracle BI 11g

OBIEE and Essbase integration

11. EPM 11.1.2.2 Upgrade and migration:

Technologies – Hyperion 11.1.2.2 and 11.1.1.3

Project Profile:

Installing and configuring of Hyperion system 11 on Prod, Dev environments.

Migration of complete environment from 11.1.1.3

Support Analyst, Steria India - Oct 2011 till Jan 2012 12. Hyperion Support– British Telecom, UK

Technologies – Hyperion System 9 and 11

Project Profile:

Installing and configuring of Hyperion system 11 on Production environment.

Load balancing on Prod environment

Full time support of Hyperion Servers(around 100)

Maintaining monthly reports

Performing daily checks for Services and data backup

Migrating Prod applications (Essbase and Planning) to Dev and Cat environment for maintaining a sync between all the three environments.

Software Engineer, Zensar Technologies, Pune – Sep 2009 till Sep 2011 13. Retail Forecasting and Budgeting Demo: Zensar Technologies, India Technologies – Hyperion Planning

Project Profile:

Creating Planning Application and building Dimensions using Planning utility.

Designing Data forms (Single and composite) and creating the same in Planning Applications to capture complex logic.

Writing and unit testing of Business Rules.

Perform end to end System Testing.

14. Budgeting And Implementation – ALDAR

Technologies – Hyperion EPM 11.1.2 Planning

Project Profile:

Created Architecture design for EPM 11.1.2

Installation of EPM System 11.1.2 on a distributed environment comprising Solaris and Windows Operating System.

Documented the installation procedure and prerequisites.

Building Planning Applications, Loading the dimensions and Web forms creations.

Writing and unit testing of business rules

Created documents like user training and admin manuals

Providing user and admin trainings.

15. Hyperion Financials Upgrade – Fluke Corporation, USA Technologies – Hyperion Essbase System 9

Project Profile:

Building and unit testing of calculation scripts

Creation of automated centralized process by using Maxl scripts and Windows batch file.

Implemented security by way of complex Essbase filters & automated it.

Implemented the automated backup and Disaster Recovery Process

Tune applications, databases and calculation scripts to improve performance

Created documents like user training manual, security guide

Full time support for the Application.

16. Hyperion Platform Upgrade – Tektronix, USA

Technologies – Hyperion Essbase System 6.5, EPM 11.1.2.1 Project Profile:

Suggested Server sizing for Hyperion Development and Production servers

Architecture design for components in distributed environment each servers for Hyperion Installation

Installation and Configuration of Hyperion 11.1.2.1 on Development and Production environments on Windows 2003 Servers.

Migration of Applications from 6.5 to 11.1.2.1

Upgrade Data Loading process from Oracle Tables

Created documents for Hyperion Clients Installation. 17. EPM 11.1.2.1 Installation– Wyndham, USA

Technologies – Shared Services, Hyperion Planning, Essbase, FR, Web Analysis, ODI Project Profile:

Recommended Server sizing for Hyperion Production servers

Created EPM Architecture for Dev, Staging and Prod Environments.

Installation and Configuration of EPM 11.1.2.1 suite on all the environments

Creating Documentation and providing training to Client. 18. Budgeting And Implementation – Bajaj Allianz

Technologies – Hyperion EPM 11.1.2 Planning

Project Profile:

Architecture design for installing components on distributed environment for EPM 11.1.2

Oracle EPM System 11.1.2 installation and configuration on a distributed environment comprising Linux and Windows Operating System.

Documented the installation procedure and prerequisites.

Building the Applications & Loading the dimensions

Designing Package for loading data in Essbase using ODI 19. Migration Project - CamelBak

Technologies – Hyperion System 9

Project profile:

Hyperion 9.3.1 installation on a distributed environment comprising Linux and Windows Operating System.

Documented the installation procedure and prerequisites.

Migration of application from production environment to development.

Created documents like admin guide, security matrix, end user training kit 20. Budgeting And Implementation - Dexcom

Technologies – Hyperion EPM 11.1.1.3 Planning

Project profile:

Installed and Configured Oracle EPM System 11 on a distributed environment comprising Linux and Windows Operating System.

Documented the installation procedure and prerequisites.

Writing and unit testing of business rules

Migration of application from test environment to development and later to Production environment.

Creation of security matrix to mirror client’s complex security access requirement.

Creating and managing Planning users, groups utilizing Planning security components.

Assigning security as per security matrix.

21. Budgeting And Implementation – Zensar Technologies, India Technologies – Hyperion EPM 11.1.1.3 Planning

Role: Team Member

Project Profile:

Hyperion 11.1.1.3 installation on a distributed environment comprising Linux and Windows Operating Systems

Documented the Installation procedure and prerequisites.

Creating data forms (Single and composite) in Planning Application.

Design, develop and test Business Rules.

Implemented Security in the Planning System using Shared Services

Communication with Client on change requests, UAT, Sign offs Jan’09 – May’09: Hewlett Packard, Noida completed Industrial Training 22. Empower – HP, India

Technologies – VB.Net and SQL Server 2005

Project Profile:

Coding and testing of the module Merchandising

Created reports

Documented the complete process using UML diagrams ACADEMIC CREDENTIALS

MCA from Bharati Vidyapeeth University, Pune in 2009.

B.Sc. from Dr RML Awadh University, Faizabad in 2005. EXTRA CURRICULUM

Winner of Inter- College Table Tennis team championship.

Participated in Table Tennis zonal and state ranking championship.

Sports Co-ordinator in College.

PERSONAL VITAE

Date of Birth : 25th March 1984

Father’s Name : Mr. B.L. Chawla

Languages Known : English, Hindi & Punjabi

Marital Status : Married

Contact this candidate