SUMMARY:

• Having around 9 years of experience in Oracle Hyperion Applications.
• Having experience in Oracle Hyperion Essbase, Oracle Hyperion Planning (Classic and EPMA), Oracle HFR, Oracle BR calculation scripts, Oracle Cloud (PBCS and EPBCS), DRM,EDMCS, HFM,Hyperion EPM Integration Developer, OAC,FCCS and Anaplan .
• Experience in Essbase Cube Analysis & design, Optimization Tuning and configuration settings.
• Having knowledge in model building, List members upload, Confidential load, classic and UX dashboard creation, Security update and REST API for Anaplan.
• Having good experience in BSO as well as ASO applications.
• Managing/administration: security, permissions, users and groups, controlling access to d Confidential base cells through managing.
• Working with customers to identify and resolve numerous instability issues.
• Having support experience in HFM and FDMEE .
• Having experience in installing and configuring the Hyperion products, resolve any Hyperion service and application related issues and be good at applying patches in Hyperion products.
• Having experience in Dimension Building, D Confidential loading and calculation scripts.
• Having experience in Hyperion version uprate and in premises to EPBCS
• Having experience in calc scripts, Maxl scripts, Esscmd Scripts, Load rules Essbase Excel - Add-in.
• Worked in Essbase Cube Analysis & Design, Maintenance and d Confidential base backups and Having experience in Batch processes and automated processes.
• Having experience in conversion of Hyperion classical planning and Hyperion Classical HFM applications to Hyperion EPMA application.
• Design and Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations d Confidential .
• Design and Developed excel templates user to input the d Confidential and retrieve the d Confidential .
• Using excel templates Single click d Confidential send and retrieve and execute the calculation scripts using macro buttons.
• Developing the reports in planning and essbase using Hyperion Financial Reporting.
• Refresh the Planning environment and help the application team in resolving any issues that may arise in the process.
• Working with users to ensure that development efforts are meeting the user’s needs.
• Possesses excellent analytical, problem-solving and learning skills as well as a keen interest in the emerging technologies.

TECHNICAL SKILLS:

OLAP Application: Hyperion Essbase 11.x, Hyperion Planning 11.x,

Hyperion Financial Reporting11.x, Hyperion Web analysis 11.x:

D Confidential bases: Oracle 10i/SQL

Utilities: MS-Office

Operating Systems : Windows 2003/2008/XP/Win-7/8/UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Menlo Park, CA

Hyperion Consultant

Responsibilities:

• Involved in Forecast, Annual Plan and Budget Plan Close activity .
• Optimized the calculation scripts and D Confidential retrieval and Outline before it has become operational.
• Export the google cloud d Confidential using dermal script and load the google GCP bucket d Confidential to Hyperion.
• Involved in model building, List members upload, d Confidential load, classic and UX dashboard creation, Security update.
• Involved in integration from Hyperion to Google PLX, Anaplan and Oracle and EPBCS and PBCS.
• Involved in metad Confidential load, d Confidential forms creation,d Confidential load,task list creation, scheduled the jobs using EPM automate and migration in EPBCS and resolved the issues for the same.
• Involved in On prem Hyperion application to EPBCS upgrade
• Involved in Export the ASO d Confidential using report script and load in GCP bucket and Turbo.
• Involved in BD days, Month end and year end perform the respective activities.
• Involved in Hyperion D Confidential, Metad Confidential and application issue and resolved the same.
• Resolved the EPMA metad Confidential related issue in DRM and resolved the same respective nodes.
• Involved in metad Confidential export using DRM and action scripts, version and Nodes updates.
• Resolved the SAP AO (Analytics office) Microsoft add-in, SSO and security related issues.
• Involved in d Confidential validation between the SAP BPC and Anaplan vice versa Oracle Hyperion.
• Custom setting type of compression, d Confidential cache, calculator cache settings, allocation of dense /spare configuration relating to hourglass model to have optimum d Confidential base block size.
• Worked with business users and resolved the issues using Guts tickets and bugnizer.
• Developed Automation Scripts for planning artifacts Backup Using LCM utility.
• Developed Automation Scripts in Maxl for D Confidential loading and Export D Confidential for ASO & BSO apps.
• Involved in day-to-day administrative activities such as managing users on the shared service.
• Worked with the Oracle support to resolve the issues using SR requests.
• Designing Excel reports to users, Excel Macros are implemented for retrieval, submit the d Confidential and execution the calculation scripts.
• Involved in integration from EBS, GCP, Google sql, Anaplan and DRM to Hyperion using the ODI tool.

Environment: Hyperion 11.1.2.4.x/Smart View/G Linux/ODI/Google PLX/GCP/Anaplan/SAP AO/EPBCS

Confidential

Hyperion Developer

Responsibilities:

• Creating and managing the Planning application and d Confidential base.
• Creating the master d Confidential Flat files and importing the file into application.
• Creating the task list and assigning the access to related groups.
• Optimized the calculation scripts and D Confidential retrieval and Outline before it has become operational.
• PBCS and EPBCS application development.
• Multiple languages report creation using HFR.
• Installed and configured Hyperion products in DEV, UAT and PROD.
• Involved in Hyperion service and application issues and resolved the same.
• Resolving Block creation issues and Clear slice of d Confidential in d Confidential base.
• Fragmentation technique is used to reduce the disk space and increase the calculation performance.
• Custom setting type of compression, d Confidential cache, calculator cache settings, allocation of dense /spare configuration relating to hourglass model to have optimum d Confidential base block size.
• Create/enhance/troubleshoot the monthly/Weekly/daily shell scripts jobs and schedule the shell scripts jobs using Jill.
• Worked with business users and resolved the issues using BMC remedy and Quality center tickets.
• Developed Automation Scripts for planning artifacts Backup Using LCM utility.
• Developed Automation Scripts in Maxl for D Confidential loading and Export D Confidential .
• Involved in day-to-day administrative activities such as managing users on the shared service.
• Worked with the Oracle support to resolve the issues using SR requests.
• Designing Excel reports to user, Excel Macros are implemented for retrieve, submit the d Confidential and execution the calculation scripts.
• Involved in d Confidential integration from EBS system to Hyperion using and Hyperion to EBS system ODI tool.

Environment: Hyperion Essbase11.1.2.4.x /Excel add-in/HP-UNIX/ODI/PBCS/EPBCS

Confidential

Hyperion Consultant

Responsibilities:

• Creating and managing the Essbase application and d Confidential base.
• Identifying and prioritizing system enhancements and developing specifications for Hyperion Applications that meet the business requirements using Quality Control ticketing tool.
• Creating the master d Confidential Flat files and importing the file in to outline.
• Optimized the calculation scripts and D Confidential retrieval and Outline before it becomes operational.
• Enhance the existing shell scripts and partial knowledge in shell scripts.
• Migrate the production environment mirror to QA and DEV.
• Resolving Block creation issues and Clear slice of d Confidential in d Confidential base.
• Fragmentation technique is used to reduce the disk space and increase the calculation performance.
• Custom setting type of compression, d Confidential cache, calculator cache settings, allocation of dense /spare configuration relating to hourglass model to have optimum d Confidential base block size.
• Create/enhance/troubleshoot the monthly/Weekly/daily shell scripts jobs and schedule the shell scripts jobs using Jill.
• Using Accurev toll we will migrate the applications from development to QA, QA to integration and integration to production.
• Worked with business users and resolve the issues using BMC remedy and Quality center tickets.
• Developed Automation Scripts for Essbase artifacts Backup Using LCM utility.
• Developed Automation Scripts in Maxl for Incremental D Confidential loading and Export D Confidential .
• Involved in day-to-day administrative activities such as managing users on the Essbase server, planning server, identifying and resolving problem.
• Worked with the Oracle support to resolve the issues using SR requests.
• Designing Excel reports to user, Excel Macros are implemented for retrieve, submit the d Confidential and execution the calculation scripts.

Environment: Hyperion Essbase11.1.2.4.x /Excel add-in/VB 6.0/UNIX.

Confidential

Hyperion Developer

Responsibilities:

• Creating an application and d Confidential base in Essbase.
• Identifying and prioritizing system enhancements and developing specifications for Hyperion Applications that meet the business requirements.
• Creating the master d Confidential Flat files and importing the file in to outline.
• Optimized the Outline before it becomes operational.
• Optimized the calculation scripts and D Confidential retrieval.
• Resolving d Confidential load issues from BSO to ASO
• Resolving ASO Dimension Solve order Issues.
• Resolving Block creation issues and Clear slice of d Confidential in d Confidential base.
• Fragmentation technique is used to reduce the disk space and increase the calculation performance.
• Custom setting type of compression, d Confidential cache, calculator cache settings, allocation of dense /spare configuration relating to hourglass model to have optimum d Confidential base block size.
• Perform monthly/Weekly/daily job runs troubleshoot issues that arise in the run
• Developed Automation Scripts for Essbase artifacts Backup Using LCM utility.
• Developed Automation Scripts in ESSCMD for Calculation sequence of scripts execution.
• Developed Automation Scripts in Maxl for Incremental D Confidential loading and Export D Confidential .
• Involved in day-to-day administrative activities such as managing users on the Essbase server, planning server, identifying and resolving problems.
• Worked with the Oracle support to resolve the issues and also maintained the Metal link for updating the SR requests.
• Created groups and user privileges and global security settings for Essbase and Planning.
• Designing Excel reports to users, Excel Macros are implemented for retrieval, submit the d Confidential and execution the calculation scripts.

Environment: Hyperion Essbase11.1.2.1 /Hyperion Planning11.1.2.1/ Hyperion EPMA 11.1.2.1/Hyperion Financial Reporting (HFR)/ Smart view/Excel add-in.- 4 -