Karl Hansen

1460 SW 151st Street · Burien, · WA · 98166 · Home: · (206) 428-7658 · a2brute@yahoo.com

Objective
A senior programmer/analyst position to design and develop custom client/server and Web-based applications.
Certification
· MCP
· MCSA, Win2000
· MCSE, Win2000
Skills
· Languages: Java (2.5 years), JSP (2.5 years), AJAX (1.5 year), JavaScript (4.5 years), XML (8 months), XSLT (1 year), PHP (6 months), VB.Net (6 months), asp (Active Server Pages) (3 years), VB (Visual Basic) 4, 5, 6 (9 years), HTML (7 years), Transact/SQL (9 months), perl (1 year), awk (5 years), c-shell (5 years), korn shell (7 years), COBOL (1 year), FORTRAN (6 months), QuickBASIC (5 years), REXX (1 month)

· Databases: MySQL (2.5 years), Microsoft SQL Server 7 (2.5 year), Sybase SQL Server (2 years), ORACLE SQL (1 year), Access 2, 7, 2000 (6 years), Paradox (2 years), 4th Dimension (2 years), ADO (4 years), DAO (7 years), RDO (1.5 years), ODBC data connection (10 years), Jet database (11 years)

· Platform / OS: Tomcat webserver (.52 year), Win2000 (5 years), WinNT4 Server, Workstation (4 years), Win95 (5 years), HP-UX Unix shell (4 years), Apollo Unix shell (7 years), Macintosh (7 years), Sequent Unix (1 year), Lynx Unix (1 year), Linux (1 year), OS/2 (1.5 years), TI minicomputer (2 years), IBM 3203 printer (2 years), IBM 3800 printer (5 years), IBM 360 (5 years), JES2, JES3 (5 years)

· Tools: Eclipse (2 years), Excel VBA (12 years), Dreamweaver (1 year), JBuilder (6 months), JCreator (1 year), Visual InterDev (1 year), VSS (Visual SourceSafe) (6 years), Excel (12 years), Word (11 years), Visio (7 years), Visual Basic for Applications (VBA) (5 years), Crystal Reports (6 months), Visual Studio (2 years), Commerce Server 2000 (6 months), BizTalk (6 months), MTS (6 months), RAID (bug tracker) (6 months), COM (2 years), ActiveX (10 years), Adobe FrameMaker/SGML (3 years), Interleaf (4 years), MS Office (11 years), MS Schedule (1 year)
Experience King County DDES
February 2007 - Present Master Application Developer Renton, WA
Technical lead for a group of five developers maintaining the county's business and land use permitting systems in .Net, Visual BASIC, Crystal Reports, asp, Access, Excel, and php. Implement new designs for permit investigation and maintenance. Key player for a $1.5 million upgrade to county-wide permitting app; estimate savings of $4 million.
Nokia (Robert Half Technology)
February 2004 - October 2006 Senior Developer Redmond, WA
Created, implemented, and automated a multi-Gigabyte-per-month MySQL database engine serving a JSP and Java Tomcat website and various application data download tools; informally recognized as first of its type in the nation. Database is automatically fed and extended from data feeds. Technical lead architect for the group, and lead developer for same database and the website. Coordinate conversion and integration of common tools into website. Create data analysis and manipulation tools in Excel VBA. Created support websites using object-oriented AJAX-enabled PHP.
Skanska Construction (Rapidigm)
November 2002 - August 2004 Senior Developer Seattle, WA
Extended and updated a website, using VB.Net, XML, and XSLT, that let users submit job estimation and budgeting forms company-wide for centralized processing. Changed the project from one job-code library to multiple libraries for cost validation; created additional output types for integration with other systems.
Frank Russell (Volt Technical)
November 2002 - December 2003 Senior Developer Tacoma, WA
In a loose team environment, designed and coded an interactive analysis engine using Excel 97/2002 VBA and Sybase SQL, which retrieved and formatted data from a Sybase database.
Hansen Consulting
January 2002 - Present Owner, Proprietor, Senior Developer Burien, WA
· Aug 2003: Converted a website from cgi/perl to IIS/asp on a three-week schedule. This included creating new shopping cart technologies and database re-design.
· Aug 2002: Central Livestock Supply, Ellensburg, WA – Created automated functions for matching physical inventories against database-recorded inventories using Excel VBA.
Boeing (Excell Data)
August 2001 - December 2001 Senior Developer Everett, WA
· Using Visual Basic 6 and Excel VBA, design and implement cross-platform methods for the creation and manipulation of original engineering data
· Design website automation using asp and Visual InterDev.
· Code data processing and presentation systems in existing macro languages for a variety of groups using Excel VBA.
· Convert FORTRAN programs into Visual Basic6 and Excel VBA.
· Create visual and streamlined representations of downloaded output files in Excel
· Automate the transformation, delivery, and processing of data between disparate systems using Unix, rsh, ftp, and Visual Basic 6 COM objects.
Boeing (Excell Data)
November 2000 - July 2001 Senior Developer Renton, WA
· In a team environment, developed a COM/MTS based three-tier Web application on WinNT4 Server using asp, JavaScript, and Visual Basic 6. The application tracks variations in hardware manufacturing during the airplane construction cycle.
· Created and managed Web and VB projects using Visual InterDev 6 and Visual SourceSafe.
· As System Analyst, designed and documented various processes for the Web application.
· Wrote stored procedures to manipulate data in Microsoft SQL Server 7 using Transact/SQL.
Aetna Insurance (Hansen Consulting)
September 2000 - Present System Maintenance Seattle, WA
· Upgrade hardware and software.
· Maintain server and PC accounts.
· Train users in Office programs and general computer skills.
Microsoft (Excell Data)
April 2000 - November 2000 Senior Developer Redmond, WA
· In a team environment, extended, debugged, and maintained business-to-business e-commerce software on Win2000 using Visual InterDev, VB6, VSS, Microsoft SQL Server 7 and ADO, and asp.
· Created and maintained code across their Solution Site, which demonstrates the capabilities of the product.
· Responsible for the core object that zipped and unzipped orders into their order system using XML and VB6.
· Created system configuration guides for integrating BizTalk and Commerce Server 2000.
· Tracked source code changes using RAID.
Escape Tours (Ajilon)
September 1998 - April 2000 Senior Developer Seattle, WA
· Designed and implemented a three-tier COM business system on WinNT4. This system tracked and ran all critical portions of the company's booking and travel services, including daily operation reports and reservation faxes for clients, except for actual bookings.
· Created and documented 100+ programs, using VB5, Transact/SQL, and VSS, and upgraded existing software for a travel broker system.
· Upgraded and overhauled automated booking confirmations to hotels. The faxes were sent electronically from an OS/2 system.
· Extended and documented a 100+ table Sybase SQL Server database that was accessed through RDO.
· Extended portions of the database to the Internet using asp and Jet databases downloaded from their core database.
Boeing (Mini Systems)
March 1998 - September 1998 Software Developer Renton, WA
In a team environment, designed and created "WPS3", a front-end and database system for an assembly and tracking tool on WinNT4, using VB5, Adobe FrameMaker/SGML, and Access 7. "WPS3" tracks and edits all Weight and Balance Manuals for Boeing, allowing for easy assembly and delivery of mission-critical manuals. The system sent text-file descriptions of documents to a Unix system for manual assembly. Manual creation times decreased to hours from weeks.
OrrTax Software (Mini Systems)
November 1997 - January 1998 Software Developer Bellevue, WA
Designed and created "Catalog Manager" on Win95, using Access 97, ODBC, and an ActiveX FTP control from Crescent. "Catalog Manager" allows complex association of customer-deliverable files, and automated updating of those files on local and remote servers and databases.
Premier1 ISP
October 1997 - October 1998 Software Developer Sultan, WA
Designed and created a billing and invoice database for customer accounts and Internet service on Win95, using Access 97. This database let them change their business rules concerning billing and dependencies of service, and print invoices based on customer services that ended at irregular intervals.
Slope Indicator (Mini Systems)
August 1997 - March 1998 Software Developer Bothell, WA
In a team environment, designed and created "DigiPro Win95/NT" on WinNT4 and Win95, using VB5, DAO, Access 7, ActiveX controls, and VSS. DigiPro is a geo-technical sensor graphing program, allowing viewing of different construction site sensor measurements in a document-format, and permitting "what-if" tweaking of desired data.
Metapath Software
August 1996 - July 1997 Technical Support Engineer Bellevue, WA
· In a team environment, configured, tested and installed complex Unix software using the Lynx Unix, Sequent Unix, and Transact/SQL for Oracle.
· Handled real-time customer problems in the Telecommunication industry. Customer requests arrived in person, via email, or over the phone.
· Designed, built and administered tools for daily company use using VB4, VB5 and Access 7.
· Provided consulting and advice for other organizations within the company, which required finding and verifying information for use by other people. Requests from internal customers were handled with personal visits, using the phone, and by email.
Boeing
August 1989 - August 1996 Technical Aide Everett, WA
· In a team environment, designed, created, and implemented a database and application front-end to a document management system on WinNT4 Server using VB5, Access 2 and HP-UX Unix shell. The system tracks past, present, and future weight and loading requirements and specifications for all Boeing Commercial aircraft.
· Designed, coded and helped implement the first Part-Level Weight database of a Boeing airplane, which was accurate to within 500 pounds (0.1% accuracy). The system was written using mainframe downloads, Excel macros, and HP-UX Unix shell.
· Designed, created and implemented a Unix script that processed interior airplane designs and reported center of gravity data, using Apollo Unix shell and awk. Time savings averaged three hours per processing run.
· Designed and created a database that handled the checklist verification of airplanes for delivery to customers using Access 2 and VB4.
· Designed a database that handled different on-the-fly description of seat loading patterns using Apollo Unix shell and awk.
· Created and maintained code that designed standard interiors for all Boeing 737 Weight and Balance manuals, using Context macros and FORTRAN.
· Developed and maintained software to improve smooth flow of production, using Macintosh QuickBASIC, Apollo Unix shell, Interleaf, and ASCII-to-template Interleaf filters.
· Ran a help desk for IBM PC, Apple Macintosh, Apollo Unix, and HP-Unix (120 user requests per month). Duties included a wide range of topics, from minor user requests to designing computing solutions.
· Responsible for allocation of a $250,000 computing budget, computer account security, and general maintenance of computer systems.
· Provided occasional assistance to a central computing group.
· Converted two TI minicomputer's data and programs to PCs or Unix accounts.
· Assisted a group of 60 - 70 people with facilities requirements, personnel locations, details, and moving of people and equipment three times.
US Bank
August 1987 - May 1989 Computer Operator Seattle, WA
· Printed and distributed time-critical daily reports, using IBM 3800 printer.
· Transmitted and received time-critical tapes using IBM mainframe.
· Cross-trained personnel on JES2 and JES3 during mainframe changeover.
Old National Bank
August 1984 - August 1987 Computer Operator Seattle, WA
· Scheduled and executed critical jobs on an IBM mainframe using JES2.
· Printed and distributed time-critical daily reports, using an IBM 3800 printer and an IBM 3203 printer.
· Transmitted and received time-critical tapes.
· Used bank's IBM PC to automate jobs.
· Only survivor in my department of a merger with U. S. Bank.
KCFPD #43
June 1980 - August 1984 Firefighter Maple Valley, WA
· As a resident firefighter, provide emergency medical and fire control assistance to a community of 30,000
· Manage the department's computers, implementing a series of programs tracking basic fire department functionality.
Education Salmon Computers
2003 Associates
MCSA, MCSE
Bellevue, WA
MCP, MCSA, MCSE certification
Highline Community College
June 1996 Associates
Math and Computers
Midway, WA
AA, Math and Computers
Community
· Renton Technical College, Advisory Board for Computer Science
· Holy Family Church Choir
· Knights of Columbus