Spreadsheet: sally_beck__35451__EBS-Developed-Software
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 | Traders, [NAME], Settlements, Deal Clearing, Logistics, Sales Eng |  | Deal Entry, Deal Positions, Deal Approval, Curve Management, Audit Information.  Involves user issues, existing bug fixes.
 | Valuation |  |  | Daily / Monthly valuations and reporting, figure analysis, debugging at times
 | Reports |  |  | Daily Position Reports and Liquidation Reports
 | Administration |  |  | Create User Accounts, maintain existing users
 | Support |  |  | Application level, network level, user level support
 | FACT |  |  | Confirm selection, generation, confirm criteria and user security.
 | Database |  |  | Maintenance on Stored procs, triggers, views, foreign keys and various debugging
 | M I N U T E S  T R A D I N G |  | 3
 | [NAME] |  |  | Trader Ratesheets / Quotesheet Tracking
 | Administrative Console |  |  | Product Manager, Supplier Routes & Rates Manager
 | USTeleNet Switch |  |  | Integration to support call routing
 | Settlements
 | S A B E R  [Strategic] |  | 0 | 2002 Implementation Not Recommended
 | T A C T I C A L  B I L L I N G |  | 1
 | Circuits / IP |  |  | Database Maintenance; [NAME]
 | Minutes |  |  | Supplier CDR file maintenance / data fixes;  Reconciliation of Invoices to Payments
 |  |  |  | User Interface to Rate / Route Data
 |  |  |  | Integration with Ratekeeper application
 | Network Operations
 | P P C S  /  T R P |  | 3
 | E C O M S |  | 1
 | N E T S |  | 3
 | Editor | Risk Management |  | Bug fixes - can often be corrupting data or preventing users from accessing the 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 questions and training
 |  | TOC |  | End user problems
 |  | Trading |  | Installation problems
 |  | Integration |  | Modification for IP
 |  | Implementation |  | Modification for EnFiber/ECOMS integration (common circuit id)
 |  |  |  | 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
 | EnLook |  | 0
 | Utopia |  | 0
 | thespotlight |  | 1
 | Livelink (Core System) |  |  | Maintain the Admin Server , [NAME], Index and HTML Engines for Livelink application
 |  | Trading |  | Administer End-user connectivity and security Adminstration
 | Input Accel Document Capture | Trading Support |  | Provide desktop support and maintenance for both the proprietary and Windows-based products which are integrated with the system
 | Contract and Invoice/Purchase Order Bar-coding System | Engineering and Operations |  | Install monthly application patches written in proprietary [NAME] language
 |  | Legal |  | Write database scripts necessary for data cleanup, and application patches
 |  |  |  | Maintain 24X7 system availability with manual system failover and system load balancing
 |  |  |  | Build reports in proprietary [NAME] language
 |  |  |  | Monitor and maintain doucment capture server
 |  |  |  | Create process paths in  proprietary language (different than Livelink language) necessary to supoprt  document capture and transformation process
 |  |  |  | Maintain [NAME] and associated software
 |  |  |  | Maintain and modify barcoding application necessary for document capture process for Contract, all Contract support documents, Invoices, and [NAME]. As well as maintaince on the infrastructure database which support these applications
 | Global Data
 | Global Counterparty + Common Codes |  | 0
 | EBS Facility |  | 0.5
 | EBS Contract |  | 0.5
 | Data Architecture
 | Database Management (90 DBs) |  | 2
 |  | [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 availibility issues.
 |  | FACT |  | Ensure nightly backups are performed on production DBMSs.
 |  | FiberBase |  | Aid in database fail-over in the event of database server failure.
 |  | GeoQual |  | Perform database recovery in the event of data loss, data corruption, or disaster.
 |  | GNEO |  | Aid in defining and implementing DBMS contingency management plan.
 |  | IP Net |  | Participate in disaster recovery planning and testing.
 |  | LiveLink / NOC |  | Ensure and perform DBMS-wide auditability on request.
 |  | Media Services |  | Create and maintain the logical and physical non-application database structures as required.
 |  | 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.