Get in Touch

Case Studies

A deep dive into my technical work, ranging from enterprise database migrations to modern full-stack web applications.

Real-Time Communication

Ping: Enterprise Messaging System

Challenge: The organization faced a $100,000/year quote for Slack which offered insufficient data retention (90 days vs 1 year required) and lacked critical government compliance features (FOIA auditing).

Solution: Architected and built a fully on-premise, real-time messaging platform using C# and SignalR backed by SQL Server. It provides instant communication while adhering to strict legal and accessibility standards.

Key Features & Impact:

  • $100k Annual Savings: Eliminated the need for expensive third-party SaaS licensing.
  • Government Compliance: Built-in HR audit portals for FOIA requests and harassment investigations; 1-year data retention policy enforced at the database level.
  • Full Accessibility (ADA): Engineered front-end with high-contrast modes, scalable typography, and reduced motion settings.
  • Departmental Security: Granular RBAC permissions ensure department isolation while permitting secure interdepartmental communication.
Full Stack & Automation

UserForge

Challenge: Manual creation of Active Directory accounts took 30+ minutes per user, was prone to human error, and lacked sufficient logging for security audits.

Solution: Developed a secure web-based application that standardizes and automates the entire lifecycle of user account management for the helpdesk.

Key Features & Impact:

  • 98% Efficiency Gain: Reduced account creation time from 30 minutes to 30 seconds.
  • Security & Accountability: Implemented granular permission controls and comprehensive logging for all actions.
  • Error Reduction: Standardized inputs and automated validation eliminated inconsistency and human error.
Full Stack & Workflow Automation

HR Payroll & Evaluation System

Challenge: HR team spent 2 weeks/month manually calculating step-increases, updating finance records, and generating evaluation letters for managers.

Solution: Built a C# web application integrated with the ERP system via a custom API. It automates eligibility checks, pay adjustments, and document generation.

Impact:

  • Time Savings: Saved approx. 240 man-hours per month (reclaiming 2 weeks for 3 staff).
  • Process Logic: Automated complex 5% step-increase logic based on anniversary dates.
  • Integration: Seamless read/write operations to the Finance Enterprise database.
Database Architecture

Database Instance Migration

Challenge: Identify and consolidate multiple redundant database instances to reduce licensing costs and improve manageability without disrupting critical business operations.

Solution: Executed a phased migration plan involving rigorous compatibility testing, data validation, and a scripted failover process.

Outcome:

  • Reduced server footprint by 30%.
  • Zero data loss during transition.
  • Significantly lowered annual licensing costs.
System Administration

Finance Software Upgrade

Challenge: Upgrade a legacy financial reporting system that was critical for end-of-quarter processing, with a strict maintenance window.

Solution: Collaborated with vendors to patch custom extensions, performed load testing in a staging environment, and orchestrated a weekend cutover execution.

Outcome:

  • Improved report generation speed by 40%.
  • Enhanced security compliance with new encryption standards.
GIS & Spatial Data

GIS System Upgrade

Challenge: Modernize an outdated Geographic Information System (GIS) to support new high-resolution spatial data formats and web-based mapping clients.

Solution: Upgraded the backend spatial database (PostGIS/ESRI), optimized spatial indices, and integrated with new web services.

Outcome:

  • Enabled real-time map rendering for web clients.
  • Supported ingestion of complex 3D spatial data.