Brian Kuo Email & Phone Number

Marina Del Rey, Ca, Us

Seattle, Wa, Us

● 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

Corte Madera, Ca, Us

● Completed multiple independent and team projects in collaboration with international teams from diverse industries, including online streaming, retail, gaming, on-demand food delivery, and fin-tech● Developed over 50 data models and custom ETLs for complex reporting projects using SQL, DBT, and cloud-based data warehouses such as Snowflake and Redshift● Managed weekly project schedules and deadlines, effectively coordinating with stakeholders ranging from project managers to executive level leaders● Provided analytical insights for sales strategy planning, supporting internal C-level leadership in driving business growth and profitability● Significantly improved data sourcing pipeline and ensured data quality, resulting in a 50% reduction in downstream reporting tool run time.● Prepared comprehensive technical documentation for data pipelines, facilitating the development of efficient reporting dashboards● Created and delivered more than 40 reports and other business deliverables, addressing specific business questions and client needs, utilizing various BI tools including Tableau, Quicksight, Sigma, Looker, and Amplitude

New York, Ny, Us

● Provided a network balancing tool for CitiBike in NYC with appropriate data analysis on rider's data, docking station data, and weather data; utilized methods such as K-Means clustering, logistic regression, and random forest models to predict network bike status● Performed analysis on Ame's housing market before 2010 and built multi-leaner descriptive machine learning model with Python to provide applicable investment strategies for potential investors in growing neighborhoods; used geopy and Google API for coordinate data collection and feature engineering● Generated insight on bubble tea industry growth trends in top 10 US cities for the past 20 years; utilized web scrapping tool Scrappy in Python and scrapped over 3000 listings on Yelp.com and cleaned data by applying filtering criteria to attained listing dataset● Analyzed six month worth of booking data and generated practical insight for potential Airbnb hosts in the greater Seattle area; constructed an R shiny web app for easy data exploration of over 3000 individual listings in mid 2020

● Supported supply chain design projects by researching pricing insight in transportation, labor, and property cost for optimal facility placement● Established input data for a supply chain optimization software in MS SQL and designed reporting dashboards in Tableau for solution comparison● Validated customer data and determined dataset in scope for a supply chain design project with MS SQL and excel

Atlanta, Ga, Us

● Maintained and improved UPS small package network optimization model in python and SQL● Acted in close liaison with planners to drive optimization solution execution and tracking results● Managed database migration between servers● Peak assignment - managed peak season internal expedited network planning service by communicating with contractors and providing scheduling solutions to facility supervisors across the country

Atlanta, Ga, Us

● Initiated design, development and implementation of comprehensive relational database structure for global freight forwarding networks; consolidating plan schedule, actual schedule, and routing data ● Identified opportunities to increase network efficiencies resulting in annual savings of $120K by maximizing existing routing system capacity● Took charge of in-depth routing compliance tracking mechanism involving over 200K weekly GAD weight in shipments for a major external customer and provided visibility in resulting cost and affected volume for all international UPS stakeholders ● Created impact analysis on executive decisions on routing and carrier change; providing all-inclusive view in cost savings, flight position detail, and flight position utilization with over 2M GAD weight worth of shipments involved annually● Established extensive international air freight flight position and schedule database for the freight forwarding team● Led cross functional working sessions to establish valid international air freight routing plans for various customer groups● Performed ad hoc analysis on air freight networks for internal customers

Atlanta, Ga, Us

● Designed and implemented real time visibility dashboard to locate and track ground freight assets for the UPS ground freight network in North America using Tableau and SQL● Executed end-to-end migration of legacy MS Access ground freight asset management database to MS SQL server reducing system processing time by over 90%● Led cross-functional quarterly demand planning of North American ground freight network, identifying annual cost savings in route scheduling of over $50M

Atlanta, Ga, Us

● Coordinated the operations of outbound small packages at air gateway● Supervised a team of over 40 seasonal workers for daily shifts● Balanced conveyer belt package flow by assessing worker efficiency and optimizing personnel placement

Bonn, De

● Built a pricing analysis tool with SQL to extract data and excel VBA for the company’s logistics operation as part of the BSA team● Initiated transportation network design to reduce operation and transportation cost● Utilized Atlassian Confluence for project documentation

● Completed a project to reorganize the warehouse for one of the largest wholesale distributor of art supplies in the US to enhance their e-commerce growth capabilities● Used SQL to analyze the warehouse skus to establish the basis for heat map construction● Constructed heat map with Microsoft Excel and provided new plans for pick path and reslotting● Conducted pick path simulation with Python indicated a 25% decrease in travel time after reslotting

Taichung, Tw

● Completed project course with a local machine tool production firm● Analyzed the firm’s order history and production process with Microsoft Excel and used theresults to propose new factory layout● Designed plans with lean production methods that could decrease the lead time by 50% or more

Taichung, Tw

● Completed scheduling improvement project for local industrial lifting chain fitting production firm● Developed of a scheduling platform that integrates the Enterprise resource planning (ERP) system,Excel VBA, and Plant Simulation to generate monthly production schedule automatically ● Decreased the scheduling time from hours to about 10 minutes

● Completed multiple manufacturing improvement projects for the world's largest bicycle manufacturer● Implemented lean techniques based on 5S on the assembly line● Redesigned work station according to the risk assessment metrics Key Indicator Method (KIM) ● Improved line balance by analyzing worker’s motion elements with Brief Work Factor (BWF) of multiple products

● Completed introductory level improvement reports for one of the production lines for one of thebiggest aerospace company in Taiwan● Implementation of lean techniques based on 5S principles on the assembly line

● Assisted the heat cycle testing process for products● Inspected returned products and analyzed cause for return● Data entry

Master’S Degree, Supply Chain Engineering

Data Engineering

Data Science Fellow

Bachelor Of Science (Bs), Industrial Engineering And Enterprise Information