- Led a data analytics team in a data-driven risk management platform project for a listed high-tech company and was in charge of data modeling and Qlik Sense dashboard implementation; the team managed to identify exceptional expense from its high-volume employee expense data with an 86% accuracy rate- Led a BI dashboard enhancement project for a listed international pharmaceutical company, included new source of system data and adjusted QlikView dashboard pages to better assist the Finance department in making data-driven budgeting and promotional spending decision- Regularly delivered data science training courses to 550+ staff, including a 3-day Python and machine learning bootcamp course, a 1-day Power Query and Power BI training course, and a 1.5-day SQL training course

- Led a data analytics team in a BI reporting project for a listed international pharmaceutical company, designed, optimized and implemented three sets of highly tailored QlikView dashboards mitigating and monitoring risks from sales and promotion activities by presenting various KPIs in interactive charts and tables- Participated in a dashboard system automation project for a global retailer and consumer conglomerate, designed a continuous risk monitoring solution with SQL, Python and Power BI to assist the Internal Audit department in making informed data-driven sampling results for further inspection work- Participated in an internal audit project for a pharmaceutical R&D and manufacturing company and designed a Tableau dashboard and underlying SQL scripts to visualizes internal audit test results in procure-to-pay business cycle- Led a promotional activities expense audit project for a major global retailer and consumer company and wrote SQL and VBA scripts to test various market promotional schemas resulting a significant decrease in incompliant promotional expense activities across China