Gaming, tennis, snowboarding, surfing
BRIAN KUO
Seattle,WA
Summary
Results-driven senior BI developer with extensive experience in ETL development, data modeling, and business intelligence reporting. Skilled in designing scalable data pipelines, optimizing SQL queries, and building executive-level dashboards. Demonstrates strong expertise in SQL, Tableau, AWS QuickSight, Snowflake, Redshift, DBT, Airflow, and cloud-based data warehouses.
Overview
9
9
years of professional experience
Work History
Senior Analytics Engineer
Dollar Shave Club
06.2024 - Current
- Developed executive-level Tableau dashboards to provide actionable insights on key business metrics.
- Designed dbt models and ELT pipelines, improving reporting efficiency among teams.
- Automated data ingestion from S3 to Redshift using Airflow, reducing manual effort and improving pipeline reliability.
- Partnered with marketing, supply chain, loyalty, customer service, and e-commerce teams to develop targeted analytics solutions.
- Managed Tableau server content as site admin, overseeing 100+ dashboards and data sources.
Business Analyst III (Contract With Genesis 10)
AMAZON
10.2023 - 05.2024
- Developed and enhanced Tableau and AWS Quicksight reports to track cost and demand metrics during peak periods, collaborating with various teams to meet reporting requirements
- Provided in-depth business and financial analysis to optimize logistics network carrier services' utilization
- Automated ETL pipelines with Python from local to cloud (S3) for improved demand forecasting using AWS SDK
- Managed cross-functional projects, defined performance metrics with stakeholders, and delivered impactful reporting solutions to support strategic business objectives, including developing demand forecasting models using Scikit-Learn for logistics network demand
Analytics Engineer | Sr. Consultant
MAMMOTH GROWTH
05.2021 - 03.2023
- Completed 5+ projects across gaming, e-commerce, online streaming, and fintech industries in collaboration with global teams
- Developed 50+ data models and custom ETLs using SQL, DBT, Airflow, Snowflake, and Redshift
- Managed cross-team projects, coordinated with stakeholders, and provided analytical insights for sales strategy planning, resulting in improved data quality and reduced reporting tool run time
- Prepared technical documentation for data pipelines and delivered 50+ reports using BI tools like Tableau, Quicksight, Sigma, Looker, and Amplitude
Senior Consultant
CHAINALYTICS
03.2020 - 10.2021
- Supported supply chain design projects by researching pricing insights in transportation, labor, and property costs for potential facility placement
- Built data models in MS SQL for supply chain optimization software and designed reporting dashboards in Tableau for solution comparison
- Implemented K-Means clustering for customer location grouping in optimization models and audited customer data for supply chain design projects using MS SQL and Excel
Data Science Fellow
NYC DATA SCIENCE ACADEMY
09.2020 - 01.2021
- Developed a network balancing tool for CitiBike in NYC using K-Means clustering, logistic regression, and random forest models with rider, docking station, and weather data
- Conducted analysis on Ame's housing market and built a descriptive machine learning model in Python to offer investment strategies for growing neighborhoods, leveraging geopy and Google API for data collection and feature engineering
- Generated insights on bubble tea industry growth trends in the top 10 US cities by web scraping Yelp.com using Python and processed over 3000 listings, and analyzed booking data for potential Airbnb hosts in the greater Seattle area using R
Planning Services Senior Analyst
UPS
09.2016 - 02.2020
- Maintained and improved UPS small package network optimization model using Python and SQL, with ad hoc reporting in Tableau /Power BI
- Managed database migration between servers and executed end-to-end migration of a legacy MS Access ground freight asset management database to MS SQL server, reducing processing time by over 90%
- Designed and implemented a real-time visibility dashboard to locate and track ground freight assets for the UPS ground freight network in North America, using Tableau and SQL
Education
Professional Certificate - Data Engineering
MIT XPro
01.2023
Master of Science - Supply Chain Engineering
Georgia Institute of Technology
01.2016
Bachelor of Science - Industrial Engineering
Tunghai University
01.2014
Skills
- DATA ANALYTICS TOOLS: Python (Pandas, Sklearn, SciPy), Tableau, Quicksight, Amplitude, Sigma, Looker, Power BI
- DATABASE TOOLS: SQL (Snowflake, Amazon Athena, MS SQL Server, Oracle), MS Access, DBT, Data Grip, MySQL, Docker, Airflow, PySpark, S3
- BUSINESS APPLICATIONS: MS Excel VBA, MS Excel Solver, MS Office Suite, MS Visio, iWork Office Suite, Atlassian Jira, Assana, Github, DigiWin ERP System
- LANGUAGES: Mandarin Chinese (Native Speaker), English (Native Speaker)
Interests
Timeline
Senior Analytics Engineer
Dollar Shave Club
06.2024 - Current
Business Analyst III (Contract With Genesis 10)
AMAZON
10.2023 - 05.2024
Analytics Engineer | Sr. Consultant
MAMMOTH GROWTH
05.2021 - 03.2023
Data Science Fellow
NYC DATA SCIENCE ACADEMY
09.2020 - 01.2021
Senior Consultant
CHAINALYTICS
03.2020 - 10.2021
Planning Services Senior Analyst
UPS
09.2016 - 02.2020
Bachelor of Science - Industrial Engineering
Tunghai University
Professional Certificate - Data Engineering
MIT XPro
Master of Science - Supply Chain Engineering
Georgia Institute of Technology
Similar Profiles
Flavic MassambaFlavic Massamba
Warehouse Assistant at Dollar Shave ClubWarehouse Assistant at Dollar Shave Club
AJAY DAVULURIAJAY DAVULURI
Supply Chain Analyst at Dollar Shave ClubSupply Chain Analyst at Dollar Shave Club
Holly StoneHolly Stone
Quality Lead, Member Engagement at Dollar Shave ClubQuality Lead, Member Engagement at Dollar Shave Club
Michael BradfordMichael Bradford
Delivery Courier at Uber EatsDelivery Courier at Uber Eats
Becks DeVriesBecks DeVries
Senior Social Strategist - Jordan | @jumpman23 at KinessoSenior Social Strategist - Jordan | @jumpman23 at Kinesso