Projects
Some old, some new.
Check back regularly for updates.
Open Data Reporting
Python / SQL Server / Tableau
2025
This project automates the download of public data to a repository for reporting purposes. Some basic reports are auto-generated as part of the ETL.
Report Aggregator
Oracle Eloqua Insight
Reporting in Tableau
Eloqua / PHP / MySQL / Tableau
2017
Daily email reports were getting difficult to manage. We automatically saved and catalogued email reports in the database for reporting.
Each snapshot is aggregated into a continuous timeline of data. With overlapping timeframes, there is redundancy in the dataset to account for occasional email report failures.
ASP / VB Script / MS Access
2003
Hi-Image Job Activity
HI-JACk started out as a fun project with free time that I had at work, and eventually came to be a core tool for the company. V1 built in 2002, the interface layout was influenced by Outlook Express.
An intranet designed for the Graphic Design, Printing and Bulk Mailing industry. The application tracks the full lifecycle of jobs as they progress from the design phase, through printing and eventually mailing allowing for data capture from all departments along the way.
The intranet is accessed via browser. It is written in Classic ASP (VB Script) and HTML and uses an MS Access database. The app runs on any simple web server capable of handling those resources.