Clayton E. Lundy

17622 19th Ave Ct E.
Spanaway, WA 98387-1916
(253) 847-5230
 

LANGUAGES AND DATABASES:

Languages: PHP; HTML; JavaScript; SQL (Stored Procedures and Triggers); PowerBuilder; MS-Office; C/C++; Pascal; COBOL; FORTRAN; JCL; VSAM. Databases: MySQL; MS SQL Server 6.5, 7.0, 2000; Oracle; Sybase SQL Anywhere; MS-Access.
 

EXPERIENCE OVERVIEW:

Over 30 successful years in systems analysis, database design and development, applications development and maintenance, and computer programming. Includes extensive hands-on experience in computer systems development in a variety of languages, industries (government, business, accounting, scientific, and engineering), and environments (networks - wide & local, PCs, and mainframe). Have outstanding verbal and written communication skills as demonstrated by expertly interacting with both technical and business personnel.
 

 
  • 1997 - Present, Self Employed, JCL Enterprises, Inc.
    • Systems / Applications Developer / Consultant / Contractor

  • 1971 - 1997, Computer Programmer/Systems Analyst
    • Enercom, Inc. - Severn Trent Systems, Tempe, AZ
    • Computer Resource Services, Phoenix, AZ
    • Business Data Systems, Phoenix, AZ
    • Lockheed Electronics, Tucson, AZ
    • Arizona-Colorado Land and Cattle, Phoenix, AZ
    • FEI Construction, Phoenix, AZ
 

SYSTEMS/PROJECTS:

Lead Analyst/Developer. Designed, developed, implemented, and supporting database driven web sites designed to bring buyers and sellers of real estate together. Tools: PHP, MySQL.

 
 

 

Lead Analyst/Developer. Designed, developed, implemented, and supporting a database driven web site designed for the sale of various products, currently including eBooks, software, and printed books. Tools: PHP, MySQL.

 
  • Includes built in shopping cart and interface with credit card processing service.
  • Provides national exposure to enrolled authors. Site is at http://www.writerscloset.com
 

 

Lead Analyst/Developer. Designed, developed, implemented, and supporting a database driven web site designed to broker photographs, backgrounds, digital artwork, etc. The site allows photographers and other artists to upload their work for sale to the public. Tools: PHP, MySQL.

 
  • Includes built in shopping cart and interface with credit card processing service.
  • Provides national exposure to enrolled artists. Site is at http://www.writerscloset.com
 

 

Lead Analyst/Developer. Provided maintenance and support for a statewide Client/Server system, The Federal Aid Tracking System (FATS), for WA Dept of Transportation. Migrated application to SQL Server 2000. Performed testing of migration to PowerBuilder 8. Included making extensive modifications to the client/server module and several complex stored procedures. Developed several additional stored procedures to support new user requirements. FATS manages all Federal Funds appropriated to the State by the Federal Highway Administration (FHWA) and non-Federal Funds. Interfaces with the FHWA's FMIS system in Washington DC via FTP for the purpose of authorizing funds for specific projects. Tools: Powerbuilder 7.0, Powerbuilder Foundation Class Library (PFC), MS SQL Server 7/2000, and Erwin.

 
  • Manages over $300 million annually and tracks over $1 billion of Federally Funded Projects at any one time.
 

 

Lead Analyst/Developer. Provided maintenance and support for a statewide Client/Server and Web system, the Survey Information System (SIS), for WA Dept of Transportation. Migrated application to SQL Server 2000. Performed testing of migration to PowerBuilder 8. Included making extensive modifications to the client/server module and several complex stored procedures. Modified the Cold Fusion Web Module to work with the changes made in the client/server module. SIS tracks and manages over 4000 Survey Monuments statewide and interfaces with a GIS mapping system used for internet access. Tools: PowerBuilder 7.0, MS SQL Server 7/2000, Cold Fusion, and Erwin.

 
  • Saves the State and private entities over $10 million annually in surveying costs.
 

 

Lead Analyst/Developer. Provided maintenance and support for a statewide Client/Server system, the Estimates and Bids Analysis System (EBASE), for WA Dept of Transportation. Migrated application to PowerBuilder 7 and SQL Server 2000. Performed testing of migration to PowerBuilder 8. Included making extensive modifications to the client/server module and several complex stored procedures. Developed several additional stored procedures to support new user requirements. EBASE is used by Engineers, Architectural Engineers, and the State Ferries Division to estimate multi-million dollar road construction and maintenance projects. Imports contractor bids to estimate and assist in the selection for contracts award. Tools: PowerBuilder 6.5/7.0, MS SQL Server 6.5/7/2000, and Erwin.

 
  • Over 1200 users statewide.
 

 

Lead Analyst/Developer. Provided maintenance programming for the Laboratory Information Management System (LIMS) and the Region Technical System (RegTech) for WA Dept of Transportation. Migrated application to SQL Server 2000. Performed testing of migration to PowerBuilder 8. These two related systems provide the means to track and manage the status and history of material samples which are tested for standards compliance. Tools: Powerbuilder 7.0 and MS SQL Server 7/2000, and Erwin.

 
  • Makes test results available to appropriate organizations during all phases of road and bridge construction.
 

 

Lead Analyst/Developer. Designed and developed a client/server Local Employee Selection System for the Washington State Department of Veteran Affairs. The system manages the selection of applicants received at two WSDVA facilities, a Veterans Retirement Facility and a Veterans Hospital. Administers the process for current employees bidding for vacant positions. Responsibilities included business rules and process analysis, developing and documenting system requirements and specifications, and developing several complex stored procedures. Tools: Powerbuilder 6.5, MS SQL Server 6.5, Custom Class Library, and Erwin.

 
  • Provides a repository for application information.
  • Automates the preparation of referrals and processing of employee transfer requests.
 

 

Analyst/Developer. Completed the development for VetTrak, a client/server Veterinary Office Management System. Migrated the application to PowerBuilder 7.0 near the end of the development. Responsibilities included business rules and process analysis, developing and documenting system requirements and specifications, and developing several complex stored procedures. Tools: Powerbuilder 6.5 and 7.0, MS SQL Server 6.5, Custom Class Library, and Erwin.

 
  • Developed for an office with over 10,000 clients and 20,000 patients.
  • Provides services billing to animal shelters and adoption facilities.
 

 

Lead Analyst/Developer. Designed and developed TrakSoft PDM, a Home Information Management System. This is a commercial application for the market for TrakSoft. It is a Personal Data Manager with 82 database tables used to manage every aspect of the home. Responsibilities included business rules and process analysis and developing and documenting system requirements and specifications. Tools: Powerbuilder 7.0, Sybase SQL Anywhere, and Erwin.

 
  • Provides a central location for all home accounting and budgeting needs.
  • Includes personal information for all family members.
  • Plans, Manages, and Tracks events and special occasions.
 

 

Lead Analyst/Developer. Designed and developed several client/server sales tracking, order entry, and customer information systems. Responsibilities included business rules and process analysis and developing and documenting system requirements and specifications. Tools: Powerbuilder 1.0 - 5.0, Oracle, and PL/SQL.

 
  • Marketed to over 150 utility companies nationwide and internationally.
  • Enables the centralization of marketing and sales information.
 

 

Lead Analyst/Developer. Designed, developed, and maintained several client/server energy audit programs for residential and commercial structures. Responsibilities included business rules and process analysis and developing and documenting system requirements and specifications. Tools: C, Pascal, and FORTRAN.

 
  • Serviced hundreds of in home energy auditors nationwide from a central location.
  • Enabled "one stop" service with the results of the audit immediately available.
 

 

Lead Analyst/Developer. Designed, developed, and maintained several accounting, technical, job cost estimation, and invoicing systems in several environments, to include PC, timeshare and mainframe. Responsibilities included business rules and process analysis and developing and documenting system requirements and specifications. Tools: BASIC, COBOL, and FORTRAN.

 
  • Automated invoicing based on job cost estimation and job percentage completion.
  • Created specialized accounts payable, accounts receivable, payroll, and general ledger systems.
  • Reduced data entry requirements by 50 to 70 percent in some areas.
 

PROFESSIONAL CERTIFICATIONS:

Certified Professional IT Consultant, Professional Standards Institute, 2002.

Certified Professional Systems Developer, Master Level, Professional Standards Institute, 2000. Specializations: PowerBuilder, "C" Language.
 

PROFESSIONAL DEVELOPMENT:

MS SQL Server 2000 (In-house training), PROptions. 2001.

Advanced Visual Basic, Tacoma Community College, 2000

Advanced C++; Microsoft Access 2000 Level I, II, and III; Access 2000, Introduction to Application Development.Pierce College, 2000.

Upgrading Powerbuilder Applications, Introduction to Powerbuilder. Midak University, 1994, 1995

 

EDUCATION:

Bachelor of Science, University of Oregon, 1961.
Major: Physics