Ajay singh chouhan Mobile: +919*********

Hyperion Consultant Email: acg4ne@r.postjobfree.com

Hyperion

Caresoft Inc. Bhopal (M.P) http://in.linkedin.com/pub/ajay-singh-chouhan/8a/225/a0/

PROFESSIONAL SUMMARY

Experience in Business Intelligence Application Hyperion Planning, Essbase,HFM, Financial Reporting, Rule

Development.

Distinctive achievements in Hyperion Application design, Analysis, Configuration and Implementation.

Expertise in Hyperion System 11.x, Hyperion Shared Service, Hyperion Workspace.

Substantial experience in Hyperion Essbase and Planning Application Creation, Data form Creation, building

dimensions, Business Rules.

Experienced in data loading through Free-Form Loading, Rules files

Strong Understanding on Business rules, Calculation scripts

Strong Understanding of Hyperion Planning Budget Process.

Expertise in Writing UAT Scripts

Expertise in creations of Hyperion Essbase application by Block Storage

Experienced in Performance tuning on applications, dense/sparse settings, backups etc.

Experience in Installation, Configuration and Migration of Hyperion System 9.x/11.x./11.1.2.1/11.1.2.2./11.1.2.3

Expertise in Installation and Configuration of OBIEE version 11.1.1.7

Skill Summary

Relevant Products and Tools: Hyperion System 11.x,, Hyperion Essbase, Hyperion Planning, Hyperion

Financial Management, Hyperion Smart View, Hyperion Workspace, Hyperion

Shared Services, Data Konnector, Hyperion Financial Reporting studio,OBIEE,

MS Excel, MSWord.

Databases: Essbase 11X

Operating Systems: Windows Family

Education

B.E (Computer Science), 2013

Rajiv Gandhi Technical University, (Bhopal), (Madhya Pradesh).

Work Experience

AM Resorts Aug’13-current

Hyperion Consultant

About the project and my role in it: AM

Resorts is a resort management company that is part of The Apple Leisure Group, largest vertically integrated travel and

resort company in North America. AM Resorts provides sales and marketing to fourteen resort properties with

approximately 4,000 rooms throughout the Caribbean and Mexico, employs 6,000 employees and has more than $1

billion in assets under its management. We are implementing HFM and Hyperion Planning for AM Resorts. Creating and

customizing various dimensions, I have defined the framework of handling the exchange rates, data loading procedures,,

and manage the metadata and rule File. I implemented Actual, Budget Scenarios; I have been generating most intricate

analytical reports for the client through Hyperion.

Responsibilities:

Developed Multi-Dimensional database (MDDB) application using Essbase 9.3.0, 11.1.2.1.

Hyperion Essbase 9.3.1(Development, Admin, Presales), Smart View For office, Spread sheet add-in, Hyperion

reporting, Business Objects 9.0/9.1/11i/11.1.

Created Web Forms in Hyperion planning for business users to load the Forecast, Actual and Budget data.

Creating user, groups & Give the user providing in Shared services

Enhanced various calc- scripts as well as business rules.

Created Calc Scripts using the Calc Script editor for performing calculation and Maintain outline member formulas as

business requirement changes.

Worked on the performance tuning (Cube Optimization) of the Applications for the fast data loads, better calculation

times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulas and Calc

scripts.

Installing & Configuring Oracle Hyperion 9.3.0 and 11.1.2.1

Creating Web forms in Hyperion Planning for Dos and Controller to load the forecast and Budget Data to

generate the Sales, Expense and Weekly Forecast report in Hyperion

Work Experience

Work Experience

Holiday Retirement Feb’14-April’14

Hyperion Consultant

About the project and my role in it: Holiday

Retirement is the nation’s leading and the largest provider of Independent Retirement Living. It is a robust family of more

than 300 senior living communities providing seniors a safe, carefree, all-inclusive independent retirement lifestyle.

Holiday Retirement is planning to upgrade the following Hyperion EPM products from 9.3.3 to 11.1.2.2

• Hyperion Shared Services

• Hyperion Planning

• Hyperion Essbase

• Hyperion Reporting and Analysis (Financial Reporting)

Holiday Retirement has been using services of Oracle’s EPM System, to meet many of its financial analysis

requirements’. The current version of EPM System used at Holiday Retirement is 9.3.3, which is causing performance

issues. Hence, to continue to garner the benefits of new version of EPM systems, Holiday Retirement is in the process of

upgrading its Hyperion environment from Version 9.3.3 to Version 11.1.2.2.

Responsibilities:

• Migrate the User Security and Configure MSAD.

• Migrate the Cubes of Essbase, Rule file, Substitution Variable, Filters and Calc Script.

• Upgraded the Hyperion Planning Apps

• Prepare a Financial Reporting Connection

• Migrate Window batch for automatic task for exporting data and service start

Arysta Life science Sep’14-current

Hyperion Consultant

About the project and my role in it:

Arysta Life Science is focused on helping our customers cultivate business growth through the development, marketing

and distribution of innovative, high-quality chemical solutions for today’s dynamic agro science and health & nutrition

science marketplace. More than three-quarters of our entire organization is directly involved in bringing new products to

market, from our supply chain specialists, to our development and registration teams, to our more than 1,700 sales and

marketing representatives working with growers, there financial data is managed with the help of Hyperion Essbase and

we are providing them support with their Monthly Closing.

Responsibilities:

Work on updating calculation scripts and Substitution Variables in Essbase

Involved in Monthly Closing of Arysta

Work on updating the outline changes in Essbase as per user request

Maintenance and backup of Essbase Cube

Created Windows Batch scripts for automation

Extensively used MaxL scripts to run calculation scripts

Date : -

Place :- ( Ajay Singh Chouhan)

Contact this candidate