Data Sql Server

SRINI

Objective

. Optimize the best possible outcome from available resources with

my rich experience in

Corporate Financial Planning and Business Performance Management.

. Apply learned concepts in the practical domain and to excel in new

areas of work with the help

of conscious-based education and decision making skills.

Professional Summary

. Over 10 years of efficient, dynamic, result-oriented experience in

IT, Design & Development of OLAP, Decision Support Systems, Business

Intelligence, Client/Server and Internet Applications.

. 5 years of experience in application design, development and

implementation using Hyperion Essbase (7.x, System 9, EPM 11),

Hyperion Planning.

. Complete understanding of Hyperion Architecture, proficiency and

experience with developing requirements, specifications, design

document development, development, parallel testing, migration to

production environment of Hyperion Essbase 7x,9x and EPM 11.

. Knowledge of latest version under Hyperion suite: Hyperion Essbase

11x and Hyperion Planning 11x Experience with installation,

configuration of 11.1 versions and upgrade or migration from 9.x

versions

. Knowledge and experience with relational drill-through, managing

spreadsheet templates, reporting on web-analysis.

. Proficiency in data warehousing techniques, conversion from

relational databases to multidimensional (Essbase) forms, ETL,

application of PL/SQL for migration, querying, development, end-user

training, issues and trouble shooting management during development,

parallel testing and production environment for Essbase (7, 9 and

11x).

. Upgrading and migration experience with Essbase 7, 9 and 11x

versions and migrations from relational models (SQL Server, IBM DB2,

Oracle RDBMS) to multidimensional models. Expertise in ETL

processes.

. Experience in over 4 full life cycle Hyperion Architecture and

Essbase implementations from requirements gathering, functional

analyst responsibilities, and understanding data warehousing

resources and limitations and conceptual applications.

. Proficiency and experience in a range of Hyperion products including

Essbase, Hyperion Planning, Hyperion Financial Reports, Web Analysis

Integration Services, Smart view and Spreadsheet Add-In, in both

Windows and UNIX environments.

. Expertise in administrative tasks of Essbase: managing applications

and databases, Essbase architecture, data and dimension loading,

Calc Scripts, MaxL, MDX Querying, Report Scripting, Performance

tuning.

. Experience as a Hyperion Essbase Administrator with Security Setup

and Management: User Management, User roles, Shared Services setup,

assigning server and application access, database calculation,

filtering, assignment of application access types.

. Proficiency as Essbase Administrator in maintaining Essbase,

managing database settings, optimizations, thorough understanding of

ASO and BSO cube architecture, Essbase Cache settings, optimizing

calculations, attributes, storage security, optimizing reports.

. Experience in working through all phases of Software Development

Life Cycle (SLDC) including the design, development, implementation,

and maintenance of financial applications.

. Knowledge of UNIX OS and UNIX Scripting, FTP/SFTP, AIX, Windows

Servers for administrative, management and support needs for data

management and integration management.

. Experience and expertise in managing and administering numerous

Essbase applications and cubes (Block Storage and Aggregate

Storage), forms, reports, and books.

. Applied in-depth understanding of STAR and SNOWFLAKE SCHEMA modeling

techniques to develop optimized OLAP models and meta-outlines using

relational and other database sources.

. Substantial experience in creating, maintaining, and supporting all

application objects including outlines, calculation scripts, rules

files for dimension building and data loading, creation and

optimization of transparent partitions, and security objects through

Essbase Administrative Services (EAS), MaxL, MDX queries, and

ESSCMDs.

. Knowledge and experience in Automation using batch scripts,

optimization of report queries in Microsoft Excel, creating ad-hoc

reports for decision makers using Smart View and other applications.

. Skilled in performance monitoring, tuning, and optimization; Played

an active role in debugging procedures by developing and

implementing test cases

. Result oriented experience in database and retrieval performance

optimization, tuning, performance analysis, and creation of

debugging procedures through development of dynamic test cases.

. Expertise in building Financial Budgeting and Forecasting OLAP

applications with Essbase.

. Assisted to develop the Test Plan, Test Cases and Test Scenarios to

be used in testing based on Business Requirements, technical

specifications and/or product knowledge.

. Assisted end-users with developing complex reports to meet

requirements; developing ad-hoc analysis reports as needed

. Demonstrated ability to work as part of a team to analyze complex

business requirements and translate them into business intelligence

solutions.

. Excellent technical, oral, communicational and analytical skills.

Admirable interpersonal abilities and an efficient team player

Education: Master in Business Administration

Certification: HCC - "Hyperion Certified Consultant - Hyperion Essbase

7.1.2"

Training: Hyperion Planning bootcamp training (C.O.E Mahindra

Satyam)

Technical Skills

Hyperion Products Hyperion Essbase 11.x/9.x/7.x, Hyperion Planning, FDQM,

Essbase Integration Services, Hyperion Smart View for Office

Database Systems Hyperion Essbase Block Storage (BSO),Aggregate Storage (ASO)

11x/9.x/7.x, MS SQL Server, Oracle 8i, 9i, 10g, MS Access

Reporting Tools Web Analysis, Hyperion Financial Reporting, Excel Add-in,

BusinessObjects

Languages MDX, MaxL, ESSCMD, Visual Basic SQL, PL/SQL, Scripting, C

Operating Systems Windows 98/XP/NT/2000, Windows Server 2000/2003, Sun

Solaris,

MS-DOS.

Computer Software Microsoft Word, Excel, PowerPoint, Access, Outlook

Scheduling Software $U, Windows Scheduling, Autosys

Utilities Erwin, TOAD, B.O. 6.5/XI ETL - Informatics 8x

Dimensional Star Schema and Snow Flake Schema Modeling, Fact and

Modeling Dimensional Tables, Physical and Logical Data Modeling

Professional Experience

Cisco Systems, Inc. Sanjose, CA,

June 2010 - till current

Hyperion Planning and Essbase Consultant

Project Summary: Cisco is one of the world's biggest technology

corporations that designs and sells consumer electronics, networking,

voice, and communications technology and services. Headquartered in San

Jose, California, Cisco has more than 70,714 employees and annual

revenue of US$ 40.0 billion as of 2010.

Fetch (Financial Expense, Capital and Headcount tracking) is an

enterprise-wide integrated reporting solution designed and developed

for tracking, multi-dimensional analysis, planning, budgeting and

forecasting of Cisco's expense, capital, and headcount data via the

FETCH Enterprise Reporting Suite.

Responsibilities:

. Developed ASO and BSO cubes using Hyperion Essbase that contained

financial data that was retrieved using FR reports.

. Developed Hyperion Planning application (full cycle implementation)

for budgeting and forecasting requirements. Worked with business

analysts for requirements gathering and creation of design

documentation.

. Collaborated with end-users and stakeholders to bring form and

clarity to a multitude of data sources which enabled data to be

displayed in a meaningful analytic way

. Modified the existing 12 Months Budget in Account dimension to 24

Months Budget to sync the planning application.

. Used to take the timely back up of all the required Essbase and

Planning applications.

. Involved with Hyperion Planning budgeting application to add

dimensions, assign member properties, variance reporting procedures,

time balancing, currency dimension properties, overall metadata

building and refreshing the data.

. Created and managed data forms, involved in implementation of

decided budgeting process involving planning units, starting review

process, and entity hierarchy and workflow notifications.

. Created Business Rules with run time prompts for planning web forms

(consolidation, and currency conversion).

. Developed metadata for eight standard dimensions including Account,

Scenario, Entity, and Cust_segment. Involved in Metadata loading and

development working closely with ETL team.

. Built metadata for planning applications by using OutlineLoad

utility.

. Designed documents from requirements gathering to technical

documentation for all the cubes. Created Test Plans document for all

the cubes for the business users.

. Created knowledge transfer document for Essbase cubes.

. Created Essbase Detail Design Requirements document for all the

current and historical cubes which includes ASO and BSO application.

. Data must be loaded to Essbase cubes, EPM tables, etc as frequently

as permitted by the source systems, with the stated objective of

meeting the general business requirement to have data updated and

available in the financial reports by 7:00 am Eastern Time Assuming

a nightly frequency, the data load process will begin as soon as the

data warehouse load is complete.

. Worked closely with the testing team to help them in data validation

and issues related with the data validation.

. Created MaxL script to automate the cube build process and developed

wrapper shell script to integrate all the MaxL scripts into it.

. Validate data quality between sources (Info cube) and target

(Essbase cube).

. Created Transparent partitions among the ASO source and BSO target

cubes.

. Maintained application security and added/deleted users per

management requests.

. Was responsible for all the scripts migrations and their validations

in all the environments.

. Developed filters to restrict uses from accessing restricted

dimensions and assigned substitution variables using MaxL Scripts.

. Worked on tuning and optimization of ASO cubes.

Environment: EPM Hyperion 11x, Hyperion Planning, Workspace, Excel

2003, 2007, Oracle 10g, HP UNIX and Windows 2003 Server with SP2.

Autosys, Shell scripting, MaxL Scripting, MDX Queries.

Wells Fargo, San Francisco, CA

Sep 2009 - May 2010

Hyperion Essbase and Planning Consultant

Project Summary:Wells Fargo is a diversified financial services company

- providing banking, insurance, investments, mortgage and consumer

finance for more than 23 million customers through 6,046 stores, the

internet and other distribution channels across North America and

elsewhere internationally.

Responsibilities:

. As part of Day2 ERP Implementation at Avago Technologies which has

spun out of Agilent and got its own system installed, had provided

support on the Hyperion Reporting track.

. Involved with finance, budgeting, accounting, and operations

departments to develop Functional Specifications Document and

develop design for overall Hyperion implementation for Planning

application operating against an Essbase engine.

. Involved in requirements gathering, design, development,

implementation, production testing, and implementation of Planning

and Essbase projects.

. Instituted Performance Management Hyperion Planning Architecture (3-

tier) - data tier, middle tier and client tier.

. Worked on Hyperion Planning Workflows to assist and enable end users

to control budgeting process by planning unit.

. Developed Hyperion Planning application (full cycle implementation)

for budgeting requirements. Worked with business analysts for

requirements gathering creation of design documentation.

. Hyperion Planning budgeting architect based responsibilities

involved performing prerequisites to creation of Planning

application - starting the RDBMS database, creation of data sources,

creation of Shared Services Planning project, and eventually the

creation of Planning application using Classic Administrator.

. Involved with Hyperion Planning budgeting application to add

dimensions, assign member properties, variance reporting procedures,

time balancing, currency dimension properties, overall metadata

building and refreshing the data.

. Created and managed data forms, involved in implementation of

decided budgeting process involving planning units, starting review

process, entity hierarchy and workflow notifications.

. Designed and built a corporate based Hyperion Planning application.

. Built Web forms for data entry, and read only forms for data

retrieval.

. Built and Maintained security in shared services and Planning.

. Created Business Rules with run time prompts for planning web forms

(consolidation, and currency conversion).

. Created task lists to provide guidance to the budget preparers

through the planning process.

. Added Smart lists to provide pre-populated drop-downs.

. Prepared a statement of work (SOW) for a Transparent partition

Assignment, defining the objectives and scope, approach and

deliverables, and any assumptions.

. Built a transparent partition between an Aggregate Storage (ASO) and

a Block Storage (BSO) for faster consolidation.

. Used XREF functions to share data across plan types.

. Provided Planning/Essbase application support.

Environment: Windows NT, OLAP Tools using Hyperion System 9 BI+ Essbase

Analytics, BI+ Web Analysis, BI+ Financial Reporting, Hyperion System 9

Planning, Hyperion System 9 Workspace, Hyperion scripting languages

(MaxL, Esscmd, MDX), MS Office, DOS scripting, VB scripting.

Avago Technologies CA,

July 2008 - August 2009

Hyperion Essbase Administrator and Developer

Project Summary: Avago Technologies provides an extensive range of

analog, mixed-signal and optoelectronic components and subsystems to

tens of thousands of manufacturers around the world. The company's

products serve four end markets: industrial and automotive, wired

networking, wireless communications, and computer peripherals.

Responsibilities:

. Developed the project plan for the implementation that identifies

the schedule, task, milestones and requirement.

. Involved in Architecture Design and development of new cubes for

quarterly budget and forecast models.

. Implemented Essbase in connection with financial budgeting, sales

forecasting and marketing analysis to produce ad-hoc reports.

. Migrated Essbase applications across the version.(9x, 11x).

. Was involved in the installation of Hyperion Essbase 7.1.2

. Created dimension building load rule and data load Rule for dynamic

dimension building, attribute dimension building and data loading in

Essbase.

. Involved in supporting the existing Hyperion environment with 7

cubes a reporting dash board. Working on the performance tuning

(Cube Optimization) of the Applications for the fast data loads,

better calculation times of the cubes and fast retrieval of the

reports using ASO migration, Dense/Sparse settings, ASO migration,

Cache settings, Outline formulas and Calc scripts.

. Developing Batch Scripts and Rules files to dynamically upload

dimensions and data from Legacy System to Essbase Cubes.

. Developing calc scripts for allocating actuals and budget numbers to

different business units.

. Implementing star schema and used EIS to interface with the

company's existing Oracle 10gig data warehouse.

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

Essbase Integration Services.

. Involved in performing admin activities like create users, password

setting, group and filters.

. Involved in making the Essbase backups and restores of Essbase

application.

. Implemented robust data-access security and user management.

. Developed Aggregate Storage Cubes (A.S.O) cubes using Essbase 7.1

. Using Essbase Integration Services (EIS) for building dimensions.

. Installing and up-grading of Hyperion Essbase, Essbase Integration

Services.

. Developing new reports and managing reports repository using

Hyperion Reports and Hyperion Analyzer.

. Extensive usage of substitution variables and setting appropriate

values in them.

. Designed and developed canned reports for internal and external

users.

. Developed transparent partitioning to optimize the calc time on the

cube.

. Developed ASO cubes and converted BSO applications to ASO

applications to increase performance and speed.

Environment: Hyperion Essbase 7.1.2, Hyperion Analyzer 7.0, Hyperion

Reports7.0,

Essbase Integration Services 7.1.2, Microsoft Excel 2000, Oracle 9i,

IBM AIX, Windows NT 4.0, ESSCMD, Maxl, Excel Add-In.

JP Morgan Chase, NY

May 2007 - June 2008

Hyperion Essbase Developer

Project Summary: JPMorgan Chase & Co is a leading global financial

services firm with assets of $1.8 trillion and operations in more than

60 countries. Market Risk Infrastructure Program is a strategic

initiative that focuses to develop a foundation of future state of

infrastructure, strategic calculation and analysis as well as to

deliver a unified set of initial reports for the Market Risk. All

market risk reports are provided by the MRI environment.

Responsibilities:

. Developed a multi-dimensional database (MDDB) OLAP application using

Essbase that stored and maintained company's financial and marketing

data.

. Designed and developed Essbase applications with excellent balance

of dense and sparse dimensions, arranged in an hourglass fashion.

. Extensively used Excel Spreadsheet add-in to design front-end which

saved significant amount of time and helped in extracting and

manipulating corporate data.

. Developed, maintained, debugged and optimized Rule files, Calc

Scripts.

. Responsible for creating System Test plan as well UAT Scripts.

. Worked as an administrator by giving privileges to the end users and

responsible for creating users, groups and creating numerous filters

and assigning them to the end users.

. Actively involved in full project development life cycle of Hyperion

Essbase Cubes, Functional Specifications Document (requirements

gathering), application design, development, parallel testing,

rollout into production environment, implementation and end-user

training across subsidiaries.

. Designed an effective framework for cube building from EIS from the

relational data source.

. Involved in dimension building and data loading using Essbase

Integration Services (EIS) by OLAP Models and Meta outlines.

. Optimized structure, loading and calculations through appropriate

dense and sparse settings of dimensions, storage allocations and by

dynamic calculations and debugging.

. Automated Essbase operations through MaxL scripts in shell script

programming to run monthly balance sheets and ledgers.

. Involved in performing DBA activities such as performance tuning the

calculation scripts, along with taking periodical ESSBASE backups.

. Sophisticated process that built two cubes one daily snapshot and

one comparison that restructured the data with current day

hierarchies

. Developed a Reference cube to the daily snapshot cube in order to

refer the old hierarchies with the current data. Made use of

reference cube concept to improve the performance.

. Created wrapper shell scripts (parameter driven) to automate the

process.

. Implemented robust data-access security and user management

. Package the cube and re-create them from a particular day (needed

for As-of-day hierarchy), this whole process takes less than

10min's.

. BPM interaction for kicking of the cube build.

Environment: ESSBASE 9X, EIS 9X, BI Plus 9x, Oracle 9i and 10G,

Autosys, Shell scripting, Maxl Scripting, MDX Queries, PLSQL,

Reconciliation Framework, Optimization/ performance Tuning, EIS

automation

General Electric, Ft. Wayne, IN

Aug 2006 - Apr 2007

Essbase Developer

Project Summary: GE is a conglomerate made up of six businesses, each

of which includes a number of units aligned for growth. I was involved

in designing, developing and maintaining an application that will be

used to assess GE's Financial Performance, perform Operating Expense

Analysis, and prepare Headcount/FTE Cost Center reports. The aim of the

project was to provide the top management and end users with Operating

Expense and Allocation Analysis for each of the business segments

separately and as per the user requirements.

Responsibilities:

. Implemented Essbase in connection with financial budgeting, sales

forecasting and marketing analysis to produce ad-hoc reports.

. Translated end user requirements into application design

specifications.

. Involved in the Development of four cubes - one for Industrial

Sales, one for Production Planning and Budgeting, one for Market

Research and one for Customer Analysis.

. Automated the data loads using ESSCMD in both interactive and batch

modes

. Implemented Dos, MaxL, Esscmd, Report and Calc Scripts.

. Assured optimal match between cube design and report specifications

. Optimized structure, loading and calculations through appropriate

dense and sparse settings of dimensions, storage allocations and by

dynamic calculations and debugging

. Utilized Application Manager/EAS: Model sizing, optimized cache

settings, established user security, managed applications migration,

established substitution variables and settings for dynamic time

series, asynchronous processing, editing/validating scripts

. Managed system upgrades and client installations based on users'

requirements

. Prepared Profitability Reports, which detail Unit Cost, Price and

Volume Trends, and Expense Variances over prior periods using

Hyperion Reports/Analyzer.

. Analyzed financial results and prepared trend reports to support

business managers make profitable decisions.

. Prepared quarterly forecasts, annual budget, ad-hoc reporting and

management reporting by working with the business managers.

. Handled performance tuning, weekly back-ups and monthly

consolidations of data and automated monthly/quarterly/annual report

generation

. Developed Analyzer OLAP views and sophisticated what-if scenarios

for the end users

. Ported applications and migrated database from version 6.5 to 7.1

. Involved in system installation, configuration and software upgrades

from Essbase version 6.5 to 7.1.

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

Hyperion Analyzer 6.5, Hyperion Reports 7.0, Windows NT

Kraft Foods, Northfield, IL

Nov 2005 - July 2006

Essbase Developer

Project Summary: Kraft Foods is a producer of leading brands in foods

and beverages segment. The client was served with a common Integrated

Sales Data Warehouse and reporting system (ISR) for the existing

Warehouse, Biscuit, and Pizza business systems based in US, Canada,

Mexico and Puerto Rico locations.

Responsibilities:

. Interacted with Business Analysts and Finance Users to determine,

design process requirements and definitions. This analysis

essentially aided in finalizing the dimensions of cubes.

. Developed Rule files to upload data from the financial system

databases to Essbase cubes and then developed a multi-dimensional

database (MDDB) application using Essbase that stored and maintained

company's financial and marketing data.

. Manipulated database settings and Essbase server settings to improve

performance.

. Developed Calc scripts and ran them to calculate complex values

using Block Storage cubes. Involved in troubleshooting, Performance

tuning and Performance monitoring.

. Created web enabled reports using Hyperion Analyzer; maintained

cubes and took regular backups of databases.

. Involved in improving Web-based budgeting and planning system

enhancing collaborative, event based operational planning processes

for capital expense planning and forecasting.

. Automated the cube building process through MaxL and shell scripts

and created a scheduling mechanism using Control-M.

. Provided Extended Capabilities for Excel Add-in by creating macros

in Excel Spread Sheets and Hyperion Spread sheet objects for

business analysis purposes.

. Used Hyperion Reports and Web Analysis software systems to produce

internal report for external reports for management, shareholders

and analysts.

. Developed Batch files and Rules files to upload data from financial

system's database to Essbase Cube; wrote Report Scripts to develop

Income and expense Statement analysis reports.

. Involved in installation and upgrading of Hyperion Essbase, Essbase

Integration Services.

. Utilized Essbase Integration Services to create OLAP models and meta-

outlines for Essbase OLAP server.

. To further optimize the database, implemented calculation engine,

partitioned cubes; decreased retrieval time by 200%.

Environment: OLAP Data Warehousing using Hyperion Essbase 6.x/7.x, EAS

6.5.1/7.1.3, Excel Spreadsheet Add-In, EIS 6.5, MaxL,UNIX Solaris,

ESSCMD, Hyperion Analyzer 6.x/7.x, Hyperion Reports 7.0, Hyperion

Planning 3.3.1, Oracle 8.1.7, Windows NT Essbase.

Bharat Heavy Electrical, India

Mar 2004 - Oct 2005

Programmer

Responsibilities:

. Designed and Developed application enhancements using VB5 and

Oracle for multiple modules.

. Involved in writing stored procedures and triggers using PL/SQL.

. Hands on experience in Developer 2000.

. Standardized the development and test environments of the database

application.

Environment: VB 5.0, MS SQL Server

Fortis Hospitals, India

June 2002 - Feb 2004

Onsite Coordinator

Responsibilities:

. Customization and implementation of HIRePS Version 2.0 to meet the

overall needs of the

hospital and its management.

. This was the first installation of HIRePS Version 2.0 which is

based on the three tier architecture.

. It involved deploying the application, training the users, helping

in defining the masters

andconfiguring the database and the application server.

. As an Onsite Coordinator lead the implementation of HIS system and

its various modules.

Environment: VB 5.0, MS SQL Server

Citadel Health Limited, India

Apr 1999 - May 2002

Software Engineer

Responsibilities:

. Designed and Developed multiple modules of HIRePS the Hospital

Information system using VB5 and MS SQL Server.

.

Environment: VB 5.0, MS SQL Server

Contact this candidate