Data Sql Server

Subha Varma

*****.******@*****.***

Direct: 614-***-****

Summary

SKILLS SUMMARY

. Over 7 years of IT experience with 5+ years experience as a Hyperion

Consultant, extensive hands on technical experience in many aspects of

Data Warehouse and OLAP software systems design and implementation.

. Extensive experience in the development, design, analysis and

implementation of various applications using Hyperion Essbase

9.x/7.x/6.x, Essbase Administration Services, Essbase Integration

Services, Hyperion Analyzer, Hyperion Reports, Essbase Query Designer,

Excel Macros and Essbase Spreadsheet Add-In.

. Proficient in Data Modeling Techniques using Star Schema, Snowflake

Schema, Fact and Dimension tables, RDBMS, and Physical and Logical data

modeling for Data Warehousing and Data Mart.

. Extensive experience of Essbase integration services, Essbase

administration services, Hyperion Essbase, Hyperion analyzer, Hyperion

reports and Essbase spreadsheet Add-in. Expertise in ESSCMD, MAXL, and

dynamic dimension build methods, calculation scripts, MaxL scripts and

dimension and data load rules.

. Adept in dynamically building dimensions, attributes, and shared members

using rules files in an Essbase Outline by means of several build methods

such as generation, level, and parent-child references.

. Expertise in building an online analytical processing (OLAP) system/multi

dimensional database (MDDB) especially Hyperion Essbase and SQL server

OLAP services.

. Developed numerous cubes from conceptual stage, designed OLAP Models and

Meta-Outlines with excellent balance of dense and sparse dimensions.

. Extensive Knowledge in dense and sparse settings, performed dynamic

calculations, developed, reviewed and optimized report queries in

Microsoft Excel and loaded data from various database to cubes.

. Experienced creating, maintaining and supporting financial application

using system 9 BI+.

. Involved in writing custom Essbase Calculations Scripts, automated the

Essbase Cubes using MaxL 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.

. Created Excel macros to filter the date at the retrieval time.

. Worked on complex financial reporting systems for various clients across

the country using Hyperion Essbase to the full satisfaction of the

clients.

. Possess a broad understanding of database calculations such as

implementing formulas on dimension members, order of calculations in

terms of dense and sparse dimensions, dynamic calculations, and

developing calculation scripts.

. Created reports using Essbase Excel add-in, Hyperion reports, report

scripts and on-the fly reports using Hyperion Analyzer

. Expertise in building financial budgeting and forecasting OLAP

applications with Essbase

. Proficient in batch scripting, UNIX Shell scripting, C++ programming,

Excel VBA coding, PL/SQL scripting, software Installation, system upgrade

and server maintenance, application and data back-ups and security.

. Expertise in building financial budgeting and forecasting OLAP

applications with Essbase.

SOFTWARE SKILLS

OLAP Tools : Hyperion/Oracle Essbase System 11.1.1.3/9.3.1, Hyperion

Essbase 11.x/9.x/7.x/6.x, Hyperion Web Analysis

11.1.1.3/9.3.1, Hyperion Financial Reports

11.1.1.3/9.3.1, Essbase Administration Services

11.x/9.x/7.x, Essbase Integration Services 11x/7x,

Hyperion Performance Suite 8.3.2/Brio 6.6, AlphaBlox

8.4.1, Hyperion Analyzer 7x/5x, Hyperion Reports 2x/7x,

Excel Add-In,

RDBMS : Oracle 9i/8i/7.x, SQL Server 2000/2005/2008

Operating : Windows NT/XP/2000/2003/2008, Unix (HP, Sun OS 2.7/8,

System: AIX), DOS

Languages : SQL, VBA, VB

Web Tools : HTML, JavaScript,ASP

Scheduling : Cron, Autosys, Tivoli Workload Scheduler

Tools

Tools : SQL Plus, SQL Loader, Load Runner

EDUCATION

. BS, Jawaharlal Nehru Technical University, India

EXPERIENCE

JPMorgan Chase

Columbus, Ohio

Jun 2009-Current

Responsibilities:

. Installed and configured Oracle Essbase 11.1.1.3 Provider/Shared

Services, Essbase Server, Essbase Administration Services, Essbase

Client, Essbase Integration Services, Financial Reporting and Web

Analysis.

. Migrated numerous applications from Essbase 7x to Essbase 11x.

. Developed a new cube by integration data from two different to separate

business segments.

. Developed and maintained various budgeting and forecasting (Income

Statement, Balance Sheet and Indirect Expenses) applications using

Essbase 11.x/7.x.

. Created Essbase Source and Target cubes as per design documents.

Automated dim build, data loads, partitions creation and backup using

MaxL scripts.

. Involved in gathering requirements and developing a project plan.

. Developed outlines, dimension build rules, data load rules

. Developed Calc scripts / formulas to calculate Ranks, B/(W) %, Rates,

Quarterly Averages, etc,.

. Developed MaxL Scripts to automate dimension build and data loads

. Optimized Data Loads and Calc Scripts.

. Involved in Performance tuning and Performance monitoring.

. Wrote batch scripts and scheduled them automatically to run ESSCMDS/MaxL

to take regular backups.

. Created many users, groups and filters.

Environment: Oracle Hyperion Essbase 11.1.1.3/7.1.5, Essbase Administration

Services 11.1.1.3/7.1.5, Hyperion Web Analysis 11.1.1.3/ Hyperion Analyzer

7.2.1, MAXL, MDX, Hyperion WorkSpace 11.1.1.3, Essbase Excel Add-In

11.1.1.3, Hyperion Shared Services 11.1.1.3, Hyperion Financial Reporting

Studio 11.1.1.3/7.2.1, Windows Server 2008/2003, SQL Server 2008/2005.

Metavante Corporation

Milwaukee, Wisconsin

Hyperion Consultant

May 2007 - May2009

Headquartered in Milwaukee, Metavante Corporation provides banking and

payment technologies to financial services firms and businesses worldwide.

It provides products and services drive account processing for deposit,

loan and trust systems, image-based and conventional check processing,

electronic funds transfer, consumer healthcare payments, and electronic

presentment and payment. The purpose of this project is to develop an

efficient Planning system and the related processes to support Metavante's

forecasting and planning cycles. The new system will replace the current

Pillar process

Responsibilities:

. Plan and Analyze the Data, Defining Dimensions, Applying Analysis

Rules, Developing and Generating the Out Line, Attempting Report

Layouts, Test Consolidations, Loading the data into the Database and

Testing the Data.

. Developed calculations in Essbase (Member Formulas, Calculation

Scripts, and Business Rules).

. Modified existing outlines for addition, deletion and movement of

members both through manually and used dimension build methods.

. Modified existing load rules properties to facilitate new data.

. Worked with Essbase integration services to create OLAP model and Meta

outline for Essbase OLAP server; developed various filters as per user

requirements and drill-through reports . Designed and developed web

forms for Data Input.

. Created EAS applications, EAS security filters, modify existing and

develop new database outlines, business rules, setting up dimensions,

users, user groups and their security rights.

. Successfully reconciled data upon changes to both calc script and load

rules

. Data was loaded into Cube through lock and send process run through a

VB Macro.

. Developed HAL Routines for metadata loading. Worked on Hyperion system

9 to create various ASO and BSO applications for budgeting planning

and forecasting for higher management of decision support system.

. Developed complex MDX formulas in income statement, balance sheet,

debt analysis, cash flow and investment income moving data across

different dimension members.

. Security maintenance: Maintained users, user groups and access

securities for all the developers and end users depending on their

current privileges.

. Worked on Hyperion system 9.3 Essbase to support complex financial

applications for budgeting that are flexible enough to adopt the

sudden change in the business life cycle.

. Developed a transparent partition with ASO and BSO cubes to leverage

the advantages of both technologies

. Developed automation scripts for back up and Refresh of all Production

Cubes during recovery

. Installed and configured Hyperion Essbase 9.3.1 products in

Development and Production Environment.

. Created User Security system and also test plans to test the security

system.

. Developed Reports like Control reports and Analysis reports using

Business Objects.

. Developed Disaster recovery system (back up scripts).

. Maintenance of batch scripts and scheduling using Autosys.

. Involved in active user interactions for regular hierarchy

maintenance.

Environment: Hyperion Essbase 9.3, AIS 9.3, Hyperion Analyzer 7.2.5,

Hyperion Application Link 9.2,VBA,Essbase Excel-Add-in, Oracle 10g, MaxL,

BO 6.5, MS Office Professional 2003, and Unix HPUX.

Verizon, Richardson, TX

Sr.Hyperion Consultant

Apr 2006 - Mar 2007

Verizon is a leading telecommunications company with a broad range of

services. The company offers various communication services along with

business solutions to customers around the world. This major project was

based on the migration of Verizon's existing business intelligence

structure on to newer versions. As part of a larger consulting team, I was

required to participate in all phases of the development lifecycle, and

played an active role in the development, maintenance and optimization of

new planning databases based on revenue and expense analysis

Responsibilities:

. Loaded data and metadata from flat files through Hyperion Application

Link to the Planning application using planning, flat file, and other

adapters.

. Involved Created custom dimensions, data sources, applications, and web

forms for Planning.

. Used MaxL in an interactive and batch mode to load data files and

automate Essbase operations.

. Moved the metadata from planning application to Essbase cube.

. Developed MaxL scripts to automate the process of loading and swapping

the ASO cubes.

. Involved in performance tuning to minimize data load and calculation time

using the dense/sparse settings and developed the required alternate

rollups for reports.

. Developed aggregate storage cubes (ASO) using Essbase 7.1.

. Migrated ASO and BSO cubes from one server to another to regulate the

server load.

. Maintained job schedules for periodic generation of reports using

different modules of Hyperion Performance Suite.

. Restructured as well as maintained existing Essbase cubes on a regular

basis.

. Involved in front-end design using Hyperion Reports, Hyperion Analyzer

and Excel templates

. Developed batch and rule files to load data from the database to Essbase

cube. Created and scheduled batch jobs for complete automation processes

for application refresh and backup.

. Developed Calc scripts and optimized them according to the Essbase

outline.

. Used Essbase functions like @DESENDENTS and @ISMBR for scripts involving

financial data.

. Developed star schema for the OLAP model, and created EIS Meta-outline

for the Essbase cubes.

. Resolved data storage requirements and up coming needs of the server and

storage devices to support the required performance level of Essbase

applications.

Environment: Hyperion Essbase 7.1.2, EIS 7.1.2, Hyperion Analyzer 7.2,

Hyperion Reports 7.2, VBA, Essbase Excel-Add-in, MS Access, Oracle 10g,

MaxL, and UNIX AIX 5.2.

Staples Inc., Framingham, MA

Essbase DBA/Developer

Aug 2005 - Mar 2006

Staples Inc. is one of the largest office products seller as well as

financial decision support department to do forecasting. Hyperion Planning

is used in developing the G/L system, this application supports the same

functions like current month, actual reporting, multi-year/period analysis,

history archive (G/L does not maintain history), actual allocations,

budgeting, forecasting.

Responsibilities:

. Extensively involved in changing the outlines for cubes on a regular

basis.

. Developed report scripts to populate data, which was fed to the other

cube.

. Was involved in designing the new structure for Metrics.

. Extensively involved in doing automation and developing Calc scripts.

. Responsible in supporting users and maintenance of cubes.

. Extensively involved in performing DBA activities such as performance

tuning the Calc scripts, database tuning, and taking the Essbase backups.

. Involved in migration of Analyzer reports from one environment to another

environment.

. Involved in software upgrades and migration of cubes from one environment

to another environment.

Environment: Hyperion Essbase 7.1, EAS 7.1, EIS, Excel Spreadsheet Add-In,

Hyperion Analyzer 7.2, Hyperion Reports 7.2, SQL Server 2000, VB 6.0,

Informatica (ETL)and Windows 2003.

UMB Financial Corporation, Kansas City, MO

Hyperion Essbase Developer

Jun 2004 - Jul 2005

UMB Financial Corporation is a multi-bank holding which offers complete

banking and financial services to individuals and business customers.

Responsibilities:

. Developed and maintained Essbase Application Objects such as database

outlines, calculation scripts, and dynamic dimension build and data load

rules files.

. Completed tuning, debugging, upgrades, and routine maintenance of Essbase

applications, as well as provided support for these applications.

. Perform constant application administration by enforcing security

measures, scheduled backups and data exports, data loads, and

optimization of databases.

. Executed and documented test cases to successfully reviewed new

application components for use with Hyperion products such as Excel

Spreadsheet Add-in, Analyzer, and Reports.

. Wrote efficient calc scripts to control the order and flow of database

calculations producing accurate results.

. Generated reports regarding system documentation, and help archives.

Environment: Hyperion Essbase 6.5, Hyperion Analyzer 6.5, EIS 6.5, Hyperion

Planning 3.3, Hyperion Enterprise Services, Hyperion Reports 2.6, UNIX AIX,

Microsoft Excel 2000, Oracle 9i, VB 6.0 and Windows 2000 Advanced Server.

TATA Consultancy Services (TCS), Mumbai, India

Database Developer

Apr 2002 - Feb 2004

The project involved the development and customization of the Inventory

management/ Purchase Order, Sales Order (IM/POSO) modules of the Materials

Management System (MMS). The MMS system is a product that is offered to

clients for purchase. The application does the inventory management tasks

like creating and maintaining purchase order, sales orders and performs

excise calculations on the orders.

Responsibilities:

Worked on a conversion project to convert the existing front end to use

Visual Basic 5.0.

Was involved in the database design phase of the project.

Interacted with the Business owners to discuss requirements and creating

technical design document.

Also assisted the QA team in the integration testing of the POSO modules

and worked on the defects reported by the QA team.

Worked as part of the support team to handle vendor support calls.

Worked on client site to provide customization to the existing IM/POSO

modules as per the client business requirements.

Environment: Windows NT, Visual Basic 5.0, Oracle 7.3, SQL LOADER, Forms,

PL/SQL.

Contact this candidate