My name is Trevor Stam and I’m a software developer based in Seattle. I hail from a background in GIS (geographic information systems) and economics. Although I’m an American citizen, I was born and raised in the Netherlands. I worked for several Dutch universities as an economic researcher. In 2017 I moved to Southern California to work in GIS and have recently moved up to Seattle to establish myself as a developer. I like to create applications with which users can interact, create data points or derive insights from.


I work with technologies such as HTML , CSS, Javascript, JQuery, Python, Express, React/Redux, Node.js, MongoDB, PostgreSQL, SQL Server and AWS to create usable and visually pleasing applications. My interests lie in data visualization and mapping. You can find more about my projects on this site. Feel free to reach out to me, connect with me, check out my Github or review my resume.

Projects

You'll find a showcase of my coding projects on this page.

project-image
  • Project title:
    • FlySorter
  • Client:
    • FlySorter
  • Project url:
    • NDA
  • Github repo:
    • https://github.com/fly-sorter
  • Collaborators:
    • David Chambers, Ben Harris, Timothy Li, Emery Parks
  • Technologies used:
    • HTML, CSS, Javascript, Node.js, Express, MySQL, AWS Cognito, AWS API Gateway, AWS Lambda, AWS Aurora, AWS Cloudwatch
  • Description:
    • FlySorter is an inventory management application for the Seattle-based company: FlySorter. FlySorter builds machines to sort fruit flies so they can be used for scientific research. This application keeps track of those machine assemblies, sub-assemblies, and the parts that belong to those sub assemblies. These components are displayed on the page and allows the user to click on a sub-assembly to reveal the parts that makeup that sub-assembly. The table also allows the user to filter parts and search for a part in order to make finding particularparts faster and easier for the user.
  • My Contribution:
      • 1. Migrated database from MongoDB to serverless AWS Aurora MySQL
      2. Re-designed schemas and tables
      3. Wrote all the queries to enable full-CRUD operations of the application
project-image
  • Project title:
    • FooDriver
  • Organization:
    • Code Fellows
  • Project url:
    • http://foodriver.s3-website-us-west-2.amazonaws.com/
  • Github repo:
    • https://github.com/fooDriver
  • Collaborators:
    • Sara Bahrini, Jen Carrigan, Ben Harris, Timothy Li,
  • Technologies used:
    • Javascript, Express, Node.js, MongoDB, Three.js, Jest
  • Description:
    • fooDriver is a comprehensive digital pantry application for mobile grocery stores and food pantries serving the needs of people with low mobility or limited access to nutritious food. With fooDriver organizations administering mobile food pantries will have an overview of their fleet of mobile pantries, food items stored in the pantry, the drivers and the stops on the routes. Drivers or people working on the mobile pantry can keep track of inventory and restock items depending on the demand along the route. Organizations or individuals donating food items will be able to add to the inventory of the mobile pantries. With fooDriver we intend to streamline the operations of mobile grocery units and bring involved parties closer together in the process. Additionally, an administrative CLI is available for quick connect and data entry.
  • My Contribution:
      • 1. Enriched MongoDB schemas with Mongoose and mongoose-autopopulate package
      2. Created route methods and handlers with Node.js and Express
      3. Tested Express routes with Jest
project-image
  • Project title:
    • Dirt Finder
  • Organization:
    • Code Fellows
  • Project url:
    • https://dirtfinder.herokuapp.com
  • Github repo:
    • https://github.com/jlhiskey/dirt-finder301
  • Collaborators:
    • Jason Hiskey, Kristian Esvelt, Daniel Frey
  • Technologies used:
    • HTML, CSS, Javascript, Node.js, Express, PostgreSQL, EJS, JQuery, Twilio API
  • Description:
    • We created the Dirt-Finder for our Code 301 final project at Code Fellows. Dirt-Finder is an application completely dedicated to streamlining the import and export of soil from jobsites. When you fill out the form, it will create a unique user id for your profile. Once you’ve submitted your personal information plus your want or need for a specific soil type, you can send a text to our number. Via the Twilio API you will be able to receive a text with a list of suppliers of your soil type in your zipcode.
  • My Contribution:
    • 1. Designed an automatic userkey generator for users to access their customized user page
project-image
  • Project title:
    • Backnote
  • Organization:
    • Code Fellows
  • Project url:
    • https://polevoyd.github.io/backnote/
  • Github repo:
    • https://github.com/polevoyd/backnote
  • Collaborators:
    • Dmitry Polevoy, Pablo Rosales, Brai Frauen
  • Technologies used:
    • HTML, CSS, Javascript
  • Description:
    • For our Code 201 final project at Code Fellows we created Backnote. Backnote is a browser extension for taking quick online notes. Simply highlight desired text in a browser and Backnote will automatically paste it in a new window for you. Take notes on the fly and save it as a text file with just one click.
  • My Contribution:
    • 1. Designed and styled the web pages
    2. Created a newsletter sign-up
project-image
  • Project title:
    • Family Names Search
  • Organization:
    • University of California Riverside: Botanic Garden
  • Project url:
    • https://beesadmin.github.io/search_family_names/
  • Collaborators:
    • None
  • Technologies used:
    • HTML, CSS, Javascript, Materialize
  • Description:
    • For the Botanic Gardens at the University of California Riverside, I created a dynamic search list to retrieve plant family names and/or its abbreviation. This was a side project inside a larger project to map all tree and plant species at the UCR Botanic Gardens.