Ethan Hsia

Logistics Cost & Operations Analyst @ GOFO

About

Data-driven professional with a Master’s in Business Analytics, specializing in data engineering, business analysis, and data analytics. Proficient in Python, SQL, Azure Databricks, R, SAS, and tools like Power BI and Tableau. Experienced in building ETL pipelines, optimizing data processes, and applying machine learning models to enhance business decision-making. Proven ability to drive insights, improve operational efficiency, and support data-driven strategies. Seeking full-time roles, I bring expertise in managing large datasets, automating reporting, and delivering results independently and within teams to solve complex business challenges. Feel free to reach me at: weichung.hsia@gmail.com

Country

United States

City

Dallas-Fort Worth Metroplex

Industry

Information Technology & Services

Skill

Supply Chain Management, Extract, Transform, Load (ETL), Pipelines, Microsoft Azure, Snowflake Cloud, Natural Language Processing (NLP), MLP, Deep Learning, SQL, GIS Modeling, Tableau, Microsoft Power BI, Dashboards, Business Intelligence (BI), Data Modeling, Machine Learning, Data Mining, Business Analytics, Python (Programming Language), Comprehensive Planning

Experience

Logistics Cost & Operations Analyst

GOFO

2025-8 - Present · 1 yr 2 mos

Lewisville, Texas, United States

• Built and maintained labor and logistics cost analysis frameworks for pickup and last-mile delivery operations by integrating data across sorting, pickup, label-switching, and driver activities to optimize operational decision-making. • Developed Excel-based labor efficiency and cost performance models to track pickup volumes, driver allocation, and KPIs, identifying time- and process-related bottlenecks to support continuous optimization for high-volume operations (5M+ parcels). • Translated execution-level pickup and last-mile operational data into scalable process recommendations and SOP enhancements, supporting consistent pickup execution and solution rollout across stations. • Collaborated cross-functionally with operations, logistics, finance, and system teams to gather field feedback, validate solution feasibility, and drive ongoing process improvements and requirement implementation

Data Analyst Intern

和雲行動服務股份有限公司

2024-6 - 2024-8 · 3 mos

Taipei, Taipei City, Taiwan

• Optimized vehicle operations using advanced analytics, saving $77K and improving by 3x parking site decisions. • Engineered ETL pipeline in Spark SQL with Python-based EDA for OLAP reporting, reducing operational costs by 20%. • Designed Snowflake Schema to standardize unstructured data, enabling scalable analytics processing in Azure Databricks. • Implemented LightGBM model on 2.5M records achieving 84% accuracy in violation prediction, applying SMOTE and PCA techniques that reduced violation rates by 24%.

Business Intelligence Intern

PRESTIGE VISION CO., LIMITED

2023-6 - 2023-8 · 3 mos

Yung-ho, Taiwan

• Optimized supply chain using Oracle SQL and Excel advanced modeling (Solver, VBA), boosting profitability by 28%. • Conducted A/B testing and applied NLP techniques (NLTK, VADER) to analyze customer sentiment, increasing sales 45%. • Developed predictive models for inventory optimization using time series analysis and statistical forecasting. • Created automated reporting dashboards tracking KPIs for executive decision-making, improving data visibility by 35%.

Data Analytics Event Assistant

La fête

2020-9 - 2023-8 · 3 yrs

Da'an District, Taipei City, Taiwan

• Built customer segmentation model using clustering algorithms and predictive analytics, increasing conversion rates 25%. • Implemented automated data pipeline in R to process customer feedback from MS Outlook, improving VIP retention 15%. • Designed interactive dashboards visualizing event performance metrics, enabling monitoring of customer engagement. • Developed churn prediction model using logistic regression that identified at-risk customers with 78% accuracy.