James Calabrese portrait
Currently an Extern @Breaking Games

🟢 Open to work

Aspiring database designer with Breaking Games externship

I am working on an SQL and database architecture externship, building hands-on skills in queries and schema design to launch my career.

Work samples

Project work from the Breaking Games externship, focused on SQL querying and schema design. These pieces show practical exercises and applied database tasks from the program.

  • 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

About me

I am working on an SQL and database architecture externship, building hands-on skills in queries and schema design to launch my career.

I'm James Calabrese. I am starting my career and have completed an SQL and database architecture externship with Breaking Games. I am focused on learning practical database design and querying while building a foundation for future projects and roles.

Externships

SQL & Database Architecture Externship with Breaking Games

Breaking Games

Experience

Extern

Breaking Games - Remote · Jul. 13 2026 - Sep. 07, 2026

Education

Stockton University

B. S. Computer Science · Class of 2025

Skills

SQL queryingDatabase schema designData modelingQuery optimization basicsRelational databases

✅ 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 raw CSV sources into a structured analytics database and produced a Q4 dashboard prototype. The work cataloged each dataset, mapped relationships across sales, products, and customers, and defined staging and fact tables for analytics. Deliverables included the database schema and a dashboard-ready data model.

SQL & Database Architecture Externship with Breaking Games

What I've accomplished

I inventoried all six raw tables, produced five exploratory SQL queries with results (top products, catalog size, ad spend), and authored a running Week‑1 project brief summarizing dataset capabilities and gaps.

Project breakdown

I inventoried each of the six raw data tables, noted what questions each could and could not answer, pasted five SQL queries with results (top products, catalog size, ad spend), and created a running Week‑1 project brief for the externship.

Google Docs
Access

A fragmented set of four spreadsheets was unified by designing dim_product, assigning stable product IDs, and joining it with event and sales tables. I ran aggregation queries to produce a product performance table used to rank products by revenue and units sold.

Google Docs
Access

During the externship I analyzed referrals, Meta campaign and sales data, calculated CTR, CPC and ROI per campaign, and produced a Q4 ad allocation plan that linked $37K in Meta spend to $61K sales and recommended campaign-level reallocations.

Google Docs
Access

The project examined exported checkout records, identified bot-like sessions (high quantities, rapid duplicate accounts, odd shipping-to-subtotal ratios), created a filtered view of clean checkouts, and recalculated the abandonment rate excluding noise.

Google Docs
Access
View all work