• Establish and maintain various databases, ETL systems and dashboards, ensure data correctness and integrity. • Deeply involved in product development, provide guidelines for designing data regulations and tracking processes to ensure user data be properly collected. • Study and analyze user behavior data, provide insights, recommendations and feedbacks to product development team to ensure outcome meet company objectives. • Promote data-driven concepts by creating dynamic dashboards for different departments, help understanding collected numbers and trends, also assess key results and performance periodically. • Digitalized and automated repeated reports to minimize labor and human error. • 依需求建置/維護 ETL 資料串流，資料庫與不同類型之 dashboard 並協助各部門檢視關鍵指標 KPI 及趨勢。 • 與技術部門協作規劃數據追蹤及不同場景的數據運用，並保證數據資料庫的完整及正確性。 • 與產品密切協作，研究與分析 App 及用戶行為，並透過數據分析持續提供產品修正或優化的反饋予開發團隊，例：協助文章推薦演算法開發。 • 使用不同管道獲取的技術及統計學概念，探索產品面及商業問題的解答 • 推動各式產品優化相關的 AB Testing，規劃、執行與分析。 • 建置報表與提供數據洞見並呈予公司 stockholders 以協助推動公司成長。

• Improve processes and perform the design, development, and modification of new systems and processes according to business needs and departmental objectives using SQL • Support users of costing applications by analyzing user needs and responding to issues submitted by internal customers. • Analyze SQL database objects to maintain optimum functionality and performance of the databases (run-time of query or database space maintenance) • Document requirements (e.g. business specifications) and coding solutions to ensure the correct implementation of new processes • Coordinate project plans for cost updates, create and provide technical reports for the region office. • Provide insight and impact analysis through BI tools to higher management, helping with proper decision making. • 成本資料庫系統之數據清理、整合、更新並配合商業規劃/報告組重新設計並最佳化通連資料庫。 • 成本模型ETL系統之Stored Procedure/trigger/SQL指令之設計、分析、撰寫、優化及除錯。 • 專案領導，資源人力協調、分配工作、時間管控、系統分析、代碼撰寫。 • 數據分析報告及長短期影響預測報告設計/可視化，提供予管理層做有利決策。 • 編寫內部教學，減少人力調度帶來之負面影響。

• Maintained and Optimized ETL process to create more time-efficiency environment and helped the users solve all related issues caused by the processes. • Created, expanded and maintained interactive consolidated report to help identifying the root causes of irregular changes and pre-answering potential questions to both internal & external customers. • Built new forecasting models based on historical data to provide preliminary analysis and insight after original source became unavailable. • Provide routine reporting and planning processes to fulfill requirements from internal customers. • Automated and connected reporting & forecasting process to save user’s time on each running cycle, reducing the possibility of human error or data inconsistency. • Liaison with different region offices, departments to interpret finding, follow the progress, distribute tasks for multiple projects and periodically report result to higher level management.