Wayne Lin Email & Phone Number

● High frequency transaction game systemUsed: C#, SQL Server, Jenkins, Redis cache/message, ASP.NET MVC, LINQ, Kibana, GitDatabase optimization and design 1. Solve deadlock/blocking issues by extended events 2. Using Query Store to find out the poor execution plans and missing index 3. Implemented T-SQL job scheduling by using SQL Server Agent to perform daily maintenance 4. Database monitor(extended event/DMO/Query store) Refactor exist code 1… Show more ● High frequency transaction game systemUsed: C#, SQL Server, Jenkins, Redis cache/message, ASP.NET MVC, LINQ, Kibana, GitDatabase optimization and design 1. Solve deadlock/blocking issues by extended events 2. Using Query Store to find out the poor execution plans and missing index 3. Implemented T-SQL job scheduling by using SQL Server Agent to perform daily maintenance 4. Database monitor(extended event/DMO/Query store) Refactor exist code 1. Preloading data to cache(redis/memory) for shorting response from 5 seconds to less than 1 second 2. Improve code reusability and reduce redundant code 3. Optimization program architecture, reduce 60% hardcode CI/CD 1. CI/CD build up and menagement with jenkins2. Enhanced and maintained CI/CD workflow with Jenkins 3. Upgrade and optimize Jenkins with groovy scripts to reduce 70% build and release time 4. Instant notification with Skype bot for alert and routine tasks Application development 1. Collaborative development and design the architecture of multi-level membership 2. Troubleshooting on production/urgent issues for 24/7 high transaction system 3. Implemented Kibana Watcher for monitoring production health and exception Show less

Project● Investment Management System (Across more than 10 departments)● Ticket Transaction Management System● Capital requirement and risk management system● Investment risk control system● Option commodity system● Risk control systemUsed: C#、ASP.NET MVC、LINQ、SQL Server、SVN1. Led 4-6 engineers members to collaboratly develop project 2. Code review for C# 3. Gather requirements, provide analysis and estimates for requested projects4… Show more Project● Investment Management System (Across more than 10 departments)● Ticket Transaction Management System● Capital requirement and risk management system● Investment risk control system● Option commodity system● Risk control systemUsed: C#、ASP.NET MVC、LINQ、SQL Server、SVN1. Led 4-6 engineers members to collaboratly develop project 2. Code review for C# 3. Gather requirements, provide analysis and estimates for requested projects4. Performance optimization ● SQL Server performance tuning ● Refactored application code ● Used cache to reduce the count of DB connections5. Designed and refactor format transform foundation and process from CSV to DB6. Used design pattern and OOP to develop history architecture7. Troubleshooting on production/urgent issues for 24/7 high transaction system Show less