//assets.cakeresume.com/assets/contentarea/contentarea-2d64eca8dae2a1ffb31e0fb1df887bbad072c7c19734d7d30fa14884bbcc299a.css

Self-driven, highly motivated and conscientious .NET Developer with a proven track record of success in developing and implementing web-based solutions, maintaining and updating applications, and improving the full system lifecycle. With 4+ years’ experience in areas spanning Database and Application Development, DevOps, and Cloud development, I can be relied upon to deliver everything that I set out to achieve, whilst always seeking ways to help my company grow, and giving customers and clients that smoothest user experience.

Tamkang University

ASP.NET Core 後端工程師 With MCSA BI Development | MCSA SQL Development | MCSE Data | Azure

Trendon Cato

Funday Asia

ASP Net Core Developer

• Spearheaded the creation of Web APIs and a robust back-end Admin Portal for Funday's Online Learning Platform using ASP.Net Core 5/6, Dapper, and SSMS. Adopted a microservices architecture, improving scalability, and facilitated team-wide comprehension through detailed database schema diagrams and comprehensive documentation, enhancing productivity and collaboration.

•	Designing, migrating and developing MS SQL Server Databases

• Database Design and Development: Designed schemas for SQL Server and MongoDB in support of 10+ Web APIs development, while consulting on schemas and queries for another 5 colleagues' projects, which bolstered overall team efficiency.

• Boosted data retrieval by 40% in legacy systems through query optimization and implemented system upgrades that reduced execution time by 60%, enhancing overall database performance by 25% using SQL Profiler and Database Tuning Advisor.

• Evaluate requirements while following through on project deliverables and performance of applications.

• Transitioned application deployments from Windows Server to GCP Compute Linux VMs using Docker, Nginx, and Docker Compose, improving load balancing and caching. Managed Cloud DNS subdomain configurations and implemented SSL certificates, boosting security and performance. Additionally, established CI/CD pipelines with GitLab Runner. 

• Regularly mentoring my team of 6 in the use of Gitlab, Docker, Serilog, Elasticsearch, and MS SQL query optimization techniques, improving overall team capabilities.

• Leveraged Serilog, ElasticSearch, Kibana, Prometheus, and Grafana, enhancing exception tracking and performance monitoring. Identified bottlenecks via K6 load testing, increasing system throughput by 3-4x through strategic code and query optimizations.

•	Implemented an ASP.NET Core 3.1 MVC, N-Tier architectured CRM Web Application with Razor views utilizing Repository and Unit-of-Work patterns, and Dapper for Data Access. In addition to Razor Views with Ajax for the for the Presentation Layer, and identity user, role, and claims management for security. 

•	Built and designed the base architecture for an ASP.NET Core 5.0 N-Tier architectured Web API using Entity Framework Core code first approach and LINQ-to-SQL for Data Access and implementing JWT Token based authentication for security for a VUE based HR Web Application 

•	Built extensive 100% test coverage for all controllers using XUnit Testing and Moq for our ASP.NET Core 5.0 Web API

•	Setup, implemented and managed version control for my team of 6 using both Gitlab and Azure DevOps

•	Communicated with internal teams and stakeholders, working to determine solutions for the user experience

•	Created an ASP.NET Core 3.1 MVC SaaS Reporting Web Application using Razor Views, Ajax, Apache ECharts and Dapper based on 5 million + records 


華延科技有限公司

 Back End Developer ( ASP.NET Core 後端工程師)

An education services organization that offers over 40 courses in various subjects for both children and adults with 40+ employees that spans four branches.

Spearheaded the creation of several SQL Server database systems in collaboration with managers of different departments, in addition to providing ad-hoc queries on request.

• Design database systems based on requirements: Collaborated with managers to analyze the prior Excel based database to formulate proper business rules, and logic, in order to create an improved, fully normalized SQL Database. ER diagrams were further used to create tables and foreign keys relations.

• Creating Views/Stored Procedures/Triggers: Stored procedures and Triggers used in concert with C# Winforms to provide data entry capabilities to the interface used by Front Desk Staff.

• Utilizing CTEs, Pivots, Merges, Dynamic SQL: CTEs, Pivots, Merges and Dynamic SQL facilitated the display of information for more complex queries and requests that were required by different departments • Migrating SQL Instances: Migration from initial SQL SERVER 2017 to 2014 Express and MDFs from versions 869 to 782, and SqlLocalDB from v14 to v12 in order to install on Windows 7 machine.

Trendon Cato’s posts