graspcorn
graspcorn graspcorn

Jet Sync App Project Details

Home Portfolio Jet Sync App (by FlyIQ)

Information

  • Project:Jet Sync App (by FlyIQ)
  • Environment:Visual Studio 2022, SQL server 2019, Entity Framework
  • Technology:Asp .net using C#, MVC Core 6.0, Restful API, selenium
  • Domain:Education
  • Duration:July 2024 - Jan 2025
  • Team Size:2
graspcorn

Introduction of JetSync Admin Panel (Development)

The JetSync Admin Panel was developed as part of the FlyIQ platform to streamline and centralize the management of private flight requests and operator participation. While the JetSync module allowed clients to submit flight needs, the Admin Panel was designed to provide administrators and super admins with the tools to efficiently manage those needs, onboard operators, and synchronize data from external aviation platforms. The system supports real-time monitoring of flight demand (“NEED” data), user management, subscription tracking, and smart data comparison between client requirements and operator availability. It also includes advanced integration with external sources like NBAA and FlyInsight, along with OpenAI’s API to process and format unstructured aviation data for better readability and decision-making. This admin interface plays a vital role in the FlyIQ ecosystem, bridging client requests with operator schedules through automation, data intelligence, and secure backend architecture.

Problem Statement

JetSync required a powerful backend system to manage flight requests (“NEED” data), onboard operators, and sync data from external aviation sources. However, there were key challenges:
bullet point

No centralized place for administrators to monitor or manage user-submitted flight needs.

bullet point

Operators needed a secure and structured way to join and manage their availability.

bullet point

External data from sources like NBAA and FlyInsight came in raw, unformatted structures, making it difficult to process.

bullet point

Comparing client needs with operator availability was manual and error-prone.

bullet point

Sensitive calendar URLs and user data needed protection through encryption.

Affected Areas

The problems identified affected several areas:
bullet point

Data Management: Flight request (NEED) data was coming from both internal forms and external APIs with inconsistent formats.

bullet point

Admin Workflow: Admins had no efficient tools for reviewing and comparing flight needs vs. operator calendars.

bullet point

User Onboarding: New operator sign-ups and credential generation lacked structure.

bullet point

Security: Security

bullet point

Data Formatting: Scraped data from NBAA via Selenium was unstructured and unreadable in its raw form.

Solution

To address these issues, the following solutions were implemented:
bullet point

Built a robust admin panel to display all flight needs and manage user data.

bullet point

Developed a super admin module with full control over users, needs, and platform settings.

bullet point

Integrated FlyInsight calendar to track operator availability.

bullet point

Pulled flight request data from NBAA and displayed it alongside internal submissions.

bullet point

Built a comparison engine to match client-submitted flight needs with available operator calendars.

bullet point

Secured external calendar URLs using data encryption techniques.

bullet point

Used OpenAI API to process and clean raw scraped data from NBAA for better readability and accurate admin review.

How We Implemented

The solution was implemented using the following approach:
bullet point

Website & Platform Integration: Connected JetSync with the FlyIQ website and enabled user subscriptions.

bullet point

Admin Panel: Created dashboards showing flight needs, operator details, and subscription statuses. Allowed user onboarding by generating login credentials.

bullet point

Super Admin Module: Added capabilities to view all system data, override records, and manage other admins.

bullet point

Calendar Integration: Pulled availability data from FlyInsight calendar into the admin dashboard. Stored and updated it regularly in the backend.

bullet point

NEED Data Handling: Pulled client needs from FlyIQ and external needs from NBAA via Selenium.

bullet point

OpenAI Integration: Processed unstructured NBAA data using OpenAI’s API. Converted it into structured formats like: Departure: KMIA, Arrival: KJFK, Pax: 3.

bullet point

Data Comparison Engine: Compared client needs with operator calendars and flagged matches/conflicts.

bullet point

Security: Encrypted FlyInsight URLs and applied form validation throughout.

Outcome

A fully functional admin panel was delivered, providing real-time access to flight requests and operator availability, allowing for efficient management of operations. The addition of Super Admin capabilities enhanced system-wide control and oversight, ensuring smooth governance across all modules. Flight requests submitted through internal forms and sourced externally were accurately displayed and easily compared, streamlining decision-making. Integration with the OpenAI API reduced the need for manual data formatting, accelerating the review process and minimizing the risk of human error. Platform security was strengthened through data encryption and secure calendar access, ensuring user data remained protected. Overall, the JetSync system significantly boosted operational efficiency for administrators managing private aviation requests.

graspcorn graspcorn

Unlock Your Business Potential
with Our Expert Solutions

Partner with GraspCorn for innovative solutions that elevate your digital presence.
Our expert team is dedicated to delivering exceptional results tailored to your business needs.