PROFESSIONAL SUMMARY:

• Over 8 years of diverse experience in IT with emphasis on Analyses, Finance & planning, EPM and OLAP tools.
• Worked on various Hyperion products - Hyperion Essbase, Hyperion Planning, Shared Services, Interactive Reporting, Financial Reporting Studio, Web Analysis, Smart View, and Excel Add-in on Windows and UNIX environments.
• Expertise in buildingFinancial Budgeting and Forecasting and EPM applications with Hyperion Suite.
• Experience in Data Forms/Web Forms, Business Rules, Task Lists, Menus, User Variables, Smart Lists, installation and configuration of Hyperion products such as Essbase Administrative services, Hyperion Planning, Hyperion Reports, Shared services, Integration Services, Oracle Data Integrator.
• Strong experience in writing custom Essbase Calculations Scripts and complex business rules.
• Extensive experience in testing the ETL, Business Intelligence, Client/Server, Web application.
• Expertise in automation of Planning and Essbase integration process with ODI.
• Possess a broad understanding of Essbase calculations such as formulas on dimension members, order of calculations in terms of dense and sparse dimensions, dynamic calculations, and developing calculation scripts.
• Extensive knowledge in Hyperion Business Rules (HBR), Hyperion Application Link (HAL), Essbase Calculation Scripts, Essbase commands (MAXL) and Essbase functions.
• Administrative knowledge of HFM (Hyperion financial management).
• Expertise in administrative tasks of Essbase: managing applications and databases, Essbase architecture, data and dimension loading, Calc Scripts, MaxL, MDX Querying, Report Scripting, Performance tuning, thorough understanding of Essbase data mining framework.
• Extensive experience in design, development, performance tuning and optimization of Essbase databases. Well versed in Essbase architecture, Calculation Scripts, Business Rules, Aggregate Storage Option (ASO), Block Storage Option (BSO), MDX Member calculations, ESSCMD, MaxL for batch scripting, and shell scripting.
• Worked extensively on Hyperion Financial Reporting Studio, Designed and Updated Financial Reports.
• Understanding of Essbase security features and ability to create user and group profiles, assign the proper privileges.
• Expertise in working with Shared as well as Native Security.
• Good understanding of RDBMS, data warehousing, data reporting and experienced in writing queries using SQL. Experienced in dimensional modeling using Star Schema and Snow-Flake Schema.

TECHNICAL SKILLS:

OLAP: Hyperion version 11.x Product suite, Hyperion System 9 BI+(Analytic Administration Services), Hyperion Planning 11.1.1.x/9.x, Financial Management 11.1.1.x/9.x, FDM 11.1.1.x, Hyperion Shared Services 9.3, Essbase Integration Services, Excel Spread sheet Add-in, Smart view, ESSCMD, MaxL and MDX.

Databases: Essbase 11.1.1.3 /9 BI+, Oracle 11i/10g/9i/, SQL Server 2005, MS Excel, MS Access

Reporting Tools: Financial Reporting Studio 11/9.3, Interactive Reporting 11/ 9.3, Web Analysis, Hyperion System 11 /9 Smart View, Hyperion Spreadsheet Add in

Languages: SQL, HTML, XML, C#, ASP.Net, VB.Net, JavaScript

Operating Systems: Windows, Unix/Linux

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Hyperion Analyst

Responsibilities:

• Played an active role in development phases which includes application design, development, and implementation.
• Created BSO & ASO applications using transparent partition technique and essential calc scripts.
• Written MDX queries for ASO outlines.
• Created interfaces in Oracle Data Integrator (ODI) for metadata and data load into BSO cubes.
• Maintain outline, metadata, members and member properties as business requirements change.
• Created Database and optimized the outlines by arranging the Dimensions for data load, calculation time and improving query retrievals.
• Modifying and execution of calculation scripts to aggregate the data with different scenarios.
• Developed MaxL Scripts to automate Essbase tasks like loading data, calculations and backups.
• Designed and created various filters according to user requirement.
• Created users and groups for access rights in applying security and authorization regulations.
• User provisioning on a client requirement basis.
• Involved in development and modification of existing financial and marketing reports which include corporate consolidation reports and financial & planning reports for management.
• Used Hyperion planning for the development of web forms for data entry into Essbase cubes.
• Performing data validation on day-to-day basis during closing period.
• Scheduled & Developed batch scripts for weekly and month end process.
• Intervened in production support issues when required to improve issue turnaround time and system availability to the end users
• Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to ESSBASE cube.
• Developed data forms and folders and customized the data forms.
• Developed Business Rules to copy data from one version to another using Run-time prompts.
• Developed OLAP Models and Meta outlines in EIS and schedule cube build and data load using EIS scheduler.
• Created and executed calculation scripts for automation of shipments, actual and forecasting data.
• Optimized the cubes performance by changing Dense/Sparse configuration.
• Developed rules files to load data from the database to Essbase cube.
• Created and scheduled batch jobs for complete automation processes for application refresh and backup.
• Presented detailed analytical reports to higher administrative people using Hyperion Planning induced collaborative decision making.

Environment: Hyperion 11.1.2.x, Hyperion Strategic Finance, Hyperion Planning, Hyperion Financial Management, Oracle 11g, Oracle Data Integrator, MS-Excel 2010 Spreadsheet Add-In, Smart View, Unix.

Confidential

Sr Hyperion Planning & Essbase Consultant

Responsibilities:

• Providing monthly and quarterly support for EFS Hyperion applications and provide support to Planning cycles.
• Loading the data from GL to Hyperion and validating the data.
• Building the dimensions and Loading the data using the rules file, data file and Maxl scripts and checking the log and error files.
• Creating/Maintaining the web forms when required.
• Exporting and Importing all data and level0 data from the cube. Copying the applications, databases and outlines from one server to other server.
• Responsible for taking the backup of the outline, rule files, Calc Scripts and Report Scripts.
• Provide support to users during planning cycles. Running the Business rules for loading the data from Planning to Essbase applications.
• Provide Administrative support to Essbase and Planning applications.
• Changes to the existing cubes when required.
• Validating the data in the Spreadsheet add-in between Source GL data and Hyperion data.
• Defining the Calculations and Formulas. Troubleshooting in case any errors.
• Used ESSCMD in an interactive and batch mode to load data files.
• Developed and optimized Data Loads and Calculations.
• Developed Calc Scripts to calculate various figures for the outline.
• Configuring ODBC Environment Variables.
• Preparing Relational Data Sources, Consolidating Relation data & developed the OLAP model & Meta -Outlines, Implemented Star Schema and used EIS to interface with the company’s existing Oracle data warehouse.
• Developed and maintained Rule files, Calc Scripts, MaxL Scripts & Reports.
• Involved in Performance Tuning to minimize data load time.
• Analyzed all dimensions and members in the EssBase outline.
• Performed tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.
• Responsible for Performance Monitoring, Backup and Recovery of the cube.
• Prepare financial reports for management.
• Developed Aggregate Storage Cubes (A.S.O) cubes using ESSBASE.
• Extensively involved in designing and modifying the outlines for ESSBASE Cubes.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
• Developed OLAP Models and Meta outlines using ESSBASE Integration Services from star schema in relational databases.

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

Confidential

Hyperion Developer

Responsibilities:

• Created a metadata which is suitable for the source system account format in Hyperion Planning & Budget.
• Metadata, such as building metadata for Account, Scenario, Entity Dimensions.
• Loading Meta data, Business Rules and Process units using Workspace.
• Workspace was used to register the application, creating the Web data forms/data grids, Workflow, Task lists, launching business rules.
• Shared services was used to maintain the user provisions and level of access(interactive user, Planner, Viewer, offline user), and creating the projects.
• Created the Data forms(Web forms) for the data representation for the end users.
• Used Shared Service for Users Setup-Provisioning-Security Classes.
• Created users and user groups in the Planning applications and assigned security to web forms.
• Design reports using Financial Reporting.
• Used HAL, EIS to load data values, accounts, entities, and custom dimensions from flat file into Planning Cube.
• Used Essbase administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.
• Managed functional operations / service desk from offshore delivery group.
• Created reports for Income Statements, Balance Sheets, Key Metrics, OTC, Operating and Admin Expenses, Consolidation, Corporate P&L, Functional P&L, Revenue.
• Created many of web analysis reports with various complexities ranging from basic P&L reports to corporate dashboards with drill through functionalities.
• Linked Hyperion financial reporting to Essbase as well as planning and created many reports to meet users’ needs.
• Provided to end users so they can create their own reports using web analysis studio.

Environment: Oracle Hyperion EPM11 - Essbase 11.1.2.1, Planning 11.1.2.1, Workspace 11.1.2.1, Oracle Data Integrator, SQL/PLSQL.

Confidential

Hyperion Essbase/Planning 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.1 version and resolved issues which were specific with 11.1.2.1
• 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
• Implemented different Essbase ASO and BSO solutions for different functional groups.
• Integrated various source system Oracle GL, Oracle HR and capital expenditure sources to Hyperion Planning using Oracle Data Integrator by creating and complex Interfaces.
• Created complex ETL on ODI to meet the end user data requirements.
• Crated Interfaces to automate the metadata and data updates for Hyperion Essbase and Planning applications.
• Experienced Oracle Data Integrator (ODI) to load both metadata and data
• Developed complex Hyperion Business Rules with run time Prompts and substitution variables.
• Worked on various simple and composite web forms in Hyperion Planning application.
• 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 projects and placed all the required business rules in the projects. Security Provisioning is provided to the business rules.
• 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.
• Automated the backup process using Shell scripts and worked on UNIX shell wrapper scripts.
• Provided database optimization with Dimension building, Data loading, Indexing, Calculations, Cache management and Partition management.
• 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, Analyzer and Hyperion Reports.

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

Confidential

Jr. Database Administrator

Responsibilities:

• Created tables, forms and reports in SQL Server.
• Loaded triggers and procedures.
• Assisted in backup and recovery andgeneral maintenance procedures.
• Created and modifiedthe SQLServerstored procedures, functions and packages whichloaddata from temp tables to interface tables and do data validations.
• Involved in requirement analysis, Code development,testing and production deployment.

Environment: SQL Server, Windows