SUMMARY:

• Over 7+ years of total IT experience of which around seven plus years of experience in design, analysis, development and implementation of various OLAP applications using Oracle/Hyperion Essbase, Oracle Financial Reporting, Essbase Integration Services (EIS),Planning, Essbase Studio, Excel Add - in, Smart view, MaxL, ESSCMD, MDX and several relational databases under Windows and UNIX environment.
• Worked with all facets of Hyperion Essbase providing customers enormous success in developing effective business intelligence solutions to support overall financial and individual business unit operation.
• Migrated OLAP solution from Hyperion Enterprise to Hyperion Essbase to provide Analytic solution from new OracleGL data source.
• Designed and developed Essbase cubes using block/aggregate storage and partitioning.
• Designed and developed Essbase cubes using rules files and different data sources with generation/level/parent child formats.
• Designed and developed OLAP Meta models and Meta outlines in Essbase Integrations Services (EIS) and Essbase Studio to build Essbase outlines.
• Experience in building Multi-Dimensional Databases (MDDBs) specifically Hyperion Essbase and defining hierarchy, dimension and formulae in Hyperion Essbase.
• Strong understanding in configuration of dense and sparse dimensions allocation, performed dynamic calculations, intelligent calculation and security.
• Expertise in multidimensional database tuning, backup and recovery on different servers and operating systems.
• Designed and developed complex automation process for nightly data mart staging and Essbase cubes build process.
• Expertise in developing MDX scripts, Calc Scripts, Data Load Rules and Report Scripts.
• Focused, dynamic professional with expertise in business analysis and building financial budgeting and forecasting, profit margin and variance calculation.
• Experience in Hyperion System9 modules (Planning, Capital Expense Planning, Workforce Planning, Interactive Reporting, Financial Reports, and Dashboards)
• Expertise in buildingFinancial Budgeting and ForecastingOLAP applications with ESSBASE and Planning.
• Designed and developed various reports with Hyperion Financial Reports per business need.
• Experienced in all stages of Software Development Life Cycle (SDLC) with comprehensive knowledge of business and requirements analysis.
• Experienced on the installation, upgrades, configuration of Hyperion products such as Essbase, Planning and Essbase Integration Services, on both Windows and UNIX environments.
• Excellent relational database experience (Oracle). Proficient in SQL, PL/SQL scripting.
• A good team player with a strong commitment to client success and leadership qualities valued both by coworkers and clients.
• Ability to meet deadlines and handle multiple tasks in a pressured environment, proficient in report writing, decisive with strong leadership qualities, flexible in work schedules.

TECHNICAL SKILLS:

OLAP Development Tools: Oracle Essbase 11.x/9.x/7.x, Oracle EPM suite 11x/9x, Oracle Essbase Administrative services 11.x/9.x/7.x, Oracle Essbase Integration services, Oracle Essbase Studio, Oracle Financial reporting 9.3/Hyperion Reports 7.x, Web Analysis, Hyperion Planning 11.1.1/3.x, Hyperion Shared Services, Hyperion Business Rules, Oracle Data Integrator (ODI),FDM

Databases: Essbase, Oracle 11g/10g/9x, SQL Server 2000, and MS-Access 2000/97

Microsoft Tools: Excel, Word, PowerPoint, Visio, Project

Internet Tools: ASP, JavaScript, HTML, DHTML and VB Script

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

Scripting languages: ESSCMD, MaxL, UNIX Shell, MDX

Operating System: Windows Server 2003/Windows 9x/NT/XP, UNIX, MS-DOS

Methodology: Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Essbase/Planning Consultant

Responsibilities:

• Involved in design and development of the new cubes as per the business requirements.
• Developed the rule file and also the SQL script for pulling and modification in the rule file as per the business requirements.
• Configured adapters in FDM to feed HFM and Planning applications on user requests
• Developed locations, import formats, logic accounts in FDM.
• Created configuration files for FDM feeds to Essbase.
• Involved in automation of the daily loads by creating the MAXL SCRIPTS and scheduling them using the windows scheduler.
• Was also involved in the daily production issues and the requests from the users.
• Involved in creating the complex Calc script for the Corp ops allocations, Variance, Cash flow, P&L Reports, Forecast scripts, etc.
• Was involved in developing the work force applications which captures the labor expenses and the head count and the number of billed hours and break hours for the variance analysis and for the daily analysis.
• Developed the various Calc scripts and the Business rules for the planning applications for the variance
• Involved in developing the report scripts for the pulling the actuals, flash and forecasted data.
• Educating the user on the smart view and also about the reporting options in the smart view.
• Involved in optimization of the calc scripts and also modifying them according to the user requirements.
• Worked on restructuring the database outlines to get the best performance of Essbase Server.
• Developed the batch scripts and also the MAXL scripts for the daily loads to automate the process.
• Was involved on developing the various web forms and business rules as per the user requirements.
• Involved in developing the security at the user, group and cost center level using the Hyperion shared services and also using the ESSBASE.
• Implemented the column level security for the user so that they can enter the values using the web forms.
• Implemented the cost center level and dimension level security for the user to lock and send the values to the ESSBASE BSO applications.
• Was involved in developing the scripts for extracting the flat files as per the user requirements.
• Was also involved in the adding developing the queries for the checking the addition of the new clients and the cost center into the essbase and planning cubes.
• Involved in various production issues like the calculation and data load issue and optimizing them.
• Developed the transparent partition from BSO cube to the ASO for the data transfer.
• Worked on Excel Add-in Tools to generate various reports to analyze the business.
• Was closely working with the SAP team, also the other finance and the data ware house team in order to get the data in a consolidated and aggregated manner for the ESSBASE feeds.
• Involved in solving the print server issue and also configuring the ghost script in order to print the web forms or any other reports through planning and HFR.
• Was involved in the daily metadata updates and how the data changes or addition of new cost centers in the ESSBASE.
• Created a detailed documentation on the production and the developing issues and how they are fixed.

Environment: Hyperion Planning and ESSBASE 11.1.1.3 and 9.3.1, ESSBASE studio, Oracle 10.2.0, Web Analysis, FR reporting, Smart view, Windows 2003.

Confidential, Charlotte, NC

Oracle Essbase Developer

Responsibilities:

• Gathering business and functional requirements details during business meetings and translated them into program specification documents.
• Installation and Configuration of the Development server consisting of Hyperion System 11 Essbase, Hyperion Planning, Hyperion Shared Services, Oracle Data Integrator(ODI), Financial Reports, Web Analysis and Workspace.
• Designed and developed new Essbase cubes for corporate reporting framework using both Aggregate storage (ASO) and Block Storage (BSO) cube as per needs.
• Developed and customized Data Forms in Hyperion planning for users to input forecast, working data and accounting changes and other variance data.
• Developed load rules for loading data files and for dimension build and implemented data-access security and user management.
• Developed Rule files and Report Scripts for data loads, dimension builds and data extracts.
• Wrote calculation scripts and business rules to perform allocations based on different drivers.
• Optimization of the cube by analyzing and modifying various aspects such as dense/sparse configuration, modifying member storage properties etc.
• Developed reports using Hyperion Financial Reports, Web Analysis, and modified existing reports to incorporate global operations.
• Database and security refreshes in Hyperion Planning
• Expertise in Essbase security features and ability to create user and group profiles for assigning proper privileges using both Native security and Shared services modes.
• Created and maintained the user provisioning by configuring user active directories to Shared services and creating groups, assigning roles and then adding users to the groups.
• Developed financial reports involving Budget Allocations, Retained Earnings, forecasting of profit and loss and the reported implied changes in balance sheets as well cash flow statements.
• Planning and execution of integration test, system test, and user acceptance test activities, including developing and documenting test plans. Involved in documentation on all Hyperion Planning processes for all business groups and technical documentation on business rules and calc scripts.

Environment: Oracle Essbase 11, Hyperion Planning, Hyperion Smart view Add in, Oracle Hyperion Financial Reporting, Hyperion Workspace, Windows 2003 Server, SQL Server 2008,Toad 9.X.

Essbase Developer

Responsibilities:

• Developed the Planning applications/cubes and Essbase Applications/Cubes in 11.1.2 version.
• Performed budgeting and forecasting at the country, entity, business unit, multiple currency and department level with the ability to generate reports at these levels.
• Users could easily input budget and forecast information using the planning Web Forms.
• Created and managed flexible workflows as it pertains to the budgeting and planning process
• Assigned security for Hyperion Planning application using Hyperion Shared Services.
• Gained strong understanding of the Hyperion System 9 relational repositories which support front end applications.
• Developed reports to enable the users to analyze the data at a level of detail incorporated into the Hyperion planning application using Financial Reports and Web Analysis.
• Wrote MAXL scripts to automate the calculation scripts.
• Participated in performance optimization by tuning the caches.
• Performed installation and configuration of the Development server consisting of Hyperion System 9, ESSBASE, Hyperion Planning, Hyperion Shared Services, Hyperion Application Link, Financial Reports, Web Analysis and Workspace.
• Participated in migration of the Planning Application from Development to Production.
• Migrated Financial Reports and Web Analysis Reports from Production to Development.
• Developed Business Rules to copy data from one version to another using Run-time prompts.
• Ensured ASO & BSO cubes are synchronized by using Outline Extractor
• Automatic consolidation of data was done using Business Rules.
• Developed calculation scripts and member formulas using XREF.
• Wrote MaxL scripts to automate data load into ESSBASE database using Rules files.
• Participated in loading metadata into planning by using Oracle Data Integrator (ODI).
• Performed ESSBASE DBAActivities (Performance tuning, optimization, Esscmd, MaxL API, Backup, Outline, Load rules).

Environment: Hyperion Planning 11.x/9.x, Essbase v11.x/9.3.1, Excel Add-in, Smart view, HFR, HAL, ODI, MAXL, Calc script, PL/SQL, SQL*Loader, Toad.

Confidential, Canton, OH

Hyperion Developer

Responsibilities:

• Involved in developing design specifications of ESSBASE cube with Customers.
• Designed and developed new Essbase cubes for corporate reporting framework using both Aggregate storage (ASO) and Block Storage (BSO) cube as per needs.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
• Developed OLAP Models and Meta outlines using ESSBASE Integration Services from star schema in relational databases.
• Created out of box dimension for workforce planning.
• Designed and developed several ad-hoc and financial reports using Hyperion Analyzer and Hyperion Interactive Reports.
• Created Complex and Dashboard Reports using Interactive Reporting.
• Developed and created Web forms for users to input the data into ESSBASE cube through Hyperion Planning.
• Worked extensively on Budget process and Budget Administrative tasks
• Developed Calc scripts to calculate values like Hourly Wages, Depreciation, Benefits and Revenue.
• Involved in Migration of Hyperion Reports and Analyzer Report groups from one environment to another environment.
• Used ESSBASE Integration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of ESSBASE Servers.
• Involved in production support and maintenance of existing cubes.
• Involved in database and security refreshes in Hyperion Planning.

Environment: Hyperion System 7X,9X, Hyperion System 9 BI+, Hyperion ESSBASE 9.0.1, Hyperion Planning 9, Hyperion Smartview Add in, Hyperion Application Link, Hyperion Reports, Workspace, Windows 2003 Server, SQL Server 2000

Confidential, Cincinnati, OH

Essbase/OLAP Developer

Responsibilities:

• Interacted with users to gather requirements, understand business needs and ensured applications met the required changes.
• Designed and developed new Essbase cubes for corporate reporting framework using Aggregate storage (ASO) and Block Storage (BSO) cube.
• Automated periodic data loads and calc scripts using MaxL and Batch Scripts.
• Developed load rules for loading data files and for dimension build and Implemented robust data-access security and user management
• Developed complex financial reports involving Budget Allocations, Retained Earnings, global forecasting of profit and loss and the reported implied changes in balance sheets as well cash flow statements.
• Developed reports using Hyperion Reports, Hyperion Analyzer and modified existing reports to incorporate global operations.
• Involved in front end design using Hyperion Analyzer and Excel templates using VBA.
• Developed reconciliation framework for validated reporting data.
• Involved in high performance tuning and optimization of cubes - sparse/dense configuration, block density and compression, outline structure strategies, batch update streamlining, load optimization (load rules and transformation), and calc script optimization.
• Involved in system installation, configuration and software upgrades from Essbase version 7.X to system 9
• Used a myriad of Hyperion tools including Hyperion Essbase, Hyperion Reports, Hyperion Analyzer, and Hyperion Planning in order to fulfill maintenance requirements.

Environment: Hyperion ESSBASE 7.1.2,Hyperion Planning 3.5, ESSBASE Integration Services 7.x, Microsoft Excel 2000, MS SQL Server 7.0, Windows NT/2000, UNIX, Oracle 10g, PL/SQL, SQL*Loader.

Confidential

OLAP Developer

Responsibilities:

• Involved in data acquisition from business users and project planning.
• Involved in Requirement Analysis, Data Warehouse design, loading of data in warehouse under ETL phase using Informatica.
• Data delivery and Information Analysis.
• Break down the information system into functional areas.
• Creating and Maintaining Universes.
• Querying and planning scope of analysis.
• Analyzing and presenting data in Drill, slice and Dice mode.
• Developed and created classes with Dimension, Detail & Measure Objects, user-defined objects.
• Resolved loops by using Aliases and Context.
• Specified Joins and cardinalities checking.
• Analyzing and presenting data of product sales.
• Creating reports of all the four regions using Business Objects to analyze data of distributor and connect centers movements.
• Escalated technical and management issues to Project Leader at right time.
• Training Users on the various issues of reports.
• Reports into the market variations, comparisons with its earlier movements and move with different schemes so as to make it unique in the market by analyzing and report the activities of the sales and marketing.
• Reports about accounts receivable invoices of sales of various magic currencies, Airtel prepaid and postpaid cards are generated after performing calculations.

Environment: Informatics Power Center5.1, Business Objects, Oracle8i, Erwin4, WinNT.