ChiaChi Hsu

• Designed and standardized metrics frameworks across business lines, including a Spot Trading KPI taxonomy and OKR calculation methodology, enabling consistent performance measurement across cross-functional teams.

• Built and maintained operational dashboards using SQL and BI tools to monitor trading volume, margin utilization, campaign conversion, and other key business KPIs, supporting data-driven decision-making across operation teams.

• Developed an internal Data AI Agent trained on proprietary metric definitions, enabling business stakeholders to retrieve KPI definitions and surface relevant dashboards via natural language queries, scaling data accessibility across non-technical teams.

• Automated weekly reporting pipelines to consolidate cross-team performance data, reducing manual reporting overhead and accelerating stakeholder review cycles.

• Collaborated with marketing and product teams to define key KPIs for short video and built a real-time monitoring system to help senior management quickly assess market response during major promotional events.

• Built an ETL pipeline integrating multiple advertising and transaction databases, syncing real-time results to a Google Sheets dashboard, enabling the business team to track hourly coupon usage and flexibly adjust voucher strategies, resulting in a 15% improvement in marketing ROI.

• Built and maintained real-time dashboards in Google Sheets and Tableau, integrating multi-dimensional data including order volume, driver online rates, and weather conditions to help management quickly monitor supply-demand balance.

-Developed a campaign performance prediction model based on historical data, enabling the business team to discuss ROI with merchant partners using quantitative data, successfully increasing merchant trust and engagement — driving a 15% growth in campaign participation and directly contributing to revenue growth.