JG@joseph-grossi
Joseph Grossi portrait

Joseph Grossi - Aspiring Tech Professional

I'm a Computer Science junior focused on building essential skills through hands-on externships and projects.

Work samples

Dive into my externship experiences that showcase my skills in cybersecurity and data analytics, bridging theory and practice.

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

    Breaking Games · Aug 2026 · ✅ Verified by Extern

    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
  • Hydroficient IoT Cyber Defense Externship
    Hydroficient logo

    Hydroficient · Mar 2026 · ✅ Verified by Extern

    Hydroficient IoT Cyber Defense Externship

    Build, hack, and defend real IoT infrastructure, then hand your security playbook to an actual company. You’ll launch realistic cyberattacks, from spoofing and replay attacks to unauthorized shutoffs, and implement defenses like TLS and mTLS.

    Top performerPython ProgrammingData AnalysisThreat ModelingDashboard Development

About me

I'm a Computer Science junior focused on building essential skills through hands-on externships and projects.

I'm a junior pursuing a Bachelor's Degree in Computer Science. While I have some work experience, I’m eager to officially kickstart my career by honing my technical skills in real-world scenarios.

Externships

SQL & Database Architecture Externship with Breaking Games

Breaking Games

Experience

Fulfillment Expert

Target · May 2026

Temporary Operations Support

Randstad USA · Mar 2025 - Sep 2025

Education

Bridgewater State University

B.S Computer Science · Class of 2027

Bridgewater State University

B.A Communications and Media · Class of 2024

Skills

SQLDatabase ArchitectureCybersecurityData AnalyticsIoT Security

✅ Verified by Extern

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 work ingested six provided data sources into a SQLite analytics database, inventorying raw tables and running diagnostic SQL to summarize top products, revenue, product counts, ad spend, and unique checkouts. It produced a cleaned dim_product table, joined sales and ad data into a product_performance view, and produced a Q4 ad allocation plan and a clean_checkouts view with recalculated

SQL & Database Architecture Externship with Breaking Games
Google Drive
Access

What I've accomplished

I loaded six data sources into SQLite, documented query results in a Week 1 Holiday Game Plan, created a cleaned dim_product table and a joined product_performance view, calculated CTR/CPC/ROI across campaigns to produce a Q4 ad allocation plan, and built a clean_checkouts view that recalculated abandonment metrics after bot filtering.

Project breakdown

View all work

✅ Verified by Extern

Hydroficient IoT Cyber Defense Externship

Build, hack, and defend real IoT infrastructure, then hand your security playbook to an actual company. You’ll launch realistic cyberattacks, from spoofing and replay attacks to unauthorized shutoffs, and implement defenses like TLS and mTLS.

Python ProgrammingData AnalysisThreat ModelingDashboard Development

Overview

The project worked against a simulated HYDROLOGIC deployment at The Grand Marina, mapping system components and threat surfaces, building and attacking an MQTT pipeline, and implementing layered defenses including TLS, mTLS, HMAC, timestamps, and sequence counters. Deliverables included threat-model diagrams, a Python sensor log generator, a secured MQTT deployment with measured performance

Hydroficient IoT Cyber Defense Externship

What I've accomplished

I produced a full security playbook for an IoT water system: threat-model diagrams, a Python sensor log generator, an insecure then TLS/mTLS-secured MQTT pipeline with measured latency, a device provisioning policy, replay-attack experiments showing combined defenses were required, and a capstone dashboard and slide deck.

Top performer

Project breakdown

View all work

✅ Verified by Extern

NASCAR NY Racing Sponsorship ROI Externship

A NASCAR NY Racing externship focused on measuring sponsor visibility and calculating sponsorship ROI across a full Cup Series season.

PythonData Analysis

Overview

The externship produced a season-long analysis that combined race results, media coverage, and social metrics to evaluate sponsor visibility. The work cleaned and merged race and sponsor data, tested correlations between performance and exposure, and implemented a Python scoring pipeline that ranked sponsors by visibility efficiency. The final deliverables included ranked sponsor metrics and a

NASCAR NY Racing Sponsorship ROI Externship
Google Slides
Access

What I've accomplished

I built a validated data pipeline and Python scoring system that produced ranked sponsor visibility and efficiency metrics across 36 Cup Series races, and I recommended Busch Light as the top efficiency sponsor.

Project breakdown

View all work