TANUJA M

617-***-****

abgtah@r.postjobfree.com

____________________________________________________________________________

__

SUMMARY:

. Over 7+ Years of experience in IT with Data Warehousing, ETL & OLAP

focusing on Hyperion Suite of Technology. Adept in preparing Hyperion

reports to measure financial performance, analyze profitability, and

facilitate effective business decision making.

. Over 5 years of functional experience in design, analysis, development

and implementation of various applications in Client/Server environment

using Oracle Essbase 11.x, Hyperion System 9 BI+, Hyperion Reports,

Hyperion Web Analysis, Hyperion Analyzer, Essbase Spreadsheet Add-in,

Essbase Query Designer on Windows 2000/NT4.0 and Unix environments.

. Experienced in all stages of Software Development Life Cycle (SDLC) with

comprehensive knowledge of business and requirements analysis, business

Process modeling, Project planning and creation of user cases.

. Designed and developed numerous Essbase applications with excellent

balance of dense and sparse dimensions, developing various OLAP Models &

Meta-Outline.

. Skilled in Architecture design of Essbase Cubes using Block/Aggregate

storage(ASO/BSO) & Partitioning.

. Involved in writing custom Essbase calculations scripts, automated the

Essbase ASO/BSO Cubes using MaxL, Mdx, Esscmds and Batch Scripts.

. Skilled in Automation, Optimization and Performance Tuning of Essbase

application data/metadata processing, upgrading, testing and migrating of

cubes in different environment

. Expertise in developing complex web reports for business and end-users.

. Versatile team player with excellent analytical, presentation and

interpersonal skills with an aptitude to learn new technologies.

. Worked extensively on developing reports & templates using Hyperion

Reports, Financial Reporting and Smartview.

. Developed, modified and customized reports using Hyperion Analyzer and

Web Analysis.

SOFTWARE SKILLS

OLAP Oracle Hyperion 11.x, Hyperion Essbase System 9

BI+

Reporting Tools Hyperion Web Analysis, Hyperion Reports,

Hyperion spreadsheet Add In Micro Strategy Web.

Languages SQL, PL/SQL, Pascal, C/C++.

Databases Essbase, Oracle 10i, MS SQL Server

2000/7.0/6.5, MS Access 7.0/2.0.

Software tools SQL *Plus, TOAD.

Operating System Windows 2000/NT 4.0/98/95, UNIX (Solaris, HP).

Microsoft Office Products PowerPoint,Excel,Word,Access.

PROFESSIONAL EXPERIENCE

Michelin Tire Corporation,

Greenville, SC

(Feb 11-Till Date)

Hyperion Essbase Developer

Responsibilities:

. Worked on Local Budgeting Project and developed reports using WebAnalysis

and Excel.

. Worked with Business Analysts and gathered the requirements.

. Designed and developed BSO cubes according to the business needs.

. Created various reports from database using Web Analysis for management

for their monthly and quarterly reviews.

. Developed Essbase outlines, Outline member formulas, load rules,

dimensions build rules etc.

. Automated the cubes using MaxL statements and running it through unix

shell scripts.

. Involved in all aspects like Development and Maintenance.

. Involved in designing, developing, Upgrading and testing applications

cubes and reports.

. Developed Rule Files in BSO cube.

. Worked with Offshore team and tested the functionality of drillthru

reports in WebAnalysis.

. Coordinated with different teams who are involved in this LBU project.

. Performed the performance testing of the drillthru reports and the

applications.

. Retrieved the reports in excel add in and performed changes.

. Made changes in the reports according to the user requirement.

. Loaded the data from tables to essbase cubes using ODI.

. Provided detail documentation of the application and performed stress

testing for the reports.

. Implemented mathematical functions for computing derived data and worked

on optimization of data loads and calc-scripts.

. Written Sql queries to load the data into essbase cubes by using rule

files.

. Involved in creating new members in outlines and optimized them by

grouping and positioning.

. Modified and developed numerous report scripts.

. Modified and created various scripts for data loads and cube

maintainance.

. Provided access to users and assigned them to groups with shared

services.

Environment: Hyperion Essbase 11.1.2, 9.3.3, Essbase Spreadsheet Add-in,

Sql Server 2005,Essbase Administration Services, Unix, Excel Add in,

Hyperion Reporting Studio, WebAnalysis.

Electric Insurance, MA

(Nov 09-Jan 11)

Hyperion Essbase Consultant

Responsibilities:

. Designed and developed reports for web based Planning Budgeting and

Forecasting purposes facilitating Gross to Net applications.

. Involved in interacting with users to gather requirements, installations,

Updates and understand business needs and ensure applications met the

required changes.

. Developed and optimized outlines by grouping and positioning, developed

rules files for dimension building and data loads.

. Responsible for Maintenance, Optimization and performance tuning of

existing cubes

. Developed complex financial reports like forecasted P&L, balance sheet

etc.

. Created ASO cubes and updated the database and written Esscmd

commands.

. Involved in testing tasks and validating reporting data by retrieving

through Excel

Add-in Smartview.

. Created users and groups and given access to them for the database.

. Created member formulas for the dimension members.

. Aggregated the reports Excel and perfomed calculation based on the yearly

reports based on product costs changing the cost values and presenting

the client latest reports.

. Written Sql Queries to load the data and created rule files to load data

into cubes.

. Created Planning Web Forms, templates and loaded the data.

. Created reporting templates, and improved financial reports on Hyperion

Financial Reporting.

. Automation of Quarterly, Monthly and Annual reports.

. Updated the database monthly for changes that took place.

Environment: Hyperion Essbase 9.3.3, Hyperion Planning, Hyperion Financial

Reporting, Smartview, Hyperion Web Analysis, Essbase Spreadsheet Add-in,

Sql Server 2005, EAS, Unix, Microsoft Excel.

Allstate Insurance, Northbrook, IL

(Oct 08 - Oct 09)

Essbase Administrator

Responsibilities:

. Developed BSO cubes, and customer analysis and also automated data loads.

. Involved extensively in modifying and optimizing outlines. Designed,

developed and implemented the expense planning and reporting system for

the financial department in Allstate.

. Depending upon the market rates allocating the costs and performing the

MaxL scripts on those.

. Optimized proper database calculations and loads by selecting appropriate

dense and sparse setting of members and storage calculations.

. Responsible for performance tuning, backup and recovery of cubes.

. Responsible for various troubleshooting procedures to recover data.

. Updated the batch scripting files every time.

. Installed the software and configured and also provided support for the

problems faced by the users.

. Responsible for giving permissions to users access based on their

specific needs and assigned them to specific groups. Also, created

filters to grant access to users based on access levels.

. Assigned owners to models and scenarios.

. Written queries and updated the changes.

. Performed the starting and stopping of application.

. Restarted the application in case of server down issues.

. Created groups in Shared service and assigned the users to those groups.

. Installed Hyperion Essbase, Hyperion Reports and Hyperion Analyzer.

. Worked closely with production team for the end user support in resolves

emergency issues.

Environment: Hyperion Essbase 9.3.1, Sql Server 2005, Data warehouse,

EIS, Windows 2000, Hyperion Reports 7.0/6.5 and Windows XP, Shared

services.

Equity Residential Properties Trust, Chicago, IL

(Aug 07 - Sep 08)

Essbase Developer

Responsibilities:

. Interacted with business analysts in gathering requirements, drafting an

outline and thus developing a project plan for Database development and

Reporting.

. Involved in performing DBA activities such as performance tuning of

calculation scripts, along with taking periodical ESSBASE backups.

. Developed ASO cube for financial data related to the cost of processing

mortgages and real estate investments.

. Automated Essbase operations through Esscmd scripts in batch programming

to run monthly balance sheets and ledgers.

. Provided seamless integration of historical, projected and derived data.

. Modified and replaced existing financial and marketing reports.

. Involved in data loading using Essbase Integration Services (EIS).

. Used ESSCMD scripting language for batch processing.

. Used EIS to interface with the company's existing data warehouse by

implementing a star schema model.

. Retrieved data using excel add-in sheets for analysis of data.

. Generated reports for annual budget, quarterly forecasts, and worked with

ad-hoc reporting and management reporting by interacting with business

development managers.

. Used Hyperion Reports & Analyzer to collect, consolidate and report

financial data globally.

Environment: Hyperion Essbase 7.x,6.5.1, Hyperion Analyzer 6.5, and

Hyperion Reports 7.0, Essbase Integration Services 6.5, Essbase Spreadsheet

add-in, Sqlserver2000, Windows NT/2000.

Client: NGM Health Care, Keene, NH

(Jan'06-Jun'07)

Hyperion Essbase Developer

Responsibilities:

. Developed BSO cubes and also automated data loads.

. Assured optimal match between cube design and report specifications.

. Optimized proper database calculations and loads by selecting appropriate

dense and sparse setting of members and storage calculations.

. Gather the requirements from the business analysts and analyze the

requirements and perfom the yearly reports based on costs.

. Responsible for performance tuning, backup and recovery of cubes.

. Implemented star schema and used EIS to interface with the company's

existing Oracle data warehouse

. Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase

Integration Services.

. Loaded data using Essbase Integration Services (EIS).

. Responsible for granting users access based on their specific needs and

assigned them to specific groups. Also, set filters to grant disparate

access to users based on access levels.

Environment: Hyperion Essbase 6.5, Essbase Integration Services 6.5 SQL,

Data warehouse, Windows 2000 and UNIX.

Microteck, Delhi, India

Oracle Developer/Essbase Developer

(Oct'04-Nov'05)

Responsibilities:

. Designed and developed Graphical User Interface using Forms.

. Developed the PL/SQL stored procedures for implementing the business

logic.

. Developed the on-line context-sensitive user help.

. Development of reports (stores ledger, invoice preparation) using Reports

2.5

. Developed test plans for invoice, order entries, billing, shipping, and

Stock maintenance.

. Configured Oracle Clients on Win NT Workstations.

. Constructed Oracle Database Triggers and Indexes.

. Written MDX scripts in the console and created reports.

. Responsible for Code Reviews and PL/SQL Code Tuning and designing ASO

cubes.

. User Management Duties involved: Create, Modify and Delete user accounts.

Environment: Developer 2000, FORMS 4.5, Reports 2.5, Oracle7.3, PL/SQL, SQL

and Windows NT

Tata InfoTech Ltd. Delhi, India

Project & Systems Engineer

(Jan'03-Aug'04)

Responsibilities:

. Analyzed, implemented and managed all information technology needs for a

Regional and four branch offices.

. Network Administrator at company's Regional office. Rendered hardware,

software and networking support to Branch Offices.

. Based on the cost allocation created while using MDX commands and getting

the latest data.

. Negotiated all information systems purchases as well as development

contracts. Authored multiple Requests for Proposals (RFP), reviewed bids,

made recommendations or acted as a decision-maker.

. Utilized Exchange/Outlook environment as an intranet to enhance staff

communication as a knowledge management solution.

. Maintained VSAT communication server/link and supervised 24/7 Support to

keep organizational communication up and running with minimal possible

downtime.

Environment : Developer 2000, SqlServer 2000.

Contact this candidate