MySQL

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 Replication

A few interesting MySQL replication scenarios:

Encrypted WAN Replication:
A company with mission-critical database services wanted real-time WAN backup of MySQL database. I setup remote, ssh-encrypted MySQL replications across WAN for real-time backup of SQL database. System supports “catch-up” replication in case network is slow or down. Allows client to recover to any moment in time if main server goes down.

Split Replication with Blackhole tables:
A company had setup a DB with thousands of tables in it and a gigantic legacy system that needed to be overhauled. The company needed to replicate part of the DB to other systems, BUT some of the queries on the master referenced tables that were not needed on the slaves. Setup replication of a few tables using suitable my.cnf configuration settings and blackhole tables to avoid errors that would have stopped replication.

MySQL 5.0 to 5.X replication with Binary Log Cron-clearing
A company with a legacy system was in the process of migrating and needed replication between the old and new systems. So much data was written per unit time that unpurged binary logs threatened to fill the disk systems. Setup cron bash scripts to check to see where the 5.1 systems were at in replication and cleared out 5.0 system logs periodically.

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.

EDI between 4 commercial systems for one Real Estate Office

A local real estate agency purchased a Perl-based commercial real-estate listing management package and purchased a commercial realty office management software that used Microsoft Access with a Visual Basic back end. Agency wanted to integrate those two products and expand on functionality of online version. Met with principles of agency, and setup deliverables, timeline and budget. Lead DBA and programmer for project able to exceed client expectations and setup a new data-driven website that agency claimed was responsible for becoming the dominant agency in the region.

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.

Integrating Admissions Databases and Web Databases

2006 Lead DBA and consulting expert for program integrating multiple universities' and colleges’ admissions database with online web-management for coaches managing recruiting. Each college has a different database structure and/or legacy system. Responsible for creating scripts to automate synchronization between admissions databases and web databases. Responsible for creating workflow, documenting, and training to ensure each college’s IT staff can implement smooth EDI processes.

ADP to Web

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.

Multi-Realtor Office MLS to Web Application System

Support for multiple realty agencies using the Paragon MLS system. Individual Reator agencies wanted to pull data from the MLS system and display them on web sites. System needed to be able to connect daily to the MLS system, download relevant images and listing data and then import into MySQL database for real-time display with search capabilities. MLS system originally used XML data as defined by IDX rules, but later changed. As the MLS system changed export criteria, updates of scripts and data import methodologies were changed as well.

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.

Doctor Office Management Software

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.

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.

Web-Based Medical Billing Software for Statewide Network of Health Care Providers

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

Condo Management and Accounting Software

Web-based, vertically-integrated billing, accounting, and facility management system for condominium association management group.

Created bid, deliverables, and timeline for third party as sub-contracting-company. Lead DBA, lead programmer, and worked closely with client to meet complex goals set by design, accounting, and management teams.

Trained client's designer on web-based HTML design criteria. Researched accrual-based accounting and accounting methodology/terminology to implement a robust system exceeding client's goals.

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