Gita

[pic]

Professional Summary

. Over *+ years combined experience in general application development.

Efficient, dynamic and result oriented experience in IT/Design, Decision

support systems, Business Intelligence, Client/Server Applications.

. Experience in working with a range of Hyperion products including

Essbase, Integration Services, Planning, Reports, Analyzer, and Excel Add-

In, in both Windows and UNIX environments.

. 5+ years experience in Finance modules and Interactive Reporting.

. Extensive expertise in Hyperion Essbase system 11.X/9.X/7.X/6.X

. Skilled in scheduling jobs in ODI, generating scenarios, and running

automated processes.

. Hands on experience on OBIEE 11.1.1.7. and 11.1.1.7.1

. Profound expertise in Workforce Planning Applications.

. Skilled expertise in Application/Production support area.

. Profound knowledge on Oracle GL, SQL Queries and reporting tools.

. Hands on experience in FDM integrations with HFM.

. Skilled expertise in installations, configurations and upgrade procedures

in the Client/Server environment.

. Worked extensively in architecture design of Essbase Cubes using

Block/Aggregate storage & Partitioning.

. Expert in building the hierarchies from DRM, Import/export process,

Blenders, various metadata validation processes.

. Skilled expertise in Oracle E- Business Suite - Essbase, Planning and HFM

- prominently hands on experience in CapEx applications.

. Skilled knowledge of ESSCMD, MaxL, MDX, Calc scripts, and Report scripts

under Windows and UNIX environments.

. Excellent communication skills to interact with business users and gather

the requirements and convert into technical solutions. (Techno-

functional).

. Experience in creating the Properties, Nodes, filters, writing automators

in different versions. Member and Hierarchy ordering in DRM, setting up

different properties to members in export process etc.

. Worked with cross functional departments and Business analysts to gather

exact Financial Data Quality Management (FDQM)

. Metadata sourcing for DRM from various kinds of different data sources

like from flat file, Databases.

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

. Exposure in automating the cube loads, dimension build, calculation

scripts using Batch files in UNIX and Windows environment.

. Expertise in Hyperion Planning Applications, Workforce, Business Rules,

Macros, and the Web Forms. Worked with the Financial, Forecast and

Budgeting Applications.

. Skilled in developing and populating planning applications using Hyperion

System 9 Planning, Hyperion Application Link, MS Access and Hyperion

System 9 Planning Desktop.

. Involved in developing Web forms using Hyperion planning web client for

the users to input forecast, budget, actual, accounting changes and other

variance explanations data.

. Knowledge of general warehousing theories and OLAP reporting. Familiar

with all aspects of OLAP technology and development of multi-dimensional

data cubes.

. Proficiency in Database Administration (DBA) such as enhancing security,

database tuning, backup and recovery on different servers and platforms,

and operating systems.

. Skilled knowledge on creating Cash Flow Statements using the balance

sheet accounts.

. Strong SQL skills, RDBMS development knowledge and understanding of

relational data marts in ORACLE and MS SQL SERVER and knowledge of

Essbase server upgrades over NT/UNIX platforms.

. Excellent communication, documentation, interpersonal, training and

presentation skills.

EDUCATION : Bachelor of Technology in Electronics and Communications

Engineering

Technical Skills

OLAP Tools Hyperion Essbase System 9.x/11.x, Hyperion Essbase 7.x/6.x,

Hyperion Essbase Integration Services, Essbase

Administrative Services, Hyperion Planning, Shared

services, FDQM, ODI 11g, DRM.

Reporting Tools System 9 BI+ (Financial Reporting, Web analysis) Hyperion

Reports 2.x/7.x, Hyperion Spreadsheet Services, Excel

Add In, Executive viewer, Smart View, Essbase studio,

Peoplesoft PeopleTools, Hyperion IR

Databases Oracle 8i/9i,10g,11g,12c, SQL Server 6.5/7.0, MS Access,

Teradata

Oracle tools SQL*Loader, SQL*Plus, Toad

Operating Systems Windows NT/2000/XP/98/95, UNIX (Solaris, HP,

AIX)

Languages C, C++, SQL, Java, Perl, ESSCMD, MaxL, SQL, PL/SQL

Scripting.

Office Tools MS Word, MS Excel, MS PowerPoint, MS Project, MS Visio.

PROFESSIONAL EXPERIENCE

Boston Scientific Corporation, Marlborough,

MA May 2014 - Till

Date

Hyperion Planning Developer

BSC is a leading innovator of medical solutions that improve patient health

all over the world. Their products and technologies are used to diagnose

or treat a wide range of medical conditions. Major responsibilities include

maintaining the Hyperion Essbase, development and maintenance of capital

cubes, reporting and expense labor and working with the development and

financial teams. These cubes provide Balance Sheets, Net Income

statements, and other financial figures and reports for various business

segments of the organization. Developing calculation scripts, load rules,

assigning access to users, security modules, and analyzing existing

transactional databases depending on the accounting business logic are some

the various challenges in this project.

Role & Responsibilities:

. Involved in ticketing system in support of the Production issues raised

and the problem management process.

. Worked with business analysts for gathering requirements, functional

specifications, testing strategies and developing a project plan.

. Assisted in the integration of Hyperion Systems with SAP R3.

. Extensively worked on CapEx applications, including Reporting cubes.

. Generated daily data back-ups and migrated files from Prod to Test via

UNIX.

. Executed the entire Capital Management System monthly process, to adjust

the missing depreciations of approved projects for various cost centers.

. Assisted end-users with Web Forms, Security access, and production

issues.

. Provisioned various user groups via shared services, and provided

assistance in planning issues.

. Extensively worked on the migration of objects between environments (DEV,

TEST, PROD) using LCM, or manually for the earlier versions.

. Modified the ODI processes in DEV to enable a full 1 allocation for the

EXLB projects, by changing the SQL queries, and enabling extra decimal

points. Migrated it to PROD to schedule it as a nightly process.

. Moved ODI jobs from one server to another, replicating the physical

schemas.

. Updated the outlines of Reporting cube and PPMS cubes, to add extra

dimensions and regenerate the automated processes.

. Involved in Metadata Loading using Outline Load Utility and Actual data

load - using MaxL scripts.

. Extensively worked with the ESSBASE database settings, caches and the

outline optimization, as well as tuning of the ESSBASE cubes for the

retrieval and calculation performances.

. Worked with Essbase DBA for security management.

. Assisted in the integration of Hyperion system 11 with EBS - R12

Environment: Hyperion Essbase 11.1.1.2, Oracle EPM system 11, Microsoft

Excel 2010, Windows NT 4.0, ESSCMD, MaxL, Excel Add-In, SQL Developer,

Windows Server 2008 R2 . Web Logic, ODI 11g, Hyperion Financial Management

- System 9.

Riverbed, San Francisco, California Nov

2013 - Apr 2014

Hyperion Planning/HFM Developer

Role and Responsibilities:

. Involved in implementation of decided budgeting process involving

planning units, starting review process, and entity hierarchy and

workflow notifications.

. Loaded the Metadata Using Outline Load Utility. Expert in building the

hierarchies from MDM / DRM, Import/export process, Blenders, various

metadata validation processes.

. Created and managed data forms, involved in implementation of decided

budgeting process involving planning units, starting review process, and

entity hierarchy and workflow notifications.

. Utilized validation Rule in Data form to Validate Balance Sheet.

. Created Menus and attached to Data forms where users can open excel and

Input data into excel and submit Data using VBA. Automated the Process to

save and load data from this excel into the Planning application with

wrapper that checks the update every 2 minutes.

. Optimized the Designs of Data forms.

. Created Business Rule with Run time prompts for Web Forms using Global

variables.

. Involved in Data Mapping and Validation for Actuals.

. Created Task Lists and User Instructions for the easy Workflow.

. Setup User security according to business requirements, restricting the

views by dimensions, Entities. . Wrote MAXL scripts to automate these

cubes in Development, Testing and Production environments.

. Designed planning applications and involved in the building of EPMA

planning application.

. Extensive usage of substitution variables and setting appropriate

values in them using MAXL/EAS.

. Created/Modified Calculation Script for Existing Application in

Production.

. Responsible for all the scripts migrations and their validations in all

the environments - HAL to ODI: Extraction of data and integrating into EPM

suite.

Environment: Essbase 11.1.2.2, Hyperion Shared services, Essbase

Integration Services, Hyperion Workspace 11.1.2.2, Windows server 93, MS

Excel, Oracle 11g,DRM,Peoplesoft Application Designer.

Verizon, Richardson, TX

Nov 2012 - Oct 2013

Essbase/Planning Developer

Project Summary: Verizon is a major cellular company in the US. It uses

Hyperion to manage its business. The project is to design and maintain

corporate budgeting & forecasting application. The high level corporate

forecasting was done on this cube. Designed and maintained two cubes, one

containing detailed level actuals from oracle and the other containing high

level actual and the forecasted values from the users. Thus two cubes were

portioned and had a user base of 50 users.

Role and Responsibilities:

. Analyzed user requirements and involved in the process of finalizing

dimensions for cubes.

. Provided integration of various data like derived, historical, and

projected data.

. Developed Rules files in order to upload data from financial system's

database to Essbase cube.

. Implemented calculation engine for computing derived data.

. Loaded, reconciled and consolidated key financial data with Hyperion

using FDQM(Financial Data Quality Manager) and HFM consolidation.

. Involved in the preparation of detail Unit Cost, Price and Volume Trends,

Expense Variances and Profitability Reports.

. Implemented an automated Cash Flow statement in HFM.

. Involved in Data Loads and Calc Scripts optimization for Essbase and

Planning.

. Hands on experience with integrations between FDM and EPM planning.

. Automated the Cube building through MaxL & shell scripts and scheduled

them though Control-M

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

Integration Services.

. Loaded data using Essbase Integration Services (EIS).

. Implemented star schema and used EIS to interface with the company's

existing Oracle 10g data warehouse.

. Created various filters as per user requirement in EIS.

. Involved in the installations and configurations of ODI 11.1.1.5

. Designed and developed numerous Essbase applications with excellent

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

. Involved in requirements definition, functional specifications,

documentations design and testing strategies.

. Involved in installation and up-gradation of Hyperion Essbase, Essbase

Integration Services.

. Involved in data-access security and user management.

. Developed Excel Templates for user interface in Essbase database.

. Involved in regular maintenance of the Essbase Server like cube backup's,

security file back up and file system backup.

. Involved in system installation, configuration and software upgrades from

Essbase.

. Prepared ad-hoc reporting and management reporting using Hyperion

Interactive Reports, quarterly forecasts, annual budget, by working with

the business managers.

. Configured and Designed Reports within Financial Reports.

Environment: Hyperion Reporting, Essbase Excel Add-in, Hyperion system

11.1.2.2, Windows server 93, Oracle 11g, Essbase excel add in 11.1.2.2,

Smart view 11.1.2.2, Workspace 11.1.1.4, Workspace 11.1.2.3, Ms excel, HFM,

Oracle E-Business Suite.

General Electric, Detroit, Michigan

Jul 2012 - Oct 2012

Hyperion Essbase Developer

Role and Responsibilities:

. Assisted senior DBA in installations and upgrades of various Oracle

products.

. Created SQL scripts for creating tables, views, and stored procedures,

loading data into the tables.

. Configured test and development servers with the help of system

administrator.

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

environments.

. Installed and configured Hyperion Planning - System 11 on Unix based AIX

. Maintained two previous Essbase cubes.

. Maintained discrete data store within one physical database using ERP

system

. Reduced budgeting time and ensured accuracy using Hyperion Planning

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

. Designed and developed calc scripts.

. Used ESSCMD extensively to run 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.

Environment: Windows server 93, Oracle 11g, Essbase excel add in 11.1.2.2,

Smart view, Workspace 11.1.1.4, Workspace 11.1.2.3, Ms excel, Hyperion

Planning Applications, Workforce Planning.

State Street Corporation, Boston,

MA Sep

2011 -Jun 2012

Hyperion Database Deveoper

State Street, a world leader in financial services, provides a full range

of products and services for large pools of investment assets. Founded as a

bank in 1792 in Boston, Massachusetts, State Street today has $9.6 trillion

in assets under custody and $1.4 trillion in assets under management. Main

responsibilities include maintaining the Hyperion Essbase, development and

maintenance of various cubes, and working with the development and

financial teams. The cubes provide Balance Sheet Statements, Net Income

statements, Earning Statements, and other financial figures and reports for

various business segments of the organization. Developing calculation

scripts, load rules, analyzing existing transactional databases depending

on the accounting business logic are some the various challenges in this

project.

Role & Responsibilities:

. Involved in total SDLC (Software Development Life Cycle) with Essbase

Cube development.

. Worked with business analysts for gathering requirements, functional

specifications, testing strategies and developing a project plan.

. Developed Batch Scripts and Rules files to dynamically upload dimensions

and data from Legacy System to Essbase Cubs. Also developed Rule files

for multi-dimensional databases.

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

Integration Services.

. Involved in Performance Tuning to minimize data load time. Analyzed all

dimensions and members in the Essbase outline.

. Implemented calculation engine that includes robust mathematical

functions for computing derived data.

. Extensively used Essbase Integration Services (EIS) for loading data.

. Implemented star schema and used EIS to interface with the company's

existing Oracle 10gig data warehouse.

. Created various filters as per user requirement in EIS.

. Assisted in the installing, implementation and configuration of ODI.

. Worked on the Data loads from Oracle Finance modules- Oracle GL

. Worked 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 the Dense/Sparse settings, Cache settings,

Outline formulae and Calc scripts.

. Worked with Essbase DBA for security management.

. Developed Excel Templates for user interface in Essbase database.

Created new batch files and scheduled these batch files for complete

automation process for nights and weekends calculations and backups.

Environment: Hyperion Essbase 11.1.1.2, Hyperion Reports7.0, Microsoft

Excel 2007, Oracle 10g, Windows NT 4.0, ESSCMD, MaxL, Excel Add-In, SQL

Developer, Windows Server 2008 R2 . Web Logic, ODI, Hyperion Financial

Management.

British Petroleum, Tulsa, OK

Dec 2010 - Aug 2011

Essbase Developer

Project Summary:

British petroleum is a major fuel supplier in US and UK .The project is to

build a multidimensional cube and validating the data. This project is

mainly for optimization and performance tuning of different cubes.

Profitability and expenses are compared and calculated depending on sale

made during various Regions, cities, publications. Sales per quarter,

average budget per quarter was determined. Overheads including salary of

employees, damaged goods, total costs used were taken into account for

calculating the yield per year/ quarter/ month/day.

Role and Responsibilities:

. Design and maintenance of cube & periodic reports related to two cubes.

. 24/7 support for the existing Essbase applications, application

maintenance - Monthly End Roll over & Reporting maintenance.

. Extensively worked with Hyperion Reports and Hyperion Analyzer, Developed

several reports for Sales and Marketing Performance Packages which

included Operating Expense Analysis, Allocation Analysis separately and

as per the user requirements.

. Loaded, reconciled, and consolidated financial data using FDQM.

. Assisted in the configuration of ODI and migrated the settings from the

previous release.

. Automated daily/monthly/annual PDF/Snapshot book generation, developed

Excel Templates for user interface in Essbase database.

. Provided technical assistance and support to end-users and was involved

in developing documentation required.

Environment: Hyperion Essbase 9.3.3, Hyperion Reports 6i, Essbase

Spreadsheet Add-in, UNIX (HP), SQL Server, Windows NT.

Nationwide Insurance, NY

Feb 2010 - Nov 2010

Hyperion Developer

Project Summary:

Nationwide Insurance is one of the leading players in the BFI. It has

chosen the Hyperion products for the financial consolidation, budgeting,

forecasting and reporting needs. The project is to build financial cubes

for the management of their businesses, projects and lines of businesses to

the decision makers to analyze the business trends and budget analysis. the

built cubes are then automated and the reports are designed in the Hyperion

reports and with excel add-in.

Role and Responsibilities:

. Responsible for end-to-end implementation activities such as design,

development, testing and user training.

. Developed web forms using Hyperion Planning web client for the users to

input Forecast and Plan numbers and also the statistical accounts like

rates.

. Developed the business rules to use runtime prompts functionality for end

users.

. Experience in working through test cases for Essbase, Planning

applications. Experience in doing unit testing, performance testing.

. Experience with HP Quality Center for defect tracing for different

applications.

. Expert in building the hierarchies in Parent child and Generation format

from MDM, Import/export process, Blenders, various metadata validation

processes.

. Automated and scheduled the planning refresh. Worked on Hyperion system 9

BI+ to create various BSO applications for budgeting planning and

forecasting.

. Created dashboards with Interactive reporting studio, Monthly and

Quarterly Reports are created using Web Analysis.

. Created and modified load rules, dimension building and Business Rules.

. Created and maintained Essbase financial application objects including

outline, Calc scripts, data load rules and user security objects.

. Created ASO outline from BSO cube. Examined all standard and attribute

dimensions and members in the Essbase outline editor for optimization and

performance using Analytic Administration Service.

. Used MAXL and ESSCMD scripts to create batch files for database

optimization.

. Worked on quarterly/annually forecasts and budget reports using Excel Add-

In utility. Optimized performance of Essbase cubes by restructuring the

database outline.

Environment: Essbase, SQL, PL/SQL, Excel Spreadsheet Add-in, SQL* Loader

and Windows NT

Wellspun Investments and Commercials Ltd.,, India

May 2008 - Jan 2010

Hyperion Developer

Project Summary:

Welspun Investments is a financial services provider company based in

India, which is a part of the US$2.9 Billion Welspun Group. The project is

to build the M-dimensional cubes and then data validation. Involved in the

development and working of those cubes for the net income statements and

earning statements and various business reports. Essbase Integration

Services was used to load and update the Essbase Cubes.

Role and Responsibilities:

. Developed the project plan for the implementation that identifies the

schedule, task, milestones and requirement.

. Migrated Essbase applications from version 7.1.6 to 9.3.1.

. Was involved in the installation of Hyperion Essbase 9.3.1

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

dimension building, attribute dimension building and data loading in

Essbase.

. Worked on Essbase Integration Services.

. Involved in performing DBA activities like create users, password

setting, group and filters.

. Involved in making the Essbase backups and restores of Essbase

application.

. Extensive usage of substitution variables and setting appropriate values

in them.

. Developed transparent partitioning to optimize the calc time on the cube.

Environment: Hyperion Essbase 9.3.1, Microsoft Excel 2003, Oracle 9i, SQL,

PL/SQL, SQL Loader, MS SQL Server 7.0, Windows NT 4.0, ASP.NET & C#, IIS

5.0, SQL Server, .NET Framework 3.0.

CMC Limited, Hyderabad, India

June 2007 -April 2008

Oracle Developer

Project Summary:

Involved in the development and maintained Financial Application System.

The project is designed to support and improve the needs of the day-to-day

business. All the transactions are entered daily. Finally Financial reports

are developed such as Balance sheet, profit and loss statement, accounts

receivables and payables, trail balance.

Role and Responsibilities:

. Involved in loading legacy data into oracle tables using SQL * Loader.

. Forms 6.0 were used to design user-friendly interactive screens.

. Involved in writing stored procedures, functions and database triggers.

. Reports were generated using report builder 6i.

Environment: Oracle 9.2.0.7, SQL, PL/SQL, Forms 6.0, Reports 6i, SQL*

Loader and Windows NT

References: Gladly available upon Request

Contact this candidate