r ""
Below is a cache of https://www.washington.edu/provost/oim/reports/choices/AppendixI.staffbaseline.4.29.pdf. It's a snapshot of the page taken as our search engine crawled the Web.
The web site itself may have changed. You can check the current page or check for previous versions at the Internet Archive. Yahoo! is not affiliated with the authors of this page or responsible for its content.
Appendix I:    Current Staffing Allocations and Additional Investments 





 
 
 
 
 
 
 
 
 
 
 
Appendix I:  
 Current Staffing Allocations and Additional Investments 
Required for UW Administrative Systems  
 
 
 
 
 
 
 
 
 
 
 
Computing & Communications 
University of Washington 
 
April 29, 2003





TABLE OF CONTENTS
 

I. STAFFING SUPPORT FOR TECHNICAL INFRASTRUCTURE ............ 1

A. CURRENT STAFFING ALLOCATIONS ..................................................... 1

B. ADDITIONAL STAFFING INVESTMENTS ............................................. 2
II. STAFFING SUPPORT FOR ADMINISTRATIVE SYSTEMS 
APPLICATIONS ........................................................................................................ 3

A.  CURRENT ISSUES AND CHALLENGES ................................................. 3

APPLICATION STAFFING ................................................................................................. 3

Work Backlog ...............................................................................................................................................5

Total Backlog................................................................................................................................................7


NEW DEVELOPMENT ISSUES AND CHALLENGES .............................................. 8

Project Planning and Cost Estimating...........................................................................................................8

Temporary Funding ......................................................................................................................................8

Prioritization Process ....................................................................................................................................9


B. ADDITIONAL STAFFING INVESTMENTS ........................................... 10

INVESTMENTS IN SPECIFIC FUNCTIONAL AREAS .......................................... 10

Finance and Budget.....................................................................................................................................10

HR/Payroll ..................................................................................................................................................10

Student ........................................................................................................................................................10

Procurement, Receivables, and Payables (ePrep) .......................................................................................11

USER Projects ............................................................................................................................................11

Data Warehousing.......................................................................................................................................11

Middleware .................................................................................................................................................11

Project Management Support......................................................................................................................11


SPECIFIC STAFFING RECOMMENDATIONS ......................................................... 12


C.  CURRENT BASELINE OF STAFFING ALLOCATIONS .................. 13

FINANCIAL AND BUDGET SYSTEMS ....................................................................... 14


HR/PAYROLL SYSTEMS.................................................................................................... 15


STUDENT SYSTEMS .......................................................................................................... 16


ALUMNI/DONOR INFORMATION SYSTEM ........................................................... 18


PROCUREMENT, RECEIVABLES, AND PAYABLES (EPREP) SYSTEMS ........ 19


FACILITIES SYSTEMS ....................................................................................................... 20


USER INITIATIVES ............................................................................................................ 21


DATA WAREHOUSING ..................................................................................................... 22


MIDDLEWARE ...................................................................................................................... 23
1 4/29/2003
Appendix I: Current Staffing Allocations

Appendix I:  
 Current Staffing Allocations and Additional Investments 
Required for UW Administrative Systems  

The key investment required to keep the administrative systems technically current and
responsive to the universitys business requirements is to ensure adequate levels of
experienced technical staff. This appendix documents current staffing levels for both the
administrative systems and their supporting technical infrastructure. It summarizes current
issues and challenges in operating and maintaining these systems in light of staffing
deficiencies, and it quantifies the additional staffing necessary to meet the UWs business
needs and sustain the non-ERP approach.


I. STAFFING SUPPORT FOR TECHNICAL 
INFRASTRUCTURE  
This section describes current staffing levels in the technical infrastructure area, explains the
tasks that this staff handles, and shows why three to four additional FTEs are needed.

A. CURRENT STAFFING ALLOCATIONS 
There are 16.5 FTEs supporting the technical infrastructure used by the universitys
administrative systems. This infrastructure includes servers, storage and other hardware,
three separate operating systems (Microsoft Windows, IBM AIX, and Unisys Clearpath
MCP), six database management systems (Microsoft SQL Server, Oracle, Sybase, Informix,
Ingres on the Windows and AIX platforms, and DMSII on the MCP systems), and
appropriate application, management, and monitoring tools.

Such a diverse environment requires staff with a number of different skill sets including:


Application supportfocusing primarily on the Windows environment, providing
in-depth consulting expertise in new and emerging aspects of this environment, as
well as support for integrating best-of-breed packages such as Ariba and JD Edwards.


Database administrationsupporting the design, implementation, and operation of
database environments across multiple server platforms.


Windows/UNIX infrastructureinvolving the specification, installation, and
configuration of 100 Windows and 30 IBM AIX servers, as well as monitoring and
2         4/29/2003 
Appendix I: Current Staffing Allocations



ongoing support. This area also supports the enterprise backup software used for the
Windows and UNIX servers and manages disk storage.


MCP infrastructureinvolving the configuration, monitoring, and ongoing support
of the mainframe systems that service numerous core administrative applications.
This area also serves as a technical consulting resource for the mainframe
environment and supports environmental and operation software such as job
scheduling and tape management.

The following chart shows how staff is allocated:

Technical Infrastructure Support Staffing
(Total 16.5 FTEs)
MCP
Win/Unix
DBA
App Supp


B. ADDITIONAL STAFFING INVESTMENTS 
The growth in complexity of the UWs administrative systems over the past decade and
rising demand for new administrative applications have placed a corresponding load on the
technical infrastructure support staff that handles associated system integration and
management issues. However, staffing levels in this area have not kept pace with increased
demands. The university has now reached a point where it is extremely critical to address
staffing deficiencies in this area; otherwise, it cannot continue to be successful in developing
and deploying technology solutions for university business requirements.

An additional three to four FTEs would contribute significantly to the ability of the
technical infrastructure support team to meet current and planned demands for the vital
services that sustain a reliable and secure administrative computing environment. In
3         4/29/2003 
Appendix I: Current Staffing Allocations



addition, further staffing would be necessary to support any new development or major
enhancements to administrative systems beyond what is currently planned.

II. STAFFING SUPPORT FOR ADMINISTRATIVE SYSTEMS 
APPLICATIONS 
This section describes current staffing levels in the administrative systems applic