2016: Infrastructure as a Service (IAAS) and Application Architecture:

Client requested upgrade of a legacy system for an organization that engages potential voters in U.S. elections across dozens of campaigns. Migrated to a full virtualized IAAS microservices architecture with virtual firewalls, virtual LANs, and virtual DEV/TEST/PROD servers. Negotiated contract for service, did load testing to predict needed allocation of resources, and led team for a successful roll-out, and hosted solution.

Originally setup in MySQL and moved to MariaDB

Client had an emergency situation regarding a custom Windows .NET application that was an online store, a CRM system, an enterprise shipping/printing management system, and an employee management system.

Was able to immediately identify key security issues and attack vectors to stop ongoing attacks.

Assisted legal teams/law enforcement with chain of evidence and reports. Worked with legacy system code/server and client’s IT team to identify further weaknesses in system.

Led teams in multi-year process to modularize and replace legacy infrastructure without impacting business continuity. Upgrades included:

Web-based billing/accounting system and patient management software for associated network of doctors across Iowa.

Allowed doctors move to a paperless medical record system. Managed allowed procedures for doctor/patient interactions and automatically created PDFs in format required by insurance agencies and state regulators. Final implementation nearly completely automated billing/reports to state regulators and insurance agencies, saving client hundreds of person-hours per month.

An Enterprise Medical Facility had a new EPIC system to rollout. Both new and old systems used  Intersystems Database based on Cache (Mumps, M).

A client in a secured government facility used a custom Paradox application to manage employees, track hours, parts, labor, and generate invoices. The hardware on which the program existed was failing and other contractors had been unable to migrate it to a new system.

The client was required to change the program logic for how it calculated invoices, however the company which developed the application no longer had the developer on staff, no longer had the source code for the "delivered" (binary only) sections, and did not have the administrative password.

An Iowa Government department had an existing Microsoft Access project which needed to share data at multiple remote offices with some sites having an intermitent and/or slow dedicated connection.

2004

2001-2006: Lead Application Architect, DBA for system integrating multiple universities' and colleges’ admissions databases into a centralized "Sports Recruiting Management System." Led a team which built the web service used by NCAA schools across the country so that coaches and recruiters could adhere to strict NCAA recruiting and reporting requirements.

2002: Hired by a Fortune 100 client looking to purchase a company and product that offered commercial, enterprise-level , web-based system for project development/management. The company asked me to do a non-destructive security analysis on a production system.

Organization using Peoplesoft on Oracle wanted to have an online application which tracked employee assets in a complex way that Peoplesoft did not offer. Existing corporate web server did not offer native OCI calls, just slower generic ODBC modules.