Meter Data Management System SWEMA Spring Conference Amarillo, Texas 2008

1. Meter Data Management SystemSWEMA Spring ConferenceAmarillo, Texas2008

2. Meter Data Management • Agenda • What is MDM? • Where does MDM fit? • Challenge of AMI • Why you need MDM • Where is MDM going? • Business Process Changes • Summary and Questions

3. Capture AMI Reads Store Read Data Validate Estimate Edit Deliver Determinants for Billing MDM - What people “think” it is • … is an enterprise-wide data management solution for interval, register and event data for residential and C&I customers. … manages data from many different collection systems and provides secure, accurate, reliable data to a wide array of billing and analysis systems • … receives data in many forms, and from a growing diversity of sources, including meters and, eventually, transformer connections and switches. It validates, edits, and formats the data for use by different applications, passes formatted data to those applications, and archives a complete set of data for future reference. • … supports utility mass market and commercial/industrial (C&I) advanced metering applications. It enables process automation and delivers unparalleled accuracy, end-to-end visibility, and real-time control over utility business processes related to advanced metering.

4. MDM is NOT: Just a data warehouse of usage data Just for C&I meters and complex billing Just for “VEE-ing” interval data Operated based on monthly billing cycles Limited to revenue metering data At least it shouldn’t be! MDM is: A platform to enable fundamental changes in operating your company using real-time information The integration point for current and future AMI technologies The information toolkit required to empower your AMI Operations department The foundation of future customer programs including new customer-premise devices (e.g. HAN, Smart Thermostats) Step one toward a Smart Grid So what is Meter Data Management?

5. It’s not simple anymore! AMI Connect/Disconnect Demand Response OMS Manage Outages Meter Reading Collect the data MDMS Process, Analyze, Normalize, Distribute CIS Calculate the bill HAN Communicate & Control CDP Present Data Load Research Analyze Data

6. AMI and MDM over the years

7. MDM is more than “Read & Bill” • Cover all MDM billing functions • Add AMI Business Process Management • Provisioning • Exception handling • Aggregation and virtual metering • Command/control • Add Analytics and Reporting • AMI performance and trends • Usage anomalies • Meter and data problems and issues • Now, integrate with the enterprise • Real-time Standards based • Flexible • Distribution of data

8. Where does MDM fit? Meter reads Billing determinants Meter reads Synchronization, billing determinants, work orders Provisioning meter reads events Meter reads Events, Power status Work order

9. The challenge of AMI Managing the AMI business processes and the data: • Deployment Planning and Scheduling • AMI Provisioning and Activation • Data Collection • Problem Detection and Resolution • Data Synchronization • Data Processing and Distribution • Outage Management By the numbers (1,000,000 meter utility) Every DAY the information systems and personnel must support: • >2,000 meter exchanges per day • >1,000 customer moves per day (25% yearly turnover) • 10,000 missing reads per day (99% daily read success) • 20 meter failures per day (0.5% annual failure rate) • 10,000 data changes per day • >30,000,000 meter reads per day

10. All MDM Systems are NOT created equal All MDM Systems will receive, store and VEE data from AMI systems and deliver for cycle billing But, an MDMS should: Completely manage the AMI system (configuration, command/control, on-demand reads, etc.) Support unique business rules of each application (billing, outage, etc) Identify exceptions & automatically trigger resolution processes Automatically synchronize data from multiple systems of record Support the entire business process, not just supply data Minimize process build/change within legacy environment Lowest Total Cost of Ownership

11. What should MDM do? • Single interface to all AMI systems (provision, read, control) • Process and store valid and complete interval and billing determinant data • Present billing determinants (scheduled and adhoc) to the billing system • Support the AMI operations • Analyze meter reading data and identify issues • Identify events and automatically forward work or information to enterprise systems • Aggregate and/or transform metering data into information for enterprise systems and users • Proactively and on-request send data to enterprise systems and web

12. Why do you need MDM? • Simplify AMI to the enterprise • Reduce load on CIS • Scale! • Analyze the large amounts of data provided by AMI • Automation of data handling and business processes • Manage all the new processes related to AMI • Meet the future changes enabled by AMI

13. AMI & MDM Data Collection Head-End Meter Data Mgmt System (MDM) Utility Integration Bus Comm Meter Communication Network SAP Comm Meter Comm Meter GIS OMS Data Collection Head-End Comm Meter Communication Network WMIS Comm Meter Comm Meter AMI Meter Integrated orRetrofitted Register AMI Network Communication & Data Collection Enterprise Integration MDMS

14. Customer Service Operations Move In/Out On-Demand Meter Read Service Connect/Disconnect Meter Read Data Quality Energy Diversion Identification Data VEE Interval Data Framing Customer Programs Mass Market Demand Response Web Data Access Billing Options and Tariffs Home Area Networks (HAN) (e.g. Smart Thermostats, in home devices) Distribution Operations Planning & Programs Outage Event Processing Restoration Verification Transformer Load Monitoring Metering Operations AMI Asset Management Meters, Communications Modules, Network Nodes Meter O&M Management AMI Installation Management AMI Diagnostics & Error Flag Management Delivering the Full Value of AMI MDM helps utilities maximize the value of their AMI investments thru benefits realization and minimizing AMI lifecycle costs

15. Supporting Demand Response • Dynamic load situations will drive more real-time needs: • Interval data collected, validated and displayed every interval • Real-time update of AMI system or mass on-demand reads • Scale and performance drivers • Customer owned and managed energy resources • Support for distribution grid operators • Support for settlement process • Flexibility to meet demands of time-variable pricing • HAN vision • Smart appliances can trade load curtailment in the market This means: More energy data available to make near real-timedecisions

16. Where is MDM going? • More focus on interval data handling • Summarization and Aggregation for the various users • Customer presentation and other systems need complete data every day (NOT, just on billing cycle) • Billing based on “usage” rather than “register reads” • More business process management rather than data management • More business process automation • More users of AMI data • Web presentation • Outage • Load research • Distribution • Demand response and home area network (HAN) • Tracking of devices, programs and security by participant • Asset management

17. Business process questions raised by MDM • Where do you? • Monitor/troubleshoot meter reading problems • Monitor/troubleshoot meter installation/provisioning issues • Monitor AMI network performance • Manage AMI network installation and maintenance • What happens if the AMI network element IS a meter? • Issue trouble tickets and work orders • Track service history • Resolve billing issues • What does the organization look like? • Who “owns” MDMS? • MDMS operations vs. AMI operations • Which information system is the SOR? • What is the role of asset management?

18. Now, “What is MDM?” An MDM will: • Collect, Store, Process and Deliver Reads • Provision and Configure AMI and HAN • Analyze Meter Reading and Meter Data • Collect, Store, Analyze and Forward Events • Distribute read and event data • Identify and resolve exceptions • Issue and track AMI control operations • Synchronize with other systems • And, someone/some system still has to: • Plan, manage, track AMI installation • Advanced data analysis • Manage the meter, AMI network and HAN assets • Aggregation and processing for settlement • Presentation of data - internally and externally • Reporting - dashboard and detail

19. Summary: An MDM should… • Process data in real-time and make it usable/available immediately • Store and maintain usage data repository • Normalize and automate business processes across differing functions and AMI system capabilities • Provide standards-based interfaces for enterprise service consumers • Compliment existing systems and enable business benefits w/o forklift upgrades • Support all aspects of AMI operations with a composite view of service level management and auditable service history

20. Thank You - eMeter eMeter Background & Qualifications • Founded in Silicon Valley in 1999 by original Cellnet executive group with nearly two decades experience in advanced meters • Leader in Advanced Metering Information Systems (AMIS) • Meter Data Management (MDM) • AMI-related Business Process Management (BPM) • Integration platform linking AMI systems to utility legacy systems • Vendor-neutral technology and business strategy Business Focus on Software & Services Supporting AMI • EnergyIP™ software • License • Implementation services • Software support and maintenance services • Software commercially available and in production • Strategic consulting on AMI and mass market demand response

21. Questions Anthony Hawkins alhawkins@cpsenergy.com 210.353-3379