Breaking Games logoCurrently an Extern @Breaking Games
Sam Kubata portrait

Aspiring Market Analyst

I’m a recent graduate focused on consumer behavior and market analysis, ready to take on new challenges.

Work samples

Dive into my projects showcasing market analysis and consumer insights, reflecting my commitment to excellence.

  • SQL & Database Architecture Externship with Breaking Games
    Breaking Games logo

    Breaking Games · ✅ Verified by Extern · ⏱️ In progress

    SQL & Database Architecture Externship with Breaking Games

    Turn six messy CSVs into an analytics database and a Q4 dashboard that drives real business decisions. SQL + Claude.

    Analytics Database DesignData AnalysisSQL FundamentalsData Storytelling
  • Ski Resort Pricing Analysis
    Ski Resort Pricing Analysis

    Conducted exploratory data analysis and predictive modeling on operational datasets to identify factors influencing pricing and performance outcomes. Applied preprocessing, feature selection, and cross-validation techniques to improve model accuracy and interpretability. Developed scenario-based analyses to evaluate the potential impact of operational changes and support evidence-based decision-making. Created data visualizations and written summaries to communicate findings clearly to non-technical audiences. Utilized Python libraries including pandas, scikit-learn, matplotlib, and seaborn for data cleaning, analysis, and reporting

    pandasscikit-learnmatplotlibseabornPython

About me

I’m a recent graduate focused on consumer behavior and market analysis, ready to take on new challenges.

I am a recent graduate eager to kickstart my career in market analysis. My experience with Beats By Dre has equipped me with insights into consumer behavior, and I am committed to enhancing my skills and building a strong resume for future opportunities.

Externships

SQL & Database Architecture Externship with Breaking Games

Breaking Games

Experience

Academic Tutor

UIC African American Academic Network · Sep 2021 May 2023

Office Aide

UIC Campus Housing · Jul 2022 Aug 2022

Vice President of Programming

University of Illinois Residence Hall Association · May 2022 May 2023

Education

University of Illinois Chicago (UIC)

Bachelor of Science in Mathematics and Computer Science · Class of 2025

Skills

Market AnalysisConsumer BehaviorData InterpretationResearch SkillsCommunication

✅ Verified by Extern · ⏱️ In progress

SQL & Database Architecture Externship with Breaking Games

Turn six messy CSVs into an analytics database and a Q4 dashboard that drives real business decisions. SQL + Claude.

Analytics Database DesignData AnalysisSQL FundamentalsData Storytelling

Overview

The externship consolidated six raw CSV files into a structured analytics database and produced SQL models that populated a Q4 analytics dataset. Work included cataloging sources, installing and validating a local database, defining a target schema, prioritizing ETL steps, and developing queries and models. Deliverables included an integrated schema and a populated analytics dataset.

SQL & Database Architecture Externship with Breaking Games

What I've accomplished

I produced an integrated analytics dataset by cataloging six data sources, building a local SQLite database, defining the target schema, and writing SQL models that populated the Q4 analytics tables.

Project breakdown

On Day 1 I inventoried six data sources, ran SQL queries (with Claude) to answer five executive questions, and recorded results like top products, catalog size (99), total Meta spend ($37,200.94), and 1,062 checkout sessions.

Google Docs
Access
View all work

Ski Resort Pricing Analysis

Conducted exploratory data analysis and predictive modeling on operational datasets to identify factors influencing pricing and performance outcomes. Applied preprocessing, feature selection, and cross-validation techniques to improve model accuracy and interpretability. Developed scenario-based analyses to evaluate the potential impact of operational changes and support evidence-based decision-making. Created data visualizations and written summaries to communicate findings clearly to non-technical audiences. Utilized Python libraries including pandas, scikit-learn, matplotlib, and seaborn for data cleaning, analysis, and reporting

pandasscikit-learnmatplotlibseabornPython
View all work

Text Statistics Web App

Developed a web application to analyze user input and display real-time counts of sentences, words, and characters

PythonHTML
View all work

Ternary Tree Analyzer

Designed and implemented a ternary tree data structure to efficiently store and manage integer datasets. Developed algorithms to insert elements, traverse the tree, and compute key properties such as the number of leaf and non-leaf nodes, nodes with degree two, and the overall tree depth

C++
View all work