Telecom and Cable Management Module

1
Telecom and Cable Management Module Wireless
Maintenance Work Requests

• Ball Aerospace Technologies Corp.
• Facilities and Support Services
• John Kuxhausen
• Wayne Schacher

2
Ball Aerospace Technologies Corp. Facilities

• Wholly-owned subsidiary of the Ball Corporation
• Educated and technically diverse staff
• Ph.D. Master 29
• Bachelors 36
• Associates Technical 8
• Total employment 3,000
• Occupy in Colorado 1.5 million square feet
• 36 buildings

Ball Aerospace living logo as seen by QuickBird
3
Ball Aerospace Technologies Corp. Facilities
Boulder, CO
Arlington, VA
Chantilly, VA
Huntsville, AL
Albuquerque, NM
4
Telecom Module Implementation Road Blocks

• Learn to communicate with each other (Facilities
  Telecommunications Network Operations)
• Take time to learn each others work language
• Take time to understand each groups processes
• Open the channels of communication and listen
• Understand the true amount of records
• Conversion of Telecommunications records into
  ARCHIBUS tables
• 15,000 faceplates
• 60,000 jacks
• 480,000 cable pairs
• Validate record information amongst all parties
• Data
• Voice
• Facilities
• Training
• Learning the language of ARCHIBUS
• Obtaining and maintaining the information

5
Temporary Tables From Excel Spreadsheets

• Converted Telecommunications and Network
  Operations Excel spreadsheets to ARCHIBUS format
• Format in Web Central
• Aerospace operates in Windows and Web Central
• Telecommunications and Network Operations
  operates in Web Central
• Originally all parties where validating one
  record at a time

6
Temporary Voice Tables in Windows Environment

• Facilities assisted in validation process through
  the Windows interface
• Mass edits and changes were capable

7
Voice Record Validation and Clean Up

• Telecommunications validated records through the
  Web Central interface
• Clean up was done one record at a time
• Process was slow

8
Temporary Data Tables in Windows Environment

• Facilities assisted in validation process through
  the Windows interface
• Mass edits and changes were capable

9
Data Record Validation and Clean Up

• Network Operations validated records through the
  Web Central interface
• Clean up was done one record at a time
• Process was slow

10
Telecom and Cable Management Final Screens

• Converted temporary tables into workable tables
  with unique Web Central tasks

11
Final Goals of On-Going Module Deployment

• One master table for voice and data records
• One final clean up of records in process
• Valid voice and data information automatically
  populated from tables for MAC requests
• Direct links from Facilities MAC request to
  generate a voice and data work request
• One page daily work load sheet for technicians
  incorporating all work requests

12
On-Line Maintenance Work Request Obstacles

• Creating new way to request work
• No longer able to e-mail or call in request
• Aspiring to paperless method
• User friendly (minimal key strokes to make
  request)
• Incorporate automatic feedback to customer
• Have access for all employees through Web Central
• Buy-off from maintenance technicians
• Why a new automated system
• Web-based
• Wireless dissemination of work order
• How does it change the way work is accomplished
• How is the data going to be used that is
  collected on work done
• How does automation change the process
• Emergency work requests
• Off-hour / weekend needs
• On-call maintenance technicians

13
Single Sign-On

• Ball Aerospace network log-in user name and
  password recognized by ARCHIBUS

14
Web Central Maintenance Request Screen

• Custom Web Central input screen created to
  minimize keystrokes and clicks

15
Work Request Verification to Requestor

• Automatic generation of e-mail to requestor
  confirming request was received

16
Behind-The-Scene Processing

• Work request automatically assigned to
  maintenance technician based on hierarchy rules
• Building location
• Craft trade
• Work request automatically converted to work
  order
• Work order sent to wireless device
  instantaneously
• Blackberry wireless handheld selected
• Company standard and supported
• Utilizes MicroView as interface to ARCHIBUS
• Emergency work requests and off-hour / weekend
  requests have different routing
• Multiple maintenance technicians notified prior
  to generation of emergency work order during
  business hours
• Escalation of notifications if no response within
  predefined time period
• Ball Aerospace Plant Security notified off-hour
  or weekends

17
Emergency and On-Call Work Requests

• Three maintenance technicians notified of work
  request option to accept or decline

• Escalation of work request if initial
  notification is declined or time expires

18
Emergency and On-Call Work Request Tables
19
Customer Feedback

• Automatically sends e-mail to requestor notifying
  work order has been completed

20
Customer Survey on Work Request

• Link in e-mail for requestor to complete
  satisfaction survey

21
Further Activities for Deployment

• Complete beta-testing and roll-out to general
  employee population
• Generate dashboard metrics
• Average response time
• Average completion time
• Work order backlog
• Customer satisfaction rating

22

• ?

?
?