Spreadsheet: chris_stokley__3959__EES Activity Listing071201
Sheet: Sheet1

 |  | Population |  |  |  |  |  |  | Projects
Activity |  | total | Done | Power | Gas | IT | Process | People | Pheonix | Gas Solutions | Ranger | Genysis | [NAME] | Timeline | Comments
Data Accuracy:
Historical
 | Review / rebook large deeals | 110 | 0 | X | X | X | X | X | X
 | Industrial gas deals | 5000 | 0 |  | X |  |  |  |  | X
 | Commercial Gas Deals |  |  |  | X |  |  |  |  | X
 | Retail |  |  | X
 | wholesale (EPMI/ENA) Intercompany Tie-up |  |  | X
 | Contract / Trade Documentation | 16000 |  | X | X |  |  |  |  |  |  |  |  | OCT | Ensure company has all contracual documents in robust, imaging / retention / system,  Goals = Accessible, complete & maintained in livelink
Go Forward
 | Integration with Global Common Tables
 | Global Counterparties | 15000 | 5000 | X | X |  | X | X |  |  |  |  |  | OCT | Have Global Data systems , integrated into Gas & Power, trade,risk & billing systems. Input and Validate historical backlog..
 | Global Contracts |  |  | X | X |  | X | X |  |  |  |  |  | OCT | "
 | Global Facility / Site |  |  | X | X |  | X | X |  |  |  |  |  | G-Oct / P-Jan | Gas October / Power Jan-02   "
 | Capture all New Deals
 | Deal Ticket
 | Complete Site Listings |  |  |  |  |  |  |  |  | X |  |  | X | G - JUL   P - AUG | Working to transition capture from Deal Mgmt / Prod Development to Risk
 | Validation
 | Back to contract |  |  | X | X | X | X | X |  | X |  |  | X | G - JUL   P - AUG | Need workflow tools and additional people.  Have good support from Origination heads
 | Fully Papered |  |  | X | X | X | X | X |  | X |  |  | X | G - JUL   P - AUG
 | Executed |  |  | X | X | X | X | X |  | X |  |  | X | G - JUL   P - AUG
 | Confirmation |  |  | X | X | X | X | X |  | X |  |  | X | G - JUL   P - AUG
Risk System Limitations:
Global | Reliability / timming of market risk interface |  |  | X | X | X |  |  |  | X |  |  | X | G-Oct / P-Jan | Reduction of Spreadsheets (SEP), Stabalizing RGS / RPS (AUG)
 | Reliability of credit agg system |  |  | X | X | X |  |  |  | X |  |  | X |  | Reduction of Spreadsheets (SEP), Stabalizing RGS / RPS (AUG).  GCP system integration, Short Term Counterparty setup
 | [NAME] not real-time |  |  | X | X | X | X |  |  | X | X |  | X |  | ST = Aggregate any existing measurement info from CSC; MT = Have CSC pull from additional utilities for Hourly/daily info on meter consumption; LT Gas Solution & Power Solution
 | EAM (Energy Asset Management) |  |  | X | X | X | X | X |  | X |  |  | X | ST - SEP LTG-OCT LTP-JAN | ST - Create EAM Books on EES side of business (so DSM can manage), Rebook and hedge between EES & EWS; LT - GAS & POWER Solutions
Power Specific | [NAME] |  |  | X |  | X |  |  |  |  |  |  | X | MT - JAN / LT - ? | IT system build out, ST - batch processes continue to be maintained in short term,  Quick hit RPS  valuation build out to reduce batch usage.
 | Validation Does Not Support all risk components |  |  | X |  | X | X |  |  |  |  |  | X | ST - JUL  MT - AUG LT-JAN | ST- Proof of concept on site profile; MT- Tariff curve database and Tariff reporting; LT- IT system build out.
 | No Intramonth
 | Position |  |  | X |  | X | X |  |  |  |  |  | X | MT - SEP LT - JAN | MT - Real Time solutions as above, load profiling / forcaseting at daily / hourly incroments; LT - Power Solution
 | Valuation |  |  | X |  | X | X |  |  |  |  |  | X | MT - SEP LT - JAN | MT - Real Time solutions as above, load profiling / forcaseting at daily / hourly incroments; LT - Power Solution
 | No Liquidation |  |  | X |  | X | X | X |  |  |  |  | X | MT - JUL LT - JAN | MT - Pull liquatations from batches; LT - Power Solution
 | No Actualization |  |  | X |  | X | X | X |  |  | X | X | X | MT - AUG LT - Q401 / Q102 | MT - Populate repository with CSC invoicing Data "Ranger Short Term [NAME]"; LT - Genysis, [NAME], EWS settlement support
 | Book Structure - Non existent |  |  | X |  | X | X | X |  |  |  |  | X | MT - JUL LT - JAN | MT - Continue to "Shoe Horn" book structure; LT - Power Solution
 | Intra Book Activity (Tariff vs. [NAME] split out)  Commodity vs. Consumption - Site Profile. |  |  | X |  | X | X |  |  |  |  |  | X | MT - AUG LT - JAN | MT - Review feasability of deal rebooking to split out risks and on going maintenance; LT - Power Solution
 | Option Valuation |  |  | X |  | X | X |  | X |  |  |  | X | MT - Q301 LT - JAN | MT - Spreadsheet models for day to day positions & P/L; LT - Power Solution
 | [NAME] |  |  | X |  | X | X |  |  |  |  |  | X | MT - AUG  LT - SEP | MT - Implementation of the tariff curve database; LT - Implementation of commodity curve database
GAS  Specific
 | Validation Does Not Support all risk components |  |  |  | X | X | X |  |  | X |  |  |  | ST - JUL   LT - OCT | ST- Proof of concept on site profile; MT- ; LT- IT system build out for Term, Physical bussiness issues will be resolved with [NAME].
 | No Intramonth
 | Position |  |  |  | X | X | X |  |  | X |  |  |  | MT - SEP LT - OCT | MT - Develop position reports using Altra data; LT - Gas Solution
 | Valuation |  |  |  | X | X | X |  |  | X |  |  |  | MT - SEP LT - OCT | MT - Develop position reports using Altra data; LT - Gas Solution
 | No Actualization |  |  |  | X | X | X | X |  | X | X | X |  | LT - Q401 | LT - Genysis, [NAME], EWS settlement support
 | Intra Book Activity Tariff, Commodity vs. Consumption - Site Profile. |  |  |  | X | X | X |  |  | X |  |  |  | LT - Q401 | LT - Gas Solution
 | Option Valuation |  |  |  | X | X | X |  | X | X |  |  |  | MT-Q301  LT-Q401 | MT - Spreadsheet models for day to day positions & P/L; LT - Gas Solution
Billing System Consolidation: