Hello, I'm Trang Dao

I'm a Senior at SJSU. I can be your

About

Hello! I'm Trang, a Management Information Systems student with hands-on experience as a Growth Data Analyst at a start-up, looking for next entry level/new grad opportunities in data.

Portfolio

  • All
  • SQL
  • Tableau
  • Python

Public Transit Performance End-to-End Pipeline

Builds and deploys an end-to-end ETL pipeline to ingest, process, and analyze public transit data in New York (MTA) and San Francisco (BART).

Data Exploration of COVID dataset

Explore percentage of people got affected, number of cases over the world,and estimation of new cases

Movie Data Correlation

Clean and analyze movie data correlation

Bank Statement Processing

Comebine multiple bank statement and analyze spending trend using Python

TV Shows Data Analysis

Identify and visualize top movies based on rating, gernes,types, languages, and network

Download Resume

Resume

Download

Education

B.S: Business Administration,

Management Information System : December 2025

San Jose State University

Projects

Transit Performance Pipeline

Python, SQLite
  • Developed a complete ETL pipeline using Python to automatically ingest real-time and static data from multiple transit APIs (MTA, BART), loading it into a structured SQLite data warehouse
  • Engineered a data transformation layer with Pandas to join and clean disparate datasets, producing key performance indicators (KPIs) such as average route delay for analysis
  • Ensured data reliability by building a validation process that identified a critical trip_id inconsistency in the source data, a key step that prevented inaccurate performance analysis.

COVID Data Analysis Dashboard

SQL, Tableau
  • Developed an interactive Tableau dashboard to analyze and visualize COVID-19 data
  • Utilized data visualization techniques to present key metrics such as infection rates, recoveries, and fatalities

Statement Analyzer

Python
  • Developed a Python script to automate the monthly review of transaction histories from multiple bank statements (Chase, Amex, Citi, BoA)
  • Generated data visualizations from the exported CSV file, following a Google Sheets template

Experience

Growth Data Analyst Intern

02/2025 - 05/2025

San Francisco, CA

  • Centralized multi-source data from GA4, Google Search Console, App Store, and Play Store by building automated API pipelines, improving data consolidation efficiency
  • Developed a real-time Looker Studio dashboard connected to BigQuery views, enabling the team to monitor acquisition, engagement, and retention metrics, and supporting data-driven strategy to improve user retention
  • Built custom analytics tools for growth team to track user behavior by landing page and source, enabling deeper insights into campaign and funnel performance

Account Receivable Assistant

09/2022 - 06/2023

San Jose, CA

  • Analyzed payment trends for over 500 customers using Excel to identify patterns and implement effective follow-up strategies, resulting in a significant reduction in overdue accounts
  • Processed over 1000 transactions monthly into the database system with 100% accuracy, ensuring timely and accurate financial records
  • Managed and reconciled customer accounts for over 500 customers monthly, reducing delinquency rates by 90%

Contact

Address

San Francisco Bay Area

Email

thutrangtt00@gmail.com