Leading the Way in Electricity SM Enterprise Information

Leading the Way in Electricity SM Enterprise Information Management Vision & Strategy Governance Architecture Delivery SOUTHERN CALIFORNIA EDISON

Leading the Way in Electricity SM Guiding Principles • Minimize the disruption to current efforts • Ensure all efforts are going in the same direction • Ensure consistency and resusability • Minimize redundancy (duplicate efforts) What is EIM? EIM is an enterprise program that plans for, manages, structures, and provides information assets (structured and unstructured) to maximize the value of information for decision making, operations, and corporate strategy. Create an operating model for SCE that: obtained, analyzed, and acted upon by all stakeholders • Serves as the authoritative source for services, shared components, and practices Vision & Strategy Governance Organization Long Term: • Define Future State Roadmap – focuses on creating an environment that facilitates collaboration and reuse. • Expand & Re-brand the BICC – focuses on creating a partnership between SCE Business Units and IT&BI that maximizes the EIM investment. • Define and institutionalize data governance across the enterprise • Extend EIM from a BI-focus to include Information and Knowledge management capabilities. • Optimizes the use of information created, Vision Governance Approach Vision & Strategy Architecture Influences Process Delivery Metrics Current State Master Plan Sets Direction Framework Target State Gartner’s Component Model • Enable Business Units to access their data in a timely and • Utilize Gartner’s component model as a framework for organizing and building out our EIM capability • Measure progress against the Gartner’s EIM Maturity Model cost-effective while protecting SCE’s information assets. • Establish the appropriate foundation (people, process, technology) that balances efficient Business Unit self service with cost-effective IT&BI rendered services. • Expand re-brand the role of the Business Intelligence Competency Center to support SCE’s EIM requirements. 2 Short Term: • Quick Wins – focuses on the delivery of high priority Business Unit requests. • Operational Improvements – focuses on improving IT&BI’s delivery capability. SOUTHERN CALIFORNIA EDISON

Leading the Way in Electricity SM High Level Engagement Model CSBU TDBU Least Complex BI OS IT&BI Power Systems GBU Corporate Center Data and Information Services Ad-hoc Reporting Highly Formatted • Web Intelligence (Corp/Regulatory) Reporting • Explorer • Crystal Reports OLAP Analysis • BEx Dashboards • Xcelsius Most Complex All BI Tools Predictive Modeling Advanced Ad-hoc • Predictive & Analytics Workbench • SAS • • Data Mgmt Data Quality/Integrity Data Security Data Movement Semantics Mgmt Master Data Mgmt Data Warehousing Data Lifecycle Mgmt Provide Increasing Skills Required BICC Enterprise Information Governance Self Service* BICC Rendered Services Data and Information Services Foundation Vision & Strategy Governance EIM Core Processes Organization Tools & Technologies Build & Maintain * BICC will provide upon request 3 SOUTHERN CALIFORNIA EDISON

Leading the Way in Electricity SM EIM Framework Baselined Vision & Strategy Primary Focus Governance EIM Core Processes Addressed as needed to support Primary Focus areas Organization Data Quality Vision Sponsorship CSFs & KPIs Data Integrity Data Security & Protection Mission Stewardship Data Lifecycle Management Structure (Virtual, Hybrid, …) Strategy Semantics Management Information Architecture Blueprint Management Roles & Responsibilities Technologies (DBMS, CMS, ETL, EAI, EII, Data Modeling, BI/DW, Collaboration) Functional Services Knowledgebase & Repositories Business Value & Relationship Management Standards & Best Practices Data Movement Policies, Principles & Tenets Tools & Technologies Database Management Goals & Objectives Alignment Master Data Management Information Services (A&R) Value Propositions Structure Services & Support Source: Xtensible Solutions See Backup for Details 4 SOUTHERN CALIFORNIA EDISON

Leading the Way in Electricity SM Select Projects in EIM Footprint Primary Focus Addressed as needed to support Primary Focus areas EIM Core Processes Governance Data Quality Sponsorship Enterprise Data Governance (AG#32) Data Governance for Edison Smart Connect BW Security Redesign Stewardship SAP Data Retention & Archiving CSBU Data Strategy Data Governance for Dynamic Pricing Data Governance for GIS (TDBU/OSBU) Customer Confidential Data Policies, Principles & Tenets Foundation for Metadata Services (AG#22, m 3) Business Analytics (AG#12) Data Governance for Power Supply Alignment Data Services/EDLC Alignment Std Enterprise Launching Page for Reporting Supply Management/AP Dashboards Structure Std Enterprise O&M Reporting KPI Reporting Dashboard for Employee Onboarding (AG#31 m 2) Tools & Technologies Customer Address Quality Data Integrity Data Security & Protection Data Lifecycle Management Data Movement Semantics Management Database Management Master Data Management Information Services (A&R) Services & Support Information Architecture Blueprint Management Edison Smart. Connect Data Warehouse (AG#1 m 4) BI Security SAP Data Services GIS-specific Enterprise Data Model (AG#24 m 1) GIS Services & Metadata Management Fleet Performance Management Dashboard & Reporting IT&BI Performance Reporting to BUs Technologies (DBMS, CMS, ETL, EAI, EII, Data Modeling, BI/DW, Collaboration) Optimize Business Objects Enterprise environment setup and Integration with BW RM/DM (Open Text) Knowledgebase & Repositories Enterprise Performance Management Dashboard (OSBU, TDBU, IT&BI) CRM Reporting Microstrategy Conversion Standards & Best Practices Enterprise Content Management Platform Knowledge Transfer Matrix (SONGS) SONGS Pre-outage and Outage reporting for Work Mgmt & Finance Edison Smart. Connect Reporting 2011 IT&BI Achievement Goals (see next slide) 5 SOUTHERN CALIFORNIA EDISON

Leading the Way in Electricity SM 2011 IT&BI AGs in EIM Footprint Name-Description 1. Edison Smart. Connect Program Leadership Team Goal Leads Div/ Dept D Erickson A Hutchison Dept H Freeman M Peacore Div Expected Completion Measure Leads Complete Data Warehouse Stage 2 implementation. 4 th Qtr Nu Pho Identify Business Objects (BOBJ) project initiatives in each one of the 5 process areas: Finance, HR, Operations Support, EAM TDBU/Non-Energy, and EAM Generation. 1 st Qtr M Peacore Successful implementation of at least one of the identified project initiatives in each one of the process areas. 4 th Qtr M Peacore Measure of Success (CSBU) - Support the Edison Smart. Connect Program by managing systems, operations, and technology to achieve billing and customer satisfaction target 12. Business Analytics Implementation (SCE) Establish Business Objects tools and processes as the standard foundation for SCE analytics and reporting. 22. Advance Enterprise Architecture G Ahwah S Ramaswamy Div Implement foundation for Metadata services. Complete requirements gathering, conceptual operating models, high level processes, and understand available tools. Select platform and operationalize services to enable enterprise Metadata management. 4 th Qtr R Ruiz J Horstman G Ahwah M Pinter Div Develop GIS-specific enterprise data model leveraging key project work. 2 nd Qtr S Ramaswamy D Walsh H Freeman M Mehta Div Implement KPI reporting dashboard for tracking onboarding progress. 2 nd Qtr M Mehta R Bourland M Peacore Div Acceptance of data governance framework by SCE Business Unit leaders. 4 th Qtr M Peacore Successfully implement data governance projects for two data families for business units such as TDBU and CSBU. 4 th Qtr M Peacore and Services - Advance Enterprise Architecture and Services to support Data Management, SOA business process management, Content Management, and Cloud Computing opportunities. 24. Geographic Information System (GIS) - Extend existing, but limited, GIS services to an enterprise GIS Service 31. Employee Onboarding – Implement technology solution to improve the employee onboarding process 32. Implement Enterprise Data Governance - Support Business units in the implementation of Data Governance by providing frameworks and processes 6 SOUTHERN CALIFORNIA EDISON

Leading the Way in Electricity SM EIM Priorities HIGH MEDIUM LOW Information Services (A&R) Data Security & Protection Master Data Management Data Governance Data Quality Database Management Semantics Management Data Integrity Data Movement Data Lifecycle Mgmt Services & Support Information Architecture Organization (Roles & Responsibilities, Structure, KPIs, Org Readiness) Tools & Technologies Define, Plan, Implement Define, High Level Plan Define Prioritization Scoring EIM Foundational Importance to Business Current Maturity Level Data Governance High Low Semantics Management High Low Data Quality Low Medium Database Management Medium Low High Data Integrity Low Medium Master Data Management Medium Low Medium High Information Services (A&R) High Medium Data Lifecycle Mgmt Low Medium High Services & Support High Medium Data Movement High Medium Information Architecture High Medium Low Component Data Security & Protection Component 7 SOUTHERN CALIFORNIA EDISON

Leading the Way in Electricity SM Back up 8 SOUTHERN CALIFORNIA EDISON

Leading the Way in Electricity SM Gartner’s Maturity Model EIM Components Level 0 Unaware Vision & Strategy Org makes strategic decisions without adequate information Value of information Power of information is realized & shared on understood but strategy cross-functional is still project oriented projects No governance security or accountability Efforts to document the risks associated with uncontrolled information assets have begun Governance Level 1 Aware Level 2 Reactive Org formalizes objectives for information sharing to achieve operational efficiency Level 3 Proactive Level 4 Managed Level 5 Effective Senior Mgt. recognizes enterprise information sharing as critical Senior management embraces EIM then markets and communicates it Senior management sees information as a competitive advantage and exploits it Gov council(s) and their policies adhered in parts Governance councils 1 and steering committees resolve problems pertaining to cross-functional information Monitoring and enforcement of information governance is automated throughout the enterprise 2 Architecture Delivery No model to share enterprise information Information is fragmented & inconsistent across diff apps Normalized information silos through consolidation Recognized need for common standards, tools and models to use skills more broadly and to reuse project materials Locally maintained data § Seamless enterprise architecture guidance • Integrated master § Localized integration Some information model align to a centralized § Largely point-to-point needs met using the interfaces Data redundancy statistics show significant overlaps in master data assets. Standards for information sharing are documented and agreed upon enterprise approach EIM becomes part of the process for planning, designing and developing applications information flows data domains EIM group coordinates all information management efforts 1 We recommend a Target level 4 in order to maintain the balance between BU independence with enterprise needs 2 We recommend a Target level 4 in order to maintain the balance between BU self-service and appropriate centralized support SCE Current Level SCE Target Level 9 Assessment by Cognizant Technologies SOUTHERN CALIFORNIA EDISON

Leading the Way in Electricity SM Three Pillars of Accountability EIM “Orchestra Leader” Robb Bourland Guiding Principles • Minimize the disruption to current efforts Functional Architecture Technical Lead M. Peacore Lead J. Kelly Lead M. Provenzano • Consultation, • • planning & client service Requirements gathering & functional solution design Functional configuration Process and governance Integration with BU EIM initiatives & roadmap • Architectural solution • • • design Integration with Enterprise Architecture Cross functional impact assessment Tool capabilities Process and governance BU level data architecture • Technical design • Technical build • System maintenance & operation • Patch management • Custodial work (capacity, archival, integrity) • Data security • Process and governance • Tool implementation & support 10 • Ensure all efforts are going in the same direction • Ensure consistency and resusability • Minimize redundancy (duplicate efforts) SOUTHERN CALIFORNIA EDISON