//assets.cakeresume.com/assets/contentarea/contentarea-2d64eca8dae2a1ffb31e0fb1df887bbad072c7c19734d7d30fa14884bbcc299a.css

Analytical and detail oriented IT professional with strong experience in Business and Data Analysis, ETL Development and Data Modeling, Data Integration. Determined and able to solve real-world problems, manage and perform critical business process analysis with a core understanding of organizational issues, while recommending process enhancing measures to increase productivity and maximize profits. Globally-focused professional fluent in English and Chinese.  

佛羅里達大學

Data Analyst

楊維禎

數果網路有限公司 - Popdaily

數據資料分析師

•	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指令之設計、分析、撰寫、優化及除錯。
• 專案領導，資源人力協調、分配工作、時間管控、系統分析、代碼撰寫。
• 數據分析報告及長短期影響預測報告設計/可視化，提供予管理層做有利決策。
• 編寫內部教學，減少人力調度帶來之負面影響。

United Parcel Service (UPS), USA

FP&A Sr Data Analyst 資深數據分析師

• 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.

Share