SUMMARY

Hyperion Technical Consultant with more than 4 years of extensive technical expertise in Design , Analysis, and Administration using Hyperion Suite of products Essbase, Planning, Financial Reporting, Web Analysis, ODI, DIM, DRM.

Professional Summary:

Full technical understanding and know-how on Hyperion System 9/11 EPM Suite of products

Professional IT experience in OLAP, Business Analysis, Requirements, Development, Testing and Database Administration of Data Warehousing and Client/Server projects using industry accepted methodologies and procedures

Strong database development and business intelligence modeling capabilities;

Expert level Essbase calculation script knowledge.

Specialized in Design and Optimization of Essbase Applications.

Very good understanding on advantages, limitations & advancements in recently released Hyperion products

Expertise knowledge in Memory analysis, cache tuning, Configuration settings tuning, Performance tuning, Optimization, Dense/Sparse settings, partitioning, etc

Very good experience in troubleshooting technical issues with various Hyperion products

Extensive experience in Essbase load rules, report scripts, integration tools and overall system architecture

Expertise knowledge in building partitions and resolving the calculation issues between the partitions

Good experience in ETL tools like ODI and DIM

Extensive experience in Hyperion Planning, web forms, business rules, Hyperion Financial Reports, Analyzer/Web analysis.

Developed business value solution for customers using Hyperion Planning.

Possess excellent project management skills in managing, developing and implementing the project

Developed many security models as per the company needs.

Strong experience in all phases of testing including defining user acceptance criteria, developing plans/scripts, documenting expected results, execution of scripts, validating actual results.

Possess excellent analytical, logical, communication skills.

Technical Skills:

Hyperion:

Essbase 11.x/9.x/7.x, Planning 11.x/9.x/4.x

Financial Reporting 9.x/11.x, Web Analysis 9.x/11.x/Hyperion Analyzer. Hyperion shared services, DRM, Smart view, Excel addin, MAXL, ESSCMD.

Languages:

Visual Basic, VBA, C, C++, PL/SQL, HTML, XML

Scripting Languages:

VB Script, Java Script, Perl, shell, Python

Database:

MS SQL Server 6.5/7.0, Oracle 8.x/9.x, MS Access

Testing Tools:

Win Runner, Load runner, Test Director

Operating Systems:

MS DOS, Windows 95/98/NT/2000/XP, UNIX AIX, Solaris

ETL Tools:

ODI, DIM, Star Analytics (SFCC & SIS)

Education:
Master of Science in Electrical Engineering
Bachelor of Technology in Electronics and Communications

Professional Experience:

Confidential, Oct ‘10 to March ‘12

Hyderabad, India

Hyperion Senior Analyst

Confidential, a leading software company with different sectors like search engine, map’s, mail and many more. They have been acquiring a large number of small companies to mould their products into a much better shape. Google finance department uses Hyperion Suite of Financial and Business Intelligence Tools for planning and forecast purposes. Actual’s data is extracted into flat files from Oracle and is loaded into a Staging Area. Data is then transformed and loaded into the Essbase from this staging area. Planning applications are developed one for each Business Unit for their monthly forecasting and yearly Planning requirements.

Roles and Responsibilities:

• Designed, developed, and implemented Reporting System for the Financial Department using Essbase, planning.
• Involved in gathering requirements and developing a project plan.
• Developed Planning dimensions and Essbase outline
• Developed Planning Web Forms.
• Developed several Business rules for Allocations, eliminations, drivers and other calculations.
• Developed Planning Workflow and task flows.
• Developed Essbase calc scripts and partitions.
• Developed Essbase reporting cube on top of planning cube.
• Defined and setup the application security in Hyperion Planning, Hyperion Essbase, and Essbase Integration Services.
• Developed EIS OLAP Model, Meta-outline for building various Essbase cubes.
• Development of dimensions and properties.
• Analyzed all the dimensions and members in the Essbase database using Essbase Administration Services.
• Setup automated scripts for weekly backup of the application.
• Created and automated aggregation scripts in ESSCMD and MaxL to run at the specific times that the business required.
• Involved in reviewing the cube design, Performance Monitoring and Performance Tuning of the Essbase server.
• Designed and developed all reports using Hyperion Reports.
• Provided technical guidance and support to end-users by developing the documentation required.
• Performed UNIT testing and USER ACCEPTANCE TESTING (UAT) the final step before Rolling out of the Application.
• Worked with Hyperion Support on a number of issue resolutions.
• Developed the documentation required to transfer knowledge for the users and for the administration and support.

Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, Hyperion workspace 11.1.1.3, Hyperion Shared Services 11.1.1.3, DIM, BEA Weblogic 8.1/9.1, Essbase Excel Add-in, Smart View for Hyperion, Oracle 10g, Solaris, Windows 2003 server.

Confidential,Green Bank, WV Feb ’09 to Sep ‘10
Hyperion Developer

Confidential, is a Federally Funded Research and Development Center of the United States National Science Foundation and the operator of the world\'s largest fully steerable radio telescope. NRAO provides state-of-the-art radio telescope facilities for use by the international scientific community. NRAO uses Hyperion Suite for the analysis of invoices, open order sales data on a daily and weekly level. The assignment includes integration Business of other locations into the WV Business and the following category of tasks – Hyperion Essbase/Planning Application developing, financial reports, and optimization of the applications for better performance.

Roles and Responsibilities:

Interacted closely with the Business Analysts, Oracle and BW professionals to gather requirements of the Business Users.

Closely worked with the functional and the business analyst team during the pre-implementation phase of the applications.

Designed Essbase Databases and Structure of the Outlines.

Designed complex outline formulas to satisfy the requirements of conditional aggregations on some stat accounts, YTD and QTD calculations, Allocations, etc

Worked on Migrations of databases from development servers to QA/Production servers

Defined and setup the application security in Hyperion Planning and Hyperion Essbase.

Performance tuning and 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

Performed Essbase administration activities such as creating filters, creation of users, of groups and maintenance of Essbase Servers

Developed dimension build rules, data load rules and report scripts.

Created and modified MAXL and other automation scripts to automate the application/cube build

process as well as reports generation and distribution process.

Created and maintained partitions between ASO and BSO cubes.

Aggregation and Database testing in various testing phases.

Created report scripts for Data validation and Balancing with the Source Systems.

Created number of MDX scripts to replace all the member formula and also to add time balance and period-to-date functionality to the application.

Worked with Hyperion Reports team to create Hyperion reports on Essbase Applications.

Created the Data forms and Data grids for the data representation for the end users.

Created users and user groups in the Planning applications and assigned security to web forms

Worked closely with the portal team for the changes to the Portal Reporting environment.

End user training and documenting the process.

Developed new Planning Application from scratch as per business requirement (proto type)

Developed planning web forms

Used ODI to load data values, accounts, entities and custom dimensions from flat file and SQL into Planning.

Environment:
Hyperion Essbase 7.1.3/ 9.3.1, Hyperion Planning 4.0/9.3.1, Analytic Administration Services 7.1.6/9.3.1, Hyperion Financial Reporting 7.x/9.3.1, Essbase Excel Add-in, AIX UNIX, Windows 2003 Server.

Confidential,Philippi, WV Oct ’08 to Feb ’09
Business Consultant

Confidential,designs reliable and robust equipment for the extreme conditions found on the face of earth. Worked on handling various aspects of the project like data gathering, analysis of the data, documenting the functional components of the business. Got a detailed understanding of business functionality.

Roles and Responsibilities:

• Information was gathered regarding the different roles in the organization.
• Analysis was done on the present work habits of the company to suggest a more efficient process.
• Worked with the senior business analyst on interacting with employees on suggesting them a better work flow.
• Documented and submitted a complete process which gave me a good insight in business process.