Glen Knickerbocker

Professional Experience

Jan 2018 – Present

Software Solutions Architect, Manager

Knickerbocker Software Inc., Clearwater, FL

• Oct 2019 – Present

  On contract with the State of Florida Dept of Health to update their public websites (central and 67 county sites) to a new modern design while troubleshooting existing issues and maintaining and enhancing custom code (HTML, CSS, JavaScript, jQuery, Responsive Web Design, Cascade CMS, Java, Node.js, JSON, XML, SQL Server)

• Feb 2019 – Sep 2019

  On contract with the State of Oregon Dept of Energy to migrate three applications to Microsoft Azure, perform specified fixes, enhancements, and maintenance for each of the three Web applications (JavaScript, jQuery, ASP.NET, ASP Classic, C#, VBScript, ADO.NET, OLEDB, IIS, Azure, Azure SQL, SQL Server), and update a desktop Java application to use SQL Server 2017.

Oct 2015 – Present

Senior Software Engineer and Lead

Sembit Corp., Beaverton, OR

• Feb 2019 – Present

  Updating auto parts e-commerce portal to integrate with new Oracle EBS SCM/ERP system (sunsetting legacy AS400 and DB2 iSeries)

• Feb 2018 – Present

  Maintaining and enhancing an e-commerce website selling tens of thousands of craft products with interfaces to all major marketplaces, suppliers, shippers, credit card clearing house (HTML, CSS, JavaScript, jQuery, ASP.NET, ASP.NET MVC, IoC, Castle Windsor, C#, VB6, Web Services, REST, XML, NHibernate, NUnit, SQL Server, Stored Procedures)

• Jan 2018 – Jan 2019

  Maintained and enhanced a wholesale auto parts e-commerce portal with distributed architecture, interfaces to ERP system, Authorize.net, shipping rates, tax rates (HTML, CSS, Bootstrap, JavaScript, jQuery, Knockout.js, ASP.NET MVC, C#, ADO.NET, MS Unit Test, SQL Server, DB2 iSeries)

• Dec 2018 – Jan 2019

  Developed and maintained a personal profile website in the cloud (HTML, CSS, JavaScript, AWS)

• Jul 2018 – Sep 2018

  Wrote a web app for developers to track time against customer projects (HTML, CSS, JavaScript, WCF)

• May 2018 – Jul 2018

  Built components of an intranet web app to manage tracking and recovery of health insurance overpayments (Angular2, NodeJS, WebAPI, .NET Core, IoC, Dependency Injection, C#, Entity Framework, SQL Server, Stored Procedures, Active Directory)

• Mar 2018 – May 2018

  Gathered requirements, analyzed, estimated, designed and prototyped an auto parts warranty claim entry and reporting module for an e-commerce web portal (Responsive Web Design, .NET, SQL Server, Oracle)

• Jan 2018 – Jun 2018

  Enhanced a major auto parts wholesale website with PCI DSS compliant credit card processing through Authorize.net clearing house (HTML, CSS, JavaScript, ASP.NET MVC, C#, MS Unit Test)

• Oct 2017 – Jan 2018

  Added a backorder feature to an e-commerce website (HTML, CSS, JavaScript, jQuery, ASP.NET, C#, VB6, XML, Entity Framework, SQL Server)

• Sep 2017 – Nov 2017

  Added support for gym membership/ fitness coverage in company health insurance program templates (HTML, JavaScript, ASP.NET MVC, Entity Framework, SQL Server, Stored Procedures, Active Directory)

• Jun 2017 – Nov 2017

  Gathered requirements, analyzed, designed, prototyped and constructed a bulk wholesale returns workflow and API for an OEM and aftermarket auto parts manufacturer out of Japan (HTML, CSS, Bootstrap, JavaScript, jQuery, ASP.NET MVC, C#, ADO.NET, SQL Server, DB2 iSeries, Stored Procedures)

• Apr 2017 – Jul 2017

  Gathered requirements, analyzed, designed, prototyped and constructed a healthcare provider information spreadsheet import tool supporting dynamic configuration of a variety of provider group export formats (HTML, CSS, JavaScript, Angular.js, .NET WebAPI, C#, ADO.NET, SQL Server, Stored Procedures, Active Directory)

• Oct 2016 – Apr 2018

  Performed ETL activities and developed elements of a consolidated provider database with complex business rules and multiple local and remote data sources, address standardization, troubleshooting, created standard reports for federal government CMS - Centers for Medicare and Medicaid Services (HTML, CSS, JavaScript, Angular.js, .NET WebAPI, C#, ADO.NET, SQL Server, Stored Procedures, JIRA)

• Oct 2016 – Oct 2016

  Authored and presented technical training topics to other developers (FaaS - Amazon AWS Lambda, Google Cloud Functions, Microsoft Azure Functions)

• Sep 2016 – Dec 2016

  Created promotional HTML emails and web pages from designer-provided photoshop mockups (Photoshop, HTML, CSS, JavaScript, JIRA)

• Aug 2016 – Nov 2016

  Updated an internal health insurance plan template configuration web application with plan data for upcoming new year (HTML, CSS, JavaScript, ASP.NET MVC, C#, Entity Framework, SQL Server)

• Mar 2016 – May 2017

  Built from scratch an e-commerce web portal for a multi-billion dollar international auto parts supplier, released it into production on schedule, documented, trained their in-house development team, performed interim maintenance (HTML, CSS, JavaScript, jQuery, Knockout.js, ASP.NET MVC, C#, ADO.NET, MS Unit Test, SQL Server, Stored Procedures)

• Dec 2015 – Mar 2016

  Enhanced a Windows tool used by a major health insurance provider to generate annual health plan configurations (C#, WPF)

• Oct 2015 – Feb 2016

  Built an intranet Web application to track accumulation of group and member plan limits for a major health insurance provider (ASP.NET MVC, Razor, C#, SQL Server, JIRA)

Jan 2012 – Sept 2015

Software Solutions Architect, Manager

Software Decoded Inc., Sheridan, OR

• Continued to consult as solution architect and senior systems analyst for Oregon DHS: designed and implemented system enhancements including developmental disability client assessment tools and reports, new financial authorization and payment model, support for individual service provider types, etc. (Architecture, JavaScript, CSS, HTML, UML, Java, Java Enterprise, SQL, DB2, Jenkins)
• Created a partner portal for an agricultural/grower’s co-op (CMS, HTML, CSS, JavaScript, jQuery, Responsive Web Design, AJAX, XML, C#, SQL Server)
• Designed and built a cloud SaaS application for managing private insurance pools (C#, ASP.NET, Azure)
• Rewrote interface for Nike customer IVR to use new e-commerce system (Java, JSP, REST)
• Developed a parts catalog writing tool for an airplane manual publishing company (C#, SQL)
• Wrote custom calculation logic for healthcare insurance claim pricing (Java, SQL Server, Facets)
• Built a custom electronic document management system for a major health insurance company; wrote Web document viewer with zoom, pan, rotate, print and notation features; migrated 50 million documents (8 Terabytes) from legacy system (JavaScript, jQuery, HTML, CSS, WCF, C#, SQL Server)

Apr 2010 – Jan 2012

Software Architect/Consultant

Oregon Department of Human Services, Salem, OR

• Dual role as solution architect and senior systems analyst (including hands-on Java programming)
• Gathered requirements for new features and web service interfaces (WebSphere, IBM MQ)
• Designed and implemented major system enhancements (Java, JSP, WebSphere DB2)
• Designed and implemented web service interfaces (Java, Web Services)
• Updated and managed continuous integration build process (Ant, Cruise Control)
• Updated hundreds of thousands of lines of Java source code from Java 1.4 to Java 6
• Trained State technical team members in OO design patterns and Java 6 language features
• Created new baseline database scripts for continuous integration build (DB2, SQL)

Jul 2009 – Apr 2011

Director of Information Technology

Transaction Tax Resources, Inc., McMinnville, OR

• Built subscription web application for tax answers (SugarCRM, LAMP Stack, PHP, jQuery, MySQL)
• Processed, analyzed hundreds of millions of rows of customer invoice data (MySQL , SQL Server)
• Hired team of IT personnel, some offshore, to manage company networks and develop new products

Jan 2002 – Jun 2009

Systems Architect and Team Lead

Oregon Department of Human Services, Salem, OR

• Jul 2008 – Jun 2009

  Solution architect and technical team lead for Statewide Automated Child Welfare Information System (SACWIS) replacement (HTML, CSS, JavaScript, Java, JBoss, JMS, SQL Server)

• Mar 2007 – Jun 2008

  Solution architect for Integrated Client Services (ICS) BI project, merged client service data from over a dozen disparate systems (DB2, SQL OLAP, ETL, de-dup)

• Jun 2006 – Feb 2007

  Systems architect for feasibility study of county systems integration

• May 2004 – May 2006

  Solution architect and technical team lead for Express Payment and Reporting System (eXPRS) - built from scratch a service authorization and claim payment Web app to manage budget and file claims online, and produce financial reports for management (JavaScript, HTML, CSS, Struts, Java, Cruise Control, Web Services)

• Jul 2003 – Apr 2004

  Solution architect for Medicare and Medicaid Information System (MMIS) replacement project, until decision was made to outsource maintenance (Reporting, UML)

• Jan 2002 – Jun 2003

  Senior system analyst on Family And Children Information System (FACIS), the prior SACWIS solution (Smalltalk, Delphi, Object Pascal, Sybase, client-server)

Oct 1996 – Dec 2001

Senior Programmer/Analyst

Heroic Path, Inc., McMinnville, OR

• Designed and developed a consumer privacy and permission management middleware solution (Java, JBoss, JMS(Java Message Service), Oracle, Solaris) and enhanced a custom SAP plugin for Intel (Smalltalk)
• Developed object-oriented components of Oregon child welfare information system, created installation program and managed deployment (Smalltalk, SQL, Delphi, Object Pascal, COM)
• Used structured analysis and design to create detailed UML models and diagrams
• Chose processes and standards for analysis, design, testing, test cycles, and source code control

Education

• Two years of College - 3.5 GPA in Mathematics

  University of Washington, Seattle, Washington

• High School Diploma

  Anthony J. Dimond High School, Anchorage, Alaska

Certifications

• Sun Certified Programmer for the Java 2 Platform

  Sun Microsystems, Beaverton, Oregon

• The Open Group Architecture Framework (TOGAF)

  The Open Group, Salem, Oregon

• IBM WebSphere Application Developer

  DevelopIntelligence, Denver, Colorado

Skills

• Communication, building relations and confidence, public speaking, documentation, statistics, architecture, patterns, frameworks, offshore
• Application:Azure, AWS, Desktop, Web, SPA, Responsive, AI, Middleware, OLTP, OLAP, Data Warehouse, Business Intelligence
• Language: C#, Java, JavaScript, SQL, XML, XML Schema, UML, HTML, CSS, Smalltalk, PHP, VBA, VB6, Object Pascal
• Database System:Azure SQL, SQL Server (every version from 2000 to 2017), DB2, Oracle, MySQL, MS Access, MongoDB, Sybase, Flat Files
• Web UI: ASP.NET, MVC, Razor, WebAPI, Bootstrap, Struts, JSF, Play, JSP, ASP
• JavaScript Library: jQuery, Angular2+, Angular.js, Bootstrap, Knockout.js, moment
• Communication: Web Services, HTTP, REST, JSON, AJAX, WSDL, XSD, DTD, COM, TCP
• Source Code Control: Git, Mercurial, Subversion (SVN), CVS, TFS, VSS, PVCS
• IDE: Visual Studio 2017/15/12/10/08/05/03, Eclipse Java/PHP, SSMS, MySQL Workbench, SSIS/SSDT, WSAD/RAD, Together, Delphi
• Server Software: WebSphere, .NET, IIS, SharePoint, JBoss, Tomcat, Apache Web Server
• Methodology: Agile, Scrum, Lean, XP, TDD, RUP, Waterfall
• Testing, CI: JUnit, NUnit, HttpUnit, MS Unit Test, Selenium, Jenkins, Cruise Control, User Acceptance
• Web Browser: Chrome, Firefox, Edge, Internet Explorer, Safari
• Operating System: Windows, Linux, AIX, Solaris