MySQL

Tommy + the technology of MySQL

Home Capabilities Technologies MySQL

MySQL Examples

Below are some of my projects involving MySQL, grouped by company. Click to read more about the relevant projects and chat with me to follow up on any topic you'd like to hear more about!
Explorys logo

Explorys

IBM Watson Health

Lead Engineer

2012 - 2014

Project: New Admin Dashboard

New Admin Dashboard - Architected and implemented green field admin dashboard, worked with junior devs and leadership to bring about in the requested stack: Bootstrap / JQuery / Ruby / Java / MySQL / LDAP. Users used Admin Dashboard to administer Organization, Role, and other management aspects of the Explorys EPM Suite.

Dependency Injection Framework - To enable high testability, all components required dependencies to be passed in, and so eliminating factory boilerplate without adopting a complex DI system was desirable. Wrote and shared a simple runtime-reflection based DI framework with multiple projects / teams

Read more...

Key Results

  • Delivered new admin dashboard supporting 10+ healthcare organizations
  • Reduced user management operations time by 65% with streamlined UI
  • Created DI framework that enabled loose coupling needed for fast pivots

Full Details

Progressive Insurance logo

Progressive Insurance

Auto Insurer
Project: Quoting (F3)

Progressive had two sites for Direct Auto Quoting - one used by customers at home and the other used by our call-center reps. Given the complex state-by-state variance in the insurance laws, this made for a huge maintenance cost, and doing it twice in two codebases didn't make sense.

The premise was that a single web 2.0 Direct Quoting Application could replace these while also yielding a much more modern and customer-delighting application.

As the team's Actionscript expert, I joined and quickly helped out delivering feature after feature, and I loved the XP discipline and grew to appreciate TDD especially after the site started hitting performance problems that warranted significant refactors, which would have been much riskier without test coverage!

Our pilot included 14 of the 50 states, and was a complete success. However, the amount of clientside rules and assets started slowing the app down, and this was when I was asked to replace the REF framework that preceded my joining, with something much faster and more developer friendly. This led to my promotion to lead engineer, where I begun work on REF 2.0 (UI Framework)

Read more...

Key Results

  • Successfully launched modern web app replacing 2 legacy systems in 14 states
  • Achieved 99.5% uptime during pilot rollout serving 10,000+ daily quotes

Full Details

Cleveland Entertainers logo

Cleveland Entertainers

Point. Click. Party.

Managing Partner

2004 - 2007

Project: Clevelandentertainers.com Website

We went through several iterations of the website, but our goals were SEO optimization and systematizing the internal booking process with salesforce while exposing certain information about entertainers, acts and availability through the website, and keeping those in sync with entertainer calendars.

With the help of some interns, I designed and built the website from the ground up, and hosted it at Cleveweb.com, the software solutions company I had formed a few years earlier.

Read more...

Key Results

  • Generated 500+ entertainment bookings annually through optimized SEO
  • Integrated Salesforce CRM automating 70% of booking workflow processes
  • Grew organic search traffic by 400% making site #1 result for Cleveland entertainment

Full Details

Cleveweb.com logo

Cleveweb.com

Web Design, Development, Hosting

Owner

2000 - 2008

Project: Mont Granite, Inc

montgranite.com - supplier of natural stone website. After assessing their products, we categorized them according to stone type, colors, texture and brand, then I created a MySQL database and an ORM to read/write PHP objects and their relationships from the database and present it as a front-end, which I designed to resemble a piece of marble.

I then hosted the company's website and email for a number of years afterward and actively updated the site on retainer.

Read more...
Project: M% (M Percent) site

I built a plain web and interactive flash based website for mpercent.com, an art gallery, backed by a php web server and mysql database, containing various works of art, artists and events that were being presented and searchable to end users

Read more...
Project: Northcoast Tech site

Working with executives, I designed, built, hosted, continuously updated, and reported traffic analysis reports for Northcoast Technologies. I designed and built an animated advertisement explaining their product.

Read more...
Project: ricksmithjr.com

Rick Smith Jr. was one of my best customers, we did 3 different versions of the website over an 8 year span. They included advanced animations and rich video experiences as well as booking forms and SEO optimizations.

Read more...
Project: The Taylor Companies

Thetaylorcompanies.com had a searchable cataolgue of many pieces of furniture, each with multiple image angles, specs, descriptions, brands, pricing, and delivery schedules. After understanding their needs, I put together a MySQL database, PHP web server with a custom ORM, and an rich frontend with an animated intro page.

Read more...

Key Results

  • Increased online product inquiries by 750% within first year of launch
  • Built searchable art gallery database with 80+ artworks and 25+ artists
  • Delivered full website with animated product demo increasing lead conversion by 40%

Full Details

Tommy Sullivan - AI + Full Stack Software Builder + Leader