credit monitoring and management status tptf december 17, 2007
TRANSCRIPT
Credit Monitoring and Management Status
TPTF
December 17, 2007
Slide 2
Agenda
• Project Status– Release Approach
• CreditRisk Architecture• Planned Release Phases
– Current Status– Vendor Relations
• Where CMM Fits in Nodal & EDS
• Project Interactions with TPTF
Slide 3
Project Status – Release ApproachCredit Risk/CMM Architecture
Common Configurable Functionality for all ROME Customers
Custom Exposure /
Management FunctionalitySpecific to
ERCOT
CreditRisk DB Integration DB
•Counter-Party Maintenance•Financial Statement Reviews•Credit Rating•Credit Score•Credit Limits•Collateral Management•Workflows
•Calculate Current & Future Credit Exposure Calc•Calculate Average Daily Prices•Integration to Nodal Systems•Credit Reporting•ERCOT Specific ACL and Collateral Management•Default Analysis•Credit Analytics•Backcasting
Base Product Functionality Integration Layer Functionality
Slide 4
Project Team
Raj ChudgarProgram Director
Cheryl YagerERCOT TreasurerExecutive Sponsor
Sylvia ShiroyamaCMM PM
Vera WeberTest Manager
Dickey Triche ROME PM
Vanessa SpellsCredit Manager
Rizaldy ZapantaCredit Analyst
Srini SundhararajanSenior Financial
Analyst
Tom KeneyBusiness Systems
Analyst
Bill KasparIT Application
Support
S PabbisettyM Gaddam
R SomavarapuJ Motheral
D KomandlaG Hegedus
M. PoythressUI Designer / Test Engineer
David SwartzDBA
2 INT Test AutomationEngineers
5 ROME Developers
Vendor employeeERCOT ContractorERCOT employee Direct Report Matrix Report
Slide 5
Project Status – Release ApproachRelease Phases
1. Base Product Functionality (see prior architecture chart)
2. Custom Calculations
3. Nodal Integration – EDS 4 Requirements
4. Custom Management Functionality
5. Back-casting
Slide 6
Current Status – Part I
• Base Product Release – completed FAT 8/31/07
• Custom Calculation Release – in FAT (as of 12/12/07)
– 441 test scripts– 399 executed– 353 passed– 8 open: 2 sev 2, 4 sev 3, 2 sev 4– 15 ready for retest: 4 sev 1, 5 sev 2, 5 sev 3– 15 closed– 8 deferred: 1 sev 3, 5 sev 4, 2 sev 5– Expected completion w/ regression testing – 12/21/07
• Originally scheduled to complete 10/26/07– Complexity of calculations – Complexity of ensuring coverage in test scripts– Complexity of data preparation
Slide 7
FAT Statistics – Custom Calc Release
CMM Custom Calc Test Stats
0
50
100
150
200
250
300
350
400
450
500
11/7/
2007
11/9/
2007
11/11
/200
7
11/13
/200
7
11/15
/200
7
11/17
/200
7
11/19
/200
7
11/21
/200
7
11/23
/200
7
11/25
/200
7
11/27
/200
7
11/29
/200
7
12/1/
2007
12/3/
2007
12/5/
2007
12/7/
2007
12/9/
2007
12/11
/200
7
Time
#
Executed
Pass
Fail
Open
Closed
Deferred
Total
Slide 8
FAT Statistics – Base Product Release
* Remaining open defects were deferred to future releases
**
Base Product FAT
0
50
100
150
200
250
6/13
/2007
6/15
/2007
6/17
/2007
6/19
/2007
6/21
/2007
6/23
/2007
6/25
/2007
6/27
/2007
6/29
/2007
7/1/
2007
7/3/
2007
7/5/
2007
7/7/
2007
7/9/
2007
Time
#
Executed
Pass
Fail
Open
Closed
Total
*
Slide 9
Current Status – Part II
• Nodal Integration– Requirements
• Complete for CRR, S&B, Registration• In process for CSI/MMS, in concert with S&B
– Detail Design – in process for integration layer– FAT – target entry 1st quarter 2008 to match EDS drops
• Custom Management Functionality– Currently defining detailed specifications– Functionality deliveries through 2nd quarter 2008
• Back-Casting – 3rd quarter 2008
Slide 10
Vendor Relations
• Vendor –
• Excellent delivery record
• Responsive
• Within authorized budget
Slide 11
Interactions with Market ParticipantsDuring EDS 4
• Where MPs Will See CMM during Market Trials– Direct Visibility:
• ACL Postings via MIS - .pdf ACL reports • CRR Auction Credit Limit allocations• CRR Bilateral Trade Approval• DAM Bid Credit Limits
– Indirect Impact via inputs to Credit Calculations• CRR Inventory• S&B Settlements Statements, Invoices and Payments• DAM and RT Transactions
Slide 12
Where CMM Fits in Nodal & EDS4
Jan 08 May 08Apr 08Mar 08Feb 08 Oct 08Sept 08Aug 08Jul 08Jun 08
R8.1: CRR Auction
R9.1: DAM/RUC Submission Testing
R8.5: Disputes
R8.2: DAM Settlement Statements and DAM Invoices and other InvoicesEvolve from posting statements/invoices of mock data, to test data, to integrated EDS data.
R8.3: RTM Settlement Statements and RTM InvoicesEvolve from posting statements/invoices of mock data, to test data, to integrated EDS data.
R8.4: Verifiable Costs
R9.2: Outage Scheduler Data Submission and NMMS Network Model Upload
R9.5: Pre-Test for 168-hour Test
R9.4: Execute Day-Ahead, Adjustment Period, and Real-Time
Operations
R9.3: Initial DAM/RUC Execution
168-hr Test
SCED Running
ACE Calculation LFC by QSE LFC System-wide test
CRR Mock CRR Unscripted CRR Muli-month
Other Activities running outside of EDS4- (Bars below do not convey completion of formal EDS release- rather they reflect the cumulative integration of nodal functions)..
N/W Model CIM/Powerflow * NOMCR Production
R8.1: Credit Monitoring 2
4
Registration
1 3
6 7
8 9
EDW
CMM Interfaces
1: Creditworthiness 2: ACL3: CRR ACL4: Residual ACL 5: MP ACL Reports (MIS)6: DAM activity & prices7: RT activity & prices8&9: Settlement Statements, Invoices, Payments10: Replication
10MIS
5
Slide 13
CMM Project Interactions with TPTF
• Status of Document Reviews– Requirements and CSD have been approved
thru Baseline 1– No updates required for Baseline 2– Detail Designs for Base Product
implementation and Calculations available now
• No others currently scheduled• What else do you want to hear about?
Slide 14
Summary
• Good team working well together• Good vendor product and support • Going slower than expected due to:
– Complexity of calculations – Capturing currently manual business processes – Complexity of defining data integration– Constrained resources– but …
• On target to meet EDS dependencies
Slide 15
• Questions?