Karl Hansen

aczsmn@r.postjobfree.com

**** ** ***** ******

Seattle WA 98166

206-***-****

Skills

Languages: PHP (6 years), jQuery (3 years), AJAX (5 years), VB (Visual Basic) 4, 5, 6 (10+ years), JSP (2.5 years),Java (2.5 years), JavaScript (8 years), DHTML (5 year), HTML (10+ years), C# (1.5 years), XML (1 year), XSLT (1 year), asp (Active Server Pages) (3 years), ASP.net (6 months), VB.Net (6 months), Transact/SQL (2 years), awk (5 years), c-shell (5 years), korn shell (7 years), perl (1 month), QuickBASIC (5 years), rexx (1 month)

Databases: MySQL (8 years), Access 2, 7, 2000, 2003, 2010, 2013 (10+ years), Microsoft SQL Server 7, 2008 (6 years), Sybase SQL Server (2 years), ODBC data connection (10+ years), ADO (8 years), DAO (7 years), RDO (1.5 years), ORACLE SQL (1 year), Paradox (2 years), 4th Dimension (2 years)

Platforms / OS: Win 10 (1 year), Win 7 (3 years), WinXP (8 years), Win2000 (6 years), Tomcat webserver (2.5 years), Apache (6 months), WinNT4 Server, Workstation (4 years), HP-UX Unix shell (4 years), Win95 (5 years), Macintosh (7 years), Apollo Unix shell (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: Excel VBA (10+ years), Visual BASIC for Applications (VBA) (10+ years), Excel (10+ years), Eclipse (8 years), VSS (Visual SourceSafe) (8 years), Word (10+ years), Visio (10+ years), Crystal Reports (3 years), COM (4 years), MS Office (10+ years), Visual InterDev (1 year), Dreamweaver (1 year), SSRS (6 months), ReportBuilder (6 months), JBuilder (6 months), JCreator (1 year), Visual Studio (2 years), Adobe FrameMaker/SGML (3 years), Alteryx (1 month), Sharepoint (3 months), Commerce Server 2000 (6 months), BizTalk (6 months), MTS (6 months), RAID (bug tracker) (6 months), Interleaf (4 years), MS Dynamics CRM (1 month), EI Dynamics (1 month), MS Schedule (1 year), jade (3 months), slack (3 months)

Karl Hansen's experience is concentrated in open-source and common end-user software and is data centric, with exposure to Information Technology / Architecture. Karl Hansen has 33 years of work experience, with several years tenure in management, including a mid-level position.

Experience

Mar/2016 - Sep/2016 Senior DBA Microsoft - Robert Half Technology

Clean and decommission the Microsoft Download Center (DLC) as part of a rehosting effort, minimizing duplication of Microsoft-sourced public-visible resources. DLC serves 22 billion downloads per year. Create Access tools that track revision history of individual downloads during the conversion process; retired 70,000 downloads in six months.

Feb/2016 - Feb/2016 UI Developer Sinclair Broadcasting - Robert Half Technology

Debug and improve a complex custom-built CRM delivering on-the-fly creation of news websites for many news organizations across America, using jade, Javascript, jsFiddle, git, BitBucket, and Slack. Exposure to Node.js, grunt, npm, masonry.

Dec/2015 - Jan/2016 Senior Developer GLY Construction - Strategery LLC

Investigate tools for use with reporting based on existing data systems. Propose changes that support data warehousing for standardized reporting. Access 2010 and 2013. Alteryx, SSRS, ReportBuilder. EI Dynamics, MS Dynamics CRM, Crystal Reports, Sharepoint.

Nov/2015 - Nov/2015 Senior Developer Wave Broadband - Robert Half Technology

Design and implement UI and backend upgrades to an existing billing and implementation database. Recommend and advise on best practices to database and UI design. Access 2010 and 2013.

Apr/2015 - Oct/2015 Project Manager Microsoft - Robert Half Technology

Manage a four member team supporting Xbox Media Application Development. Track all forum and email support requests, resulting in 90+ percent resolution within three days. Incorporate data from forum posts and email aliases into statistical analysis of trending solution Key Performance Indicators (KPIs). Evaluate alternate technologies for effective use within the group. Ensure reports show weekly and monthly trends based on real-world data. Guarantee a smooth and easily tracked flow of support operations, using time-aged SLA validation. Manage coordination meetings inside and outside the group, including remote team status calls and daily standups. Represent the support group in communications with other organizations. Create, document, and verify operational smoothness in day to day procedures. Interview and validate candidates for positions in the group. Completely revamp the team's statistics and performance data management system, allowing for custom and historical report generation on demand, suitable for both internal use and external distribution Primary team liaison between major content providers for XBOX Live (HBO GO, Hulu and Netflix) and internal Microsoft development teams developing applications for the XBOX One/360 consoles. Technologies utilized/supported include YouTrack, Visual Studio/TFS, Windows 10, SharePoint, collaborative editing.

Mar/2015 - Aug/2015 Senior Developer Amazon - Robert Half Technology

Designed and upgraded a building - service - vendor database using Access 2013 VBA.

May/2013 - Jan/2015 System Application Manager Realty In Motion (RIM), Factoria, WA

Helped implement my enterprise-wide .Net replacement invoicing system design, resulting in a 95% reduction in invoice request time. Managed and updated the Access 2010 VBA case management system for their core business processes (500+ users). Rewrote and modernized the Access 2003 VBA billing and invoicing programs. Applications use a SQL Server 2008 backend. Upgraded billing system programs from serial use to concurrent use, protecting them from "silent billing failures". Interviewed and recommend hiring. Managed ticket queues for 3+ developers. Integrated business and development processes, resulting in smooth development communication with business in a chaotic high-volume change request environment. Documented existing system configurations and best-practices, preserving tribal knowledge.

Jun/2012 - May/2013 System Application Manager RIM, Factoria, WA - Robert Half Technology

At Realty In Motion, managed the Access 2003 / 2010 VBA file management system for their core business processes. Managed the Access 2003 / 2010 VBA billing programs that send invoices to clients. Applications use SQL Server 2008 as the backend. With a small team, designed a modular, configurable replacement billing system in .Net. Document configuration and best practices, protecting against loss of tribal knowledge.

Feb/2007 - Mar/2012 Master Application Developer King County DDES, 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. Main team member for the Permit Integration project; a $1.5 million upgrade to county-wide permitting app with an estimated savings of $4 million.

Aug/2005 - present Owner, Senior Software Developer / Application Designer Strategery LLC, Burien, WA

Customized computer services for specific clients.

Mar 2011 - present: Designer and developer of a php and jQuery / Javascript website, with a php and MySQL backend. The website automates scheduling of automotive appointments and services in real-time through the dealer's systems, and involves JSON APIs and FTP updates using XML through various external vendor systems.

Aug 2016 - present: Developed my interactive resume as an Android app (https://goo.gl/Ia4htM or http://bit.ly/2iuTvph), and have a customizable eResume under development. Explore Angular website development.

Feb/2004 – Dec/2006 Senior Software Developer Nokia, Bothell, WA - Robert Half Technologies

Led a loose and remote team that 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 two supporting websites in PHP.

Nov/2002 – Dec/2003 Senior Software Developer Frank Russell, Tacoma, WA - Volt Technical

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.

Aug/2002 – Oct/2002 Senior Software Developer Frank Russell, Tacoma, WA - Volt Technical

In a loose team environment, created and extended VB6 code replacing mainframe REXX data feeds with processing through a service on Windows 2000 Server. Track code changes using VSS.

Aug/2001 – Dec/2001 Senior Software Developer Boeing, Everett, WA - Excell Data

ACCESS group, Sonic Cruiser: 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 Basic 6 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.

Nov/2000 – Jul/2001 Senior Software Developer Boeing, Renton, WA - Excell Data

HABIT group: 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.

Sep/2000 - Aug/2003 Owner, Senior Software Developer Hansen Consulting, 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.

Nov 2002: Baugh Skanska Construction (Rapidigm) – Extended and updated a website, using ASP.Net, 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. Created a database-to-xml conversion website in ASP.Net.

Sep 2000 – Aug/2003: Aetna Insurance – Upgrade hardware and software. Maintain server and PC accounts. Train users in Office programs and general computer skills.

Apr/2000 – Nov/2000 Senior Developer Microsoft, Redmond, WA - Excell Data

Commerce Server Team: 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.

Sep/1998 – Apr/2000 Senior Developer Escape Tours, Seattle, WA - Ajilon

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.

Mar/1998 – Sep/1998 Software Developer Boeing, Renton, WA - Mini Systems

Weight Engineering: 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.

Nov/1997 – Jan/1998 Software Developer Orrtax Software, Bellevue, WA - Mini Systems

Tax Software: 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.

Oct/1997 – Oct/1998 Software Developer Premier1 ISP, Sultan, WA

Internet Service Provider: 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.

Aug/1997 – Mar/1998 Software Developer Slope Indicator, Bothell, WA - Mini Systems

Commercial Engineering: 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.

Aug/1996 – Jul/1997 Technical Support Engineer Metapath Software, Bellevue, WA

Tactical Assistance Center: 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.

Aug/1989 – Aug/1996 Technical Aide Boeing -- Everett and Renton, WA

Weight Engineering: 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.

May/1989 – Aug 1989 Computer Operator Associated Grocers, Seattle, WA

Printed and distributed time-critical daily reports. Transmitted and received time-critical tapes.

Aug/1987 – May/1989 Computer Operator US Bank, Seattle, WA

Data Processing Center: 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.

Aug/1984 – Aug/1987 Computer Operator Old National Bank, Seattle, WA

Data Processing Center: 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.

Certifications: Windows 2000: MCP, MCSA, MCSE

Education

2003 MCP, MCSA, and MCSE certification Salmon Computers, Bellevue, WA

Mid-1996 AA, Math and Computers Highline College, Midway, WA

Jun/1987 Computer Science Renton Technical College, Renton, WA

Community

Jun/2001 - present Advisory Board, Computer Science Renton Technical College, Renton, WA

Sep/2000 – Jun/2003 Holy Family Choir White Center, WA

Aug/1994 - present Knights of Columbus Washington

1980 – 1984 Volunteer Resident firefighter King County Fire District #43, Maple Valley, WA

Contact this candidate