gjimtsai

# 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 an impressive 99% availability rate and significantly improved data query time to under 10 seconds.

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. This achievement played a pivotal role in their remarkable growth and recognition.

4. Successfully integrated ClickHouse to overcome query performance bottlenecks as the data volume reached 3 billion records. This optimization significantly improved data retrieval speed and scalability, ensuring efficient data analysis for the system.

5. Led the refactoring of the microservice architecture, transitioning from an API-based approach to Pub/Sub. This transformation resulted in a remarkable 60% reduction in computing costs while providing increased flexibility for seamless integration with new projects.

6. Implemented an AI model for PM2.5 data calibration and anomaly detection, enabling governments to accurately identify the sources of pollution. This groundbreaking solution not only empowered decision-making processes but also 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 a substantial economic impact of 3.5 million economic activities.

# Agriculture Irrigation and Monitoring System (2017 - 2023)

1. Developed a web visualization system using React.js and MongoDB, seamlessly integrating it with an edge control system developed by professor Day. This innovative approach resulted in an impressive 20% reduction in farmers' daily workload, significantly improving their efficiency and productivity.

# Air quality real-time monitoring map

1. developed a low-cost PM2.5 sensing platform for the Environment Protection Administration Executive Yuan R.O.C.

2. Utilized the ASP.NET MVC framework for building a robust and intuitive data visualization web application, ensuring efficient data processing and seamless integration.

3. Integrated Google Maps API to display GIS base data, providing users with a comprehensive and interactive map interface.

3. Leveraged Apache EChart to present historical data, enabling users to analyze trends and patterns effectively.

4. Developed a Messenger Bot to provide convenient data querying services, enhancing accessibility and user engagement.