Build a source code scanning pipeline with CodeQL on Jenkins for 150+ projects. Build a packages scanning pipeline with Yarn on Jenkins for 30+ projects. Implement cache mechanism to archive 40% performance optimization for Jenkins pipeline.

# Air quality IoT analytics system (2019 - 2023) 1. Led a team in building an IoT device management and data analytics system using microservice architecture with Docker. Achieved 99% SLA and under 10 seconds data query time. 2. Designed and executed a seamless migration plan from MariaDB to PostgreSQL with Timescale extension, addressing a query performance bottleneck caused by 80 million records. 3. Developed a stable and practical analysis platform that facilitated the customer's expansion from 500 devices to 3,500, establishing them as the leading consulting company in Taiwan for Civil IoT initiatives in collaboration with local governments. 4. Integrated ClickHouse to overcome query performance bottlenecks as the data volume reached 3 billion records. 5. Transitioning from an API-based approach to Pub/Sub architecture. This transformation resulted in a 60% reduction in computing costs. 6. Implemented an AI model for PM2.5 data calibration and anomaly detection, enabling governments to accurately identify the sources of pollution. This solution contributed to the organization winning a prestigious "Smart 50 Award." # Digital Lottery System (October 2021 - February 2022) 1. Spearheaded the development of a digital lottery system aimed at revitalizing the economy of Puli post-epidemic. This system garnered an impressive participation of over 6,000 individuals and collaboration with 150+ stores, generating 3.5 million economic activities. # Agriculture Irrigation and Monitoring System (2018 - 2023) 1. Developed a web visualization system using React.js and MongoDB. This approach resulted in an impressive 20% reduction in daily workload. # Air quality real-time monitoring map (2015-2022) 1. Utilized the ASP.NET MVC framework for building a low-cost PM2.5 sensing platform for the Environment Protection Administration Executive Yuan R.O.C. 2. Integrated Google Maps API to display GIS base data, and leveraged Apache EChart to present historical data. 3. Developed a Messenger Bot to provide convenient data querying services.