Dimitry Vartan

Attronica Externship via Extern

I turn messy data into clear answers, building attribution models, dashboards, and reports that nontechnical stakeholders can use to make decisions.

About me Message Me

Work samples

Projects range from SQL database builds and dashboards to channel attribution, ROI and payback analyses, and a zero-waste sustainability externship. I document processes so teams can keep reporting

Schreiber Foods Zero-Waste Sustainability Strategy Externship
Schreiber Foods · Oct 2025✅ Verified by Extern
Schreiber Foods Zero-Waste Sustainability Strategy Externship
You’ve definitely eaten Schreiber Foods — you just didn’t know it. Think: Cheese slices. Yoghurt tubes. Now they want you to help them solve a massive real-world challenge: How do we turn food manufacturing waste into something useful — instead of sending it to landfills? Schreiber’s aiming for 100% waste diversion by 2030, and in this externship, you’ll dig into real data, analyze why some plants are falling behind, and uncover circular economy solutions that actually work. This is an Internship Track Externship: top externs will be selected to interview with Schreiber Foods for internship opportunities.
StrategyOperationsAI & MLPresentation Skills
SQL & Database Architecture Externship with Breaking Games
Breaking Games · Oct 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.
Top performerAnalytics Database DesignData AnalysisSQL FundamentalsData Storytelling
Attronica Financial Planning & Analysis and Private Company Valuation Externship
Attronica✅ Verified by Extern⏱️ In progress
Attronica Financial Planning & Analysis and Private Company Valuation Externship
A 40-year-old, $80M family-owned IT firm is preparing to sell — and they need real FP&A work to back it: clean financials, a defensible forecast, and a valuation. Organize the books, model the forecast, and deliver a valuation that lands on the CEO's desk and on a buyer's table.
Financial ModelingFinancial Statement AnalysisExcelValuationForecasting

About me

I turn messy data into clear answers, building attribution models, dashboards, and reports that nontechnical stakeholders can use to make decisions.

I trained as a biologist. At San Jose State I spent two years scanning ant specimens and building 3D models of their mandibles — slow work that taught me to trust a measurement only as far as its method. What changed my direction was five years at a medical equipment store. I fitted walkers, wheelchairs, and electric scooters, and what someone took home usually came down to cost and coverage, not what fit them best. The science was rarely the constraint. For five years I worked at a medical equipment store, fitting walkers, wheelchairs, and scooters for patients and their families. What stuc

Externships

Attronica Financial Planning & Analysis and Private Company Valuation Externship

In progress

Experience

Extern, Data & Analytics

Breaking Games · Aug. 2026 – Present

Senior Sales Associate

Almaden Medical Market · March 2025 – Present

Sales Associate

Almaden Medical Market · May 2021 – March 2025

Research Assistant

San Jose State University · Jan. 2023 – May 2024

Extern, Sustainability & Operations Analysis

Schreiber Foods · Aug. 2025 – Oct. 2025

Arborist Technician

San Jose Department of Transportation · Aug. 2024 – Oct. 2024

Education

Harvard Extension School

A.L.M. in Sustainability (expected 2027) | GPA 3.6 · Class of 2027

De Anza College

Certificate of Achievement, Advanced · Class of 2028

San Jose State University

B.S., Ecology and Evolution | GPA 3.2 · Class of 2024

Skills

ROI analysiscost-benefit analysispayback analysisbusiness case developmentdata cleaning and validationchannel attribution modelingstatistical analysisprocess design and documentationExcelSQLTableauPowerPointPython

Back to work

Schreiber Foods · Oct 2025 ↗

✅ Verified by Extern

Schreiber Foods Zero-Waste Sustainability Strategy Externship

You’ve definitely eaten Schreiber Foods — you just didn’t know it. Think: Cheese slices. Yoghurt tubes. Now they want you to help them solve a massive real-world challenge: How do we turn food manufacturing waste into something useful — instead of sending it to landfills? Schreiber’s aiming for 100% waste diversion by 2030, and in this externship, you’ll dig into real data, analyze why some plants are falling behind, and uncover circular economy solutions that actually work. This is an Internship Track Externship: top externs will be selected to interview with Schreiber Foods for internship opportunities.

StrategyOperationsAI & MLPresentation Skills

Overview

During my externship with Schreiber Foods, I tackled the challenge of transforming food manufacturing waste into valuable resources. The goal was to contribute to the company's ambitious target of achieving 100% waste diversion by 2030. I engaged deeply with real data, analyzed operational hurdles, and explored practical circular economy solutions across multiple facilities.

Schreiber Foods Zero-Waste Sustainability Strategy Externship

Google Slides

Access

What I've accomplished

I produced a set of quantitative deliverables: a tabulation of waste flows and diversion rates, a cross-facility comparison highlighting best and worst performers, a regional provider map and notes, and a final presentation with proposed investments, payback ranges, and estimated annual revenue.

Project breakdown

View all work

Back to work

Breaking Games · Oct 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

Overview

The work audited six raw data sources, mapped their fields and quality issues, defined a schema linking dim_product to events, sessions, carts, and sales, and produced a denormalized dashboard table plus an HTML dashboard with three visuals. The work was awarded Top Performer by Breaking Games.

SQL & Database Architecture Externship with Breaking Games

Google Drive

Access

What I've accomplished

I produced a data inventory and Holiday Game Plan, unified product data with a dim_product and linking tables, reconciled ad spend to sales, implemented bot-detection and a clean_checkouts view, and built a denormalized dashboard table plus an HTML dashboard with three visuals.

Top performer

Project breakdown

View all work

Back to work

Attronica ↗

✅ Verified by Extern · ⏱️ In progress

Attronica Financial Planning & Analysis and Private Company Valuation Externship

A 40-year-old, $80M family-owned IT firm is preparing to sell — and they need real FP&A work to back it: clean financials, a defensible forecast, and a valuation. Organize the books, model the forecast, and deliver a valuation that lands on the CEO's desk and on a buyer's table.

Financial ModelingFinancial Statement AnalysisExcelValuationForecasting

Overview

The externship addressed financial cleanup, forecasting, and valuation for a 40-year-old, family-owned IT company preparing for sale. The work involved organizing historical books, building a defensible financial forecast, and constructing a valuation model. Deliverables included cleaned financial statements, a forecast model, and a valuation memo.

Attronica Financial Planning & Analysis and Private Company Valuation Externship

What I've accomplished

I worked through the externship deliverables to prepare the company’s financials and valuation materials, producing cleaned statements, a forecast model, and a valuation memo aligned with the programme requirements.

Project breakdown

View all work

Work samples

Schreiber Foods Zero-Waste Sustainability Strategy Externship

SQL & Database Architecture Externship with Breaking Games

Attronica Financial Planning & Analysis and Private Company Valuation Externship

About me

Schreiber Foods Zero-Waste Sustainability Strategy Externship

Overview

What I've accomplished

Project breakdown

Inside a Zero Waste FacilityI analyzed the Shippensburg facility's waste report and summarized its waste streams, diversion methods, and diversion rate.

Cross-Facility Data Analysis & Plant SelectionI built a diversion comparison chart showing each U.S. plant's waste diversion rate.

Investigate Regional BarriersI mapped local waste services and recyclers near the Smithfield facility, listing providers, distances, and material specializations.

Designing a Diversion StrategyI drafted a facility diversion strategy report recommending partnerships, knowledge transfer from a nearby plant, and targeted preprocessing investments to reduce comingled waste.

SQL & Database Architecture Externship with Breaking Games

Overview

What I've accomplished

Project breakdown

Getting Into Breaking Games' Raw DataI documented the dataset inventory and first-week SQL work for the Breaking Games externship, compiling a running Holiday Game Plan to track findings week by week.

Designing Your First DatabaseI built joined queries and a unified customer-journey view, then produced a reorder recommendation for Breaking Games based on cleaned product IDs and performance aggregates.

Following the MoneyI built a Q4 ad allocation plan that connected Meta campaign spend to on-site revenue and recommended which campaigns to keep, cut, or reallocate.

Investigating Breaking Games' Cart AbandonmentI diagnosed cart abandonment for Breaking Games, filtered bot noise, and recalculated the true abandonment rate.

Attronica Financial Planning & Analysis and Private Company Valuation Externship

Overview

What I've accomplished

Project breakdown

Onboarding and engagement kickoffI met the FP&A lead, reviewed the company's history and ownership, completed confidentiality paperwork, and refreshed my understanding of the balance sheet, income statement, and cash flow statement before beginning the analysis.