Kohnen Consulting Resume Highlights: SQL Server DBA, ASP and ASP.NET, VB.Net, C#, ColdFusion, JavaScript, HTML, VBScript, IIS, VB, PowerBuilder, Test, NT, C, C++
Home
 		Resume
 		Rates & Availability
 		Contact
   Home Office/Msg. (360) 438-0437    Cell (360) 790-2762

Resume

kept up-to-date at http://www.kohnen.com/resume.cfm & as a Word document at http://www.kohnen.com/ekresume.doc

Eric Kohnen

Kohnen Consulting
5201 Vine Ct. NE
Olympia, WA 98516-1416
Email:
Home Office/Msg.: (360) 438-0437

Summary of Qualifications
Extensive experience in the development of database driven systems with web and client server interfaces. Positions have included Database Administrator, Database Developer, Web Developer, Application Developer, Web Architect, and Webmaster.

Skills
Operating Systems Windows Operating Systems, Unix
Computer Languages SQL, Visual Basic, Visual Basic.Net, C#, VBScript, JavaScript PowerBuilder, C++, C, and others
Databases Microsoft SQL Server, Sybase, Oracle, Access, and others
Other Tools Active Server Pages (ASP), ASP.NET, ColdFusion, Visual Studio, Internet Information Server (IIS), VBScript, JavaScript, HTML, DHTML, DOM, COM, COM+, Visual Source Safe, Crystal Reports, Red Gate, ERwin, Visio

Education
BS Computer Science, University of California Irvine
BS Electrical Engineering, University of California Irvine
Recent Training Developing Web Applications with Microsoft Visual Basic .Net and Microsoft Visual C# .Net, Deep ASP.NET Mini Camp, Data Warehousing Using Microsoft SQL Server, SkillBuilding with ColdFusion, Data Modeling & Database Design with ERwin, Performance Tuning and Optimization of Microsoft SQL Server

Recent Web Sites
Puyallup Assessment Data System Provides teachers and administrators online access to students' assessment tests (such as the WASL). This is an ASP.NET web application (using VB.NET). (Link provides screenshots only.)
http://www.kohnen.com/PADSscreenshots.cfm
Accounts Receivable /Collections Replaces the functions previously provided by eighteen different accounting systems at the Department of Labor and Industries. This is an ASP.NET web application (using VB.NET and C#). (Link provides screenshots only.)
http://www.kohnen.com/ARCscreenshots.cfm
SQL Server Database Administration forum Public discussion group where I answer SQL Server questions.
http://67.171.62.98/sqlsupport/DesktopDefault.aspx (ASP.NET 2.0 using C#)
Kohnen Consulting ColdFusion based web site with a SQL Server back end advertising my services as a Technical Consultant.
http://www.kohnen.com
DSHS Client Registry Secure Intranet access to data about services provided to Department of Social and Health Services (DSHS) clients. This site was developed using Active Server Pages (ASP).


Experience
KOHNEN CONSULTING, Olympia, WA (2/99 to present)
Technical Consultant, at Department of Natural Resources, Olympia, Washington (6/06 to 11/06)
Provided development of C# windows application with Oracle backend. This application provides tracking of engineering and building tasks and expenses. Development included creation of a new build process and creation of Oracle stored procedures and packages.

Technical Consultant, at Puyallup School District Information Technology Center, Puyallup, Washington (9/05 to 6/06)
Provided maintenance and data loading for ASP.Net web site with SQL Server backend. This VB.Net web site provides teachers and administrators online access to students' assessment tests (such as the WASL). Maintenance included bringing the project under source control using Microsoft Visual SourceSafe, configuring machines for code development, loading/using Red Gate database management tools, creating and updating Crystal Reports, updating documentation, and mentoring and training permanent staff to maintain the system.

Technical Consultant, at Washington State Department of Labor and Industries, Tumwater, Washington (8/03 to 7/05)
Provided ASP.Net web site development and Microsoft SQL Server development for department wide Accounts Receivable/Collections system with messaging interfaces to departmental relational and mainframe databases. This system encompasses the functions previously provided by eighteen different accounting systems within the department. Web pages were developed using VB.Net, C# (C Sharp), Visual Basic Script, JavaScript, HTML, DHTML, XML, and COM and COM+ business objects. Database stored procedures and triggers were developed in Transact SQL. Tools used include Internet Information Server (IIS), Visual Studio .NET, Visual SourceSafe, MQ Series messaging queue, and Crystal Reports. Provided documentation, training, and mentoring to permanent staff to enhance the transition from system development to maintenance.

Technical Consultant, at Washington State Department of Labor and Industries, Tumwater, Washington (1/01 to 6/03)
Provided Active Server Pages web site development and Sybase and Microsoft SQL Server development and database administration for enterprise data collection and reporting systems with interfaces to Sybase, Informix, and ADABAS databases. These systems collect and report on safety and health inspections and consultations and industrial insurance accounts receivable financial and accounting information. Web pages were developed using Visual Basic Script, JavaScript, HTML, DHTML, and COM and COM+ business objects. Database stored procedures and triggers were developed in Transact SQL. Tools used include Internet Information Server (IIS), Visual Interdev, Visual SourceSafe, and EntireX messaging queue. Provided documentation, training, and mentoring to permanent staff to enhance the transition from system development to maintenance.

Technical Consultant, at Vulcan Northwest, Seattle, Washington (9/00 to 1/01)
Provided SQL Server Database Administration and Development at Vulcan Northwest in support of a geographically distributed and replicated multimedia storage system with a multi terabyte data store. Duties included installation, administration, and maintenance of SQL Server 2000 and SQL Server 7.0 databases, troubleshooting Active Server Pages (ASP) accessing SQL Server data, and creating and debugging stored procedures.

Technical Consultant, at the Law Enforcement Support Agency, Tacoma, WA (6/00 to 8/00)
Provided SQL Server Database Administration and Development at the Law Enforcement Support Agency in support of 2400 users, 8 servers, and 60 GB of data in 150 databases. Duties included installation, administration, and maintenance of SQL Server 7.0 databases, troubleshooting Active Server Pages (ASP) accessing SQL Server data, creating and debugging stored procedures; and adding and changing NT and SQL Server logons, users, and groups.

Technical Consultant, at iMonitoring.com, Mountain View, California (12/99 to 6/00)
Provided SQL Server Database Administration and Development at iMonitoring.com, a Silicon Valley start up. iMonitoring.com created a service allowing the owners of on-site closed circuit television systems to access, via the Internet, live and archived video from the cameras they own. Duties included installation, administration, and maintenance of SQL Server 7.0 databases, creation and maintenance of data models using Visio, testing of Java web pages, creation of stored procedures that interface with Java based web site, determination of the architecture and specification of the hardware for a multi Terabyte data store, installation of Oracle Financial accounting package, and evaluation of SQL Server 2000.

Technical Consultant, at Kiss.com, Seattle, Washington (11/99 to 12/99)
Provided SQL Server Database support at the Internet's largest picture personals web site. For this ASP based web site, debugged and rewrote the stored procedures that provide email reports to members, informing them of people that they may be interested in contacting. Created stored procedures to determine mutual interest (listing people that may be interested in contacting the member as well). Recommended changes to web site and search procedures to increase the number of simultaneous users that can be supported.

ANALYSTS INTERNATIONAL CORPORATION (AiC Seattle), Seattle, WA (4/98 to 10/99)
Technical Consultant, at Washington State Department of Transportation (WSDOT), Olympia, Washington (8/98 to 10/99)
Provided SQL Server Database Administration support for WSDOT Management Information Services. The databases administered are on 4 Servers in 170 databases. These database servers have a total of 6,500 user logins.

The wide range of services provided for this SQL Server / PowerBuilder Client environment included: creating and maintaining databases; troubleshooting SQL Applications; creating and debugging stored procedures; restoring databases from backup; adding and changing SQL Server logons, users, and groups; and converting Access Databases to SQL Server Databases.

Created accounting applications in PowerBuilder calling Dynamic Linked Libraries created in C++ to provide a means of calling Windows API functions to securely authenticate users (using Security Service Provider Interface). Used ColdFusion to create an Intranet web site detailing database administration services I provided and allowing remote site administrators to create database accounts and verify the current status of end user accounts before requesting changes.

Technical Consultant, at Weyerhaeuser Corporation, Tacoma, Washington (4/98 to 8/98)
Created and ran "Scenario" test scripts to test a pricing, accounts receivable, order entry, and tracking application for Weyerhaeuser's corrugated box factories. This is a Visual Basic and C++ application with a SQL Server back end, customized for Weyerhaeuser by Witron. I discovered and documented more than 2 1/2 times as many bugs as any other tester on my test team; I personally discovered and documented 60% of all the bugs found by the 5 person test team.

DEPARTMENT OF SOCIAL AND HEALTH SERVICES (DSHS), Olympia, Washington
(4/94 to 4/98)
Technical/Database Manager, Client Registry Project
Ported DSHS Mental Health Division's Client Registry database from Sequent platform to Compaq Proliant 4000 (Quad Pentium) server. Added Client Registries from multiple DSHS divisions to Client Registry database. Demonstrated capability to automatically find probable matches among the client identities from the divisions. Developed monthly reports from the Client Registry tabulating clients utilizing services from multiple divisions. Published monthly summaries of cross division service utilization to departmental web pages.

Led the design, coding, testing (including scripted functional test, usability test, and load test), problem tracking, and continuous upgrading of a Visual Basic tool to access the Client Registry.

Created secure web pages to access the Client Registry database. These web pages have approximately 4000 users statewide. These pages use Active Server Page (ASP) technology and are maintained using Microsoft Visual Studio and Visual InterDev.

Designed and implemented file system and database backup procedure with onsite and offsite storage. Designed and implemented archival storage procedures. Designed, implemented, and documented operational procedures for loading and posting data to the Client Registry database. Coded and maintained Visual Basic application to load data and additional utilities in C.

Named a DSHS 1997 Outstanding Employee and Outstanding Team member.

Also used ERwin, Internet Information Server (IIS), and Visual Source Safe.

THE BOEING COMPANY, Seattle, Washington (9/81 to 4/94)
Lead Test Engineer (10/93 to 4/94)
Performed system level test of Boeing's Cabin Management System for the 777 airplane. Discovered and reported problems at a faster rate than any other test engineer in my workgroup of 10 engineers.

Supported the conversion of the project's problem reporting system from a paper system to an online system for entry of problem reports into an Ingres database, by providing entry screen design, beta testing, user training and written instruction, and compiling the users' list of suggestions for improvements to the problem reporting system.

Lead Test Engineer (2/92 to 10/93)
Wrote tests of the system software for Boeing's Manufacturing/Engineering Test Station. Discovered and reported more problems than any other test engineer in my workgroup of 15 engineers. Programming was done in C using X Windows and Unix in a Local Area Network with HP X terminals and Sun file servers. Problem reports were stored in an Oracle database.

Manufacturing Systems Analyst (1/91 to 2/92)
Designed, coded, tested and debugged manufacturing work station software for the Finish Cell at the Boeing Sheet Metal Center. The Finish Cell is where every part produced in the factory receives corrosion resistant coating. The software in the Finish Cell provides instruction and information to machine operators, a means of controlling the material handling systems, communication with other factory computing systems, and storage of appropriate data to an Rdb database. Programming was done in C on a Networked VAX cluster using VMS.

Manufacturing Systems Analyst (9/89 to 1/91)
Specified the hardware and software architecture of the Boeing Sheet Metal Center's Chemical Monitoring Laboratory Controller. Programming was done in C on a Networked VAX cluster using VMS. Initiated a problem report system on an IBM PC using a Paradox database.

Lead Design Engineer (3/88 to 9/89)
Designed, coded, tested and debugged software for a microprocessor based flap control unit for the 747-400 airplane. For this project my group created new standards for clear program documentation and good configuration management. In keeping with these standards, created programs that produce documentation files directly from the code, eliminating any possibility of documentation errors. Programming was done on a VAX cluster using VMS.

Senior Engineer (11/85 to 3/88)
Led design of memory access hardware for a 13 processor computer for radar processing. Design simulation was done in C on a Networked VAX cluster using Unix. (9/87 to 3/88)

Graduated from Boeing Computer Services' 1 year Artificial Intelligence Associates Program. My project was to port an expert system shell language, written in C, to a 20 processor Sequent computer with a parallel Networked Unix operating system. (9/86 to 9/87)

Specified requirements for an Artificial Intelligence chipset for Boeing's High Technology Center, and for the radar processing computer mentioned above. Project support was provided by a VAX cluster using Unix. (11/85 to 9/86)

Lead Electrical Engineer (3/84 to 11/85)
Led design, test, and debug of microprocessor based hardware to interface between the AWACS (Advanced Warning and Control System) computer and simulation equipment. Led the design and implementation of a microprocessor-based interface between radar and AWACS computers.

Software Engineer (9/81 to 3/84)
Upgraded AWACS software. Implemented an error message retrieval system that cut the tape storage requirement by 67% and error message retrieval time by 83%.

BURROUGHS CORPORATION, Mission Viejo, California (7/80 to 9/81)
Associate Test Engineer - Associate Test Engineer - Performed hardware checkout of a new multiprocessor computer. Designed a memory control system for a multiprocessor computer.

Updated 4 January, 2007