Mass Markets Energy

1
Mass Markets Energy Weekly Project Status Update
May 19, 2009
2
Project Status Capital Projects
3
8169 NGSS Release IV
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
04/01/09 04/01/09 04/09/09 Kick Off Comp
04/20/09 TBD Analysis Design Y
04/09/09 TBD Project Plan Y
04/23/09 TBD Build Y
Test Y
Implement Y
Post Production Y
PM Julie Chin
complete project analysis conducted at start of
project
Risk/Issue Mitigation Status Owner
Operations resources have been committed to other projects which may conflict with R-IV activities Projects have been obtained and start/end dates are being identified, and assessed for impact analysis. Pending Mike Rieck
Allegro format impacted by reorg, and potential sizing and timing unknown. Theresa Wilson is speaking directly with Shelley Lineham in EMG to explore alternatives. Attempting to obtain cost and sizing. Pending Theresa Wilson Trevor Mah
ATCO has not finalized format for submission of profile class and is causing impacts to design and development of related components Theresa Wilson is working with ATCO to obtain ETA files manually reformatted in the interim Pending Theresa Wilson
4
8226 US North Credit Card Program
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
04/13/09 04/29/09 04/29/09 Bus. Requirements Comp
04/30/09 05/08/09 05/08/09 Analysis Design Comp
TBD TBD Project Plan
TBD TBD Build
TBD TBD Test
06/21/09 06/21/09 Implement R
TBD TBD Post Production
PM Ron Marano
Risk/Issue Mitigation Status Owner
Awaiting result of technical due diligence regarding the vendor recommended solutions. Only then can we proceed with engaging Citibank and Metavante for an implementation resource and plan. Technical due diligence meetings to be done. Meeting tentatively scheduled for 05/20/09 Architecture/Security

5
8226 US North Credit Card Program
Risk/Issue Mitigation Status Owner
Metavante does not want to open up any new projects with DE pending the following. - Full contract execution which is dependent of the result of the technical review. - Current Texas initiative has missed multiple deliverable timelines thus extending project resource commitments at Citi and Metavante far beyond what they should be. They want to see progress on these points by May 29 which is a key deliverable date. Facilitate full contract execution. Clarify Citi/Metavante resource capacity as this project should not have any technical dependency on other DE projects. Treasury

6
I8301 Enbridge CIS Upgrade
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
11/10/08 12/5/09 2/18/09 Bus. Requirements Comp
11/10/08 1/15/09 1/15/09 Analysis Design Comp
1/19/09 3/5/09 3/5/09 Project Plan Comp
1/16/09 4/14/09 4/14/09 Build Comp
2/23/09 5/19/09 Test G
6/12/09 6/12/09 Sept/09 Implement G
6/13/09 7/12/09 Oct/09 Post Production G
PM Joanna Moyssidis
Risk/Issue Mitigation Status Owner


7
I8301 EGD Gas Accounting Work stream
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
11/10/08 12/5/09 3/19/09 Bus. Requirements Comp
4/6/09 4/17/09 4/17/09 Analysis Design Comp
4/20/09 4/22/09 4/22/09 Project Plan Comp
4/20/09 5/19/09 Build G
5/20/09 6/10/09 Test G
6/12/09 6/12/09 Sept/09 Implement G
6/13/09 7/12/09 Oct/09 Post Production G
PM Joanna Moyssidis
Risk/Issue Mitigation Status Owner


8
9010 Incumbent Billing Audit (Regulatory) Changes
Phase 1
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
03/24/09 04/29/09 04/29/09 Bus. Requirements Comp
3/24/09 05/15/09 Analysis Design G
05/08/09 05/18/09 Project Plan G
Build
Test
Implement
Post Production
PM John Clitherow
Risk/Issue Mitigation Status Owner
Risk Regulus is a part of the transition work from AD to DE which may impact resource availability Work with Regulus to complete Billing audit changes within requested timeframe Requested resources to meet needs of this project John Clitherow
9
8199 Texas LIDA Process CCR1
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
04/28/09 04/28/09 05/19/09 Bus. Requirements Comp
05/12/09 05/15/09 Analysis Design R
05/15/09 05/15/09 Project Plan R
Build
Test
Implement
Post Production
PM Sheri Luong
Risk/Issue Mitigation Status Owner
Issue - Additional requirements for another LIDA report Finalize new requirements Paul Morrison / Nelson Switzer

10
I9086 Mass Markets Remediation Texas Organic
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
2/23/09 Q2 Bus. Requirements
Q2 Analysis Design
June 1,09 Integrated project plan
Q3 Build
Q3 Test
Q4 Implement
Q4 Post Production
PM Craig Harper
Risk/Issue Mitigation Status Owner


11
I9084 Corporate Customer Dashboard pilot
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
3/1/2009 4/31/2009 Pilot initiation
6/15/2009 Integrated plan
5/25/2009 8/1/2009 Pilot execution
8/1/2009 8/31/2009 Pilot Analysis
9/1/2009 Project initiation



PM Craig Harper
Risk/Issue Mitigation Status Owner


12
6095 Risk Segmentation Phase 3
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
11/03/08 01/02/09 01/02/09 Bus. Requirements Comp
01/05/09 02/17/09 02/17/09 Analysis Design Comp
12/16/08 01/16/08 01/16/08 Project Plan Comp
02/18/09 03/13/09 03/13/09 Build Comp
03/16/09 06/12/09 05/15/09 Test G
06/12/09 06/25/09 06/01/09 Implement G
06/25/09 08/25/09 Post Production G
PM Komal Karra
13
6095 Risk Segmentation Phase 3
Testing Milestones
Milestone Start End G/Y/R
Timeline Config Cycle 1 (SIT/UAT) 02/19/09 03/03/09 Comp
Timeline Config Cycle 2 (SIT/UAT) 03/04/09 03/13/09 Comp
SIT Cycle 1 03/16/09 04/03/09 Comp
SIT Cycle 2 04/06/09 05/13/09 G
UAT Cycle 1 04/06/09 05/13/09 G
UAT Data Prep 04/06/09 04/20/09 Comp
Timeline Assignment 04/20/09 4/24/09 Comp
DPP, EPP, LPC, Credit Hold, Other Scenarios 4/27/09 5/13/09 G
UAT Cycle 2 05/14/09 06/12/09 G
Test Execution Summary

• Completed Last Week
• Setup data to ensure all customers are assigned
  to a timeline
• Test timeline assignment change scenarios
• Scheduled This Week
• Test DPP, EPP, LPC, Credit Hold, Other Scenarios.

TEST CASES TEST CASES TEST CASES TEST CASES VARIANCES (Code/Config Related) VARIANCES (Code/Config Related)
Testing Cycle Total (New) Started Passed Failed Open Variances Variances Resolved
Peace Configuration SIT/UAT Cycle 1 94 (94) 94 94 0 0 1
Peace Configuration SIT/UAT Cycle 2 110 (16) 10 110 0 0 0
SIT Cycle 1 278 (278) 278 278 0 0 0
SIT Cycle 2 One-time 151 (151) 84 84 0 0 0
SIT Cycle 2 Re-occurring 372 (0) 254 254 0 0 2
UAT Cycle 1 556 (556) 456 456 0 0 2
UAT Cycle 2 556 (0) - - - - -
14
I9126 Vectren Market Entry
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
TBD TBD Bus. Requirements
TBD TBD Analysis Design
TBD TBD Project Plan
TBD TBD Build
TBD TBD Test
TBD TBD Implement
TBD TBD Post Production
PM Ron Marano
Risk/Issue Mitigation Status Owner
VECTREN currently is undergoing some system enhancements. Our requirements will be dependent on the result of such enhancements as we receive the final version of the EDI data dictionaries and processes. This has the potential of pushing the Market Entry Date. Tentative Market Entry Date is end of August. Regular follow-ups with VECTREN/ESG regarding final data dictionaries and processes. Open Utility Relations manager / Operations

15
I9076 - Ranger Phase 2 - DEB/ERM Integration
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
2/25/09 2/25/09 Bus. Requirements Comp
3/27/09 5/8/09 Analysis Design G
5/4/09 5/5/09 Project Plan G
TBD TBD Build
TBD TBD Test
TBD TBD Implement
TBD TBD Post Production
PM Yomi Fashoro
Risk/Issue Mitigation Status Owner
ERM billing and Load Profile shapes get overwritten when shapes change making it impossible to accurately validate ERM data in Ranger as historical shape data is not available. Load Only deployment months ERM data and start keeping historical data log as of that month. Load all data and finance to agree to accept data as is with no validation. Meeting scheduled 5/19 to discuss options listed with Finance. Yomi Fashoro

16
Project Status Life Cycle
17
9040 CR-2009-13 Niagara/Pen West Merger
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
04/06/09 04/06/09 04/06/09 Kick off Meeting Comp
04/07/09 04/13/09 04/13/09 Analysis Design Comp
04/07/09 04/20/09 04/20/09 Project Plan Comp
04/14/09 04/17/09 04/17/09 Build Comp
04/20/09 05/11/09 05/15/09 Test Comp
06/28/09 06/28/09 TBD Implement G
06/29/09 07/10/09 TBD Post Production G
PM Edgar Torres
Risk/Issue Mitigation Status Owner
The implementation date has not been set up by the Utilities. End of May has been proposed for implementation Code modification will be done based on initial implementation date of April 27, 2009 04/17/2009 - Kristine Innes has notified the tentatively implementation date of June 28, receiving CCIs on June 29. Closed Kristine Innes
Conversations are held to define if Niagara OEB license number or a new License number will be used. Code design will be based on the assumption that a new OEB license number will be used. 04/17/2009- Kristine Innes has notified the amalgamation will be using NF OEB license number. Closed Kristine Innes
18
9040 CR-2009-18 Upload Tool
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
05/08/09 05/08/09 05/08/09 Kick off Meeting Comp
05/12/09 05/21/09 TBD Analysis Design G
05/12/09 TBD TBD Project Plan W
TBD TBD TBD Build W
TBD TBD TBD Test W
TBD TBD TBD Implement W
TBD TBD TBD Post Production W
PM Rami Ayyad
Risk/Issue Mitigation Status Owner


19
9040 CR-2009-02 Alberta Evergreen Renewals
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
04/15/09 04/15/09 04/14/09 Kick off Meeting Comp
04/16/09 04/22/09 04/24/09 Requirements Comp
04/27/09 05/08/09 05/08/09 Analysis Design Comp
04/27/09 05/08/09 05/11/09 Project Plan Comp
05/04/09 05/15/09 TBD Build Y
05/19/09 05/28/09 TBD Test G
05/31/09 05/31/09 TBD Implement G
06/01/09 06/05/09 TBD Post Production G
PM Rami Ayyad
Risk/Issue Mitigation Status Owner
Business has notified that ideal implementation date is May 27,2009 Divide scope Create manual processes Implement different phases 4/17/09 Meeting to be held to discuss mandatory requirements on April 27,2009 . Closed Team
Involvement of I-tek during the testing Notifiy I-tek 5/8/09 Business will decide if will implement without I-Tek involvement
20
8022 CCR 3 Automated Rate Changes and Bill
Messaging
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
4/13/09 4/15/09 4/15/09 Bus. Requirements Comp
4/16/09 5/18/09 Analysis Design Y
5/18/09 5/29/09 Project Plan G
Build
Test
Implement
Post Production
PM Karen Clarke
Risk/Issue Mitigation Status Owner


21
7046 Remittance Automation Phase 2B One Time
Payments
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
9/16/08 9/16/08 9/16/08 Bus. Requirements Comp
1/13/09 2/9/09 2/26/09 Analysis Design Comp
10/31/08 2/9/09 2/9/09 Project Plan Comp
2/28/09 4/17/09 5/15/09 Build R
4/6/09 5/14/09 6/15/09 Test R
5/15/09 5/28/09 6/25/09 Implement R
5/29/09 6/28/09 8/24/09 Post Production
PM John Clitherow
Risk/Issue Mitigation Status Owner
Issue DE/ Citibank contract not signed. Complete contract signatures Contract updates by Citibank sent to DE legal Mike Beck
Issue - Need Core IS tasks for completing Recurring Credit Card (RCC) payment processing Obtain task sizings from Core IS. Sizings and estimates requested 4/6/09. Cost estimates received 4/15, still need tasks for IPP Yuliy Ruzin
Risk Metavante requires final branding changes, if any, by 5/29 Complete branding changes and sign off on branding With John Mangieri for completion. New date by 5/22 John Mangieri

22
7046 Remittance Automation Phase 2B
Risk/Issue Mitigation Status Owner
Issue Because DE/Citi contract not signed, live Merchant IDs can not be given to Citi/Metavante for testing Complete sign-off of DE/Citi contract for First Data DE/Citi contract being vetted, with Citibank for final approval Mike Beck
23
7046 phase 4 Electronic Remittance Services for
Western Union, 3rd Party Collection Agencies, and
other non-contracted payment vendors
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
04/16/09 Bus. Requirements
Analysis Design
Project Plan
Build
Test
Implement
Post Production
PM John Clitherow
Risk/Issue Mitigation Status Owner


24
8177 Exceptions in Market Solutions
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
10/24/08 3/27/09 3/27/09 Bus. Requirements Comp
3/27/09 5/29/08 Analysis Design G
5/15/09 5/19/09 Project Plan G
3/27/09 6/10/09 Build G
5/19/09 TBD Test G
TBD Implement G
Post Production G
PM Nancy Strickland
Risk/Issue Mitigation Status Owner
Testing Environment being used for 2.1, new code/activities may interrupt 2.1 timeline. (new test cases and dependencies) Wait for 2.1 stability to schedule Exotran testing. Include 2.1 changes in to test plan cases if post 2.1 testing/go live. Put project on hold. Closed, May 19th Concurrent testing with 2.1 approved by Mark Mark Boyd (manages Exotran test environment)
Resource Constraints for the Exotran related Tasks Plan start date when resources available, request prioritization of projects by business Closed Program Management
25
9024 PUCT Information Disclosure Rule
Implementation
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
3/9/09 4/1/09 5/8/09 Bus. Requirements Comp
3/10/09 TBD Analysis Design
Project Plan
Build
Test
Implement
Post Production
PM Karen Clarke
Risk/Issue Mitigation Status Owner
Issue The PUC gave options for contract expiration notification and contract document fulfillment. The options have been vetted with the vendors and developers so options can be presented to the leadership team. A decision was agreed to on May 8. Stacy Noel

26
I9111 Electronic Bill Presentment
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
04/06/09 5/1/09 Bus. Requirements
04/06/09 Analysis Design
05/08/09 Project Plan
Build
Test
Implement
Post Production
PM John Clitherow
Risk/Issue Mitigation Status Owner


27
Project Status Texas Bad Debt Life Cycle
28
9026 Collection Fee (Organic)
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
02/01/09 02/25/09 Bus. Requirements Comp
04/20/09 05/11/09 05/01/09 Analysis Design Comp
03/30/09 04/10/09 Project Plan Comp
05/11/09 05/22/09 Build G
05/14/09 06/10/09 Test G
06/08/09 06/18/09 Implement G
06/19/09 07/19/09 Post Production G
PM Komal Karra
Risk/Issue Mitigation Status Owner

29
9052-(II)Require Deposit Prior To Enrollment
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
4/08/09 04/21/09 5/13/09 Bus. Requirements R
4/07/09 4/20/09 5/29/09 Analysis Design G
5/29/09 6/5/09 Project Plan G
6/08/09 Build G
Test G
Implement G
Post Production G
PM Nancy Strickland
Risk Risk Mitigation Status Risk Owner
Dependency for bill print vendor changes in 9010 Work with 9010 resources, timeline Open Nancy Strickland
New Requirement risk of enrollment staking Analysis on downstream impacts, discovery, submit BRD for approval Open, new requirement needs approval Bruno Mariejeanne Guy Robinson Ken Zhu
30
9058 Collection Fee (Incumbent)
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
02/01/09 04/09/09 Bus. Requirements Comp
Analysis Design
5/4/09 5/12/09 Project Plan Y
Build
Test
Implement
Post Production
PM Komal Karra
Risk/Issue Mitigation Status Owner
The project plan is not complete, we are awaiting decision on whether the Incumbent DNP letter format should be changed (which will increase the effort). Original assumption was that we would only make verbiage changes to the letter. Obtain decision on whether both format and content of Incumbent DNP letter should change or only content. 5/18/09 Received estimates from Regulus. Issue closed. 5/15/09 Based on stakeholders feedback Regulus is estimating effort to change Incumbent DNP letter to match Organic DNP letter. 5/12/09 Awaiting decision from project stakeholders. Bruno Mariejeanne / Cheryl Mount
31
9053-Transfer of Service, Credit Check Prior to
Enrollment
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
4/08/09 4/22/09 5/15/09 Bus. Requirements R
5/15/09 5/29/09 Script changes G
5/29/09 6/10/09 Review/Approval of changes G
6/1/0909 6/2/09 Scheduling of training, G
6/9/09 6/25/09 Implementation of training to call center, G
PM Nancy Strickland
Issue Risk Mitigation Status Risk Owner
Business rules and requirements outstanding approval Request approval Open, new approach will be discussed for potential requirements updates Paul Morrison
Regulatory and Compliance constraints for additional deposit and existing customer rules Inform business of rules, request decision Add criteria to remove ineligible customers from deposit assessment In progress, business rules have been provided for approval. Bruno Jim
32
8065a Phase2-(I) Skip Trace Action
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
6/18/08 11/7/08 9/16/08 Bus. Requirements Comp
11/7/08 11/24/08 3/6/09 Analysis Design Comp
11/7/08 11/24/08 3/6/09 Project Plan Comp
3/06/09 3/2709 4/20/09 Build Comp
3/27/09 4/10/09 5/15/09 Test Comp
4/16/09 4/16/09 5/21/09 Implement G
4/16/09 4/16/09 6/21/09 Post Production G
PM Nancy Strickland
Risk Risk Mitigation Status Risk Owner
Vendor support (Dialer) Peace Data pulls approach discussion for next phase Open, meeting with stakeholders 5.12.09 Ken Zhu Carl Grossardt
33
8065c Skip Trace Actions for Organic
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
4/8/09 5/18/09 Bus. Requirements
Analysis Design
Project Plan
Build
Test
Implement
Post Production
PM John Clitherow
Risk/Issue Mitigation Status Owner


34
8081 Consolidate Payment Arrangements (Organic)
Major Milestones
Start PlannedEnd Actual or RevisedEnd Milestone G/Y/R
11/03/08 12/05/08 5/5/09 Bus. Requirements R
Analysis Design
Project Plan
Build
Test
Implement
Post Production
PM Nancy Strickland Transitioned 3.20.09
Risk/Issue Mitigation Status Owner
Requirements must be approved prior to estimations Requesting that the business approved the changes to the dialer requirements from 4.28.09 In review Bruno Mariejeanne, Ken Zhu