Sign in

Hyperion Essbase developer

Piedmont, California, 94611, United States
March 12, 2011

Contact this candidate




Data Warehouse professional with 12 years of IT experience in advanced analytical software applications, with Business Analysis, Requirements, Development, and Testing of web-client/server technology. Expertise in optimizing Essbase data loads, Essbase aggregations (calculations) and Essbase data extractions. Skills include developing data input and retrieval spreadsheets.


OLAP Hyperion Essbase, Oracle Essbase Release 11

ETL Essbase Studio, Informatica

Tools Hyperion Reports, HAL, Hyperion Analyzer,

Reporting Tools Hyperion Reports, Hyperion Web Analysis, Business Objects,

Oracle/Hyperion Planning Data Forms

Languages Perl, VB, VBA, Java, PL/SQL, MS DOS, Javescript

Operating Systems Windows 2003 & 2008 Server, Ubuntu (Linux), Sun Solaris

Databases Oracle Release 11, MS SQL Server 2000, MS Access, MySQL

Markup Languages HTML 4.0, XML



Clorox, through HP BI Practice October 2010 – February 2011

Oracle Essbase Developer

Project assignment at Clorox in Oakland, CA.

Essbase 9.3.0 Windows in VMWare Enviroment.

• Analyzed and designed optimized Essbase model to handle 50 minute updates, in just 10 minutes

• Developed and implemented load routine, using ftp, MS DOS, load rules, and calc scripts

• Documented low level design and procedure for QA review and approval

Paypal April 2010 – October 2010

Oracle Essbase Developer

Project assignment at Paypal in San Jose, CA

Essbase 9.3.1 UNIX Sun Solaris 10 environment.

• Configured SSL Hyperion Products and user directory connection to MSAD.

• Support migration for Essbase 9.3.1 and other Hyperion System 9 components on Sun Solaris 10

Cooper Tires

Oracle Essbase Infrastructure Architect December 2009- June 2010

Remote project assignment at Cooper Tires in Findlay, OH

Essbase 6.5.6 and 9.5 (release 11) on Windows Server 2003 64 bit OS.

• Architected Oracle Essbase Release 11 solution for new Windows server environment

• Installed and Configured Oracle/Hyperion Foundation Shared Services and Workspace on 64 bit server

• Installed and Configured Essbase and Financial Reporting on 64 bit server (EM64T)

Wells Fargo, Inc. September – December 2009

Oracle Essbase Clarity Administrator

Project assignment at Wells Fargo in San Francisco, CA

Hyperion Essbase 9.3.1 (64-bit) on UNIX Sun Solaris 64 bit OS.

• Augmented Essbase with Perl shell scripts

• Support for Essbase 9.3.1 and other Hyperion System 9 components on Sun Solaris 10

• Support for Clarity Systems 5 and spreadsheets templates

Local Insight Media Services

Oracle Hyperion Planning Developer January-March 2009

Remote project assignment at Local Insight Media Services in Denver, CO

Oracle Essbase Rel. 11(version 9.5 64-bit) on Windows Server 2003 64 bit OS.

• Augmented Essbase with Perl shell scripts, shifting of data values by multiple time dimensions

• Implemented Oracle Essbase Planning environment on release 11

Blue Cross Blue Shield

Hyperion Planning Developer May 2008

Remote project completed at Blue Cross Blue Shield of Florida

Hyperion Essbase 9.3.1 (64-bit) and BPMA (32-bit) on Windows Server 2003 (64-bit and 32-bit) OS.

• Resolved open issues during implementation of BPMA Planning (System9 BI+)

• Implemented Essbase Planning environment on Hyperion System 9 BI+

CELERA, Alameda, CA 2006 - 2009

Sr. Business Systems Analyst

Enhanced Clarity/Essbase system models/templates for budgeting and forecasting. Established feeds and loads linking SAP source systems.

• Administered Essbase and Oracle (repository) systems

• Designed and developed FTE hierarchy for reporting in project management and accounting Essbase applications

• Designed and developed validation routines for loading Actual values in Essbase

• Developed custom batch reporting via Email from Essbase to end-user community

• Designed and developed project management allocation routines in Essbase

• Designed and developed Spreadsheet application offering data input, for 100 users to enter project time

• Migrated Essbase version 6.5.6 to Release 11 and Clarity Systems version 5 to 6

Environment: Clarity Systems, Hyperion Essbase 6.5, Essbase 7.1, and Oracle Release 11, MYSQL, Oracle, MS-Excel, IIS, Tomcat, Windows 2000 Enterprise and Windows 2003 Server Editions

WILLIAMS-SONOMA, San Francisco, CA 2000 - 2006

Decision Support Specialist

Reviewed and enhanced Essbase Applications to analyze merchandise returns for mail order and internet business. Supported and enhanced Essbase Applications for budgeting/forecasting and reporting financials to internal/external company sources.

• Analyzed system reporting requirements for end users

• Collected and analyzed management reporting requirements and developed input and reporting cubes with data flow from source systems

• Designed and implemented change requirements for reporting

• Developed custom batches for the dimension building and data loading using ESSCMD

• Designed and implemented A3 templates for enterprise budgeting solution

• Managed Tomcat server and Essbase Java API connections from A3 to Essbase Server

Environment: Hyperion Essbase 6, Tomcat, A3, MS-Excel Windows 2003 Server and IBM AIX

marchFirst, San Franciso, CA 2000

Data Warehouse Consultant

Provided consulting services at Informix, in Menlo Park

• Designed and developed reporting solution for end-user business requirement

• Developed Ad-Hoc reports using Business Objects

• Developed dashboards using MetaCube and training for dashboard application which featured MetaCube

Environment: Informix, Informatica, MetaCube, and Business Objects


SAP Certified Software Training

SAP AC010 – Business Processes and Financial Accounting

Hyperion Certified Software Training

Hyperion Wired For OLAP Analyzer & Design

Hyperion Essbase 5 Fundamentals

Hyperion Essbase 5 System Administration

Hyperion Essbase Partitioning

Hyperion Essbase Calculation Scripting

Hyperion System 9BI+ System Administration

Microstrategy Certified Software Training

MicroStrategy 7i: Intelligence Server Administration

Oracle Certified Software Training

Oracle Express: Database Design and Control

Oracle Financial Analyzer For End Users


Hyperion Certified Professional for Essbase


Bachelor of Business Administration, Loyola University-Chicago

course work completed at UC Berkeley: Perl and Discovering Java

Contact this candidate