Case Studies/ATC — Air Traffic Controller
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.
Challenges & solutions
What we inherited, and exactly how each constraint was resolved.
- Challenge
Intricate client-module configuration plus redundant database structures made the system hard to manage.
SolutionWe introduced a V2 module structure, reduced database redundancy, and shipped a friendlier UI for simpler operations.
- Challenge
Managing changes in service rates and keeping accurate rate history for predictive invoicing was difficult.
SolutionWe used Hangfire jobs to auto-update per-user rates and added logging so admins can monitor rate changes over time.
- Challenge
Transitioning from CoreUI to DevExtreme UI risked breaking functionality and aesthetics.
SolutionWe analyzed DevExtreme, prioritized critical components, and migrated iteratively with testing — improving UX without losing functionality.
- Challenge
LINQ-based analytics across many tables degraded performance and slowed page loads.
SolutionWe restructured LINQ into optimized SQL and added caching to cut database load and speed up query execution.
Key features
Email integration
Connects Mailgun so users receive emails inside the dashboard, with detailed logs for opens, IPs, and click-through rates.
Client dashboard analytics
Detailed invoice and feedback statistics help clients track finances and make informed decisions.
Document creation
Zoho Writer integration for template design, PDF/Docx export, email merge, e-signing, and postal mail via SendGrid.
Resource management
Assign and adjust hours by project and availability, track time per member, and reallocate to hit timelines.
Leaves management
Handle leave requests from admins or employees, with analytics into leave trends and usage patterns.
Zoho Books integration
Auto-syncs data with Zoho Books to track billable hours, oversee projects, and generate precise invoices.
Results
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.
Technology Stack
Frontend
HTML5
CSS3
Vue.jsCoreUIDevExtreme UIBackend
ASP.NET Core
DockerHangfireEntity FrameworkDatabase
PostgreSQL
RedisVersion control
Azure DevOpsIntegrations
ZohoProject management
TrelloMicrosoft TeamsReady to build the next success story?
Partner with a studio that ships production systems — and stays accountable after launch.