Spreadsheet: sally_beck__35451__EBS-Developed-Software
Sheet: EBS Systems

EBS Information Technology
Key Applications - Estimated Development Costs Since Inception - As of 11/15/01
SYSTEM | MAJOR FUNCTIONALITY |  | MAGNITUDE / METRICS |  | COST
S A B E R |  |  |  |  | 1000000
 | Current (Maintenance) |  | Current System Metrics
 |  | [NAME] for Circuits, Fiber & Conduit |  | 1700+ Deals (est 12/1/01)
 |  | Calculate Telecom Taxes |  | 2003 GUI objects
 |  | Generate Accounting Entries |  | 126 GUI windows
 |  | Post Transactions to SAP |  | 25  Web pages
 |  | Flash to Actuals Reconciliation |  | 380  Middle-tier classes
 |  | Generate Manual Statements |  | 129 DB tables
 |  | Bridge Global Data to Saber |  | 1439 Data elements
 |  | Bridge Enfiber Deals to Saber |  | 347 Stored Procedures
 |  | SAP Interfaces for Payment and Intercompany Reconciliation |  | 592 Triggers
 |  |  |  | 6 Unix c-shell scripts
 |  |  |  | 11 [NAME] scripts
 | Future Enhancements Identified by Users (Development) |  | Level of Effort (weeks)
 |  | [NAME] (new commodity) |  | 128
 |  | Settle Real Estate (new commodity) |  | 48
 |  | [NAME] (new commodity linked to circuits) |  | 12
 |  | Settle Quarterly / Annual deals |  | 4
 |  | Report taxes for year end returns & Regulatory reporting |  | 14
R E M E D Y |  |  |  |  | 700000
 | Current (Maintenance) |  | Current System Metrics
 |  | Release 2.0 of  Change Management system |  | 268 [NAME]
 |  | Integration of CMR with [NAME] and NETs |  | 287 Tables
 |  | MSN Document Routing and Approval System |  | 92 Views
 |  | Additional functionality with the Case Tracking System |  | 60,000 Rows
 |  | [NAME] server to version 5.0 |  | 4 Snapshots
 |  |  |  | 4 External Interfaces
 |  |  |  | 7545 Trouble Tickets
 |  |  |  | 294 Change Requests
 | Future Enhancements Identified by Users (Development) |  | Level of Effort (weeks)
 |  | Automatic Netcool to Remedy integration |  | 4
 |  | TNT Change Process |  | 4
 |  | Scheduled Customer Notices |  | 2
 |  | Security Checklist integration |  | 2
 |  | Enhanced Notification functionality |  | 2
 |  | Delinquent CMs |  | 2
 |  | MSN Document Routing and Approval system |  | 12
 |  | NETs Integration |  | 6
 |  | ECOMS Integration |  | 4
 |  | Web-based frontend for Change Management, Document Routing and Case Tracking |  | 12
 |  | Enhanced Automated Report/Metrics |  | 4
 |  | MSN Case Ticket Gateway |  | 6
G L O B A L  C O U N T E R P A R T Y  + C O M M O N  C O D E S  (CDP) |  |  |  |  | 277000
 | Current (Maintenance) |  | Current System Metrics
 |  | System of Record for Counterparty Information across Enron |  | 33 Tables
 |  | No EBS-specific user interface |  | 26,000 Records
 |  | Customized EBS database via Common Data Platform which is approximately 50% different from design of GCP |  | 1,300 Counterparties
 |  |  |  | 5 Interfaces
 | Future Enhancements Identified by Users (Development) |  | Level of Effort (weeks)
E B S   F A C I L I T Y |  |  |  |  | 350000
 | Current (Maintenance) |  | Current System Metrics
 |  | System of Record for all EBS Facilities / Locations (POPs, Regens, Colocations etc) |  | 20 [NAME]
 |  | No Relation to Enron Global Facility System |  | 20 Stored Procedures
 |  |  |  | 4,000 Records
 |  |  |  | 1,500 Facilities
 |  |  |  | 7 Interfaces
 |  | Move Trading City to Location level
 | Future Enhancements Identified by Users (Development) |  | Level of Effort (weeks)
 |  | Facility Requisition
 |  | [NAME]
E B S   C O N T R A C T |  |  |  |  | 315000
 | Current (Maintenance) |  | Current System Metrics
 |  | System of Record for all EBS Contracts for all product types |  | 50 [NAME]
 |  | No relation to Enron Global Contract System |  | 45 Stored Procedures
 |  | Product maintenance |  | 42 Tables
 |  |  |  | 11,000 Records
 |  |  |  | 4,500 Contracts
 |  | Code table (picklist) maintenance |  | 2 Interfaces
 | Future Enhancements Identified by Users (Development) |  | Level of Effort (weeks)
 |  | Complete EBS Contracts v1 |  | 16
 |  | Add Subdocuments |  | 7
 |  | LiveLink Integration |  | 40
 |  | Common Code Integration |  | 5
 |  | Rules Based Validation |  | 14
N E T S |  |  |  |  | 1500000
 | Current (Maintenance) |  | Current System Metrics
 |  | Inventory Management (Life Cycle)
 |  | Purchasing |  | 94 Active Users
 |  | Receiving |  | - 41 Field Operations
 |  | Transfers (shipping) |  | - 12 Implementation
 |  | Storage |  | - 10 Network Planning
 |  | Bar coding |  | - 8 Network Mgmt
 |  | Material Master |  | - 7 Engineering
 |  | Tracks Bar Codes & Serial Numbers |  | - 6 Risk Mgmt
 |  | System of Record for over 2,300 unique manufacture part numbers
 |  | Other |  | - 10 Other
 |  | Extensive search capabilities
 |  | Reporting (Canned and Ad-Hoc) |  | $19.4 MM Inventory
 |  | Attached Documents |  | $168.4 MM Deployed
 | Future Enhancements Identified by Users (Development) |  | Level of Effort (weeks)
 |  | Logistics & Provisioning
 |  | Streamline EnFiber/ECOMS/NETS/Remedy interfaces |  | 10
 |  | Database integration with [NAME] (eliminate dual entry) |  | 10
 |  | Provisioning wizard and Provisioning functionality |  | 20
 |  | Enhance Cable Management |  | 20
 |  | Integrate NOC with NETS (operational failures) |  | 10
 |  | Integrate Change Management procedures |  | 5
 |  | Auditing circuits and tracking changes |  | 5
 |  | Provide Topographical view of network |  | 20
 |  | GIS View of network (pull in GeoQual) |  | 20
 |  | Reserve ports |  | 5
 |  | Sign-off functionality for handover to NOC |  | 10
 |  | Greater support for IP |  | 10
 |  | Engineering
 |  | Reconcile against live configuration |  | 10
 |  | AutoCAD plug-in |  | 5
 |  | Engineering Material Master Enhancements |  | 20
 |  | Power management |  | 10
 |  | Pre-building of circuits |  | 5
 |  | Chassis and Card Elevation |  | 10
 |  | Inventory Management
 |  | Replacement functionality for Deal Ticket |  | 4
 |  | Kits or Bill of Materials |  | 3
 |  | Pending Goods Receipt |  | 5
 |  | Streamlined equipment receiving |  | 3
 |  | Support auditing equipment |  | 10
 |  | Direct support for RTV & RMA |  | 10
 |  | Other
 |  | Additional Reports |  | 20
 |  | Total
E N F I B E R |  |  |  |  | 3030000
 | Current (Maintenance) |  | Current System Metrics
 |  | C O R E  S Y S T E M
 |  | Deal Blotter + Deal Blotter Server |  | 50 [NAME]
 |  | Deal Entry |  | 80 Stored Procedures
 |  | Deal Patrol |  | 60 Views
 |  | EOL Bridge |  | 4807 Data Elements
 |  | Position Manager |  | 281 Tables
 |  | Curve Manager |  | 3457 Deals
 |  | Launchpad |  | 25 Applications
 |  | Login |  | 26 Reports
 |  | [NAME]
 |  | [NAME]
 |  | SysAdmin
 |  | EnFiber Deploy
 |  | Valuation
 |  | [NAME]
 |  | PortCalc [NAME]
 |  | Deal Approval
 |  | Deal Scheduling
 |  | Deal Valuation
 |  | Position Manager
 |  | Deal Monitoring
 |  | Reports - BRIO
 |  | Reports - Views
 |  | Database/Trigger/Advanced Queueing Maintenance
 |  | 70 % of EnPower Tables have been dropped
 |  | 30 % new Tables  + major column drops to existing tables
 |  | 80 % of application code has been changed (from EnPower)
 |  | Large percentage of code still exists
 |  | F A C T
 |  | Automate the delivery of the trade confirmations to counterparties. |  | 36 Windows
 |  | Get new and revised deal information from EnFiber. |  | 32 Stored Procedures
 |  | Select an appropriate template by matching the trade details. |  | 30 Tables
 |  | Generate a deal confirm by merging the trade data with template. |  | 43 [NAME]
 |  |  |  | 20 Annex
 |  |  |  | 14 Provisions
 |  |  |  | 2978 Deals
 |  |  |  | 3041 Strips
 |  | R E A L  E S T A T E
 |  | Create Real Estate deals |  | 5 windows
 |  | Project deal incomes/expenses |  | 9 tables plus [NAME] tables
 |  | Real Estate Deal Valuation |  | 7 reports
 |  | Real Estaste Deal reports |  | 10 views plus Enfier views
 |  |  |  | 80 Data Elements plus Enfiber Data Elements
 |  |  |  | 600 deals
 | Future Enhancements Identified by Users (Development) |  | Level of Effort (weeks)
 |  | C O R E  S Y S T E M
 |  | Service Level Agreements |  | 32
 |  | Interface with [NAME] |  | 24
 |  | Addition of Real Estate Commodity |  | 24
 |  | Expand Position Manager to Include all Deal Types |  | 24
 |  | Addition of System Administration Utilities – curves, city pairs, etc. |  | 12
 |  | Scheduling Phase II |  | 36
 |  | Add future Deal Types |  | 12
 |  | F A C T
 |  | Display FACT Confirm Status for Deals in [NAME]. |  | 2
 |  | Add FACT to the EnFiber Launch Pad. |  | 1
 |  | Automate FACT deployment process. |  | 3
 |  | Display Deal Screen from FACT. |  | 1
 |  | Add additional merge fields for Counter Party Fax and address. |  | 4
 |  | Move all Save Buttons to the top of the screen. |  | 2
 |  | Create a bar code ID within the Confirm. |  | 2
 |  | Expand mini deals screen which will show the options on a deal. |  | 4
 |  | Add Automatic Electronic Signature capability. |  | 4
 |  | Ability to fax multiple confirms to multiple counter parties. |  | 8
 |  | Generating a Fax Cover Sheet with CP information. |  | 2
 |  | Ability to cancel a fax not yet sent. |  | 2
 |  | Merge field with formulas. |  | 2
 |  | Add ability to store confirms in Spotlight. |  | 6
 |  | Connectivity and international issues in Europe and Asia. |  | 8
 |  | Ability to copy and paste a user profile into another profile. |  | 2
 |  | Ability to click and drag columns in the View Deal Screen. |  | 2
 |  | All Broker Fields should be non-editable for EOL deals. |  | 2
 |  | View the templates and their associated Annexes together. |  | 4
 |  | Web based [NAME] (as used in Commodity Logic). |  | 8
 |  | Upgrade vsFlex6 to vsFlex7. |  | 4
 |  | R E A L  E S T A T E
 |  | Update projection methodology to handle annual and quarterly payments |  | 4
 |  | Integration with the [NAME] settlements system |  | 4
 |  | Integration of remaining [NAME] reports (any report in [NAME] can be run for Real Estate) |  | 9
 |  | Ability to monitor and update depreciation and capital expenditures, both realized and projected (probably an additional tab on deal entry) |  | 2
 |  | Update disposition process to enable entry of one time "closing" payments rather than manipulating projections. |  | 2
E C O M S |  |  |  |  | 1500000
 | Current (Maintenance) |  | Current System Metrics
 |  | Provisioning / Logistics Order Entry and Management |  | 150 Users
 |  | Document Storage and Tracking |  | 85 [NAME]
 |  | Logical Circuit Design |  | 90 Data Objects
 |  | Workflow / Task Management and Reporting |  | 20 Stored Procedures
 |  | Search Capabilities for NOC |  | 5 System Interfaces
 |  |  |  | 95 Tables
 |  |  |  | 1300 Service Orders
 |  |  |  | 1250 Enron Circuits
 |  |  |  | 1600 Vendor Circuits
 |  |  |  | 2200 Documents
 |  |  |  | 12000 Tasks
 | Future Enhancements Identified by Users (Development) |  | Level of Effort (weeks)
 |  | Resource Management for Task Assignments |  | 12
 |  | Buy/Sell GUI redesign |  | 8
 |  | Track Colo Deals |  | 8
 |  | Security for attached Documents |  | 6
 |  | EnFiber interface |  | 4
 |  | NETS Interface |  | 6
P P C S  /  T R P |  |  |  |  | 40000000
 | Current (Maintenance) |  | Current System Metrics
 |  | PPCS
 |  | Disable xConnect & disconnect |  | 100,000 switch commands
 |  | Support early contract extension and early termination |  | 1000 threads
 |  | Reset logical contract start date |  | 50 screens
 |  | Clean up port/tributary assignment if contract duration change |  | 50 tables
 |  | DB migration from v1.0 to v1.1.2 |  | 100 contracts
 |  | Trib assignment down to customer level |  | 500 log files
 |  | Switches and contracts are allocated in a particular region or inter-region |  | 30 switches
 |  | TRP
 |  | TRP architecture & API discovery
 | Future Enhancements Identified by Users (Development) |  | Level of Effort (weeks)
 |  | PPCS
 |  | Active TDM contract monitor |  | 8
 |  | Support IP trades |  | 20
 |  | Suppot hybrid communcation protocol |  | 12
 |  | Support multiple network topology |  | 20
 |  | Support additional switch vendors |  | 24
 |  | TRP
 |  | TRP acceptance test |  | 8
 |  | Active contract monitor |  | 12
 |  | Network element monitor |  | 12
 |  | Open PM collection transaction protocol for all switches |  | 20
 |  | Open gateway to NOC alarm system |  | 20
 |  | Support multiple network topology |  | 20
T A C T I C A L  S E T T L E M E N T S |  |  |  |  | 100000
 | Current (Maintenance) |  | Current System Metrics
 |  | Generate statements for Real Estate, circuits, [NAME], minutes |  | # of Users | 8
 |  | Reconciliation of invoices to payments |  | # of Tables | 25
 |  |  |  | # of GUI windows | 42
 |  |  |  | # of queries | 91
 |  |  |  | # of Vendors | 449
 |  |  |  | # of Customers | 66
 |  |  |  | # of Statements | 2665
 |  |  |  | # of Reports | 16
 | Future Enhancements Identified by Users (Development) |  | Level of Effort (weeks)
 |  | None Planned
V O I C E  M I N U T E S |  |  |  |  | 100000
 | Current (Maintenance) |  | Current System Metrics
 |  | Tactical Billing
 |  | User Interface to Rate + Route Data
 |  | Integration with Ratekeeper Application
 |  | Reconciliation of CDRs
 |  | Voice Minutes Ratekeeper Application
 |  | Product Manager |  | Approx 20,000+ potential dialing codes
 |  | [NAME] Manager |  | Approx 6,000+ supplier definitions for 4 carriers
 |  | Trader Ratesheet
 |  | USTeleNet Integration via API (Routing)
 | Future Enhancements Identified by Users (Development) |  | Level of Effort (weeks)
 |  | Implement 3rd Party Software Modules
 |  | Least-Cost Optimization |  | 8
 |  | Routing / Switching |  | 8
 |  | Settlements |  | 8
 |  | [NAME] with 3rd Party Software Modules |  | 8
D A T A B A S E  M A N A G E M E N T |  |  |  |  | 0
 | Current (Maintenance) |  | Current System Metrics
 |  | DBMS Software Management |  | Total Databases: 90
 |  | [NAME] and related software installations. |  | - Oracle: 57
 |  | Ensure licensing agreement compliance with DBMS and related software. |  | - MS SQL: 33
 |  | Coordinate with DBMS vendor support services regarding database problems and issues.
 |  | DBMS Configuration Management
 |  | Create and maintain the DBMS according to Enron's database server architecture.
 |  | Maintain all DBMS configuration, log, and trace files associated with the database.
 |  | Manage DBMS utilization of database server resources.
 |  | Manage startup and shutdown of the DBS and associated facilities.
 |  | DBMS Capacity Planning
 |  | Aid in identifying server resources necessary to implement and maintain DBMS.
 |  | Coordinate requests of server resources with the UNIX Systems Administration team.
 |  | Physical Database Design Management
 |  | Create and maintain the logical and physical non-application database structures as required.
 |  | Create and maintain database replication logic as requested by Application Development teams.
 |  | Promote the application database structures to other DBMS environments as requested by Application Development teams.
 |  | Coordinate with database designers and systems analysts regarding distributed and replicated transactions to other DBMSs.
 |  | Determine and manage storage characteristics of physical database objects.
 |  | Ensure database objects comply with Enron naming conventions and standards.
 |  | Performance/Fault Management
 |  | Ensure 24x7 DBMS performance and fault monitoring.
 |  | Provide DBMS performance tuning and proactive database/application fault management.
 |  | Coordinate with Application Development/Production Support teams on DBMS/application performance tuning.
 |  | Coordinate with Systems Administration teams on DBMS/server performance tuning.
 |  | Coordinate with Network Systems Administration team on DBMS/network performance tuning.
 |  | DBMS Availability / Recoverability
 |  | Coordinate with Systems Administration teams on defining and implementing DBMS backup/recovery and high-availability procedures.
 |  | Test and ensure recoverability and high-availability procedures of DBMSs.
 |  | Ensure nightly backups are performed on production DBMSs.
 |  | Aid in database fail-over in the event of database server failure.
 |  | Perform database recovery in the event of data loss, data corruption, or disaster.
 |  | Aid in defining and implementing DBMS contingency management plan.
 |  | Participate in disaster recovery planning and testing.
 |  | DBMS Security / Auditability
 |  | Coordinate with Application Development/Production Support teams on user access, roles, and privileges.
 |  | Coordinate with Application Development/Production Support teams on defining and implementing application data auditability.
 |  | Ensure and perform DBMS-wide auditability on request.
 | Future Enhancements Identified by Users (Development) |  | Level of Effort (weeks)
 |  | TOTAL