Reengineering a seaport operation system
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
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
- 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
- TFVC
(Team Foundation Version Control)
- Azure
- DevOps
- Azure
- DevOps
Technology stack

MS SQL

ASP.NET Core

React

REST API

MS reporting
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.
- 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
“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. “