Developer Data

Sampath Shetty

Hyperion / BI Consultant

Summary of Professional Experience:

. Over 4 Years of experience in IT Industry Service delivery, Project

Implementation, Analysis and integration and implementation of various

applications in Client/Server environment using Hyperion suite of tools.

. 3 years of functional experience in the development, design, analysis and

Implementation of various applications using Hyperion Essbase, Essbase

Integration Services, Hyperion Analyzer, Hyperion Reports, Hyperion

Planning, and Essbase Spreadsheet Add-In on Windows server family.

. Knowledgeable in JavaScript, SQL, Stored Procedures, Triggers, Cursors,

PL/SQL, VBA.

. Motivated team player, capable of working independently, excellent

communication, analytical, and strong inter-personal skills.

Technical Competencies:

Hyperion System 11.1/9.3: Essbase Administrative Services (EAS),

Hyperion Financial Management (HFM), Hyperion Analytic

Server, Hyperion Financial Data Quality Management

(FDQM), Analytic Administrative Services (AAS), Hyperion

Planning, Hyperion Workforce Planning, Hyperion Master

Data Management (MDM), Hyperion Business Rules, Hyperion

Application Link, Hyperion Interactive Reporting,

Hyperion Web Analysis, Hyperion Smartview.

Business Intelligence: Hyperion Essbase 11.x/9.x/7.x, HAL 9.x,

Hyperion Planning 3.5, Hyperion Analyzer 9.2, Hyperion

Reports 9.2 and Excel Spreadsheet Add-in.

Databases: Oracle 9i/8i/8.0, DB2, MS SQL Server 2000/7.0/7.0, MS Access

7.0/97/2000

Operating Systems: Windows, DOS, UNIX.

Client Applications: MS Word, Excel, Outlook, PowerPoint, Project, Visio,

FrontPage.

Languages: C, C++, Java, VB, JavaScript, SQL, PL/SQL, UNIX Shell

Scripting.

Education:

Master's Degree,New Jersey Institute of Technology, NJ, USA

Bachelor of Science, Electronics & Communication Engineering, India

Professional Experience:

Client: First American Corporation, Santa Ana, CA

Jul'09- Nov'09

Role: Sr. Hyperion Developer

Hyperion Administrator:

> Gather requirements and understand the excel modules currently in use.

> Created Users / Groups in Hyperion Shared Services and assigned

appropriate access.

> Implemented application security process, created users/groups, security

profiles and application access to different groups using filters.

> Exported / Imported Hyperion Reports in Hyperion Workspace for backup and

migration.

> Migrated and backed up Planning web forms from one application to another

using FormDefUtil.cmd.

> Educated Users on Setting Planning Preferences and use of User Variables.

> Migrated application using the Hyperion LCM Process.

> Managed Web Forms and Reports using Folder Structure.

> Developed Microsoft Excel Template and used built in Essbase Data Load

feature to load data.

Hyperion Developer:

> Developed and maintained Web Forms based on User Requirements.

> Created and assigned User Variables to Web Forms.

> Developed Business Rules to Support the Web forms.

> Created Substitution Variables for complex Business Rules and Web Form

Definitions.

> Developed and Maintained Financial Reports using Oracle Hyperion

Financial Reporting Studio.

> Created Complex Member Formulas to support Reports.

> Created Books in Workspace to categorize Reports.

> Supported application testing.

Client: ADP, Chicago

April'09- May'09

Role: Sr. Hyperion Developer

Hyperion Administrator:

> Frequent Interaction with off-site Business Users to gather requirements

and understand the excel modules currently in use.

> Managed Outlines and Data Loads using Oracle EPMA.

> Migrated web forms from one server to another and from one application to

another using HP FormDefUitl.

> Improves Application performance by configuring Outlines and Cache

Settings.

> Provided technical assistance and support to end users and was involved

in developing documentation.

> Educated Business Users about the data movements in Business Rules and

preference settings for Data Forms

Hyperion Developer:

> Involved in Outline modifications and assigning descriptive alias name to

members.

> Developed Web forms in tune with the various Requirements.

> Created User Variables to make the web forms more user friendly and

flexible.

> Trained Users in assigning User Variables.

> Developed Complex Business Rules supporting the Web Forms.

Client: Deloitte, Mississauga

May'08- Mar'09

Role: Sr. Hyperion Developer

Hyperion Administrator:

> Interviewed Business users during the implementation phase of the

applications for requirement gathering and analyzing

> Defined Technical Specifications and discussed Testing Strategies.

> Defined Cache and Lockblock Settings in the essbase config file.

> Initiated change in the hierarchy of the application increasing its

Performance.

> Participated in the application testing, while monitoring the system

performance, thereby reporting any anomalies in the application design.

> Configured Essbase objects like Outline, Rules File, Calc Scripts, Caches

to improve application performance.

> Migrated data forms using HP FormDefUitl.

> Created Folders and sub folders for efficient management of Data Forms.

> Educated Business Users about the data movements in Business Rules and

preference settings for Data Forms

Hyperion Developer:

> Developed Complex Business Rules in line with the technical documents to

meet the business user requirements.

> Used @XREF functions to transfer data from one database to another.

> Optimized existing Business Rules to increase its performance by

replacing @ALLOCATE and @SUMRANGE functions with manual calculations.

> Used Calculation Commands like CREATENONMISSINGBLK, NOTICE,

EMPTYMEMBERSETS, AGGMISSG and so on for increased Performance.

> Developed Global and local Variables as Run Time Prompts enabling users

to select members while launching the Business Rules.

> Created and managed Report Templates and Requirement Types using Excel

Add-in.

> Created and maintained Data Forms including composite data forms and

applied menus and lists for quicker response to user requirements.

> Created User Variables to increase the functionality of the Data Forms.

> Used Export and Import feature of the Data Forms to quickly develop

multiple Data Forms of the same type.

> Tuned Data Form format settings and evaluation order for increased

functionality.

> Developed complex Control Reports for comparing Budget Extracts.

> Provided Production Support in tracking, analyzing and fixing defects and

supported ongoing migration process.

> Responsible for analyzing business requirements and developing queries

and reports using Hyperion System 9 - Interactive Reporting (BRIO) tool

to provide web-enables data analysis solution.

> Developed Executive Dash Boards to accomplish launching various reports.

Client: AIG, NYC

Jul 07 - Mar 08

Role: Sr. Hyperion Developer

Hyperion Administrator:

> Installed and configured Hyperion Shared Services 9.2.0.2 to Hyperion

License Server.

> Installed and Configured Hyperion Analytic Server 9.2.02, Hyperion

Analytic Administrative Services9.2.0.2, Hyperion Planning 9.2.0.2.

> Created Users in LDAP and Groups in HSS and assigned them privileges for

different Hyperion Applications.

> Externalize Essbase user authentication process to Hyperion Shared

Services (HSS).

> Configured Essbase objects like Outline, Rules File, Calc Scripts,

Caches, etc to improve application performance.

> Migrated HP application from dev to prod and vice versa.

> Migrated web forms from one server to another and from one application to

another using HP FormDefUtil.cmd

Hyperion Developer:

> Developed Versions, System Categories and Property Categories for

implementation of three subscribing systems in Master Data Management

(MDM 9.3).

> Created three node type glyphs, one each for HFM, HP, and Essbase.

> Created different node types and numerous properties (Defined, Derived,

RWDerived, and Lookup) for dimension building in HFM, HP, and Essbase.

> Created property queries to export stored and alternate dimension

hierarchies.

> Developed HAL integrations to build dimensions in Hyperion Planning (HP).

> Developed data forms/web forms for user data input.

> Developed Hyperion Business Rules (HBR) and Sequences to calculate

different dimension members in HP.

> Developed Run-Time prompt variables for HBR to help users choose their

members.

> Used Essbase Spreadsheet Add-in and Hyperion SmartView extensively to

test Business Rules.

> Developed numerous dashboards for higher management team using Hyperion

Web Analysis

Client: Dell, Mumbai

Aug 05 - Apr 06

Role: Technical Support Engineer

Responsibilities:

> Provided highest level Technical Support for troubleshooting Hardware

related Issues including vital data entry, dispatch/ replacement of

damaged parts, Warranty checks and other departmental works.

> Guide Customer troubleshooting efforts to identify products having

Customer Issues and issue service calls in accordance with guidelines.

> Logged and sufficiently document all contacts with customers in

designated tools

Client: AirTel Communications, Managalore, India

Dec 04 -Jun 05

Role: Business Analyst / Application Developer

Responsibilities:

> Involved in design, development, administration and maintenance of the

application.

> Participated in gathering user requirements, developing functional and

non-functional requirements and technical specifications.

> Developed use cases/diagrams, conceptual model, behavior diagrams

(sequence, collaboration, state chart, Activity), using MS Visio.

> Responsible for the delivery of Business Requirements Documents (BRD)

within project timelines.

> Created and Configured Workflows, Worklets, and Sessions to transport the

data to target warehouse Oracle tables using Informatica Workflow

Manager.

> Involved in setting up and configuring the wireless university tower.

References: Provided upon request or please visit my Linkedin Profile:

http://www.linkedin.com/pub/sam-shetty/16/0/48

Contact this candidate