Fan-Yu Liao

- Integrated mathematical model and ETL pipeline into supply chain optimization systems, improving the inventory turnover rate by 30% for worldwide products distribution - Built robust data pipelines using Python and PL/SQL for data warehouses, EDI processes, and reporting tools - Increased data query speed by 70% while transforming Oracle BI Discoverer reports to SQL Server Reporting Services platform - Experienced with Git CI/CD and DevOps tools such as Airflow, Jenkins, and Rancher

- Developed auto-refreshed SharePoint page to track the status of customized-tested wafers using Perl and RESTfulAPI, saving search time by more than 50% - Collected data from the manufacturing execution system and displayed the information in a webpage using python and SQL API, simplifying the business process and reducing the manual setting time by 60%

- Assisted 40 students to learn mathematical programming with the tools of Python, Gurobi, and AMPL - Conducted research about sharing mobility’s process optimization and gained 2.89 million NTD research fund from the National Science and Technology Council

- Thesis: Mathematical Programming Framework for Deployment and Repositioning in Dock-less Electric Scooter Sharing Systems (Grade: A+) - Research Field: Mathematical Programming, Flow Network Planning, Simulation - Overall Grade: GPA: 4.28/4.3, Class Rank 1

Major: Logistics Management