PR50121_07 Retail Business Processes (RBP) Project Update

1. PR50121_07 Retail Business Processes (RBP)Project Update A Sub-project of the Service Oriented Architecture (SOA) Initiative Retail Market Subcommittee Meeting

2. Background • Objectives • Goal is to replace current SeeBeyond Retail Components with TIBCO EAI components to deliver a technology and framework improved scalability, reliability, stability & maintainability. RBP is one of 8 SOA Subprojects to replace SeeBeyond. • Drivers • Minimize or reduce operating failures produced from current SeeBeyond Application and Architecture. • Reduce maintenance costs associated with up-keep of SeeBeyond Application and Architecture. • Dependencies • PR50025 – Enhance ESIID Look Up on TML GUI has cross-impact with Retail TML Functions • PR50121_08 EndPoint Services has dependency with RBP as built on same framework and need schedule to stay in synch. • PR50059 Siebel Transition to ODS has dependency on RBP DDLs • PR50060 EIF Transition to ODS has dependency on RBP DDLs PR50121_07 RBP PPL Source: ERCOT Priority: 1.0 Rank: .08 Budget: $1-3M Program Area: RO

3. Project Status • Project Status – Currently on target for Schedule, Scope, and budget • Project Phases • Initiation – Completed 08/01/2005 • Planning – Complete 05/08/2006 • Execution • Go-Live – 12/10/2006 weekend • Stabilization effort – 02/09/2007 • Closing – Target to complete February 2007 • Recent Activities As of 11/29/2006 • Core UAT Completed • Submit Final Market Notice • Completed Initial Technical Walk-thru • Next Steps • Continue Delta Siebel Data Conversion every weekend until Complete • Continue Delta EIF Data Conversion every weekend until complete • Continue Performance Load Testing • Final Technical Walk-thru 12/1/2006 PR50121_07 RBP PPL Source: ERCOT Priority: 1.0 Rank: .08 Budget: $1-3M Program Area: RO

4. Milestones • Requirements (pens down) – Completed April 12, 2006 • Design (internal document) – Completed July 14, 2006 • Build – Completed July 28, 2006 for Core Components • Internal Testing – Target Completion Date of December 1, 2006 • Internal Training – Target completion of December 12/1/2006 (updated) • Production (Go live) – Weekend December 10, 2006 **Code Migration, Data Conversion, and Production Verification PR50121_07 RBP PPL Source: ERCOT Priority: 1.0 Rank: .08 Budget: $1-3M Program Area: RO

5. Testing Status • Testing Schedule • Transaction Processing: Starts 08/28 - 100% complete (approx. 600 scripts) • Retail TML: Starts 10/02 - 100% (approx. 50 scripts) • Reprocessing: Starts 10/02 - 75% (approx. 70 scripts) • ETS Testing: Starts 10/02 - 83% (approx. 60 scripts) • Load/Performance Testing: (Rescheduled) Starts 11/22 - 90% • Monitoring Testing: Starts 11/13 – 90% • Defect Status (182 total to date as of 11/29/2006) • Code – 89 Only 74 of those have been TIBCO • Configuration – 25 • Environment – 42 • Invalid – 24 • Unknown (Under Review) – 2 PR50121_07 RBP PPL Source: ERCOT Priority: 1.0 Rank: .08 Budget: $1-3M Program Area: RO

6. Implementation Weekend • RMS approval for SLA exception Migration Weekend DATE AFFECTED:  7:00 AM Friday, December 8, 2006 to 11:30 PM Sunday, December 10, 2006 Additional Information: • All transactions received by ERCOT will be held at NAESB.  Market Participants are encouraged to limit transaction submission during this timeframe to normal transaction processing volumes.  (ie. no annual validation).   *** NAESB will be offline from 8:00 AM to 9:00 AM Saturday, December 9, 2006 for a server reboot.  Transactions WILL NOT be accepted by ERCOT while NAESB is offline.  Market Participants should not submit transactions during this time. *** •  867 Transactions will NOT be forwarded during the outage weekend. • 997 Functional Acknowledgements will NOT be sent during the outage weekend. • Cancel/Notification batch process may run after 6AM on Monday, 12/11/2006. (if rollback) PR50121_07 RBP PPL Source: ERCOT Priority: 1.0 Rank: .08 Budget: $1-3M Program Area: RO

7. Implementation Continued • MarkeTrak will not be available during the outage weekend. • Retail Components of TML and API will NOT be available including: • Report Explorer / Search Reports (Includes statements and extracts) • Find ESI ID • Find Transaction • Submit Transactions • USA Functionalities • EXTRACTS • Siebel Service Order Extract will not run during the migration.  Full extract received on Tuesday, 12/12/2006 will contain all Siebel Service Order history, including data from Friday thru Monday. • Data Conversion Load Mitigation: • Reduce the outage to the Market by ERCOT Go-Live with 3-6 months of 2006 descending transactional data (previously stored in Seebeyond TCH Database) • Phase in remaining years on following weekends. ETC by late December 2006 / January 2007 • Retail TML and API Find Transaction will be limited to Data Conversion Load

8. Implementation Status Communication Migration Checkpoint Emails: • Friday 12/8/2006 - Notification all transactions have cleared • Saturday 12/9/2006 at approximately 8:00 PM – Migration Status email • Sunday 12/10/2006 4:00 PM – Go/No Go Decision **Conference Bridge** • Conference DN:     3822 (outside ERCOT dial 512-248-3822) • Conference Password:  1307 • Sunday 12/10/2006 – Notice that migration Rolled Back or Completed

9. Questions / Contact Adam D. Martinez Mgr, Market Operations Divisional Projects Organization ERCOT (512) 248-3883 amartinez@ercot.com Hope Parrish PM, Market Operations Divisional Projects Organization ERCOT (512) 248-6522 hparrish@ercot.com