SUMMARY

• Over 9+ years of experience as a Hyperion Developer/Administrator with extensive hands on technical experience in many aspects of Data Warehouse and OLAP software systems Administration, design and implementation.
• Extensive experience in the development, design, analysis and Implementation of various applications using Hyperion System 9, Hyperion Essbase 7.X/6.X, Essbase Integration Services, Hyperion Analyzer, Hyperion Reports, Hyperion Planning, Hyperion Financial Management (HFM), Hyperion Performance Suite, Financial Data Quality Management(FDMEE), BRIO, and Essbase Spreadsheet Add - In on Windows 2000/NT and Unix environments.
• Commendable knowledge and experience in automation, Essbase cube designing, partitioning and optimization of report queries in Microsoft Excel.
• Designed and developed numerous cubes from conceptual stage, Essbase MDDB applications, OLAP Models and Meta-Outlines with excellent balance of dense and sparse dimensions.
• Managed projects to build and maintain Hyperion Planning applications supporting an efficient Budgeting and Forecasting process.
• Highly involved in Hyperion Financial Management (HFM) Administration to ensure accurate monthly, quarterly and annual Accounting closes and consolidation of all the legal entities in accordance to GAAP and SAP accounting standards.

TECHNICAL SKILLS

OLAP Tools: Hyperion System 11/9, Hyperion Enterprise, Hyperion Essbase 9.x/7.x/6.x, Excel Add-In, Essbase Integration Services 7.1 / 6.x, ESSCMD, MaxL, Essbase Administration Services, Hyperion Planning, Hyperion Performance Suite 8.3.

Business Intelligence Tools: Hyperion Planning 11.x/9.x/4.x/3.x, H.A.L, HFM, FDM, FDMEE, DRM, ODI

Operating Systems: MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP

Languages: SQL, PL/SQL, C, C++, HTML, DHTML, XML

Databases: Essbase, Oracle 8.x/7.x/6.x, MS SQL Server 2000/7.0/6.5 , MS Access 2000, DB2, Sybase.

PROFESSIONAL EXPERIENCE

Senior Hyperion Administrator/Developer

Confidential

Responsibilities:

• Work as an administrator to develop, support and maintain their respective Essbase and Planning Applications.
• Support and Resolve Hyperion infrastructure issues in Windows and Unix environments.
• Assign user security and provisioning to various applications as per the requirement through Shared Services and refresh security filters in Essbase and Planning applications as per the requirement.
• Publish list of users having access to Hyperion to support Quarterly Audit process.
• Design and develop cubes as per the requirement, maintain outline, metadata and member formulas and load data manually as well as via automation using MAXL scripts for Essbase applications.
• Develop and Support FDMEE mappings and Rules to support daily load from SAP.
• Modify and Optimize various Calc scripts as well as Business Rules in Essbase and Planning applications as per the requirement.
• Support Business users to load actuals for their Actuals Reporting and Monthly and Quarterly Close.
• Copy and Load data in Planning applications via EPMA to support the client’s Forecast and Budgeting Process.
• Perform Outline Maintenance and Cube Maintenance for EPMA Planning applications.
• Actively Involved with Consultants to develop the new Sales and Margin ASO Application to run daily Flash Reports.
• Provide end user support with data reporting tools and process including troubleshoot and resolve errors/discrepancies/validations to ensure timely and accurate financial reporting along with providing the most effective and efficient tools for data loading (FDMEE,SQL,ODI)

Hyperion Consultant

Confidential

Responsibilities:

• Work with various clients as an administrator to develop, support and maintain their respective Essbase, Planning and HFM Application.
• Client and server installation of the entire EPM suite in Windows and Unix environments.
• Assign user security and provisioning to various applications as per the requirement through Shared Services and refresh security filters in Essbase and Planning applications as per the requirement.
• Design and develop cubes as per the requirement, maintain outline, metadata and member formulas and load data manually as well as via automation using MAXL scripts for Essbase applications.
• Perform Cube Optimization/Performance Tuning for faster data loads, better execution times of Calc scripts and faster retrieval of Reports using proper Dense/Sparse settings, Cache settings, Outline Formulas etc.
• Create and enhance various Calc scripts as well as Business Rules in Essbase and Planning applications as per the requirement.
• Create, support and maintain various Planning applications via EPMA to support the client’s Forecast and Budgeting Process.
• Perform Outline Maintenance, create and enhance Web Forms in Classic and EPMA Planning applications.
• Manage security of users around the globe for HFM applications by creating and maintaining security classes and assigning them proper Groups to ensure proper security for all global entities.
• Manage user security, create and edit import formats, create and maintain custom scripts, create and edit account, entity and custom mappings in FDM/FDMEE to ensure they are able to load their trial balance reports for their respective locations and perform consolidations in HFM.
• Provide end user support with data reporting tools and process including troubleshoot and resolve errors/discrepancies/validations to ensure timely and accurate financial reporting along with providing the most effective and efficient tools for data loading (Template, Data Forms, HFM Grids, Journals etc.)

SR. Hyperion Developer

Confidential

Responsibilities:

• Worked closely with business stakeholders to correctly identify their requirements and ensured the design satisfies the requirements.
• Developed a build plan for the development team using microsoft project to ensure that all the tasks are implemented in a timely manner and the deadlines are met.
• Worked extensively with the team to develop various Essbase and Planning applications for the budgeting process.
• Create properties in DRM for various applications and ensure that all the metadata and hierarchies flow properly in to all applications via EPMA.
• Create ASO cube for Actual data load and Reporting.
• Worked with team to develop and maintain Rules Files, Calc Scripts, MDX member formulas and MAXL scripts.
• Provide inputs while partitioning between ASO and BSO application for the Budgeting process.
• Highly involved with the testing team to develop test scripts for SIT and UAT.
• Worked in ALM to ensure the results of the all the testing is tracked and any issues, defects or concerns are tackled in a timely manner.
• Developed plan for migration of applications from one environment to other environment.

SR. Hyperion Developer

Confidential

Responsibilities:

• Designed and supported the complete architecture, installation and configuration of the entire Hyperion system (Essbase, Planning, HFM and FDM applications) while upgrading it to version 11.
• Held accountability for system maintenance, supporting and monitoring, capacity planning, resource management, evaluating and implementing upgrades and patches, performance tuning as well as security maintenance.
• Worked closely with business stakeholders to correctly identify their requirements and ensured the design satisfies the requirements.
• Supported HFM in all three environments.
• Create task lists, load actual data on a monthly basis in HFM, deploy monthly closing using task lists management and back up HFM application, Data forms and Data grids.
• Design and optimized calc script and business rules for EPMA 11.1.2.
• Create ASO Cube For actual data load and reporting .
• Excellent understanding of different storage in Essbase and their usage. Created really large cubes using ASO option. Also, created BSO application to support Financial Budgeting and Forecasting Application.
• Developed and maintained Rule files, Calc Scripts (BSO), Maxl Scripts, MDX member formulas (ASO).
• Create partition between ASO and BSO application for Budget and Plan data movement.
• Hyperion Planning was used in testing of the new calculation scripts.
• Optimized the ASO Cube by changing hierarchy and MDX formulas
• Hyperion Planning 11.0 was used to define business rules with run-time prompts or allocation sequences to match the needs of the users.

SR. Hyperion Developer/Administrator

Confidential

Responsibilities:

• Designed and supported the complete architecture, installation and configuration of the entire Hyperion system
• Designed and developed Hyperion Public Sector Planning and Budgeting.
• Manage positions, and position data, and position-related compensation details
• Manage employee-related data such as salary grades, benefits, location, status, employer paid taxes, and union information
• Project and evaluate the impact of employee compensation on overall budgets
• Forecast the impact of new positions, workforce reductions, contract proposals, and compensation and benefit changes as they occur throughout the year
• Perform mass updates and globally or conditionally apply compensation default changes
• Allocate budget amounts to different programs, projects, or other chart-of-account Dimensions
• Provided seamless integration of historical, projected and derived data.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Provide Metadata maintenance for Hyperion HFM and Planning applications.
• Run monthly close processes in HFM, Essbase and Planning applications loading the actual month close files in to HFM through FDM.
• Create ASO Cube For actual data load and reporting .
• Developed and maintained Rule files, Calc Scripts (BSO), Maxl Scripts, MDX member formulas (ASO).
• Create partition between ASO and BSO application for Budget and Plan data movement.
• Hyperion Planning was used in testing of the new calculation scripts.
• Optimized the ASO Cube by changing hierarchy and MDX formulas
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.

Hyperion Admin

Confidential, Seattle, WA

Responsibilities:

• Create new web form called Allocation Drivers to reduce the work load of the user thereby focusing on a single form rather than three different Forms namely Plan, Actual and Forecast.
• Hyperion Planning was used in testing of the new calculation scripts and to define business rules to match the needs of the users
• Created data entry forms to enter forms, update, analyze, print, and report on data.
• Design and optimized calc script and business rules for EPMA 11.1.2
• Hyperion Planning was used in testing of the new calculation scripts.
• Hyperion Planning 11.0 was used to define business rules with run-time prompts or allocation sequences to match the needs of the users.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion. Developed Aggregate Storage Cubes using Hyperion EPMA 11.0.
• Installed Hyperion Planning software and designed a design document on Hyperion Planning for the end users, how to work with forms, how to create business rule, and how to manage the workflow.
• Used to write MAXL script, S script, back up and automate monthly and yearly process.

Environment: Clarity, Hyperion Essbase System 11/ 9,HFM 9.x,Hyperion Reports 7.0, Hyperion Analyzer 6.5, Hyperion Planning 3.5.1, HFM, Hyperion Reports 7.0, Hyperion Performance Suite 8.3,SQR, Essbase Integration Services 7.1,BRIO 6.5, Microsoft Excel 2000, Oracle 9i, Windows 2000 Advance Server, UNIX.

Hyperion Admin/Developer/Administrator

Confidential, NYC, NY

Responsibilities:

• As an Essbase Database Administrator created Users and Groups in Hyperion Essbase and assigned privileges to them. Applied security on different applications by creating Filters on its dimension members.
• Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase Integration Services.
• Loaded data using Essbase Integration Services (EIS).
• Worked extensively on Web forms and Planning cube development, EIS, DIM and partitioning according to user specifications. Developed OLAP models and meta-outlines using EIS from the Oracle Star schema.
• Hyperion planning 9.3 release was used to create new web forms. The same was used to define business rules.
• Develop security authentication for the users of Hyperion Planning and maintaining workflow management process.
• Implemented star schema and used EIS to interface with the company’s existing Oracle 9i data warehouse.
• Migrated Essbase server into newer versions and newer operating systems.
• Convert Hyperion Enterprise Model In to HFM Model For Detail data Analysis.

Environment: Hyperion Essbase 7.0/6.5.1, Hyperion Planning, Hyperion Reports 7.0/ 6.5, BRIO, Hyperion Analyzer, MS-Excel 2000 Spreadsheet Add-In, Oracle 9i, Windows NT 4.

Essbase Developer

Confidential, Pasadena, CA

Responsibilities:

• Implemented Essbase in connection with financial budgeting, sales forecasting and marketing analysis to produce ad-hoc reports
• Translated end user requirements into application design specifications
• Assured optimal match between cube design and report specifications
• Optimized structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations and debugging
• Optimized cache settings, established user security, managed applications migration, established substitution variables and settings for dynamic time series, asynchronous processing, editing/validating scripts
• Developed OLAP models and meta-outlines designed through Essbase Integration Services
• Managed system upgrades and client installations based on users’ requirements
• Migrated database from version 6.2 to 6.5
• Handled performance tuning, weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation
• Developed Analyzer OLAP views and sophisticated what-if scenarios for the end users
• Documented and issued procedures pertaining to Essbase applications
• Provided business analysts with advice and options on opportunities to leverage the tool and increase usage
• Involved in checking the status and progress of each planning unit so as to analyze variances in real time, revise, promote, reject and approve plans.

Environment: Hyperion Essbase 6.2/6.5, EAS 6.5.1, Excel Spreadsheet Add-In, EIS 6.5, Hyperion Analyzer 6.5, Hyperion Planning 3.3, Hyperion Reports, Windows 2000