SUMMARY

• 9 Plus years of rich experience in IT including over 6+ years’ experience in design, analysis, development and implementation of various Hyperion applications using Hyperion Essbase, Essbase Administration Services, Hyperion Planning, Oracle Data Integrator (ODI), Hyperion Financial Reporting, Interactive Reporting, Hyperion Smartview, Hyperion Web Analysis, ESSCMD, MaxL and Essbase Excel Add - in.
• Working knowledge of financial and accounting within the Business organizations.
• Experience 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 use cases as well as user stories.
• Experienced in working with multiple applications within EPMA andintegration between Hyperion planning and Essbase.
• Extensive experience in designing and developing OLAP cubes from a conceptual level.
• Expertise in Calc scripts, MaxL, ESSCMD, Hyperion business rules, Dimension build rules, Partitioning, Data load rules and report scripts.
• Experience in Data integration through ODI, scheduling and loading of metadata/data for Planning, Aggregate Storage (ASO) and Block Storage (BSO) database models.
• Created various Calc scripts according to the requirements and needs and worked with multicurrency applications.
• Applying quantitative methods to analyze synthesize and interpret information from multiple data sources.
• Experience with testing of the applications.
• Expertise in creating business rules in calculation manager using run-time prompts and design time prompts.
• Capable of managing organization’s data, assess and fulfill its reporting needs and develop powerful solutions that have true impact on the performance of a company.
• Functional knowledge of financial statements, budgeting, forecasting and planning processes that facilitate creation of powerful Hyperion solutions including workforce estimation and capital expense planning.
• Involved in installing, configuring, upgrade and documentation of Hyperion System 9.x and 11.x, including Workspace.
• Managing security, permissions, users and groups, controlling access to database cells through managing filters, filters: creating, copying and assigning filters.
• Extensive involvement in maintenance, automation, backups, Performance tuning and Optimization of Essbase cubes, Calc scripts, reports and applications to facilitate effective business decision making.
• Support user training, documentation and rollout of new projects.
• Versatile team player with excellent leadership and inter-personal skills.

TECHNICAL SKILLS

OLAP and BI Tools: Hyperion Essbase 11.x/9.x/7.x/6.x, Hyperion Planning, EPMA, Oracle Data Integrator (ODI), Essbase Integration Services (EIS), Essbase Studio, Workspace, Smart View for Office, MS Excel Add-In

Reporting Tools: Hyperion Financial Reporting (FR), Web Analysis and Hyperion Reports

Office Tools: MS Office Suite 2007/2003/2000

Languages: ESSCMD, MaxL, MDX, SQL, PL/SQL, C, C++, VB, Java

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

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

PROFESSIONAL EXPERIENCE

Confidential

Environment: Hyperion Essbase 11.1.2.1, Hyperion Essbase Integration System(EIS), Hyperion Studio, Hyperion Planning 11.1.2.1, Hyperion Shared Services 11.1.2.1, Workspace, Hyperion Smart View, Hyperion Financial Reports 11.1.2.1

Lead Essbase & Planning Consultant

Responsibilities:

• Review Business requirement documents (BRD) for ongoing project enhancements.
• Provide the optimal solutions considering business and technical aspects to the development team as per the user requirements.
• Coordinate with the platform team to consider the impacts of BRD's on the system.
• Work closely with Product and Services tracks to understand and evaluate their workflow, processes and systems
• Interact with Business team and discuss design changes/implications with them in Business terms.
• Troubleshoot and Performance Tuning for Hyperion Planning and Essbase.
• Review Hyperion Planning and Essbase design and provide/implement recommendations.
• Interact with support team to support and get engage in resolving issues came during Monthly forecast cycle
• Recommended various approaches of optimizing the web forms and reduce the load time
• Published documents related to optimization e.g., Calc script, data forms, data load, database settings, etc. on Cisco Doc (including Hyperion Best Practices and application specific) for both Product and services
• Interact with development team to implement and track optimization areas
• Work with infrastructure team to upgrade applications and recommend patches on a timely manner to ensure optimal performance and high system availability
• Engaged in optimizing resources utilization of infrastructure
• Developed Financial and Management Reports using Hyperion Financial Reporting Studio and Smart-View for Essbase, Hyperion Planning, and HFM application.
• Built various reports like the Income Statement, Balance Sheet, Run-rate analysis and other region specific reports.
• Worked on Related Content Links for detailed analysis of P&L accounts at cost center level.
• Acted as a liaison between other report developers and the migration team to promote financial reports from Development environment to Testing to Production environment

Confidential

Environment: Hyperion Essbase 11.1.1.3 and 11.1.2.1, Hyperion Essbase Integration System(EIS), Hyperion Studio, Hyperion Planning 11.1.1.3 and 11.1.2.1, Hyperion Shared Services 11.1.1.3 and 11.1.2.1, Workspace, Hyperion Smart View, Hyperion Financial Reports 11.1.2.1, Financial Data Quality Management (FDQM) 11.1.13 and 11.1.2.1, Windows XP

Sr. Hyperion Planning & Essbase Consultant

Responsibilities:

• Helping users understand and follow the process, understanding mappings, setting application preferences, etc.
• Involved in creating the load utility batch files for the dimension member loading and the data loading into the application.
• Designed and developed simple and composite Data Forms and created Business Rules for the application.
• Created Smart-Lists to be associated with the Account dimension to be used in data forms.
• Created Menus for User selection of dimensions to be made available for data entry.
• Designed and developed reports for Cash Flow, Depreciation, Project Approval, Spend and Variance based on various Cost-Centers and Capital-Projects.
• Created batch scripts and scheduled them to automate the process to run ESSCMD/Maxl to take regular backups.
• Involved in making the Essbase backups and restores of Essbase application.
• Performed Optimization using Hour glass design technique, during Data Loads and while calculating.
• Performed Performance tuning by using the dense/spares settings and developed the required alternate rollups for reports.
• Developed Financial & Internal Reports using Hyperion Web Analysis Reporting Studio Version 11.1.2.1
• Created Test workbooks for Lock and Send of data for testing purposes.
• Involved in the System Testing and Unit Testing of the Reports.
• Developed Training documentation with elaborate explanation of application working for user understanding.
• Involved in Automation of the reports using Workspace.
• Participated in the support development for another ongoing Expense and Labor Planning applications.
• Optimized the existing business rules and Calculation scripts.
• Worked on Security/Access troubleshooting and modifications
• Worked on Initiating the new planning/forecasting cycles
• Worked on setting monthly budget cycle and provide system to users.
• Metadata management (i.e. add/delete/move entities and accounts, changing attributes, etc.)
• Data management support (i.e. mapping updates, reconciliation support for end users, etc.)
• Managing databases and services (i.e. start, stop, restart, coordination for outages, working through IBM - for relational database issues, etc.)
• Managing/Coordinating scheduled jobs as needed based on other business and/or technical activities
• Coordinating system upgrade timelines and activities - working with technical support teams

Confidential, Chicago, IL

Environment: Hyperion Essbase 11.1.2.1, Hyperion Essbase Integration System(EIS), Hyperion Studio, Hyperion Planning 11.1.2.1, Hyperion Shared Services 11.1.2.1, Workspace, Hyperion SmartView, Hyperion Financial Reports 11.1.2.1, Hyperion Interactive reporting, Windows XP, MS SQL Server 2005

Sr. Hyperion Planning & Essbase Consultant

Responsibilities:

• Involved in the implementation of Hyperion System 11.1.2.1 and configured the system (Essbase, Financial Reporting and Smart View).
• Involved in different activities of project such as information meeting, analyzing it, documenting business/functional requirements.
• Designed many Essbase cubes for many departments as per the BRD and optimized them for better performance.
• Improved data loading and database calculation by modifying the Essbase configuration
• Maintained cubes and took regular backup.
• Migrated and took backups of different Hyperion applications across Development, Test and Production environments.
• Maintained the security of users and groups for various Hyperion components using the native Open LDAP and User directories in User Management Console.
• Involved in Creating Data Forms and Folders and Customizing Data Forms.
• Used procedures to generate complex reports.
• Created many Web Reports and wrote queries, analyzing data, producing reports using Hyperion Designer and translating functional requirements into technical specifications.
• Implemented Row level security on Reports..
• Worked on the creation of alternate hierarchy for the ASO cube.
• Used Views and Stored procedure on that view to create complex Dashboards.
• Used HTML procedures and Stored Procedures to generate complex reports.
• Implemented Spotlight feature in Report Sections.
• Analyzed the financial budgeting and planning process of the firm by interviewing users, planners, and administrators of the system.
• Translated various planning units of the business into Dimensions and Members (Scenario, Version and Entity) for Hyperion Planning application and Essbase database.
• Developed data forms, task lists, calculation scripts, and menu lists for the users to enable them to enter financial data into the system.
• Created Planning applications using workspace (EPMA) and Planning studio.
• Led the Hyperion training program at the company, aimed at providing initial overview of Hyperion Planning features to the users.
• Created Key Performance Indicators report using Interactive Reporting.
• Used various conditional numeric functions to add computed columns in query, result, pivot and report sections in Interactive reporting and did Problem solving and Query Tuning while report generation.
• Designed and developed various types of reports (Pivot, Tabular, and Chart reports) to be used by different user groups using Hyperion Interactive reporting.

Confidential, Philadelphia, PA

Environment: Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, EPMA 11.1.1.3Oracle Data Integrator (ODI) 10.1.3.4, Hyperion Shared Services 11.1.1.3Workspace, Hyperion Smartview, Hyperion interactive reporting 11.1.1.3, Hyperion Financial Reports 11.1.1.3MS SQL Server 2005, Windows XP

Sr. Hyperion Planning & Essbase Consultant

Responsibilities:

• Requirement analysis and documentation leading to an effective Hyperion solution incorporating user needs of converting Excel based Budgeting and Forecasting Process to Hyperion Planning in-order to increase efficiency
• Designed data integration using Oracle Data Integrator (ODI) by setting up sources and targets using ODI Topology Manager, creating Designer models, developing integration interfaces and additional components
• Configured ODI agent and leveraged Knowledge Modules to define workflow and task automation
• Used Journalization feature of ODI in-order to keep track of changes in data at the source level
• Designed Outline layout, forms to facilitate Revenue budgeting at a quarterly level and Costs at a monthly level
• Created business rules that replicate the functionality of complex formulas existing in excel
• Developed Dynamic Web forms for various users with POVs and Pages
• Designed the overall workflow of the budgeting and forecasting process with kick-off, reviews and approval states
• Maintenance and support of the Hyperion Planning applications created
• Implemented application security process, created users/groups, security profiles and application access to different groups using filters
• Created Calc scripts for various purposes for example if the company paid the policy holder more than certain period of time was that customer still with the company or not.
• Performed allocation for different departments to increase the business performance.
• Created Aggregate Storage (ASO) application from the Block Storage (BSO) applications for executive level reporting
• Created financial reports using Prompts, User POV, Grid POV, Conditional Suppression and Conditional Formatting
• Developed Reports to compare against different months & years, entities and scenarios using SmartView
• Extended the functionality of the planning system to include workforce estimation planning
• Provided user Documentation, Training and Production support as part of the Implementation

Confidential, Atlanta, GA

Environment: Hyperion Planning 11.1, EPMA, Essbase Administration Services (EAS)Oracle Data Integrator (ODI) 10.1.3.4, Hyperion Shared ServicesHyperion Web Analysis, Hyperion SmartViewOracle Database 10g, Windows Server 2003, MS Excel 2003

Sr. Hyperion Planning & Essbase Consultant

Responsibilities:

• Interacted with Business Users for gathering requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations.
• Developed Rules file for Dimension Building and performed Metadata and Data loading
• Developed business rules and calc scripts to derive complex calculations such as cash cost per user, YTD commitment, variance, capital expenditure forecast and budgeted cash flow statements
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data
• Created reports using Hyperion Web Analysis Studio and SmartView for monthly, quarterly and annual data
• Created and maintained ASO/BSO cubes as per user requirements and performed optimization by using appropriate dense/sparse configuration, outline structure strategies such as dynamic calculations, attribute dimensions, partitioning etc. and optimization of calc scripts and tuning of calc cache
• Designed Task lists and workflow process for all the Planning applications.
• Created various business rules according to the requirements.
• Design currency conversion tables to deal with multicurrency applications.
• Created Hyperion Security by creating Users, Groups and Filters for Analytic Services and Hyperion Reports in Shared Services
• Created Data Integration interfaces, procedures and projects for loading SQL and File System data into Planning and Essbase using ODI
• Use of Operator GUI within ODI in-order to debug data loading issues and also schedule procedures
• Integrate Shared Services Security with ODI Security for centralized management of security
• Created documentation for the users and provided required training for data entry and reports

Confidential, New York, NY

Environment: Hyperion System 9, Hyperion Planning 9.3.1Hyperion Financial Reporting 9.3.1, Hyperion Shared Services 9.3.1Hyperion Smart View, Workspace, Windows NT, Oracle 10g

Hyperion Planning Consultant

Responsibilities:

• Interacted with Business Users for gathering requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations
• Created Budgeting and Forecasting applications using Hyperion Planning for the Finance department
• Identified planning metadata requirements and loaded metadata
• Developed Load Rules to automatically validate the data and feed into Essbase
• Extensively involved in creating web forms and business rules
• Designed reporting and input templates and developed numerous Financial Reports like Profit & Loss Reports, Income statement Reports, Expense Reports & Revenue Reports using Hyperion Financial Reporting
• Interacted with end users on a regular basis to capture business requirements
• Supported existing cubes, problem identification, resolution and documentation
• Provided user training on data entry and report generation steps

Confidential, Denver, CO

Environment: Hyperion Essbase 7.0.1, Hyperion Reports 7.0.1Hyperion Planning 3.5.1, ESSCMD, Windows NT 4.0/2000

Hyperion Planning & Essbase Consultant

Responsibilities:

• Designed, developed and supported financial and management cubes and reports
• Develop Rules file and perform Monthly loading of metadata and data
• Developed and implemented Dimensions and member Attributes
• Involved in budgeting application using Hyperion Planning
• Used Hyperion planning to create Planning Applications with Business rules and data forms
• Uploading metadata to Hyperion planning and data to Essbase
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data

Confidential, Chicago, IL

Environment: Hyperion Essbase 6.5.4, Essbase Integration Services 6.5.Hyperion Planning 4.0/3.5, Hyperion Reports 6.5, Hyperion Analyzer 6.5Excel-Add-in, MS Access, Oracle 9.x

Hyperion Planning & Essbase Developer

Responsibilities:

• Developed EIS OLAP Models and Meta outlines for the cube.
• Restructured and redesigned previous Essbase cubes.
• Extensively used MaxL, ESSCMDS for creating batch files for automation.
• Created Hyperion Planning applications and data forms to replicate sample Excel Mock Up’s.
• Prepared quarterly forecasts, annual budget, ad-hoc reporting and management reporting using Hyperion Reports and Hyperion Analyzer.
• Involved in defining requirements, functional specifications and designing
• Responsible for providing training to the end users.

Confidential, Springdale, AR

Environment: Hyperion Essbase 6.5, Hyperion Essbase Spreadsheet Add-inHyperion Essbase Reports 6.5, Windows 2000, Oracle 9i

Hyperion Essbase Consultant

Responsibilities:

• Translated end user requirements into application design specifications, assuring optimal match between requirements, cubes, outlines and report specifications
• Involved in the development of new cubes and modifying existing cubes
• Optimized cubes by altering the Dense/ Sparse settings for the different Dimensions
• Developed outlines, ESSCMD scripts, Calc scripts, data load rules for loadings
• Created various rules files for dimension building, data loading
• Created reports in Excel by accessing data through relational, multidimensional, BI sources and refreshed them periodically using Smart View
• Created queries using Essbase Query Designer to retrieve dimensions, database members into worksheet

Confidential

Environment: Oracle 10g, SQL DEVELOPER, TOAD

PL/SQL Developer

Responsibilities:

• Involved in creating Functional and Program Specification documents
• PL/SQL Development and Implementation
• Involved in creation of Partitioned Tables and Indexes, Packages, Stored Procedures and Triggers
• Involved in writing complex SQL Queries to implement the business requirements
• Involved in loading data into Database using SQL*Loader
• Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS (Native Dynamic SQL)
• Involved in cleaning and maintaining migrated data
• Involved in Index Monitoring for identifying the Unused Indexes
• Created Functional and Technical Design documents

Confidential

Environment: Oracle 10g, SQL DEVELOPER, TOAD

PL/SQL Developer

Responsibilities:

• Designed and developed database packages, procedures, functions and triggers
• Involved in writing complex SQL Queries to implement the business requirements
• Made enhancements and applied defect fixes using PL/SQL and TOAD.
• Created summary reports to address fix/enhancement code change to support design specifications and user feedback
• Created Issue Resolution documents and plans for minor enhancements.
• Involved in creating Functional and Program Specification documents
• Involved in analyzing Schema’s, Tables and Indexes as part of OPTIMIZATION