563-382-3118
wmcclain@watershade.net
Software Consulting, Contract Programming
All my work since 1994 has been full-time telecommuting. I have the references to show that it works well. I can make onsite visits, but recruiters please note that I am not able to relocate.
Consultant for INGRES Corporation, providing programming and migration services for their clients, including:The work has required C, COBOL and FORTRAN programming on Linux, AIX and MS Windows.
- UGI Natural Gas, Reading PA.
- MAPAQ, Ontario.
- Thomas Steel, Warren OH.
- Kemper Insurance, Long Grove IL
- APEX, New York City, NY
Consultant for the Screen Actors Guild, Los Angeles CA, doing database development and maintenance.
Senior Programmer Analyst at Mayo Foundation - Section of Clinical Trials. I was a member of the Application Support Team, writing and supporting applications for a large clinical trials effort. Large projects included:The platforms were VMS and Windows NT, the language was C++.
- the concurrent data archiver
- new labeling system which supported detailed customization of high-volume bar-code labels for lab use
- a rewrite of the report delivery system, which subsystem providing reports via printer, fax, file transfer, or online
- a rewrite of the kit creation system
- new implementation of the FaxSr delivery system as an MS Windows NT system service
Consultant at Kemper Insurance Companies. See below.
Consultant at the Mayo Foundation - Section of Clinical Trials. I designed and implemented a large archiving system. The platform was Ingres on VAX/VMS, using ESQL/C and Ingres/Star. The task was to migrate historical data out of a production database into archival databases. The archive system runs concurrently with production operations and has many performance and validation constraints. I also did Ingres ABF/4GL development.
Consultant at Kemper Insurance Companies. This was the conversion and re-implementation of a large claims processing system. The task involved migrating databases from mainframes to Ingres on UNIX platforms. The data volume was in the hundreds of gigabytes. The development language was COBOL.
Technical Support at INGRES. I supported the Chicago-area INGRES sales office, performing competitive benchmarks and developing numerous application prototypes for INGRES clients. I made extensive use of all of the INGRES application development tools, including Windows4GL, Vision/ABF and precompilers. I performed this work on a variety of UNIX, VMS and MS Windows platforms.
Consultant at UNOCAL. I designed and implemented a VAX/VMS system tuning utility for a large credit-card authorization system. This was a 7-day, 24-hour RMS-based system with no scheduled downtime. I retrofitted the system to enable on-line reorganization of the RMS indexed files, a task not normally possible on VMS. The development tools were COBOL and C.
Consultant at Generation Software, Chicago. I designed and implemented a new VAX/VMS product, a system management and optimization tool for RMS indexed files. I also wrote the documentation and supervised installation of the first customer sites.
Technical Support at Britton Lee. I supported the Chicago-area sales office, working with a combined hardware and software relational database product. The work involved numerous benchmarks, system conversions, application prototypes and customer presentations.
Systems Analyst at Pioneer HiBred. I was part of a team providing computer support for a large agricultural research effort involving hundreds of users. Our principal computing facility was a VAX cluster running VMS.I handled several system conversions while at Pioneer. In the course of several years, the data management effort was first migrated from PDP-11s to VAXes, then from native files to Ingres, and finally from Ingres to another relational database.
I did a large amount of systems design and applications programming, largely in Pascal, FORTRAN and COBOL.
Available on request