Aviation Industry Scheduling Platform

Client 

Aviation Industry

Technology Partner 

Aumnitech LLC 

Business Challenge 

Commercial pilots manage complex flight rotations across multiple calendar sources—Google, Microsoft, and airline-generated ICS files. These schedules are fragmented, inconsistent, and difficult to normalize into a single, reliable view. 

Aviation Industry needed a secure, scalable foundation for its SkedQ platform that could: 

• Ingest flight schedules from multiple calendar sources 
• Normalize disparate calendar formats into a unified structure 
• Provide pilots with a clear, real-time view of past, current, and upcoming rotations 
• Establish a strong backend architecture for future features like legality checks, pay calculations, and mobile apps 

Aumnitech’s Solution 

Aumnitech partnered with Aviation Industry to design and deliver SkedQ Phase 1, a production-ready web platform built in just 4–6 weeks. 

The engagement focused on building a robust ingestion and normalization engine, secure authentication, and a user-friendly web experience—laying the groundwork for future product expansion. 

Scope & Key Capabilities Delivered 

1. Secure User Authentication & Access Management 

• Email-based user registration with OTP verification 
• Secure login using email/password 
• Google and Microsoft Single Sign-On (SSO) 
• Permission-controlled access to connected calendars 

2. Calendar Ingestion & Normalization Engine 

• OAuth-based Google Calendar integration 
• OAuth-based Microsoft Graph Calendar integration 
• Manual ICS file uploads with validation and deduplication 
• Webhook-driven near real-time updates with manual sync options 
• Normalized event storage in MySQL for consistent downstream processing 

3. Pilot-Focused Web Application 

• Unified dashboard showing all rotations 
• Intelligent grouping: Past, Today, and Upcoming schedules 
• Sorting and filtering for quick navigation 
• Visual indicators for new or modified rotations 
• Quick stats such as last sync time and upcoming routes 

4. Account & Integration Management 

• Connect, disconnect, and manage calendar integrations 
• Enable or disable auto-sync 
• Manual “Sync Now” capability 
• Profile management and password updates 

5. Admin Portal for Operational Oversight 

• User management (activate/deactivate accounts) 
• Visibility into event ingestion sources 
• User activity and event monitoring 
• Foundational tooling for system governance 

Technology Stack 

• Frontend: React, HTML5, CSS3, JavaScript 
• Backend: Python (Flask) 
• Database: MySQL 
• Infrastructure: Cloud-hosted (AWS-ready; Azure/GCP compatible) 

Delivery Model 

• Iterative, milestone-driven delivery 
• Weekly check-ins and progress reviews 
• Clear acceptance criteria tied to functional outcomes 
• Fixed-scope, fixed-price engagement 

Timeline: 

• Week 1: Environment setup, authentication, ingestion design 
• Week 2: Calendar integrations and normalization logic 
• Week 3: Web app, account settings, admin portal 
• Week 4: QA, deployment, client walkthrough, acceptance 

Business Impact 

By the end of Phase 1, Aviation Industry had: 

• A production-ready scheduling platform foundation 
• Reliable ingestion of pilot schedules from multiple sources 
• A normalized data model enabling future analytics and compliance logic 
• A scalable architecture ready for legality evaluation, pay insights, and mobile apps 

Most importantly, SkedQ moved from concept to a deployable, extensible product—accelerating Aviation Industry’s roadmap while reducing technical risk. 

Why Aviation Industry Chose Aumnitech 

• Deep experience building data-intensive, cloud-native platforms
•  Strong understanding of OAuth, calendar APIs, and event normalization
• Ability to deliver fixed-scope projects on aggressive timelines