Download a copy of this resume in MS Word format.
Download a copy of this resume in PDF format.
Converted a Student Enrollment/Payment data processing system from dBase for DOS to Visual FoxPro 6.0 for the University of Minnesota, Continuing Dental Education. The system is essentially a complete re-write although some dbase code was reused. The application handles all aspects of course registration and related data entry, as well as all financial processing and invoicing. A wide variety of reports are generated by the system - from class lists and labels to transcripts. Many of the system reports are generated using OLE Automation methods to generate Word documents, rather than FoxPro reports. Converting the old system was complicated because the application needed to coexist (i.e. share data) with a dBase subsystem that will continue to be used for some time to come. As a result, table indexes are maintained in both dBase and FoxPro formats (this proved difficult), and the system is designed to avoid any possibility of dBase and Visual FoxPro components simultaneously using the same table. Current development of this system includes eliminating the dBase components, upgrading it to be fully network ready (it is currently designed for multiple users but is not being run on a network), and porting it to Macintosh.
Designed a complete Data Entry/Processing/Reporting System for the University of Minnesota, Institute of Technology Special Education Program. This system processes data based on an annual survey of Alumni of the UMTYMP (Talented Youth Mathematics Program). The design required a complex (but easy to use) data entry screen to accommodate a rather complex survey. Collected data is processed, various reports are generated, and at the end of the annual cycle, new surveys are generated from the collected data (the Survey is one of the reports). The system is also designed to interact with a web server. The mailed surveys include a password which allows the Alumni to access the survey via the internet (the password allows them to view the survey with their own historical data). Visual FoxPro code generates the HTML version of the survey on the fly when a user makes a request. It incorporates JavaScript for field validation, etc, and updates the system data on submit.
For EMR/Process Pro, a software design company that develops a value added component for SBT Accounting Software, I designed new, and modifed existing, modules written in FoxPro 2.6 and Visual FoxPro 5.0. This included form design and modification, design of reports, documentation, and analysis of customer requirements. SBT software handles all aspects of industrial data processing related to accounting, receiving, ordering and processing of inventory. Modules also exist to handle a wide variety of related industrial needs. Process Pro also customizes SBT/Process Pro for customers requiring more specialized systems. The product is designed to be run on Windows95/98/NT and may be accessed via a Citrix Server. Design and development routinely requires running Visual FoxPro on a remote site via Citrix. I wrote new code, and made modifications to, a variety of modules, such as a specialty component for adding sub-assemblies to sales orders, and a component for applying a specialty pricing scheme, as well as routinely adding and modifying reports and fixing customer reported bugs. I was also extensively involved in upgrading the Process Pro to be compatible with the (then) newest version of SBT.
Created a new application in Visual FoxPro 6.0 based on an earlier version written in FoxPro 2.6 (but not a conversion) for the University of Minnesota Institute of Technology, Center for Educational Programs. The software is a designed as a self-contained student enrollment and processing system. The system includes components for handling student pre-enrollment testing, score analysis, transfer of accepted students to current class list, tuition tracking, grading, grade reporting, transcripts, and a variety of reports, and related routine procedures, such as maintaining teacher lists, and moving former students records to history files.
Made modifications to an existing Financial Analysis System written in Visual FoxPro 6.0 for Norwest Mortgage. Contract was short-term fill in for another developer who was on leave. Designed components to export financial reports to formatted Excel Spreadsheets using OLE Automation methods. Also converted a small database application from FoxPro 2.6 to Visual FoxPro 6.0. Analyzed and debugged several other applications over the course of about two months.
Made major improvements to the user interface of an application written in Visual FoxPro 3.0 for the University of Minnesota Department of Operative Dentistry. Also removed unused code and made various technical improvements. The application reads ASCII data from a network drive and does extensive reprocessing before generating a wide variety of reports. Generally speaking, the design was technically competent but difficult to comprehend from the user point of view, so the project was essentially a matter of creating a friendly interface to insulate the users from the underlying complexity of the application. Also made extensive modifications to repair year 2000 problems, and designed a system for printing very large reports to an off-site printer on a UNIX based system. The design outputs each report to a postscript file which is ftp'd to the UNIX system. A UNIX cron script then sends each file on to the printer.
Based on work done for AFSCME designed a data entry and reporting system in Visual FoxPro 5.0. The system is designed to be a commercially distributed product, aimed at union locals and union organizing campaigns. The system records a wide variety of membership data and also incorporates perks such as extra fields that can be reassigned by the user, and the ability to add external attachments (external documents, scanned images...) to each record. A wide variety of included standardized reports and labels are designed to the typical needs of union locals. It also includes a comprehensive help system and an installation program.
As an Applications Programmer for the University of Minnesota, Mathematics created a data collection and analysis system for tracking computer service requests. Project involved analyzing a disorganized department to determine where problems existed, and providing organizational and business operations advice. The application was written in dBase IV for UNIX and ran on a SUN Solaris system. The application took advantage of X-Windows components to add functionality and improve visual appearance. Functionality includes tracking service requests by age, printing reports, etc. PC based sub application, written in FoxPro for Windows generates a progress report for administration, accessing the data via PCNFS. Later designed an experimental Web Page version of this system. Set up a PC running Windows95 as a Webserver and created a database server application with Visual dBase. The application provided all the features of the earlier app while allowing any user with a Web Browser to use the application, regardless of OS.
As an Applications Programmer for the University of Minnesota, Mathematics converted a student enrollment, data collection and reporting system written in Paradox for DOS to FoxPro for Windows in a NetWare environment with about a dozen users using 486 PC’s. Converted hundreds of tables to FoxPro format recreated data entry screens and basic reports, and assisted staff in the use of those tools and with using Windows and FoxPro in general. The project had to be constructed simultaneously with the academic year; hence, components had to be functional without the opportunity for extensive testing and without causing any interruption of academic operations. Latter improved the application by recreating screens and reports to better take advantage of Windows, FoxPro, and other system resources. Added functionality such as remote grade data entry for teachers using dBase IV for UNIX on a SUN OS network. Improved complex student testing answer sheet generation and score importing system and created system for generating better transcripts from multiple data sources. Improved or recreated applications for statistical reporting of student scoring, and grades data. Project was substantially complete in two years including refinement.
Download a copy of this resume in MS Word format.
Download a copy of this resume in PDF format.