Breaking Games logoCurrently an Extern @Breaking Games
Jonathan Smith portrait

Senior CS student focused on data and databases

I turn messy data into structured databases and dashboards that inform decisions, currently completing a Breaking Games externship.

🟢 Open to work

Work samples

Projects include an externship at Breaking Games converting CSVs into a production-style analytics database and a Q4 decision dashboard using SQL and Claude.

  • SQL & Database Architecture Externship with Breaking Games
    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
  • Rewind
    Rewind

    Rewind

    Cross-platform social app (Flutter/Dart) for Android, iOS, and web. Designed and enforced a feature-based Clean Architecture with Riverpod state management and a Firebase backend (Auth, Firestore, Cloud Storage, Cloud Functions, FCM), writing code standards and documentation to keep a multi-contribu

    FlutterDartRiverpodFirebaseAuthFirestoreCloud StorageCloud FunctionsFCMGitHub ActionsGitHub CopilotClaude Code

About me

I turn messy data into structured databases and dashboards that inform decisions, currently completing a Breaking Games externship.

I am a senior Computer Science student at Full Sail University finishing my bachelor's while exploring a career shift. I work on data and database projects, including an externship building an analytics database and dashboard from messy CSVs.

Externships

SQL & Database Architecture Externship with Breaking Games

Breaking Games

Experience

Customer Service Representative

Inspira Financial · May 2024 - Present

Customer Service Representative

Assurant · Apr 2019 - May 2024

Electronic Services Specialist

Achieva Credit Union · Jun 2014 - Mar 2019

Education

Full Sail University, Winter Park, FL

B.S. Computer Science — Mobile Development Concentration · Class of 2027

Full Sail University, Winter Park, FL

A.S. Computer Science · Class of 2026

Skills

SQLDatabase architectureData cleaning from CSVsAnalytics dashboard designClaude (AI assistant)

✅ 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 converted six provided e-commerce sources into a local SQLite analytics database. The work installed DB Browser for SQLite, opened the supplied breaking_games.db, and verified that all six tables were populated and queryable. It also traced a fragmented customer journey, created a dim_product table, and produced a product performance table that flagged top sellers and SKUs with

SQL & Database Architecture Externship with Breaking Games

What I've accomplished

I produced and validated a local breaking_games.db containing six populated tables, created dim_product as a clean product dimension, and generated a product performance table that identified top sellers and products with traffic but no sales.

Project breakdown

The work described installing DB Browser for SQLite, downloading the breaking_games.db file, and confirming the database opened successfully so all six tables were queryable in a local environment.

The project traced a fragmented customer journey, created dim_product as a clean product dimension, wrote JOINs to unify four tables, and produced a product performance table that identified top sellers and products with traffic but no sales.

Google Docs
Access

I audited ad and referral data, designed a channel taxonomy, calculated CTR/CPC/ROI per Meta campaign, and produced a Q4 ad allocation plan that matched $37,200.94 in Meta spend to Shopify sales using documented SQL and dashboards.

Google Docs
Access
View all works

Rewind

Cross-platform social app (Flutter/Dart) for Android, iOS, and web. Designed and enforced a feature-based Clean Architecture with Riverpod state management and a Firebase backend (Auth, Firestore, Cloud Storage, Cloud Functions, FCM), writing code standards and documentation to keep a multi-contribu

FlutterDartRiverpodFirebaseAuthFirestoreCloud StorageCloud FunctionsFCMGitHub ActionsGitHub CopilotClaude Code

Overview

Rewind
View all works

Liquor Ledger POS System

Android tablet POS system for liquor retail. Participated in requirements analysis and UI prototyping with the client, designed a Firebase backend with role-based access control and secure transaction processing, built monitoring tooling for production, and automated inventory tracking and vendor pu

FirebaseAndroid
View all works