M E M O

TO:	Dan Schmidt

cc:	Bob Berkopec

Ann Herbst

FROM:	Yvonne Engel

DATE:	January 17, 2002

RE:	Clement

As an IT professional, our full-time Compuware placement, Clement, accomplished tasks last year that required specific knowledge and experience. In addition to trouble shooting any network problems as they occurred, he worked with various vendors to install, upgrade and maintain all of the investment software products: Passport, Private i, Great Plains, and Zephyr Style Advisor (which requires that monthly updates be downloaded) and the library database, Inmagic. He assisted with an upgrade of the grants database (Gifts for Windows) which necessitated the database be zipped and sent FTP to the manufacturer in New York in order to resolve unknown bugs relating to the upgrade.

Early in the year he converted all Windows 98 workstations to the Windows 2000 operating system. He contacted appropriate vendors to replace faulty items under warranty (the back-up tape drive unit and a hard drive). Whenever our T-1 line went down, he was able to work with Time Warner to trouble shoot the problem. Furthermore, he coordinated the disconnection of the T-1 line and installation of our DSL line. In addition, he resolved lingering problems with our Back-up Exec software and a web proxy server problem, which led him to research and subsequently install the new ISA Server for Internet security. Then, Clement upgraded our e-mail program by installing and fine tuning the Exchange 2000 Server along with the workstation components. He resolved both hardware and software printing issues on several printers and assisted the Canon Rep to install a networked printer/copier/scanner machine on the ground floor. He verified our software licenses and purchased additional licenses as needed and required by law.

In addition to his work here, he assisted one of our grantees (PAVE) on computer issues and installed a new file server and workstations, including setting up a new domain, software, e-mail program and configuring their DSL line.

Currently, Clement is testing and planning for the conversion of our file servers from a two-server NT-4 system to a three-server Windows 2000 system. Much work needs to be done to ensure that all of our current software will work together on the new operating system and new configuration. These changes will make the Foundation's data more secure, faster, easier to use and maintain. He works with our web site host (Tushaus) to upload changes to our site and advises on the appropriateness of the site's appearance. He continues to upgrade all of our software as needed and he keeps us abreast of the latest technologies and how they may be applied to the Foundation's needs.

/ye