PROFESSIONAL SUMMARY:

• 7+ years of Hyperion experience in advanced analytical software applications, requirements gathering, design, development, testing and Database Administration of OLAP and Client/Server projects using industry accepted methodologies and procedures.
• Experience in advanced analytical software applications, Business Analysis, Requirements Analysis, Development, Testing, and Database Administration of OLAP and Client/Server projects using industry accepted methodologies and procedures.
• Experience in interacting with business users at various levels and converting the requirements into technical solutions.
• Expert Level experience in Hyperion Essbase, Essbase Integration Services and Hyperion Planning.
• Good experience in Essbase Cube Analysis and Design and Essbase database Administration.
• Expert Level skills in Hyperion Reports and Hyperion Analyzer.
• Experience in performing upgrade, Maintenance, database backups, Performance tuning and Optimization.
• Strong Knowledge of reporting tools like Business Objects, Cognos EP7 series and Cognos Reportnet.
• Strong Knowledge of relational database design, programming and Administration.
• Experience in knowledge transfer, preparing technical documentation, training business users
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work / project environment
• Also worked with offshore teams around the clock
• Clear Understanding of accounting concepts such as Financial Statement, Balance Sheet, Cash flow Statement

PROFESSIONAL EXPERIENCE:

Confidential, San Franscisco, CA

Hyperion Developer

Responsibilities:

• Assisted in Migration from Hyperion 9.3.1 to Hyperion 11.1.2.1.
• Responsible for gathering and analyzing requirements for the Business Management module.
• Managed access to Data Forms and Folders including assigning access and changing access using Hyperion Planning.
• Extensively involved in importing and exporting Access Permissions.
• Involved in assigning access and groups to various users of the company and maintained the applications securely using Hyperion Shared services.
• Creating and customizing data forms, asymmetric and Composite data forms, creating business rules with runtime prompts, creating task lists, managing the review cycle for planning units and review budget data by using process management, creating substitution and user variables.
• Created data entry forms to enter forms, update, analyze, print, and report on data.
• Managed Security Filters using Planning Administration.
• Production support - resolving technical and functional issues in a timely manner to resume production process in time for smooth flow of monthly/quarterly process
• Created and provision users with necessary roles on applications using Hyperion Shared Services.
• Developed outlines, MaxL Scripts, Rules Files for loading dimensions and data into Essbase cube.
• Monitoring ticketing system every day in the morning and throughout the day at regular intervals.
• Tracking all issues that we have in the Hyperion system.
• Monitored production applications and systems integrated on it.
• Have used HPSM ticketing system (Hewlett Packard System Management) to log tickets.
• Developed Rules file for specific requirement so that Alias name is displayed as per requirement.
• Developed batch scripts using MaxL for the automation of various processes.
• Optimized outlines to have faster data loads, calculation and retrievals.
• Worked extensively on security and access settings for the reports and cubes in Workspace and Shared Services.
• Migrated application from test to pre-prod and production.
• Monitored batches and helped them in resolving issues through ticketing system to get the task done before deadline.
• Testing to validate data provided by mainframe in excel add in.

Environment: Oracle Hyperion Essbase 9.3.1/ 11.1.2.1 , Hyperion Planning 9.3.1/11.1.2.1 Essbase Administration Services (EAS), Oracle Hyperion Shared Service 9.3.1/11.1.2.1 , Excel Add-in, Smart View, Microsoft Office Excel/Word.

Confidential, NJ

Hyperion Developer

Responsibilities:

• Worked on creating Public sector Budgeting (Position Only) application.
• Created Map reporting application design for reporting purpose from one BSO cube to other BSO cube and BSO cube to ASO cube.
• Worked on migration of applications form one environment to other. Migrated application from development server to Pre-Production.
• Worked on Smart lists and customizing them according to Public sector budgeting application.
• Worked on creating various financial reports on FR studio.
• Monitoring batch for every day task completion and submitting reports to my lead and manager
• Provided production support and worked on migration of reports and providing the security to different groups.
• Worked in creating the security file and importing it in planning for different environment. Using command utility for importing the sec file.
• Worked on creating the security filters for Essbase and importing them.
• Worked on metadata building and data loading using outline load utility for various dimension for different applications. Created various shell scripts for different dimensions.
• Worked on customization of workspace logon page and panel. Made changes in css file to create different themes.
• Worked on customization of Business rule and webformson out of the box one that got created during Public sector initialization.
• Build rule files and passed on different parameters for loading data.
• Worked on creating ASO cube for reporting purposes. Designed, Developed ASO cube and customized the hierarchies according to the requirement.
• Performed optimization on ASO cube and BSO cube. Developed the script for ASO cube for optimization and incremental load.
• Worked on creating Calc scripts. Some were developed for aggregation; some for data export in customize form.
• Worked on developing Business rule for allocation purposes, calculated expense.
• Developed training material and presentation for end user training.
• Provided User training and workshop, in that helped troubleshooting their problems and to get them use to new tool.
• Worked on installation and configuration of Hyperion Product Essbase and planning in Linux single server as well as clustered servers using GUI interface.
• Actively performed tasks. Involved in meetings with users for gathering requirements for implementation.
• Build shell scripts and MaxL script for automation of data loads and metadata loads.

Environment: Hyperion Essbase11.1.2.2, Hyperion Planning 11.1.2.2, Essbase Administration Services (EAS), Shared Services, Hyperion Financial reporting 11.1.2.2, Oracle Database 11.2.0.3, Windows Server 2008, LINUX 5.3, MS Excel 2010.

Confidential, Temple, TX

Hyperion Developer

Responsibilities:

• Working as an individual team/developer for various major projects, involved in application design and process flow model to meet detail technical requirements to serve as implementation guidelines.
• Responsible for gathering and analyzing requirements for the Business Management module.
• Assisted in migrating from 11.1.1.3 to 11.1.2.1
• Created the financial budgeting and planning process of the firm by interfacing with users, planners, and administrators of the system.
• Identified various planning units of the business and translated them into Dimensions and Members (Scenario, Version and Entity) of Hyperion Planning application and Essbase database
• Created planning application and data load processes using EPMA.
• Checking Error File for Dimension build, if there is any error records exists correcting and reloading those records and making sure required Outline Structure build and data load.
• Developed data forms, task lists, calculation scripts, runtime prompts, and menu lists for the users to enable them to enter financial data into the system.
• Developed Web forms using Hyperion planning web client for the users to input Forecast, Budget, Actual accounting changes and other variance explanations data.
• Developed business rules that calculate an assortment of financial data and also replicate the formula processing capabilities of Excel.
• Involved in performing DBA activities like create users, password setting, group and filters.
• Worked on FDM application and developed oracle GL interface to load data in planning application.
• Configured Essbase adaptors for FDM to match with respect to Essbase cubes.
• Created locations for different geographies and defined import format to load data.
• Created maps to handle sign flips for some accounts and to map data and different dimension.
• Extensively worked on Explicit, like, between and in mapping in FDM and mapped Single column in two dimensions.
• Built summary financial reports for the upper management and comprehensive reports for the daily users by using Web Analysis and Smart View.
• Redesigned currency conversion scripts to facilitate reporting in more than one currency.
• Identified and allocated proper access and security measures to different types of users in the company per the needs of higher management.
• Written Essbase formulas, Calculation scripts, MDX formulas as per the requirements and created substitution variables for the ease of maintenance of application.
• Written MaxL scripts to load databases, adding users, alter substitution variables and executed the scripts in both interactive modes.
• Analyzed many existing BO reports and recreated them using Web Analysis and FR.
• Created Pivots and Charts using Web Analysis.
• Extensively used Traffic Lights in Web Analysis Reports.
• Exported and Imported reports from different Workspace environment (like Dev, test and prod).
• Created and maintained connection for reports in Workspace.
• Provided production and support and acted as batch monitor to help in fixing issues and meeting deadline.
• Monitoring batch for every day task completion and submitting reports to my lead and manager.
• Build complex Smart view reports and data entry templates which had complex formulas and display sheet, used mainly for data retrieval for other sheets containing complex formulas. An input sheet was provided for reducing the effort for user to change the month and year in each cell, helping reducing the error caused by them in changing and providing fast and accurate reports.
• Lead the Hyperion training program at the company aimed at providing initial overview of Planning features to the power users and navigating the application
• Providing technical guidance and support to end-users by developing appropriate documentation

Environment: Hyperion Essbase 11.1.1.3/11.1.2.1 , Hyperion Planning 11.1.1.3/11.1.2.1 , Web Analysis, Essbase Administration Services (EAS), EPMA, FDM, Shared Services, Smart View, Web analysis, Oracle Database 11g, MS Excel 2010.

Confidential, Houston, TX

Hyperion Developer

Responsibilities:

• Translated end user requirements into application design specifications, assuring optimal match between requirements, cubes, outlines and report specifications
• Involved in Performance tuning and Performance monitoring for satisfying the users reporting requirements, including Error Handling, Troubleshooting, handling restructuring and server problems.
• Created planning applications using outline load utility.
• Created and managed numerous Web Forms and created Business Rules for multiple applications.
• Assigned user access and privileges on Web Forms and Business Rules
• Involved in the development of new cubes and modifying existing cubes. Optimized cubes by altering the Dense/ Sparse settings for the different Dimensions
• Responsible for migrating cubes to production server for the sales department, which used Hyperion Essbase as their OLAP server.
• Developed outlines, Calc scripts, data load rules for loadings
• Created various rules files for dimension building, data loading.
• Created queries using Essbase Query Designer to retrieve dimensions, database members into worksheet.
• Performed optimization for various data load rules and Calc scripts.
• Enhanced the existing Hyperion planning application to support Workforce Estimation (WFE).
• Created reports to analyze P & L at customer and product levels using Web Analysis.
• Created reports in Excel by accessing data through relational, multidimensional, BI sources.
• Performed database tuning by setting appropriate index, data and Calc cache.
• Updated User security through Shared Services and integrated it with ODI.
• Designed and developed ASO and BSO cubes for optimum analysis, performance and reporting needs.
• Developed Interactive Reports such as net margin, various reports for credit, debit, liability, variance reporting, product line analysis reports and product hierarchy reports.
• Created key performance indicators reports using interactive reporting.
• Used various conditional numeric functions to add computed columns in query, result, pivot and reports section in Interactive reporting and did problem solving and Query Tuning while report generation.
• Combined tables, Queries, Pivot, and charts into dashboard and wrote scripts to drill down in dashboard for Interactive reporting.
• Trained reporting analysts on Hyperion reports for a gradual shift to Hyperion Reports as against the traditional excel spreadsheets.

Environment: Hyperion Essbase 11.1.1.3, Hyperion Workspace 11.1.1.3, Hyperion Shared services 11.1.1.3, Oracle Data Integrator 10.1.3.4, Hyperion Planning 11.1.1.3, ESSCMD, Hyperion Interactive Reporting Studio(Brio) 11.1.1.3, Oracle 11G, PL/SQL, Excel Add-in, IIS, Windows Server 2003.

Confidential, Houston, TX

Hyperion Developer

Responsibilities:

• Developed rule files for automating the data load as against the ‘lock and send’ procedure used by the company.
• Developed complex Calc scripts that were used to allocate the values to leaf level members in Block Storage cube.
• Optimized applications by balancing out the block size with Sparse/Dense dimension alterations.
• Developed MaxL scripts to automate the process of dimension build and data loading.
• Optimized the Calc scripts resulting in the reduction of calculation time from 2 hrs. to 45 mins
• Involved in taking regular backups and restores of Essbase application. Implemented robust data access security and user management.
• Converted BSO cubes to ASO cubes for aggregation and reporting purpose using Query tracking method.
• Developed Interactive Reports such as net margin, various reports for credit, debit, liability, variance reporting, product line analysis reports and product hierarchy reports.
• Created key performance indicators reports using interactive reporting.
• Used various conditional numeric functions to add computed columns in query, result, pivot and reports section in Interactive reporting and did problem solving and Query Tuning while report generation.
• Designed aggregated view for optimization.
• Created member formula for calculation purposes.
• Involved in creating filters and assigning filters to users in Essbase for ASO cubes.
• Worked on financial reporting. Build various reports using User POV, Grid POV, Prompts, conditional formatting and conditional suppression according to requirements provided by users.
• Built summary financial reports for upper management and comprehensive reports for the daily users using Hyperion financial reporting studio.

Environment: Hyperion Essbase 9.3.5, Hyperion Financial Reporting Studio 9.3.5, Hyperion Interactive Reporting Studio(Brio) 9.3.5. Excel Add-In, Windows NT 4.0, Oracle 10g.

Confidential, Cleveland, OH

Hyperion Developer

Responsibilities:

• Designed, developed, and implemented multi-dimensional database application using Essbase.
• Designed and developed monthly, quarterly and yearlyRetail P&L Cubes.
• Developed Calc Scripts to calculate various figures for the outline.
• Developed and maintained Rule files, Calc Scripts, EssCMDs & MaxL Scripts.
• Automated the Essbase Cubes using EssCMDs and Batch Scripts.
• Developed and optimized Data Loads and Calculations.
• Optimized the Dense/Sparse configuration in the BSO cube.
• Preparing Relational Data Sources, Consolidating Relation data & developed the OLAP model & Meta -Outlines, Implemented Star Schema and used EIS to interface with the company’s existing Oracle data warehouse.
• Developed the PL/SQL stored procedures for implementing the business logic.
• Constructed Oracle Database Triggers and Indexes.
• Responsible for Code Reviews and PL/SQL Code Tuning.

Environment: Hyperion Essbase 9.3.1, Microsoft Excel 2000, MS SQL Server 7.0, Windows NT/2000, Oracle 8i, PL/SQL.

Confidential

Hyperion Developer

Responsibilities:

• Involved in the new Planning cube build process
• Configured complex rules files for attribute, alias and consolidation property associations
• Wrote new, and optimized existing calculation scripts
• Wrote batch commands and scripts in EssCmd and MaxL
• Modified Business Rules to cater to the changing business requirements
• Created users, user groups and administered security for multiple applications
• Maintained security for Planning, Business Rules and Essbase
• Performed data validation for the business rules and maintained Web Forms
• Monitoring this ticketing system every day in the morning and throughout the day at regular intervals.
• Tracking all issues that we have in the Hyperion system.
• Provided Essbase administration and optimization training to resident technical resources
• Developed and administered reports with Hyperion Analyzer and Hyperion Reports
• Built simple and complex views of data; created spreadsheet reports, graphs, and pin board displays
• Supporting month end Financial Reporting activities

Environment: Hyperion Essbase 9.3, Hyperion Planning 9.3, Hyperion Reports 9.3, Hyperion Analyzer 9.3, Windows 2000, Excel Add-In.