Objective

• Seeking a challenging position through which my complete skills and passion for excellence will be utilized and would provide me an opportunity to utilize my professional experience and my domain knowledge in Oracle Hyperion.

SUMMARY

• 8 years of diverse experience in Information Technology with emphasis on Business Intelligence, RDBMS, Enterprise Performance Management & OLAP tools.
• Experience in Hyperion Essbase, Hyperion Planning, Hyperion Financial Reporting, Interactive Reporting, Hyperion Workspace, Hyperion Shared Services, Essbase Integration Services and Excel Spread Sheet Add - in under different environments.
• Excellent knowledge of building Financial Budgeting & Forecasting, EPM and OLAP applications using Oracle Hyperion Planning.
• Extensive experience in creating, maintaining, and supporting all application objects including outlines, calculation scripts, rules files for dimension builds and data loads, transparent partitions, and security objects through both Essbase Administration Services (EAS) and MaxL scripts; also involved in automation of these procedures using batch scripts.
• Experience in optimization and performance tuning of Essbase application data, upgrading, testing and migrating cubes in different Hyperion applications.
• Expertise in managing security for Planning & Essbase applications and ability to create user and group profiles for assigning proper privileges using both Native security and Shared services modes.
• Expertise in analyzing metadata and building Dimensions viz Generation, Level, Parent and Child preferences and loading fact data using Rule files..
• Expertise in writing custom Essbase Calculation scripts & Member formulas using MDX.
• Designed and developed numerous Essbase applications with excellent balance in dense and sparse dimensions, various OLAP models and meta-outlines across Block/Aggregate storage and partitioning.
• Worked on Work Force & Capex plan types of planning.
• Experience in performing migration between different environments and in upgrade between different versions including Life Cycle Management.
• Performed several administrative tasks like installing and configuring of Hyperion Essbase, Hyperion Planning, Hyperion Shared Services, Hyperion Reporting and Hyperion Workspace on client and server machines.
• Experience and proficiency in multiple Oracle Hyperion installations, configurations for v7, 9.3.1, 11.1.2, 11.1.2.1 and 11.1.2.2 for Shared Services, Essbase, HFM, Planning, Financial Data Quality Management (FDM), Interactive Reportiing (IR) &Financial Reporting(FR).
• Expertise in migration/upgrade from v9.0 to v9.3.1 and from Development to production servers.
• Complete understanding of Database Design Life Cycle.
• Strong SQL knowledge and familiar with creating queries, tables, relational references and also experience maintaining the referential and data integrity.
• Proficient in gathering end users requirements and documentation.
• Excellent analytical and logical skills with a good understanding with excellent presentation, communication and interpersonal skills.

TECHNICAL SKILLS

OLAP Tools: Hyperion Version 7.1.2/9.3.1.2/11.1.1.1/11.1.1.2/11.1.1.3/11.1.2.2 Product Suite, Hyperion Analytic Administration Services, Hyperion Planning System, Hyperion Shared Services, Hyperion Essbase, Smart View, Essbase Excel Add In, ESSCMD, MaxL, MDX, Hyperion Reports, Hyperion Financial Reporting Studio

Reporting Tools: Hyperion Financial Reporting Studio, Hyperion Reports, Web Analysis, Hyperion Spreadsheet Add-in, Hyperion Smart View.

Operating Systems: Windows 95/98/2000/NT/XP, UNIX.

Data bases: Oracle 11g, MS-Access, SQL Server.

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Hyperion Admin/Developer

Responsibilities:

• Involved in Installation and Re-configuration of Hyperion 11.1.2.1 system consisting of Hyperion
• Essbase, Hyperion Planning, Hyperion Shared Services, Web Analysis and Workspace.
• Performed application migration using Migration Wizard from one environment to another.
• Successfully migrated Essbase ASO/BSO and Planning applications and registered into new environment.
• Worked extensively on Budget process and Budget Administrative tasks.
• Created Batch scripts/Crons for building dimensions dynamically and load data into cubes and scheduled to process on a periodic basis.
• Created Shell scripts to manage/control and monitor windows services related to Hyperion.
• Created MaxL scripts for Automation of key processes.
• Developed Hyperion Business Rules including the use of run-time prompts for realizing various business functionalities like creating a project, enter the planned amount for the project and consolidating to the upper level of the hierarchy.
• Developed Calc scripts, Rules files for loading budget and actual data to the Essbase cube.
• Involved in performance tuning to minimize data load and calculation time using the dense/sparse settings and developed the required alternate rollups for reports.
• Experience on Data Source Configuration through Hyperion Configuration Utility in Hyperion Foundation Services.
• Provided the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and other related administrative tasks.
• Responsible for performance monitoring and disaster recovery(DR).
• Responsible for the automation of nightly backups, extraction of data and loading data.
• Performed monthly maintenance of the hierarchy by loading the hierarchy using the Outline load utility.
• Expertise in maintenance of the application in sync across various environments by migrating the artifacts using LCM utility, production support thereby troubleshooting user issues.

Environment: Oracle EPM 11.1.2.1, Hyperion Essbase, Hyperion Planning, Interactive Reporting Studio, Excel Add-In

Confidential - Chandler, AZ

Hyperion Consultant

Responsibilities:

• Designed BSO application for the purpose of Gross Margin and Commissions planning and a separate ASO application for regulatory reporting, variance analysis and archiving process which also supports annual budget.
• 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.
• Established a workflow process to keep track of the plan, review the plan, and change the ownership and status of the planning unit.
• 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.
• Automated Task Lists to guide the planning users through a several sets of web forms, calculations, business rules, etc. required to complete the plan cycle.
• Designed a replicated partition to transfer a portion of data from one cube to another, which significantly increase the performance for the excel-retrievals.
• Implementedvarious types of calculations such asDynamic & Two-Pass,Member formulas, UDA’s, attributes and XREF functions for calculations.
• Created MaxL and batch scripts to automate process of updating cubes on a daily basis.
• Performed regular Backups of the cube and archiving it.
• Created Data export Calc and Report Scripts for the purpose of exporting specific set of data from the cubes.
• Created customized Financial Reports using Hyperion Financial Reporting Studio according to the finance user's requirements.These reports included Budget vs. Actual, Budget vs. Forecast and Forecast vs. Actual reporting capabilities. Also, automated the entire process of pushing reports by sending them automatically on a particular business day.
• 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.
• Also worked on resolving tickets that are opened by the end-users to support the Hyperion products.

Environment: Oracle EPM 11.1.2.2, Hyperion Essbase, Hyperion Planning, Financial Reporting Studio, Hyperion Smart View, Oracle 11g, PL/SQL.

Confidential - Detroit, MI

Hyperion Admin/Developer

Responsibilities:

• Participated in gathering business and functional Requirement details during business meetings and translated them into program specification documents.
• Designed and developed numerous Essbase applications with excellent balance in dense and sparse dimensions, various OLAP models and meta-outlines acrossBlock/Aggregate storage and Partitioning.
• Involved inproduction supportandmaintenanceof existing cubes.
• Developed Calc Scripts for calculate values like Hourly Wages, Depreciation, Benefits and Revenue.
• Participated inOptimizationof the cube by analyzing and modifying various aspects such as dense/sparse configuration, modifying member storage properties etc.
• Expertise in Developing and Deploying Cubes using various dimension build and data load methods, automation of data loads usingMaxL batch scripts
• Provided the user provisioning by configuring user Active Directories to shared services and creating groups, assigning roles and then adding users to the groups.
• Worked on migrating old applications from v.9.1.5 to 11.1.1.3, also optimized existing applications for optimal performance.
• Developed and createdWeb formsfor users to input the data into ESSBASE cube throughHyperion Planning.
• Created applications includingCapexandWorkforceplan types ofPlanning.
• DevelopedHyperionBusiness Rulesto copy data from one version to another version using Run-time promptsforrealizing various business functionalities.
• Createdusers, groups,filtersand assigned different kinds ofsecurity accessto users in Hyperion Planning applications using Hyperion shared services.
• Involved in the development of various variance reports and regional reports using theHyperionFinancial Reporting Studioand ad-hoc reports usingSmart View.
• Created and scheduled batch jobs for complete automation processes for application refresh and backup.
• Developed SQL scripts used for running simple batch process.
• Involved in documentation on all Hyperion Planning processes for all business groups and technical documentation on business rules and calc scripts.

Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning,Financial Data Quality Management,Hyperion Financial Reporting, Hyperion Shared Services, Smart View,Hyperion Reports, Workspace, Essbase Administrative Services

Confidential - Hopkins, MN

Hyperion Administrator/Developer

Responsibilities:

• Interacted with users to gather business requirements to define, design, develop, test and deploy Hyperion Planning Applications.
• Involved in installation and configuration for entire Hyperion Suite(11.1.2)of products from scratch including architecture designing, environment setup and security levels setup.
• Involved in setting up automated disaster recovery and failover process for the projects.
• Manage and Oversee Tasks in Hyperion Essbase, Hyperion financial Reporting and Hyperion Planning.
• Automation of regular maintenance of Backup and Recovery of Hyperion applications.
• Involved in creating regulatory reports using Hyperion financial reporting tool.
• Created web forms in Hyperion planning for users to input forecast, working data and accounting changes and other variance data.
• Provided the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and then adding users to the groups.
• Developed Hyperion Business Rules including the use of run-time prompts for realizing various business functionalities like creating a project, enter the planned amount for the project and consolidating to the upper level of the hierarchy.
• Created different Essbase cubes depending upon the client requests.
• Involved in the development of calc scripts, rules files for loading budget and actual data to the Essbase cube.
• Worked on Budget Process and Budget Administrative Tasks using Task Lists.
• Involved in the development of various variance reports and regional reports using the Hyperion Financial Reporting Studio and Adhoc reports using Smart View.
• Involved in the automation of nightly backups, extraction of data and loading data.
• As an administrator, responsible for monthly maintenance of the hierarchy by loading the hierarchy using the Outline load utility.
• Expertise in maintenance of the application in sync across various environments by migrating the artifacts using LCM utility, production support thereby troubleshooting user issues.
• Worked closely with management and end-user to develop and enhance the application processes that will result in a stable productive environment.

Environment: Hyperion Essbase 11.1.1.2, Hyperion Planning, Hyperion Financial Reports, Essbase Excel Add in, Essbase Administrative Services, Hyperion Shared Services, Hyperion Workspace.

Confidential - Kansas City, MO

Hyperion Consultant

Responsibilities:

• Involved in design and development of two cubes, one for budgeting and planning and the other for customer analysis.
• Developed both ASO and BSO applications depending on the requirement of the application.
• Creating and modifying Hyperion Planning Web forms.
• As a part of team developed the Essbase outlines, member formulas and data load rules for the Planning Application.
• Experience in loading metadata in to 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, revenue per square foot, and return on assets, properties, plants and equipments, cash cost per user and YTD commitment and variance.
• Developed complex MDX formulas in income statement, balance sheet, debt analysis, cash flow and investment income moving dataacross different dimension members.
• Designed and developed several ad-hoc reports using Hyperion Analyzer and Hyperion Reports.
• Involved in performance tuning to minimize data load and calculation time using the dense/sparse settings and developed the required alternate rollups for reports.
• Responsible for performance monitoring, backup and recovery of the cubes.
• 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.

Environment: Hyperion Essbase 9, Hyperion Web Analysis, Hyperion Financial studio, Hyperion Planning, SQL, MS-Excel 2000 Spreadsheet Add-In, Windows NT 4.0, SQL Server 2000, MS SQL Server, Web Logic.

Confidential - Manhattan, NY

Hyperion Developer/Administrator

Responsibilities:

• Participated in the creation and migration of numerous planning applications to newer versions of Essbase.
• Designed and developed new aggregate storage and block storage cubes.
• Implemented transparent partitions to link databases and enable calculations.
• Developed MaxL scripts and rules files to work with all database objects including outlines, formulae, caches, and security profiles.
• Designed calculation scripts, and batch files to automate data load and other maintenance procedures.
• Performed client/server installations, setup, configuration, and upgrades of Hyperion Essbase as well as other Hyperion products including Excel Spreadsheet Add-in and Reports.
• Regularly monitored performance and carried out optimization and fine-tuning tasks; provided troubleshooting services and assistance to end-users in resolving errors.
• Created security filters and assigned them to users depending on responsibilities and tasks.
• Assisted with the design and implementation of reports, books, and forms.

Environment: Hyperion Essbase 9.2/9.3, Essbase Integration Services, Microsoft SQL2000 Client Tools - Enterprise Manager and Query Analyzer, Hyperion Essbase Spreadsheet Add-in, MS Windows XP Professional, Hyperion Financial Reporting, Hyperion Web Analysis and Oracle 10g.