Analyst for finance, data, supply chain and AI teams

Tarang (TJ)
Jammalamadaka

I’m a data and business analyst finishing a degree in Management Information Systems at the University of Washington Bothell. This summer I was an AI MarTech Intern at The Coca-Cola Company. I graduate in June 2027 and I’m looking for a full-time analyst role.

See my work for FinanceDataSupply chainAI

Pick the role you are hiring for

Each tab shows the projects that prove that kind of work. Some projects sit in more than one lane. Every tab has its own link you can share.

The Coca-Cola Company, summer 2026

Replacing a manual data pull

~50people used the tool I built

A four-person, three-day manual pull became an internal tool. Azure OpenAI plans the query, plain Python computes every figure, and 50+ checks stop the run if two systems disagree.

  • AI
  • Data
  • Azure OpenAI
  • Python
  • Power BI
  • Excel

Quadcore Innovations, 2025 to 2026

Cutting support tickets

100 to 40support tickets after the fixes I proposed

Traced about 70% of tickets on a payments platform to one crash path. Resolution time went from 2 to 4 days to 24 hours, and weekly reporting moved to automated SQL feeds.

  • Data
  • SQL
  • Power BI
  • Tableau
  • Process mapping

UW Bothell Club Council, 2026 to 2027

Reviewing a $200K+ student budget

nearly 20%of funds allocated so far needed a correction I made before approval

As Treasurer I check each club’s purchase request against its quote, invoice or cart, line by line, before it goes to a vote. The allocation covers 95+ organizations.

  • Finance
  • Budget review
  • Excel
  • Funding policy

Team Cartier, team project

Forecast vs actual P&L

25+expense categories broken out

A FY2024 wholesale-distribution P&L: forecast vs actual by channel, budget variance and working capital. I built the P&L waterfall and broke out the expense categories. Figures are the case dataset.

  • Finance
  • Excel
  • Chart.js
  • Variance analysis

Independent research, 2026

Who really gets aerospace contract dollars

$499.4Bof DoD aerospace spend, FY2021 to 2025

Every NASA contract transaction plus DoD aerospace manufacturing (NAICS 3364) from USAspending, rolled up to parent companies. Lockheed Martin’s share goes from 21% as listed to 43% rolled up, and 87% of DoD aerospace dollars were not competed.

  • Supply chain
  • Finance
  • Data
  • Python
  • DuckDB
  • SQL
  • USAspending API

Independent research, 2026

Three-way match audit of a real ERP log

3,693PO items invoiced before the PO existed

Fourteen purchase-to-pay controls run on a public log of 251,734 PO items. 1.47% of items had an invoice dated before the PO, and 2,526 had one person both record and clear the same invoice.

  • Supply chain
  • Finance
  • Python
  • pandas
  • Process mining
  • Audit controls

Independent research, 2026

Testing the bullwhip effect

44industries tested on Census data through 2025

A replication of a well-known bullwhip study. With seasonality kept, no retail industry amplifies demand. Remove seasonality and 82% of retail cells appear to, so the method can manufacture the effect.

  • Supply chain
  • Data
  • Python
  • Census data
  • Bootstrap tests

Independent build, 2026

Seeing Boeing’s production rate from the sky

624 of 774737 deliveries seen as first flights

A 3D Puget Sound where every new Boeing jet’s first flight replays from public flight-tracking history, with a ledger that compares the sky count with Boeing’s reported deliveries over 647 days.

  • Supply chain
  • Data
  • Python
  • three.js
  • ADS-B data

Independent build, 2026

Satellites as a supply chain

16,896active satellites in the feed at last check

Every active satellite over you, with Amazon Leo and Starlink shown as a production line: factory, launch, orbit raising, on station, retired. Both factories are a short drive from campus.

  • Supply chain
  • JavaScript
  • three.js
  • CelesTrak data

Independent research, 2026

Forecasting weather prediction markets

4,433settled markets scored

A temperature model scored against Kalshi prices. The market was better calibrated (Brier 0.2114 vs my 0.3047), so I did not trade real money on it.

  • Data
  • Finance
  • Python
  • pandas
  • Calibration

SQL study, 2026

Segmenting store customers in SQL

54.4%of revenue from a third of buyers

Cohort and window-function queries on a six-table retail schema with 620 orders. Customers with four or more orders are 33.3% of buyers.

  • Data
  • PostgreSQL
  • Window functions
  • Cohorts

Independent build

Economic Pulse dashboard

7live indicators from FRED

Seven live indicators from the Federal Reserve’s FRED API in Python and Streamlit, with recessions shaded.

  • Finance
  • Data
  • Python
  • Streamlit
  • FRED API

Independent study

Washington housing and homelessness

9years of rent, income and vacancy data

Nine years of rent, income, vacancy and homelessness data, modeled in R and published in Tableau.

  • Data
  • R
  • Tableau

Open source

ragproof

BEIRSciFact benchmark harness

An open-source harness that scores how well a search system finds the right documents.

  • AI
  • Python
  • Retrieval evaluation

Product I built

AutoAppli

~400weekly users

A job-search tracker that shows where an application pipeline is leaking.

  • AI
  • Next.js
  • TypeScript
  • Claude API

Product I ran, Mar to Aug 2026

SyllabusAI

1,055automated tests

Turned a syllabus into dated calendar deadlines. I built and ran it from March to August 2026.

  • AI
  • Node
  • Supabase
  • Claude API

Kaggle simulation competition, 2026

A card-game playing agent

245th of 6,807final rank, top 3.6%

An agent that plays the Pokémon Trading Card Game, ranked on a ladder against thousands of other entrants’ agents.

  • AI
  • Agents
  • Simulation
Where each project sits

Deep dives: four projects told with their own data

Most dots here stand for one real person, ticket, market or buyer from the work. The note under each picture says what one dot is.

The Coca-Cola Company, summer 2026

Replacing a three-day manual pull

4 people spent about 3 days pulling the same recurring request by hand.

I interviewed 10 of the people who relied on it and built an internal tool. About 50 people could then run it themselves.

Azure OpenAI plans each query. Plain Python computes every figure over 25 to 30 million rows.

More than 50 checks compare results across Excel, Power BI and Python. If two systems disagree, the run stops. The checks caught 9 mismatches.

run log (illustration: the real tool is internal)
$ run brand-review
plan query, schema-checkedok
compute 25 to 30M rowsok
reconcile Excel vs Pythonok
reconcile across systemsHALTok
> two systems disagree on one figure. run stopped.> all systems agree. report published.
Show a run where the systems

Read the full case study

Quadcore Innovations, Oct 2025 to May 2026

Cutting support tickets on a payments platform

The platform was getting about 100 support tickets.

I mapped the platform with the people who run it and traced about 70% of the tickets to one crash path.

The product lead accepted the fixes I proposed. Tickets dropped to about 40, and resolution time went from 2 to 4 days to 24 hours.

Show tickets

Read the full case study

Independent research, 2026

Testing a forecasting model against prediction markets

My model turns day-ahead temperature forecasts for 7 U.S. cities into probabilities and compares them with Kalshi prices. It has scored 4,433 settled markets.

The first paper backtest returned +7.7%. The calibration check further down is why I did not rely on it.

1,216 of them were contested, where the market itself was unsure.

On those, the market’s Brier score is 0.2114 and mine is 0.3047. Lower is better, so the market wins.

I have not traded real money. My rule needs a better Brier score than the market on 200+ contested markets and a positive paper return. Neither is true yet: paper return is -3.37% on 212 picks.

brier score calculator
market 0.2114my model 0.3047you 0.0900

0 perfect1 always wrong

Your forecast: 70% chance of 60°F or warmer Outcome: Your score: 0.0900

Read the full case study

SQL project, 2026

Finding who pays the bills in an online store

A retail database with 620 orders from January 2024 to June 2025. 189 buyers placed at least one order that was not cancelled or refunded.

I grouped them by how many orders they placed: 36 bought once, 90 came back two or three times, and 63 placed four or more. That last group is a third of buyers.

ecommerce-sql / query 2.4 (excerpt)
CASE
  WHEN order_count = 1 THEN 'One-time buyer'
  WHEN order_count BETWEEN 2 AND 3 THEN 'Repeat buyer'
  ELSE 'Loyal customer (4+)'
END AS segment

They bring in 54.4% of revenue.

Move the line for who counts as loyal. The dots regroup from the real order counts.

segments
segmentbuyersrevenue
One-time19.0%7.5%
Repeat47.6%38.1%
Loyal (4+)33.3%54.4%
4+orders

Read the full case study

About

I study Management Information Systems at the University of Washington Bothell, with minors in Data Analytics and Economics. Major GPA: 3.7, Dean’s List 2024, 2025 and 2026. I graduate in June 2027.

U.S. citizen. I prefer the Pacific Northwest or the Bay Area and will relocate anywhere in the U.S. for the right team.

The best way to reach me is email: tarangjammalamadaka9@gmail.com.

Experience

  1. Fall 2026
    Principal Investigator, NASA L’SPACE NPWEEOur concept was chosen from four pitches and hit every milestone.
  2. 2026 to 2027
    Treasurer, UW Bothell Club CouncilA $200,000+ annual allocation across 95+ organizations.
  3. May to Aug 2026
    AI MarTech Intern, Ignite Program, The Coca-Cola Company
  4. Mar to Aug 2026
    Built and ran SyllabusAI, Independent
  5. Oct 2025 to May 2026
    Operations Improvement Analyst, Quadcore Innovations
  6. Apr 2025 to May 2026
    President, Delta Sigma Pi, Upsilon PsiNamed Collegiate Member of the Year 2026.
  7. 2022 to 2024
    Product Analyst Intern, JMT Worldwide LLCRan 50 user interviews, wrote PRDs and ran UAT.
  8. 2021 to 2022
    IT Business Analyst Intern, JMT Worldwide LLC

Tools

SQL (PostgreSQL, SQL Server), Python (pandas, Streamlit), R, Excel, Power BI and DAX, Tableau, Azure OpenAI, Claude API.

Certifications and awards

  • Microsoft Certified: Power BI Data Analyst
  • Anthropic: AI Fluency
  • Second place, CED Finance Case Competition
  • 14th of 1,983, HackerRank Orchestrate