interested in designing and building data-driven projects

timothyclifford2@gmail.com

Live etl project

I designed and built an application that tracks and monitors the price of “Magic: The Gathering” cards. It presents the data in stock-like graphs, and uses stats to track price trends. 

Features:

– SQL database (click here to see how I clean data in a jupyter notebook)

– Bootstrap front-end on flask microplatform

– Numerous web scrapers 

– interactive graphical charts

– watchlist functionality for price tracking

– Ubuntu server using nginx, gunicorn, and flask

YEAST CELL COUNTING

I built an application with OpenCV to count the living and dead cells from a yeast culture using Otsu watershed segmentation and color filtering for use with methylene blue dilutions.

The image to the left shows red dots on detected blue(dead) cells, the results are reasonably accurate. A handful of false positives, a handful of false negatives, but overall better than doing it by hand when a cell count is 2000+.

This was designed to be used with a typical 1:100 dilution and hemocytometer image which people use to count cells by hand.

Bent's fort VR app

I designed and built a VR application for IOS and Android using Unity and Google Cardboard SDK that lets you step into a historic 19th century Colorado trading post.

The app was created in conjunction with Boston College’s Immersive Education program and The US Department of Interior/National Park Service to be used as a prototype.

Features:

– created with unity ( uses c# for scripting)

– crossplatform mobile application

– head tracking VR, single button navigation

– bluebrint accurate 3D model of historic site

Skills

Programming

Python
SQL (Mysqlite3, Postgresql etc)
Flask/Jinja
HTML/CSS
Bootstrap
WordPress
Docker
Unity (uses C#)
Javascript
OpenCV
Tensorflow

3D

Fusion 360
Blender
3D printing slicers (simplify3d)

Technologies

Git
Slack
REST apis
Linux server (ssh/ftp/cron/VPN etc)
Microsoft office suite (Word, Excel, Powerpoint etc)
Adobe (Photoshop, Lightroom)
Fusion 360, Blender, Simplify3D
Tableau

Image Editing

Photoshop
Illustrator
Lightroom
OpenCV