Dave Guerin

Dave Guerin

3211 S Barrington Ave #I, Los Angeles, CA 90066

(310) 391-7451

e-mail: dguerin38@hotmail.com

Summary: Over twenty years application development involving programming with business and engineering analysis. Extensive database design with business application development including low-level DOS interrupt coding and Windows API calls. Ten years in former career as Human Factors Engineer in the Aerospace industry providing man-machine interface and statistical analysis, human engineering in hardware design for weapons systems.

Application development has included the following languages and technologies. VB.NET, ASP.NET, Visual Basic (3-6), Visual Interdev, COM/DCOM, MTS, ADO, ASP, Clarion, C, QuickBASIC, SQL Server and Oracle.

System architectures include monolithic, stand-alone DOS and Windows applications, client server (two-tier), Microsoft DNA based, three-tier, distributed applications to Microsoft's .NET Framework using VS.NET. I am entirely self-trained and have never cost an employer one-cent for training. I have used my self-taught knowledge to mentor other programmers in new technologies (at the same time learning from them - no one knows all of this stuff).

Aerospace experience includes two stints as production supervisor and another as engineering supervisor. Skilled at analysis, debugging and just making things work.

Top Projects Clients Education

Partial Software Project List
Commercial Windows Software Development

Tools: VB, CLW, DWMX, JS, WSFTP, TCP/IP, IE, XML, PayPal, HTMLed, FI3

Design: Windows Applications available through commercial websites using PayPal system implementation complete with custom supporting Database Administration.

Description: Home and business user commercial applications marketed and distributed over Internet with download, paymement and business administration infrastructure. See Address book organizer software, PageWon and others.

Client Applications Accessing Oracle, SQL Server and Access Databases Supporting Baan ERP System.

Tools: Visual Basic 6.0, Visual Interdev 6.0, Oracle 7.3, SQL Server 7.0, ADO, RDS, COM/DCOM, MTM Design: Three-tier client/server, distributed component architecture, with code generated by VBeXpress using custom templates, providing stateless classes that are re-usable for both Windows and Web based applications. Description: Applications provide custom user support for ERP system and other business purposes. Using VBeXpress with my custom-written templates, applications were generated from properly designed Oracle, SQL Server and Access databases, providing architecture and pure Visual Basic code that saved over fifty percent of the work required to develop sophisticated 3-tier distributed component applications.

Art Books Bookstore and Supplies Application

Tools: Visual Basic 5.0, Visual Interdev 1.0, SQL Server.
Design: Three-tier client/server, business rules encapsulated in out-of-process server, connected to SQL Server backend with RDO.
Description: Tracks inventory, sales, customers to run internet based bookstore. Preliminary work for eventual deployment as interactive web application.

SQL Statement Builder

Tools: Visual Basic 4.0 Enterprise, SQLAnywhere.
Design: Utility program accessing SQLAnywhere database using RDO.
Description: Program displays any database table with columns and keys in separate list boxes along with SQL statement entry controls and result grid on one form that allows users to build SQL statements by key-in or by modifying help-file examples while viewing on screen database schema.

Contact Manager Program

Tools: Visual Basic 3.0, Crystal Reports.
Design: Online transaction processing managed by Jet relational database.
Description: Contacts can belong to unlimited number of user defined categories with original data entered only once. Data managed comprehensively or by category. Phone dialer, unlimited phone numbers, notes, calendar, call history and more.

Financial Data Calculation & Form Filler Program

Tools: Clarion for Windows, SuperTagging templates, CPCS Reports
Design: Online transaction processing managed by Clarion relational database on Novell network.
Description: Financial data calculated and managed to output precise report forms read by Sungard mainframe application.

Money Transfer Transactions Program

Tools: Clarion for Windows, SuperTagging templates, CPCS Reports
Design: Online transaction processing managed by Clarion relational database on Novell network.
Description: Manages very large money transfer tickets for daily posting to binary file written to network directory where it is read by mainframe application which transmits actual money transfers.

Medical Application Security System

Tools: Clarion for Windows, standard and modified C3 templates.
Design: Online transaction processing managed by Clarion relational database TPS file system on Novell network.
Description: Security is established at the screen field and control level for any screen in very large, multi-module application by permissions established by application administrator. All security module code is contained in an extensive, extension template and several forms implemented as a DLL. System is activated for any screen in any module by simply activating the security extension template.

Radiation Lab Management System

Tools: Clarion DOS, Causeway (DOS-extender linker), multiple LEMs.
Design: Online transaction processing managed by Clarion relational database DAT file system on Novell network.
Description: Contributed to design and coding of major upgrade to multi-module (20 Meg) system managing all aspects of large, radiology laboratories including patient administration, scheduling, transcription, insurance, history, accounting and more. Implemented DOS-extender linker which eliminated chronic memory problems.

Medical Office Management System

Tools: Clarion DOS, Visual Basic 3.0.
Design: Online transaction processing managed by Clarion relational database DAT file system. Partial redevelopment for Windows in VB3 with Jet.
Description: Comprehensive system managing busy Ophthalmologist practice includes modules for patient administration, scheduling, insurance reports, medical history, accounting and more.

Automatic Appointment Verification Program

Tools: Clarion PD, Rhetorex four-line dialing board.
Design: Online transaction processing with Clarion database coded to access dialing board API via DOS interrupts.
Description: Dials four numbers simultaneously from list selected by user criteria from database for any outcall purpose and automatically routes call results to selected workstations monitored by operators who update database while on line.

Top Projects Education

Work History
ScribbleSoft, NamesnStuff, PageWon, Los Angeles, California: 2002-Present: Commercial Software Developer
Graffics Bindary, Northridge, California: 2000-2002: VS.Studio Devloper using VB.NET, ASP.NET
Industrial Dynamics, Torrance, California: 1998-2000: Senior Application Developer
Todaro Systems, Inglewood, California: 1997-1998: Programmer/Analyst (Contract)
Dai-Ichi Kangyo Bank, Los Angeles, California: 1996-1997: Programmer/Analyst (Contract)
Professional Practice Systems, Los Angeles, California: 1995-1996: Programmer/Analyst (Contract)
Radman, Incorporated, Santa Monica, California: 1993-1995: Senior Software Engineer
Professional Practice Systems, Los Angeles, California: 1992-1993: Programmer/Analyst
PC Resolutions, Los Angeles, California: 1990-1992: Programmer/Analyst
McDonnell Douglas, Los Angeles, California: 1988-1990: Senior Industrial Engineer (Contract)
Northrop Electronics Division, El Segundo, California: 1985-1988: Senior Industrial Engineer (Contract)
Amex Systems, Inc, Compton, California: 1981-1985: Industrial Engineer (Contract)
Teledyne Microelectronics, Marina del Rey, California: 1980-1982: Production Supervisor
Don Baxter, Inc, Glendale, California: 1978-1980: Production Supervisor
Hughes Aircraft Company, Culver City, California: 4/73 - 1978: Group Head, Human Factors
Litton Industries, Culver City, California: 4/70 - 1973: Human Factors Engineer

Dave Guerin

Copyright(c) 1997 Dave Guerin and The Software Contractors' Guild, Post Office Box 257, Nottingham, NH USA 03290-0257