State K-12 Accountability system: Update and maintain the ETL pipeline throughAzure DevOps development, collaborating with other developers using Git. Systematically utilize Python OOP and communicate with SQL Server via DDL/DML to ensure smooth operation of the system/database functionality.
Aspect-based Opinion Mining: Utilized BerTopic topic modeling with OpenAI API representation on School Report Cards Comments. Employed prompt engineering, fine-tuning, and RAG capabilities of a pre-trained LLM, incorporating department data source for sentiment analysis.
AOI Research: Optimization on full academic year's intstrutional time for Arizona Online Instruction. Employed experimental design techniques, including Statistical tests and Bayesian optimization by data skills by T-SQL , Plotly and Reveal.JS.
Data Analyst/Scientist - ECommerce
Voltour Electric Bike
Phoenix, AZ
08.2020 - 08.2023
Competitor Analysis Application: Marketing End-to-end MLOps solution for competitor analysis, featuring web scraping by Selenium, advanced Machine learning modeling, and interactive visualization using Streamlit.
Advertising KPI Visualization: Develop Power BI app and automation pipeline to optimize PPC campaigns on Google AdWords. Analyzed keyword bidding, campaign duration, dwell time, and identified competitive brands.
Color Trend Analysis: Used Mask-RCNN for image detection and segmentation, followed by K-means clustering algorithm with Silhouette Method for partitioning e-Bike images into color groups.
Industrial Engineer With Data Expertise
GoWISE USA
Phoenix, AZ
04.2018 - Current
Demand Forecasting: ETL pipeline from QuickBooks ODBC for creating a timeline dataset. Applied Croston's method, ARIMA, and LSTM Time series models to accurately predict future demand patterns for B2B direct import and domestic sales.
Direct Import Optimization: Established a standardized operating procedure (SOP) for analyzing container allocation data, considering demand, shipping costs, and delivery schedules. Customized optimization models, including Mixed integer programming, to optimize freight container distribution.
Research Assistant
ASU School Of Computing Augmented Intelligence
Tempe, AZ
08.2019 - 08.2020
State K-12 Accountability system: Update and maintain the ETL pipeline throughAzure DevOps development, collaborating with other developers using Git. Systematically utilize Python OOP and communicate with SQL Server via DDL/DML to ensure smooth operation of the system/database functionality.
Aspect-based Opinion Mining: Utilized BerTopic topic modeling with OpenAI API representation on School Report Cards Comments. Employed prompt engineering, fine-tuning, and RAG capabilities of a pre-trained LLM, incorporating department data source for sentiment analysis.
AOI Research: Optimization on full academic year's intstrutional time for Arizona Online Instruction. Employed experimental design techniques, including Statistical tests and Bayesian optimization,and Time series Analysis.
Education
Executive Master of Business Administration - IT
Ottawa University
Surprise, AZ
08.2022
Master of Science in Industrial Engineering, - Industrial Engineering
Arizona State University
Tempe, AZ
12.2017
Bachelor of Science - Industrial Engineering
National Chiao Tung University
Taiwan
06.2013
Skills
Software Development Methodology and Tools: Azure DeVops, CI/CD, Git, Linux
Data Collection: Selenium, AWS Sagemaker Ground Truth, OpenAI Gym Custom Environment, QODBC, QBO API
Database: Snowflake, SQL Server, MySQL, MongoDB
Data Engineering (ETL) and Data Analytics:SQL, Spark, Pandas/Numpy/Polars, Matplotlib/Plotly/Seaborn, Tableau, PowerBI,Streamlit, Excel VBA,