Micah Howard | Web & Automation

Portfolio

Here’s a collection of projects showing my work in web development, data automation, and programming. Click on the featured or personal/school projects for more details.

Featured Projects


Personal/School Projects

Google Sheet Automation

Tech: Make, Google Sheets, PayPal Webhook

Automatically logs payments and PayPal fees from invoices into a Google Sheet, helping keep track of income and transaction details without manual entry.

Click to enlarge the images below.

Make scenario webhook setup sending data to Google Sheets
Google Sheets table populated via Make automation scenario

Email Automation

Tech: Python, Spotify API

Pulls the last 50 songs a user listened to in a week and sends a personalized email recap, summarizing listening habits and stats.

Click to enlarge the images below.

Spotify weekly email showing number of songs listened, total time, average song length and popularity
Spotify weekly email highlighting top artist and top song
Python code used to pull last 50 songs from Spotify and generate email digest

Full-Stack Team Project

Tech: React, Tailwind CSS, Node.js, MySQL, RAWG API, Aiven

A full-stack web application where users create an account, log their favorite games, and receive personalized game recommendations. Users can track games by status (currently playing, completed, or want to play), while the system pulls and analyzes game data from the RAWG API to generate recommendations.

My contributions:

  • Designed and built the entire relational database schema
  • Implemented MySQL database hosted on Aiven
  • Collaborated with frontend and backend team members

Click to enlarge the images below.

User profile page showing recent games
Homepage of game recommendations website with games pulled from RAWG API
Page showing curated games recommendations for user
SQL code for creating user games database tables

Custom C++ String Library

Tech: C++

Built an extended string class supporting custom constructors, type conversions, substring search, trimming, case conversion, replacement, insertion, operator overloading, and full test coverage for all behaviors.

Click to enlarge the images below.

C++ program output for customer string class
C++ code initializing custom super string class

XML Viewer + Editor

Tech: Java

Built a console application that reads customer data from an XML file, displays each customer’s information in a clean, readable format, and allows users to add missing details such as phone numbers, contact names, and email addresses.

Click to enlarge the images below.

Java console output showing modified customer information
Java console output displaying customer data
Java code snippet handling user input

Rental Transaction Builder

Tech: Java, SQL Server

Built a console‑based rental system that connects to a SQL Server database to display pickup locations, collects customer details with full input validation, calculates rental costs based on vehicle type and duration, and prints a formatted transaction summary.

Click to enlarge the images below.

Java console output showing vehicle rental system transaction details
Java code implementing vehicle rental system backend logic

Database Design

Tech: SQL Server

Designed and built an entire clinical‑trial database from scratch for patient screening, randomization, drug‑kit assignment, and withdrawal tracking. Developed a companion SQL script that drives the full workflow, generating realistic multi‑study patient activity.

Click to enlarge the images below.

SQL script creating tables in database
SQL script creating procedure and beginning transaction
SQL stored procedure execution script