SailFuture Live Expedition Tracker

In March of 2024, I joined the TypeWorks team and began working on SailFuture's new Live Expedition Tracker with my good friend Justin Linn.

This application provides live tracking data from SailFuture ships and allows users to keep up with current and past sailing expeditions. Admins can add expeditions, posts, and more through a Sanity CMS integration. Meanwhile, users can view a ship's current position, as well as click points on the map to read posts about what the crew did at that location.

The Custom Gun

In my spare time, I have begun this large side project using many new (to me) technologies. Through my time working as a web developer in the firearms industry, I have noticed a gap that is not yet catered to. With this project, I hope to fill that gap, as well as gain a deeper understanding of the technologies I am building with.

WooCommerce & GunBroker Automation

While working as a web developer for Seattle Engraving Center, I took initiative to find a solution to the countless hours spent posting merchandise on GunBroker.com and our WooCommerce Store. After some research, I found that GunBroker.com, WooCommerce, and many of the suppliers we dropship merchandise from offer APIs.

Using Node.js, I created 2 programs (one for WooCommerce and one for GunBroker) that automate the action of posting items on our GunBroker and WooCommerce stores. The programs start by gathering each vendor's available inventory, either through their API or by downloading a CSV inventory file from their FTP server. Next, the program converts this data into JSON format and iterates through every product, removing unnecessary data, adding required fields, and properly formatting any fields that need it. Finally, the programs iterate through the formatted inventory, generating custom product images and posting the item with all necessary information to either GunBroker or our WooCommerce based store. The programs can also check every item currently listed on GunBroker.com or our WooCommerce store and determine whether that item is still available from any of our suppliers, automatically deleting or suggesting the deletion of any product that is no longer available.

These two programs showed results. Our number of GunBroker listings shot from around 1,300 to over 3,500 over the course of a week. One listing typically took around 20 minutes to post, but the programs were able to post ~1000 listings in that same time. We quickly became a top 100 seller on GunBroker, and no longer had to dedicate an employee to listing products all day.

Pear Programming

I created Pear Programming as a place for entry level developers like me to share project ideas and work together to build their portfolios and teamwork skills. I built the client using React and the server using Node.js, with MongoDB as the database. The client is hosted with Netlify and the server is hosted with Render. I also used Cloudinary to host the image uploads such as profile pictures and post images.

Passwords are hashed (server-side) and API routes are protected based on whether a user is logged in or not. I also utilized OAuth 2.0 to allow a user to register or log in using their Google account.

YouTube Word Search

I created YouTube Word Search for when I'm watching a YouTube video and think "When are they going to finally talk about [blank]?". You can enter the URL of any YouTube video with captions and see a list of words said in that video ranked by number of times used. Click on any word to see a breakdown of the phrases it was used in, as well as a link to the exact point in the video where each phrase was spoken.

This Website

I created this website in my spare time as an extension to my resume. Many of my old web development projects have been lost to the chaotic file management of my teenage self, so this website was a great way to wrap up some of what I learned back then into one project. I decided to forgo the use of a CMS like Wordpress for this site in order to not only have more precise control over the layout and functionality, but also to display my ability to build a responsive website from scratch.

Capstone Project

This website was developed by my capstone teammates and I. We built a platform for pharmacist Bob Gold to share his reviews of popular drug ads, and the problems with them. It allows for him, along with anyone else given admin credentials, to log in and add, edit, or delete reviews. The website is built using HTML, CSS, jQuery, PHP, and MySQL.

WikiSearch

A project partner and I collaborated to develop and test a Java application which uses Wikipedia's API to display page data. Given a term that exists as a page on Wikipedia, the application displays information about that page's recent revisions and/or the pages top editors.