SUMMARY

• Experience of over 12 Years in IT design, analysis and development. Extensive experience in implementation and administration of various applications environment using Hyperion Essbase, Essbase Administration Services, Hyperion Planning, Hyperion Financial Reporting, Hyperion Interactive Reporting, Hyperion Financial Management (HFM), Analytic Provider Services, Hyperion EPM, Smart View for Office, ESSCMD, MaxL, Essbase Excel Add - in, on Windows and Unix environment.
• Experienced in all stages of Software Development Life Cycle (SDLC) with comprehensive knowledge of business and requirements analysis, Business Process Modeling, Project planning and creation of user test cases.
• Extensive experience in designing and developing OLAP cubes from a conceptual level and possesses outstanding skills in Essbase related technologies.
• Experienced in installing, configuring, and upgrade and documenting Hyperion System 9 products.
• Skilled in administering, automation, optimization and performance tuning of Essbase applications, data/metadata processing, upgrading, testing and migrating of cubes in different environments.
• Extensive experience with Metadata management using DRM (Data Relationship Management) to manage metadata used in various Essbase, Planning and HFM applications.
• Developed complex Hyperion Financial Reports (FR) using Financial Reporting Studio connecting to various Essbase and HFM applications using multiple data sources.
• Managing / administration: security, permissions, users and groups, controlling access to database cells through managing filters, filters: creating, copying and assigning filters.
• Extensive knowledge of Financial Data Quality Management (FDM).
• Scheduling loading of data, and writing scripts to perform loads and calculations, Essbase Partition database models and Essbase Block Storage database models.
• Database optimization and performance-tuning expertise with Essbase.
• Support user training, documentation, QA Strategy and rollout of new projects.

TECHNICAL SKILLS

OLAP Tools: Hyperion Essbase 9.x/7.x/6.x, Essbase Analytic Services (EAS), Analytic Administration Services (AAS), Analytic Provider Services (APS), Analytic Integration Services (AIS /EIS), Workspace, Dashboard Studio, Smart View for Office, OBIEE, BI Publisher, MS Excel Add-In Essbase query designer.

BI (Business Intelligence): Hyperion Master Data Management, Data Relationship Management, Hyperion Planning, Hyperion Financial Management (HFM), Financial Data Quality Management (FDM), Integration Services, PBCS/EPBCS, OBIEE

Reporting Tools: Hyperion Financial Reporting (FR), Interactive Reporting (BRIO), SQR Production Reporting, Web Analysis and Hyperion Reports and SSRS.

MS Office Tools: MS Office Suite 2007/2003/2000. Excellent skills of MS Excel 2003

Modeling Tools: Star schema, Snowflake schema, Dimension and Fact tables, Logical and Physical Modeling

Databases: Oracle 11i/10g/9i/8i, MS SQL Server, MS Access, DB2

Operating Systems: Windows NT/2000 /XP/Server 2003, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

Senior Hyperion Consultant

Responsibilities:

• Provided subject matter expertise in both leading business practices and application expertise to assist in the designing, developing, and deployment of the Hyperion Planning and Essbase applications.
• Created Planning application using Hyperion Planning and Budgeting Cloud Services (PBCS) and set up and configure Financials, Workforce and Capital Planning modules.
• Customized Workforce and Capital Planning applications as per the business needs.
• Used PBCS to load dimension members (metadata) and data into the Planning applications including setting up of forecast years and multicurrency applications.
• Setup PBCS applications Scenarios using Planning and Forecast Preparation and Variables for Scenario, Currency, Version, Years.
• Using EPBCS, set up new hires, new asset classes and cash flows for the various Planning modules within PBCS.
• Worked on Essbase cubes including both Aggregate Storage (ASO) and Block Storage (BSO) cubes.
• Worked on designing dimensions, members, UDA’s and development of other Essbase artifacts.
• Involved in requirement gathering and transforming them into design and functional documentation.
• Created project documentation and deadlines for different Hyperion applications and ensure that they are met.
• Worked on Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) for data mapping and validation from RDBMS and Planning applications.
• Worked extensively in Shared Services Administration, User Management, Provisioning, and Group Management.
• Created Groups in Shared Services, provisioned them with Essbase, Planning, Reporting and Analysis roles and assigned these roles to dimension and webform security.
• Worked extensively on migration from Dev to UAT and from UAT to Prod environments of Essbase and Planning artifacts using LCM (Life Cycle Management).
• Created Load Rules to load metadata and data into the Essbase cubes and Calculation Scripts to calculate the data loaded.
• Worked extensively on the automation of jobs using Essbase Maxl scripting.
• Used Hyperion Data Relationship Management (DRM) to maintain Essbase and Planning metadata and export hierarchy trees to planning.

Environment: Hyperion Planning V11.1.4, Oracle PBCS/EPBCS, Hyperion Essbase V11.1.2.4, Hyperion Financial Data Quality Management (FDMEE), Hyperion Financial Close Management (FCM), Hyperion Financial Reporting (HFR), Essbase Administration Services (EAS), DRM (Data Relationship Management), Shared Services, Oracle Database 10g, Windows Server 2003, Linux, Putty.

Confidential, Boston, Massachusetts

Senior Hyperion Consultant

Responsibilities:

• Involved in requirement gathering and transforming them into design and functional documentation.
• Worked extensively on Hyperion Planning applications including design and development.
• Worked on Essbase cubes including both Aggregate Storage (ASO) and Block Storage (BSO) cubes.
• Created Load Rules to load metadata and data into the Essbase cubes and Calculation Scripts to calculate the data loaded.
• Involved in the migration of Essbase cubes and Planning applications from one environment to another.
• Worked extensively on the automation of jobs using Essbase Maxl scripting.
• Used Putty and WinSCP to work in Linux environments to create and run jobs.
• Used Hyperion Shared services for administration and security purposes and used Hyperion LCM (Life Cycle Management) for migrating Essbase Artifacts.
• Created Web forms, Run Time Prompts in Hyperion Planning using workspace.
• Involved in planning and execution of unit, integration and acceptance testing on an as needed basis.
• Regularly communicated and collaborated with stakeholders and other teams to design and develop new applications that help in the reporting needs of the clients.

Environment: Hyperion Essbase V11.1.2., Hyperion Planning V11.1.2, Hyperion Financial Reporting (HFR), Essbase Administration Services (EAS), Shared Services, Oracle Database 10g, Windows Server 2003, WinSCP.

Confidential

Hyperion Consultant

Responsibilities:

• Created business requirement’s documents after meeting with the business clients and gathering requirements.
• Involved in the migration of Essbase cubes and Planning applications.
• Migrated On-Premises Hyperion planning application to PBCS. Customized dimension members to suit the needs of the client.
• Created Hyperion Planning application using Oracle PBCS.
• Used PBCS to provide security to uses as per business needs.
• Essbase Administration, User Management and Maintaining Security using Workspace.
• Worked on Hyperion Essbase Aggregate Storage (ASO) and Block Storage (BSO) cubes. Created rule files to load data into the cubes.
• Created Calculation Scripts in Essbase BSO Cubes to perform calculations on the data loaded and write Report Scripts to export data from the Essbase Cubes.
• Created Maxl jobs to automate metadata and data load process.
• Used Hyperion Interactive Reporting to create IR reports using data from RDBMS such as Oracle and Netezza.
• Create OCE (Open Catalog Extensions) files for database connections using Hyperion Interactive Reporting (HIRS).
• Created Financial Reports using Hyperion Financial Reporting (HFR) Studio.
• Used Oracle Data Integrator (ODI) to perform extract, transform and load (ETL) jobs.
• Created packages to import and export data from one database (Netezza and Oracle) to another database (SQL Server) using Oracle Data Integrator.
• Created Procedures for data movement and Interfaces to map data using ODI.
• Used Sql Server Integration Services (SSIS) to replicate ODI Packages into SSIS Packages and Sql Server Reporting Services (SSRS) to create reports as per user requirements.

Environment: Hyperion Planning V11.1.2, Oracle PBCS, Essbase Administration Services (EAS), Hyperion Integration Services (EIS), Hyperion Financial Reporting, Hyperion Interactive Reporting (IR), Oracle Data Integrator (ODI), Shared Services, Oracle Database 10g, Windows Server 2008, Microsoft Visual Studio 2008.