SUMMARY

• Oracle Essbase 11 and Oracle Hyperion Planning 11 Certified Implementation Specialist with 4.7+Years of experience in Business Intelligence/Analytics/ EPM with major focus on design, development, implementation and Maintenance of Hyperion Essbase and Hyperion Planning Applications (v11.1.x).
• Successfully involved in 3 full cycle implementation and Experience insupport/Maintenance of UAT/Production Environments.
• Extensive experience using Hyperion tools like Hyperion Planning, Hyperion Essbase, Lifecycle Management (LCM), Hyperion Profitability and Cost Management, Hyperion Essbase - Excel Add-In, Smart View for Office, Hyperion Shared Services.
• Extensive experience in developing Hyperion Essbase objects like Dimension build rules, Data load rules, MAXL Scripts, Calculation Scripts.
• Experience in developing Hyperion Planning objects like Web Forms, Hyperion Business Rules & Task lists and Design, Development, Implementation of Security Matrix for Hyperion Application, Budget Work Flow Process Management (11.1.2.3), Out of the box Currency Conversion (11.1.2.3)
• Expertise in User Access Management for all Hyperion Application.
• Experience in Unit testing and System Integration Testing(SIT)
• Hands-on experience in implementing Hyperion Planning &Essbase applications in various Industry verticals such as Banking and Finance, Health Care, Insurance, Manufacturing And Hi-Tech
• Worked in varied environments of Development, UAT, Production-Support, and Maintenance projects.
• Excellent Result oriented approach, great written and oral communication / Presentation skills.

PROFESSIONAL EXPERIENCE

Confidential

Hyperion Consultant

Responsibilities:

• Enhancement/Development of Data and dimension build load rules, MAXL Scripting Etc.
• Support for Production deployed cubes.
• Maintenance and additional set up of the needed automation for the cubes on need basis.
• Responding and resolving user issues related to smart view, understanding on working of cubes and their flow.

Confidential

Hyperion Consultant

Responsibilities:

• Decoding excel models to implement the business logic into Hyperion System.
• Implementation and testing of Hyperion Essbase and Planning Objects.
• Implemented different Spread methods in the system with unique logic defined for all with the help of smart lists and development of Business rules in calc manager.
• Performed data movement between different plan types by implementing XWRITE functionality.
• Updating the planning meta data via EPMA.
• Development of Different web forms suitable for needs of capturing Operating expenses, Revenue, player salaries etc.
• Performance tuning of HBR for faster execution of the rule.
• Performed allocations
• Testing of the developed Planning objects and Preparation of their analysis report.
• Development of standard templates for observing correct outcome of the rule executions.

Confidential

Hyperion Consultant

Responsibilities:

• Carrying out the day to day support Activities for Koch's Essbase environment on both Development And production Environment.
• Understanding And Debugging the issues related to the automation set up for Development and production Environment.
• Maintaining Sync of Automation on both production and Development with regards to the changes captured for the relational tables in the warehouse.
• Responding and resolving user issues related to smart view, understanding on working of cubes and their flow.
• Preparation of system documents for each and every Essbase application active on Koch Environment for reference of business users as well as core development and support team.
• Coming up with resolution to curb the glitches of smart view on migration from smart view 11.1.1.3 to smart view 11.1.2.2

Confidential

Hyperion Planning Consultant

Responsibilities:

• Involved in requirement gathering, design and implementation of the “Budget Workflow Process|Approval Process”.
• Generated the “Out of the Box Currency Conversion Script“ and modified the same to in corporate the needs of the business.
• Proposed and Implemented “Advanced Hour Glass Model”to structure the order of the dimensions to achieve maximum performance gain.
• Involved in requirement gathering, designing, and implementation of security structure for the application.
• Developed Web Forms as per the business needs.

Confidential

Hyperion Planning/Essbase Developer

Responsibilities:

• Help the respective application owners with the changes in the application data and Meta data.
• Perform the testing activities to improve the execution time of the business rules.
• Proposed a linear security design for the application.
• Troubleshoot the errors/issued faced by the end user

Confidential, New York

Hyperion Planning/Essbase Developer

Responsibilities:

• Involved in Requirements Gathering And Design Phase for the Development Of Deposits Module Application.
• Developed the Overall security for the Application.
• Developed security matrix wherein the identification of groups and the number of groups were taken care of.
• Implementation of the designed security at both dimension level and at Web Forms.
• Creation of the Groups and users using MAXL and Syncing of the same with HSS.
• Provisioning of groups and users.
• Generating security files from the security matrix to define the dimension level security and implementing the same using import security utility in Hyperion Planning.
• Creating the Parent child formatted files for dimension upload (Meta Data) using Outline load utility for Hyperion planning.
• Developed Calculations scripts in Essbase.
• Developed Business For Use In Hyperion Planning.
• Implemented “Multi Level,Multi-Dimensional Allocation” Model for deposits module.
• Extensive use of both Excel Add in and Smart View for data validation, data retrieval Purposes.
• Performed Migration of Artifacts from one application to another Using LCM.
• Performed Import/Export of web forms using FormDefUtil in Hyperion planning.
• Developed Web Forms in Hyperion Planning and Implemented Security to Them As well.
• Overall Lead for UAT Handling of the application.
• Handling Clients over calls with excellent communication skills and quick and result oriented solution to the users as well.

Confidential

Hyperion Essbase Developer

Responsibilities:

• Providing complete support to the Production Application.
• Creating rule files to load the data into the cube.
• Performing the data load into the dev. environment before implementing the same in the production environment.
• Performing data validation using excel add in and smart view for office.
• Development of calculation scripts.
• Building Test cases.
• Migration of Applications and artifacts across same and different environments.