Manager Sql Server

An accomplished Essbase Multidimensional database and Hyperion Planning

administrator with demonstrated success designing and implementing database

solutions that improve business functionality. Possess diversified

background. Proven ability to deal with technologies that decrease costs,

increase performance and positively affect the bottom line.

QUALIFICATION HIGHLIGHTS

> Over 6 years of experience in IT including consulting and

administration experience with Hyperion products and OLAP-related

technology

> Strong knowledge of Hyperion Essbase and Planning (ver 6x, ver 7x, 9x

and 11x) and Hyperion Essbase, Planning internals including calc

scripting, MDX & MAXL and Hyperion Enterprise 6, HAL.

> Has provided support and administration for Hyperion Essbase & Reports

> Experienced in the installation of several Hyperion products in

windows environment.

> Experience as consultant, technical analyst, network administrator and

specialized in Oracle - Hyperion 6x, 7x and System 9 implementations.

> Expertise in full project life cycle development for implementation,

integration, support and enhancement.

> Well versed with financial terms like General Ledger, Reporting and

Analysis, Budgeting and Forecasting.

TECHNICAL EXPERTISE

Op. Systems: Windows NT 4.x, Windows 2000 and XP, UNIX

Databases: Hyperion Essbase v6.x, v7.x, System 9.3.1 and 11.x, Hyperion

Planning 9.x and 11.1.2.1 (EPM), Hyperion Enterprise 6.0, MS SQL Server

2000,2005,

Software: Hyperion Essbase, Hyperion Essbase Administration Server,

Hyperion Enterprise 6, Hyperion Reports, Hyperion Shared Services,,

Hyperion Analytic Administration sever (AAS), Application Manager Hyperion

Reports, SmartView, MS Office, VB Excel Skills and Templates, Windows

Scripting, MDX, ESSCMD, MaxL, VNC, Dameware, PL/SQL, C, C++ and Java.

PROFESSIONAL EXPERIENCE

Client: Cymer Inc, San Diego

Company: Mahindra Satyam

Role: Hyperion Consultant

Duration: Mar

2011 - Till Date

> Supporting Financial System of client involving Net Revenue Reporting,

Gross Revenue Reporting, Cash Flow and Balance Sheet, Employee

database etc. (Actual, Forecast and Budget data)

> Upgraded the system (Hyperion Planning) from 9.2.0.3 to EPM 11.1.2.1

(Latest version) in distributed environment.

> Have been working as an admin on latest version

> Created new calc scripts, MaxLs, Batches for new system

> New system is pretty stable and resolved every issue

> Good experience on all versions (Hyperion Essbase and Planning),

Physical as well as virtual Environment

> Performing weekly, monthly and yearly activities such as archiving,

monthly actual load through HAL, user training, resolving issues

through Team Track (ticketing System), User Security etc.

Client: Ernst & Young (NJ, USA)

Company: Hexaware Technologies Ltd.

Role: Hyperion Consultant

Duration: Mar

2010 - Mar 2011

> Essbase Admin. Worked on Essbase Cube development process in DEV, QA

and PROD.

> Daily maintenance, support and enhancement (BSO/ASO)

> Involved in writing complex Essbase calculations scripts, automation

of Essbase Cubes using MaxL, ESSCMD, and MDX.

> Developed Batch Scripts and Rules files for dynamically uploading

dimensions and data to Essbase Cubes.

> Skilled in optimization and performance tuning of Planning and Essbase

application data/metadata processing, upgrading, testing and migration

of cubes in different environment.

> Responsible for security groups and access for the users in Hyperion

Reports and Hyperion System 9 Planning and Hyperion Shared Services

> Actively involved in taking daily requests (Ad-hocs) from users and

fixing them.

> Worked extensively on production support and was involved in solving

the production tickets.

> Developed functional as well as technical documentation of the

existing Essbase cubes and financial reports to transfer knowledge

for users, for administration and support.

> Worked closely with business persons, and extensively involved in

requirement gathering process.

> SQL Server 2005 (MaxL, MDX, ASO/BSO), worked on SQL stored procedures,

SQL Jobs to atomize essbase jobs ( through MaxL scripts)

> Developed Excel VBA code using macros and formulas to model and create

financial reports to be used with Essbase.

> Used Hyperion Essbase Excel Add-In for data manipulation and report

creation

> Well versed with financial terms like General Ledger, Reporting and

Analysis, Budgeting and Forecasting. Maintained mapping tables (GL and

GCOA)

> Data refresh as per users demand, data transfer to another Essbase

Cubes/other Hyperion Systems.

Client: Citibank

Company: Wipro Technology Services

Role: Hyperion Consultant

Duration: May

2009 - Jan2010

> Extensively involved in total SDLC (Software Development Life Cycle)

of Essbase Cubes.

> Daily maintenance, support and enhancement

> Worked on currency conversion on Essbase cubes.

> Created MAXL scripts and developed batches to automate them.

> Worked extensively on Hyperion Reporting, EAS and Created numerous

users, groups and provided them different privileges.

> Developed Excel VBA code using macros and formulas to model and create

financial reports to be used with Essbase.

> Used Hyperion Essbase Excel Add-In for data manipulation and report

creation.

> Worked extensively on production support and was involved in solving

the production tickets.

> Developed functional as well as technical documentation of the

existing Essbase cubes and financial reports to transfer knowledge

for users, for administration and support.

Client: International Masters Publishers (IMP), Malmo, Sweden

Company: Tata Consultancy Services, Stockholm, Sweden

Role: Hyperion Administrator

Duration:

Mar 2006 - Mar 2009

Description: As a Hyperion Administrator, responsible for implementation,

migration and technical-support for maintaining Hyperion Essbase production

and Development servers for various clients. Working onsite and supporting

client through VNC, Dameware or other remote desktop tools. With the

leadership qualities and also as a versatile team player in the migration

team worked with other analysts to understand requirements, specifications,

testing strategies and also for planning the project time line for

migration.

> Worked at client Location (Malmo, Sweden) (End user support, issue

analysis and bug fixing)

> Migrated of Essbase from version 6.5.4.2 to 7.1.6.

> build rules/ load rules/calc script development, EssCmd/MaxL

Scripting, security/administration

> Provided technical Support for Oracle- Hyperion Essbase and Hyperion

Enterprise 6.0 with clients spread all over Europe, US, EMEA and APAC

as a part of Hyperion Worldwide Support.

> Supported Financial System of IMP involving Net Revenue Reporting,

Gross Revenue Reporting, Cash Flow and Balance Sheet, Liquidity

reporting etc. (Actual, Forecast and Budget data)

> Backup of development and production server.

> Developed several excel templates (Excel Developer) using VB.

> Implemented application security process, created users/groups,

security profiles and application access to different groups using

filters.

> Trained new users on the Essbase system and Reports, and Essbase Add-

In

> Install Hyperion shared services and configure users with security

provisioning

> Migrating user, filters, applications and databases.

> Upgrading client machines to new versions.

> Using windows task scheduler for customized DOS batch scripts with

ESSCMD to backup periodically.

> Performed optimizations of Essbase database calculations, load and

query performance times.

> Responsible for Performance Monitoring, Backup and Recovery of the

cube.

> Troubleshooting Essbase database partitioning related issues and data-

load on portioned cubes.

> Automated Essbase system with MaxL and server side batch scripting.

> Work with client's IT administration team to configure firewall and

network requirements for Hyperion applications

> Used Shared Services to create users, groups and assigning roles

according to the requirements.

> Provided technical assistance and support to end users and was

involved in developing documentation.

> Document Hyperion system processes and responsible for complete system

documentation and training materials.

> Provided training to end users in using the MS Excel spreadsheet add-

in to load data and the basic concepts of multidimensional databases.

> Involved in building an outline and assigning descriptive alias name

to members.

> Extensively involved in Essbase Administration activities such as

filter creation, creation of users, and creation of groups and

maintenance of Essbase Servers.

> Provided 24/7 Essbase technical supports to all business units of

Essbase / Reports / Enterprise, offered suggestions and proposed

solutions to resolve issues and involved in recovery and back up on NT

Servers.

> Optimized dense and sparse database settings for improving retrieval

times.

> Involved in performance tuning, backup and recovery of cubes.

> Involved in system upgrades and client installations based on users

requirements.

> New user desktop installation and tracking Hyperion licenses

> Well acquainted with financial terms like General Ledger, Reporting

and Analysis, Budgeting and Forecasting.

> Mapping of accounts between chart of accounts and GL (through Excel

templates). Data transfer in between essbase cubes.

ACHIEVEMENTS: Customer Satisfaction Top Performer Sep-Nov 2008.

Environment: Hyperion System 9.3.1, Shared Services, Hyperion Essbase

9.x, 7.x and 6x, Hyperion EAS, Hyperion Reports, MaxL, ESSCMD, VB

Excel Developer, Hyperion Essbase Spreadsheet Add-In, MS SQL Server,

Windows 2003 Adv server, VNC, Dameware, Windows NT, XP & Unix.

Project: Competitive Intelligence & Market Research (CI&MR)

Company: Tata Consultancy Services, Mumbai.

Role: Hyperion User and Market Analyst

Duration: Sep 2005 - Mar 2006

Description: Financial performance analysis of the competitor IT companies

using Tools as well as Market Research using research tools like Gartner,

IDC, Forrester, Datamonitor, IDC etc.

> Did research on various competitors and developed 15+

competitor/customer/market based intelligence reports for both senior

management and sales team globally. Profiled customers across various

horizontals/verticals of the IT industry.

> Analyzed the financial performance of the competitors and made

presentations on the same. Well acquainted with research tools like

Gartner, Forrester, Factiva, IDC, Datamonitor, Bloomberg and other

free and paid news sources.

> Conducted training sessions and mentored new members of the team.

> Took initiative to market the reports to the sales and practice heads.

> Identified methods to create awareness amongst employees and

implemented the same to increase the foot print of the team.

> Involved in negotiation with the customers for requirement gathering

> Performed User Acceptance Test of the Competitive Intelligence System

> As an extracurricular initiative I was also made the fun manager of

the floor and was responsible for events and activities to create a

lively atmosphere in the office.

EDUCATION

1] Sardar Patel College of Engineering, Mumbai - India

Bachelor of Engineering, 2001-2005

Major: Computer Science

Achievements: 1] Overall First Class, 2] Positioned amongst top 10 in

the class of Computer

Engineering 2005, 3] Selected as class

representative of 2nd year

2] Maharashtra Board - India

HSC (Grade 12), 1999- 2001

Score: 91.5%

3] Maharashtra Board - India

S.S.C (Grade 10)

Score: 92.5%[pic]

Contact this candidate