OS

Enterprise Architecture for Fortune 5 Company: Web-application for customers

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.

Web-based Traffic Management System absorbing real-time data from roadside devices

Worked with embedded device team to create a vertically integrated system from field to server system to end user.

Investigated technologies and built from scratch web-system used to manage of deployment, monitoring, reporting, calculations, and real-time display of data from sensors deployed along roads. Built basic system from scratch with custom modules. Then hired and lead team to create an entire Traffic Management System with real-time map speed data, graphs, etc.

Assisted with securing patent with attorneys and listed as inventor.

Worked with numerous DOTs and system integrators to adhere to ITIS standards for complex data integration systems.

MySQL Binary Logging Plus user tracking tools.

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.

Windows / Linux Integration

Since 1995 I have been integrating Windows and Linux/Unix servers to take advantages of the strengths of each to provide services that together are more robust, secure and tailored to client needs than either would be by themselves.

Web Server System Administrator since 1993

Evaluated, built and installed many multi-homing, heavily accessed web server systems. In some cases systems spanned both Windows servers and Linux servers. Many systems setup supported SSL, e-mail-to-fax gateways, PGP, streaming video, on-the-fly gzip decompression, on the fly PDF creation, PHP, SQL database, standard and fast CGI and CGI.pm. Started in 1993 with the NCSA web server and have installed and managed many different servers over the years including EMWACS, IIS, Apache, Oreiley's Web Server.

Peoplesoft Oracle/MySQL/PHP Integrated Application

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.

HIPAA Security Upgrades

Contracted by private regional hospital for assisting with security issues fpr network of several hundred windows 2000 client computers. Network ran with a central PDC running RedHat linux and Samba. Client was required to implement additional security as part of HIPAA (Health Insurance Portability and Accountability Act of 1996).

WAN Analysis for Ten Distributed Offices

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.

4-ISP Linux firewall

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.

Six-hospital Research Project 3-tier web application.

Five+ year multi-hospital orthopaedic study for meaningful statistics on tibial-plafond fractures. Program integrated, in real-time, patient records from 6 Hospitals (Univ. of Iowa, Univ. of New Mexico, Univ. of Virginia, Wake Medical Center, Univ. of Tennessee - Knoxville, OHSU). Converted all relevant medical forms (SF36, MFA, SMFA, Pain Scale, Xray data, etc.) to HTML or PDF and scripted detailed, real-time project management reports to color-code by hospital, by forms completion, and by follow up visits/forms done at proper times.

Person to Person Marketing and Campaign Management Software

2004 Project Manager and Development Team Lead for a person-to-person campaign management strategy with functionality beyond current commercial and open-source solutions. Granted funding only two weeks before deadline to start campaign yet kept an intense development schedule to create a complete system from scratch capable of supporting hundreds of concurrent users for multiple political campaigns with their campaign managers, all accessing over 2.5 million voter-records.

Microsoft SQL Server Replication

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.

Cache and Intersystems

At Enterprise Medical Facility hired to work with Cache (Mumps, M) on Medical database system to add complex reporting to legacy system. Setup Novell Linux (SLES) system with Drupal and CSP (Cache system pages) with authentication via LDAPS to give easy management of users and grant access to data and reports.

Later also added Oracle API to access Peoplesoft DB to access real-time employment records as part of Web-based system. Worked with Oracle team to setup views for system to maintain good security.

Syndicate content