mSQL

UNI talent database: 2-tier system

University of Northern Iowa: In 1997 I created a “talent database” where individuals could login via a web interface and volunteer as local experts in various fields.

This was written prior to the existence of PHP, ASP or even JSP – written entirely in Perl via CGI using DBD/DBI libraries with a mSQL back-end. In order to make the system completely automated I created a Perl sendmail to database interface.

The system had a Perl script which sent out periodic e-mails, looked for replies, and then automatically updated the database based on the response submitted by users.

Six-hospital Research Project 3-tier web application.

Five+ year multi-hospital orthopaedic study for meaningful statistics on tibial-plafond fractures. Program integrated, in real-time, patient records from 6 Hospitals (Univ. of Iowa, Univ. of New Mexico, Univ. of Virginia, Wake Medical Center, Univ. of Tennessee - Knoxville, OHSU). Converted all relevant medical forms (SF36, MFA, SMFA, Pain Scale, Xray data, etc.) to HTML or PDF and scripted detailed, real-time project management reports to color-code by hospital, by forms completion, and by follow up visits/forms done at proper times.

Doctor Office Management Software

Web-based Orthopaedic patient/schedule management system. Allowed doctor to track patient statistics, CMEs, meetings,
and allowed staff to provide doctor with documents needed on trips anywhere in the world.

Created bid, deliverables, and timeline for third party as sub-contractor. Lead
DBA, hired additional programming staff for project, trained them in
PHP-database programming, and managed project from inception to completion.

Project so successful for first physician that many other physicians in office setup the same
thing.

Originally written in mSQL but migrated to MySQL.

Syndicate content