Projects
Ad Campaign Analytics with SQL & Python
Worked with Adsphere (a fictional social media ad platform dataset) to explore how advertisers structure and present campaigns. The goal was to determine whether advertisers with the most active campaigns and ads generate the most revenue, and to analyze how presentation choices such as formats and CTAs affect performance. Wrote over 10 SQL queries using INNER/LEFT JOINs, CTEs, and INTERSECT, and paired them with Python visualizations in Seaborn and Matplotlib to test correlations and highlight trends. The analysis revealed a positive correlation between ad volume and revenue (though not causal) and showed that CTA effectiveness is format-dependent.
Role: Data Analyst
Technologies Used: MySQL, Python (SQLAlchemy, Matplotlib, Seaborn)
Ski Resort Data Analysis
Conducted a comprehensive analysis of U.S. ski resorts. Utilized Python and various libraries for data processing, statistical analysis, and visualization, assessing key metrics such as snowfall, terrain, amenities, and user reviews to derive data-driven insights.
Role: Software Developer, Data Scientist
Technologies Used: Python (Matplotlib, Seaborn), Online Data (APIs, CSV/HTML/XML Files)
Data-Driven Analysis for Colorado Swim School
Conducted informational interviews with Colorado Swim School management to gather qualitative insights and mapped findings using data journey and social world models. Collaborated with team members to synthesize data and perform secondary source analysis, evaluating social media presence and other external factors. Identified challenges, proposed design principles to improve information flow, and provided actionable recommendations for organizational improvement. Delivered findings in a professional presentation to Colorado Swim School stakeholders.
Text-Based Adventure Game
Designed and developed a dynamic, text-based two-player board game in C++ inspired by The Lion King, implementing interactive gameplay mechanics, file handling, and strategic decision-making features.
Role: Software Developer
Technologies Used: C++, File I/O
Ice Cream Shop Business Plan
Determined the most profitable business and target location by using SQL to query Google reviews, then processed the data. Then surveyed potential customers to assess the competition.
Role: Data Analyst, Product Manager
Technologies Used: SQL, Excel, Google Suite
