RÉSUMÉ Otis W. Auclair 946 Eighth Street (760) 788-9146 (msg) Ramona, CA 92065-2812 http://members.cox.net/otisa2/ OtisA2@cox.net Software Engineer / Database Programmer SUMMARY Experienced Software Engineer / Database Programmer with expertise using Visual Basic and Transact-SQL in conjunction with SQL Server. Also work extensively with Visual Basic and ASP web pages. Can do database tuning and other Database Administrator functions. Additional programming experience with the Visual FoxPro database management system. Eight years experience throughout career developing database software. Several secondary development projects using C and Unix scripting. Also capable in Microsoft Access, Excel, and Word. Familiar with Solaris Unix, Windows XP, NT, 2000, ME, 98, and DOS operating systems. Strengths include extensive experience making use of software engineering development processes. Excellent skills in problem solving, troubleshooting, software debugging, and providing programming support. Work well both independently and as a team member. Progressive Computing, LLC, San Diego, CA 2003 - Present Computer Programmer Develop and maintain multiple computer programs, multiple SQL databases, and company web site. * Business computer programming includes Visual Basic and Microsoft Access programs utilizing form and graphic display of data, trouble report entry and reporting, and maintaining marketing data. * SQL development includes large and small stored procedures used between many satellite servers, queries for program use, and data extraction for one time management reporting. * Web site development includes ASP, SQL, and HTML programming of input/output forms, user tracking through site, and remote connections for registration/licensing purposes. JNI Corporation, San Diego, CA 1999 - 2002 Test Engineer / Production Engineer Develop and maintain processes, equipment, and procedures to test new and existing products prior to shipment. * Designed, wrote, and implemented a system of computer programs using Visual Basic, SQL Server, and Unix scripting. Allows automated data collection and text parsing from over 50 Unix and 25 Intel test stations through an intranet. Provides failure data for hardware diagnostics and product improvement analysis. * Major participant in the development of a Highly Accelerated Stress Screen (HASS) process and lab to detect infant mortality defects prior to product shipment. * Designed, built, and maintained Sun (Unix) and Intel PC computer test stations (HASS and Functional) and external peripherals to ensure product functionality prior to shipment. * Wrote, implemented, and maintained procedures to provide test operator instructions and document test station repair and maintenance. P & M Computer, Ramona, CA 1998 Computer Hardware Technician Build and repair personal computers to provide customers quality systems. * Install internal and external peripherals and related software to provide additional capabilities. * Install and verify operating systems, computer applications, and hardware device drivers. * Diagnose hardware and software to repair computer malfunctions. Auto & Tire Center, Ramona, CA 1994 - 1998 Small Business Owner Performed all aspects of business management including accounting and writing custom computer business applications to improve efficiency, reduce errors, and ensure customer satisfaction. * Wrote database software maintaining information on customers, vendors, deposits, credit card transactions and other data to provide reliable business accounting. Used Microsoft's Visual FoxPro relational database software and transact SQL for database query. * Designed, wrote, and implemented a system of relational database programs to provide customer billing and control improving efficiency and increasing customer satisfaction. * Developed software to perform environmental control of underground gasoline storage tanks to ensure safe operation and compliance with federal regulations. Martin Marietta Astronautics, San Diego, CA 1989 - 1994 (formerly General Dynamics Space Systems) Senior Software Quality Engineer * Designed spreadsheet database to record Software Trouble Report status. Developed program using Microsoft Excel scripting to provide automated analysis and status reports for management. * Conducted SQA activities on flight, ground, and support software compliant with DOD-STD- 2168 and DOD-STD-2167A to satisfy government contracts (Secret Security Clearance required). * Performed software requirements traceability and testability verification from contract specifications to final product. * Verified software design to product source code to confirm code written as designed ensuring accurate transition from design to test. Teledyne Ryan Electronics, San Diego, CA 1983 - 1989 Software Quality Engineer * Performed the systems analysis, designed, wrote, and implemented a system of computer programs that allowed statistical graphic reports and interrogation of QA Product Test and Inspection results. Significantly improved project status and Quality reporting. Utilized dBase II / III relational database management software (the original xBase programming language currently used in FoxPro). * Wrote many additional computer programs enhancing other QA and Manufacturing activities. * Wrote and implemented Software QA manual, SQA procedures, Software Configuration Management Plan and contract specific SQA Plans. * Performed software requirements traceability and testability verification from contract specifications to final product. EDUCATION * Bachelor of Science degree in Computer Science from National University. * Associate of Science degree in Computer Science Information Systems from Grossmont College. Emphasis in Computer Programming and Systems. * Associate of Science degree in Business Administration from Grossmont College. Also earned a Specialized Certificate in C Programming from UCSD Extension. MILITARY United States Navy. Honorable discharge as EN3. Vietnam era Veteran.