SUMMARY

• 8years of professional IT experience in OLAP, Business Analysis, Requirements gathering, Designing, Developing and Testing of Hyperion Enterprise Performance Management EPM applications.
• Strong experience in Hyperion Planning 11.1.2/11.1.1.3/9.3.1/4. x,Hyperion Essbase 11.1.1/9.3.1/7. x, Hyperion Financial Reporting, Hyperion Web Analysis (Web Analyzer).
• Well experienced in Planning Application implementation from end to end includes architecting, designing the metadata, building, loading data. Worked with Business unit, Process unit, Review process, Rules.
• End to End implementation of Planning for Budgeting/Forecasting for the business is developed.
• Applications in Planningare implemented with all the Data forms/Business rules for the business required.
• Extensive experience in creating reports using Financial Reports, Essbase Excel Add - In, Hyperion Analyzer, Smart view, EIS, MDM or DRM, ODI, EPMA.
• In Planning, Hands-on expertise in Dynamic dimension building, Data Loading using Rule files, creating Ad-hoc reports using Excel Add-In, Hyperion smart view.
• Expertise in writing Calc Scripts, Report Scripts and Load rules.
• Implemented/Installed the EPM applications Essbase 11.1.1(1, 3)/9.3.1/, Planning11.1.1(1, 3)/9.3.1 in Windows Server 2003.
• Creating Macros/ CDF’s using VB scripts through Excel Spreadsheet Add-in, Smart-View.
• Extensive Knowledge of ESSCMD, MAXL scripts, Member Formulasand Essbase Analytic services.
• Strong experience on Essbase Cube analysis, design and development, Essbase database administration and performed Up gradations,Maintenance, Database backups, Performance tuning, optimization of BSO/ASO Cubes, Dense/Sparse settings, partitioning etc.
• Created & Used HALroutines to update the metadata changes in Planning.
• Involved in developing Web forms usingHyperion planning web client for the users to input forecast, budget, actual, accounting changes and other variance explanations data.
• Possess excellent project management skills in managing, developing and implementing the project. Possess excellent analytical, interpersonal, logical, communication skills, reliable and great team player.
• Experienced in knowledge transfer, preparing the required documentation and training the clients.
• Possess excellent analytical, logical, communication skills, familiar with the SDLC methodology of system development.

TECHNICAL SKILLS

OLAP Development Tools: Hyperion Planning 11.1.1/9.3.1/4. x, HyperionEssbase 11.1/9X/7.x/6.5/6.2 Hyperion System 9.3.1 BI+, Hyperion System 9.3.1 BI+ Analytic Administration Services, Hyperion System 9 Application Link (HAL), Hyperion System 9 BI+ Financial Reporting, Hyperion Planning, Hyperion Web Analyzer, Esscmd, MaxL, Hyperion Reports, Hyperion Enterprise and Hyperion Essbase Administration Services console (EAS), ASO/BSO, Hyperion Data Integration Management (DIM).

Dimension Modeling: Star-Schema Modeling, Erwin Snowflake Modeling, Fact and Dimension Tables.

Databases: Oracle 10g/9i/8i, DB2 UDB, MS SQL Server 2005 and MS Access.

Languages: SQL, PL/SQL, Perl.

Operating Systems: Windows NT 4.0/XP/2000/2003 and UNIX.

Server Applications: Apache-Tomcat, Active Directory, Terminal Services, Outlook Web Access (OWA), Front Office, Web logic 8.1

Reporting Tools: Hyperion Analyzer 7.x/6.x/5.x, Hyperion Financial Reports 9.x/7.x/2.x, SmartView, Essbase Excel Add-in

PROFESSIONAL EXPERIENCE

Confidential, MD

Hyperion Planning Developer/Analyst

Responsibilities:

• Hyperion Planning was used to build the Planning & Budget application from the scratch to meet the Business functional requirement and to map the data from external source applications.
• End to End implementation of Planning for Budgeting and Forecasting for the business is developed.
• Create Metadata/Meta topics, Data Marts which are suitable for the source system account format in Hyperion Planning & Budget, Hyperion Essbase and Financial Reporting Studio respectively.
• Developed a couple of new Applications from scratch as per business requirement.
• Workspace was used as a centralized system to register the application, creating the Web data forms/data grids, Workflow, Task lists, launching Business rules and Accessing Reports
• Metadata development such as building Meta topics for Account, Scenario, Entity and other Dimensions.
• Used Oracle Data Integrator (ODI)to load data values, accounts, entities, and custom dimensions from flat file into Cube.
• Created Batch files, automation scripts for data back-up, Importing, Exporting data etc using Maxl.
• Designing the Hyperion Model with queries joined using the Data warehouse base tables.
• Designed/Modified Outlines, Business Rules, Calc scripts, MDX scripts, Rules files, MAXL Scripts as per demand.
• Shared service was used to maintain the user provisions and level of access (Interactive user, Planner, Viewer, offline user) and creating the projects.
• Making a user friendly environment for the end-users using the Dashboard (in a click button way).
• Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Data forms and Data grids were sent every day to end users for their glance at the financial data.
• Used Essbase administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.
• Design reports using Financial Reporting Studio, Smart view, Hyperion Web Analyzer based on the user requirements.
• Extensively worked on Database optimization and performance tuning of Essbase cubes for fast retrieval and calculation performance.
• Designed and developed numerous reports based on end user’s needs.
• Trained End-Users on process control, Reporting methods and using Hyperion performance suite.
• Involved in Hyperion Installation from scratch from Shared services to installing the modules like Planning, HFM and cleared the Installation issues which occurred in the process.
• Participated in the team designing and developing Financial Management Application (HFM) cube.
• Used Financial Data Quality Management (FDM) application as required.
• Involved in Application migration, Database objects from Dev environment to prod environment using Hyperion Administrative services console.
• Migratedreports from Dev to UAT and then to prod. Responsible for testing the Reports, production datavalidation and all other related aspects through all phases of the SDLC.
• Involved in Trouble shooting the Production issues in support to the EssbaseApplications, Interactive Reports and all Reporting objects (Production Support).
• Involved in troubleshooting, Data validation, Performance tuning and Performance monitoring.
• Used so many tools in supporting this project such as ODI, Outline extractor, HAL, Financial Reporting, Interactive Reporting, Web Analyzer, Smart view, Essbase Excel Add-in, Toad.

Environment: Hyperion Planning v.11.1/v.9.3.1/3, Shared services, Workspace,HyperionEssbase v.9.3.1/3, Essbase Integration Services(EIS), Essbase Studio, HAL, Hyperion Financial Reporting Studio, Hyperion Interactive Reporting Studio, Hyperion Web Analyzer, Smart view, Essbase Spread sheet add-in, Hyperion Financial Management(HFM), Oracle 10g, Toad v.9, MS SQL Server, Windows server.

Confidential, Ohio

Hyperion Planning/Essbase Consultant

Responsibilities:

• Involved in technical requirements gathering and identifying dimensions for the Regional agencies application.
• Designed and developed BSO and ASOcubes for the commercial department.
• Developed the outlines using Dynamic dimension build method.
• Created Rule files for Data Loading in to RDASH and FOCUS cubes.
• Checking Err File for Dimension build as well as data load, if there is any error records exists correcting and reloading those records and making sure required Outline Structure build and data load.
• Implemented/Installed the EPM applications Essbase 11.1.1./9.3.1 / Planning 11.1.1./9.3.1 in Windows server.
• Developed Web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual accounting changes and other variance explanations data.
• 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.
• Worked on Hyperion Application Link (HAL), ODI to load bulk metadata in to planning application.
• Assigned data form entry, execution of business rule tasks to end users.
• Set up users and groups according to the department and maintained security to users and groups from Hyperion shared services and assigned security to web forms.
• Installed and configured Hyperion financial reporting studio, web analysis and Hyperion spread sheet add-in in the client systems.
• Developed some key reports like direct cost P&L summery, Income statement, Net Margin, Balance sheet and Headcount reports by using financial reporting studio.
• Trained business analysts on retrieving data from Essbase cubes by using Excel spreadsheet add-in and smart view.

Environment: Hyperion Essbase11.1/ 9.3.2, EAS, EIS, Hyperion Planning 11.1/9.3.2, Hyperion financial Reporting 9.3.2, Hyperion workspace 9.3.2, Hyperion web analysis, HAL, Hyperion Performance suite 8.3, MAXL, SQL Interface, Teradata, SQL server 2005, Essbase Deployment Services.

Confidential, MD

Hyperion Analyst

Responsibilities:

• Worked as an Essbase administrator and created rules and give access privileges to the users.
• Was responsible for Designing and Reporting for forecasting using the Hyperion Intelligence designer 8.3.2.
• Used Hyperion Application Link (HAL) to integrate for data sources to Hyperion Planning database.
• Worked on workforce planning and capital application.
• Was responsible to provide data integrity and verification of financial reporting using Hyperion FDM application.
• Worked on workforce planning to handle and forecasting of data for financial expenses.
• Was responsible for reporting using the ASOcubes.
• Was able to build the outline using DIM adapter for Essbase.
• Was responsible for handling the administration of BSOcubes.
• Was responsible for creating and maintaining of web data forms and journals using HFM.
• Used Hyperion planning 9.3.1 to create new web forms to reduce the work load of the user thereby focusing on a Planning, Budgeting and Forecasting.
• Responsible for system life cycle documentation (SDLC) for the changes made to the system.
• Was responsible for building financial reports for co-operate using Hyperion Financial Report.
• Created new complex calc- scripts for data calculations for reporting purposes and also re-scripted existing calc scripts for more effective calculations.
• Responsible for Data Optimization and performance tuning for Essbase.
• Was responsible for transfer of data from General Ledger (GL) and ERP systems using DRM (Data Relational Management).
• Was responsible for developing dimension build rules, data loading and also maintain calc scripts via Esscmd and Maxl scripts.
• Was responsible for maintaining and administering security permissions for users and groups.
• Was responsible for providing schemes for executing the targets/deadlines by gather requirements and conducting meetings with the business units.
• Created Dashboards for reporting using the Web Analysis.
• Was responsible for leading the team to maintain and development of Essbase cubes.
• Created reports using Web Analysis for financial data.
• Enhanced and developed budgeting, reporting templates and ad-hoc reporting using the smart view for office.
• Was responsible for providing support for the project team for development until the production.
• Documentation of all the issues which could occur for the users and their respective solutions for reference was been created.

Environment: Hyperion Essbase 9.3.1,DB -2, Hyperion Reports V 9.3, Hyperion Analyzer, Hyperion Integration Services, SQL, Microsoft Access, Windows Scheduled tasks, MAXL, ESSCMD, Excel Add-In, Essbase Utilities, UNIX, Windows.

Confidential, PA

Hyperion Essbase Developer

Responsibilities:

• Coordinated with business analysts / clients to understand and develop an optimized Essbase cube.
• Gathered requirements and developed a project plan.
• Prepared an optimized data source.
• Developed aggregate storage cubes (ASO) using Essbase 7.1.
• Developed a transparent partition with ASO / BSO cubes to leverage advantages of both technologies.
• Developed rule files for loading data and for dimension build.
• Implemented robust data-access security and user management.
• Automating of cube refresh through MaxLand UNIX Scripts.
• Optimized data loads and calculation scripts and maintained existing Essbase cubes.
• Optimized the applications to reduce runtime.
• Retrieved reports using Excel Add-in and generated batch reports using Hyperion reports.
• Maintained the OLAP application and took regular backups.
• Provided technical guidance and support to end-users by developing appropriate documentation.

Environment: Hyperion Essbase 7.1.5, Hyperion Reports 7.0, Hyperion SQR, Hyperion Planning, PL/SQL, SQL Server, Excel Add-in, Windows NT 4.0, Oracle 8i

Confidential

Software Developer

Responsibilities:

• Involved in retrieving data using ADO.NET with C#, ASP.NET and presenting it to presentation layer.
• Used Data Grid, Data List, Data Repeater, Datasets and Data Adapters to display data from the Database.
• Created tables and generated SQL scripts, Export and port of data.
• Developed SQL Queries and Stored Procedures for accessing data from the SQL Server database.
• Involved in Database design.
• Developed windows service to retrieve data from a table.
• Parsed and used the data (XML) returned by web services to Auto populate fields on the forms.

Environment: ASP.NET (C#), Web Services (C#), SOAP, XML, VSS, JavaScript, DHTML, HTML, IIS, Windows NT/2000, Oracle server, and SQL server.