Projects

Soccer ProLeagues - Soccer Web App based on Web-Scraped Pro Soccer Stats

February 2024 - April 2024

Website | Demo Video | GitHub (Frontend) | GitHub (Backend)

  • Constructed RESTful API backend with Flask and SQLAlchemy to serve data stored in PostgreSQL that was collected by web-scraping popular sports news websites with BeautifulSoup4.
  • Built a responsive React front-end, utilizing complex state changes to provide user functionality to login and follow/unfollow teams and leagues, adding them to user-customized pages that can be securely accessed and modified by the user.
  • Constructed object-oriented database model structure with SQLAlchemy, enabling queries to return associated team, league, and user data and to modify join tables to implement user follows and unfollows.
  • Implemented user authentication and authorization on client-side and backend using JWTs to enable secure, personalized access for users with registered profiles.

Pixly - Full-Stack Photo Gallery App

September 2023 - October 2023

Demo Video | GitHub (Frontend) | GitHub (Backend)

  • Implemented functionality for user upload and retrieval of images via Amazon S3, with S3 file access links stored in a PostgreSQL database with image metadata and other information.
  • Integrated image-editing functionality, allowing users to make simple image modifications, save associated image edits in Amazon S3, and toggle between original and updated images on the image detail page.
  • Extended photo upload functionality to utilize PostgreSQL full-text search using stored metadata from image files.
  • Utilized AWS S3 to generate protected URLs to provide access to photos stored in private AWS S3 buckets.

Jobly - Full-Stack Job Application Web App

August 2023 - September 2023

Demo | GitHub (Frontend) | GitHub (Backend)

  • Constructed object-oriented database model structure to create standardized and replicable queries to power a RESTful API backend.
  • Implemented user authentication/authorization with JWTs on selected routes to protect routes and limit job application functionality based on logged-in status.
  • Attained 98% test coverage for the back-end API utilizing test-driven development, incorporating both unit and integration tests, to ensure robust code quality and reliability.

Warbler - Full-Stack Twitter Clone

August 2023 - September 2023

GitHub

  • Utilized object-oriented methods for interacting with a PostgreSQL database using SQLAlchemy, simplifying database interactions to streamline the development process while powering core functionality of user following/followed-by features.
  • Implemented protection of user and database information against CSRF attacks by implementing form validation with CSRF tokens through WTForms.