- Designed and created the original Loan Repayment Services website
in 1997 which was comprised of over 70 pages. Maintain this site until September, 1999.
- Designed and created a webform
which creates an ASCII data file of event pre-registrants for the Tarheel Sports Car Club. The file is downloaded into MS Excel saving the time and effort of manual registration.
- Presented at the national and Carolinas Student Information Systems Users (SISU) conferences on the topics of:
- using FOCUS to enhance student loan collections and
- designing, creating, and implementing a website for a student loans office. Received a Best Presenter Award for 1998 presentation.
- Established and actively manage the LMS List
which operates via the UNC-CH listserve software. This email list has a current membership of over 465 student loan collection personnel providing interaction regarding student loan regulations and collection procedures for approximately 200 schools and 15 organizations, including members of the U.S. Department of Education.
- Assisted AIS (Administrative Information Services) programmers in the design and testing of the FAM (Financial Aid Management) FOCUS MFD (Master File Description) to provide the data extract for Stafford Loan information. Also provided the means to update several hundred existing FOCUS ad hoc reports with new data field names saving many hours of manual corrections.
- Introduced OSSA (the Office of Scholarships and Student Aid) to email in 1992 and provided instructions and training on how to use email. Also, provided instructions and training on how to use TSO (Time Share Option, the MVS component for updating datasets) to edit email datasets to combine separate pieces of email and to upload and download files between the ATN (Academic Technology & Networks) MVS mainframe, where our email was housed, and our office PCs. This was very useful and timesaving information at that time since it occurred before OSSA could receive email in a Windows environment.
- Was approached by AIS (Administrative Information Service) to present, to a group of AIS programmers, a demonstration of a complex MS Access database application I created for Loan Repayment Services to manage and balance daily and monthly collection and disbursement activities. Due to time constraints created by more pressing projects, this presentation has not yet taken place.
- Attended supplemental training courses on the subjects of:
- Web design and implementation
- Adobe Photoshop
- MS Access
- MS Excel
- MS WORD
- Lotus 1-2-3
- PC File management
- Visual Basic