ZIXUAN YUAN

Full-Stack Developer / Project Lead

D3 Security Management Inc.

03.2021 - Current

Spearheaded development of the PWA Mobile App by redesigning and rewriting key functionalities using React JS and Ant Design UI Library. Implemented offline support with the service worker, ensured multi-platform compatibility with a single codebase, and boosted business usage by 50%. Technologies Used: React JS, PWA, Service Worker, Indexed DB, Rest API, JWT Authentication
Developed Operations Resource Management System that streamlined the upload, categorization, sharing, and searching of Standard Operating Procedures (SOPs), improving workflow efficiency across business units by 80%. Technologies Used: JavaScript, Kendo UI, jQuery, C#, SQL Server Full-Text Search, Microsoft Office Online Server (Multi-Server Farm).
Developed Real-Time Availability Checking System enhancing operational transparency and resource allocation decisions in real-time, improving daily check-in efficiency by 120%. Technologies Used: JavaScript, Kendo UI, jQuery, C#, SQL Server, SignalR.
Revamped Product Data Grids and Forms to implement row-level and field-level real-time auto-refresh capabilities, achieving a significant 90% reduction in the need for full data refreshes. Technologies Used: JavaScript, Kendo UI, jQuery, C#, SignalR.
Developed Multiple REST API Endpoints to facilitate seamless data retrieval, refreshing, and searching, directly addressing client business needs and enhancing responsiveness, reducing manual work by 60%. Technologies Used: .NET Web API, Python, Flask, Waitress Server, pywin32, SignalR.
Designed and Developed a Token Generation and Authentication Service utilizing JWT for improved security, scope management, and authorization of REST API endpoints, reducing the vulnerability of the rest API by 80% Technologies Used: React JS, Ant Design, Python, Flask.
Spearheaded the Implementation of a Product-Wide Search Functionality that replaced SQL Server Full-Text Search with Elastic Search, resulting in search performance enhancements of 90%. Developed a robust API service for real-time index updates and creation. Technologies Used: React JS, Ant Design, C#, Elastic Search, Logstash.
Created a Database Monitoring Service for multiple client database servers, created a weekly scheduler, and proactively tracked exceptions, deadlocks, long-running queries, resource usage, and index fragmentation, with integrated SMTP and Google Chat notifications for critical alerts, reduced noises by 80%. Technologies Used: SQL Server, Python, Pandas, SMTP, Google Chat API
Performed SQL Server Performance Tuning to optimize query execution times, successfully reducing SQL query durations by 99% through strategic indexing and query optimization techniques. Technologies Used: SQL Server Profiler, Execution Plan, Indexing.
Provided On-Site Support for a client business unit with a consistent load of over 500 real-time users, efficiently diagnosing and resolving critical issues next to business users under an intense production environment, resolved 90% of the active production issues, leading to greater client satisfaction.
Participated in designing and implementing distributed system architectures of core clients, which led to an 80% increase insystem availability. Technologies Used: Azure Cloud, AOAG
Mentored developers and created onboarding documentation on Confluence for environment setup and basic training, resulting in an 80% increase in onboarding efficiency.
Established an Agile workflow from the ground up using Jira and Jira Automation, enhancing capacity planning and overall efficiency by 50%.

Summary

Overview

Work History

Full-Stack Developer / Project Lead

Education

Bachelor of Applied Science - Electrical Engineering

Skills

Languages

Timeline

Full-Stack Developer / Project Lead

Bachelor of Applied Science - Electrical Engineering

Similar Profiles

Huanrong ZhangHuanrong Zhang

Ruiqi WangRuiqi Wang

Abdoulaye DickoAbdoulaye Dicko