[Data Warehouse Construction] - Utilized DBT and Airflow to establish scheduled data pipelines, integrating various data sources in AWS Redshift. - Ensured data accuracy and consistency, improving data processing efficiency by 50% and accuracy by 30%.

[Royalty Report Manager] - Managed the royalty system, handled report-related tasks, and facilitated cross-departmental communication. - Automated data import into the internal financial system, reducing manual data entry time by over 90%. - Customized various reports to meet specific needs, saving the company 50% in manpower. [Product Launch Process Review and Performance Optimization] - Replaced over five spreadsheets with database integration, increasing data accuracy by 30%. - Optimized workflows to achieve 80% automation, saving 50% in manpower. [Power BI Dashboard Development] - Implemented Page-Level Security, allowing different departments to view customized content within the same dashboard, reducing information communication time by 20%. - Developed an alert feature to notify when the stock of licensed laser tags is low, reducing shipment delay risk by 30% and manual data management time by 50%.

[Su-Hua Corridor Travel Time Prediction Project] - Developed travel time prediction algorithms for various segments using machine learning, optimizing performance by 20% and improving accuracy by 20%. - Planned and implemented ETL data processes, enhancing data integrity by 30%. - Developed automated scheduling programs with execution logs, saving 35% in manual data inspection time. - Utilized GIS tools with Python to provide geographical visualization charts.