Sql Server Developer

SRIKANTH

Phone: 408-***-****, E-Mail: ************@*****.***

Education Master's degree in Electrical Engineering. GPA:3.61

Northwestern polytechnic university, Fremont, CA (December

2009)

Bachelor of Technology, Electronics and Electrical. GPA: 3.5

Jawaharlal Nehru Technological University, Hyderabad, India

(April, 2007)

Professional Extensive experience in complete life cycle development of

Summary Hyperion Essbase Cubes, HAL, Database backups, Performance

tuning,Maintenance and Optimization.

Technical skills include Hyperion System 9.3x, Hyperion

Reports, Esscmd, Hyperion Planning, MaxL, Hyperion Business

Rules.

Hyperion Certified Developer for Hyperion System 9.

Skilled in Architecture design of Essbase Cubes using Block

storage (BSO) and Aggregate storage (ASO).

Experience in interacting with business users at

various levels and converting the functional business

requirements into technical specifications.

Developed Batch Scripts and Rules files for dynamically

building dimensions and loading data to Essbase Cubes.

Involved in writing complex calc scripts, automation of

Essbase Cubes using MaxL and ESSCMD.

Technical

Skills Tools

Hyperion Essbase 9.x,Hyperion Planning 9.x, Hyperion Essbase

Administration Services (EAS), MS Excel spreadsheet add-in,

Microsoft Analysis Services 2005, Hyperion System9 Smart View

for Office.

Reporting Tools

Hyperion Web Analysis, Hyperion Financial Reports,

ETL Tools

Hyperion Application Link (HAL)

Languages

C, PL/SQL

Operating Systems

Windows Server 2003

Database

SQL server 2005

Experience: Wachovia, San Francisco,CA

Jun 2009 - Sept 2010

Hyperion Developer/Administrator

Wachovia is a leading Financial Institution and provides

various financial products like general banking, wealth

management, investment banking etc. The Essbase project

involves redesigning and developing new cubes to accommodate

the merger of Wachovia business with Wells Fargo. In

addition, we redesigned the architecture to convert the

existing BSO cubes into ASO cubes

Role & Responsibilities:-

Design and development of Essbase ASO & BSO cubes.

Automated Cube build and load process using Maxl and Shell

scripts.

Design and development of OLAP model and Metaoutlines for

Essbase cube build using Essbase Integration Services.

Development of Oracle stored procedures, packages and oracle

objects to support automation of Essbase security process.

Optimization of Essbase cube refresh cycles by reducing time

to build and load data and using back end cube.

Development of custom Excel Add-in VBA code to support drill

to detailed level data from summary level data.

Developed numerous calculation scripts/business rules for

allocation, forecasting, datacopy between versions and

scenarios

Responsible for security provisioning using shared services

across the entire Hyperion environment.

Design and development of a process to extract data from

several upstream cubes and feed to a downstream cube.

Design and development of Hyperion Planning application for

budgeting and forecasting purpose.

Used Hyperion Application Link to create integrations for

metadata update in Hyperion Planning.

Development of Web forms and Business rules to support

Hyperion Planning applications.

Design and development of reports using Hyperion Financial

Reports & Web Analysis.

Support production system to resolve all the assigned

tickets.

Responsible for monthly maintenance of Essbase cubes.

Environment:- Hyperion Essbase 9.3.1, Essbase Administration

Services 9.3.1, Hyperion System 9 Web Analysis, MAXL, MDX,

Hyperion System 9 WorkSpace, Hyperion System 9 SmartView for

Office, Essbase Excel Add-In 9.3.1, Hyperion System 9 Shared

Services, Hyperion Planning 9.3.1, Essbase Integration

Services 9.3.1, HAL 9x, Hyperion Financial Reporting Studio

9x,Windows Server 2003, SQL Server 2005.

Delta Ups,Hyderabad,India

Feb 2006- Jan 2008

Hyperion Developer

Delta Group is the world's largest provider of switching

power supplies and brushless fans, as well as a major source

for power management solutions, components, visual displays,

industrial automation, networking products, and renewable

energy solutions. Involved in Creating an BSO Application

SalesApp for allocation and forcasting.

Role & Responsibilities :-

Design and development of Essbase BSO cubes.

Performed dimension build and data load for the Essbase cubes

using rule files.

Created Report Scripts for Importing and Exporing the data.

Developed complex calc scripts and formulas for the existing

BSO cubes to implement the business logic. This involved

using complex functions like @shift, @descendants, etc.,

"fixing" on sparse and applying conditional "if" statements

on dense dimensions.

Worked on ESSCMD, MAXL scripts and developed batches to

automate them

Worked on cube enhancement process which involved

discussions, designing, and documenting and adding new

requirements to existing cube outlines.

Worked closely with business users at the time of creating

the reports and extensively involved in requirement gathering

process.

Worked extensively on Smart view as well as Web Analysis for

data manipulation and report creation.

Extensively worked on Hyperion Financial Reports.

Worked extensively on Hyperion shared Services and Created

numerous users, groups and provided them different

privileges.

Worked extensively on production support and was involved in

solving the production tickets.

Provided technical assistance and support to end users and

was involved in developing documentation.

Involved in Migration of hyperion Essbase 7.1.2 to hyperion

Essbase 9.3.1.

Environment :- Hyperion Essbase 9.3.1, EPMA 9.3.1, Hyperion

Financial Reports, Smart View, SQL Server 2005.

Certifications :- Oracle Certified Hyperion Developer.

Contact this candidate