SKILLS SUMMARY:

• About 8+ years of diverse experience in Information Technology with emphasis on Business Intelligence & OLAP tools.
• Experience in OLAP design, analysis, architecture, development, implementation, reporting and administration using Hyperion Essbase, Hyperion Financial Management, Hyperion Planning, DRM/DRG, FDMEE, Hyperion Essbase Integration Services, Hyperion Reports, Oracle PeopleSoft, SAP Business Objects and Excel Spread Sheet Add - in under Windows environments.
• Trained users and created documentation for end client users to understand various Hyperion Financial Management processes.
• Good Knowledge of Hyperion Versions 11.x & 9.3.3 Hyperion Essbase and Planning & SAS Enterprise Miner 6.3.
• Experience in Hyperion Planning 11.3.1/9.3.3to support complex financial applications for budgeting and Forecasting.
• Web Forms/Data Forms creation in Hyperion Planning for users to input forecast, budget, actual, accounting changes and other data.
• Developed Hyperion Essbase cubes using Block/Aggregate storage technologies (BSO/ASO).
• Proficient in dynamically building Dimensions, Attributes using rule files and loading Fact data in an Essbase Applications by means of several build methods such as generation, level and parent-child references.
• Hands on Experience in calculation scripts (creation, Manipulation and maintenance).
• Performed several Administrative tasks like installing and troubleshooting of Hyperion Essbase Administrative services, Shared Services and Planning on server machines.
• Skilled in automation, optimization and performance tuning of Hyperion Essbase application data metadata processing, upgrading, testing and migrating cubes in different Hyperion applications.
• Experience in performing Migration between different Environments and in Upgrade between different Versions.
• Expertise in Hyperion Essbase security features and ability to create user and group profiles for assigning proper privileges using both Native security and Shared services modes.
• Created customized Financial Reports using different tools of Hyperion like Hyperion Interactive Reporting Studio, Hyperion Financial Reporting Studio according to the Client requirements.
• Skilled in automation, optimization and performance tuning of Essbase application data, metadata processing, upgrading, testing and migrating cubes in different Hyperion applications.
• Involved in Automation of Hyperion Essbase cubes using MaxL, Esscmd, MDX, Batch and Shell scripts.
• Expertise with building models based on neural networks and decision trees, analyzing data and generating reports using SAS Enterprise Miner 6.3.
• Knowledge of integrating Microsoft Office tools with OLAP server.
• Highly developed ability to implement technology based solutions for business problems and to maximize productivity through cost reduction and improved efficiencies.
• Deep expertise in various Oracle EPMA technologies and areas such as Hyperion Essbase 11.1.2.x, 11.1.1.x, 9.x, Planning, Public Sector Planning (PSPB), Workforce & Capex Planning, Workspace, Shared Services,Hyperion Interactive Reporting, Financial Reporting Studio, FDQM, MaxL, MDX, ODI, Excel Add-in, Smart View on Windows environment.
• Built Metadata and customized HFM Rules in line with business’s functional and performance requirements.
• Customized Member Lists in line with the Metadata modification.
• Ran Extended Analytics to generate data sets as per requirement from the client.
• Copied data from Actual scenario to various other scenarios using a custom built taskflows.
• Used Process Control to lock and unlock entities for user input at the start and end of each month.
• Performed data Consolidation
• Modified reports using Hyperion Financial Reporting Studio and prepared financial reports using Smart View as per client requirements.
• Used HFM Admin Utility to perform various admin functions ranging from Database Management to extracting and loading of Metadata, Rules & Member Lists.
• Modified various data forms to manually add consolidated accounts to the Hyperion Financial Management System for user data input.

TECHNICAL SKILLS:

OLAP Tools: Hyperion version 11.x Product suite, Hyperion System 9 BI+(Analytic Administration Services), Hyperion Essbase 11.x/9.x/7.x, EAS 7.0, EIS 9.x/7.x, Hyperion Planning 11.x/9.x, Hyperion Shared Services 11.x/9.x, Hyperion Financial Management 11.x/9.x, Essbase Integration Services, Excel Spread sheet Add-in, Smart view, ESSCMD, MaxL and MDX, SAS Enterprise Miner 6.3, Oracle PeopleSoft 9.x

Reporting Tools: Hyperion Interactive Reporting, Financial Reporting Studio, Excel Spreadsheet Add-in and Hyperion Smart view, Hyperion Admin Utility SAP Business Objects

Databases: Oracle 9i/8i, MS-Access, SQL Server

Dimensional Modeling: Star-schema Modeling, Snow-flake Modeling, Fact and Dimension Tables, Physical and Logical data Modeling, Erwin 4.0.

Programming languages: SQL, PL/SQL

Operating Systems: Windows, Macintosh

PROFESSIONAL EXPERIENCE

Confidential, IL

HFM/FDMEE/DRM/EPMA Consultant

Responsibilities:

• Maintain and manage three Hyperion applications related to HFM, Reporting and Planning.
• Support the Hyperion, Accounting and FP&A team with the monthly close process.
• Create taskflows using the Consolidation Administration functionality in Hyperion Workspace.
• Commit to monthly metadata and mapping change requests in DRG using the DRM web client.
• Create new mappings and change existing mappings in FDMEE.
• Generated a file containing dimension hierarchies using HFM Toolbox
• Used Application Library in Hyperion Workspace to import applications during the close period.
• Compared, Validated and Deployed the applications using Dimension Library in Hyperion Workspace.
• Generated and updated the changes log on a timely basis to keep track of the changes that have taken place in the Hyperion system during the month end close period.
• Generated the mapping logs on a timely basis to track the mapping changes in FDMEE during the month end close period.
• Calculated and consolidated various applications using taskflows and grids in Prod and UAT.
• Created a file using the changes and the mapping logs for running the EBS updates.
• Validated and tied out the data using Smartview after every month end close periods for both Prod and UAT.
• Created Action Scripts and loaded it to DRM for making bulk changes in the Hyperion system.
• Troubleshoot user issues related to mappings during the monthly close period.
• Analyze the criteria related to kick outs or variances in data during the month end accounting push period using the auto generated error log provided by the system.

Environment: Hyperion Financial Management 11.2.x, Hyperion Essbase 11.2.x, Oracle DRM/DRG, FDMEE, Hyperion Financial Reporting Studio, Workspace, Shared Services, Calc Script, HFM Toolbox, Business Rules, SmartView.

Confidential, Greensboro, NC

Hyperion Techno Functional Consultant

Responsibilities:

• Provided the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and then adding users to the groups.
• Created web forms in Hyperion planning for users to input forecast, working data and accounting changes and other variance data.
• Developed HBR (Hyperion Business Rules) with 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.
• Involved in the development of calc scripts, rules files for loading budget and actual data to the Essbase cube.
• Involved in the development of various variance reports and regional reports using the Hyperion Financial Reporting Studio and adhoc reports using SmartView.
• 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, maintenance of the application in sync across various environments by migrating the artifacts using LCM utility, production support thereby troubleshooting user issues.
• Create the test environment ready for Budget application during the budgeting period from Aug-Sep
• Perform various pre forecast tasks every month ranging from business day 1 to business day 18.
• Provide security to access the application to the users.
• Perform analysis on various files related to budget and forecast and give inputs on how the process can be made better and efficient.
• Create mass user security update file for the application so that the unwanted access can be eliminated and the user security can be optimized.
• Create documentation regarding the different processes that can be performed using the Hyperion Planning application.
• Monitor the daily outline maintenance and application security processes and notify the technical maintenance team about any discrepancies if any.
• Provide amicable solutions to the end user on their technical problems related to the Hyperion applications.
• Create glossaries regarding the business rules, calc scripts and load rules so that the end user can understand the different kinds of commands used in the Essbase and Planning application.
• Generate a user security report and various reports using SAP Business Objects and perform analysis on those reports based on the requirement of the client.
• Use Oracle PeopleSoft 9.x to run various processes based on the checklist and requirement for the monthly Forecast tasks and yearly Budgeting tasks.
• Compare the hierarchies between PeopleSoft and Hyperion and notify the technical maintenance team about the differences if any.
• Manage the Essbase and Planning application and make sure that it’s running at the optimum level at all times by constantly bridging the communication gap between the functional and technical team.
• Validate various data files related to the Forecast and Budget applications using Hyperion Smartview.
• Manage the various Web Forms in Hyperion Planning and change the POV or add fields to it as per the client requirement.
• Analyze the data from the application using Web Forms for various Forecast and Budgeting tasks.
• Make sure the pre -budget tasks and updates to the documents are completed before the budget season starts.

Environment: Hyperion Essbase 11.2.x, Hyperion Planning 11.2.x, Hyperion Financial Reporting Studio, Workspace, Shared Services, Hyperion Planning11.1.1.2/ 9.3.1, Oracle Peopleoft, SAP Business Objects Calc Script, Business Rules, ESSCMD, SmartView.

Confidential, Dallas, TX

Hyperion Consultant/Admin

Responsibilities:

• Involved in design and development of two cubes, one for budgeting and planning and the other for customer analysis.
• Provided security for business users.
• Provided with up to date maintenance of applications and databases on daily basis.
• Helped the team with creating reports using financial reporting studio and smartview.
• Updated business rules in the system on a timely basis to suite the requirement of corporate finance.
• Creating and modifying Hyperion Planning Web forms.
• Used Capex and Workforce planning to aggregate and have a better understanding of headcount to capital expenditure ratio and advise the head of corporate finance on important cost cutting measures.
• As a part of team developed the Essbase outlines, member formulas and data load rules for the Planning Application.
• 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 seat, return on assets, properties, plants and equipments, cash cost per passenger 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.
• Designed the cubes and worked with Attribute dimensions.
• Developed both ASO and BSO applications depending on the requirement of the application.
• 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, the global access layer and the server level.
• Created security filters and assigned them to users depending on responsibilities and tasks.
• Involved in troubleshooting and production support.

Environment: Hyperion Essbase 11.2.x, Hyperion Planning 11.2.x, Hyperion Financial Reporting Studio, Workspace, Shared Services, Hyperion Planning11.1.1.2/ 9.3.1, Hyperion Admin Utility, Calc Script, ESSCMD, MaxL, SQL

Confidential, Joliet, IL

Hyperion Financial Management Admin

Responsibilities:

• Helped the company create and implement HFM application.
• Designed new rule files to optimize the data load process.
• Participated in extracting from SAP Business Objects and loading the data into the HFM applications and calculating data with business rules.
• Taught users how to use Hyperion Smartview and other end-user products more efficiently.
• Extracted data as per client requirements by creating reports from SAP Business Objects
• Consolidate scenarios from time to time to keep the scenarios up to date with the current data entered by using the reports from SAP Business Objects.
• Created security groups and assigned security to users using Hyperion Shared services.
• Troubleshoot the problems faced while implementing the HFM application and provided them with solutions and suggestions with regards to using the Hyperion Financial system.
• Extract metadata, member lists and rules file from the Hyperion system using the Hyperion Admin Utility and modify the extracted data as per the requirement provided by the client in the system change form and then load those modified files in the system back again.
• Modifying, building and adding new entities, accounts and scenarios as per the requirements provided in the system change form provided by the client.
• Opening up parents and base entities specific future period during the last week of the month for the financial reporting team to input data in that period using the process called 'Process Control'.
• Locking up the base entities using 'Process Control' after the financial reporting team notifies that the data input for the month is over.
• Copying over data from the Actual scenario to various other scenarios using a fixed and defined taskflow after the entities are locked for the month.
• Create Ad-Hoc reports using Excel Smartview.
• Validate data by using VLookup formulas and Pivot tables.

Environment:Hyperion Financial Management 11.x Hyperion Admin Utility, Excel Spreadsheet Add-in, Hyperion Financial Reporting Studio, Hyperion Workspace, SAP Business Objects Planning & Consolidation.

Confidential, Lisle, IL

Hyperion Financial Management Admin

Responsibilities:

• Maintained and managed HFM applications of the company called TRAIN (development) and Confidential (production).
• Modified existing rule files and designed new ones to optimize the data load process.
• Participated in extracting and loading the data into applications and calculating data with business rules.
• Taught users how to use Hyperion Smartview and other end-user products more efficiently.
• Extract data as per client requirement from Hyperion Workspace using Extended Analytics.
• Create new Financial Reports using Hyperion SmartView and also maintain the existing reports by making changes as per requirement from the client using Financial Reporting Studio.
• Created security groups and assigned security to users using Hyperion Shared services.
• Consolidate various scenarios from time to time to keep the scenarios up to date with the current data entered by the users.
• Troubleshoot the problems faced by the users at different company locations around the world and provide them with solutions and suggestions with regards to using the Hyperion Financial system.
• Extract metadata, member lists and rules file from the Hyperion system using the Hyperion Admin Utility and modify the extracted data as per the requirement provided by the client in the system change form and then load those modified files in the system back again.
• Modifying, building and adding new entities, accounts and scenarios as per the requirements provided in the system change form provided by the client.
• Opening up parents and base entities specific future period during the last week of the month for the financial reporting team to input data in that period using the process called 'Process Control'.
• Locking up the base entities using 'Process Control' after the financial reporting team notifies that the data input for the month is over.
• Copying over data from the Actual scenario to various other scenarios using a fixed and defined taskflow after the entities are locked for the month.
• Write queries in MS SQL to extract data from the HFM database for the BPC team, append data to the tables in the HFM database and run the stored procedures to generate data from the MS SQL database.
• Create Ad-Hoc reports using Excel Smartview.
• Validate data by using VLookup formulas and Pivot tables.
• Help the BPC team to migrate data from HFM to BPC using a mix of HFM & MS SQL.

Environment:Hyperion Financial Management 9.3.3 Hyperion Admin Utility, Excel Spreadsheet Add-in, Hyperion Financial Reporting Studio, Hyperion Workspace, SAP Business Objects Planning & Consolidation, SQL Server 2012.

Confidential, Hoffman Estates, IL

Hyperion Consultant/Admin

Responsibilities:

• Involved in requirement gathering and created weekly, monthly & quarterly reports using Financial Reporting Studio from Planning Application.
• Wrote complex calc scripts to run the automated data loading process.
• Worked on Hyperion Planning 11.1.1.2/11.1.1.3 to support complex financial applications for budgeting and Forecasting
• Created and registered Planning applications in Hyperion Workspace.
• Created Users, Groups, Filters and assigned different levels of Security Access to users in Hyperion Planning.
• Created customized Financial Reports using different tools of Hyperion like Hyperion Interactive Reporting Studio, Hyperion Financial Reporting Studio according to the Client requirements.
• Provided security for business users.
• Provided with up to date maintenance of applications and databases on daily basis.
• Helped the team with creating reports using financial reporting studio and smartview.
• Updated business rules in the system on a timely basis to suite the requirement of corporate finance.
• Developed Data Forms and folders and customized data forms.
• Developed Rules Files to load data to Essbase cube.
• Developed Task Lists.
• Developed Business Rules including the use of Run-time prompts.
• Installation and Configuration of the Development server consisting of Hyperion System 11 Essbase, Hyperion Planning, Hyperion Shared Services, Oracle Data Integrator, Financial Reports, Web Analysis and Workspace.
• Used Classic administration and EPMA environment to create planning cubes with dimension library, application library by importing GL information from ETL processed data mart.
• Created and executed calculation scripts for automation of shipment calculation, actual and forecasting data.
• Participated in Optimization of the cube by analyzing and modifying various aspects such as dense/sparse configuration, modifying member storage properties etc.
• Created and scheduled Batch Jobs for complete automation processes for application refresh and backup.
• Automated the process of loading data in financial applications using CTRL M scheduler.
• Involved in documentation on all Hyperion Planning processes for all business groups and technical documentation on business rules and calc scripts.
• Expertise in working on SQL with databases like Oracle 11g, MS SQL Server 2005/2000.
• Performed data loads using Hyperion Admin Utility.
• Copied data from Actual scenario to various other forecast scenarios at the close of each month using data grids and Admin utility
• Set up a 10 step taskflow in Workspace to automate the data copy process.
• Used Hyperion Admin Utility/Workspace to extract, modify and load metadata, rules & member Lists and also build/modify the security class of accounts, entities and scenarios.
• Used Extended Analytics in Workspace to generate subsets of data for data testing purposes.
• Unlocked and locked entities for user input each month using a data process in Workspace called ‘Process Control’.

Environment: Hyperion Financial Management (HFM) 11.1.1.2/9.3.3, Hyperion Essbase 11.1.1.2/9.3.1, Hyperion Financial Reporting Studio, Workspace, Shared Services, Hyperion Planning11.1.1.2/ 9.3.1, Hyperion Admin Utility, Calc Script, ESSCMD, MaxL, SQL

Confidential, Lisle, IL

Hyperion Consultant/Admin

Responsibilities:

• Provided support for Financial Reporting Close Processing Essbase applications for Confidential which was used by the company for internal reporting purposes
• Daily monitored batch jobs that built and loaded Essbase cubes and insured that cubes were available to the users.
• Provided security for business users.
• Provided with up to date maintenance of applications and databases on daily basis.
• Helped the team with creating reports using financial reporting studio and smartview.
• Updated business rules in the system on a timely basis to suite the requirement of corporate finance.
• Setup monthly forecast scenarios in Essbase for financial analysts to forecast data.
• Resolved tickets to help troubleshoot the open issues that users encounter.
• Provided support for Confidential ’s Hyperion Profitability and Cost Management application that provided a breakout of the income statement by model, plant and place for Truck Division internal management reporting.
• Created financial reports using Financial Reporting Studio based on the business users requirements.
• Installed software patches quarterly to address the bug fixes.
• Developed Business Rules including the use of Run-time prompts.
• Worked on Hyperion Planning 11.1.1.2/9.3.3 to support complex financial applications for budgeting and Forecasting
• Configured Data Sources through Hyperion Configuration Utility.
• Developed batch scripts to automate data loads.
• Created and executed calculation scripts for automation of shipment calculation, actual and forecasting data.
• Created and scheduled Batch Jobs for complete automation processes for application refresh and backup.
• Involved in documentation on all Hyperion Planning processes for all business groups and technical documentation on business rules and calc scripts.
• Assisted with the development of Hyperion Planning for P&L and Workforce Planning.
• Installed and configured the server consisting of Hyperion System Essbase, Hyperion Planning, Hyperion Shared Services, Financial Reports and Workspace.
• Generated reports such as PNL, Balance sheets, Trial balance, Revenue and Expenses using Financial Reporting Studio.

Environment:Oracle Essbase 11.1.1.2/9.3.3, Hyperion Planning 11.1.1.2/9.3.3, Excel Spreadsheet Add-in, Oracle Hyperion Financial Reporting, Hyperion Workspace, Windows 2003 Server, SQL Server 2005.

Confidential

Hyperion Planning 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.
• Use public sector planning and budgeting to integrate human resources and ERP financials derived from Hyperion Financial management suite
• Developed and managed new planning applications called Workforce Capital Planning and General Ledger Planning in public sector planning.
• 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 Finplan application and load FTE’S, and pay grades into workforce application.
• 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.
• Performed knowledge transfer to the financial users regarding how to use data forms for the budgeting and workflow process.
• Maintain security by creating, managing, and assigning provisions to the users in the shared services.
• Develop customized Financial Reports using Hyperion Financial Reporting Studio and Smartview according to the Client requirements.
• Perform various Administrative tasks such as installation and configuration of several Hyperion Products, server settings, backups & disaster recovery, client installations of Excel Add-in, Smartview and Financial Reporting.
• Perform Migration of applications and its artifacts between different Environments.
• Automation of daily tasks through MaxL and Batch scripts.
• Participate in weekly meetings with financial users and IT Department to address any issues and queries.
• Interacted with users to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• As a Hyperion Administrator involved in Installation and Configuration of Hyperion 9.3.3 system consisting of Planning, Essbase and Financial Reporting Studio, Shared services and Workspace.
• Provided the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and then adding users to the groups.
• Created web forms in Hyperion planning for users to input forecast, working data and accounting changes and other variance data.
• Developed HBR (Hyperion Business Rules) with 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.
• Involved in the development of calc scripts, rules files for loading budget and actual data to the Essbase cube.
• Involved in the development of various variance reports and regional reports using the Hyperion Financial Reporting Studio and adhoc reports using SmartView.
• 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, maintenance of the application in sync across various environments by migrating the artifacts using LCM utility, production support thereby troubleshooting user issues.

Environment: Hyperion Essbase 9.3.3, Hyperion planning 9.3.3, Hyperion Financial reports 9.3.3, Smart view, Essbase excel add in, Essbase Administrative Services, Hyperion Shared Services 9.3.3, Hyperion Workspace 9.3.3, and Windows 2003.