SUMMARY:

• Oracle Hyperion Planning 11.1.2.4 Administrator/Oracle Hyperion Essbase 11.1.2.4 Developer/Oracle Hyperion BI+ 9.3 Administrator Certified Expert seeking to utilize these skills as an Oracle Hyperion Planning/Essbase/BI+ System Administrator/Senior Developer in a corporate environment on a permanent, fulltime basis.

PROFESSIONAL EXPERIENCE:

Independent Consultant

Responsibilities:

• Oracle Hyperion Planning/Essbase installation, development, optimization, and administration.
• MAXL, MDX, and batch scripting/scheduling.
• SQL development and optimization.
• Oracle Hyperion Financial Reports development and scheduling.

Confidential - New Hyde Park, NY

Manager, Decision Support Systems

Responsibilities:

• Managed development and administration of an Oracle Hyperion 11.1.2.4 Planning application used to support budgeting, forecasting, and financial modeling for the largest shopping center real estate investment trust (REIT) in North America.
• Performed upgrade from Oracle Hyperion Planning 9.3.1.5 on MS Windows O/S to 11.1.2.4 on Oracle LINUX 6 O/S.
• Developed Oracle Hyperion Web Analysis 11.1.2.4 dashboards utilized for CapEx/OpEx analyses.
• Provide Oracle Hyperion support and to an end-user community of 300+.
• Maintain security access for Hyperion and SAP Business Objects Data Warehouse systems.

Confidential - New York, NY

Senior Consultant

Responsibilities:

• Developed and taught on-site, custom Oracle Hyperion Planning 9.3 and 11.1 Administrator and End-User Workshops.
• Provided on-site and remote development and support for Oracle Hyperion System 11.1 BPM/BI products (e.g., Oracle Essbase 11.1 and Oracle Essbase Studio 11.1, Planning 11.1, Financial Reporting 11.1, Interactive Reporting 11.1, Web Analysis 11.1).
• Provided on-site and remote development and support for Oracle Hyperion System 9 BPM/BI products (e.g., Oracle Hyperion Essbase 9.3 and Oracle Hyperion Planning 9.3, Financial Reporting 9.3, Interactive Reporting 9.3, Web Analysis 9.3).
• Development and maintenance of Oracle Hyperion System 11.1 materials.
• Development and maintenance of Oracle Hyperion System 9.3 materials.

Confidential - New York, NY

Consultant

Responsibilities:

• Designed and implemented a General Ledger reporting application utilizing Hyperion System 9 Analytic Services (Version 9.2) OLAP databases.
• Utilized Hyperion System 9 Planning (Version 9.2), Financial Reporting (Version 9.2), Web Analysis (Version 9.2) and Interactive Reporting (Version 9.2) applications to facilitate budgeting, forecasting, modeling, and reporting.
• Conducted end-users seminars.

Confidential - New York, NY

Vice President, GMCID, Management Reporting

Responsibilities:

• Successfully installed and implemented Hyperion Essbase (Version 9.0) and Hyperion Web Analysis (Version 9.0) on Windows XP/2000 and UNIX (Solaris Version 8) operating systems.
• Performed conversion/migration of block and aggregate storage databases from Essbase (Version 7.1) to Essbase (Version 9.0).
• Maintained and administered Hyperion Essbase block and aggregate storage databases used for Global Corporate and Investment Banking activity sales reporting.
• Designed, developed, and administered nineteen Hyperion Essbase (Version 7.1) OLAP databases that utilized the Aggregate Storage Object (ASO) model to meet the requirements for Institutional and Debt sales activity reporting.
• Designed, developed, and administered three financial reporting delivery systems (e.g., DEV, QA, and PROD environs), located on three independent, UNIX servers, utilizing Hyperion Analyzer (Version 7.2).
• Trained and supported 100+ end-users in the usage of Hyperion Essbase (Versions 7.1 and 9.0) and Hyperion Analyzer/Web Analysis (Versions 7.2 and 9.0).

Confidential - White Plains, NY

Senior Systems Analyst

Responsibilities:

• Administered twelve Hyperion Essbase (Version 7.0) OLAP databases which provided actual, budget, variance, variance percent data for income statement, balance sheet, and lead sheet financial reporting requirements.
• Performed conversion/migration from Essbase (Version 6.5) to Essbase (Version 7.0).
• Developed a financial reporting delivery system (HFRS) utilizing Hyperion Enterprise Reporting (Version 6.5).
• Trained and supported 40+ end-users in the usage of Hyperion Essbase and HFRS.

Confidential, NY

Consultant

Responsibilities:

• Developed multidimensional databases used to measure the effectiveness, with respect to website registrations, of media content presented on corporate web sites.
• Developed dynamic dimension building rules for constructing/updating OLAP databases.
• Utilized SQL data extracts from Oracle 8i databases, and created custom data load rules to populate OLAP models.
• Developed custom calculation scripts to handle business intelligence reporting requirements.
• Optimized OLAP database performance.
• Scripted ESSCMD batch files to automate data loading/calculation processes.
• Maintained OLAP model/user security.
• Performed upgrade of Hyperion Essbase OLAP server environment
• Conducted end-user/developer seminars.

Confidential - New York, NY

Hyperion Systems Administrator

Responsibilities:

• Performed initial installation of Hyperion Essbase OLAP Server
• Interacted with Business Analysts to design Client Revenue & Billing, Client Profitability, and GAAP Income Statement OLAP models.
• Developed dynamic dimension building rules for constructing/updating OLAP databases.
• Utilized data extracts from Hyperion Enterprise and custom data load rules to populate OLAP models.

Confidential - New York, NY

Senior Technical Specialist

Responsibilities:

• Supervised and trained a five member Hyperion Essbase development team.
• Provided development/maintenance oversight for four OLAP financial reporting applications (e.g., Profitability and Retirement Asset Tracking, Advertising).

Confidential - Stamford, CT

Lead Consultant

Responsibilities:

• Designed, implemented, and optimized Executive Decision Support Systems at numerous client sites utilizing Hyperion Essbase, Excel Essbase Add-In, and Wired for OLAP.
• Conducted on-site in Essbase Fundamentals and Excel Essbase Add-In at numerous client sites.

Confidential - New York, NY 9

Applications Consultant

Responsibilities:

• Designed, implemented, and optimized Essbase Executive Decision Support Systems at numerous client sites.
• Taught Hyperion Essbase Fundamentals, Excel Essbase Add-In, and Introduction to ADL at numerous client sites.
• Trained internal staff in use of Hyperion Essbase, Excel Essbase Add-In, ADL, and Decision Desktop.