Solution Portfolio

Tableau Public

Visualizing My Curiosity

I participate on Tableau Public, where I share visualizations I’ve made to satisfy my own curiosity. I’m mostly interested in speculation with respect to the overall direction of the American stock market, but there is no part of my life that I won’t data mine.

FINRA margin debt balances versus the S&P 500 index.

A chart showing the relationship between U.S. unemployment, the spread between the 10 year and 2 year treasury bonds, and the S&P 500 index.

USDA Report Parser

Market Data, Analysis Ready On Release

A snippet of an E-mail notification I created that shows the USDA afternoon beef cutout for a particular day with graphs
  • Private project developed for a prop trading firm
  • Collects data from USDA reports which are human-friendly, human-typed text reports that are challenging to parse
  • Automated execution ensures user’s database is always up to date
  • Immediate e-mail notifications summarize new report contents with charts and statistics

Charity Job Hub

Multiple Sites, Unified Filtering

A list of jobs from charity job hub, showing two pinned jobs.
  • Collects job postings from the largest charity and non-profit job posting sites and harmonizes the job postings into a single database of listings
  • Provides a filtering interface to users to select postings based on the relevance to their careers
  • Supports both positive (“must have one of …”) and negative (“must not have any of …”) filters on all important columns, unlike any job posting site
  • Help users keep track of relevant postings with a calendar of application deadlines and in-interface marking of “applied” and “interesting” jobs
  • Updates daily and deletes expired postings (which many sites leave up for months)
A graph of new jobs over time from the chairty job hub admin interface

Home Depot Prices

Alternative Data for Earnings Speculation

A capture of my home depot revenue estimator, which sends a daily email that estimates quarterly earnings based on changes in reported inventory
  • Private project collecting prices for 99941 Home Depot products Canada-wide
  • Capable of identifying best regional and nation-wide prices
  • Tracks changing prices of all items over time to identify patterns
  • Tracks inventory numbers of all products for all stores nation-wide
  • Ultimate purpose was to provide alternative data for equity research

Book Market Spider

Determine Market Price

Screenshot of the output of a report generated from the book market spider
  • Private project collecting prices for books across multiple online book markets
  • Keeps track of offerings, quantities, and prices
  • Used to determine estimates of books sold at what prices
  • Ultimately determines what the market is willing to pay for a particular book through time

Landlord Finder

Lead Generation for Property Management

Screenshot of the output of a report generated from the landlord finder
  • Private project collecting rental postings across several websites
  • Identifies landlords and property management companies common to several properties
  • Can also be used to identify trends in rental pricing
  • Useful for market research for property management companies to identify potential leads