API Middleware and Data Integration in the Luxury Tourism Sector

Implemented in ongoing

Maintenance and development of an ASP.NET middleware with RESTful APIs for real-time integration between SQL Server databases and on-board/shore systems, along with automated jobs in .NET and Azure Functions for synchronization with the Otalio platform.

The project involves corrective and evolutionary maintenance of a middleware used to connect front-end software to the company’s database through the development and optimization of RESTful APIs in JSON format, built with ASP.NET. The middleware enables real-time data exchange with a Microsoft SQL Server database distributed between on-board and on-shore systems.
In parallel, I am responsible for designing, developing, and maintaining automated integration jobs, implemented via Azure Functions and .NET console applications, which interface directly with Otalio, a management system for the cruise industry. These jobs synchronize the data stored in the internal database with the Otalio platform through API calls. The processed information includes bookings, excursions, discounts, passenger data, and other entities critical to operations.

Benefits

Automation of data synchronization with Otalio
Reduction of API response times
Greater reliability in information flows

Architecture used

ASP
NET (versione .NET 6 e 9)
Microsoft SQL Server 2022
NET 6 e 9
Azure Cloud
3

People

I am a programmer at Widesolutions, hired after earning my diploma as a Full Stack Developer. My experience is mainly focused on creating websites, which is the field I am most passionate about. For web application development, I have worked with various frameworks, including ReactJS and Spring Boot.

Marco Vestini

Problem solving

When I need to implement a new feature or solve issues, before testing the code, I consider different solutions along with their advantages and disadvantages.

Adaptability

I am always open to learning how the technologies used within a project work. In addition to adapting to the application’s structure, I also contribute improvements whenever possible.

Other projects

April 2025 – Ongoing

Benefits

Single point of contact for clients
Standardized communication via SOAP
Secure data access
Monitoring and tracing of requests

January 2025 – June 2025

Benefits

Pre-boarding and on-board bookings managed centrally
Secure and tracked data access
Real-time alignment with external system
Centralized control of the booking flow

January 2025

Benefits

Extract, associate, and transmit data and photos of passengers disembarked the previous day

2022 – Present

Benefits

Monitored applications
Issues resolved in the short term
Emergency management even outside office hours

Intrigued?

Book a call with one of our consultants

If you have to face a similar challenge, or want to explain your problem to us, book a call with one of our consultants: together we’ll find out if we have the right person for you.

Error: Contact form not found.

Career&Education

Grow with us.

Working at widesolutions.it is different: find out about job opportunities at WideSolutions and join us!

Open positions

Programmers and system engineers

Required technical skills

The role requires:

  • knowledge of Python, Pandas and Spark
  • knowledge of MySQL
  • knowledge of Jenkins
  • knowledge of AWS services: Lambda, S3, Cloudwatch, Iam, Glue
  • experience in Testing (Unit Test, Integration and UI test)

Programmers and system engineers

Required technical skills

The role requires:

  • at least 3 years’ previous experience with Talend and ODI
  • experience in analyzing business requirements and translating them into effective technical solutions using Talend
  • experience with Talend in designing and developing complex workflows and using customized components for configuration management
  • Excellent knowledge of relational databases, including SQL query optimization and performance management
  • Excellent knowledge of data flow migration practices