SUMMARY:

• 8+ years of experience as Hyperion Consultant with extensive experience in OLAP software systems design and implementation .
• Experienced in all phases of SDLC like analysing the business requirements, developing the application using industry best practices, deploying into different environments ( production, test and development ).
• Involved in Hyperion Financial Reporting.
• Analyzed, designed, developed, and implemented applications using Essbase 11.x/9.x, Planning 11.x/9.x, Hyperion Financial Reports, HFM, Essbase Studio, and Essbase Spreadsheet Add - In, & Smart view
• Experience in DRM (Data Relationship Management) Extensive experience in FDMEE (Financial Data Quality Management Enterprise Edition) .
• Expertise in using Smart View to analyse data and create ad hoc reports.
• Extensively worked on data extraction, transformation and loading from various sources like Oracle, SQL Server, DB2, COBOL and Flat files .
• Experience in diverse ERPS such as PeopleSoft, EBS/eEBS/Fusion and JD Edwards.
• Experience in ETL and reports development in Informatica, SQL Server, SSIS (SSIS 2012 & 2016).
• Hands on experience of dense and sparse settings, performed dynamic calculations, developed, reviewed, and optimized report queries in Microsoft Excel, loaded data from various database to cubes.
• Expertise 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 .
• Proficient in software documentation, technical report writing, knowledge transfer, and possess strong leadership qualities along with communication and interpersonal skills.
• Sound understanding of Essbase security feature with experience in creating user/group profiles, and assigning proper privileges using native security, and shared services mode .
• Extensively worked on Dimension building, Data Loading, Database Optimization, Database backups, Dense/Sparse settings.
• Experienced in Calc scripts, Report scripts, MaxL, and ESSCMD

TECHNICAL SKILLS:

Multidimensional Database: Hyperion Essbase 11.x/9.x

EPM Tools: Hyperion Planning 11.x/9.x, Studio, Hyperion Profitability and Cost Management (version 11.1.2.4)

Reporting Tools: Hyperion Financial Reporting 11.x/9.x, Web Analysis, Hyperion System 9 Smart View 11.x/9.x

Hyperion Scripts: Calc Scripts, Report Scripts, MaxL, MDX and ESSCMD

Programming Language: Java, PL/SQL

Web Technologies: HTML, DHTML, XML, CSS, Java Script

Operating Systems: Windows, UNIX

Databases: Oracle 9i/10g/11g, SQL Server 2008, Teradata

GUI Tools: TOAD, SQL Developer, VMWARE, MS-VISIO

PROFESSIONAL EXPERIENCE:

Hyperion Financial Reports Consultant

Confidential

Responsibilities:

• Developed reports using Hyperion Financial Reporting studio
• Provided technical support and advice on the definition and strategy of best practices of development Hyperion Financial reports for the client
• Involved in documentation of the Hyperion Financial Reports, design document and test Approach Documents
• Ensuring data access security to the correct roles and service accounts.
• Experience in loading metadata into Essbase application using outline load command lines utility.
• Devel oped reports using Hyperion Fusion cloud for EBS (Enterprise Business suite)
• Gathered requirements for building of reports from business users and senior management.
• Used Web Analysis, Financial Reporting and Interactive reporting to prepare quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.

Hyperion Consultant

Confidential, Nashville, TN

Responsibilities:

• Designed BSO application and ASO application as per the reporting requirement of the company.
• Provided technical support and advice on the definition and strategy of best practices of development EPM Hyperion for the client
• Involved in analysis, development, implementation, documentation of Functional requirements forHyperion Planning ESSBASE, ODI, OBIEE and Financial Reporting implementations
• Designed Rules Files for the purpose of loading data from flat files to the dimensions in outline using several build/load methods such as generation, level and parent-child references.
• Utilized FDMEE to integrate Hyperion to source system.
• Designed, developed and implemented Analytics solutions using Tableau and Power BI
• Responsible to build Data Mart using Informatica PowerCenter.
• Used Informatica PowerCenter to develop ETL mappings involving medium to complex logic using various power centre transformations such as Source Qualifier, Expression, Filter, Aggregator, Sorter, Java transformation, Router, Update Strategy, Sequence Generator, Look up and Joiner.
• As a part of team developed the Essbase outlines, member formulas, and data load rules for the Essbase Applications .
• Analyzed and documented client requirements and developed/implemented customizations for Hyperion Planning and Forecasting Application.
• Used DRM (Data Relationship Management) to manage organization’s metadata.
• Experience in loading metadata into Essbase application using outline load command lines utility.
• Involved in Hyperion Profitability, and Cost Management EPM implementation.
• Used MaxL in an interactive and batch mode to load data files and automate Essbase operations.
• Developed and maintained rules files, calc scripts, MaxL scripts and reports .
• Ensuring data access security to the correct roles and service accounts.
• Developed and customized Data Forms in Hyperion Essbase for users to input forecast, working data, and accounting changes, and other variance data .
• Developed load rules for loading data files and for dimension build and implemented data-access security and user management . Developed Calc Scripts to calculate various Metrics for the outline.
• Designed and created a security plan to manage security at the user and group layer, including global access layer and the server level .
• Involved in troubleshooting and production support .
• Developed several ad-hoc reports using Smart view .
• Involved in performance tuning to minimize data load and calculation time using the dense/sparse settings and developed the required alternate roll ups for reports.

Sr. Hyperion Consultant

Confidential, Salt Lake City, UT

Responsibilities:

• Designed BSO application and ASO application as per the reporting requirement of the company.
• Provided technical support and advice on the definition and strategy of best practices of development EPM Hyperion for the client
• Involved in analysis, development, implementation, documentation of Functional requirements forHyperion Planning ESSBASE, ODI, OBIEE and Financial Reporting implementations
• Designed Rules Files for the purpose of loading data from flat files to the dimensions in outline using several build/load methods such as generation, level and parent-child references.
• Ensuring data access security to the correct roles and service accounts.
• Designed, developed and implemented Analytics solutions using Tableau and Power BI
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected and unconnected Lookups, Filter, Router, Sequence Generator, Sorter, Joiner, and Update Strategy
• Provided technical support and advice on the definition and strategy of best practices of development EPM Hyperion for the client
• Involved in analysis, development, implementation, documentation of Functional requirements forHyperion Planning ESSBASE, ODI, OBIEE and Financial Reporting implementations
• Involved in UAT/SIT testing
• Used DRM (Data Relationship Management) to manage organization’s metadata.
• Designed Data forms/Web forms, Menus and Smart lists to allow users to key in the data for the drivers that business requires, also attached business rules with these data forms to calculate several accounts.
• Utilized FDMEE to integrate Hyperion to source system.
• Involved in Hyperion Profitability, and Cost Management EPM implementation.
• Designed a replicated partition to transfer a portion of data from one cube to another, which significantly increase the performance for the excel-retrievals.
• Created MaxL and batch scripts to automate process of updating cubes daily.
• Supported existing P&L application (consisting of Balance Sheet, Consolidated and Workforce databases )to plan several employee related expenses like salaries, bonuses, vacation days, vacant and filled positions, report Net income, Net Sales, Profit and Loss etc.

Hyperion Planning/Essbase Consultant

Confidential, Austin, TX

Responsibilities:

• Involved in design and development of two cubes, one for budgeting and planning and the other for customer analysis .
• Led design, build and tuning of all Hyperion objects according to business requirements
• Involved in analysis, development, implementation, documentation of Functional requirements for Hyperion Planning ESSBASE, ODI, OBIEE and Financial Reporting implementations
• Developed both ASO and BSO applications depending on the requirement of the application.
• Used SQL Server Integration Services (SSIS 2012) for integration services
• Creating and modifying Hyperion Planning Web forms .
• Designed, developed and implemented Analytics solutions using Tableau and Power BI
• Used DRM (Data Relationship Management) to manage organization’s metadata.
• As a part of team developed the Essbase outlines, member formulas, and data load rules for the Planning Application .
• Utilized FDMEE to integrate Hyperion to source system.
• Experience in loading metadata into planning application using outline load command lines utility.
• Used MaxL in an interactive and batch mode to load data files and automate Essbase operations.
• Developed and maintained rules files, calc scripts, MaxL scripts and reports .
• Developed the necessary calculation scripts to calculate complex values, such as acquisition cost, gross margin/inventory turnover, revenue/payroll hr, total head count, and return on assets, properties, plants, and equipment, cash cost per user and YTD commitment and variance.

Hyperion Consultant

Confidential, Columbus, OH

Responsibilities:

• Designed and developed new Essbase cubes for corporate reporting framework using both Aggregate storage (ASO) and Block Storage (BSO) cube as per the requirement.
• EPM Hyperion Full cycle implementation.
• Involved in Hyperion Profitability, and Cost Management EPM implementation.
• Worked with Essbase and Teradata, which included metadata changes, revising data forms and creating Balance Sheet schedules. Loaded data through Essbase and created and resolved any mapping kick outs.
• Used DRM (Data Relationship Management) to manage organization’s metadata.
• Developed and customized Data Forms in Hyperion Essbase for users to input forecast, working data, and accounting changes, and other variance data .
• Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Developed load rules for loading data files and for dimension build and implemented data-access security and user management . Developed Calc Scripts to calculate various Metrics for the outline.
• Developed application to create reports for income statements, balance sheets, key metrics, operating and admin expenses, consolidation, corporate P&L, Functional P&L and Revenue for different markets.
• Loaded actual data into Hyperion Essbase to drive actuals, forecast and budget numbers.
• Utilized FDMEE to integrate Hyperion to source system.

Hyperion Consultant

Confidential, Irving, TX

Responsibilities:

• Designed and developed Essbase cubes for corporate reporting framework using both Aggregate storage (ASO) and Block Storage (BSO) cube as per the user requirement.
• Developed and customized Data Forms in Hyperion planning for users to input forecast, working data, accounting changes and other variance data .
• Involved in end to end Hyperion Profitability, and Cost Management EPM implementation.
• Used DRM (Data Relationship Management) to manage organization’s metadata.
• Participated in gathering business and functional requirements details during business meetings and translated them into program specification documents .
• Developed load rules for loading data files and for dimension build and implemented data-access security and user management .
• Prepared ETL design document and deployment documents.
• Utilized Informatica PowerCenter for ETL
• Used complex queries and stored procedures to create reports.
• Created and maintained the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and adding users to the groups.
• Wrote calculation scripts and business rules to perform allocations based on different drivers.
• Involved in database and security refreshes in Hyperion Planning .
• Participated in optimization of the cube by analysing and modifying various aspects such as dense/sparse configuration, modifying member storage properties etc.
• Utilized FDMEE to integrate Hyperion to source system.
• Participated in the planning and execution of integration test, system test, and user acceptance test activities, including developing and documenting test plans. Involved in documentation on all Hyperion Planning processes for all business groups and technical documentation on business rules and calc scripts

Hyperion Consultant

Confidential, Pittsburgh, PA

Responsibilities:

• Built metadata using outline load utility and developed load rules to load data into the application.
• EPM Hyperion Full cycle implementation.
• Used DRM (Data Relationship Management) to manage organization’s metadata.
• Wrote SQL scripts for retrieving the data.
• Involved in gathering business requirements.
• Worked with different sources such as Oracle, MS SQL Server, flat files and others. Import data from various Sources, transformed and loaded into Data Warehouse Targets using informatica.
• Designed the Planning Process using the Hyperion Planning Workflow .
• Developed Reports using Financial Reporting against both Essbase and Planning data sources.
• Created input control mappings to validate the flat files being sourced from Mainframes using Power Exchange Navigator
• Wrote SQL queries and stored procedures to query the database and create reports
• Utilized FDMEE to integrate Hyperion to source system.
• Developed the security matrix and security model for Shared Services provisioning in consultation with the client.
• Developed Reports using Financial Reporting against both Essbase and Planning data sources.