Fully Implemented GIS/WMS/Outage System

1. Fully Implemented GIS/WMS/Outage System May 2004

2. DataOne History • Feb. 1998 DataOne Project formed to replace legacy GIS/WMS/OMS Systems • 1998-99 Product evaluation and selection • 2000-2001 Data Migration from legacy GIS System to new GIS Package • Dec. 2001 GIS Go-Live • Sept. 2002 PowerOn Go-Live • Sept. 2003 WMS/Design Go-Live

3. The Old • Job requests entered into stand alone Work Management system • Construction Designs draw in stand alone AutoCAD • As-builts manually re-drawn into GIS • GIS Model updates manually sent to Outage System

4. The New Process

5. CUSTOMDATAONE Outage Management System Geographic Information System PowerOn GIS Call Taking App. *Tree Trimming *Public Involvement COREDATAONE Work Design ED 3 *Reference File *Asset Manager Work Management System Distribution System Planning& Analysis *Contractor Invoicing STORMS FeederAll *Materials Forecasting Enterprise Application Infrastructure (EAI) Interfaces to AE Legacy Systems -IMS, Banner SOMS GIS Web The DataOne System * Post Go-live applications.

6. Core DataOne Applications • GIS (GE Smallworld) • Maintains electric facilities data • Contains electrical connectivity model • Replaces CAOS • WMS (STORMS) • Initiates, tracks, and closes distribution work • Allows work to be routed to various users • Replaces SPEED • Outage Management (PowerOn) • Initiates, dispatches, and close outages • Analyzes and predicts outage source from trouble call information • Work Design(ED3) • Designs and estimates distribution work • Utilizes GIS • Replaces ACAD

7. GIS System • Austin Energy uses GE Small World as the GIS Package • All Overhead & Underground Distribution Facilities reside in the GIS model • GIS model contains full connectivity, phasing, & location of Distribution Facilities • GIS model is Sub-Meter accurate for x,y coordinates

8. Business Processes & System Initiate Work STORMS A customer request for construction enters the Distribution System and follows a basic path. Design & Estimate Work ED 3 & GIS Approve Design STORMS PIA Obtain Easements Collect Fees STORMS Release for Construction STORMS The request is passed seamlessly between DataOne applications, from initiation to closure. Schedule Work Scheduler Tree Trimming Construct Work Perform Tree Trimming Report Work Completed CIA Time Reporting Asset Manager Enter As-Builts ED 3 & GIS Close Work STORMS

9. Work Requests Each job is initiated and tracked in STORMS as a Work Request. Each Work Request is assigned a unique number. All work performed for the Work Request is charged to its unique number.

10. Compatible Units ED3 utilizes compatible units to develop a design Compatible units contain AE’s Design Construction Standards along with labor and accounting information

11. Construction Design Print • Every construction design will have a unique Work Request number • Proposed install features appear as bolded objects • Designs are defined by points and spans • During the final design process, facility numbers are automatically assigned to riser and line fuses, capacitors, reclosers, regulators, and airswitches • Designs use existing GIS

12. Construction Order • Crew receives construction order as well as design print • Displays scheduled date and estimated amount of time job may take to complete • Breakdown of CU’s by point and span

13. calendar Work Design/GIS As-Built Process As-Builts are closed out automatically using the Work Design Package. • This integration will enhance the as-built process by: • using existing infrastructure information to develop new designs • reducing manual digitizing • accessing current information about the electrical system • searching for specific electric system components

14. Merging to Master GIS Model • All changes to the GIS Working model are merged to the GIS Master model at the end of each business day • The Outage Management System takes updates from the GIS model • The Design Package takes updates from the GIS model

15. Outage Management System • Power On uses the Distribution Electric Connectivity Model • Electric Connectivity is established from the Substations down to each customer • Outage model predicts the appropriate protective device • Crew locations are tracked with Power On

17. Next Steps • Update all packages to latest version releases • Deploy Planning Analysis Package • Deploy Assest Management Package • Enhance Mobile applications

18. Experiences - Positive • Ownership of data quality is shared across the company • Engineering uses GIS for Design work • Rule-based tools reduce data errors • Outage Management is updated every 24 hours

19. Experiences - Negative • Roll-out of software packages was not consistent • Product customization vs. configuration • Reorganization of the project before completion • Business Process Changes & Scope Creep

20. Lessons learned • Assemble a team that includes SME’s ( Subject Matter experts ) for each package • Use a qualified consultant for software selection, data migration, and implementation • Do not make promises that are outside of the Business Plan. No Scope Creep! • Find a champion who can navigate the political arena • Keep users involved throughout the life of the project