Data Engineering / Data Testing
Co-leading the development of a relational database to organize and manage 40 years of lake sampling data. Responsibilities include writing R test scripts, designing SQL tables and relationships, creating new data workflows, and producing clear, informative data visualizations to support research and analysis.
Recipe Management
Designed and implemented a fully functional Flask application, enabling users to seamlessly add, edit, and delete recipes.
Developed a responsive API to retrieve detailed recipe information by efficiently querying a SQL database.
Ski Weather Data Tool
Combined web scraping for weather data collection with a robust Python backend to create and merge JSON files, made comparisons using normalized data and incorporated a UI to let users explore the data.
Automated Emails
Developed an automated emailing system using Python, reducing task time by 95%. Split a CSV of several hundred short term rental reservations, created 50 unique PDFs for each with personalized information.
Designed for an utilized by Tentrr, a short term rental website. It's like Airbnb but for camping.
Track That!
Gained experience with Agile development methods, weekly scrums, working with project managers, and using Git, GitHub and branches as part of a development team.
Utilized SQL and a custom API to add new events and create a database of completed activities with the time and date of completion.
Anders' Orbits
Developed a simple portfolio website for my brother as a Flask application to show off his Senior Capstone Project.
Incorporates embedded latex and a professional design.
Check it out at anders-orbits.com.
Plant Ecophysiology Research
I studied the effects of high light stress on ornamental plants, using croton as a study sample. My research aimed to determine how pigmentation changed with varying light intensity, which relied on the use of a LI-6800 and sampling.
The use of a LI-6800 allowed me to test varying light situations and could see in real time how the plant was reacting.
Using Excel, I was able to create visualizations of CO2 output versus light intensity to gain an understanding of how the plant responded to stress.