Projects

StudyBuddy, a Study Group Finder

Software Engineering Final Project

October 2025 – December 2025
  • Built StudyBuddy with a teammate: a Flask web app where students register, log in, and create, join, and manage study groups, with group chat and file sharing, a task tracker, and video meeting links.
  • Migrated the app’s database from SQLite to MongoDB Atlas with PyMongo, moving users, groups, messages, and tasks to the cloud.
  • Fixed a permissions bug that let non-creators edit groups, limiting editing and deleting to each group’s creator.
  • Worked across three Agile sprints with Git and GitHub, and handled final debugging before the class presentation.
Python Flask MongoDB HTML Bootstrap Git
GitHub repository
StudyBuddy home page in dark mode, showing a subject filter and four study group cards with member counts, creators, members, and Join, Leave, Chat, Edit, and Delete buttons
Study Group Dashboard The home page, where students filter groups by subject and join, leave, chat in, or manage each group.

SpaceX Falcon 9 Rocket Landings

IBM Data Science Professional Certificate · Applied Data Science Capstone

July 2025
  • Prepared and analyzed Falcon 9 launch data in Python to identify the key launch parameters that predict first-stage landing success.
  • Built interactive visualizations with Plotly and Seaborn to explore how launch parameters relate to landing outcomes.
Python pandas Plotly Seaborn Jupyter
Capstone badge Certificate
Seaborn line chart of Falcon 9 first-stage landing success rate by year, at zero through 2013 and rising to about 90% by 2019
Success Rate of Rocket Landings Yearly first-stage landing success rate, climbing from zero before 2014 to around 90% by 2019.
Seaborn bar chart of average landing success by orbit type, with ES-L1, SSO, HEO, and GEO at 100% and GTO lowest at about 52%
Success Rate of Each Orbit Average landing success by target orbit, with ES-L1, SSO, HEO, and GEO missions landing every time.

Analyzing Website Data with The GRAMMYs

The Global Career Accelerator

July 2024 – August 2024
  • Identified key trends and user behaviors using Python to inform content strategy and promotional initiatives by analyzing and interpreting website traffic data for The GRAMMYs.
  • Analyzed critical performance metrics with pandas, uncovering patterns and identifying areas for improvement, leading to enhanced user engagement and site optimization.
  • Conducted thorough benchmarking and competitive analysis, identifying growth opportunities and strategic advantages to position The GRAMMYs ahead of competitors.
  • Developed dynamic, interactive data visualizations using Plotly, delivering actionable insights to GRAMMYs stakeholders and facilitating data-driven decision-making.
Python pandas Plotly NumPy
Certificate
Plotly line chart of daily average pages per session from February 2022 to June 2023, with the Recording Academy site at a median of 2.9 pages and a peak of 11.4 on June 15, 2022, and grammy.com at a median of 2.1 with a peak of 5.8 on February 5, 2023
Pages per Session Daily engagement on the GRAMMYs and Recording Academy websites. Recording Academy visitors viewed more pages per visit, while the GRAMMYs’ peak lined up with the February 2023 awards show.
Plotly grouped bar chart of visitors by age group for grammy.com and recordingacademy.com, with 18-24 and 25-34 the largest groups and 65+ the smallest
Age Demographic Share of visitors by age group on the GRAMMYs and Recording Academy websites, built with Plotly.

Intel Sustainability Project

The Global Career Accelerator

June 2024 – July 2024
  • Conducted thorough research using complex SQL queries to determine the best locations for new data centers based on energy availability and sustainability requirements.
  • Generated sensible conclusions and suggestions to guide the selection of sustainable and energy-efficient sites in decision-making processes.
  • Found ways to maximize the use of energy in data center operations and to harness renewable energy sources, which helped Intel meet its commitment to sustainability goals.
  • Identified places where energy output is excess, which might result in lower energy procurement costs for newly operating data centers.
  • Contributed significantly to Intel’s sustainability efforts by offering data-driven insights on adoption tactics for renewable energy, all visualized on Tableau.
SQL Tableau
Certificate
Tableau bar chart of renewable energy as a percentage of overall generation by U.S. region, led by the Northwest, Central, and California, with Florida lowest
Renewable Energy % per Region How much of each region’s energy comes from renewable sources, as a percentage.
Tableau bar chart of net energy production by U.S. region, with New England and the Mid-Atlantic producing a surplus and California and New York showing the largest deficits
Net Production vs Demand of Energy Net energy production by region. Regions below zero can’t keep up with their energy demand.

Company Data Analysis

May 2024
  • Created and managed a SQL database of over 15,000 rows to support structured, governed data access for sales and performance analysis.
  • Developed automated Python pipelines for data cleaning, transformation, and storage, ensuring consistent data quality and traceability.
  • Built Tableau reports for sales, customer behavior, and performance trends, aligning visualizations with internal business data strategies.
SQL Python Tableau
Tableau dashboard: yearly revenue from 2019 to 2024 peaking at about $143K in 2022, revenue by item, and item distribution with AC units at 72% and furniture at 26%
Revenue by Year and Item Yearly revenue peaked at about $143K in 2022, and AC units brought in 72% of all sales.
Tableau map of revenue by city across South Texas, with the largest totals in Zapata and McAllen
Revenue by City Sales mapped across South Texas, with Zapata and McAllen bringing in the most revenue.