- assessing computing hardware and software needs
of Loan Repayment Services
- researching, recommending, and installing computer hardware and software
for Loan Repayment Services.
- Recently installed new Win98 PCs at all Loan Repayment Services employee workstations, re-establishing connections to all network applications and the AIS (Administrative Information Services) mainframe.
- overseeing the operation of 10 PC workstations, 1 laser printer, and 2 dot matrix printers
in Loan Repayment Services
- providing training and support
to all Loan Repayment Services personnel in the use of all computing equipment
- providing training and support for all commercial PC applications
used in Loan Repayment Services such as the MS Office components and various programs and applications used to obtain data housed at other entities such as the credit bureaus, National Student Loan Database System, and National Student Loan Clearinghouse
- trouble shooting PC-related problems
in Loan Repayment Services as well as some PC problems in OSSA (the Office of Scholarships and Student Aid) and some network-related problems on the OSSA server which services OSSA and Loan Repayment Services
- One investigation provided a solution for a critical issue that had plagued the network for many months. The problem prohibited multiple users from running MS Access simultaneously which was greatly reducing office efficiency.
- developing, instituting, and maintaining many PC applications in MS Access, MS WORD, MS Excel, MS Powerpoint, Paradox, Lotus 1-2-3, DOS batch files, and assorted other small programs
for Loan Repayment Services as well as some applications for the OSSA and Work-Study personnel.
With a small Loan Repayment Services staff (8) and a large loan and borrower portfolio, automation of office and collections functions outside of the capabilities of LMS greatly aids in work efficiency and, therefore, collections effectiveness. Some procedures I have automated are:
- MS Access application to balance daily and monthly financial transactions created in LMS. This application serves as a check to LMS for accounts receivable. Also, since LMS does not carry loan fund cash balances, this is the sole source of cash balancing in Loan Repayment Services and serves as a check of FRS (Financial Reporting System) loan fund cash balances for the OSSA accountant.
- MS Access application to calculate individual work/service cancellations as well as provide monthly and yearly cancellation summary reports for federal Fiscal Operations Reports
- MS Excel application to summarize receivables and cash data for Fiscal Operation Reports
- MS Access/MS WORD application to produce monthly and on-demand forms for borrowers requesting loan work/service cancellations
- Paradox application to create promissory notes, loan checks, rolodex cards, data entry source documents, and fund reimbursement sheets for student emergency loans which are disbursed daily
- Paradox application to create monthly bank drafts for over 300 borrower payments
- many MS WORD individual and mail merge forms to do such things as create on-demand promissory notes and submission forms for assignment of defaulted loans to the U.S. Department of Education
- Paradox application to complete new work-study student employee forms
- Paradox application to create billing statements for the OSSA accountant to bill students who were overfunded