JOSHUA LOPEZ

Welcome to my portfolio site, where you can explore my data-related projects.

NOAA Fishing Survey Data Project

This project demonstrates an ETL pipeline that processes NOAA's fishing survey data, then makes it available for analysis through an interactive web app. Explore the links below to learn more!

Links: Web App | Github Repo

Tools: Python | SQL | dbt | DuckDB | Prefect | Streamlit | Docker | Git | Bash

Concepts: ETL | Pipeline Orchestration | Data Warehouse | Data Visualization | Web Application | Version Control | Containerization | Data Analytics | Data Engineering

YouTube Fishing Videos Data Analysis

This project ingests YouTube video data related to fishing, stores it in MongoDB, and provides visualizations through Metabase for analysis—check out the links below for more details!

Links: Dashboard | Github Repo

Tools: Python | YouTube Data API | MongoDB | Metabase | Docker | Git

Concepts: Data Ingestion | API | NoSQL | JSON | Business Intelligence | Reporting | Dashboarding | Data Visualization | Data Analytics | Version Control | Containerization

NJ Beach Cam Object Detection Notifier

This project performs object detection using YOLOv8 model on a live stream of a NJ beach. Notifications via Twilio are sent when there are increased levels of fishing activity. Check out the links below!

Links: Web App (coming soon) | Github Repo

Tools: Python | OpenCV | YOLOv8 | Twilio API | Docker | Git | Bash

Concepts: Data Processing | Computer Vision | Object Detection | Deep Learning | Convolutional Neural Networks (CNN) | Web Application | Version Control | Containerization