SUMMARY

• Over 7+ years of work experience in design, analysis, development and implementation of BI solutions using Hyperion Essbase 11.x/9.x/7.x/6.x, Hyperion Planning 11.x/9.x, Analytic Administration Services (AAS), Analytic Integration Services (AIS), Financial Reporting, Web Analysis, Interactive Reporting, ESSCMD, MaxL, Smart View, Essbase Smart View and Essbase Query Designer on Windows.
• Experience in installing, maintaining and optimizing Hyperion System 9 components
• Experience in all stages of Software Development Life Cycle including Requirements gathering, Design, Development, Testing, Rollout, Implementation, and Training
• Designed and developed numerous cubes and Multi - dimensional databases both ASO and BSO in Essbase with excellent balance of dense and sparse dimensions allocation strategy, developed various OLAP Models & Meta-Outline for loading dimensions and data into Essbase cubes
• Managing / administration: security, permissions to users and groups, controlling access to database cells through creating, copying and assigning filters
• Involved in Dimension build rules, Data load rules, Calculation Scripts, Hyperion business rules, Web forms, EssCmd, MaxL and Batch scripts
• Extensively involved in automation, backups, Performance tuning and Optimization of cubes and calc scripts, partitioning database, upgrading, testing and migration of cubes in different environment.
• Proficient in administering and using Hyperion Shared Services (HSS), Analytic Provider Services (APS), Work Space & Financial Reporting Studio
• Knowledgeable in financial concepts, chart of accounts/balance sheet/P&L/cash flow
• Experience in preparing consolidation of financial statements on a monthly basis and cost variance, analysis report for all major cost variances between actual, budget and forecast.
• Developing support, enhance budgeting and reporting templates and ad-hoc reports using Excel Add-in, Smart view for office and Essbase VBA functions
• Proficient in Star and Snowflake schema modeling technique used to design data warehouse & data mart
• Excellent troubleshooting and debugging skills
• Support user training, software documentation and technical report writing.
• Excellent interpersonal, presentation and communication skills with the ability to work in a team and a stand-alone environment

TECHNICAL SKILLS

OLAP Tools: Hyperion Essbase 11.x/9.x, EssbaseAnalytic Services (EAS), Analytic Administration Services (AAS), Analytic Provider Services (APS), Analytic Integration Services (AIS /EIS), WorkspaceReporting Tools: Financial Reporting/Reports,Web Analysis / Hyperion Analyzer, Smart View for Office, MS Excel Add-In

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

Languages: ESSCMD, MaxL, MDX, SQL, PL/SQL

Web Design: HTML, DHTML, Flash

Operating Systems: Windows NT/2000 /XP

Other Tools: MS Office Suite 2007/2003/2000

PROFESSIONAL EXPERIENCE

Confidential, Irving, Texas

Hyperion Planning/Essbase Developer

Responsibilities:

• Involved in design and development of two cubes, one for budgeting and planning and the other for customer analysis.
• Involved in dynamic dimension building and modifying outlines.
• Developed batch scripts for automating the dynamic dim builds and data loads
• Interacted with the business users and administrators to gather requirements to develop required Web forms.
• Developed Web forms for several Business process - Contingency, Line of Business transfer and Reforecasting processes.
• Involved in designing and developing web forms using Hyperion Planning tool for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
• Developed calc scripts, business rules using Hyperion Business rules tool.
• Hyperion Planning and Essbase global implementations, including Workforce Planning in version 9.3.1 and 11.1.2.0
• Created the Planning application for Multi currencies.
• Expertise in buildingFinancial Budgeting and ForecastingOLAP applications with ESSBASE and Planning.
• Installation and Configuration of the Development server consisting of Hyperion ESSBASE, Hyperion Planning, Hyperion Shared Services, Hyperion Application Link, Hyperion Reports,Web Analysis and Workspace.
• Develop Business Rules to copy data from one version to another using Run-time prompts.
• Migration of the Planning Application from Development to Production.
• Involved in Performance Tuning to minimize data load time and calculation time.
• Designed and implemented an automated dimension build process for the Essbase Reporting Cube.
• Designed and built a partitioned database using Replicated and Linked Partitioning for reporting needs as per business requirements.
• Created Essbase Block Storage (BSO) and Aggregate Storage (ASO) cubes for reporting needs with Complex, aggregation process.
• Developed web forms using Hyperion Planning web client.
• Developed the Business Rules and Calc Scripts using Calculation manager, for their Allocations and Data copy between the versions, Scenario, etc.
• Created Business Rules that need to run on fly with Input template and also that run on timely manner (Daily, Weekly, Monthly and Yearly).
• Designed Task Lists for the Budgeting process by including web forms, Business Rules for the end users.
• Involved in the performance tuning and optimization of data load calc scripts
• Extensively used MaxL scripts to run calculation scripts.
• Involved in MaxL script changes based on business requirements.
• Used Shared Services to create users, groups and assigning roles according to the requirements.
• Provided technical assistance and support to end users and was involved in developing documentation
• Worked with designed calculation script for enhancements and performance.

Environment: Oracle Hyperion Essbase 11.1.2,0 Oracle Hyperion Planning 11.1.2.0 Excel Add-in, Hyperion Financial Reports, Smart View Office, Windows Server 2003

Confidential, TEMPE, AZ

Hyperion Planning Consultant

Responsibilities:

• Involved in developing design specifications of Essbase cube with Customers.
• Extensively involved in designing and modifying the outlines for Essbase Cubes.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dim builds.
• Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube.
• Developed OLAP Models and Meta outlines using Essbase integration services from star schema in relational databases.
• Developed batch to load data from SQL Server.
• Involved in installation of Hyperion Planning on Windows environment.
• Involved in Loading dimensions, create Business rules
• Developed and created planning forms for users to input the data into Essbase cube through Hyperion Planning.
• Involved in database and security refreshes in Hyperion Planning.
• Designed and developed several adhoc and financial reports using Hyperion Analyzer and Hyperion Reports.
• Involved in Migration of Hyperion Reports and Analyzer Report groups from one environment to another environment.
• Used Essbase Administration services for activities such as filter creation, creation of users, creation of groups, migration of cubes and maintenance of Essbase Servers.
• Maintenance of Batch Scripts, Scheduling runs through AutoSys.
• Assisted with the integration of financial reporting along with streamlining of process/method improvement for data collection.
• Optimized the applications to bring down the runtime and database size considerably.
• Involved in production support and maintenance of existing cubes.
• Worked as a team member in Hyperion EssBase & Planning Implementation.

Environment: Essbase Server v 9.3, Hyperion Planning v9.3, Analytic Administration Services v9.3, Essbase Integration Services (EIS), ESSCMD, Web Analysis, Financial Reporting Studio v 9.3, SQL Server 2000,Windows 2000/NT

Confidential, Overland Park, KS

Hyperion Developer/Administrator

Responsibilities:

• Involved in the design and development of cubes and also reviewing cube designs
• Developed outlines, ESSCMD scripts
• Created various rules files for dimension building, data loading and writing calculation scripts
• Used various types of Calculations such as Dynamic calc, Two-Pass Calculations, Intelligent calculations for Outline Calculations.
• Performed optimization for various data load rules and calc scripts
• Performed database tuning by setting appropriate index, data and calc cache
• Involved in security setup for user groups
• Created and managed restrictions to the OLAP server
• Developed reports for forecasting monthly expenditures, expense management
• Created reports based on the user requirements using Financial Reporting.
• Retrieved reports using Excel Add-in
• Provided technical support and documentation

Environment: Hyperion Essbase 9.3.1, Hyperion Analyzer 9.3.1, Hyperion Reports 9.3.1, ESSCMD, SQL Server, Excel Add-in, Windows NT Server

Confidential, Kansas

Hyperion Consultant

Responsibilities:

• Involved in the complete Software Development Life Cycle and was responsible for the design and development of two cubes business collection and strategy.
• Converted BSO to ASO using migration wizard
• Worked on currency conversion applications.
• Write, debug and enhance various calculation scripts and business rules.
• Involved in the migration of Reports and Forms from Development to QA and then to Production and tested them. Monitored the monthly and weekly data load.
• Developed and modified Report Scripts and Rules files.
• Created custom reports using Hyperion Reports.
• Prepared reports as per client requirement using Hyperion Analyzer.
• Actively participated in defining requirements, functional specifications, designing documentations and testing strategies.
• Provided troubleshooting and advice to improve the current Essbase database.
• Implemented calculation engine that includes robust mathematical functions for computing derived data.
• Involved in Performance Tuning to minimize data load time.

Environment: Hyperion Essbase 9.3.1, Hyperion Reports 9.3.1, Hyperion Analyzer 9.3.1

Confidential, VA

Jr. Hyperion Admin/developer

Responsibilities:

• Involved in installation and configuration of Hyperion system 9.0.2
• Involved in developing planning applications for community and corporate business units
• Created mapping documents from People soft
• Created user groups for managing overall security of the applications
• Involved in created Business rules
• Involved in creating HAL routines for Entity dimension
• Created web-forms and financial reports
• Created MaxL scripts fordata loading and hierarchy changes
• 24/7 on-support for the overall application
• Loaded the Monthly budget Actual from Peoplsoft upon request
• Automated the daily jobs for cube building, Export of the data for Back-up

Environment: Hyperion System 9.0.2, Essbase, Planning, Analytical Administrative Services (AAS), Web-Analysis, Hyperion Financial Reporting, Calc Scripts, Business Rules, Web-Forms, MaxL Scripts, Excel Add-in, Oracle, UNIX