SUMMARY

• 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 Planning, Hyperion Financial Management, DRM, FDQM, HAL, ODI, Hyperion Business Rules, EPMA, Hyperion Reports, SmartView and Excel Spread Sheet Add - in under Windows, UNIX environments.
• Extensive experience in using Oracle Hyperion Planning and Essbase in design, development, test, roll-out and post production support.
• Strong understanding on ETL process and the usage of Oracle Data Integrator.
• Architect data management using Financial Data Quality Management tool.
• Developed 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).
• Expertise in building Financial Budgeting and Forecasting OLAP applications with Essbase and Hyperion planning.
• Skilled in automation, optimization and performance tuning of 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 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 Essbase cubes using MaxL, Esscmd, MDX, Batch and Shell scripts.
• Good Knowledge of Hyperion Version 11.x Essbase and Planning.
• 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.

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 Financial Management 9.3.1, DRM, HAL, HFM, FDM, ODI, EPMA, Hyperion Shared Services 9.3, Essbase Integration Services, Excel Spread sheet Add-in, Smart view, ESSCMD, MaxL and MDX

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

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

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Winston-Salem, NC

Sr. Hyperion Consultant

Responsibilities:

• Hyperion system remediation project development and support work.
• Works with business understanding requirements and enhancements to Hyperion remediation design.
• Responsible for developing Hyperion objects including calculation scripts, business rules, report scripts.
• SmartView templates using HsGeTvalue functions are developed and end users are trained.
• Extensive development for monthly executive management report package reports using Financial Reporting Studio.
• Hyperion master data load design using DRM and Hyperion load utilities.
• Build Hyperion interface supporting monthly Non-GL schedules maintenance.
• Hyperion data management using ETL and Essbase load rules.
• Hyperion data flows design between planning, forecasting, and reporting cubes.
• Hyperion best practices design recommendation as well as process flows.
• Security matrix design and validation using Hyperion Foundation/Shared Services.
• Essabase administration including application/database configuration, cache settings, using EAS.
• Proof of concept/proto type testing work for new change requests.
• Hyperion compression/defragmentation automation to improve performance.
• Oversee Hyperion automation work with IT and scheduling teams. UNIX and Essbase Maxl scripts are used.
• Extensive financial reports and report scripts development.
• Involve preparing end user training slide deck for SmartView, Hyperion Planning, and Hyperion Reports.
• Support the old Hyperion parallel period month end activities including master data maintenance, data loads, calculations, data issues, end user support, and Non-GL manual loads maintenance.
• Involve in functional and technical specifications documentation.

Environment: Hyperion systems 11.1.1.3, Hyperion Essabse, Planning, Foundation Services, SmartView, FR Studio, Data Relationship Management tool, UNIX, Windows, Oracle.

Confidential, Canton, OH

Hyperion Reporting Consultant

Responsibilities:

• Maintain Hyperion Planning applications an efficient budgeting and forecasting process, including working with cross functional finance team members to develop comprehensive requirements.
• Support and develop Hyperion reporting systems using, Hyperion Planning, Essbase, EPMA, FDQM, HAL, EAS, Financial Reports Studio, Smart View, Excel Add-in.
• Monthly data loads using FDQM and troubleshoot issues with mapping and validation.
• Design complex Hyperion Financial Reporting Studio reports.
• Smartview work includes end user training, trouble shoot connectivity issues.
• Deploy and maintain several EPMA planning applications metadata and troubleshoot issues.
• Maintain and enhance Hyperion Planning security utilizing Shared Services.
• Maintain and develop multiple planning applications.
• Metadata management using EPMA ADS files and EPAM batch client.
• Data management using FDM and Essabse data load rules.
• Developand maintain Hyperion Calculation Manager Rules for multiple planning applications.
• Develop calculation scripts as per new requiremnts.
• Maintain planning Security Matrix and identify shared services or application object access issues
• May work across all levels management to gather, analyze, summarize, and prepare recommendations regarding financial plans, new business planning, trended future requirements, and operating forecasts.
• Support corporate financial planning, salary, expense, and other divisional planning applications including month end and day-to-day activities.
• On-going support of existing planning cycles, including required maintenance supporting planning components (business rules, forms, security, etc.)
• Oversee security provisioning and migration using LCM tool for Planning applications.
• Work on special projects related to forecast and other which leverage the knowledge of accounting, consolidations, and system structure.
• Provide first tier end user support, including ongoing development and delivery of business training documentation.
• Monitor application performance, availability, and utilization.
• Install and trouble shoot client software (SmartView, Excel add-in, FR Studio).
• Mange Exchange rates load and trouble shoot currency conversion issues.
• Provide support for Hyperion users
• Monitor ITSM helpdesk tickets and address resolving issues in timely manner.
• Develop Maxl scripts for data load and nightly jobs automation.
• Work with business gathering new change request requirements.
• Update documentation as addressing new change requests.
• Create, modify, and maintain technical and functional specification documentation of Hyperion systems.
• Develop testing, evaluation, and development processes for system changes, modifications, or enhancements to software. Establish Hyperion Planning system operational policies and procedures.

Environment: Hyperion Planning 11.1.2.0, Essbase, EPMA, FDQM, FR Studio, Smartview, HAL, EAS, Foundation Services, Excel Add-in, Windows, UNIX, Oracle.

Confidential, Minneapolis, MN

Hyperion Analyst

Responsibilities:

• Involved in developing design specifications of ESSBASE cube with Customers.
• Developed Aggregate Storage Cubes (A.S.O) cubes using ESSBASE.
• Extensively involved in designing and modifying the outlines for ESSBASE Cubes.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
• Developed OLAP Models and Meta outlines using ESSBASE Integration Services from star schema in relational databases.
• Designed and developed several ad-hoc and financial reports using Hyperion Analyzer and Hyperion Interactive Reports.
• Created Dashboard Reports using Interactive Reporting.
• Developed and created Web forms for users to input the data into ESSBASE cube through Hyperion Planning.
• Worked extensively on Budget process and Budget Administrative tasks
• Developed Calc scripts to calculate values like Hourly Wages, Depreciation, Benefits and Revenue.
• Involved in Migration of Hyperion Reports and Analyzer Report groups from one environment to another environment.
• Used ESSBASE Integration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of ESSBASE Servers.
• Optimized the applications to bring down the runtime and database size considerably.
• Involved in production support and maintenance of existing cubes.
• Worked as a team member in Hyperion ESSBASE & Planning Implementation.
• Involved in database and security refreshes in Hyperion Planning.

Environment: Hyperion System 9 BI+, Hyperion ESSBASE 9.0.1, Hyperion Planning 4.1.1, Hyperion Analyzer, Excel Spreadsheet Add-in, Hyperion Application Link, Hyperion Reports, Workspace, Windows 2003 Server, SQL Server 2000.

Confidential

Financial Analyst

Responsibilities:

• Involved in requirement gathering, user interaction, study, business model designing.
• Designing the prototype application for presentation.
• Responsible for monthly GL postings reconciliation.
• Prepare monthly management reporting package for close meeting.
• Support and train end users.