John D. Hardin

17014 Broadway Avenue
Snohomish, WA 98296-8031
(360) 668-5342
  I am a skilled designer and developer of large database applications with a decade's experience of working effectively in a "Virtual Office" environment, maintaining productivity, team communications and product quality while telecommuting full time. I have been repeatedly praised by clients for the level of support I have provided when they are experiencing complex, urgent problems that were escalated from frontline customer support. I have a long history of administering computers, networks and database services and providing consultation, training and mentoring for my colleagues at all skill levels. I am a US Citizen by birth.
Please see Recommendations at LinkedIn.
  December, 2004 to July, 2020 (15½ years)
Senior Retail Applications Developer and Database Architect
CRS Retail/Epicor Retail/Aptôs
Lynnwood, WA
  Designed, developed, maintained and supported retail customer relationship management application suite used by Buckle, Build-a-Bear, Carters, Christopher and Banks, Cole Haan, Famous Footwear, Grupo Axo, Michael Kors and many other large and high-end retail brands in multiple countries. Received praise from colleagues and a company award for technical skills, mentoring and colleague training. Received praise from clients for quality and responsiveness of escalated issue support.
  • Corporate "fat client" retail application, frontend Winforms UI and backend service development in C#
  • RESTful retail webservice development in C# and ASP.NET Core
  • RESTful retail microservice development in Typescript with Node.js
  • RESTful webservice quality assurance using Postman, including developing database-driven test automation
  • RESTful webservice performance testing, analysis and tuning
  • Utilization of Agile/Scrum development processes
  • Design of large (20+ million customer, multiple hundred million transaction) retail customer relationship management database
  • Application design and technical advisory consultation with business analysts and project managers
  • SQL query and stored procedure development and performance tuning for SQL Server 2000 - 2019
  • Business report development using SQL Server Reporting Services and SAP Crystal Reports
  • SQL Server 2000 - 2019 DBA
  • Colleague consultation, support, training and mentoring at all skill levels
  • Client consultation
  • Escalated issue support for databases and applications at client sites
  • Support of client heritage systems using Informix (through IDS10) and Oracle (through 9i)
  2009 to present (ongoing)
Apache SpamAssassin Developer and Project Management Committee Member
Apache Software Foundation
  • Development, maintenance and tuning of regular expression spam-detection rules and analysis service code framework for the open-source Apache SpamAssassin e-mail anti-spam utility
  • Co-administration of the Apache SpamAssassin project as one of thirteen Project Management Committee members
  • Apache Software Foundation committer
  December, 1999 to December, 2004 (5 years)
Internal Systems Administrator, Software Developer, DBA
Apropos Retail/CRS Retail
Lynnwood, WA
  • Administration of POSIX (GNU/Linux, SCO Open Server) and Windows (98, XP, 2000) desktop and server network supporting corporate office users and telecommuters and hosted e-commerce web sites
  • Corporate network Internet access and security design, tool development, and management
  • Support and training of corporate users and Development and Customer Support departments
  • Security, network, Internet and VPN consulting, design, implementation and support for clients
  • Informix (through IDS10) and SQL Server DBA and database architect
  • Escalated support for client database issues
  • Retail Business Intelligence and ETL design and development using SQL Server Analysis Services and SQL Server Integration Services
  • Retail application development in C# with Oracle 9i and SQL Server 2000
  • Retail application development in Informix 4GL with Informix procedure language
  • Utility application development in C
  • On-site installation, configuration and support of servers, network infrastructure, databases and custom application software for clients
  1996 to present (ongoing)
Independent Consultant
  • Design, development, testing and documentation of Linux kernel modifications to support masquerade (NAT) of PPTP and IPsec VPN traffic in the 2.0.x and 2.2.x kernel series
  • Design and development of e-mail and firewall security tools in the GNU/Linux and POSIX environments
  • DNS, website and secure e-mail management
  • Consulting on Linux system administration and security, networking administration, and VPN technologies
  June, 1987 to December, 1999 (12½ years)
Systems Manager, Developer, DBA
Sizzling Platter, Inc.
Salt Lake City, Utah
  • Co-administration of Windows NT (3.51, 4.0, Terminal Server) and Unix (GNU/Linux, SCO, SVR4) wide-area network of more than 50 locations serving more than 200 users across four states
  • Development, documentation and maintenance of, and user training and support for, accounting, payroll, cash management, communications, e-mail automation, corporate intranet, and restaurant management, analysis and support applications and databases
  • Design, development, documentation, installation and maintenance of, and user training and support for, restaurant management, full-service and cafeteria style Point-of-Sale, e-mail, intranet, communications and support applications, databases and systems in more than 40 restaurants in four different concepts across four states, connected by dial-up, WAN and Internet VPN
  • Internet access and security design, tool development, and management
  October, 1986 to May, 1988 (2 years)
Westminster College of Salt Lake City
Salt Lake City, Utah
  • Tutored lower- and upper-division Computer Science 20 hours a week while attending classes full-time and while working part-time after June, 1987
  May, 1984 to May, 1987 (3 years)
White Pine Cable Television
Ely, Nevada
  • Designed, implemented, maintained and expanded subscriber information management system and trained users
  • Provided part-time support while attending college
  May, 1983 to May, 1984 (1 year)
Lineman and Installer
White Pine Cable Television
Ely, Nevada
  • Construction and maintenance of exterior physical cable plant, including aerial work
  • Installation, adjustment, troubleshooting and maintenance of subscriber service from pole to television set, both residential and multi-unit commercial
  • Relational database design and performance tuning
  • SQL query and stored procedure design and performance tuning
  • C# application development
  • Typescript application development
  • C application development
  • Business report development using SQL Server Reporting Services and SAP Crystal Reports
  • Regular Expressions
  • Source code control using git (bitbucket), Team Foundation Server, Subversion, RCS
  • Agile/Scrum development processes
  • Issue management using Atlassian Jira and document management using Atlassian Confluence
  • Postman webservice testing
  • SQL Server 6.5 through 2019 (including SSRS, SSAS and SSIS) DBA
  • Linux system and network administration (Gentoo, Centos, Red Hat, Ubuntu, Immunix distributions)
  • Windows system and network administration, desktops (from 3.1 through Windows 10) and servers (from NT through Server 2019)
  • POSIX tools and applications including Perl, bash, awk, sed, C, sendmail, procmail, Samba, SpamAssassin
  • TCP/IP-based Local Area and Frame-Relay and VPN-based Wide Area networking, T1 management
  • PPTP and IPsec VPN design and management
  • Linux 2.0.x and 2.2.x kernel development (PPTP and IPsec masquerading)
  • Internet and Intranet management, including security (DMZ, firewall and proxy design and management) and standard Internet protocols and applications
  • Microsoft Office ('97 through 2010) applications support
  • Microsoft Access application design, development and support
  • Informix Dynamic Server 7.3, 9.x, 10.x DBA
  • Informix SQL and 4GL (through IDS10) application programming, maintenance and support
  • Oracle SQL and PL/SQL (through 9i) application programming, maintenance and support
  • PC desktop and rackmount server hardware assembly, maintenance and troubleshooting
  • User training and support at all skill levels
  • Technical documentation writing
  • Communications cabling design and installation including telephone, television, serial data, and coaxial and twisted-pair network, including exterior plant construction (aerial lineman)
  Bachelor of Science in Computer Science, Summa Cum Laude - Westminster College of Salt Lake City, Salt Lake City, Utah, May 1988.
  Member of Uniforum, 1988 to 1994
Member of the Association for Computing Machinery, 1985 to 1989
Licensed radio amateur, Technician class (KA7OHZ), 1982 to present