Klient - JOB AIR Technic

Expanding the capabilities of the internal system

The company JOB AIR Technic a.s. is a member of the industrial group CZECHOSLOVAK GROUP and its CSG Aerospace division, specializing in aviation services, specifically aircraft maintenance and repair. It possesses one of the largest aircraft maintenance hangars in Central and Eastern Europe, featuring a modern facility equipped for the maintenance of 2 wide-body or 8 narrow-body aircraft. The company is engaged in a wide range of activities related to technical aircraft maintenance, from routine inspections and service checks to complex repairs and modifications. JOB AIR Technic a.s. primarily focuses on the maintenance of large commercial aircraft, such as the Airbus A320 or Boeing B737, including all of their production variants.

 

Home

When the existing system needs improvement

The company JOB AIR Technic a.s. utilizes the Quantum Control information system, a complex ERP system designed specifically for the aviation industry and the MRO sector. This system covers various operations ranging from supply chain management to maintenance planning and financial management. The architecture and licensing scheme of IS Quantum correspond to the era of its creation, and features such as data access for third parties, mobile device support, remote login, and other operations considered standard nowadays cannot be added without a fundamental and costly modernization.

Following the aircraft's arrival and problem diagnosis, a need for additional unplanned repairs often arises, which requires approval of the time requirements for the repairs while simultaneously securing the necessary material. All of this demands direct communication with the customer. Due to the aforementioned limitations of the IS, data sharing relied on exchanging Excel spreadsheets and reports via email, which was a time-consuming process for the responsible staff in administrative departments.

The process of approving maintenance-related costs was inefficient and slow, carrying a risk of error. Mutual communication prolonged the ordering process for necessary spare parts. It was challenging for the sales department staff to obtain complete documentation to send out the final billing.

 

 

The objective was to enable real-time access to the order status for both internal and external users. To provide the sales department with access to the necessary documents, thereby speeding up the billing process of the entire order.

Solution Proposal

Our solution consisted of developing a PWA-based (Progressive Web App) application that enables clients of JOB AIR Technic a.s. to track and approve individual repairs on aircraft or aircraft components online. The synchronization of on-premise databases with the cloud system is a key component of the application, which we developed in the Oracle Cloud. To build the application, we utilized the IS Quantum database operating on the Oracle platform.

Final State

The result is a new supplementary system that, without the need for complex and costly IS modernization, enables the tracking of individual costs associated with repairing defects identified during scheduled aircraft maintenance.
The application we created has streamlined the approval process and enabled the sales department to communicate directly with the customer regarding additional work.

Advantages of the developed application:

  • The application provides real-time access to data, which significantly improves client satisfaction with the progress of the service order.
  • Clients have better financial control and a clear overview of the entire repair process.
  • The application allows clients to track costs associated with individual repairs and includes a communication platform for easy approval and handling of inquiries.
  • Synchronization of the on-premise database with the cloud system has increased data security – in the event of a local infrastructure failure, clients can quickly resume operations and minimize potential data loss.
  • The application is available as a Progressive Web App (PWA), meaning clients have full access directly within the browser without the need for downloads, with the capability to operate both online and offline.
Dodané služby: 

Penetration test

Penetration tests will give you information about vulnerabilities, errors in configurations and codes used in applications. As specialists in Oracle Application Express technology, we know the typical problems when writing applications and running applications in this framework. To verify the security of your applications and system, we will use the OWASP methodology, which describes the basic vulnerabilities of web applications.

Perex: 

We provide clients with information about vulnerabilities, errors in configurations and codes used in applications.

Logo: 

Application development

Are you bothered by high administrative costs? Can't keep up? Is your error rate increasing? In that case, it is high time to deploy a web or mobile application. We will help you with the assignment and instead of endless analyzes, we will soon show you the first prototype of your new application.

Perex: 

We create modern and secure applications for various devices and platforms to help you be more efficient.

Logo: 

Applications support

We will be happy to look after the applications developed by us. The extent and intensity is up to the client. We adjust the service level according to needs. If you've inherited older Oracle Apex applications, we can handle that too.

Perex: 

We provide clients with all the benefits of support, which is not only effective for companies, but also financially advantageous.

Logo: 

Hosting

If you need hosting for your new application, we are ready. We will prepare all standard services such as as regular backups, database monitoring, JasperServer for dynamic messages, and FTP access according to your needs.

Perex: 

We will take care of the continuous operation of your applications. We will ensure a comprehensive range of functioning of your applications.

Logo: 

IT colsultation

Are you deciding on a long-term IT strategy for your company? Do you need analysis and assistance in preparing an assignment for a new comprehensive system? Or do you just want an independent consultation? Do not hesitate to contact us. We are happy to help and share our experience from dozens of different projects for international corporations and smaller local startups.

Perex: 

Thanks to our many years of experience, we will help you identify shortcomings and propose an optimal solution.

Logo: 

Oracle Cloud

An elegant and secure solution for your application is Oracle Cloud. You will be surprised by the conditions and possibilities that Oracle has ready in its cloud solutions. With us, you get a cloud tailored to your company.

Perex: 

The solution for those who require higher performance, lower costs and easy migration to the cloud.

Logo: 

Školenie

Ako funguje ORACLE APEX? Ako vytvoriť svoje prvé aplikácie? To všetko sa naučíte počas našich školení, kde vám na praktických úlohach ukážeme, ako funguje vývojové prostredie ORACLE APEX. Získate základne vedomosti o architektúre, nástrojoch a postupne sa naučíte vytvárať svoje vlastné aplikácie.

Perex: 

Získate základné vedomosti o architektúre, nástrojoch a postupne sa naučíte vytvárať svoje vlastné aplikácie.

Logo: 

System integration

Do you use several unconnected applications and systems simultaneously? CRM, ERP, accounting system, internet banking and a few of your own applications. Viewing data is becoming an increasing problem and the development of any system costs considerable resources. The fastest and most efficient solution is an application that connects all systems.

Perex: 

We will combine your existing software solutions, such as Pohoda, SAP, ERP, or Internet Banking into one application.

Logo: 

CZ_Job Air Technic

Rád bych vyjádřil velkou spokojenost s IT společností APEX Solution, která pro společnost Jobair Technic vyvíjí řešení na míru zaměřené na zjednodušení fakturace a zlepšení komunikace se zákazníky. Spolupráce s APEX Solution je výjimečná díky vysoké míře kooperace. Vývojáři nejenže plní zadané úkoly, ale aktivně přinášejí inovativní nápady a myšlenky do celého vývojového procesu. Tento proaktivní přístup vede k efektivní diskusi, šetří čas a eliminuje nedorozumění. APEX Solution vyniká odborností, profesionalitou a flexibilitou. Jejich schopnost přizpůsobit se našim specifickým požadavkům a poskytovat cenné konzultační služby výrazně zlepšila naše interní procesy. Doporučujeme APEX Solution každé společnosti, která hledá spolehlivého a inovativního partnera pro vývoj IT řešení na míru.
Jan Krystyn, Continuing Airworthiness Manager