Hyperion Women’s Forum

US-Analytics

June 14, 2012

2

Agenda

I. Background and Overview - Who We Are

- Where We Started

- Business Need Confirmation

- Project Snapshot

II. Hyperion Solutions - Key Team Players

- Tool Set and Related Accomplishments

- Data Flow Depiction

III. Lessons Learned Or Confirmed

IV. Customer Viewpoint

V. Q&A

Background and Overview

4

BBC Description

Our primary market sectors include:

• Healthcare

• Hospitality

• K-12 and Higher Education

• Military Housing

• Multi-unit and Residential Housing

• Retail

Balfour Beatty Construction (BBC) is a construction contractor

predominately engaged in general building construction and

construction management throughout the U.S.

BBC’s parent is Balfour Beatty plc, located in London. Consequently, BBC

prepares financial statements in compliance with IFRS and GAAP.

• Corporate office

• Criminal justice

• Government

5

Div./Region HQ

Nat’l HQ

Local Market Offices

North

Southwest South Central

Southeast

~1,200 active projects

~2,400 employees

Current Footprint

Northwest

(HSW)

6

San Diego Women’s Correctional Facility

San Diego, CA

Cross-Division Collaboration

Bank of America Coit Data Processing Center

Richardson, TX

National Public Radio Headquarters

Washington, DC

Workplace 2012 (Headquarters Renovation)

Glen Mor Student Apartments At UC Riverside

Riverside, CA

U.S. Headquarters Houston, TX

7

Utah Data Center NCE

The Peabody Bank of America ‘Super Block’

Recent Signature Projects

Charlotte, NC

$600M

Orlando, FL

$262M

Ft. Belvoir, VA

$1.4B (50/50 JV)

Camp Williams, UT

$1.2B

8

Dr. Phillips Center for the Performing Arts Museum of Nature & Science

Dallas Convention Center Hotel Austonian

Recent Signature Projects

Austin, TX

$138M

Dallas, TX

$306M (80/20 JV)

Dallas, TX

$94M

Orlando, FL

$126M

9

Where We Started

• Excel – intensive consolidation and reporting

• Manual processes and controls

• Complex projection tools that were cumbersome and

error prone

• Reporting at set monthly intervals with no option to run

consolidated results on demand

• Limited standard reporting across divisions

Our previous Financial Reporting process included:

10

Business Need Confirmation

We completed Project Startup with US-Analytics to confirm the best tool

suite to automate our financial reporting process.

We sought a solution that would:

• Increase the speed and efficiency of reporting financial and

operational information

• Self-enable our Divisions, leading to more independence for

reporting and enhanced analysis

• Reduce the reliance on manual processes and tools

• Reduce the cost of compliance and deliver confidence in the

numbers

• Provide automated options for divisions/companies not using

our ERP

11

Sept 2011 Oct 2011 Nov 2011 Dec 2011 Jan 2012 Feb 2012

Plan &

Analyze

Design

Build

Test

Deploy

Support

none none

Project Snapshot

May 2011 Jun 2011 Jul 2011 Aug 2011

Select Implementation

Partner

Complete Project

Start-up Interviews

Finalize Solution

Roadmap Obtain Approval

Requirements

Gathering

Convert Requirements

to Technical Design

Construct Metadata,

applications

Testing and Training

(Systems and UAT)

PROJECT START-UP

PHASE 1

Rollout / Knowledge Transfer

Run Parallels

Go Live Projected Date =

1st week of February

2012; January close

Hyperion Solutions

13

Hyperion Solutions

BBC chose to leverage the latest, best in class technology by selecting

the following Oracle products:

- Hyperion Financial Management

- Hyperion Planning

- Financial Data Quality Management (FDM)

JD Edwards, our ERP system, is also an Oracle application.

Other solution components include:

- Hyperion Reports

- Smartview / MS Excel Add in for Ad Hoc reporting

14

BBC Key Team Members

Hyperion Technical Administrator

New system development

Maintain forms, rules, workflow, reports

Data integration

Provide extracts and downstream interface data

Perform system maintenance, monitor hardware

System process execution (loads, calculations, etc.)

Add users

Hyperion Functional Administrator

Implement organizational hierarchy changes

Set up joint ventures

End user training

Maintain forms, rules, workflow, reports

Critical business knowledge

New report development

Metadata modification

Finance Technical

Technical Finance

In addition to including subject matter experts in the implementation core

team, two Hyperion administrators were hired by BBC.

15

Tool Set & Related

Accomplishments Hyperion Financial Management (HFM) *

a financial consolidation and reporting application with advanced Web technology

GOALS MET

Create consolidated

and divisions stand

alone financial

statements

Generate the Contract

Summary with project

level detail by division

or on a consolidated

basis; including JV

detail

Provide multiple

accounting and legal

views:

– IFRS

– GAAP

– Legal entities

– Management /

operating

aggregations

Automate creation of

proportionate

consolidation, full

consolidation and

equity method

accounting

Increase

standardization of

reports where it

makes sense

Automate certain

journal entries specific

to our industry and

company and push

them back to JD

Edwards. Examples

are:

– BIE/CIE

– Reserve for projects

<10% complete

Hyperion Planning (Planning) *

a centralized, Excel and Web-based, planning, budgeting and forecasting solution

GOALS MET

Streamline projection

processes with a

flexible projection

model

Support projections

on a quarterly basis

with monthly updates

for actual results

Incorporate multiple

E-curves (e.g., type,

duration, industry)

Segregate corporate

adjustments from

division adjustments

(leave an audit trail)

Support adjustments

from probable

scenarios to stretch

scenarios

Provide workflow and

process management

Automate certain

management

operating report data

Financial Data Quality Management (FDM)

GOALS MET

Map new acquisition and sister company data to consolidations for actual results

* Includes the Excel Add-in, “Smart View,” which allows for ad hoc reporting and analysis

16

Data Flow Depiction

Lessons Learned or Confirmed

18

Lessons Learned or Confirmed

• When implementing more than one application,

repeatedly confirm the deliverables of each tool with the

Hyperion architects.

• Ensure reporting requirements are based on detailed

review of requested reports (some may be more

complex than appear at first glance).

• Confirm automation abilities early in the process.

- Will the end solution be fully automated? Will it be semi-automated? What will

still be manual?

• Increase UAT time for non-standard processes.

Application Knowledge - Development

19

Lessons Learned or Confirmed

• If you build it, they will come.

- Super users should be identified and used as a resource to other Hyperion

users.

- As experience grows with Hyperion and Smartview, users will want more. Guide

them to use standard reports where it makes sense and to increase their ad hoc

skills when it doesn’t.

• Stress the potential impact of users with Admin rights.

• It’s probably not possible to over train.

• Expect to provide extensive customer support in the six

months following Go Live.

Application Knowledge - Users

20

Lessons Learned or Confirmed

• Communicate, communicate, communicate

- Periodic touch points with Core Team members, the finance community and

Executives proved effective using email, Webex meetings and live

presentations.

- Set expectations early and reiterate often.

• Core Team members must be engaged

- Weekly status meetings should be used to focus on milestones, issues and

risks.

- Find an alternate for a core team member who is unable to fully engage in the

process.

• Partner with IT

- An IT partner can bridge the technical gap between the finance personnel and

the Hyperion architects .

Project Management

Customer Viewpoint

Q&A