SUMMARY

• Over 7+ years of experience in design, analysis, development and implementation of various applications in Hyperion using Hyperion Essbase, EIS, Hyperion Planning, Hyperion Interactive Reporting, Dashboard Studio, ODI, FDMEE, Financial Reporting studio and Hyperion SmartView.
• Experience in creation and maintenance of finance, ledger, planning and reporting cubes across BSO and ASO Essbase kernels.
• Strong knowledge on multidimensional and relational database architecture.
• Involved in multiple end - to-endHyperionPlanning and Essbase implementations.
• Experience in installation, configuration, server settings, client and server installations of Hyperion products such as Hyperion Essbase, Essbase Administration Services, Essbase Integration Services, Hyperion Planning, Hyperion SmartView, and Hyperion Financial Reporting on Windows and LINUX environments.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, developing various OLAP Models and Meta-Outline.
• Experience in reporting using Hyperion Interactive Reporting (Hyperion System 9 BI+) and Hyperion Performance Suite with Hyperion Intelligence Designer/Explorer.
• Expertise in writing custom Essbase Calcscripts, automated the Essbase Cubes using MaxL, ESSCMDS and Batch Scripts.
• Experience in creating, updating maps, import format and locations in FDM.
• Expertise in database development and business intelligence modeling.
• Extensive knowledge in Essbase server upgrades across Windows and LINUX platforms.
• Utilization and understanding of Analysis & Design tools, Object Oriented methodology, Iterative development cycle, Visio, Excel macros, MS Project and PowerPoint.
• Proficient in the star and snowflake schema data modeling technique used to design for data warehouse and data mart.
• Skilled in Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Experience on creating data mapping, business process artifacts, Style Guide & GUI screens.
• Migrated applications from one environment to other using LCM process and copy application utilities.
• Migrated artifacts between Development, Test and Production Environments.
• Strong experience as aHyperionEssbase 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.
• Experience in Creating, Maintaining, and supporting all application objects including Outlines, calculation scripts, Rules files for dimension builds and data loads, Transparent partitions, and Security objects through both Essbase Administration Services (EAS) and MaxL scripts.
• Created documentation for maintenance and support for Hyperion products.
• Strong knowledge in writing test cases to validate the applications developed and performed Unit Testing.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL EXPERTISE:

OLAP Development Tools:Hyperion Essbase 11.1.2.4/9.x

ETL Tools: ODI, FDMEE, Oracle Warehouse Builder

Business Intelligence Tools: Hyperion Planning 11.1.2.4, Hyperion Essbase and Hyperion System 11x/9x.

Reporting Tools: Business Objects, Hyperion Visual Explorer, HFR, Hyperion Interactive Reports 9x, Excel-Add-In, Hyperion Smart view.

Operating Systems: MS-DOS, LINUX, WINDOWS 2008

Databases: Oracle 12C/11i/10g, DB2, MS SQL Server 2000, MS Access, Oracle SQL Loader, Microsoft DTS

Hardware Platform: SUN Solaris, Windows 2008/NT Servers

Languages: C, MS Visual C++, SQL, PL/SQL

Dimensional Modeling: Star-Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables, Physical and logical data modeling

PROFESSIONAL EXPERIENCE:

Sr. Hyperion consultant

Confidential, Seattle, WA

Responsibilities:

• Worked on implementation of Hyperion Planning and Essbase applications in every phase of the implementation life cycle.
• Designed 4 region based Budget related Hyperion Planning applications (Americas, EMEA, APAC and Greater China) and 2 Essbase applications for reporting purpose in Hyperion 11.1.2.4.
• Involved in requirement gathering sessions for Expense Planning, Labor Planning, revenue planning and reporting applications.
• Made all Hyperion Planning applications as Hybrid applications by adding Hybrid settings in Configuration file.
• Populated all the dimensions with latest metadata which is coming from Workday by using FDMEE.
• Optimization of BSO cubes, Custom setting type of compression, data cache, calculator cache settings, and allocation of dense/spare configuration relating to hourglass model to have optimum database block size.
• Created Locations, data load rules and data load mappings in FDMEE and loaded Actuals data to all ESSBASE and Planning applications through data sync.
• Developed different type of web forms both simple and composite for entering Revenue, operating expenses and employee salaries data by cost center.
• Created separate Task lists for Finance users, Finance controllers and Budget Leads in all 4-region based Hyperion planning applications.
• Developed different type of business rules and Calcscripts to calculate allocated expenses based on revenue percentages, Base salary calculation based on hourly rate and expense type, Bonus, compensation calcs based Commission plans and statistical driver based calculations.
• Performance tuning and Optimization of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulas.
• Developed some special business rules to move the data in between the cubes dynamically (data integration between the cubes) and used @XWRITE function because of the data dependency between the cubes.
• Created 2 Essbase applications for reporting purpose. One is to report Clint revenue Actuals data at granular level, payroll data and head count related data and the 2nd cube is to report variance between Actuals and Budget/Forecast data at the same level.
• Used FDMEE for Budget/Forecast data integration from all planning applications to Essbase reporting application.
• Developed different kind of reports by using Financial Reporting Studio such as Income statement summary report, income statement variance report, Revenue by region and sub region reports. Created batches for all these reports and used burst reports method to run these reports by service line and market.
• Written automation scripts using MAXL for daily data backups, weekly backups of all the applications and objects.
• Provided user training to Finance team, prepared process document for each cube and administered end to end process for all Hyperion applications.
• Created Ad-hoc reports for Finance team using smart View as per the request.
• Worked on migration of all the Hyperion applications from one environment to another environment using LCM.
• Provided day to day production support after the applications go live.

Environment: Hyperion System 11, Hyperion Essbase 11.1.2.4, Hyperion Planning, Workday, Windows 2008, Hyperion SmartView, Hyperion Financial Reporting Studio and FDMEE.

Hyperion Essbase/Planning Developer

Confidential, Houston, TX

Responsibilities:

• Worked on full life cycle of the new Hyperion planning application and Essbase applications starting from new source systems (Peoplesoft).
• Implemented Hyperion Planning Classic applications from the scratch to the Go Live.
• Participated in development and design of the Hyperion Planning application with 5 Plan types.
• Participated in decision making of dimensional structure and building hierarchy of Hyperion applications.
• Analyzed all dimensions and members in all 5 plan types in Hyperion Planning application and also all dimensions in Essbase applications.
• Performed excellent balance of dense and sparse dimensions, arranged in modified hourglass model.
• Developed alternate hierarchies, UDAs and Attribute dimensions.
• Set up locations, category mapping, periodic mapping and import formats for FDMEE.
• Configured users and access rights in FDMEE.
• Involved in redesigning and restructuring of dimensions during the design stage.
• Developed load rules to load the data and metadata in both Essbase and Hyperion Planning application.
• Developed calculation scripts to aggregate the database and complex Business rules for both Projections(Forecast) and Budget calculations such as Inflation rates calculation, Revenue calculation, Net Assets rolling forward, FTE calculations, Bonus and Benefits, Payroll and Capital projects planning calculations.
• Performed Optimization and performance tuning of the developed calculation scripts and Business rules.
• Developed some complex web forms such as composite web forms and created substitution variables, Global variables for Year, Version, Entity and Scenario.
• Developed MAXL scripts for the automation of data load and metadata loads.
• Created ODI interfaces and sequences to load the data and metadata from source system (Peoplesoft) to Hyperion Applications.
• Developed Smart views adhoc Reports for Gross Revenue, Bonus and Benefits.
• Developed different kind of reports such as Income Statement, Balance Sheet, Cash flow, Variance Report, Expense Report and Cumulative statistics (Volumes) Report by using Hyperion Financial Reporting Studio.
• Defined and setup the application security in Hyperion Planning such as dimension level security, Web forms security, workflow security, Task list security and Business rules security.
• Involved in providing security authentication for the users of Hyperion Planning/Essbase and created new users, groups and provisioned them according to the security matrix.
• Performed ad-hoc queries for validation and reconciliation of the data.
• Migrated Hyperion planning application, Essbase application and reports from one environment to another environment.
• Prepared the documentation and templates for Inventory of all the objects for the users.

Environment: Hyperion System 11, Hyperion Essbase 11.1.2.3.5, Hyperion Planning 11.1.2.3.5, PeopleSoft, ODI, Windows/UINX, Hyperion SmartView, Hyperion Financial Reporting Studio.

Senior Hyperion consultant

Confidential, Dallas, TX

Responsibilities:

• Provided Hyperion administration and development working with the team at American Airlines.
• Administered and knowledge on installation, configuration, and optimization of Hyperion System 11.1.2 Essbase, Planning, Financial Reporting and Interactive reporting.
• Migrated number of applications from Hyperion 9.3.1 to version 11.1.2.1. Created newly enhanced Hyperion planning and Essbase applications in the new system 11 environment as per the new requests from functional users after the upgrade.
• Written batch scripts and shell scripts for daily backups, weekly backups and monthly backups. And also written complex MAXL scripts for dimension building and data loading.
• Performed troubleshooting, root-cause analysis, solution development in existing applications and involved in every phase of newly enhanced Hyperion Planning/Essbase application design.
• Developed SQL load rules by deleting existing flat file load rules to extract data and metadata directly from source system.
• Developed new calcscripts and business rules as per the new enhancement requests from Finance team.
• Modified existing web forms, created new web forms and added validation rules in some of the web forms as per the requirement.
• Provided management reports, query, and analysis capabilities for a wide variety of data sources in a single coordinated environment in Hyperion Workspace.
• Performed on Interactive Reporting (BRIO) and Hyperion Financial Reporting Studio V 11.1.2.1 for Reporting based on Financial and Quantity related data. Report optimizations, functions, dashboards and formatting for the customer. Worked on reports rationalization, functional and technical documentation, unit testing and integration testing of reports.
• Configured different user directories such as LDAP, MSAD and migrated users.
• Performed immediate recovery of crashed databases and also defragmentation of cubes.
• Performed document changes according to SDLC.
• Performed Daily monitoring and analysis of applications across multiple servers.
• Conducted boot camps for Installation of Hyperion v11.1.2.1 for the administrators and training them to handle the configuration issues.
• Given Training of lead (advanced module) and new Essbase developers (fundamental module), Business users (reporting) on Hyperion Essbase, EAS, Smart view and Hyperion Financial Reporting Studio.
• Provided technical support to diagnose and troubleshoot various issues for Essbase developers and business users both within the group and across the organization.
• Involved in Meetings with Project Managers, Business Users and Business Analysts during various stages of the application development lifecycle.

Environment: Hyperion System 11.1.2.1/9.3.1, Hyperion Essbase 11.1.2.1, Hyperion Planning 11.1.2.1, Oracle 11i, Toad 8.0, Solaris/Aix UNIX, Essbase Excel-Add in, Hyperion SmartView, SQL Loader, Oracle Financials.

Hyperion Administrator

Confidential, Kenilworth, New Jersey

Administrative responsibilities:

• Supervised the migration of the Hyperion Planning environment to Hyperion System 11. In addition to rebuilding all the Hyperion applications, which also included a new deployment of Hyperion Workforce Planning.
• Worked on procedures related to Planning 11.1.2.1, Allocations with finance and business users to understand requirements and translated them into Hyperion Planning/Essbase tasks and vice versa for other Finance users.
• Responsible for Upgradation of Essbase from 9.3 to 11.1.2 and Identified database settings on Windows platform.
• Customized configuration of Essbase server configuration file based on analysis of applications on server and the physical server kernel settings.
• Responsible for Optimization of BSO cubes: Custom setting type of compression, data cache, calculator cache settings, and allocation of dense /spare configuration relating to hourglass model to have optimum database block size.
• Optimization of ASO cubes - identifying views based on members, creation of load buffer, aggregation views. Generation of load buffers for faster load of ASO cubes.
• Automated process of all Essbase cubes using shell and batch scripts, Created and maintained users, groups and filters across Essbase servers
• Analyzed and converted compatible BSO applications to ASO applications for improved performance
• Maintained EIS applications across NT platforms.
• Defined and setup the application security in Hyperion Planning, Hyperion Essbase and Essbase Integration Services.
• Involved in providing security authentication for the users of Hyperion Planning and maintaining workflow management process
• Performed ad-hoc queries.
• Administered the Enterprise wide deployments of Essbase.
• Deployment of EAS console and Essbase client for application developers.
• Created new BSO /ASO applications including planning, ledger and reporting cubes.
• Created custom rules files for database build and load purposes.
• Supported various applications including currency cubes for Business Analysts/System Advisors within the Confidential
• Created ODI interfaces and sequences to do the dimension building in Hyperion Planning Applications and Hyperion Essbase applications. Migrated all the mappings from HAL to ODI.
• Using Hyperion Financial Reporting Studio, developed various reports to provide executives, business users and analysts with the most intuitive user-directed relational query and capabilities.
• Used various types of Calculations such as Dynamic calc, Two-Pass Calculations, Intelligent calculations for Outline Calculations.
• Modification of cubes based on new business requirements from Business and Financial Analysts.
• Performed conversion of all ESSCMD scripts to MAXL scripts
• Creation of custom templates and reports for Business users using excel (query designer) and Hyperion visual explorer. Creation of technical documentation for Essbase Applications.
• Creation and support of applications for Services group (the Sales, Supply chain and Marketing Division of Merck Corporation) located both at the World Headquarters and at the World Technical Centre.

Environment: Hyperion System 11/9.3, Hyperion Planning v11.1.2.1, Hyperion Essbase, EAS, EIS, Oracle 10g, Linux, Essbase Excel-Addin, SQL Loader, Hyperion Visual Explorer, EPMA 11.1.2.1

Hyperion Planning/Essbase Developer

Confidential, San Francisco, CA

Responsibilities:

• Involved in gathering requirements from the SME’s.
• Based on the requirements gathered from the SME’s developed the OLAP Models and Outlines.
• Developed applications which included both ASO and BSO cubes.
• Created transparent partition between ASO and BSO cubes.
• Implemented Hyperion Planning and Worked with Hyperion Planning in developing web-based forms for the various budgeting purposes and implemented whole security matrix in Hyperion Planning.
• Creation of multiple dimensions in different applications, loaded members in Hyperion Planning using Hyperion Application Link (HAL)
• Optimization of Data Load Rules and Calc Scripts.
• Views from Teradata are used to feed the applications using Essbase Integration Services.
• Developed many data load rules for loading specific type of data files.
• Wrote various calculation scripts and member formulas.
• Involved in building test cases for the applications.
• Involved in performance tuning and testing various tools.
• Assigned access for users to the application for their reporting and other purposes.
• Converted various forecasting and planning tools from legacy system Mars2xl to Essbase.
• Developed forecasting tool for the Inventory management team called as IM Regv which had a write back and Actualization functionality.
• Developed Build sheets for the business partners to have trends of the history data for each of the product.
• Developed Merchandise performance recap report to assess how each product is doing in different regions.
• Developed alternate hierarchy for one of the existing applications as part of BI enhancement project.
• Administrated various Essbase applications and various forecasting and planning tools.
• Automated multiple reports to be refreshed on a single click of a button by applying module of VB code.
• Automated the backup process for all the applications.
• Trained business partners to use Essbase add-in for the adhoc queries and helped them to build their own tools for different purposes.
• Developed various reports using Hyperion Financial Reporting studio based on the requirements gathered for the SME’s.

Environment: Hyperion Essbase Administration Services 9.3.1, Hyperion Essbase Integration Services 9.3.1, Hyperion Essbase add-in, Hyperion Workspace 9.3.1, Teradata 12, Windows XP, Microsoft Office 2007.

Hyperion Essbase/Planning Developer

Confidential Warren, NJ

Responsibilities:

• Developed a financial data models to support their Data Warehousing and Financial Reporting needs.
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Involved in installation and up-gradation of Hyperion Essbase, Essbase Integration Services.
• To develop the structure of having three ASO cubes and a BSO cube which will be the interface for the three ASO cubes developed models.
• Created the partition between the three ASO cubes and the BSO cube. ASO cubes will act as source which will feed the BSO cube.
• Each source ASO cube contains the data for different scenarios such as one with Actuals other with planned data and Forecast.
• The Source cubes are fed by an hourly update of an Essbase Integration Services data mart.
• A relational data model enhanced the existing operational data store to permit drill thru to relational querying in Essbase Interactive Reporting and Excel Add-in client.
• Used Hyperion Planning 9.3.1 to 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 9.3.1 was used to provide financial planning analysis. Created new calculation scripts and defined business rules to match the needs of the users
• Created data entry forms to enter forms, update, analyze, print, and report on data.
• Hyperion Planning 9.3.1 was used in testing of the new calculation scripts.
• Hyperion Planning 9.3.1 was used to define business rules with run-time prompts or allocation sequences to match the needs of the users.
• Involved in migration of entire Development environment to Production environment
• Involved in migrating planning applications, Business rules, Reports.
• Generated various reports based on the requirements using Hyperion Financial Reporting Studio.
• Defined queries with cube navigators formatted spread sheet add-in and saved the reports as web page.
• Worked closely and pro-actively with project leadership to identify and resolve key risks with the Hyperion upgrade project.
• Provided technical leadership and mentoring, helping those on the team less familiar with Hyperion System 9 to come up to speed.
• Intervened in production support issues as necessary to improve issue turnaround time as well as the customer's perception of the team's customer service.

Environment: Hyperion Essbase Integration Services 9.3.1, Essbase Administration Services 9.3.1, Hyperion Shared Services9.3.1, Hyperion Workspace 9.3.1, Hyperion Planning 9.3.1, Hyperion Interactive Reporting 9.3.1, Hyperion SmartView 9.3.1, Oracle 10i, Windows Server 2003.

Confidential

Hyperion Administrator

Responsibilities:

• Production Support for the existing Hyperion System 9.
• Performing monthly Financial close procedure which involves
• Extracting Actual data from SAP and loading in to Essbase.
• Copying data across Essbase applications.
• Opening and closing financial forecast for Users and Controllers.
• Generating monthly Summary reports.
• Involved in requirement gathering for setting up new Hyperion environment for Siemens Canada group.
• Implemented 4 Essbase applications for Siemens Canada & USA as per request to support their reporting.
• Worked as an Essbase DBA, which involved predefining data mapping from Hyperion Essbase to the relational source, and running ad-hoc queries for providing optimized reports.
• Created and managed login restrictions for the OLAP Server.
• Analyzed financial results and prepared trend reports to support business managers make profitable decisions.
• Provisioning and creating Users to access Hyperion System.

Environment:Hyperion system, Essbase (ASO, BSO), Financial Reporting 9.3.1, Windows 2005, SQL Server, SAP.