SUMMARY

• Over 7 years of IT experience with emphasis on Oracle Hyperion Business Intelligence Application Development,Requirements Gathering, Design, Testing, Administration and implementation of OLAP and Client / Server projects using industry accepted methodologies and procedures and Support, involved in all stages of the application development life cycle.
• Deeply expertise inHyperion Essbase 11.1.2.3, 11.1.2.2; Hyperion Planning 9.3.1, Shared Services 9,Workforce & Capex Planning, Workspace, Hyperion Interactive Reporting, Financial Reporting Studio, MaxL, MDX, ODI, HFM, and FDM, Excel Add - in, Smart View on Windows and UNIX environments
• Experienced in design and maintenance of multidimensional cubes involving both BSO and ASO storage types and Partitioning.
• Experienced in development of Hyperion Planning applications with forms, business rules, menus, plans, and application migration as well as application management and troubleshooting.
• Created customized Financial Reports using different tools like Hyperion Interactive Reporting Studio, involved in build and unit test, Hyperion Financial Reporting Studio according to the client requirements.
• Worked on Hyperion Planning to createEAS applications, EAS security filters, modify existing and develop new database outlines, business rules, setting up dimensions, users, user groups and their security rights
• Carefully designed high performance outlines leveraging important design considerations such as storage options, member properties, dense/sparse dimensions, user management and security, formulas, hardware requirements, data sources etc.
• Proficient in dynamically building Dimensions outline, 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.
• Proficient in creation of complex Calc Scripts& Business Rules, Data Forms, Task Lists, Menus and Smart Lists.
• Experienced in design of Multi-Currency applications for large corporations operating in several countries.
• Experienced on complete SDLC of OLAP design, analysis, architecture, development, implementation, reporting and administration.
• Created customized Financial Reports using different tools of Hyperion like Hyperion Interactive Reporting, Hyperion Financial Reporting Studio and Smart-view according to the Client requirements.
• Extensive hands-on various Administrative tasks such as installation and configuration of several Hyperion Products, server settings, backups& disaster recovery &client installations of Excel Add-in, Smart view and Financial Reporting Client.
• Perform Patch Updates on several different products to fix the ongoing bugs/issues.
• Managed Essbase/Planning security to create users and groups for application access.
• Experience in performing Migration of applications and its artifacts between different Environments using Lifecycle Management Utility (LCM) utility.
• Resolved network issues as well as configured MSAD with Shared Services.
• Skilled in Optimization (optimize Essbase caches, restructuring, data loads, calculations and reports)and Performance Tuning of Essbase applications
• Automation of daily tasks through MaxL and Batch scripts.
• Experienced with Oracle Data Integrator for complex data loads and translations.

TECHNICAL SKILLS

OLAP Development Tools: Hyperion EPMA Suite 11.x, 9.x, Hyperion Essbase, EAS, Hyperion Planning, Hyperion Shared Services, Financial Management 11.1.1/9.x, FDM 11.1.1x, Workspace, FDQM, Excel Add-in, Smart view, ESSCMD, MaxL and MDX

Reporting Tools: Hyperion Interactive Reporting, Financial Reporting Studio, Excel Spreadsheet Add-in and Hyperion Smart view

Operating Systems: Windows 2000/2003/XP/NT, Windows Server 2003, MS-DOS

Databases: 9i/10g/11i, MS-Access, SQL Server 2000/2005/2008.

Other skills: Strong understanding of Business Intelligence Tools, OLAP tools, Budgeting, Forecasting and planningprocesses

PROFESSIONAL EXPERIENCE

Confidential, Brooklyn Park, MN

Responsibilities:

• Installation and Configuration and validation of the server consisting of Hyperion Essbase, Hyperion Planning, Hyperion Shared Services, Essbase Integrated Services, Financial Reports and Workspace
• Implemented Hyperion Essbase upgrade from v11.1.2.1 to v11.1.2.3 compatibility with IE10.
• Oracle Hyperion Planning and Essbase to provide the company with a fully integrated solution for financial modeling, budgeting, forecasting and management reporting.
• Helped IT team with database backups, migrate applications from test to production server, and synchronize both environments.
• Assisted financial users in using Smart view Excel-Add in to view the data and the basic concepts of multidimensional databases.
• Participated in meetings with financial users and IT Department if any issues arise regarding Hyperion upgrade.
• Configured Data Sources through Hyperion Configuration Utility.
• Created different data forms like input forms, what-if forms, and composite forms required for budgeting and forecasting using Hyperion Planning.
• Wrote calculation scripts or business rules to perform cost allocation based on different drivers.
• Wrote several MaxL Scripts to perform automation and load data, export data, and execute calculations as necessary.
• Used Life Cycle Management Utility for migration purposes from one environment to other.
• Involved in performance tuning to minimize data load and calculation time by optimizing Essbase caches, restructuring, dataloads, calculations and reports
• Created and scheduled Batch Jobs for complete automation processes for application refresh and backup
• Participated in extracting and loading the data into databases and calculating data with business rules.
• Taught users how to use Hyperion Smart view and other end-user products more efficiently.
• Involved in gathering functional requirements from the users and translating them into technical development requirements using Hyperion Planning.
• Developed budgeting and forecasting applications using Hyperion planning for several financial and business users to analyze liquidity risks, automate budgeting and planning process and maximize the bank’s risk-adjusted returns.

Confidential, Detroit, MI

Hyperion Developer

Responsibilities:

• Implement Oracle Hyperion Planning and Essbase to provide the company with a fully integrated solution for financial modeling, budgeting, forecasting and management reporting.
• Created and maintained Essbase Multi-dimensional Cubes leveraging both ASO and BSO technologies.
• Participated in Optimization of the cube by analyzing and modifying various aspects such as dense/sparse configuration, modifying member storage properties etc.
• Supported existing P&L application (consisting of Balance Sheet, Consolidated and Workforce and Capex planning 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.
• Maintenance of batch scripts, scheduling runs through windows scheduler.
• Retrieve reports using Excel add-in and generate reports out of batch in Hyperion Reports.
• Create a New Planning Application which will overtake the present Budget Application.
• Create documentation around the project and train the end-users on various tasks associated with managing the end-to-end EPM Planning and Essbase solution.
• Loaded the metadata and business rules using Outline Load Utility.
• Developed Data forms, Menus, Task Lists, and User Variables based on the functional and technical Requirements requested by the business.
• Write several MAXL Scripts to perform automation and Load data, Export data, and Execute calculations as necessary.
• Write Calculation Scripts or Business Rules to perform cost allocation based on different drivers.Essbase functions such as @DESCENDENTS, @MDALLOCATE, etc. were very supportive for these Calc Scripts.
• Developed Calculation Scripts for the communication and integration between the Sales Forecasting and Financial Forecasting application. Used Data export functions to extract data from Financial Forecasting cube and feed (import) the data into the Sales Forecasting application.
• Implemented Essbase for business intelligence purposes to data mine and generate quarterly reports.
• Maintain security by creating, managing, and assigning provisions to the users in the Shared Services.
• Participate in meetings with financial users and IT Department if any issues arise regarding Hyperion.

Environment: Hyperion 11.1.2.2, Hyperion Planning 11.1.1.3/9.3.1 , Interactive Reporting, Financial Reporting 9.3MS-SQL Server 2008, WINDOWS

Confidential, Houston, TX

Hyperion Administrator/ Consultant

Responsibilities:

• Performed the duties of a Hyperion Administrator for a large-scale environment.
• Involved in Installation and Configuration of Hyperion products such as Hyperion Planning, Essbase, Hyperion Financial Management, Financial Data Quality Management and Reporting tools like Interactive Reporting & Financial Reporting Studio.
• Designed BSO application for the purpose of Gross Margin and Commissions planning and a separate ASO application for regulatory reporting, variance analysis and achieving process.
• Created Users, Groups, Filters and assigned different levels of Security Access to users in Hyperion Planning.
• Build dimension and outline using Outline Load Utility and Oracle Data Integrator.
• Configured master and work repositories, defined the physical and logical architectures and contexts in ODI.
• Assisted users in using Hyperion Smartview and Excel-Addin to perform the drill downs and ad hoc reporting.
• Implementedvarious types of calculations such asDynamic & Two-Pass,Member formulas, UDA’s, attributes and XREF functions for calculations.
• 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.
• Configured Data Sources through Hyperion Configuration Utility.
• Developed Data Forms and folders and customized data forms, developed Task Lists.
• Created and registered Planning applications in Hyperion Workspace.
• Developed Rules Files to load data to Essbase cube.
• Developed batch scripts to automate data loads.
• Supported existing P&L application consisting of Balance Sheet, Consolidated and Workforce and Capex planning databases.
• Created customized Financial Reports using Hyperion Financial Reporting Studio according to the finance users’ 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. Developed Business Rules including the use of Run-time prompts.
• Created and executed calculation scripts for automation of shipment calculation, actual and forecasting data.
• Performed migration tasks from one environment to another using LCM (Lifecycle Management) utility and Relational backup and restore.
• Created documentation for functional requirements of the project which included entire end-to-end development, testing and go-live.
• Created and scheduled Batch Jobs for complete automation processes for application refresh and backup.
• Supported Report Creation using Financial Reporting.
• Actively participated in upgrade of Hyperion System from 9.3.1 to 11.1.1.3

Environment: Hyperion Planning System 11.1.2./9.3.1/ , Hyperion Essbase 11.1.2/9.3.1 HAL, Financial Reporting, Interactive Reporting, Smart View, Essbase Excel Add-In

Confidential, Foothill Ranch, CA

Hyperion Consultant/ Administrator

Responsibilities:

• Designed multicurrency BSO application and a separate ASO application for regulatory reporting, variance analysis and archiving process. These applications supported annual budget of approx. $400 million and 24-month forecast process.
• Build dimension and outline using Outline Load Utility and Oracle Data Integrator.
• Configured master and work repositories, defined the physical & logical architectures and contexts in ODI.
• Supported existing P&L application consisting of Balance Sheet, Consolidated and Workforce and Capex planning databases
• Established a workflow process to keep track of the plan, review the plan, and change the ownership and status of the planning unit.
• Designed a Replicated partition to transfer a portion of data from one cube to another, which significantly increased the performance for the excel-retrievals.
• Assisted users in using Hyperion Smart viewand Excel-Addin to perform the drill-downs and ad-hoc reporting.
• Implemented various types of calculations such as Dynamic & Two-Pass, Member formulas, UDA’s, attributes and XREF functions for calculations.
• 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.
• Created MaxL and batch scripts to automate process of updating cubes on a daily basis.
• Performed regular Backups of the cube and archived it.
• Performed daily and monthly refresh processes, which involved opening and closing of the monthly forecast, loading actual, updating variables, archiving, data validation etc.
• Performed migration tasks from one environment to another using LCM (Lifecycle Management) utility and Relational backup and restore.

Environment: Hyperion 11.1.2.1, Oracle 11g, WINDOWS, UNIX

Confidential, Texas

Hyperion Consultant

Responsibilities:

• Developed multi-dimensional database application using Hyperion that stored and maintained company’s financial and marketing data for trend analysis and reporting.
• Designed various reporting cubes (ASO and BSO), tax reporting.
• Modified existing rule files and designed new ones to optimize the data load process.
• Developed 5 independent applications supporting different projects for approx. 1000 users.
• Upgraded cube setup, which involved complex partitioning, and 4 cubes to a simple design with a single ASO cube. This efficient design made user’s work more efficiently as the retrieval time was reduced significantly.
• Participated in extracting and loading the data into databases and calculating data with business rules.
• Taught users how to use Hyperion Smart view and other end-user products more efficiently.
• Involved in gathering functional requirements from the users and translating them into technical development requirements using Hyperion Planning.
• Developed budgeting and forecasting applications using Hyperion planning for several financial and business users to analyze liquidity risks, automate budgeting and planning process and maximize the bank’s risk-adjusted returns.
• Worked on Hyperion Workforce application to plan bank employees' expenses (their salaries, vacation days, bonuses, refunds, etc.) on all bank levels.
• Automated MaxL and batch scripts to import and export the data from the cubes that were updated regularly Confidential mid-night and during the day.
• Applied security to the Essbase databases by created users and user groups to control the access of data in specific areas.
• Performed daily and weekly Backups and Recovery of the cube.

Environment: Hyperion 11.1.1.3, SQL Server 2008, WINDOWS & UNIX

Confidential, St Paul, MN

Hyperion Developer

Responsibilities:

• Interacted with several users from different departments to gather business requirements, define, design, develop, test and deploy Hyperion Planning Applications.
• Designed an outline consisting of both user defined and default dimensions, consisting of thousands of members per dimension.
• Loaded the metadata and business rules using Outline Load Utility.
• Developed Dataforms, Menus, Task Lists, and User Variables based on the functional and technical Requirements requested by the business.
• Developed Calculation Scripts for the communication and integration between the Sales Forecasting and Financial Forecasting application. Used Dataexport functions to extract data from Financial Forecasting cube and feed (import) the data into the Sales Forecasting application.
• Designed Rules Files by carefully mapping the dimensions from flat files to the dimensions in outline
• Worked with multiple Currencies and changing the currencies of a data cell in the data forms.
• Implemented Member formulas, UDA’s, attributes and MDX formulas for calculations.
• Designed and created a security plan to manage security Confidential the user and group layer, the global access layer and the server level using Shared Services.
• Created security filters and assigned them to users depending on responsibilities and tasks and limiting their access to only particular applications as per the guidelines of their department.
• Involved in Installation and Configuration of Hyperion products such as Hyperion Planning, Essbase, Hyperion Financial Reporting Studio, Interactive Reporting, Workspace and Shared Services.
• Used Life Cycle Management Utility for migration purposes from one environment to other.
• Involved in performance tuning to minimize data load and calculation time by optimizing Essbase caches, restructuring, dataloads, calculations and reports
• Created and scheduled Batch Jobs for complete automation processes for application refresh and backup

Environment: Hyperion Essbase 9.3, Hyperion System 9 BI+, Hyperion Financial Management 9.3, Hyperion Financial Data Quality Management 9.3, Hyperion Planning, Essbase Integration services, Hyperion Analyzer, Web analysis.

Confidential, NY

Hyperion Developer/Administrator

Responsibilities:

• Installation and Configuration of the server consisting of Hyperion System Essbase, Hyperion Planning, Hyperion Shared Services, Financial Reports and Workspace.
• Created different data forms like input forms, what-if forms, and composite forms required for budgeting and forecasting using Hyperion Planning.
• Wrote calculation scripts or business rules to perform cost allocation based on different drivers.
• Wrote several MaxL Scripts to perform automation and load data, export data, and execute calculations as necessary.
• Helped IT team with database backups, migrate applications from test to production server, and synchronize both environments.
• Participated in meetings with financial users and IT Department if any issues arise regarding Hyperion.
• Configured Data Sources through Hyperion Configuration Utility.
• Created Users, Groups, Filters and assigned different levels of Security Access to users.
• Involved in documentation on all Hyperion Planning processes for all business groups and technical documentation.
• Developed load rules for loading data files and for dimension build and implemented data-access security and user management.
• 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 Scripts for complete automation processes for application refresh and backup.
• Optimized the cubes performance by changing Dense/Sparse configuration.
• Assisted financial users in using Smart view to view the data and the basic concepts of multidimensional databases.
• Generated reports such as PNL, Balance sheets, Trail balance, Revenue and Expenses using Financial Reporting Studio.

Environment: Hyperion ESSBASE 7.1.2, Hyperion Planning 3.5, ESSBASE Integration Services 7.x, Hyperion Financial Management