SUMMARY

• Oracle Hyperion Expert with 10+ Years of experience in advanced analytical software applications, Requirements Gathering, Design, Development, and Testing, Administration and Implementation of OLAP and Client/Server projects using industry accepted methodologies and procedures.
• Experience working as a Hyperion Consultant providing more flexibility to different business stake - holders about Hyperion suite of products along with other Business Intelligence modules.
• Exclusively worked for 4 years as an Administrator on up-gradations, installing, configuring, migrations between different environments for Hyperion suite of products like Essbase, Planning, HFM, HFR, setting up security and involvement of disaster recoveries.
• Provided solution for the cube design for different Hyperion applications for optimal performance.
• Worked as an administrator applying the patches whenever required, maintenance of multi-server level environments with any given complex architecture.
• Worked on Workforce Planning, Capex Planning, PSPB, PBCS modules in Hyperion Planning.
• Extensive experience on different industries/domains such as manufacturing units (Oil & Gas, Semi-conductors etc..), products & services, IT Consulting, Investment/Regular Banking, Retail, Health Care.
• Worked on implementing Cognos Command Center - pilot project to highlight the tool functionalities with the key business stake-holders. Involved in getting requirements and focused on implementing those within the tool.
• Worked on creating a POC (Proof of Concept) on Hyperion Planning & Budgeting on Cloud Services to get the benefits of the module and tested all the features & functionalities of PBCS.
• Worked on implementing Public Sector Budgeting & Planning to provide the tool capabilities with the integration of different source systems, budget calculation and write back to different source systems using Hyperion Planning. Provided a solution for the government sector client for one of the Oracle projects.
• Having subsequent Experience as a Hyperion Technical/Functional Consultant in managing a team of onsite/offshore model and work closely with multiple teams, developers and users.
• Good experience in full lifecycle implementations and extensive experience in support/Maintenance of production environments.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Excellent communication skills with proficient expression, transmission and interpretation of knowledge and ideas.

TECHNICAL SKILLS

OLAP: Hyperion EPM product suite Version 11.x, Hyperion Essbase 9.x, Essbase Integration Services, Planning & Budgeting Cloud Services, Hyperion Planning 11.x/9.x, Hyperion Shared Services 9.x, DRM, HFM, FDM, MAXL, ESSCMD.

Reporting Tools: Hyperion Financial Reports, Hyperion Web Analysis, OBIEE, Hyperion Spreadsheet Services and Smart View for Office

Operating Systems: Windows 7/2000/XP/2008/2003 R2 Servers, UNIX/LINUX environments.

RDBMS: Oracle 9I/11G

Programming: C, SQL, VB Scripting, Shell Scripting, Core Java.

Other Skills: Expert Level Skill in MS Excel, MS Access Database, MS Word, MS PowerPoint.

Web Server: IIS, Web Sphere, web logic, Apache Tomcat

PROFESSIONAL EXPERIENCE

Confidential, TX

Hyperion Consultant

Responsibilities:

• Worked on designing of ASO/BSO Essbase applications.
• Worked on Workforce and Capex planning modules.
• Working on optimization of Hyperion Financial Reports, fine tuning the calc scripts, load process.
• Reviewed the complete cube structure and provided recommendations for optimal performance of the cubes.
• Worked on the partition techniques to pull the data as a between different databases.
• Created a POC for Planning & Budgeting Cloud services.
• Created application structure on PBCS, loaded metadata/data from Oracle GL.
• Setup task lists and assigned users to perform tasks which include running business rules through calc manager and input data into web forms.
• Created web forms in PBCS 11.1.2.3.500 version.
• Tested business rules by executing them, tested planning ad-hoc reporting for the users to enter calculations in excel for client.
• Tested pushing functionality to copy data from one to another plan type and also between different versions.
• Tested the sandbox and valid intersections functionality.
• Worked on task lists, setting up security for MSAD users.
• Created calc scripts/business rules as per the business needs.
• Designed and developed Income Statement & Balance Sheet Financial Reporting reports for TAX department.
• Worked on ARM - Accounts Reconcilation Manager issues to check the data integrity issues for GL, AP, AR, FA balances.
• Loaded data through FDMEE interface tables to different applications like HFM, Essbase & Planning.
• Exclusively worked on different Plan types in Hyperion Planning.
• Developed workforce planning application with the setup of HCM as source.
• Created Web forms for Income statement and Balance sheet for workforce planning application.

Environment: Oracle Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, FDMEE, Hyperion Financial Reports, Hyperion Smart View, Foundation Services, Excel Add-In, MAXL, Oracle 11G, Linux box, Windows Server 2008 R2.

Confidential, Houston, TX

Hyperion Consultant

Responsibilities:

• Involved in Installation and Configuration of Hyperion 11.x system consisting of Oracle’s EPM suite of products like Essbase, Planning, Financial Management, Financial Reporting Studio, Foundation Services and Workspace.
• Responsible for the installation, configuration and maintenance of Oracle Hyperion products on Websphere, Weblogic and IIS servers.
• Involved in the up-gradations and migrations from 11.1.2.2 version in Oil & Gas to 11.1.2.3 version in Corp Shared environment.
• Involved in designing new Essbase, Planning applications based upon the business needs.
• Supporting different P&L within Oil & Gas like M & C - Measurements & Control, D & S - Drilling & Surface, Subsea etc…
• Playing a techno-functional role providing support to all the modules in Hyperion.
• Provided the user provisioning by configuring user active directories to Foundation services and creating groups, assigning roles and then adding users to the groups.
• Providing regular support for BAU activities on Essbase & Planning applications.
• Developed & designed workforce planning application.
• Created business rules and web forms for workforce planning application.
• Maintained the metadata and data for workforce planning & Capex planning applications.
• Involved in New Business Model Applications performance tuning and testing on different environments for Florence users.
• Worked on new Planning application by creating Offline web forms for the users in 11.1.2.2 version as a pilot project and also SOP model derivation.
• Involvement in providing DRM support for the new HFM application on Corp environment.
• Involved in installation, configuration and complete setup of Cognos Command Center a pilot project to decide on the tool capabilities.
• Involved in the maintenance of data, metadata, shell scripts, maXL scripts as a part of this process.
• Involved in the offshore new DevOps model implementation (both on Development & Support activities).

Environment: Oracle Hyperion Enterprise Performance Management (EPM) 11 Suite - Essbase 11.1.2.3.500 , Planning 11.1.2.3.500 , Hyperion Financial Management 11.1.2.3, Financial Data Quality Management 11.1.2.3, Workspace 11.1.2.3, Foundation Services, Calculation Manager, Classic/EPMA Applications, Smartview, Financial Reporting Studio 11.1.2.3, MaxL/Esscmd, MS Excel 2010, Unix/Linux, and Informatica 9.1, Oracle Data Integrator.

Confidential

Hyperion Consultant

Responsibilities:

• Provided help on design challenges, trouble shooting on installation and configuration issues.
• Developed new Essbase applications based on the business needs.
• Worked on the integration of ERPi & ODI with different source systems and Hyperion down-stream applications.
• Exclusively worked on different Plan types in Hyperion Planning.
• Developed Planning application with HCP (Human Capital Planning) & RPT (Reporting) plan types with source GL system.
• Created Web forms for Income statement and Balance sheet.
• Created applications and database cubes in Essbase and Planning. Assigned privileges to users through shared services.
• Created business rules for aggregations and data copy between versions.
• Working on the performance tuning of calculation scripts to minimize the time taken for each calculation script.
• Created Planning Unit Hierarchy and Process Management for work flow.
• Created financial reports for Income statement and Balance sheet.

Environment: Oracle Hyperion Essbase, Hyperion Planning, ERPi, Oracle Data Integrator, Hyperion Financial Reports, Hyperion Smart View, Foundation Services, Excel Add-In, MAXL, Oracle 11G, Linux box, Windows Server 2008 R2.

Confidential

Hyperion Senior Analyst

Responsibilities:

• Involved in requirements gathering for designing and developing Essbase and Planning applications.
• Designed, Developed and Implemented numerous Planning applications and Essbase application from transactional data (SAP Fixed Assets &, Oracle General Ledger Legacy Systems) which was the platform for all the financial reporting and analysis modules.
• Worked on Hyperion planning to support complex applications for budgeting that are flexible to adapt to changes in the business life cycle.
• Worked on various forms using Hyperion Planning.
• Created Stand alone Essbase applications apart from maintaining Essbase databases using Planning application.
• Created and executed calculation scripts for sales, order shipments, actual and forecasting data.
• Executed performance tuning and optimization of both the data retrieval and data loading scenarios.
• Created Hyperion Security by creating Users, Groups and Filters for Essbase and Hyperion Reports.
• Maintained Web Analysis hierarchies in DRM.
• Addition/Deletion of nodes/leaves in the hierarchies.
• Exported/Imported hierarchies through hierarchy routine.
• Monitoring daily incremental loads.
• Involved in renaming process of cubes.
• Solved Excel Add-In issues in Essbase.
• Created Point of Views to users in web analysis.
• Executed calculation scripts for users.
• Interacted with business managers to identify information needs.
• Involved in CRs & ERs for Alias changes, modifying scripts, updating text files, modifying hierarchies in DRM and adding new members to the dimension.

Environment: Hyperion Essbase, EAS, Hyperion Planning, Data Relationship Management, Spreadsheet Services, Smart view, Excel 2003, MaxL, Shared Services, Windows 2003 Server.

Confidential

Hyperion Consultant

Responsibilities:

• Worked on Service Requests with 4 different severity levels.
• Supported 24X5, Users base of 1000 spread across Europe/Asia/Australia.
• Involved in running of Month and Quarter Close process.
• Attended Recovery Calls as a part of Severity 1 issues within the project.
• Worked on providing Root Cause Analysis documents for the common issues in RBS environment.
• Worked on setting up system for Planning Sessions.
• Executed and managed technical break / fix & day-to-day user support cases using Service Requests ticketing process.
• Worked on Mid Monthly maintenance activity where the hierarchies are rebuilt and fresh data is loaded from Legacy systems.
• Worked on re-designing webforms to reduce quarterly maintenance and providing more flexibility to users.

Environment: - Hyperion Essbase, Planning, EAS, EIS, Shared Services, Workspace, MaxL/Esscmd, Excel Add-in.

Confidential

Hyperion Developer

Responsibilities:

• Developed outlines, Calc Scripts, rule files for loading dimensions and data into Essbase cube.
• Designed and developed monthly, quarterly and yearlyreports.
• Created dimension building load rule and data load Rule for dynamic dimension building, attribute dimension building and data loading in essbase.
• Used Time balance and dynamic time series properties for revenue, profit, month end and month beginning data calculations.
• Developed Calc Scripts to calculate various figures for the outline.
• Worked on implementing different applications in Essbase and wrote calculation scripts based on the requirement.
• Developed and maintained Rule files, Calc Scripts& MaxL Scripts.
• Automated the essbase Cubes using MaxL and Batch Scripts.
• Developed and optimized Data Loads and Calculations.
• Monitored the batches during business hours for failures, thus preventing disruption in business operations.

Environment: Hyperion Essbase, Hyperion Shared Services, Excel Add-in, MS Excel 2003, VB Scripts, Windows 2003 Server.