Business Web App Dashboard
A responsive dashboard for business operations, reporting, and workflow management designed for clarity and speed.
Full Stack Engineer
4 Months (Q4 2025)
The Challenge
The operations team used three separate legacy systems to track tickets, customer communications, and supply chains. The separation caused data inconsistencies, delays, and performance bottlenecks, with analytical reports taking up to 10 seconds to load.
The Solution
Created a unified single-page application dashboard in Angular, backed by a high-throughput ASP.NET Core Web API. Unified legacy databases into SQL Server with optimal indexing and partitioned tables. Integrated RxJS streams to feed real-time notifications to coordinators.
Impact & Achievements
Reduced average dashboard report loading time from 10 seconds to 800 milliseconds.
Centralized work ticket workflows, saving operational staff roughly 12 hours of manual tracking per week.
Achieved a 95% user satisfaction rate on the intuitive drag-and-drop workflow kanban boards.
Technical Snippet
Here is a look at a key implementation detail from this project:
// ASP.NET Core optimized query retrieving aggregated operational metrics
[HttpGet("metrics/summary")]
public async Task<IActionResult> GetMetricsSummary([FromQuery] DateTime startDate)
{
// Retrieve aggregated numbers using optimized CTEs and query indices
var summary = await _dbContext.Tickets
.Where(t => t.CreatedAt >= startDate)
.GroupBy(t => t.Status)
.Select(g => new StatusMetricDto
{
Status = g.Key.ToString(),
Count = g.Count(),
AverageResolutionTimeMinutes = g.Average(t => t.ResolutionTimeMinutes ?? 0)
})
.ToListAsync();
return Ok(summary);
}