• 依需求建置/維護 ETL 資料串流，資料庫與不同類型之 dashboard 並協助各部門檢視關鍵指標 KPI 及趨勢。
• 與產品密切協作，研究與分析 App 及用戶行為，並透過數據分析持續提供產品修正或優化的反饋予開發團隊。
• 推動各式產品優化相關的 AB Testing，規劃、執行與分析。
• 建置報表與提供數據洞見並呈予公司 stockholders 以協助推動公司成長。
May 2020 - Now
• 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指令之設計、分析、撰寫、優化及除錯。
Jul 2018 - Mar 2020
• 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
Jun 2017 - Jul 2018