楊維禎

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 數據資料分析師  •  數果網路有限公司

• 依需求建置/維護 ETL 資料串流,資料庫與不同類型之 dashboard 並協助各部門檢視關鍵指標 KPI 及趨勢。
• 與產品密切協作,研究與分析 App 及用戶行為,並透過數據分析持續提供產品修正或優化的反饋予開發團隊。
• 推動各式產品優化相關的 AB Testing,規劃、執行與分析。
• 與技術部門協作規劃數據追蹤及不同場景的數據運用,並保證數據資料庫的完整及正確性。
• 建置報表與提供數據洞見並呈予公司 stockholders 以協助推動公司成長。

May 2020 - Now

FP&A Sr Data Analyst 資深數據分析師  •  United Parcel Service (UPS), USA

• 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

Reporting Systems Specialist  •  United Parcel Service (UPS), USA

• 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

學歷

Aug 2014 - May 2016

University of Florida, USA

Information Systems and Operations Management

Sep 2007 - Jun 2010

國立高雄大學

應用物理學系

Powered by CakeResumePowered by CakeResume