SUMMARY

• Around 5 years of software development experience in Hyperion Essbase, Hyperion Planning, ESSCMD, MaxL, Essbase Excel Add - in under Windows and UNIX environment.
• Strong experience in designing BSO, ASO, and Partitions.
• Proficiency as Essbase Administrator in maintaining Essbase, managing database settings, optimizations, thorough understanding of ASO and BSO cube architecture, Essbase Cache settings, optimizing calculations, attributes, storage security, optimizing reports.
• Strong knowledge and expertise in Database Optimization with Dimension Building, Data Loading, Indexing, calculations, cache management and partition management.
• Proficient in Data Modeling Techniques using Star Schema, Fact and Dimension tables, RDBMS, and Physical and Logical data modeling for Data Warehousing and Data Mart.
• Extensive experience in building Financial Budgeting & Forecasting, Contribution Margin, Sales, profit margin, variance calculations, exchange rate calculation application with Hyperion Planning (Forms, Security, Metadata Maintenance, Business Rules and Essbase Excel Add-In), and Reports.
• Strong Experience in developing outlines, Calc scripts, Rule files, report scripts, excel templates, Smart View.
• Strong experience as a Hyperion Essbase Administrator with Security Setup and Management: User Management, User roles, Shared Services setup, assigning server and application access, database calculation, filtering, assignment of application access types.
• Extensive experience in integrating Business Analysis, Multi-Dimensional Modeling using Hyperion Essbase, creating, manipulating and maintaining calculation scripts (Calc Scripts)
• Proficient in dynamically building dimensions, attributes using rule files and loading fact data in an Essbase application by means of several build methods such as Generation, Level and Parent-Child s.
• Good experience in executing data migration between different Hyperion applications.
• Expertise in integration of Microsoft Office tools with OLAP.
• Expertise in Business Analysis methodologies and iterative Software Development Life Cycle (SDLC).
• Energetic self-starter with excellent analytical, organizational and communication skills
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

OLAP: Hyperion System 11/9, Hyperion Planning System 11.x/ 4.0/3.5.1/9. x, Workforce planning, Capex Planning, HAL, Life Cycle Management(LCM), Hyperion Analyzer, Hyperion DRM, Hyperion MDM.

Reporting Tools: Hyperion Financial Reporting Studio (HFR), Hyperion Reports, Web Analysis, Hyperion Analyzer, Hyperion Spreadsheet Add-in, Hyperion System 9 Smart View.

Languages: ESSCMD, MAXL, MDX, SQL, PL/SQL, C, Java, C# net

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

Software Packages: MS Office, MS Project

Operating Systems: Windows 95/98/2000/2003/ NT/XP/Vista/7,UNIX/AIX

PROFESSIONAL EXPERIENCE

Confidential, MA

Hyperion Essbase/Planning consultant

Responsibilities:

• Designed, developed and maintained multi-dimensional databaseapplication using Essbase & Planning.
• Involved in developing design specifications of ESSBASE cube with Customers.
• Developed Aggregate Storage Cubes (A.S.O) cubes using ESSBASE.
• Provided security for various levels of users using Hyperion Shared Services.
• Used Classic administration and EPMA environment to create planning cubes with dimension library, application library.
• Developed and created Data forms for users to input the data into Essbase cube through Hyperion Planning.
• Developed and created Web forms for users to input the data into ESSBASE cube through Hyperion Planning.
• Created new users and groups, assigned existing users to those groups and grant access to the users and groups as per their specific needs to access the cubes.
• Used Filtersto control the access of those users and groups to individual data within the database to provide security at the detailed level.
• Developed andmaintained Rulefiles, MaxL Shell Scripts, Reports MDX Scripts & Calc Scripts to calculate very complex values.
• Involved in the development of calc scripts, rules files for loading budget and actual data to the Essbase cube.
• Involved in loading Meta data for planning using ODI (version 10)
• As a part of team developed the Essbase outlines, member formulas and data load rules for the Planning Application.
• Created users, groups, filters and assigned different kinds of Security access to users in Hyperion Planning Applications using Hyperion Shared Services.
• Analyzed all dimensions and members in the Essbase outline.
• Uploading metadata to Hyperion planning and data to Essbase.
• Provided the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and then adding users to the groups.
• As a part of team developed the Essbase outlines, member formulas and data load rules for the Planning Application.
• Responsible for providing to the end users.

Environment: Hyperion Essbase 11.1.2.3, Exalytics, HyperionPlanning 11.1.2.3, Smartview,11.1.2.3, 11.1.2.3, Web Analysis, FR reporting, Smart view, FDM, People Soft, Windows 2003, SQL, Microsoft Access, Windows Scheduled tasks, MAXL.

Confidential, Bellevue, WA

Hyperion Consultant

Responsibilities:

• Conducted various meetings with the users to gather and understand business requirements.
• Developed numerous Essbase artifacts such as Load Rules, Calc Scripts, and Reports Scripts.
• Extensively worked on update the substitution variables in EAS (Essbase Administration Services).
• Extensively worked on Supplemental loads (lock & send sheets).
• Created new users groups & gave provision access in workspace.
• Used smart view extensively to reconcile tie sheets
• Documented various business requirements, deployment plans and prepared various users guides to facilitate the users to learn and adapt to the new systems.

Environment: Hyperion Essbase 11.1.2.3, Exalytics, HyperionPlanning 11.1.2.3, Smart view, 11.1.2.3, 11.1.2.3, Windows 2008, UNIX, Oracle 11g, WebLogic 10. DRM.

Confidential, Herndon, VA

Jr Hyperion Consultant

Responsibilities:

• Interacted regularly and communicate effectively with users, business owners, upper management, vendors, and outside consultants during project scoping, requirements gathering, solutions design, implementation, project management, UAT, and production support
• Prepared High level Technical Document and a detail level technical specifications document for Essbase and Planning applications and objects.
• Created Essbase Block Storage (BSO) in Essbase using Essbase Administration Services (EAS).
• Developed numerous Essbase artifacts such as Load Rules, Calc Scripts, Reports Scripts and Web forms, Business Rules for Hyperion Planning Applications.
• Created Load Rules to load Metadata / data into the Essbase applications using both parent-child and generation level settings for load rules.
• Developed Report Scripts to export subsets of the Essbase database which can be used for reporting purposes and loading as data into other Essbase databases.
• Used ESSBASE functions like @IDESCENDANTS and @UDA in creating the Calc Scripts.
• Extensively used MaxL, ESSCMDS to run calculation scripts and report scripts.
• Used various types of Calculations such as Dynamic calc, Two-Pass Calculations, Intelligent calculations, involved in the performance tuning and optimization of data load calc scripts.
• Convert Smart View/excel reports into Hyperion financial reports (HFR).

Environment: Hyperion Essbase 11.1.2.1, Hyperion Web Analysis 11.1.2.1, Hyperion Planning 11.1.2.1, Smart view, ODI 11.1.2.1 Windows 2003, MaxL, Microsoft Excel 2000, Microsoft Access, Oracle 10g, SQL server.

Confidential

Hyperion Intern

Responsibilities:

• Interacted with key business users to develop functional and technical specification.
• Performed a Key role in the new development of a corporate systems Essbase implementation.
• Planning and Analyzing the Data, Defining Dimensions, Applying Analysis Rules, Developing and Generating the Outlines, Interacting with the End Users for the Report Layouts, Test Consolidations, Loading the data into the Database and Testing the Data.
• Modifying/Writing Calc Scripts, creating Rules file, Formulas, creating Filters to restrict access to cube.
• Loading Sales, Revenue, and Head Count Data to cubes, creating current Actual/Forecast/Budget members.
• Created Currency Exchange Rate tables for the Multi currencies
• Developed/Modified automated batch scripts to automate the data loading and to run Calc scripts at scheduled intervals.
• Synchronized the Test/Development Environment with the Production Environment, Used HAL to load Metadata and mapping of the Metadata with planning data.

Environment: Hyperion Essabase 11.1.2.1/11.1.2.0 , Hyperion Planning 11.1.2.1/11.1.2.0 , Excel Smart view Add-In, Oracle 10g, Microsoft Excel 2000/2003, Windows 2003