Helping local council, state government & government organisations & predict the future cities.

- Designed a coordination mechanism to prevent deadlock conflicts during service auto-scaling. Implemented a monitoring system, alert system, and dashboard to enhance reliability and maintainability, leading to a 30% reduction in IT support working time.- Implemented SDKs such as Redlock, MongoDB, and Google Analytics 4, enhancing internal development efficiency and code reusability.- Utilised bulk/batch operations, Common Table Expressions (CTEs), partitioning, and indexing to refactor… Show more - Designed a coordination mechanism to prevent deadlock conflicts during service auto-scaling. Implemented a monitoring system, alert system, and dashboard to enhance reliability and maintainability, leading to a 30% reduction in IT support working time.- Implemented SDKs such as Redlock, MongoDB, and Google Analytics 4, enhancing internal development efficiency and code reusability.- Utilised bulk/batch operations, Common Table Expressions (CTEs), partitioning, and indexing to refactor and tune the PL/SQL procedure, resulting in a performance improvement of over 300%.- Built the mTLS protocol, certificate cache factory, and monitoring system, resulting in a 30% reduction in IT support workload.- Transitioned from a monolithic design to a microservices architecture using .NET 6 and MediatR to implement a RESTful API based on the Mediator design pattern. Show less

- Constructed an automated integration testing pipeline using GitLab CI/CD, Cypress, Docker, and Shell Script to enhance system reliability and streamline QA efforts by about 750%.- Built ReCAPTCHA features that enable IT Support to activate it within our SAAS platform. Included site key validation, retry mechanism, caching, and circuit breaker feature, resulting in a 15% reduction in fees and enhanced reliability when using Google reCAPTCHA.- Integrated OAuth, Bloom filter, Redis, and… Show more - Constructed an automated integration testing pipeline using GitLab CI/CD, Cypress, Docker, and Shell Script to enhance system reliability and streamline QA efforts by about 750%.- Built ReCAPTCHA features that enable IT Support to activate it within our SAAS platform. Included site key validation, retry mechanism, caching, and circuit breaker feature, resulting in a 15% reduction in fees and enhanced reliability when using Google reCAPTCHA.- Integrated OAuth, Bloom filter, Redis, and CDN to build the coupon distribution system, leading to a 20% increase in member account bindings via OAuth.- Optimized LINQ and T-SQL procedures by optimizing queries, designing appropriate indexing, using temporary tables, and implementing data housekeeping strategies.- Employed skills in Angular.js, JavaScript, and TypeScript to develop features for the SAAS platform. Provided users with a CMS interface for quick analysis, marketing, and designing official websites. Show less

- Constructed a data pipeline using C# Console, SSIS, PowerShell, and Python, capable of processing millions of raw data per hour. Built data warehousing to provide valuable data for other data analysts, resulting in a 30% improvement in their working time.- Served as a company tutor for various information skills, including Power BI, Python, C#, and MSSQL.- Developed an Excel report generator offering various analysis modes for generating Excel reports, resulting in a 200% reduction in… Show more - Constructed a data pipeline using C# Console, SSIS, PowerShell, and Python, capable of processing millions of raw data per hour. Built data warehousing to provide valuable data for other data analysts, resulting in a 30% improvement in their working time.- Served as a company tutor for various information skills, including Power BI, Python, C#, and MSSQL.- Developed an Excel report generator offering various analysis modes for generating Excel reports, resulting in a 200% reduction in workload time for non-technical coworkers.- Led to implement a train loading analysis module, increasing the train digestion rate by 15%.- Launched multiple data analysis modules for implementation across websites, desktop applications, and Power BI. These modules facilitated efficiency enhancements for the Operating Control Center in monitoring train operations and equipment availability. Show less