TECHNICAL SKILLS

• Hyperion Financial Management (HFM) 11.1.2.2
• HFM Rules
• EPMA
• LCM
• Calc Manager
• Hyperion Planning
• Hyperion Essbase
• Hyperion Financial Reporting Studio
• SmartView
• Hyperion Financial Data Quality Manager 11.1.2.2 (FDM)
• Shared Services
• Hyperion Enterprise 6.22
• Essbase Esscmd
• Essbase Calc Scripts
• Essbase Maxl scripting
• VBA.

PROFESSIONAL EXPERIENCE

Confidential, Mountain View, CA

Hyperion Architect

Responsibilities:

• Hyperion 11.1.2.2 HFM, FDM, EPMA and Calc Manager
• Implementation of HFM and FDM: Metadata, Business Rules, Security and FDM
• Technical Lead for several HFM development projects
• Created HFM production support documentation, assisted in decreasing FDM load time by 50%

Confidential, Birmingham, AL

Hyperion Architect

Responsibilities:

• Hyperion 11.1.1.3 EPMA, HFM, FDM, Calc Manager, Financial Reporting Studio, SmartView
• Full life cycle implementation: Requirements, Design, Build and Test
• Created HFM Metadata, Business Rules, Hyperion Reports: P&L, Balance Sheet, and Cash Flow

Confidential, Fort Wayne, IN

Hyperion Architect

Responsibilities:

• Hyperion 11.1.2 EPMA, HFM, FDM, Calc Manager, Financial Reporting Studio, SmartView
• Full life cycle implementation: Requirements, Design, Build and Test
• Created HFM Metadata, Business Rules, and Hyperion Reports: P&L, Balance Sheet, and Cash Flow
• Created FDM locations, import formats, mapping and SQL interface to Data Warehouse
• Provided end user training for 30 users

Confidential, Indianapolis, IN

Hyperion Architect

Responsibilities:

• Hyperion 11.1.1.3, EPMA, HFM, FDM, Calc Manager, Financial Reporting Studio, SmartView
• Modified application to accommodate a conglomerate merger
• Created HFM Metadata, Business Rules, and Hyperion Reports
• Created FDM locations, import formats, mapping and SQL interfaces for 28 General Ledgers

Confidential, Houston, TX

Hyperion Architect

Responsibilities:

• Hyperion HFM 9.3, FDM, Financial Reporting Studio, SmartView
• Full life cycle implementation and upgrade from Hyperion Enterprise: Requirements, Design, Build and Test.
• Created HFM Metadata, Business Rules, and Hyperion Reports, load and validate historical data
• Created and presented user training class to a group of twenty
• Created ERP interface from SAP to FDM

Confidential, Framingham, MA

Hyperion Architect

Responsibilities:

• Hyperion HFM 9.2, SmartView, Financial Reporting Studio
• Added KPI Schedule and Custom Dimension, created SmartView KPI report and load template
• Created HFM Rules for KPI calculations
• Configured Process Management including Phased Submission
• Created Hyperion Reports - Financial Reporting Studio

Confidential, Cincinnati, OH

Hyperion Archit ect

Responsibilities:

• Hyperion System9 ver. 9.3, Planning, CapEx, and Work Force Planning modules
• Full life cycle implementation

Confidential, Houston, TX

Hyperion Architect

Responsibilities:

• Hyperion Essbase System9 version 9.3
• S ystem metadata architecture redesign: Added new divisions/brands, redesigned security, created data copy calc scripts for Forecast scenario, decreased calculation times by 400%, decreased monthly and year end maintenance by 70% by creating Maxl scripts to build monthly security filters, merged four databases into two.

Confidential, Columbus, OH

Hyperion Architect

Responsibilities:

• Hyperion System9: Hyperion Financial Management (HFM) 9.2, Planning/Essbase 9.2,
• Financial Reporting Studio and Hyperion Financial Data Quality Manager (FDM), SmartView
• Full life cycle design and implementation Business process and system metadata architecture design Created reports in Financial Reporting Studio Created ERP interface from SAP

Confidential, Chicago, IL

Consultant/Project Manager

Responsibilities:

• Installed, designed and implemented Hyperion Forecasting Application
• Logic Rules: Statistical Accounts, eliminations, KPI’s, and consolidation logic
• Hyperion Enterprise 6.2.2 and Hyperion Essbase 6.6 application design, optimization and support for World Headquarters Consolidation and Planning systems
• Business process and system architecture design
• Project management and process methodology utilizing Fujitsu Macroscope
• Designed and implemented a Hyperion fail over system for disaster recovery.
• Lead developer for financial segment income reporting and cash flow automation project utilizing Hyperion Reporting 3.5 and Hyperion Retrieve .
• Production support team member, supporting production migrations, change management, and Sarbanes Oxley (SOX) documentation.

Confidential, Northbrook, IL

Hyperion Architect

Responsibilities:

• Designed and implemented Hyperion Enterprise, and Hyperion Application Link (HAL) for the Domestic and International divisions.

Confidential, San Ramon, CA

Hyperion Architect

Responsibilities:

• Hyperion Architect on Confidential Hyperion merger team. Designed and implemented Hyperion applications to integrate the legacy Chevron and Texaco Enterprise applications. This was part of the Confidential International ERP Integration project.
• Extracted, translated, loaded and tied out data from the Chevron and Texaco Enterprise applications.
• Created post merger Hyperion Reports and Excel Retrieve reports.
• Provided Hyperion support and knowledge transfer for the initial post merger financial close and subsequent closes.

Confidential, Milwaukee, WI

Senior Consultant

Responsibilities:

• Created a Hyperion Enterprise and Essbase pilot. This project entailed setting up pilot databases for the Dealer Dashboard 2 project.
• Provided a written technical comparison of the two databases, and provided an evaluation based on the project requirements.

Confidential, Lisle, IL

Senior Consultant

Responsibilities:

• Developed an allocation Essbase database which allocated fixed expenses from expense pools.
• Developed a financial reporting Essbase database.
• Created data Load Rules to import data from Hyperion Enterprise and an Oracle data warehouse.
• Created ESSCMD scripts to automate dimension builds, partitioning and data loads.

Confidential, Wheeling, IL

Senior Consultant

Responsibilities:

• Lead Essbase developer on a project team of three.
• Designed a product profitability database.
• Assisted project team with design of SQL server data warehouse.

Confidential, Chicago, IL

Consultant

Responsibilities:

• Designed and implemented a financial reporting Essbase database.
• This project entailed setting up an Essbase database for weekly reporting of financial and assembly plant production data.
• Converted several static Excel reports to dynamic reports utilizing the Essbase spreadsheet Addin and VBA .
• Designed and built the Essbase outline, and created outline calculations for weekly reporting and variance analysis.

Confidential, Houston, TX

Consultant

Responsibilities:

• I created approximately 50 monthly and weekly reports using Hyperion Report Writer.
• I also provided Report Writer training to several SYSCO employees.

Confidential, Chicago, IL

Financial System Manager

Responsibilities:

• Managed and maintained multiple Hyperion Enterprise applications.
• Provided Hyperion Enterprise training for new Accountants.
• Managed financial systems special project teams.
• Assisted in the development and rollout of the USG Intranet.

Confidential, Chicago, IL

Senior Financial Staff Analyst/Staff Accountant

Responsibilities:

• Implemented and maintained multiple Hyperion Enterprise applications.
• Consolidation of subsidiaries for monthly and year end closing. Elimination of inter-company activity, quarterly and year end SEC reporting, forecasting, and special projects.
• Assisted in creating Monthly Income Statements, Balance Sheets, Cash Flow Statements, and Account reconciliation.
• Responsibilities included consolidation of subsidiaries for monthly and year end closing, elimination of inter-company activity, assisted in Chapter 11 bankruptcy filing, and fresh start accounting.
• Assisted in creating Monthly Income Statements, Balance Sheets, and Cash Flow Statements.

Confidential, Chicago

Accountant

Responsibilities:

• Bank and account reconciliation, created journal entries for monthly and year end closing.