SUMMARY

• Over 7+ years as a Hyperion Consultant, extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems design and implementation.
• Worked on installation and configuration of Hyperion EPM 11.1.2.3 version on windows/Unix environments.
• Extensive experience in all critical phases of Software Development Life Cycle(SDLC) like research, analysis, design, modeling, development, testing, deployment, and support.
• Experience in the Implementation, development, design, analysis and of various applications using Essbase 11.x/9.x/7.x/6.x, planning 11.x/9.x/4.x/3.x, Hyperion Workforce Planning, Hyperion Capital Expense Planning, Essbase Integration Services, Hyperion financial Reports, Essbase Studio and Essbase Spreadsheet Add - In, & Smartview.
• Good understanding of RDBMS, data warehousing, data reporting and experienced in writing queries using SQL. Experienced in dimensional modeling using Star Schema and Snow-Flake Schema.
• Worked extensively on Hyperion Financial Reporting Studio, created & edited Financial Reports
• Strong Understanding of dense and sparse settings, performed dynamic calculations, developed, reviewed, and optimized report queries in Microsoft Excel, loaded data from various database to cubes. Used ODI to load data into planning.
• Understanding of Essbase security features and ability to create user and group profiles, and assign the proper privileges.
• Extensive experience in design, development, performance tuning and optimization of Essbase databases. Well versed in Essbase architecture, Calculation Scripts, Business Rules, Aggregate Storage Option (ASO), Block Storage Option (BSO), MDX Member calculations, ESSCMD, MaxL for batch scripting, and shell scripting.
• Strong SQL knowledge in creating queries, tables, and relational references, and maintaining the referential and data integrity.
• Created the Meta Data using EPMA (Data synchronization, ADS files)
• Functional background with regard to gathering and analyzing the requirements of users and translating them into specifics cube definitions and design.
• Proficient in software documentation, technical report writing, decisive with strong leadership qualities, flexible in work schedules
• Proficient in building dimensions dynamically, creating rule files, loading data in Essbase applications.
• In depth understanding of Essbase security features and ability to create user/group profiles, and assign proper privileges using both native security, and shared services mode.
• Worked on Dimension Building, Data Loading, Database Optimization, performed Database backups, Dense/Sparse settings.
• Results-oriented individual who views challenge as an opportunity. A strong team player capable of working independently with excellent communication, analytical, and inter-personal skills.
• Experience in Calc Scripts, Report scripts, and automated the cubes using Maxl and Esscmd.

TECHNICAL SKILLS

• Hyperion Essbase 11.x/9.3.1/7.X/6.x
• Hyperion Planning 3.0/3.3/3.5/4. x/9.x/11.x
• Hyperion Financial Management9.3/11.x
• Financial Data Quality Management FDQM 9.3
• Oracle Data Integrator(11G)
• Hyperion SharedServices System 9 BI+
• Hyperion System 9 Smart View
• Hyperion Financial Reports 11.1.1.3
• Teradata v13
• SQL
• Java
• MS Office
• Quick Books
• Peachtree Accounting
• MS Visio
• Windows
• UNIX
• HTML
• XML
• Java Script
• Servlets
• JSP
• Oracle 11g/10g / 9i / 8i / 7x
• MS SQL Server 2000/2005/2008
• MS Access
• SQL plus
• Hyperion Financial Reporting
• Hyperion Analyzer/Web Analysis
• Excel Add-in
• Smart View.

PROFESSIONAL EXPERIENCE

Hyperion Essbase Developer

Confidential, Austin, TX

Responsibilities:

• Worked as Essbase and Financial consultant in Finance Analysis and Treasury Risk Systems team. Project worked is involving Global financial analytical service and financial forecasting application.
• Designed and developed new Essbase cubes for corporate reporting framework using both Aggregate storage (ASO) and Block Storage (BSO) cube as per the requirement.
• Worked with Essbase and Teradata, which included metadata changes, revising data forms and creating Balance Sheet schedules. Loaded data through essbase and created and resolved any mapping kick outs.
• Developed and customized Data Forms in Hyperion essbase for users to input forecast, working data and accounting changes and other variance data.
• Developed load rules for loading data files and for dimension build and implemented data-access security and user management. Developed Calc Scripts to calculate various Metrics for the outline.
• The included application to create reports for income statements, balance sheets, key metrics, operating and admin expenses, consolidation, corporate P&L, Functional P&L and Revenue for USA, Europe and ASIA
• Loaded actual in to Hyperion essbase to drive actuals, forecast and budget numbers.
• Performed Integration test, system test and validation of reports and report data.
• Created and edited Hyperion essbase reports using Excel add-in.
• Worked closely with external auditors, business analyst and business Intelligence team.
• Implement best practice in to Essbase in order to get highest performance out of the cube.

Environment: Windows Server 2008, Hyperion essbase11.1.1.3 Administration Services, Excel Add-In, Web Analysis, Hyperion Financial Reporting / Hyperion Essbase /Teradata v13,Teradata ODBC

Hyperion Financial Analyst

Confidential, Atlanta, GA

Responsibilities:

• Perform monthly consolidate reporting of fixed assed and capital spending for the upper management.
• Worked as a Financial Business Analyst on Hyperion Essbase/Planning multi-currency application for the companies budgeting and forecasting purpose.
• Developed financial reports involving Budget Allocations, Retained Earnings, forecasting of profit and loss and the reported implied changes in balance sheets as well in cash flow statements.
• Developed reports using Hyperion Interactive Reports, Hyperion Financial Reports, Web Analysis, and modified existing reports.
• Handled quarterly and year-end audit requirements. Worked closely with external auditors & attorneys for International Transfer Pricing
• Developed Hyperion Financial Management application to create reports for income statements, balance sheets, key metrics, operating and admin expenses, consolidation, corporate P&L, Functional P&L and Revenue.
• Reported directly to senior management for issuance of management reports for earned and unearned revenue by title.
• Worked with HFM and FDM which included metadata changes, revising data forms and creating Balance Sheet schedules. Loaded data thru FDM and created and resolved any GL Account mapping kick outs.
• Performed Integration test, system test and validation of reports and report data.
• Worked directly with forecasters and planners and helped them in analysis.
• Created and edited Hyperion financial reports using Financial Reporting Studio.
• Used best practices to optimize calculation time.
• Loaded actuals into Planning Application and consolidated actuals, forecast and budget numbers.

Environment: Hyperion essbase11.1.2.3 Administration Services, Excel Add-In, Web Analysis, Hyperion Financial Reporting / Hyperion Essbase / Planning Consultant

Hyperion Consultant

Confidential, Portland ME

Responsibilities:

• Designed and developed new Essbase cubes for corporate reporting framework using both Aggregate storage (ASO) and Block Storage (BSO) cube as per the requirement.
• Developed and customized Data Forms in Hyperion planning for users to input forecast, working data and accounting changes and other variance data.
• Involved in the installation and configuration of the development server consisting of Hyperion System 11 Essbase, Hyperion Planning, Hyperion Financial Management Hyperion Shared Services, Financial Reports, Web Analysis and Workspace on UNIX.
• Participated in gathering business and functional requirements details during business meetings and translated them into program specification documents.
• Developed load rules for loading data files and for dimension build and implemented data-access security and user management.
• Used Oracle Data Integrator (ODI) 11g for data loading.
• Created and maintained the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and then adding users to the groups.
• Wrote calculation scripts and business rules to perform allocations based on different drivers.
• Involved in database and security refreshes in Hyperion Planning.
• Created Hyperion Financial Management application to develop financial reports involving Budget Allocations, Retained Earnings, forecasting of profit and loss and the reported implied changes in balance sheets as well cash flow statements.
• Participated in optimization of the cube by analyzing and modifying various aspects such as dense/sparse configuration, modifying member storage properties etc.
• Developed reports using Hyperion Interactive Reports, Hyperion Financial Reports, Web Analysis, and modified existing reports to in corporate global operations.
• Created applications, locations, import formats, mapping templates, control tables, integration scripts, and validation rules in Oracle Hyperion Financial Data Management (FDM).
• Participated in the planning and execution of integration test, system test, and user acceptance test activities, including developing and documenting test plans. Involved in documentation on all Hyperion Planning processes for all business groups and technical documentation on business rules and calc scripts.

Environment: Hyperion System 11, Hyperion System 9 BI+, Hyperion Essbase 11.x/9.x/7.x, Hyperion Planning, Hyperion Financial Management Suite (HFM), Excel, Smart View, and FDQM, UNIX

Hyperion Essbase Developer

Confidential, Arlington VA

Responsibilities:

• Created Excel Add In Budget and forecasting Planning reports.
• Created users and user groups in the Planning applications and assigned security to web forms.
• Performed analysis on Payroll and benefits functions using Hyperion Essbase Application.
• Participated in Requirement analysis phase and gathered reports in several format, analyzed the reports to design a Hyperion Essbase Cube for Sales Analysis.
• Developed Calc Scripts to calculate various Metrics for the outline.
• Worked directly with forecasters and planners and helped them in analysis
• Designed and developed monthly, quarterly and yearlysales Cubes.
• Involved in weekly meetings, to discuss current project status.
• Managed all franchise related accounting and advertising including Management variance & Analysis reports using Hyperion Essbase Reports.
• Worked closely with outside auditors for Financial Statement Preparation.
• Created reports using Hyperion Financial Reports and Smartview (Excel Add-In) from Hyperion Planning
• Supported Planning Application, which includes web forms, business rules, smart list. Also provided access to users based upon their role.
• Used best practices to optimize calculation time.
• Worked with FPNA teams for their month end close process.

Environment: Excel, VB Scripts, Macros, Hyperion Essbase 7.1/6.x, Hyperion Financial Reporting Studio Hyperion Planning Excel Add In

Hyperion Consultant

Confidential

Responsibilities:

• Worked on Informatica power center tools-Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer and Mapplet Designer.
• Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, and Sequence Generator.
• Involved in extracting data from various sources, applying the transformations before loading the data into target (warehouse) Oracle tables.
• Used Informatica Designer to create mappings using different transformations to populate data to a data warehouse.
• Wrote PL/SQL procedures for processing business logic in the database, Tuning Sql queries for better performance.
• Extensively worked in the performance tuning of transformations, Mappings and Workflows.
• Involved in developing Unit Test cases for the developed mappings.
• Created sessions and Workflows using Informatica Workflow Manager.

Environment: Informatica 6.1, Oracle 9i, UNIX, Toad