OBJECTIVE:

• Hyperion Essbase Architect position, designing and implementing Enterprise Performance Management solutions.

SUMMARY:

• Over 20 years of experience delivering successful reporting, analysis, and planning solutions across industries and functions. Involved in all facets of implementation: business requirements definition; technical design; development; and deployment and .
• Over 20 years of experience in Hyperion EPM Confidential (including 11.1.2.3): Specialized in Essbase; experience with Planning, HFM, FDM/EE, and DRM.
• Over 15 years of experience in Microsoft BI Confidential: SQL Server; Analysis Services; Integration Services; and Reporting Services.
• Over 20 years of multidimensional and relational modeling experience.
• Integration experience sourcing from SAP/ECC, SAP/BW, Oracle EBS, JDE, and Peoplesoft
• Integration and modeling experience with other relational databases: Oracle; TeraData; Netezza; DB2; Informix; and Progress.

PROFESSIONAL EXPERIENCE:

Confidential

Hyperion Architect

Responsibilities:

• Global Financials and Profitability, Reporting and Forecasting: Architected a framework that integrated data from 3 SAP instances and 6 other GL/ERP sources into a globally aligned dimensional design that supports both regional and global reporting needs. Developed the Essbase applications and integration processes that leveraged DRM for hierarchical consistency. Provided never - before available high quality and timely levels of detail and functionality for improved global decision making.
• Global Product Costing: Developed an Essbase reporting application for product level costing analysis, comparing different scenarios across multiple seasons. Significantly improved quality and timeliness of critical plan information.
• Hyperion Platform Migrations: Lead the migration effort from 9.2 to 11.1.1.3 including server installations and configuration, application migration for HFM, Essbase, and FDM, data quality assurance, and . Subsequently helped migrate from 11.1.1.3 to 11.1.2.3, including conversion from FDM to FDMEE.

Confidential

President, Principal Architect

Responsibilities:

• Credit Risk, Portfolio Analysis - Consumer and Commercial Banking: Worked with a banking consulting firm to develop the dimensional models, data integration, and production processes to support both Hyperion Essbase and Microsoft Analysis Services solutions. For Hyperion platform, development included Essbase Integration Services-based Cubes with Web Analysis and Financial Reports. For Microsoft platform, development included SSIS, AS cubes, ProClarity, and Reporting Services.
• Operational Reporting - Retail: Upgraded Essbase merchandise planning model to work within a transparent partition environment, making information immediately available for management reporting. Optimized existing reporting cubes and calculations to increase performance and reduce total cube sizes. Enhanced infrastructure for better auditing, alerts, and error handling. Provided technical support for Integration Services and ASO conversion.
• Expense Reporting - Property Management: Converted an existing Operational Expense cube, migrating from Essbase to MS Analysis Services, adapted processes to work within a new dimensional warehouse framework.

Confidential

Business Intelligence Architect

Responsibilities:

• Sales Reporting - Manufacturing: Architected and implemented Hyperion 9.2 Essbase applications to report critical sales and operations metrics to support marketing and manufacturing efforts. Integrated two ERP source systems, JDE and Oracle EBS.
• Financial Consolidation - Manufacturing: Developed dynamic ETL staging process using SQL Server to support a multi-GL, multi-currency Outlooksoft application.

Confidential

Senior Consultant

Responsibilities:

• Check Card Analysis - Consumer Banking: Developed system to process detailed ATM transactions, identify customer buying habits and marketing opportunities, track system performance, and reveal potential fraudulent activities.
• Credit Risk - Commercial Banking: Designed and implemented the complex integration processes for an application delivering banking metrics to analyze loan portfolio performance and risk.
• Performance Measurement - Federal Government: Optimized database and cube design and processes for delivering service performance metrics and updated the web framework to report on application usage.

Confidential

Principal Consultant

Responsibilities:

• Holistic Forecasting - Credit Cards: - Developed a forecasting system that integrated complex forecast data across departments and functions, with several specialized cubes, including yield on promotions and detailed departmental expenses, that fed a consolidated cube, all in a controlled workflow environment. Shortened turn-around time significantly for much more timely management reporting.
• Video Sales Forecasting - Entertainment: Designed and implemented a driver-based engine to forecast future video sales and corporate profitability. Engine supported multiple users and versions for corporate-level what-if analysis.
• Financial Reporting - Property Management: Developed the system to deliver web-based reports for all financial aspects of Property Management, including GL, AR, and detailed expense reporting.

Confidential

Datawarehouse Architect

Responsibilities:

• Financial Datawarehouse: Developed the integration process for multiple GL’s into a single datawarehouse that flowed into Essbase for consolidated financial reporting with a single chart of accounts.
• Corporate Budgeting. Developed a nationwide financial budgeting and forecasting system, including workforce and capital asset planning, and workflow.
• Project Reporting: Developed application to report task-based project costs vs. goal and its effects on financials, information used to plan future projects.

Confidential

Senior Consultant

Responsibilities:

• Quality Reporting - Manufacturing: Developed an application to report on production quality using statistical analysis for a large chemical firm’s manufacturing processes, across all plants and production equipment.
• Consumer Goods Category Analysis - Information Service: Designed and implemented a system to deliver key sales metrics on grocery products within hundreds of categories.