許博淳 Email & Phone Number

台灣 臺北市

Construction and Management of Data Pipelines1. Routinely retrieved and updated data from external platforms via APIs, incorporating retry mechanisms and ensuring data accuracy.2. Maintained data quality by investigating anomalies during updates and effectively resolving false alarms.3. Integrated cloud and on-premise pipelines to ensure data users consistently access accurate information.Cloud Migration of Data Pipelines1. Successfully transitioned the on-premises pipeline to Azure Synapse Analytics and restructured it to eliminate unnecessary dependencies.2. Refactored the on-premises stored procedure for migration, achieving a 6-10x increase in execution speed.3. Implemented a daily data validation mechanism to identify and record any

台灣 臺北市

ELT1. Executed a daily data pipeline using Airflow as the primary tool for data updates.2. Automated data retrieval from Google Cloud Storage to Google BigQuery, with progress updates seamlessly pushed to Slack.3. Actively developed 40 Data Marts by harmonizing common requirements, achieving a 90% reduction in query-related costsCross-Functional Team work1. Worked closely with the product team to design user journey maps, pinpointing key factors in teacher user churn. Enhanced the user interface, leading to a 30% surge in deep engagement among teachers.2. Developed publicly available statistical data, allowing donors to easily grasp user demographics and usage trends, thereby stabilizing donation inflows

碩士, Computer/Information Technology Administration And Management

學士, 運輸與物流管理系