Projects / Lab
Technical experiments, tools, and engineering topics I have worked on or researched.
Access Control System Modernization
Modernized a legacy access-control system integrating Hikvision biometric readers, RFID cards, and gated-community management with a .NET backend and SQL Server database.
Problem: A legacy VB6/COM-based access-control system needed to support modern hardware, SSL/TLS, real-time event processing, and a web-based management interface.
Technologies: C#, .NET, ASP.NET Core, SQL Server, Hikvision SDK, RFID, REST APIs
Completed
AI-Assisted Legacy Code Analysis Toolkit
A structured methodology and supporting scripts for analyzing large legacy .NET codebases using AI tools to identify dead code, security issues, and migration risks.
Problem: Large legacy codebases with millions of lines of code are impractical to review manually. AI tools can accelerate analysis but need structured prompts and verification workflows.
Technologies: C#, .NET, Python, Claude API, OpenCode, static analysis, Roslyn
In Progress
SQL Server Performance Diagnostic Toolkit
A collection of T-SQL scripts, PowerShell automation, and documentation for diagnosing and resolving SQL Server performance issues in production environments.
Problem: Production DBA and development teams need fast, reliable diagnostic queries and a structured approach to identify performance root causes under pressure.
Technologies: T-SQL, SQL Server, PowerShell, Performance Monitor, Query Store
In Progress
Static Tech Radar Generator
A custom static site generator that builds a personal technology news digest and portfolio site from structured content files, inspired by the ThoughtWorks Technology Radar.
Problem: Personal developer websites usually require heavy CMS platforms or frameworks. A lightweight, content-driven static generator is easier to maintain and deploy.
Technologies: Node.js, JavaScript, HTML, CSS, Markdown, JSON
Completed
Windows Server and IIS Hardening Checklist
A comprehensive hardening checklist for Windows Server and IIS deployments based on CIS benchmarks, Microsoft security baselines, and real-world production experience.
Problem: Production servers are often deployed with default configurations that leave security gaps. A repeatable, auditable hardening checklist is needed for each new deployment.
Technologies: Windows Server, IIS, PowerShell, TLS/SSL, Group Policy, Security Baselines
Completed