SUMMARY

• Information Technology Professional with 8+ years of experience and 5+ years of experience in complete project life cycle implementations, Budgeting and Forecasting with Oracle Hyperion Systems. Have excellent written and oral communication skills and a strong financial background with experience in numerous industries.
• Possess the ability to adapt to rapidly changing business requirements, technical and social environments with an emphasis on continual learning and improvement.
• Experience in Hyperion Essbase, Hyperion Planning, Hyperion Financial Management (HFM), Hyperion Shared Services, Hyperion Workspace, Hyperion Interactive Reporting, Excel Add - in and Smart view.
• Experience in Financial Budgeting and Forecasting, EPM and OLAP applications with Planning.
• Experience in variance analysis of Financial Budgets and Forecasts
• Experience in Data Forms/Web Forms, Business Rules, Task Lists, Menus, User Variables, Smart Lists.
• Created and customized several Financial Reports using different tools of Hyperion including Hyperion Interactive Reporting Studio and Hyperion Financial Reporting Studio according to client requirements.
• Expertise in loading data using Outline Load Utility.
• Experience in Reporting Tools and the creation of user defined reports.
• Experience with Crystal Reports and Microsoft FRx.
• Experience with different releases of Oracle Hyperion 9 and Oracle Hyperion 11.
• Experience in installation and configuration of Hyperion products such as EssbaseAdministrative Services, Hyperion Planning, Hyperion Reports, Shared services, IntegrationServices.
• Expertise in dynamically building Dimensions using rule files and loading Fact datain Essbase Applications by means of several build methods such as generation, level andparent-child references.
• Experience in performing migration between different environments and in upgrade betweendifferent versions including Life Cycle Management utility in version 11.
• Acquired a broad understanding of database calculations such as implementing formulas ondimension members, dynamic calculations, developing calculation scripts and ESSCMD.
• Skilled in automation, optimization and performance tuning of Essbase application datametadata processing, upgrading, testing and migrating cubes in different Hyperion applications.
• Complete understanding of Database Design Life Cycle

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/

Databases: Oracle 11i/10g/9i/ SQL Server 2005 MS Access

Reporting Tools: Financial Reporting Studio 11/9.3 Hyperion System 9/11 Smart View Hyperion Financial Management (HFM) Hyperion Interactive Reporting Hyperion Smart View Hyperion Spreadsheet Add in

Crystal Reports: Microsoft FRx

Languages: SQL, VBA

Operating Systems: Windows 2000/ 2003/2008 server operating systems

Accounting Software: Accpac Saige, Accpac Dos, MS Solomon Dynamics

Other Software: JMP Pro10, Enterprise Miner, Minitab, ExtendSim8Lt, Fidelity, Ms Office Suite

PROFESSIONAL EXPERIENCE

Confidential, NJ

Hyperion Developer/Administrator

Responsibilities:

• Gathered requirements by interviewing users in order to discover business needs and user requirements.
• Ensured user needs were satisfied by developing Essbase applications to client specification Aggregate storage (ASO) and Block Storage (BSO) applications as needed.
• Developed load rules and Rule files for the building of dimensions and loading of data files.
• Implemented the automation of both periodic data loads and calculation scripts with the use of MaxL Scripts.
• Responsible for the continuous maintenance and restructuring of cubes with the aim of optimizing. Ensured correct sparse/dense configurations, block density and compression, outline structure strategies, batch update streamlining and calculation script optimization.
• Developed and maintaineda range of financial reports using Hyperion Financial Management (HFM)
• Created Users, Groups, Filters and assigned different levels of Security Access to users in Hyperion Planning.
• Involved in usingOutline Load Utility for loading data into Hyperion Essbase and Planning.
• Migrated objects between the Development, Testing and Production environments using Oracle Life Cycle Management
• Performed integration test, system test and validation of reports and report data.
• Developed Hyperion Planning applications

Environment: Hyperion Essbase11.1.1.3, Hyperion Planning, Hyperion Shared Services, Hyperion Reports, Smart View

Confidential, Warren, NJ

Hyperion Developer

Responsibilities:

• Defined and developed BSO applications in Hyperion Essbase.
• Designed and loaded outline dimensions and members including Standard and Attribute dimensions, Aliases and Formulae using Rules Files.
• Participated in Optimization of the cube by analyzing and modifying various aspects such as dense/sparse configuration, modifying member storage properties etc.
• Worked on Migrations of databases from development servers to QA/Production servers
• Created and scheduled Batch Jobs for complete automation processes for application refresh and backup.
• Developed and created Web forms to client’s specifications for data load into ESSBASE cube through Hyperion Planning.
• Developed financial reports involving Budget Allocations and forecasting of Income Statements, Balance Sheets and Cash Flow Statements using Hyperion Financial Management (HFM) and Hyperion Planning.
• Managed solution access and security by creating users, users groups and filters.
• Actively involved in the maintenance and support of existing Essbase cubes and Planning applications.
• Worked extensively on Smart view for data manipulation.
• Worked on Migrations of databases from development servers to QA/Production servers
• Created and scheduled Batch Jobs for complete automation processes for application refresh and backup.

Environment: Hyperion Essbase11.1.1, Hyperion Planning, Hyperion Shared Services, Hyperion Reports, Smart View.

Confidential, New York, NY

Hyperion Administrator

Responsibilities:

• Worked closely with external consultants and the company with the Hyperion Implementation
• Developed and maintained Oracle Essbase solutions involving ASO and BSO technologies and suite of Hyperion products (Essbase/Planning).
• Monitored system performance as well as Hyperion System Logs for errors and outage conditions.
• Managed complete system backups including the necessary MAXL scripting for Essbase backups.
• Assisted with management of all system RDBMS backups
• Troubleshoot issues with both client and server systems
• Worked closely with end users and SMEs to resolve issues, recommend solutions, and create requirements
• Maintained security roles and access for various users
• Worked closely with Technology department and identified/communicate when data feeds were not updated during monthly close and reporting timelines
• Created Web forms for data input into income statement accounts, balance sheet accounts, drivers, stats accounts, and actual adjustments

Environment: Hyperion Essbase9.3.3 Hyperion Planning, HyperionShared Services, Hyperion Financial Reporting Studio, Hyperion workspace, and Smart View

Confidential, Auburn, WA

Hyperion Consultant

Responsibilities:

• Translated end-user requirements into application design specifications.
• Developed Essbase cubes and database objects to meet business requirements, including developingoutline structure.
• Created rules for data loading and populated Essbase with the necessary data.
• Documented and issued procedures pertaining to Essbase applications.
• Created users and groups in Hyperion Planning and managed security.
• Created reports using Hyperion Financial Reports to detail product profitability levels.Developed batch scripts to automate data loads.
• 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.
• Created Users, Groups, Filters and assigned different levels of Security Access to users in Hyperion Planning.
• Developed Business Rules including the use of Run-time prompts.

Environment: Hyperion Essbase 9.3.1, Hyperion Reports, Hyperion Planning, Excel Spreadsheet Add-in

Confidential, Salem, NH

Hyperion Consultant

Responsibilities:

• Consulted with end-users to gather requirements and develop applications to specifications.
• Developed Planning applications for budgeting and forecasting.
• Managed and maintained Essbase cubes and database objects to meet new business requirements.
• Established security for users and groups.Involved in performance tuning and optimization of cubes - sparse/dense configuration, block density and compression, outline structure strategies, batch update streamlining, load optimization (load rules and transformation), and calculation script optimization.
• Developed financial reports involving Budget Allocations, Retained Earnings, forecasting of profit and loss and the reported implied changes in balance sheets as well as cash flow statements
• Managed applications migrations between Essbase servers, established substitution variables andsettings for dynamic time series, asynchronous processing, and editing/validating scripts.
• Developed Batch files using MaxL, and Rules files to upload data from financial systems Database toEssbase cube.

Environment: Hyperion System 9.2.0.3, Hyperion Reports, Hyperion Planning, Excel Spreadsheet Add-in

Confidential, Washington, DC

Hyperion Consultant

Responsibilities:

• Assisted in the motivation, training and delegation of duties to ten member staff
• Aided in the design of software solutions as required to improve the efficiency and accuracy of the company’s operations.
• Assisted in the implementation of Oracle Hyperion ESSBASE v 9
• Developed and created Web forms for users to input the data into ESSBASE cube through HyperionPlanning.
• Established security for users and groups.Involved in performance tuning and optimization of cubes - sparse/dense configuration, block density and compression, outline structure strategies, batch update streamlining, load optimization (load rules and transformation), and calculation script optimization.
• Created reports using Hyperion Financial Reports to detail product profitability levels.
• Prepared monthly financial statements including Profit & Loss Statements and Balance Sheet
• Supervised the external audit process as well as changed the financial year end.

Environment: Hyperion System 9.2.0.2, Hyperion Reports, Hyperion Planning, Excel Spreadsheet Add-in

Confidential

Staff Accountant

Responsibilities:

• Implemented a change in the Financial Year End.
• Highlighted where the company the miss-management of recoveries from Facultative Reinsurers was resulting in significant losses on a yearly basis.
• Aided in the design and implementation of the company’s in-house software solution for the management and recovery of facultative recoveries.
• Prepared monthly financial statements including Profit & Loss Statements and Balance Sheet and updated financial statements formats as needed.
• Supervised the external audit
• Assisted in the motivation, training and delegation of duties to a ten member staff including an Accounts Supervisor, Accounts Receivable and Payable staff and Cashiers