Hyperion Consultant
Resume:
Ajay singh chouhan Mobile: +919*********
Hyperion Consultant Email: *************@*****.***
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