Summary:

• Over 8 years of IT experience with over 6 years experience as a Hyperion Consultant, extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems design and implementation.
• Implemented 2 Hyperion Planning Projects in version 11.1.2 and 1 migration project from 9.3. to 11.1.1.3 and having strong knowledge of entire SDLC process.
• Worked on implementations related to Workforce, Capital Expense Planning applications, Public Sector Planning. Extensive knowledge of OOTB Out of the box functionality of all the modules.
• Extensive experience in the Implementation, development, design, analysis and implementation of various applications using Essbase 11.x/9.x/7.x/6.x,planning 11.x/9.x/4.x/3.x,Hyperion interactive reporting 11.x/9.x/8.x, OBIEE 10.x,Hyperion strategic finance, Hyperion Data integration management DIM , Hyperion Workforce Planning, Hyperion Capital Expenditure Planning, Hyperion public sector planning, Oracle Data Integrator ODI ,Essbase Integration Services, Hyperion Essbase Studio, HAL, Hyperion web Analysis, Hyperion financial Reports, Essbase Spreadsheet Add-In, Hyperion Visual Explorer, Hyperion Smart View.
• Worked on installation and configuration of Hyperion EPM 11.1.2 version on windows/Unix environments including ETL Tools Oracle Data Integrator and DIM.
• Installed and Configured Oracle Data Integrator on windows and Unix Servers.
• Configured master and work repositories created agents, context.
• Strong knowledge of architecture of EPM 11.1.2 and oracle data integrator.
• Worked on various ERP systems oracle financials, Oracle HR, People soft, SAP as data sources
• Integrated OLTP System Oracle EBS, SAP, HR and Demantra to Hyperion using Oracle Data Integrator.
• Created ODI Interfaces to update Hyperion Planning/Essbase Metadata and to import Essbase Data and to export data from Hyperion Essbase to File System and relational databases.
• Proficient in Data Modeling Techniques using Star Schema, Snowflake Schema, Fact and Dimension tables, RDBMS, and Physical and Logical data modeling for Data Warehousing and Data Mart.
• Developed EPMA as well as Classic planning application with Workforce and Capital expenses modules included.
• Worked on various data sources Teradata, Oracle, SAP, Essbase and loaded data from various files such as text, excel xml etc.
• Good knowledge of understanding SDLC process in 11.1.1.3/11.1.2 using Life cycle management utility.
• Expertise in Calc Scripts, MaxL Scripts, MDX scripts in BSO and ASO cubes
• Strong experience in writing custom Essbase Calculations Scripts and complex business rules
• Experience in automation of planning and Essbase dimension build and data load.
• Extensive experience in testing the ETL, Business Intelligence, Client/Server, and Web application.
• Possess a broad understanding of database calculations such as formulas on dimension members, order of calculations in terms of dense and sparse dimensions, dynamic calculations, and developing calculation scripts.
• Able to effectively apply PL/SQL knowledge to retrieve, manipulate, and control data by creating efficient queries, functions, procedures, packages, and triggers.
• Designed and developed UNIX shell scripts as part of the BI process to automate the process of running ad-hoc queries and reports.
• Developed complex dashboards and reports using interactive reporting studio.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• Solid time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews and user trainings as required.
• Excellent written and oral communication skills and a team-player with a results-oriented attitude

Technical Skills:

PROFESSIONAL EXPERIENCE:

Confidential

Hyperion Essbase/Planning /ODI Implementation Consultant

Responsibilities:

• As part of migrating reports from business objects to Hyperion we need to go through the existing reports in business objects and existing business requirement documents to analyze the system.
• As a techno functional consultant worked on entire SDLC of entire Hyperion Implementation.
• Worked on Installation and configuration EPM 11.1.2 version and resolved issues which were specific with 11.1.2
• Worked with Subject matter experts SME and business analysts to gather the business requirements and went through the company chart of accounts to understand the accounting process
• Developed ASO and BSO cubes using Hyperion Essbase 11.1.2
• Integrated various source system Oracle GL, Oracle HR and capital expenditure sources to Hyperion Planning using ODI Oracle Data Integrator by creating and complex Interfaces.
• Created complex ETL on Oracle Data Integrator ODI to meet the end user data requirements.
• Crated Interfaces to automate the metadata and data updates for Hyperion Essbase and Planning applications.
• Developed complex Hyperion Business Rules with run time Prompts and substitution variables.
• Worked on various simple and composite web forms in Hyperion Planning application.
• Created batch scripts using ESSCMD/MaxL to automate Essbase application refresh process dimension building, data loading and calc scripts .
• Embedded Menu, smart list in Hyperion Planning Web forms. Created Data validation rules in web forms to make sure user value would equal to a GL account.
• Created the BSO and ASO cubes in Essbase and Designed Aggregate storage cubes ASO for faster data load.
• Created projects and placed all the required business rules in the projects. Security Provisioning is provided to the business rules.
• Involved in optimizing the ASO calc using Query tracking
• Created Sequences and placed the Hyperion Business rules in the sequences as per client requirements.
• Involved in designing and creating Multidimensional database cubes for financial and analytical business queries.
• Created and executed complex calculation scripts for calculations and MaxL scripts for automation.
• Designed and developed several ad-hoc and financial reports using Hyperion Financial Reports and Hyperion Smart View.
• Involved in Automation of Hyperion Financial reports to run in web and pdf formats and send as attachments to people across the business.
• Administering security, user creation with Native and External Authentication, Filters, dimension level security and Groups.
• Provided database optimization with Dimension building, Data loading, Indexing, Calculations, Cache management and Partition management.
• Optimized the cubes memory by changing Dense/Sparse configuration.
• Executed performance tuning and optimization of both the data retrieval and data loading scenarios.
• Developed comprehensive reporting system using Hyperion Reports.
• Created Hyperion Security by creating Users, Groups and Filters for Essbase, Analyzer and Hyperion Reports.

Environment: Hyperion planning 11.1.2, Essbase 11.1.2, EIS-Integration services 11.1.2, Essbase Studio 11.1.2, Hyperion Data Integration management 11.1.2, Hyperion smart view, Oracle 11g, Oracle Applications, MS Excel Add-in, VB Scripting, ODI 11g.

Confidential

Hyperion Implementation Consultant

Responsibilities:

• Involved in gathering business and functional requirements from detailed business meetings and converted them into design specification documents.
• Communicated with the users to understand any new business needs, and required changes.
• Worked on Hyperion Planning 11.1.1.3 to support complex financial applications for budgeting and Forecasting.
• Designed, developed, tested and deployed Hyperion Planning Applications in Hyperion Workspace.
• Created Web Forms/Data Forms in Hyperion Planning for users to input forecast, budget, actual, accounting changes and other data.
• Developed Task Lists, Work Flows, Menus and Composite Data Forms.
• Developed Business Rules and attached to the input forms to calculate data with an option for Run-time prompts.
• Designed and developed several reports like financial reports, P L Reports, Balance Sheet Reports and Budgeting Reports using Financial Reporting Studio from Planning Application.
• Used Essbase administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.
• Created Transparent Partition for users to share data and outlines that are synchronized on multiple databases to provide users with certain updates on data values.
• Performed tuning of the BSO cubes by arranging the dimensions according to the hourglass model, using Sparse/Dense setting, and various other techniques.
• Created MaxL scripts for data load, dimension build, substitution variable update, partition creation, and partition drop.
• Developed Calc Scripts and improved the calculation performance using techniques such as optimizing the Essbase caches, using parallel calculation, combining FIX statements, etc.
• Successfully upgraded from 9.3.1 to 11.1.1.3 version.
• Optimized the applications to bring down the runtime and database size considerably.
• Involved in production support and maintenance of existing cubes.
• Worked as a team member in Hyperion ESSBASE Planning Implementation.

Environment: Hyperion planning 11.1.1.3/9.3.x, Essbase 11.1.1.3/9.3.x, Hyperion financial Reporting, Hyperion shared Services 11.1.1.x/9.3.x, Financial Reporting Studio 11, Hyperion Utilities, Maxl, MDX, EAS administrative services, Oracle 10g, Smart View, MS excel Spreadsheet Add-In, Windows 2000

Confidential

Senior Hyperion Essbase/Planning Developer

Responsibilities:

• Worked with FPNA team to understand the requirements related to new developments as well as working on enhancements of existing applications as required.
• Involved in designing and creating Multidimensional database cubes for financial and analytical business queries.
• Involved in the requirements gathering for new application development.
• Worked on Hyperion system 9/11.1 planning to support complex applications for budgeting that are flexible enough to adapt to changes in the business life cycle.
• Developed Hyperion Business Rules with Run Time Prompts.
• Developed simple and composite forms as per the end user requirements.
• Created and maintained Essbase databases using Planning application.
• Created and executed calculation scripts for automation of shipments, actual and forecasting data.
• Created Web Forms and Data Grids in Hyperion Financial Management for users to create, modify the data. Running consolidations and debugging rules script for correct results.
• Designed and developed several ad-hoc and financial reports using Hyperion Analyzer and Hyperion Financial Reports.
• Involved in Automation of Hyperion Financial reports to run in web and pdf formats and send as attachments to people across the business.
• Migration of Financial Reports and Web Analysis Reports from Production to Development.
• Administering security, user creation with Native and External Authentication, Filters, dimension level security and Groups.
• Provided database optimization with Dimension building, Data loading, Indexing, Calculations, Cache management and Partition management.
• Optimized the cubes memory by changing Dense/Sparse configuration.
• Executed performance tuning and optimization of both the data retrieval and data loading scenarios.
• Developed comprehensive reporting system using Hyperion Reports.
• Created Hyperion Security by creating Users, Groups and Filters for Essbase, Analyzer and Hyperion Reports.

Environment: Hyperion planning 11.1.2, Essbase 11.1.2, EIS-Integration services 11.1.2, Essbase Studio 11.1.2, Hyperion Data Integration management 11.1.2, Hyperion smart view, Oracle 11g, , Oracle Applications, MS Excel Add-in, VB Scripting, ODI 11g.

Confidential

Hyperion Essbase Consultant

Responsibilities:

• Major concentrated on installation and configuration of oracle Enterprise Performance Management fusion 11.1.1.3. Integrated Oracle Business Intelligence OBIEE and Essbase in fusion environment where Essbase is used as the database and OBIEE is used as front end reporting tool. Worked on migrating Interactive reports from version 8.x to 11.1.1.3 Design and creation of ASO / BSO cubes for OLAP in Hyperion Essbase Assisted in the development of the Security model for the migrated reports based on the earlier version security model using Shared Services across Interactive reporting, Essbase, Planning, Financial Reports Enabled single sign on for the Hyperion applications and implemented SSL communication for the Hyperion suite. As part of migration from Hyperion Intelligence to OBIEE we have created custom dashboard in OBIEE based on the existing Hyperion Interactive reports/Dashboards. Created and maintained Essbase multi-dimensional cubes leveraging both ASO and BSO technologies. Migrated various Essbase objects like outlines, report scripts, cal scripts from Hyperion Essbase 9.x to Essbase 11.x
• Strong knowledge of building cubes using data from various OLTP systems and various relational data marts using Essbase Studio and Integration services.
• Implemented monthly, quarterly and annual Interactive reports which are used by accounting teams for budgeting and forecasting managers.
• Used substitution variables to implement budgeting and forecasting reports as per client requirement with no constraint of time period
• Created complex calculation scripts to implement various business calculations as required.
• Used Data integration management DIM an Informatica plug-in to perform dimension building and data loading of cubes from various staging areas and OLTP systems.
• Participated in various phases of project management such as development, testing, UAT and production support
• Experience in Preparing BTEQ scripts to Populate stage Views using various data marts in Teradata. Used life cycle management utility to copy the Essbase objects from one environment to another i.e. from Dev to Test and Test to Prod As an administrator I have worked on backup and recovery of applications and security groups. Worked on setting up single sign on security between shared services and other Hyperion products
• Involved in User sessions to train users on newly developed products and its new functionalities.
• Worked with business users in each and every phase of the project like business requirement gathering, development, UAT and supporting users for existing reports and applications in production.

Environment: Hyperion planning 11.1.1.3/9.3.1.3, Essbase 11.1.1.3/9.3.1.3 Oracle Business intelligence suite 10.1.3, EIS-Integration services 11.1.1.3/9.3.1.3, Essbase Studio 11.1.1.3, Hyperion Interactive Reporting 11.1.1.3 BI BRIO ,Hyperion Data Integration management 11.1.1.3, Hyperion Web analyzer 11.1.1.3, Hyperion workspace, Hyperion smart view, ORACLE SQL, Oracle 9i/10g, SQL Server, SAS, Teradata, Oracle Applications, MS Excel Add-in, VB Scripting, Informatica, UNIX

Confidential

Hyperion Essbase Developer

Responsibilities:

• Obtained a detailed knowledge of the business process being followed in the project environment
• Extracted the business requirements from the end users keeping in mind their need for the application and prepared business requirement document as per the requirements.
• Involved in the day-to-day implementation of the Rational Unified Process RUP methodology of application development with its various workflows, artifacts and activities
• Involved in backing up the Essbase application on daily basis and restored the Essbase application whenever required.
• Automated the backup process using Shell scripts and worked on UNIX shell wrapper scripts.
• Developed Load rules for Dimension build and Rules File for loading the data from Oracle GL into Hyperion Cube.
• Developed Calc Scripts for aggregating the data based on the business requirements.
• Involved in optimization and tuning of the Essbase application to bring down the calc time.
• Automated the monthly loading process using Maxl, Shell Scripts.
• Resolved many technical and functional issues and ensured the smooth process flow during monthly and quarterly close.
• Maintained the closing cube in parallel to Hyper Roll to ensure the data is being loaded and aggregated as per the business requirements.
• Developed reports required for the business needs using Hyperion Reports and Hyperion Analyzer ad-hoc .
• As a part of team, involved in the installation and configuration of Hyperion Essbase 7.X on VMware environment to test the application.
• Used Web sphere application server for installing and configuring the Planning Web applications.
• Developed Business rules to facilitate the users to aggregate data based on user inputs.
• Developed Web forms using Hyperion Planning for various planning scenarios.
• Involved in validating the web forms for the OTC users on the consolidation cube.
• Created users, user groups in the Planning application for accessing the various application elements.

Environment: Hyperion ESSBASE 6.5.4/7.1.5/9, Hyperion Planning 3.5.1, Hyperion Application Link HAL , Hyperion Reports 7.0, Hyperion Analyzer 7.0, People Soft, Hyperion Essbase Spreadsheet Add-In, PL/SQL and Oracle 8i, Web Sphere 5.0, Windows 2003, Unix Solaris , Korn Shell Scripting, IBM AIX 5.2