Sql Server Data

Experience in Systems Implementation and Integration, Requirements

Gathering, Data Conversion and Extraction, Business Process

Modeling, Data Structure and Relationship Diagrams, Database Design,

Hyperion (Brio Query) Intelligence Tools.

Expertise in reporting using Interactive Reporting, with Hyperion

Intelligence Designer/Explorer. Experience in Hyperion Performance

Suite Administration, Brio Server Administration (On-Demand and

Broadcast Servers),

Experience in Essbase, creating database outlines, loading data,

rules files,calculation scripts, Report Scripts, Administrative

Server Administration, Shared Services Administration and Workspace.

Experience in Hyperion Planning, Data Forms, Business Rules, Task

Lists. Data Integration Management.

Experience in using EIS, DIM and ODI in loading dimension member in

Planning and Essbase Applications.

Experience in creating user-friendly reports using Interactive

Reporting, SmartView and Excel Add-in client.

Scripting Experience: JavaScript, MAXL, ESSCMD, MDX

GE, Albany, NY (June

2009 - Nov 2009)

Designation: Hyperion Consultant

Responsibilities on Hyperion:

. Interacted with the clients to gather requirements, documented and

assisted in proposing the design architecture for the Essbase/

Planning application.

. Created dummy Essbase application for client to better understand the

hierarchical structure, rollups and member formulas.

. Created files for metadata and data loading for the ETL team.

. Successfully created Essbase and Planning applications as per client

requirements.

. Wrote complex member formulas, calculations scripts and business

rules.

. Performed data validation.

. Installed and Configured DIM for planning metadata load.

. Installed and Configured ODI for Essbase/Planning metadata load.

. Loaded hierarchies from flat files and database tables into Planning

and Essbase applications using ODI.

. Designed the migration strategy for existing Brio 6.2 reports,

scheduled jobs and parameters, user permissions.

. Successfully migrated from brio 6.2 to Hyperion IR 11.3

. Created usage tracking reports for IR and planning.

. Documented and trained users for Interactive Reporting and Workspace

usage.

Environment/Tools used:

Hyperion System 11/9, Essbase 11/9, Hyperion IR 9.3, Brio 6.2, Hyperion

Unicode migration utility, ODI 10.1.3, Informatica Power Center 8.1.1.

Brown Brothers Harriman (Mar 2005 -

Dec 2008)

Designation: Hyperion Technical Lead

Responsibilities on Hyperion Intelligence:

. Interfacing with clients, project managers, team leads for gathering

requirements, developing, and testing Brio Reports.

. Communicated with business analysts or end users in defining report

requirements, documented end users' requirements, created report

prototypes to finalize user requirements.

. Created queries and developed reports using Hyperion Interactive

Reporting. Developed complex Dashboards for data analysis.

. Designed series of MS Excel reports by extensively using JOOLE concept

in Hyperion Interactive Reporting.

. Developed an application in which several brio documents were merged

into one for one time publish on Hyperion Portal and giving client the

power of interacting between several reports without opening different

documents on the portal.

. Extensively worked with all the components of Hyperion interactive

reporting, dashboard, reports, pivots and charts.

. Published BQY jobs on Hyperion portal. Modified existing custom

reports to schedule them on the Hyperion portal and ftp the output in

csv, excel or pdf format as per requirement.

Environment/Tools used:

Hyperion Intelligence Designer/Explorer 8.3/8.5, Hyperion Insight 8.3,

Oracle 9i/10g, SQL Server 2000/2005

Wells Fargo (Feb 2004 - Jan

2005)

Designation: Business Intelligence Consultant

Responsibilities on BRIO/Hyperion Intelligence:

. Provided functional and technical support to the finance community in

utilizing the Brio reporting tool.

. Worked with users to obtain requirements and design, build and deploy

new EIS Brio reports.

. Utilized comprehensive report techniques such as dashboard/EIS (in

Java scripts), pivot, char, table, detail report, in building user-

friendly professional financial reports; created dynamic query report

system for end users to select report limits and build their own

reports in Hyperion Explorer; created parent-child reports and enabled

passing parameters between them based on end user selection.

. Created both adhoc and scheduled bqys for dynamically exporting pdf

files onto UNIIX server.

. Enhanced/modified existing Brio reports as per changes in reporting

requirements.

. Administered the Brio production and development servers as the backup

server admin.

. Installed Hyperion Performance Suite 8.3.2 and evaluated the new

version.

. Published and administered Brio documents to the portal via the

OnDemand server, scheduled jobs to be run on the Broadcast server.

Migrated 6.6 reports to 8.3.2 and ensured existing customizations work

in 8.3.2.

. Administered Brio 6 BCS and ODS servers. Created Quality report for

senior management.

. Developed naming standards for Brio files. Provided helpdesk support

for Brio user assistance.

Environment/Tools used:

Brio 6.6.4/Hyperion 8.3.2, Broad Cast Server, On Demand Server, JavaScript

University of Minnesota (Dec 2001 to

Jan 2004)

Designation: Hyperion Developer

Responsibilities on BRIO:

. Reporting to the Development Manager in the data warehouse team,

provide Brio expertise and perform data warehouse reports development

activities.

. Responsible for developing Brio reports, creating technical

specifications, testing and QA of reports and support.

. Designed automated procedures for daily generation scheduled on Brio

Intelligence Server and distribution via email.

. Maintained over 100 reports and updated the reports to reflect

database changes.

. Accessed data with SQL on Oracle 8i and MS SQL Server 6.5 for Brio

Enterprise tools.

. Administrated reports, users and groups on the Broadcast and On Demand

servers and provided Brio training to report users.

. Set up ODBC and OCE files for Brio Enterprise.

Environment/Tools used:

Brio 6.5, Oracle 8i.

. Master of Science in Electrical Engineering

. Bachelor of Science in Electronics Engineering

. Oracle Certified Hyperion Essbase Analytics 9.3 Developer.

.

TECHNICAL SUMMARY

PROFESSIONAL EXPERIENCE

EDUCATION

Contact this candidate