Case Studies/ATC — Air Traffic Controller
An internal management tool for project handling and HR — a centralized hub for invoicing, email, messaging, and real-time updates via SignalR.
Unified
HR, invoicing & real-time ops
Client requirement
The client needed their internal management tool restructured — simpler client modules over a cleaner database, automated service-rate and invoice handling, a modern DevExtreme UI, and SQL-optimized analytics for fast dashboards.
What we inherited, and exactly how each constraint was resolved.
Intricate client-module configuration plus redundant database structures made the system hard to manage.
We introduced a V2 module structure, reduced database redundancy, and shipped a friendlier UI for simpler operations.
Managing changes in service rates and keeping accurate rate history for predictive invoicing was difficult.
We used Hangfire jobs to auto-update per-user rates and added logging so admins can monitor rate changes over time.
Transitioning from CoreUI to DevExtreme UI risked breaking functionality and aesthetics.
We analyzed DevExtreme, prioritized critical components, and migrated iteratively with testing — improving UX without losing functionality.
LINQ-based analytics across many tables degraded performance and slowed page loads.
We restructured LINQ into optimized SQL and added caching to cut database load and speed up query execution.
Connects Mailgun so users receive emails inside the dashboard, with detailed logs for opens, IPs, and click-through rates.
Detailed invoice and feedback statistics help clients track finances and make informed decisions.
Zoho Writer integration for template design, PDF/Docx export, email merge, e-signing, and postal mail via SendGrid.
Assign and adjust hours by project and availability, track time per member, and reallocate to hit timelines.
Handle leave requests from admins or employees, with analytics into leave trends and usage patterns.
Auto-syncs data with Zoho Books to track billable hours, oversee projects, and generate precise invoices.
Streamlined module structure and optimized database improved system efficiency.
Automated rate management and email integration smoothed overall workflow.
A revamped UI and dashboard analytics gave a more intuitive, informative experience.
Streamlined leave management reduced administrative burden for HR.
Resource management improvements drove higher efficiency and productivity.
Robust allocation, tracking, analytics, and financial insight lifted project performance.
Frontend
HTML5
CSS3
Vue.jsCoreUIDevExtreme UIBackend
ASP.NET Core
DockerHangfireEntity FrameworkDatabase
PostgreSQL
RedisVersion control
Azure DevOpsIntegrations
ZohoProject management
TrelloMicrosoft TeamsPartner with a studio that ships production systems — and stays accountable after launch.