Reengineering a seaport operation system

Industry:  Logistics
Cargo traffic:  294, 641 tons
Country:  Israel

Project definition and goal

The Port of Eilat addressed TYMIQ for reengineering of their port operation system called OGEN. The system was originally developed using MSSQL with stored procedures, .NET Web forms, and DevExpress components. Ogen 2.0 allowed managing all critical operations: ships arrival, care and departure, import/export of all cargo types including cars, cargo and containers, communication with customs office, shipping agents, managing personnel, etc.

The goal of the project was

to significantly increase the system performance and optimize the current business processes through reengineering of OGEN.
The main reasons for reengineering were:
  • Performance issues associated with large amounts of data. Some forms took 10-20 seconds to open, or even timeout of SQL execution.
  • The applications didn’t work with the modern and widely used browsers.
  • The technology was outdated, so the system required migration to something more modern. Otherwise, it would be difficult to support the system in the future.
  • The need to implement new business requirements.

Global tasks facing the team

Increase
performance and data protection
of the system through reengineering

Ensure smooth and uninterrupted operation of the system during the reengineering process

Keep the
functionality of the previous version
and implement the new one

Integrate the system with different communication services, such as customs office, ship agents, managing personnel, etc.

Provide real
user-friendly Hebrew interface

Our working concepts

Methodology
SCRUM
Teams
1
Team members
6
Project duration
9 months
2021
Ongoing cooperation
Now
Our responsibilities and contribution
  • Architecture modules design

The team took an active part in the decision-making process on architecture solutions.  They proactively responded to the manager’s requests and collectively figured out the best reengineering plan.

  • Planning

Reengineering the functioning system and integrating the old and new functionality required from our team accurate and coherent planning. Every step must be considered from the perspective of uninterrupted operation of the system.

  • Reengineering and deployment

All our engineers on this project brought a senior level of proficiency and could properly maintain smooth operation of the system, even during new releases. They were fully responsible for the preparation of artifacts and their deployment to different environments.

  • Security analysis

TYMIQ’s engineers were always partial to providing the highest level of the system security. They used advanced techniques and tools to ensure protection from any malicious attacks.

  • Maintenance and support of the system

Throughout the project and up to this moment, TYMIQ has been maintaining the system in the actual and secure state.

  • Maintenance of project documentation and technical specifications

The team was fully responsible for maintaining technical specifications within the project.

  • Business analysis and business logic development

TYMIQ played an important role in the development of the customer’s business processes through continuous engagement in the requirement management. Our engineers were aspiring in delivering their ideas for improvements where it was really necessary and where it should bring value to the customer.

IT infrastructure

Code management
  • TFVC
    (Team Foundation Version Control)
CI/CD
  • Azure
  • DevOps
Project management
  • Azure
  • DevOps
Code management
  • GIT
CI/CD
  • Azure
  • GevOps
Project management
  • Azure
  • DevOps

Technology stack

MS SQL

MS SQL

ASP .NET core

ASP.NET Core

React

React

REST api

REST API

MS reporting services

MS reporting
services

Data transformation services

Data transformation
services

Solution

The profound expertise in software reengineering helped TYMIQ fulfill the customer’s request and deliver the modernized version of the port operation system - OGEN 2.0. Throughout the project, our team have been keeping the system available 24/7, despite all the challenges caused by parallel migration and integration processes.

The new system is based on the same database as the previous one and consists of the following components:
  • SQL server with Stored Procedures as database server
  • ASP.NET Core Web API
  • ASP.NET Core Authentication service
  • React Frontend app
  • REST-API application based on ASP.NET Core
  • Web application based on React
  • Authentication, communication, and reporting services

The application architecture is a mix of microservice and monolith approaches. The authorization module is based on the microservice approach and the main application–the monolith approach. The business logic is implemented on the SQL Server side via Stored Procedures. The whole application is built based on .NET Core.

  • Authentication - Makes authentication of each request based on JWT token
  • ASP.NET Web API Controllers - Handle incoming HTTP requests and send responses back. The Web API controllers implement the REST API approach
  • Models - Present an HTTP incoming request as an object
  • Business objects - Contain business entities and their methods
  • Data access layer - Calls SQL Stored Procedures on SQL Server side and returns the result back. It uses the external FndUtils library. This library uses ADO.NET component to communicate with the SQL Server
  • All SQL procedures working with datasets have been enhanced with additional parameters to support server-side pages. As well, we have enhanced C# to be able to get parameters from the grid and send them to the SQL procedures
  • Most complex queries and Stored procedures have been improved with the required indexes, using views and also some refactoring where it is required

The frontend part of the project is represented by the React Web Application. The application uses the following technologies:

  • React as a JavaScript library
  • TypeScript as language
  • Node js as package manager
  • React routing as navigation system
  • i18next for globalization
  • Axios for http requests
  • Telerik Kendo UI as the main UI components library

Why the client selected working with us

Credibility

TYMIQ is a truly reliable partner who works hard and inclusively.

True reengineering proficiency

We know how to correctly upgrade a legacy software and put it back on track in the optimal time. We strive to make this process as painless for the customer as possible.

Focus on value

We deliver lasting value for a reasonable price. Our specialists are always result-oriented, and therefore look for only sustainable and smart solutions fitting best the customer’s needs.

High commitment

TYMIQ has strong dedication to the development of the client’s business, as evidenced by our high responsibility to work.

Open and honest communication

Our team stays in constant contact with the customer and timely arise all critical issues to get their approval for remediation actions.

Client’s feedback

Eilat logo
 “We selected TYMIQ over others for their great culture fit and good value for cost.”

“We selected TYMIQ over others for their great culture fit and good value for cost. They provide a very professional plan with a detailed explanation of how they will resolve all the goals and issues in the existing software that we have provided.
Everything was delivered on time and was quick response for all our needs. We found their professional team and business ethic impressive. “

Gera Bider
Gera Bider
linkedln icon
Application and Security Manager
Review on Clutch

Other projects implemented by TYMIQ

Critical incident management
Swissphone

Development of critical incident management platform

TYMIQ built a modular, highly secure and flexible platform for critical incident alerting. The platform provides cloud, hybrid, and on-premises deployment options and is prepared for a wide range of critical events.

Core tech

Python, PHP, JavaScript, Angular, Swift, Kotlin

Country

Switzerland

IT services
Soxes

Partnering with other IT services providers

A wide range of TYMIQ services does not make us a closed-loop company. Instead, our expertise in various domains allows us to build effective cooperation with other IT companies and together help businesses optimize their legacy software.

Core tech

.NET, PHP, Python

Country

Switzerland

Remote asset monitoring
Prylada

Developing a solution for remote asset monitoring

TYMIQ developed hardware and software products and brought them into a single asset monitoring system. Our dedicated team managed to quickly release the first commercial version of Prylada and helped the client occupy its niche in the market.

Core tech

Java, C, Zephyr, TypeScript (Angular)

Country

Germany

arrow left
arrow right

Have a similar case?  Let’s discuss together

Discuss my case