Thang Tran

Business Data Analyst

Turning messy data into clear decisions with SQL, Python (pandas), and BI (Power BI / Tableau).

About Me

Welcome to my website! I’m Thang Tran, a UMass Lowell graduate with a degree in management information system. I am passionate about turning complex data into clear, actionable insights and making web pages. Through my co-op at Lightforce Orthodontics and multiple analytics projects, I’ve gained hands-on experience with SQL, Python, Power BI and Tableau. I hope we can meet soon!

Get in Touch

Projects

Selected work with outcomes. Ask for code samples or deep-dive writeups.

Sales & Profits Analytics Dashboard

Python • Excel • Power BI

Developed to explore sales, costs and profits across cities, products, managers and purchase types.Includes dynamic filters, map visuals, KPI cards and interactable elements so that stake holders can understand the data, uncover trends and quickly identify profit drivers. Cleaned and prepared raw excel data and used DAX measures to calculate interactive KPIs. This dashboard would essentially allow restaurant managers to monitor real-time performance across different locations, track profitability trends and identify which products were high performing

Interactive (PBIX)Non-Interactive (PDF)

Holiday Impact on Retail Sales

Python • Excel • Power BI • SQL

Enabled managers to monitor $21.7B sales as data across 45 stores, improving visibility into profitiability trends for holiday season. Authored an end to end retail analytics pipeline with SQL Server, Processed and transformed 6,000+ rows with SQL bulk inserts and star schema modeling, type safe SQL in order to designed and deliver a clean interactive Power BI model with multiple pages showing analytics on real world data such as growth rate, total sales over time.

Interactive (PBIX)Non-Interactive (PDF)

Automobile Performance Report

Tableau • Excel

Created two connected dashboards that allow users to track fuel efficiency, horsepower, and brand popularity over time. Drill-down options include origin, cylinders, and model year, as well as dynamic filters, scatterplots, and bar charts. Provides a comprehensive image of how different regions and brands compared in terms of MPG, horsepower, and number of models between the 1970s and 1980s. Shows sale trends, brand breakdowns and model pricing insights alongside using filters to get the cleanest data. (click me!)

Employee Recognition & Rewards System

Microsoft Slides • Microsoft Excel • Lucidchart • Python

Designed and documented a Slack-integrated Employee Recognition & Rewards System (ERRS) to improve morale, engagement and retention. Prepared a full report documentation that includes Gantt and PERT analysis and a break even analysis. Includes user requirements, project scope, communication plans, and project feasibility. Developed data flow diagrams that ex plores all processess to the system. (click me!)

Netflix Data Mining Workflows Project

Rapidminer • Microsoft Excel • Python

Analyzed and cleaned nearly 9000 Netflix shows and movives using the Naives Bayes model to uncover patterns in genre, country of origin and ratings with a accuracy of 99.97%. Tested decision tree, logistic regression models as well, but they did worse than Naive Bayes.Found movies dominate over TV shows; dramas, comedies and documentaries are most common; US, India and UK lead in production.

Healthcare Insurance Cost Analysis

Pandas • Microsoft Excel • Python • Streamlit • GitHub • Plotly

Built a interactive data dashboard to explore how traits influence healthcare insurance charges. Performed data cleaning and exploratory data analysis on real world insurance data using Pandas and Seaborn/Plotly. Implemented multiple filters for users to inreactively explore the data with a streamlit sidebar. Deployed using Streamlit cloud and github for public access. (Click me!)

Experience

Roles where I delivered measurable impact.

Process Engineering Co-op

Lightforce Orthodontics • Wilmington, MA

June 2023 – May 2024

I had a really good time working at Lightforce, I collaborated with the process engineering team and the floor technicians to help improve process and production by 20%. .
Gained alot of experience in time management, cross team collaboration and leadership through the engineers and my supervisor. Was given the oppurtunity to run my own printline of marketing parts for the whole company, printing with low error rates and efficient time
Assisted in python code debugging and quality assurance for gear that the floor technicians used, also assisted the IT team on several occasions with computer or hardware issues

Technician

Randolph Engineering • Randolph, MA

May 2022 – Jun 2022

Performed precision assembly and QA checks on 100+ aviator eyewear units daily, ensuring compliance with manufacturing standards.
Implemented improvements to shipping workflow, reducing errors in rates in product deliveries
Learned alot about company manufacturing processes in how aviators were produced, how their materials were acquired and cost of production

Contact

Want to talk about an opportunity or a project? Reach out! I’m based in the Greater Boston area and open to roles.

Email Me: thangt112511@gmail.com LinkedIn GitHub