Tommy Nguyen

Experience

Employment History

Showtile

Sales Operations Analyst

Tiles, Stone & Pavers - Sydney, NSW

Dec 2023 - Present

Manage sales data and invoice reconciliation across MYOB and Xero for 200+ accounts.

Track 15+ international procurement pipelines - handle supplier quotes, delivery schedules, and cut mismatches by 30%.

Redesigned and automated CRM data entry processes. Cut duplicate records and made pipeline reports reliable.

Run showroom marketing through Canva, Google Ads, and Google Analytics - grew foot traffic by 20%.

HTT Flooring

Account Manager

B2B Flooring Wholesale - Sydney, NSW

Jul 2022 - Dec 2023

Sourced leads and built KPI frameworks across BCI Central, EstimateOne, and Monday.com for a $1M+ B2B portfolio.

Administered and automated CRM data across 3 platforms for 300+ B2B accounts with 98% data accuracy.

Conducted territory analysis across 4 markets. Found 35% of revenue came from one region, shifted focus and grew the overall portfolio by 15%.

Built reporting workflows across sales, warehouse, and logistics - eliminated 3 manual handoffs, cut response time by 40%.

Royal Crystal Group

Sales Rep & Business Development

International B2B - Remote from Australia

May 2020 - Jul 2022

Produced competitor intelligence across 20+ flooring brands. Findings fed a pricing review that lifted margins by 12%.

Managed cross-border operations across 2 time zones - maintained 95% on-time delivery rate.

Led Sydney Build trade event activation - managed $15K budget, generated 50+ leads, secured 2x budget next year.

Spire Property Group

Key Account Manager

Property - Sydney, NSW (Concurrent)

Dec 2020 - Mar 2023

Generated weekly pipeline dashboards for 8 key accounts ($2M+) - preserved $350K revenue through early risk detection.

Delivered quarterly performance presentations to the C-suite. Analysis influenced $500K+ in quarterly resource allocation decisions made by leadership.

Kept CRM records at 99% accuracy across 100+ accounts.

Portfolio

Projects

SQL

Retail Business Analysis

T-SQL · CTEs · Window Functions · Dynamic PIVOT

Question: At which discount tier does each product category shift from profit to loss?

Key results: Discounts above 50% produce losses across all categories. Technology is the top profit driver for Consumer and Corporate segments even though it is not always the top revenue category.

View Report Source Code Dataset

SQL

AU Building Approvals

T-SQL · LAG() · Conditional Aggregation · Seasonal PIVOT

Question: Which states are gaining construction market share, and which are declining?

Key results: Victoria leads with 31% of national approvals vs NSW at 28%. NSW has fallen 41% from its 2016 peak. Only Tasmania and South Australia grew between 2015-2019 and 2020-2024.

View Report Source Code Dataset

SQL

AU Building Activity

T-SQL · Starts-to-Completions Ratio · PIVOT · Rolling Averages

Question: Is Australia's construction pipeline building backlog or clearing it?

Key results: Starts-to-completions ratio spiked to 1.34 in 2021 (COVID pipeline jam). National pipeline peaked at 244,100 dwellings in Q3 2022. Victoria overtook NSW as the largest construction market.

View Report Source Code Dataset

SQL

US Construction Spending

T-SQL · LAG() · Peak-to-Trough Analysis · PIVOT · Rolling Averages

Question: How did the GFC and COVID compare in terms of construction spending impact and recovery speed?

Key results: GFC: total spending fell 37%, residential fell 64%, took a decade to recover. COVID: only a 2.8% dip followed by the fastest growth in the dataset at +14.9% in 2022.

View Report Source Code Dataset

Python

Customer Sentiment Analysis

Python · VADER · TextBlob · NLP · pandas · matplotlib

Question: Does what customers write in a review match the star rating they give?

Key results: VADER sentiment correlates 0.681 with star ratings. Quality and durability is the #1 complaint (41% of negative reviews). 3.9% of reviews show text-star mismatches. iFit has a 43% negative review rate.

View Report Source Code Dataset

Python

Housing Feature Impact

Python · pandas · matplotlib · Statistical Comparison

Question: Which building materials and finishes have the biggest dollar impact on sale price?

Key results: Stone masonry veneer adds $102K vs no veneer. Kitchen upgrade from Average to Excellent adds $80K+. Poured concrete foundation is $43K above cinder block.

View Report Source Code Dataset

Python

Home Furnishings Market

Python · pandas · seaborn · matplotlib · Market Analysis

Question: How concentrated is the Amazon home improvement marketplace, and does Prime status drive better outcomes?

Key results: Top 10 sellers hold 15.8% of listings. Prime products rate 4.06 vs 4.18 for non-Prime. Discounts above 50% generate 35% more reviews.

View Report Source Code

Python

US Construction Spending

Python · pandas · matplotlib · seaborn · Time Series

Question: Which sectors drove construction growth, and how did private vs public spending behave through economic cycles?

Key results: Manufacturing and healthcare were the standout growth sectors. Private spending is far more volatile than public through downturns. Residential led the GFC collapse and the post-COVID bounce.

View Report Source Code Dataset

Power BI

Pizza Retail Dashboard

Power BI · DAX · Excel · Interactive Dashboard

Question: When do customers order, what do they order, and which products drive the most revenue?

Key results: Friday is the highest revenue day. Classic category leads in both order count and revenue. Peak hours are 12-1pm and 5-7pm. Thanksgiving (27 Nov) was the single highest revenue day of the year.

View Report Source Code Dataset

Employment History

Projects

Education

Certifications