Nextel Communications Enterprise Reporting Evolution OracleWorld Presentation September 11th, 2003

1
Nextel Communications Enterprise Reporting
EvolutionOracleWorld PresentationSeptember
11th, 2003
2
Enterprise Reporting Striving to be Best in
Class

• 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

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

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

4
Enterprise Reporting - Approach

• Balanced Scorecard
• Dashboards

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

• Multi- Dimensional Reporting
• OLAP Applications
• Strategic Decision Making

What is our most profitable sales channel ?
Strategy

• Key Performance Indicators
• Common Business Rules
• Transformed/Summarized Data

What is the Customer Churn Rate for April ?
Business Rules

• Transactional Data
• Un-manipulated Data
• Batch Reporting

How many orders were processed today ?
Infrastructure
Reporting Tier Structure
5
Enterprise Reporting - Building Blocks
Executive View
Balanced Scorecard
Smart Growth Strategy
6 Quarter Forecasts
Strategic Investments
3 Year Plan
Business Rules/Reporting
Tax
Subscriber Activity
Sales

CRR
Profit
Billing
Revenue
Infrastructure
APIs

Intranet
PeopleSoft
Single Sign-on
Privacy Security
NDW
Ordering Billing
Oracle
6
Enterprise Reporting Reporting Evolution
1
5

• 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

Executive Reporting
4
20
Analytical Reporting
50
20
Functional Reporting
75
25
Transactional Reporting
2002 Reporting Model
2004 Reporting Model
Enterprise Reporting Evolution
7
Enterprise Reporting Infrastructure
8
Nextel Data Warehouse Standard Operating
Environment

• 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

9
Nextel Data Warehouse Data Sourcing
NDW Inputs
Listings (WSJ)
ABI
Dun Bradstreet
Brightpoint
Commissions
RPAS
Harte-Hanks
Lightbridge
Nextel Online
Telcordia
Motorola
Network Elements
Telemarketing Vendors
Voice Response Units
Ordering
HR
Customer Care
Financials
Billing
Supply Chain
Usage
Nextel Retail Stores
ACT Load
IP Billing
UPLink (Web Clicks)
Nextel World Wide
Sales Leads
NDW Systems
Horizontal/Cross Fleet
Web Sales
10
Enterprise Reporting Delivery Approach
i-Connect (Intranet Portal)
NexStep
Billing Data
IWS Data
Switch Data
WNP Data
Other Sources
HR
Finance
SCM
Business Intelligence Page
Data Replication
PS Query PL SQL nVision SQR
Transactional Reporting
Operational Data Store (ODS) Layer
1 Data Staging into a Common Data Source
Business Rules, Summarization, Data
Transformation
Business Objects Crystal Reports SAS KPI Builder
Others
PeopleSoft Data Warehouse
Billing Data Warehouse
Combined Data Warehouse
Functional Reporting
Data Warehouse Layer
Data Mart Layer
Analytical Reporting
Hyperion Apps CRR Dashboards Scorecards
Finance
Marketing
Sales
Revenue
Profit
Data Repackaging, De-normalization, Cube Building
3 - Common Presentation and Security
2 Apply Common Business Rules and Single
Version of the Truth
Nextel Data Warehouse
11
Enterprise Reporting Leveraging Oracle 9i RAC
i-Connect (Intranet Portal)
Application Users
Reporting Users/Data Warehouse
PeopleSoft Application
PeopleSoft Reporting
Oracle 9i RAC
HR

• 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
Enterprise Reporting Corporate Reports of Record
Metrics (Sample)
Data Sorts (Sample)
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 lt 30 seconds)
Channel Segment/Industry Vertical
Segment Geography Smart Growth
Category Competition Product Line / Product
Service Plan
14
Enterprise Reporting User Access Methodology
Nextel Enterprise Directory (LDAP)
NEXTEL DATA WAREHOUSE
User Authentication Request
Operational Data Store
2
NDWSAP
Enterprise Data Warehouse
Nextel i-Connect
1
User Login
3
PRESENTATION LAYER
Enterprise Data Marts
User Authorization
Business Intelligence Tab
Enterprise OLAP environment
4
Departmental Silos
5
Present Links As Per User Credentials
15
Enterprise Reporting Business Intelligence
Presentation
16
Enterprise Reporting Analytical/OLAP Reporting
17
Nextel Data Warehouse Profitability Reporting
Source Data
USAGE
UNITS
COST
REVENUE
RECONCILIATION
LOAD PROCESS
Profit Data Mart
Profit OLAP Cubes
Standard / Ad-Hoc Reporting (Wide Audience)
Ad-Hoc Reporting (Narrow Audience)
Financial Analysts Business Analysts
Executive Management Management / Operations
18
Profitability Reporting Drill Down Approach
First Level View
19
Profitability Reporting Drill Down Approach
(Cont.)
Second Level View
20
Profitability Reporting Drill Down Approach
(Cont.)
Third Level View
21
Nextel Data Warehouse Sales Reporting
Application
22
Enterprise Reporting Executive Dashboards/Scorecar
ds
23
Enterprise Reporting Dashboard Customization
(Sr. Exec)
24
Enterprise Reporting Dashboard Customization
(Functional Area)
25
Enterprise Reporting Questions ???