SUMMARY

• IT Professional with 7+ years in Oracle Hyperion Business Intelligence Application Development, Deployment and Support, involved in all stages of the application development life cycle.
• Worked on various Hyperion products such as usingHyperion 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, EPM and OLAP applications with Hyperion planning.
• Experience in Data Forms/Web Forms, Business Rules, Task Lists, Menus, User Variables, Smart Lists.
• Experience in installation and configuration of Hyperion products such as Essbase Administrative services, Hyperion Planning, Hyperion Reports, Shared services, Integration Services, Oracle data integrator, ERPI.
• Worked on both Hyperion 9 and Hyperion 11.
• Experience in planning and designing multi-dimensional cubes using both ASO and BSO options while leveraging important design considerations such as storage options, member properties, dense/sparse dimensions, hardware requirements, data sources etc.
• Experience in dynamically building dimensions, Attributes using Rule files and loading Fact Data in an Essbase application by means of several build methods such as Generation, Level and Parent child references.
• Acquired a broad understanding of database calculations such as implementing formulas on dimension members, dynamic calculations, developing calculation scripts and ESSCMD.
• Expertise in Essbase cube analysis, design and maintenance, Essbase database administration upgrades, performance tuning and optimization.
• Expertise in Developing and Deploying Cubes using various dimension build and data load methods, automation of data loads using MAXL batch scripts.
• Used ODIto load Metadata values, accounts, entities and custom dimensions from flat file and SQL into Hyperion Planning.
• Skilled in automation, optimization and performance tuning of Essbase application data metadata processing.
• Acquired a broad understanding of database calculations such as implementing formulas on dimension members, dynamic calculations, developing calculation scripts.
• Understanding of Essbase security features and ability to create user and group profiles and assign proper privileges.
• Experience in performing Migration between different environments and upgrade between different versions including Life Cycle Management utility in Version 11.
• Created customized Financial Reports using different tools of Hyperion like Hyperion Interactive Reporting Studio, Hyperion Financial Reporting Studio according to the Client requirements.
• Expertise in loading data using Oracle Data Integrator (ODI), and Outline Load Utility and Essbase Rule File.
• Expertise in Essbase cube analysis, design and maintenance, Essbase database administration upgrades, performance tuning and optimization.
• Complete understanding of Database Design Life Cycle.
• Involving to creating the disaster recovery for all Hyperion systems

TECHNICAL SKILLS

OLAP: Hyperion Essbase 11.1.x/9.3.x/7.1.x/ Hyperion Planning 11.1.1.3 / 9.3. x/4.x/Hyperion Shared Services 11.1.x/9.3.x/Essbase Integration Services 11.x Hyperion System 9/11 BI Oracle Data Integrator (ODI)

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

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

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

Operating Systems: Windows 2000/XP/NT Unix/Linux

PROFESSIONAL EXPERIENCE

Confidential, PA

Sr. Hyperion Consultant

Responsibilities:

• Worked on Hyperion budgeting and forecasting solution to integrate financial and operational planning processes and improve business predictability.
• Build an efficient and optimized Hyperion cube and train members for support.
• Created a new planning application, which will overtake the present budget application.
• Worked with financial users to understand the functionality and to identify the outline structure to build a cube.
• Loaded monthly actuals and forecasting data into PSFinMgmt application and load FTE’S, and pay grades into salaries application.
• Build reports using Financial Reporting Studio for different end-users, including Financial Users, Sales Managers, Actuaries, and Cost-Center Administrators.
• Created different data forms like input forms, what-if forms, and composite forms required for budgeting and forecasting.
• Wrote calculation scripts or business rules to perform cost allocation based on different drivers.
• Implemented and Deployed ASO Cube for Archiving and Reporting to Business users.
• Used Essbase Administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.
• Performed knowledge transfer to the financial users regarding how to use data forms for the budgeting process.
• Maintain security by creating, managing, and assigning provisions to the users in the shared services.
• Participated in meetings with financial users and IT Department if any issues arise regarding Hyperion.
• Extensively involved in Installation, Configuration, Server settings, Backups and Client installations of Hyperion products such as Essbase, Hyperion Planning, Hyperion Financial Report, Essbase Integration Services, Analyzer, Hyperion Financial Management and Financial Data Quality Management.

Environment: Hyperion System 11.1.2.3, Hyperion Essbase Administrative Services, Hyperion Financial Reporting Studio 11.1.2.3, Hyperion Planning 11.1.2.3, Hyperion Shared Services 11.1.2.3, Hyperion Web Analysis, Oracle, Smart view Add-in, on Windows Platform.

Confidential, NJ

Hyperion Planning Consultant

Responsibilities:

• Actively participated in gathering requirements, functional specifications, design documentations and test strategies.
• Supported application in Hyperion Planning, Hyperion Essbase, and Financial reporting studio for the end users.
• Successfully migrating all Hyperion Business rules to calcmanager.
• Hands on expertise in Business Rules, Smartlist, and Tasklist in Hyperion Planning.
• Designed, developed and implemented the Planning and reporting system for the financial department.
• Participated in the creation and migration of numerous Planning Applications to newer versions of Essbase.
• Maintained and updated Essbase and Planning Applications as per user and business requirements.
• Linked Hyperion financial reporting to Essbase as well as planning and created many reports to meet users’ needs.
• Created and managed numerous Web Forms and created Business Rules for multiple applications.
• Migrated Web Forms from one server to another and from one application to another using LCM.
• Used various types of Calculations such as Dynamic Calc, Two-Pass Calc and Intelligent Calc for Application Outlines.
• Designed and developed numerous Essbase Applications with excellent balance of Dense and Sparse dimensions, arranged in an hourglass Model.
• Extensively involved in designing, developing and modifyingOutlinesby grouping and positioning.
• Involved in creating Rule files for dimension building and data load process and created scripts in MAXL for automating these processes.
• Designed and supported data integration using Oracle Data Integrator (ODI) by setting up sources and targets using ODI Topology Manager, creating Designer models, developing integration interfaces and additional components
• Extensively working on Database optimization and performance tuning of Essbase Cubes for fast retrieval and calculation performance.
• Developed Data Loads and numerous Calc Scripts and optimized them.
• Generated reports relating to Income statement and Balance sheet using Financial Reporting.
• Assigned accesses and privileges to various end users in different planning applications using Shared Services.
• Providing training to end users in MS Excel spreadsheet Add-In and Web Forms to enter data.
• Actively troubleshooting all Hyperion installation and configuration issues.

Environment: Hyperion System 11.1.1.3, Hyperion Essbase Administrative Services, Hyperion Financial Reporting Studio 11.1.1.3, Hyperion Planning 11.1.1.3, Hyperion Shared Services 11.1.1.3, Hyperion Web Analysis, Oracle, Smartview Add-in on Windows Platform

Confidential, NJ

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 training to end users so they can create their own reports using web analysis studio

Environment: Hyperion Planning 11.x/9.3.1, Hyperion Workforce Planning, Shared services, Workspace, HFR, Hyperion Essbase 11.x/9.3.1, EIS, Oracle 11i, Calc Scripts, Maxl, VBA, Smart view, enterprise reporting, Unix, Solaris.

Confidential, NJ

Hyperion Developer

Responsibilities:

• Defined and developed Load rules, Functions, Report Scripts to perform cube build and data load.
• Created and executed calculation scripts.
• Design and creation of ASO / BSO cubes for OLAP in Hyperion Essbase.
• Developed ESSCMD scripts for Dimension Build and Data Load processes.
• Developed load rules for loading data files and for dimension build.
• Optimized Data Loads and Calc Scripts.
• Implemented robust data-access security and user management.
• Created various filters as per user requirements in EAS.
• Automating of cube refresh through MaxL and UNIX scripts.
• Restructured as well as maintained existing Essbase cubes.
• Optimized the applications to bring down the runtime considerably.

Environment: Hyperion Essbase 9.3, Hyperion planning 9.3, HFR, Spreadsheet Add-in, MaxL