The development team created the logic for the new system using Java and node.js. However, they did not have the necessary infrastructure required to grow and meet new demands for as many as 30,000 import/export container movements and 1,500 daily agency transactions. Also, their scheduled deadline was threatened because no budget for new infrastructure or Oracle licensing had been considered for the 2018 budget.
Transoceanica’s CIO turned to SoftwareONE for an evaluation of cost-effective alternatives. SoftwareONE proposed a three-phase optimized cloud strategy that would move the new platform to Amazon Web Services (AWS). It was a convincing business analysis with estimated cost savings of almost ninety-nine percent over three years when compared to hosting on-premises.
After additional conversations and database optimization analysis, the new SoftwareONE plan proposed migrating the Oracle database to Amazon’s Relational Database Service (RDS) Postgres. The system would be easily scalable and entirely fault tolerant. Using RDS not only reduced database management costs, but it also saved on the licensing expenses. With the serverless system in place, requests would be made 7through API calls which enabled tracking to which warehouse originated the request and how many functions were called so that chargebacks could be efficiently processed at month end.
To assure the most successful and rapid deployment, SoftwareONE held over 80 hours of workshops for Transocianica’s operations and application development teams. SoftwareONE also supported the development team throughout the transformation to Lambda, including migration of their database from Oracle to Postgres. Beyond implementation, the sessions detailed how to re-use portions of the existing authentication backend code to be deployed in Lambda. The workshops also covered architectural best practices, the API Gateway, RDS Postgres, Cloud Watch, and Simple Email Services (SES).