January 2024 - Present
Taichung City, Taiwan

Senior Data Analyst

RHINOSHIELD

• Managed the royalty report system, automating the generation of over 30 reports each month and integrating them into the company's financial system. 
• Facilitated cross-department communication between licensing and finance, led royalty report-related projects, and planned program and process enhancements.
• Implemented scheduled data pipelines with DBT and Airflow, integrating various data sources into AWS Redshift and increasing data processing efficiency by 70%.
• Developed a sales forecasting dashboard for product SKU levels at the factory end, leveraging Power BI and machine learning techniques.

June 2020 - December 2023
Taichung City, Taiwan

Data Analyst

RHINOSHIELD

• Established the royalty report system from scratch, decreasing the manpower required for manual monthly report calculations by 50%.
• Facilitated the optimization of the product data management process, ensuring consistency and accuracy, and enhancing efficiency by 80%.
• Implemented Power BI Page-Level Security feature, leading to a 20% reduction in cross-departmental communication costs.
• Implemented a Power BI notification feature, reducing the risk of licensed sticker stock shortages by 50%.