● 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

● 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

● 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

● 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

● 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

● 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

● 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

● 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

● 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

● 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