楊維禎
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 數據資料分析師 • 數果網路有限公司
- Establish and maintain various databases, ETL systems and dashboards, ensure data correctness and integrity.
- Deeply involved in product development cycle, designing tracking methods, data structure, regulations and metrics to ensure needed data can be properly collected and interpreted.
- Analyze user behavior data and market trends, to provide insights and recommendations to the product development team, ensure outcome meets company objectives.
- Promote data-driven concepts across different departments, help understanding collected data, trends for better decision making, also assess key results and performance periodically.
- Digitalized and automated dataflow from source to end reports, including multiple BI tools and dashboards, to minimize labor and time-wasting.
- 依需求建置/維護 ETL 資料串流，資料庫與不同類型之 dashboard 並協助各部門檢視關鍵指標 KPI 及趨勢。
- 與產品密切協作，研究與分析 App 及用戶行為，並透過數據分析持續提供產品修正或優化的反饋予開發團隊。
- 推動各式產品優化相關的 AB Testing，規劃、執行與分析。
- 與技術部門協作規劃數據追蹤及不同場景的數據運用，並保證數據資料庫的完整及正確性。
- 建置報表與提供數據洞見並呈予公司 stockholders 以協助推動公司成長。
May 2020 - Now
FP&A Sr. Data Analyst 資深數據分析師 • United Parcel Service (UPS), USA
- Improved 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 the ETL process to create a more time-efficient environment and helped the users solve all related issues caused by the processes.
• Created, expanded and maintained an interactive consolidated report to help identify the root causes of irregular changes and pre-answer potential questions to both internal & external customers.
• Built new forecasting models based on historical data to provide preliminary analysis and insight after the original source became unavailable.
• Provide routine reporting and planning processes to fulfill all requirements of 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 findings, follow the progress, distribute tasks for multiple projects and periodically report results 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
