Nextel Communications Enterprise Reporting EvolutionOracleWorld PresentationSeptember 11th, 2003

2

A Best in Class approach enables the enterprise to gain competitive advantage by reducing the time and effort required to acquire, distribute and respond to new information

The Enterprise Reporting program will deliver the following over a two year period:

– Common, secure, single sign-on access path to Nextel information

– Improved data accuracy

– Improved strategic decision making

– Tools that make data analysis user friendly

– Shared data across business functional areas

– Compliance with Security and Privacy requirements

– Compliance with Sarbanes-Oxley requirements

– A ‘single version of the truth’

– Reduced maintenance costs

– Better visibility into financial and operational information

Enterprise Reporting – Striving to be “Best in Class”

3

Enterprise Reporting – Governance Model Steering Committee Organization

– Quarterly Face-to-Face meetings– Monthly dashboard updates– Executive Sponsor VP Organizations:

IT Internal Audit Finance Finance Ops Sales Operations Customer Operations Tax Employee Services HR Development Indirect Distribution Corporate Communications

Oversight Committee Organization– Working team of representatives from various business areas– Monthly meetings– Definition of business priorities– Serve as business owners to define business rules for respective areas

IWS Marketing Revenue Assurance Supply Chain Customer Care Regional Sales Strategy HR Compensation/Benefits Engineering

4

Enterprise Reporting - Approach

Multi- Dimensional Reporting

OLAP Applications

Strategic Decision Making

Key Performance Indicators

Common Business Rules

Transformed/Summarized Data

Transactional Data

Un-manipulated Data

Batch Reporting

Infrastructure

Reporting Tier Structure

How many orders were processed today ?

What is our most profitable sales channel ?

What is the Customer Churn Rate for April ? Business Rules

Executive

Strategy

Balanced Scorecard

DashboardsWhat is the ARPU, OCPU, and CPGA for the month of April ?

5

Enterprise Reporting - Building Blocks

Infrastructure

Business Rules/Reporting

Smart Growth Strategy

6 Quarter Forecasts

Executive View

Balanced Scorecard

CRR Profit Billing Revenue TaxSubscriber

Activity Sales …

IntranetNDW PeopleSoftOrdering

& Billing SingleSign-on

APIs …Privacy &Security

3 Year Plan

Oracle

StrategicInvestments

6

Enterprise Reporting – Reporting Evolution

Transactional Reporting

Functional Reporting

Analytical Reporting

Executive Reporting

1 % 5 %

4 % 20 %

25 %75 %

50 %20 %

2002 Reporting Model 2004 Reporting Model

Enterprise Reporting EvolutionEnterprise Reporting Evolution

Un-actionable reporting to executives

Limited tools for strategic analysis

Conflicting business rules

Many users accessing

raw data

Actionable reporting to executives

Robust tools for strategic analysis

Consistent business rules

Few users accessing

raw data

7

Enterprise Reporting

Infrastructure

8

Servers– HP Superdome– Sun Fire 12000– HP/Compaq

Storage– EMC Symmetrix– EMC DMX– HP Storage

Backups– EMC EDM– HP Omni back

Software/Tools– Oracle (Various Products)– SAS– Hyperion Essbase– Business Objects– Crystal Reports– SQL /PLSQL– Quest Shareplex– CA TNG– CA Autosys– TOAD– Web Sphere

Nextel Data Warehouse – Standard Operating Environment

9

ABI

Harte-Hanks

NDW Systems

NDW Inputs

Nextel Data Warehouse – Data Sourcing

HR

Financials

Supply Chain

Nextel Retail Stores

IP Billing

Sales Leads

Web Sales

Nextel Online

RPAS

Motorola

Brightpoint

Horizontal/Cross Fleet

Nextel World Wide

UPLink (Web Clicks)

ACT Load

Usage

Billing

Customer Care

Voice Response Units

Ordering

Network Elements

Lightbridge

Commissions

Telcordia

Listings (WSJ)

Dun & Bradstreet

TelemarketingVendors

10

i-Connect

(Intranet Portal) HR

Business

Intelligence

Page

Finance Marketing Sales Revenue Profit

OthersBillingData

Warehouse

Business Objects

Crystal Reports

SAS

KPI Builder

Operational Data Store (ODS) Layer

Data Warehouse Layer

Data Mart Layer

Transactional

Reporting

Analytical

Reporting

Functional

ReportingPeopleSoft

Data Warehouse

CombinedData

Warehouse

Finance

Business Rules,

Summarization,

Data Transformation

Billing

Data

Data Repackaging,

De-normalization,

Cube Building

Nextel Data Warehouse

Hyperion Apps

CRR

Dashboards

Scorecards

PS Query

PL SQL

nVision

SQR

SCM

NexStep

3 - Common Presentation and Security

1 – Data Staging into a Common Data Source

2 – Apply Common Business Rules and ‘Single Version of the Truth’

Data Replication

IWS

Data

Switch

Data

WNP

Data Other

Sources

Enterprise Reporting – Delivery Approach

11

Enterprise Reporting – Leveraging Oracle 9i RAC

i-Connect (Intranet Portal)

PeopleSoft

Application

HR

Oracle 9i RAC

PeopleSoft

Reporting

Application Users Reporting Users/Data Warehouse

Benefits

• Isolates application users from reporting users

• Instances can be tuned separately

• Provides fail-over for application users

• Provides real-time reporting capabilities

• Reduces need for data replications

12

Enterprise Reporting

Common Business Rules/Presentation

13

Sales Focus

Total Subscribers

Gross Adds

Churn (%)

Net Adds (units)

Revenue

ARPU

Penetration

Financial -- Cost Focus

CPGA

OCPU

Network Focus

Dropped Calls

Network Uptime

Network Operating Cost per MOU

Total Cell Sites

Financial -- Performance Focus

Days Sales Outstanding (DSO)

Bad Debt as a % of Revenue

EBITDA

Operating Margin

Free Cash Flow

EPS  

Valuation Focus

Lifetime Customer Value (LTV)

Employee Focus

Total Headcount

Employee Turnover Rate

Customer Focus

Customer Satisfaction % (CSI)

Service Level % (answer < 30 seconds)

Metrics (Sample) Data Sorts (Sample)

Channel

Segment/Industry

Vertical Segment

Geography

Smart Growth Category

Competition

Product Line / Product

Service Plan

Enterprise Reporting – Corporate Reports of Record

14

Enterprise Reporting – User Access Methodology

Nextel i-Connect

Nextel EnterpriseDirectory(LDAP)

Business Intelligence

Tab

Operational Data Store

Enterprise Data Warehouse

Enterprise Data Marts

Enterprise OLAP environment

Departmental Silos

NEXTEL DATA WAREHOUSE

PRESENTATION

LAYER

User

Login

Present Links

As Per User Credentials

User Authentication Request

User Authorization

1

2

3

4

5

NDWSAP

15

Enterprise Reporting – Business Intelligence Presentation

16

Enterprise Reporting

Analytical/OLAP Reporting

17

RECONCILIATION

USAGEUSAGEUNITSUNITS COSTCOST

LOAD PROCESS

REVENUEREVENUE

Profit Data Mart

Source Data

Financial Analysts &

Business Analysts

Ad-Hoc Reporting

(Narrow Audience)

Profit OLAP Cubes

Executive Management

Management / Operations

Standard / Ad-Hoc Reporting

(Wide Audience)

Nextel Data Warehouse – Profitability Reporting

18

Profitability Reporting – Drill Down Approach

First Level View

19

Second Level View

Profitability Reporting – Drill Down Approach (Cont.)

20

Third Level View

Profitability Reporting – Drill Down Approach (Cont.)

21

Nextel Data Warehouse – Sales Reporting Application

22

Enterprise Reporting

Executive Dashboards/Scorecards

23

Enterprise Reporting – Dashboard Customization (Sr. Exec)

24

Enterprise Reporting – Dashboard Customization (Functional Area)

25

Enterprise Reporting

Questions ???