Hello, I'm Trang Dao

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

About

Hello! I'm Trang, a Management Information Systems student with experience in accounting, now transitioning to data analytics. Driven by a passion for data, I taught myself Python and am working on projects to improve my technical skills.

Portfolio

  • All
  • SQL
  • Tableau
  • Python

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 housing data correlation

Housing Data SQL Cleaning

All housing data was cleaned in SQL

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 : Expected 2025

San Jose State University

Projects

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

TV Recommendation

Python
  • Developed a Python script to identify and visualize the top 10 TV shows based on ratings
  • Utilized Pandas for data cleaning and preparation, and Matplotlib for data visualization
  • Generated insights on TV show ratings, genres, types, languages, and networks to enhance user recommendations

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

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%

E-commerce Specialist

07/2022 - 08/2022

San Jose, CA

  • Managed inventory for over 1000 products in the warehouse, ensuring synchronization with online inventory systems
  • Addressed and resolved 10-15 customer inquiries daily, enhancing customer satisfaction
  • Organized and tracked over 100 shipments daily, ensuring timely delivery

Contact

Address

San Francisco Bay Area

Email

thutrangtt00@gmail.com