Summary




9 years of total IT industry experience in online analytical applications OLAP, Business Analysis, Requirements, Development, Testing and Database Administration of Data Warehousing and Client/Server projects using industry accepted methodologies and procedures.
9 years of Hyperion Experience, Hyperion Planning and Budget, Essbase, Workforce Planning, Capex in Architecture, Administration, Analysis, design, development, enhancement, production support, upgrade, installation.
Strong experience in Hyperion Planning v11.1/v9.3.1/v4, Hyperion ESSBASE v11.1/v9.3.1/v7.1.5/v6.5.4, Workforce Planning, Hyperion Spreadsheet Services, Hyperion Web Analysis 9.3.1/Analyzer v7.2.1 Workspace, HAL, HIS, EIS, EPM, Clarity and Hyperion Financial Reports 9.3.1/Reports 7.2 on windows and Unix environment.
Extensive experience in creating reports using Financial Reports, Hyperion Intelligence Brio, Interactive reporting, Essbase Excel Add-In, Hyperion Analyzer, Hyperion Reports, Smart view.
Experience using Business Rules, Calc scripts, Load Rules, Architecture, Design, Business Logic, Performance tuning, Report development and all the areas related to whole life cycle of Essbase application implementation.
Well experienced in Planning Application implementations from end to end includes architecting, designing the metadata, building, Loading data. Worked with Business unit, Process unit, Review process, Rules.
Created and Used HAL routines to update the metadata changes in Planning.
Extensive developed numerous cubes from conceptual stage, designed Essbase MDDB applications, OLAP Models and Meta-Outlines with excellent balance of dense and sparse dimensions.
Strong Understanding of dense and sparse strategy dimension allocation, performed dynamic calculations, developed, reviewed and optimized report queries in Microsoft Excel.
Strong experience as Essbase Cube Analysis and Design, Essbase database Administration and performed up gradations, Maintenance, Database backups, Performance tuning, Optimization, Dense/Sparse settings, partitioning, etc.
Optimizing Aggregate Storage Option and Block Storage Option outline
Developed MAXL Scripts, ESSCMD, MDX formulas.
Extensive experience in automation process of NT environment using Batch Scripting and Shell Scripting in the UNIX environment.
Setting up users and groups according business department and Assigning security to users and groups using Shared Services.
Possess excellent analytical, logical, communication skills, familiar with the SDLC methodology of system development.


Employment

September, 2008 -  JUNE, 2009
Senior Hyperion Implementation Consultant

Mars Inc operates the manufacturing and selling of multiple candy products in Mars stores all over USA It has the top selling stores in Las Vegas, New York, Chicago. Main products it has are the M and M s, Gourmet Chocolate, Snickers, Milky Way.

The project is to implement a financial analysis on Profit and loss of all the stores on M and M and the Gourmet Chocolate. Involve working with Hyperion Planning and Budget 11.1 and 9.3 to keep the P and L transactions in metadata application and making an analysis report of all these stores in Hyperion Interactive Reporting BRIO. Web client activities are added through the i-server to view the reports in Intranet. Data Warehouse is the input processing source for the analysis in a multi-dimensional environment is being developed by Hyperion Essbase 11.1/9.3.1, Hyperion Planning 11.1/9.3.1.

Performed the Upgrade/Installation of Hyperion Modules from 9.3.1 to 11 version.

As a Hyperion Business Developer/Analyst responsible for interacting with Profit and Loss allocation process to build the Hyperion Metadata in Hyperion Planning, importing P and L data using HAL, EIS from General Ledger of People soft, SAP, Fusion.
Involves gather the requirements, Architecting, analyzing, design, develop and deploy interfaces used for Hyperion Intelligence, Essbase database and to generate reports using Hyperion performance suite and Excel export.

Roles and Responsibilities :
Created a metadata which is suitable for the Peoplesoft, SAP, Fusion G and L account format in Hyperion Planning and Budget.
Developed new Planning Application Metrix from scratch as per business requirement.
Metadata, like building metadata for Account, Scenario, Entity Dimensions.
Loading Meta data, Business Rules and Process units using Workspace.
Trained End-Users on process control for Budget data.
Developed and maintenance of G and L planning application for Corporate Services group using Hyperion Planning, Essbase, Hyperion Application Link HAL, Business rules.
Designing the Hyperion Model with queries joined using the Data warehouse tables.
Created the Data forms and Data grids for the data representation for the end users.
Manage Journal templates and periods. Monitoring IC transactions. Posted journal entries were made the Financial P and L adjustments Credit/Debit.
Making a user friendly environment for the end-users using the Dashboard in a click button way. And used the JAVA scripts for more enhancements.
Multi-Dimensional analytical architecture was built in Essbase for each store and the item of purchase to dig in.
Shared Service Port 28080 Users Setup-Provisioning-Security Classes.
Created users and user groups in the Planning applications and assigned security to web forms.
Design reports using Financial Reporting.
Used HAL, EIS to load data values, accounts, entities and custom dimensions from flat file into Planning Cube.
Developed Report Scripts to extract data from Essbase to a text file which is exported to the staging area.
Implemented nightly cron jobs to print DBA reports, SQL and PL*SQL scripts.

Used Essbase administration activities like filter creation, creation of users and creation of groups and maintenance of Essbase Servers.
Created Batch files using maxL for automation.
Worked on the Essbase Spreadsheet Services.
Created reports for Income Statements, Balance Sheets, Key Metrics, OTC, Operating and Administrator Expenses, Consolidation, Corporate P and L, Functional P and L, Revenue.

Environment : Hyperion Planning 11.1/9.3.1, Hyperion Workforce Planning, Capex, Hyperion Interactive Reporting, BRIO, Hyperion Essbase 9.3.1 HFM, Hyperion Reports 7.2, Hyperion Enterprise, HAL, EIS, Excel Add-In, Oracle 11i, Maxl, Essbase API, VBA, Smartview, Unix, Solaris.

February, 2007 -  August, 2008

Bank of America operates banks and other financial services principally in Ohio, Michigan, Pennsylvania, Indiana, Kentucky, NC, NY and Illinois states. Bank of America's subsidiaries provide financial services - corporate and small business banking and treasury management, personal banking, trust and investment services, item processing, mortgage servicing and insurance.

Involves working and creating the Metadata applications for Hyperion Planning. External GL Data import to Planning application is through the HAL, DIM, ODI modules.

The project is to develop a closing and consolidation system, leveraging Hyperion Planning, to replace the existing Enterprise system and supplemental data gathering and analysis processes. Closing Cube Essbase is intended to support aggregating actual and planning data. The Consolidation Cube Planning will support commentary entry, planning input, variance analysis and CF Corporate Finance submissions.

As a Business Analyst responsible for interacting with the FP and A Financial Planning and Analysis and OTC users to gather the requirements, design, develop and deploy interfaces used for Essbase and Planning databases and to generate reports using Hyperion Reports and Excel Add-In.

Roles and Responsibilities : Meta data is developed in Hyperion Planning for the actual or Budget data and loading the data through HAL, ODI, DIM.
Meta data is developed in Hyperion Planning for the planning and budget data.

Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes and other variance explanations data.
Used HAL to load data values, accounts, entities and custom dimensions from flat file into Planning Cube.
Developed Business rules and attached to the input forms to calculate data on save Option.
Created users and user groups in the Planning applications and assigned security to web forms.

Imported security profiles from Hyperion planning to Hyperion Essbase.
Developed Report Scripts to extract data from Essbase to a text file which is exported to the staging area.
Worked on the Hyperion Reports. Designed and Developed 30 reports based on the client s needs.
Worked on the Excel Add-In templates. Designed and Developed 30 reports based on the client s needs.
Implemented nightly cron jobs to print DBA reports, SQL and PL*SQL scripts.

Used Essbase administration activities like filter creation, creation of users and creation of groups and maintenance of Essbase Servers.
Created Batch files using maxL for automation.
Worked on the Essbase Spreadsheet Services.
Worked on the Essbase Integration with OBIEE 10.1.3.3.1 to bring an Essbase cube into the Oracle BI Server metadata layer and report against it using Oracle Answers and Oracle Dashboard.
Created reports for Income Statements, Balance Sheets, Key Metrics, OTC, Operating and Administrator Expenses, Consolidation, Corporate P and L, Functional P and L, Revenue.

Environment : Hyperion Planning 9.3.1/4.0, Workforce Planning, Capex, Essbase 9.3.1/7.1.3, HAL, HFM, Hyperion Interactive reporting or Intelligence or Brio, Hyperion Business Rules 4.0, Hyperion Reports 7.2, Hyperion Enterprise, HAL 7.0, Excel Add-In, Oracle 11i, Maxl, Esscmd, Essbase API, VBA, Smartview, Unix shell scripting.

April, 2006 -  February, 2007

Commercial Finance Fleet Services buy vehicles and lease them or sell them directly. It acts as dealer to sell vehicles. GE Fleet Services has presence in the US, Canada, Europe, Japan, Australia and New Zealand.

As a developer/analyst responsible for design, development and maintenance of Global Management Reporting Application. This system is used to support the process of budgeting, planning and forecasting to align strategic objectives to organizational goals.

As a developer responsible to develop and deploy interfaces used for Hyperion Financial Management applications and to generate reports using Hyperion Financial Reports and using the Data forms and Data grids. Data transfers through the HAL, FDM from the external GL accounts. Designed, developed and involved in complete life cycle of the application.

Responsibilities :
Hyperion Planning is used to build the Planning and budget application from the scratch to meet the business functional requirement and to map the data from the external sources applications.
Data forms and Data grids were been sent every day to end users for their glance at the financial data.
Journal Entries were create to make the Credit/Debit adjustments.
ICP transactions were generated for the intercompany transfer of transactions.
Developed numerous simple to complex Business Rules and attached them to the web forms.
Created users and user groups in the Planning applications and assigned security to web forms.
Load rules and lists for Hyperion Financial Management Meta data applications.
Used HAL flow diagrams for the dynamic dimension building and data loading into the Planning cube.
Worked on the Hyperion Financial Reports. Designed and Developed 80 reports based on the client s needs.
Worked on Interactive Reporting Brio for the Dash board applications

Created reports for Corporate P and L, Functional P and L, Revenue, Interest for daily, weekly, quarterly and yearly.
Developed weekly, monthly forecast, budget and quarterly year to date YTD reports.

Environment : Essbase 7.1.2 Hyperion Planning 4.0, HFM, Hyperion Business Rules 4.0, HAL, Brio, Hyperion Reports 7.0.1 HAL7.0, Essbase Spreadsheet Services 7.1.7 Excel Add-In and Oracle 9i, Unix, Solaris.

August, 2005 -  March, 2006

The application provides business intelligence analysis services to Capital 1 finance department on cost-margin performance metrics through interactive client tools. BLR, CFAR, CDRS these 3 are Financial tools which are useful for the Financial Decision Supporting System in Capital 1.

CFAR
stands for Consolidated Forecasting, Analysis and Reporting. It is an application that allows users to enter forecast data and report data in a multidimensional format that allows for easy analysis.
BLR is the official database for Business Line Reporting for Capital 1. The Reports are consolidated to Corporate Level. Multiple combinations of Actuals and Forecast are stored in separate versions.
CDRS is the official database for Driver reporting system which is used for marketing department.
The end users can drill through the information using Hyperion Reports technology and Excel over intranet/internet. Security is implemented to control the end user data access. The whole process is automated.

Roles and Responsibilities :
Hyperion Planning is used to build the Planning and budget application from the scratch to meet the business functional requirement and to map the data from the external sources applications.
Used the Financial Reports/brio for producing the drill down reports or graphs.
Optimizing Aggregate Storage Option and Block Storage Option outline
Developed MDX formulas for dimensional Metrics
Creating reports using Hyperion Reports
Creating reports using Hyperion Analyzer
Creating reports using Hyperion Essbase Spreadsheet Services
Worked on Hyperion Essbase Spreadsheet Services templates with customized VBA code
Setting up users and groups according business department and Assigning security to users and groups.
Design and Develop OLAP cubes
Data Modeling and MetaOutline building with EIS
Worked on UNIX, Shell Scripting in the Project
Solving production Issues
Automate Maxl scripting.

Environment : Hyperion Planning and Budget, Hyperion Essbase7 .x, EAS v7 .x, Hyperion Analyzer v7.1.3 MaxL, SQL Interface, Essbase API, Essbase Deployment Services, UNIX Shell Scripting and Hyperion Essbase Spreadsheet Services.

January, 2005 -  August, 2005

Project Overview
Mitchell International, Inc is the leading provider of data, software and eBusiness solutions for the automotive insurance, collision repair, medical claims and glass replacement industries. Mitchell facilitates several million electronic transactions between more than 16000 business partners. From the moment policyholders notify their insurance companies of vehicle claims, Mitchell products go into use throughout the entire claims and repair cycle. Mitchell products provide the information and tools insurers and collision repair shops rely on to give their customers the best service possible, from assessing the amount of vehicle damage, to helping collision repairers return vehicles to pre-accident condition, to making the entire claims process more efficient. Mitchell International, Inc is the North America's largest provider of collision repair information.

Roles and Responsibilities : Involved in Designing and development of Financial Management HFM Company Cubes for the each insurance company and the Body Shop Agencies.
Designed and developed the outlines for the applications based on the functional requirement documents.
Developed web reports using Hyperion Financial Reports/Analyzer/Brio for all the Insurance companies and the Body Shop Agencies.
Developed the formatted and monthly standard/Dashboard reports in Hyperion Interactive Reports/Brio.
Modified the existing reports in Hyperion Reports to meet the end user requirements.
Developed several reports like claims report by company, Estimates report, Supplement Reports, Cycle time reports and Total Loss Reports.

Optimized the reports for better retrieval by reducing the calculations, conditional formatting options, cross axis references and functions in rows and cols.
Developed charts, graphs and Standard with the Hyperion Analyzer.
Developed custom and modified standard reports which are similar to all the insurance companies and the Body Shop Agencies
Developed reports specific to the Insurance Company and the Body Shop Agencies.
Implemented Drill-Through and the traffic lighting functionality for the dashboard reports.
Designed and developed the dynamic dimension build rules files to build dimensions dynamically
Worked with SQL Interface to load the data from the oracle warehouse into the Essbase cubes using the data load rule files
Modified the existing outlines to implement the new functionality based on the user requirements.
Worked on PL/SQL as a part of the transformations and data massaging before loading the data from staging area to the warehouse worked on Database optimization and tuning of the Essbase cubes for the retrieval and calculation performance.
worked with the Essbase database settings, caches and the outline optimization for the better performance
Developed simple to complex formulas in the outline for the aggregation of the data
Developed simple to complex calculation scripts for calculating the claims and the estimates and modified the existing the calc scripts to suite with the end user needs.
Worked on basic DBA functionality like creating the users, filters and updating the cubes in the production environment.
worked with the Cube Navigator and the Dimension browser
Developed Essbase Excel-Addin reports for the testing purpose and to give the sample reports with the data to the users
Worked with the existing reports and modified them to suite the end user needs
Developed the documentation required to transfer knowledge for the users and for the administration and support.
Worked with the ESSCMD to automate the process of cubes rebuild and the data load from the oracle warehouse developed the ESSCMD scripts to take backup of the database and to recover from the failure.

Environment : Hyperion Planning 2.0, Hyperion Essbase 6.5, Hyperion Analyzer 6.5, Hyperion Reports 2.6 Essbase API, Excel- Addin, SQL Interface, Oracle8 .x, Windows 2003 Server

January, 2003 -  December, 2004
OLAP Developer

Citigroup Inc, today's pre-eminent financial services company, with some 200 million customer accounts in more than 100 countries, Other major brand names under Citigroup's trademark red umbrella include Citi Cards, CitiFinancial, CitiMortgage, CitiInsurance, Primerica, Diners Club, Citigroup Asset Management, The Citigroup Private Bank and CitiCapital.
The Project named Finance 1 includes collection of all financial data balance sheet data, general ledger data from various units into people soft INBOUND and showing them in reports OUTBOUND using people soft crystal tool and Hyperion reports tool. We built three-cubes Finance cube, management cube and Intercompany cube using People soft process and Essbase Integration services tool for OUTBOUND reporting.

Roles and Responsibilities : Designed the application for HFM and Planning based on the business input and mapping the external applications to Hyperion Applications.
Involved in building Management cube, financial cube and Intercompany cube using peoplesoft process and Essbase integration services.
Responsible to solve the performance issues in the Reports.
Designed and developed financial reports using financial cube.
Designed and Developed Management reports using management cube.
Designed nested reports Sub reports for Management group.
Support and maintenance of the Financial Hyperion reports for the Delaware accounting unit.
Support and maintenance of all the 3 cubes
Migrated reports from development to Preproduction and then to production.
Responsible for solving the reports issues related to tool with the help of Hyperion Technology support.
Enhancements to the management reports due to change in user requirements.
Developed Dashboard reports using Hyperion Analyzer and implemented the drill through and traffic lighting scenario reports

Testing of Hyperion reports and training the users to the new Hyperion reports.
Developing and Modifying the Outline, Calc scripts.
Lot more support, maintenance and development to go.

Environment : Hyperion Planning 2.0, Hyperion Essbase 6.2/6.5.1, Hyperion Analyzer 6.5, Hyperion Reports 2.5/2.6, Essbase API, Excel, Oracle8 .x, Unix, Solaris.

August, 2000 -  December, 2002

Education

Training

OLAP
Hyperion Planning , Essbase , HAL , FDM , EAS , ESS , Hyperion Web Analysis/Analyzer , Hyperion Financial Management HFM , Hyperion Financial Reports/Reports Operating Systems Unix , Windows Scripting/Language MAXL , ESSCMD , CALC scripts , MDX , Java script , VB script Databases Oracle , Access , Sql Server 2000/2005 , DB2 Server Unix , Windows , HP , Solaris , Mainframes , AS/400 Web sphere Reporting Tools Essbase Add-in , Smart view , Hyperion Analyzer , Hyperion Interactive Reporting , Hyperion Financial Reporting
Its business offering a range of services for private clients , small businesses , institutions and corporations and financial intermediaries .
Here I worked under Financial Information Management systems FIMS and skills I have used are Hyperion Essbase , Hyperion Reports , Hyperion Analyzer , Hyperion Essbase Spreadsheet Services , Oracle and UNIX shell scripting .
Roles and Responsibilities :
Created business information model and data model for data feeds from different Source files .
Optimizing database settings and configurations .
Created Applications and Databases using Essbase Application Manager .
Created Essbase Cubes based on user requirements
Created Calc Scripts for mid to complex allocations .
Setup and update security at user level and at the application level
Dynamically building outlines using rules files .
Involved in Hyperion Reports Presentation .
Developed Report Scripts for extensive reporting in Report Extractor .
Developed various mgt web Reports using Hyperion Reports .
Developed front end Interface for Reports using Hyperion Reports .
Involved in troubleshooting , Performance tuning and Performance monitoring
Involved in writing the Shell Scripts to run the batch files
Additional tasks included configuration and production support .
Involved in optimization of Essbase Server Settings for better Performance .
Involved in pager rotation program to support 24 x 7 production support
Environment : Hyperion Essbase 6.1/6.2 ., Hyperion Planning 2 , Hyperion Analyzer5.0 , Hyperion Reports 2.0 , Essbase API , Excel , Oracle7 .x , Windows NT 4.0/2000
Project Details
pg .3
pg .1