Sql Server Data

[pic]

Abhiram Kampe

*******.*****@*****.***/ *******.*.*****@*****.***

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

Summary

. 6 years of extensive experience in application designing and development

using Oracle Hyperion Essbase 11.x/9.x/7.x/6.x, Hyperion Planning

9.x/4.x, Hyperion Reports, Essbase Integration Services, ESSCMD, MAXL,

Excel Add-In, Hyperion Performance Suite and Hyperion Analyzer.

. Extensive experience on the configuration, server settings, backups,

client installations of Hyperion products such as Hyperion Essbase,

Hyperion Planning, Hyperion Web Analysis/Analyzer, Hyperion Financial

Reporting/Reports and Hyperion Performance Suite on both Windows and UNIX

environments.

. Extensive experience in creating Calc Scripts, Load Rules and Report

scripts.

. Commendable knowledge and experience in Automation using Batch scripts

and UNIX Shell Scripts, Essbase cube designing and partitioning and

optimization of report queries in Microsoft Excel.

. Experience in creating OLAP models & meta-outlines using Essbase

Integration Services.

. Proficient in DBA operations such as Database tuning, backup and recovery

on different servers and operating systems.

. Experience in building Dashboards using JavaScript using Hyperion

Performance Suite/Brio 6.6.

. Created trend reports using a combination of Hyperion Intelligence and

Hyperion Reports.

. Worked on financial reporting systems and Decision Support Systems (DSS)

in Hyperion Essbase.

. Expertise in building Financial Budgeting and Forecasting OLAP

applications with Essbase.

. Excellent communication skills and better understanding of business

requirements and software development cycle in the Hyperion Essbase

environment.

. Highly dedicated towards work goals and creative in new development as

well as solutions to critical issues.

. Experience in writing documentation relating to design, statement of work

documents, work plans and development standards among others.

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 Planning 9.x/4.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

. MS, University of Oklahoma

PROFESSIONAL CERTIFICATION

[pic] Hyperion Certified Consultant for Hyperion Essbase 7.1.2

EXPERIENCE

JPMorgan Chase

Oct 2009-Current

Asset Management

PB/PWM Reporting Tools

Application Developer / Associate

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 weekly, monthly and historical (50) applications and security

from Essbase 7.x environment to Essbase 11.x environment. Utilized

migration utility to migrate applications. Created automation scripts for

loading data in new environment. Utilized replicated partitions between

7.x and 11.x historical applications to copy data.

. Automated ASO export and BSO automatic backup and recovery in Essbase

11.x (New features).

. Involved in designing and developing of Consolidated Reporting Cube for

Private Banking (PB) and Private Wealth Management (PWM) lobs to support

Budgeting, Forecasting and Reporting.

. Held discussions with business users to derive requirements. Lead design

sessions and created functional and technical design documents.

. Authored 'As-is' blueprint of all Functional Requirement Document (FRD)

and Business Level Specifications (BLS).

. Technical design document included the specifications/requirements for

Sql Server and Essbase.

. Created various processes to extract, transform and load (ETL) raw data

from various sources including text files, Excel files and a data

warehouse in Sql Server.

. Created Sql Server Inegration Services Packages (SSIS) to automate all

the ETL processes.

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

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

MaxL scripts. Created transparent partitions between source and target

applications to support load of actuals, budget and forecast data.

. Created groups and users for different business segments and then

assigned security and filters to define Essbase privileges on them.

. Designed the budgeting and year-end process for Corporate and Divisions.

. Worked closely with the End users to understand their Reporting needs and

updated the essbase applications accordingly.

. Designed and implemented Balance sheet in an existing cube based on the

user requirements.

. Modified the existing Essbase Applications to reduce the calc time and

maintenance required for it. Designed/Modified the Essbase Cubes based on

reporting needs of the users. Responsible for the design, development,

enhancement, and maintenance of the various BSO cubes used for

forecasting and strategic decision-making.

. Created batch scripts using Maxl to automate Essbase application refresh

process (dimension building, data loading and calc scripts).

. Created partitioning and also used cross database function to load slice

of data from other remote cube. Used Essbase partitioning to improve

performance of Essbase Application.

. Developed Calc Scripts for allocation of expenses for the budgeting

process. Developed Calc Scripts for complex calculations and for currency

conversion and optimized them.

. Recovered application from its backup.

. Responsible for production support and training business users.

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.

JPMorgan Chase

Jan 2007-Oct 2009

Retail Financial Services

EDW Finance

Retail Financial Systems / Brach Profit and Loss

Application Developer / Assistant Vice President

Responsibilities:

Retail Financial Systems (Budgeting and Forecasting):

. Responsible for system enhancement, maintenance, and administration.

. Authored 'As-is' blueprint of all Functional Requirement

Specifications (FRS) and Business Level Specifications (BLS).

. Developed and maintained various budgeting and forecasting (Income

Statement, Balance Sheet and Indirect Expenses) applications using

Essbase 9.x/7.x and Hyperion Planning 4.x/9.x.

. Migrated Essbase 7.1.5 applications to System 9.

. Designed/Developed standard architecture to perform data loading,

error reporting and process logging in Unix in dev/tst/prd

environments.

. Developed calculations in Essbase (Member Formulas and Calculation

Scripts).

. Worked with Essbase integration Services (EIS) to create OLAP model

and Meta outline for Essbase OLAP server; developed various filters as

per user requirements and drill-through reports .

. Implemented SQL Drill through using Essbase Integration services.

. 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

. Assisting users in set up, installation and usage of Essbase client.

. 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.

. Support production system to resolve all the assigned tickets.

. Responsible for monthly maintenance of Essbase cubes.

. Created all the required documentation like design, level of effort,

project schedules, process flow and production support for all the

projects involved.

. Extensively designed Sql Server Data Transformation Packages (DTS) and

Sql Server Integration Services (SSIS) packages to accomplish data

processing (ETL) tasks.

. Created yearly, quarterly, monthly and weekly reports using Hyperion

Financial reports.

. Created groups and users for different business segments and then

assigned security and filters to define Essbase privileges on them.

Worked with Essbase Advanced Security Manager to extract and

manipulate users/groups/&filters

Branch Profit and Loss:

. Involved in the monthly maintenance, load and back-up BPL (Branch

Profit and Loss) and NBPL (New-Build Profit and Loss) applications.

. Involved in BPL and NBPL Package maintenance which utilize Alphablox

and Excel VBA.

. Involved in making necessary outline, data and package changes as

requested by Business partners.

. Created Ranking cube that houses Branch, District and Market ranks.

Essbase responsibilities included:

. 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: Hyperion Essbase 9.3.1/7.1.5/6.5.5, Essbase Administration

Services 9.3.1/7.1.5, Hyperion System 9 Web Analysis/ Hyperion Analyzer

7.2.1, 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/4.0.1, Essbase Integration Services 9.3.1/7.1.5,

HAL 9x/7.x, Hyperion Financial Reporting Studio 9x/7x, HP AIX Unix, Windows

Server 2003, SQL Server 2005/2000.

JPMorgan Chase

May 2006-Dec2006

Retail Financial Services

EDW Finance

Branch Profit and Loss

Consultant

Responsibilities:

. Involved in designing & standardizing P&L Essbase load architecture.

. Migrated the P&L application from Windows environment (Essbase 6.5.5)

to Unix environment (Essbase 7.1.5).

. Converted Windows ESSCMD script to Unix MaxL scripts.

. Created Shell scripts to execute ESSCMD & MaxL scripts.

. Optimized the various cache settings to enhance the performance of

Cubes.

. Involved in maintaining various Data Transformation Services (DTS)

packages, which provide 30% of files to P&L Essbase cubes.

. Created various FTP scripts to move the files between Windows and Unix

servers.

. Created Calc Scripts & outline formulas to determine the rankings of

all the branches.

. Create MaxL scripts for dimension building & data loading.

. Involved in reviewing the cube design, Performance Monitoring and

Performance Tuning of the Essbase server.

Redesigned BSO cubes as ASO cubes.

. Created MaxL scripts to automate month end maintenance for daily cubes

. Extensively utilized Mercury Load Runner for performance monitoring.

Environment: Hyperion Essbase 7.1.5/6.5.5, Essbase Administration

Services,, ESSCMD, MAXL, Excel Add-In, Windows Server 2003, SQL Server

2000/2005,HP AIX Unix, Shell scripts, Load Runner 8.0.

Verizon Business (MCI) Oct2005-

May 2006

Application Developer / Consultant

Role & Responsibilities:

. Involved in gathering requirements and developing a project plan.

. Involved in gathering data and supervising data load.

. Designed and developed the outline for an aggregate storage (ASO)

Essbase application.

. Involved in creating Rule files and batch files to automate the data

load process.

. Optimized Data Loads and Calc Scripts.

. Restructured and redesigned previous Essbase cubes including a

conversion from Block Storage (BSO) to an Aggregate Storage (ASO)

database.

. Worked extensively with Hyperion Planning to create budgeting and

forecasting applications.

. Developed a list, pivot, master-detail and chart in Hyperion

Performance Suite.

. Executed DBA duties like automation of Outline build and data loads

for cube refreshing, updating substitution variables, performing month

end and year end maintenance, ongoing performance tuning,

defragmenting, taking regular backups, restoring Essbase objects or

complete applications in case of a server crash.

. Used Essbase administrative activities such as filter creation,

creation of users, creation of groups and maintenance of Essbase

Servers.

. Restructured existing cubes using Transparent Partitioning to improve

the data loading and calculation times.

. Extensively used Essbase Integration Services for dimension building &

data loading.

. Created Budget Variance Report, Prior Period Trending Report, Year on

Year Trending Report and Trial Balance Reports in Hyperion Reports and

Hyperion Analyzer.

. Created Transaction Detail, Capital Reports, various Document Search

and converted Actuate Reports to HPS Reports using Hyperion

Performance Suite.

. Created numerous Ad-Hoc reports using Hyperion Reports, Hyperion

Analyzer and Hyperion Performance Suite.

. Extensively used JavaScript to build dashboards in Hyperion

Performance Suite.

. Performed Job Publishing, Job scheduling using Hyperion Intelligence

Server.

. Implemented security and user management in Essbase used MaxL to

automate user creation.

. Worked with Load Runner tool to test the performance of the cubes when

200,500 users logged in simultaneously.

. Implemented user update in Hyperion Reports, Hyperion Analyzer and

Hyperion Performance Suite from Essbase.

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

in, Hyperion Reports, Hyperion Analyzer and Hyperion Intelligence to

load data, run reports and the basic concepts of multidimensional

databases.

. Designed and developed optimized Essbase applications.

. Developed Excel Templates for user interface in Essbase database.

. Actively participated in defining requirements, functional

specifications, designing documentations and testing strategies

Environment: Oracle Hyperion Essbase 7.1.2/6.5.1, Hyperion Planning

4.0.1,Hyperion Analyzer 7.2.1, Hyperion Reports 7.2,Hyperion Performance

Suite 8.3, JavaScript, Essbase Administration Services,, ESSCMD, MAXL,

Excel Add-In, Oracle 8.x and 10G, Windows Server 2003, Sun-Solaris Unix,

Shell scripts, Load Runner 8.0.

Satyam Computers

Jun 2002 - Aug 2003

India

Essbase Developer

Responsibilities:

. Installation of Essbase family products in both Windows 2000/NT and UNIX

(Sun-Solaris) environments.

. Responsible for producing the functional design documents and

specification for the Essbase modules.

. Maintenance of two pre-existing Essbase cubes.

. Involved in script writing for dynamic dimension builds and data loads.

. Worked on performance tuning of data loads and calculation times.

. Design and development of calculation scripts.

. ESSCMD is extensively used to run these calc scripts.

. Developed the Load Rules to automatically validate the data and feed into

Essbase new structure.

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

cube.

. Created batch files to run calc scripts, data load and data calculations.

. Extensively worked with Hyperion Reports and Hyperion Analyzer.

Environment: Hyperion Essbase 6.1/6.0, ESSCMD, Hyperion Analyzer, Excel Add-

In, Oracle, Windows NT/2000, Hyperion Reports, Sun-Solaris UNIX

Contact this candidate