Data Management Systems for a Coast-to-coast Helicopter Service
Project Type
Data Management Systems for Airlines
Industry
Travel & Hospitality
Tech Stack
ABOUT THE CLIENT
Soar is a coast-to-coast helicopter service in the United States of America. Their goal is to deliver a convenient service for travelers and enthusiasts.
*All names and logos have been changed to respect NDA
OVERVIEW
Soar’s goal was to streamline daily data processes, approvals, supervision, expense tracking, and payroll generation, all within one system to improve overall efficiency. We built an Aviation Management Dashboard that performed all these functions and more.
Total Users
Active Monthly Users
Accessibility Scores
BUSINESS
REQUIREMENT
The client needed a mobile app to simplify daily data input, including work status, flight reports, expenses, and LogBook entries. Key features included digital signatures, report sharing, weekly report access, and data synchronization with image embedding. For admins, an offline-capable web platform was required for data review and approval. The backend had to support a large user base, ensure data integrity, and run without interruptions, with a built-in intercom for customer support.
SOLUTION
Analysis of the goals showed that two solutions would be the best approach. It was divided into two segments: a web application for the admin panel and a mobile application for users. This approach was taken keeping in mind the efficiency of aviation services for both administrators and users.
CHALLENGES
Handling data in poor network conditions threatened operational efficiency and data integrity. We addressed this with robust data restoration and soft delete functionalities to ensure smooth operations.
Simultaneous logins on multiple devices created potential security risks and data inconsistencies, which we addressed by enhancing security protocols and data validation processes.
1
Exporting large volumes of data from flight reports led to system slowdowns, requiring data export and display optimization to prevent crashes and performance issues.
2
Ensuring access control for sensitive data was crucial. We implemented strict measures to secure data while keeping it accessible to authorized users.
3
OUR APPROACH
The project was meticulously structured into various milestones, each dedicated to introducing innovative features, refining existing functionalities, and undergoing thorough QA testing to ensure alignment with business objectives.
The initial milestone prioritized the creation of a fundamental dashboard, enabling administrators to access weekly reports generated by JSReport effortlessly. Subsequent phases encompassed enhancements such as displaying weekly receipts, managing billing and fueling systems for individual flights, reviewing engineer job records, overseeing flight reports, and facilitating the creation and editing of bookings while updating flight information.
Analysis and Tech Stack Selection
We commenced the project by prioritizing both security and performance (as detailed later). Next, we held in-depth discussions with the client to understand their specific needs. The overarching goal was to enhance the efficiency of aviation services for both administrators and users.
Based on these discussions, we meticulously selected the technology stack that would best serve the project's requirements.
For the admin panel, we opted for a robust combination of React with Redux as the core framework, leveraging Redux's state management capabilities.
JSReport was chosen for its ability to generate detailed flight reports. To ensure code maintainability and facilitate cross-platform compatibility, TypeScript was integrated. Material UI provided a seamless component library for a user-friendly interface. Furthermore, Redux Saga was selected for advanced application management, complemented by Redux Form for streamlined form handling.
Web Application Development
The initial phase involved creating a core dashboard, which allowed administrators to easily access JS Report-generated weekly reports. Subsequent phases introduced features like receipt display, billing and fueling management, engineer job reviews, flight report oversight, and booking management with flight updates.
Mobile Application Development
We built a dedicated mobile app to support remote management using Flutter, supported by SQLite. We optimized the sync process by switching to daily sync, improving performance in low-bandwidth areas.
Backend Development
We started with a monolithic architecture using Aqueduct and Postgres, but as the user base expanded, we transitioned to a microservices approach with Nest.JS, TypeORM, and PostgreSQL, enhancing performance. Key features included user registration, AWS S3 image uploads, notifications for data submissions, and endpoints for managing flight reports, bookings, and daily sync. Access controls and a single-device login mechanism were also implemented to improve security and user experience.
Testing and Deployment
Each sprint included comprehensive QA testing to ensure quality and fix bugs before moving forward. After each sprint, user acceptance testing was conducted, and the client provided valuable feedback. This iterative process helped refine the application, ensuring a seamless user experience.
PROJECT RESULTS
Our solution has become the backbone of the client’s operations, handling everything from data input to report approvals and flight management. It has transformed their workflow, turning the platform into a critical tool for operational efficiency and advancing their business objectives.
Total Users
Active Monthly Users
Accessibility Scores
Lets Build Your Travel/Hospitality Idea Together!
Connect with our team for a free discovery session.
LET'S TALK
OTHER CASE STUDIES
Building a Robust SaaS Widget for Exceptional Customer Support
How GeekyAnts redefined customer engagement by developing a widget and an application suite for a SaaS company.
Aviation Management Dashboard For Coast To Coast Helicopters
Helping an Aviation Company manage processes better with AirOps.
Leveraging health date to enhance life of amputees and footballers
We built two IoT solutions for a healthcare device manufactured aimed at helping athletes and amputees live an empowered life.