Spreadsheet: sally_beck__35401__EBS-NonElective2002
Sheet: NonElective Detail

 | EBS IT - Non-Elective System Maintenance
 | 2002 Headcount (Estimated)
 | SYSTEM | KEY USER GROUP | # OF PEOPLE | NON-ELECTIVE MAINTENANCE FUNCTIONS
 | Trading / Front Office
 | E N F I B E R |  | 3
 | Core System | Trading |  | - Database upgrade
 | Valuation | Risk Management |  | - MultiCast / Server / Network Monitoring
 | Reports | Settlements
 | Administration | Deal Clearing |  | - Curve Management / Fixing Curve
 | Support | Logistics |  | - Audit Information
 | FACT | [NAME] |  | - User Issues; Existing bug fixes
 | Database |  |  | - Daily / Monthly valuations & reporting, figure analysis:  debugging
 |  |  |  | - Daily Position Reports and Liquidation Reports
 |  |  |  | - Create User Accounts, maintain existing users
 |  |  |  | - Application, network & user-level support
 |  |  |  | - Confirm selection, generation, confirm criteria and user security.
 |  |  |  | - Maintenance on Stored procedures, triggers, views, foreign keys
 |  |  |  | - Various debugging
 | M I N U T E S  T R A D I N G |  | 3
 | [NAME] | Trading |  | - Effective scaling of business requires systematic approach for tracking customer quotes which are subject to rate changes
 | Administrative Console | Risk Management |  | - Require systematic ability to manage products (bundle calling codes), Supplier Routes & Rates (significant volumes)
 | USTeleNet Switch | Logistics |  | - Integration to support call routing via existing leased switch
 |  | Settlements
 | Settlements
 | S A B E R  [Strategic] |  | 0 | No Support (2002 Implementation Not Recommended)
 | Tactucal L Billing |  | 1
 | Circuits | Settlements |  | - Database maintenance
 | IP |  |  | - Statement generation
 | Real Estate |  |  | - Reconcilement of Supplier Invoices for Payment processing
 | Minutes |  |  | - Supplier Call Detail Records - file maintenance, daily data fixes
 |  |  |  | - User Interface to Rate / Route Data
 |  |  |  | - Integration with Ratekeeper application
 | Network Operations
 | P P C S  /  T R P |  | 3
 | PPCS Existing System | NOC |  | - Active Contract Monitor
 | TRP - New Development | Logistics |  | - Alarm Notification Filter
 |  | Commercial Engineering Support (formerly TOC) |  | - Contract Notification Filter
 |  | Capacity Management |  | - Automatic Switch Commands Archive
 |  | Global Network Management |  | - Multiple Communication Protocol Support
 |  | Tes & Tune-up |  | - TDM & IP Trade Consolidation
 |  |  |  | TRP (New Development)
 |  |  |  | - TRP Acceptance Test & Certification
 |  |  |  | - TRP Architecture Implementation
 |  |  |  | - Enron PM Collection API
 |  |  |  | - Active Contract Monitor
 |  |  |  | - Network Element Monitor
 |  |  |  | - Develop Multiple Interfaces (with Device Driver, with Oware, with Auto-Discovery Probe, with Inventory Management., with Netcool Alarm Notification)
 |  |  |  | - Private Line & Wavelength Consolidation
 |  |  |  | - Common Platform for all trades
 |  |  |  | - Common QoS Reports
 |  |  |  | - Common Network Management Platform
 |  |  |  | - Extranet / Intranet web site for Enron's customers
 |  |  |  | - Monitor both Provier's & Customer's SLA
 |  |  |  | - Support Out-of-Band PM Collection
 |  |  |  | - Map-Driven Interface
 |  |  |  | - TRP Resell Bundling
 | E C O M S |  | 1
 |  | Sales Engineers |  | - Database maintenance; bug fixes; data fixes;
 |  | Provisioning |  | - Maintenance of stored procedures, views, triggers etc
 |  | Field Operations |  | - Administration / user queries / security
 | N E T S |  | 3
 | Editor | Risk Management |  | - Bug fixes -often data corruption or user inability to access data
 | Engineering Master | Engineering |  | - System Administration - user accounts & security
 | Material Master | Field Operations |  | - Ad-hoc reporting
 | Administrator | Logistics |  | - Manual running of weekly and daily reports
 |  | Capacity Management |  | - Fixing data problems
 |  | Provisioning |  | - Audit tracing (finding out how data was changed)
 |  | NOC |  | - General user problems, questions and training
 |  | TOC |  | - Installation problems
 |  | Trading |  | - Modification for IP
 |  | Integration |  | - Modification for EnFiber/ECOMS integration (common circuit id)
 |  | Implementation |  | - Application distribution
 | R E M E D Y |  | 1
 | Network Trouble Ticket | NOC |  | - Maintain user accounts / password resets
 | Change Request System | Engineering |  | - Application bug fixes / software upgrades/software patches
 | [NAME] | Trading Ops |  | - User inquiries / how-to's
 | Netcool Integration | Field Ops |  | - Monitor integration with other external databases, Netcool, MSN reporting
 |  | MSN |  | - Monitor database snapshots, performance tuning
 |  | Implementation |  | - Monitor web server upkeep and performance
 |  |  |  | - Monitor automated event notifications / management escalation pages
 |  |  |  | - Update troubleshooting / support documentation
 |  |  |  | - Monitor application server performance
 |  |  |  | - Monitor generation daily / weekly / monthly reporting
 |  |  |  | - Monitor Netcool gateway
 | E N L O O K  (GeoQual) |  | 0 | No Support
 | U T O P I A |  | 0 | No Support
 | Market Intelligence |  | 0 | No Support
 | L O C A T E |  | 0 | No Support
 | [NAME]
 | Livelink (T H E  S P O T L I G H T) |  | 1
 | Livelink (Core System) | Trading |  | - Maintain Livelink Admin Server , [NAME], Index and HTML Engines
 | Input Accel Document Capture | Trading Support |  | - Administer End-user connectivity & security
 | Contract & Invoice / Purchase Order Bar-coding System | Engineering and Operations |  | - Provide desktop support & maintenance for both the proprietary and  Windows-based products which are integrated with the system
 |  | Legal |  | - Install monthly application patches written in proprietary [NAME] language
 |  |  |  | - Write database scripts necessary for data cleanup, and application patches
 |  |  |  | - Maintain 24X7 system availability with manual failover & system load balancing
 |  |  |  | - Build reports in proprietary [NAME] language
 |  |  |  | - Monitor and maintain document capture server
 |  |  |  | - Create process paths in  proprietary language (different than Livelink language) necessary to support  document capture and transformation process
 |  |  |  | - Maintain [NAME] and associated software
 |  |  |  | - Maintain & modify barcoding application necessary for document capture process for Contract, all Contract support documents, Invoices, and [NAME];
 |  |  |  | - Maintain infrastructure database which support these collective applications
 | Global Data
 | G L O B A L  C O U N T E R P A R T Y  (via CDP) |  | 0 | No Support
 | G L O B A L  C O M M O N   C O D E S (via CDP) |  | 0 | No Support
 | Common Data - Integration | [NAME] |  | - Key integrated systems have data dependency (GCP data integrated via EBS Common Data Platform)
 |  | FACT
 |  | ECOMS
 |  | NETS
 |  | Remedy
 |  | EBS Contract
 | E B S   F A C I L I T Y |  | 0.5
 | Common Data - Integration | [NAME] |  | - Database maintenance (Views, stored procedures, triggers, foreign keys etc) required to support ongoing integration with key systems
 |  | ECOMS |  | - Bug fixes ; data maintenance
 |  | NETS |  | - Lack of integration will require modifications to discreet applications such as EnFiber to accommodate data capture
 |  | EBS Contract
 | E B S  C O N T R A C T (Tactical / Notes) |  | 0.5
 |  | Global Counterparty |  | - Database maintenance (Views, stored procedures, triggers, foreign keys etc) required to support ongoing integration with key systems
 |  | [NAME] |  | - Bug fixes ; data maintenance
 |  | Settlements |  | - Risk of continued use of Tactical system without Notes support
 | Data Architecture
 | D A T A B A S E    M A N A G E M E N T |  | 2
 | 90 Databases | [NAME] |  | - Coordinate with application team and DBMS vendor support services regarding database problems and issues.
 |  | EBS Contracts |  | - Install DBMS and related software patches and upgrades.
 |  | EBS Counterparty |  | - Ensure 24x7 DBMS availability, performance and fault monitoring.
 |  | EBS Facilities |  | - Provide DBMS performance tuning and proactive database/application fault management.
 |  | ECOMS |  | - Coordinate with Application Development / Production Support teams on DBMS / application performance and availability issues.
 |  | FACT |  | - Ensure nightly backups are performed on production DBMSs.
 |  | IP Net |  | - Participate in disaster recovery planning and testing.
 |  | LiveLink / NOC |  | - Ensure and perform DBMS-wide auditability on request.
 |  | NETS |  | - Create and maintain database replication logic as required.
 |  | PPCS |  | - Promote the application database structures to other DBMS environments as requested by Application Development teams.
 |  | Remedy/NOC |  | - Coordinate with database designers and systems analysts regarding distributed and replicated transactions to other DBMSs.
 |  | Settlements |  | - Create and manage storage characteristics of physical database objects.
 |  |  |  | - Manage DBMS utilization of database server resources.
 | TOTAL HEADCOUNT