Demo:
Designed and lead team to build demo for one of the world's largest companies integrating voice, traffic, phone and mobile web-based application. Assisted with sales for final demo which used real-time, in-car, voice-activated traffic information. Was lead on demo project and responsible for programming the voice activated system leveraging VXML tools.

Full system:
Demo went so well that the company selected the demo for a full system. Lead on project interacting with client's web software teams, DB teams, security teams, testing groups, business groups, in-vehicle software teams, marketing groups, voice contractors, design teams, and operations teams. Multiple APIs required and developed to work between various groups at client. For the company creating the system, it required implementing an API service that sat between legacy Java system and new web-application environment.

Performed load testing to support 250,000 concurrent users and architected to scale to support multi-millions of users. Base system setup with load balancing infrastructure.

In addition to being lead on the project, stepped in to build SAML2 system via Shibboleth, did load testing, setup DB encryption capable for encrypting on primary key without significant performance degradation, base system, and hardening of network & system. Extensive encryption vs performance metrics tested and ultimately implemented AES hardware acceleration. Hired additional staff to complete project on time with all deliverables.

A client with a mission-critical application needed to track every update and change to a MySQL database system. I implemented a binary logging system which records every update/insert/delete to the database as well as tools to replicate user input. System proved invaluable both in Q/A and in production by being able to track users database actions. End result was that the time to resolve database-related user trouble tickets was reduced from days to minutes since 100% of a user's actions could be replicated.

Client had 7 offices each connected via a T1. Each office had a Windows 2003 server with nightly backups via tape. Each system had roughly 100 Gigabyes of data to backup. Existing issues were that complete automation was impossible because individual office managers had to replace tapes, recovery was slow and required searching individual  tapes for the correct data, and the high cost of gigabyte tapes. The client was looking for an automated solution that would allow for remote access, off-site storage, easy rollback to any day's work, and a system that could be used by anyone easily.

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 web server did not offer native OCI calls, just slower generic ODBC modules.

Built a new web server from scratch with oci modules for PHP under Linux (SLES 10), migrated existing Novel/Windows server system to Linux, and re-engineered views and PHP code for real-time data. Got buy-in from HR, Peoplesoft db administrator and completed project with all departments extremely satisfied.

Analysis of web server, network and firewall security for client with 10 offices across the Midwest. Issues investigated included: connectivity across multiple T1 lines, migration from Novel to a Windows 2000 cluster, general IP security, database issues and IT security.

Implemented MRTG, DMZ, new routing tables, secondary firewall with an IDS (snort), dual Internet connections with bandwidth sharing. Client passed two third-party security audits and had no issues relevant to work done.

Called in to take over networking issues that prior consultants were unable to solve.

After purchasing two competitors, the client was required to maintain connections to the internet and required by vendors have direct WAN connections to 3 third-party vendor networks.

A car dealer had an ADP DMS access via "Reflections" and remote access only via modem. I was approached by a company with the problem that nightly updates were being done by hand to pull from the ADP system in order to upload them to a web server. This was a complex problem requiring scripts in Windows, ADP “English statement” scripts, Reflections Visual Basic Macros, and finally a bash/PHP script to move the downloaded data into a MySQL database. Met with client and setup a completely automated system.

Consultant for a hospital network that spanned 4 states, 20 hospitals and numerous outpatient facilities and clinics.

Web-based Orthopaedic patient/schedule management system. Allowed doctor to track patient statistics, CMEs, meetings,
and allowed staff to provide doctor with documents needed on trips anywhere in the world.

Created bid, deliverables, and timeline for third party as sub-contractor. Lead
DBA, hired additional programming staff for project, trained them in
PHP-database programming, and managed project from inception to completion.

Project so successful for first physician that many other physicians in office setup the same
thing.

Originally written in mSQL but migrated to MySQL.

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

Web-based billing/accounting system and patient management software for associated network of doctors across Iowa. Allows doctors to record records in a paperless fashion and manages allowed procedures for patients. Software automatically creates PDFs in format required by the State so accounting staff does not have to re-enter or re-type details. Managed upgrades from PHP3 to PHP4, from mSQL to MySQL4, and numerous Linux OS upgrades