Pfizer logoCurrently an Extern @Pfizer
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 · 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
  • 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

Pfizer Advanced: AI-Powered Document Insights & Data Extraction Externship

Pfizer

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

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
Google Docs
Access

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

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

✅ Verified by Extern · ⏱️ In progress

Pfizer Advanced: AI-Powered Document Insights & Data Extraction Externship

Prototype AI-powered document intelligence with Pfizer—using OCR, LLMs, and RAG to automate real enterprise PDF workflows and build a standout portfolio project.

AI & MLPythonDocument IntelligencePresentation Skills

Overview

The project developed prototype document-intelligence workflows combining OCR, LLMs, and RAG techniques. The work reviewed foundational LLM concepts and applied them to design how extracted text and embeddings could be used in downstream document search and question answering. Deliverables included documented research and implementation notes related to model behavior and retrieval strategies.

Pfizer Advanced: AI-Powered Document Insights & Data Extraction Externship

What I've accomplished

I analyzed a multi-part pharmaceutical vendor file, cataloging six date formats, identifying retest and superseded-version dates, flagging repeated disclaimers and near-duplicate statements, and documenting OCR risks such as checkbox ambiguity and redactions.

Project breakdown

I inspected a multi-part vendor file, identified six date formats, noted retest and superseded-version dates, flagged repeated disclaimers and near-duplicate statements, and recorded OCR risks like checkbox ambiguity and redactions.

The module presented messy text and a noisy scanned image. I cleaned and standardized text (HTML removal, encoding fixes, price normalization, contraction expansion, punctuation handling) and applied median blur, grayscale, and CLAHE to denoise and enhance a scanned document, producing a cleaned…

View all works