Return to Our Portfolio










Project:     Marine Terminal Management System
Industry:      Engineering
Programming Language:      Visual Basic, ASP
Database:      Microsoft SQL Server/Access/Excel/Outlook
Application Type:      Data Collection and Statistical Management
Operating Systems:      Windows 98/2000
Project Description
Phoenix Consultants created and implemented their corporate-wide Marine Terminal Database System 2000 (MTDBA) for a previous client returning for advanced management and logistical help with their fleet of shipping tankers and freighters. By using an innovative incorporation of Visual Basic, MS Access, SQL Server, and ASP, we provided augmented ability to track and report objective risk assessment criteria, assisting with safety efforts and liability reduction within its shipping venues throughout the world.

Further into development, Phoenix developed a modularized Marine Terminal Survey Tracking and Implementation System (MTSTIS), using Access 97 to track and report onload/offload activity at this client's international oil shipping terminals.

Creating the international LAN-based network allowing 35 users simultaneous access to several customized Access databases located throughout the organization(s) was accomplished with the development of a straightforward and logical GUI, always considering its international application and usage. The GUI was customized to meet various national/international standards, while still accomplishing encoded calculation, weighting, and statistical analysis capability for the base application.

Continued enhancements and modifications were requested and performed during May 99-Jun 99.

The extensive database was driven by a 30 page MSAcess questionnaire, where our applications evaluated known values against input data, analyzing and projecting by weighted scales, which physical sites were at risk for an oil spill. Worldwide data transmission was accomplished with a VB program attached to a SQL Server email module to transfer data results and projected risk throughout the world. Users could update data through an Excel spreadsheet transmitted over the facilitator and imported at the end terminal; an Access database, also sent and imported; or using the web interface to directly modify their data. The application was also designed to accommodate time differences between users, and scheduled data-sending to different off-site facilitators for analyses of risk assessment.

Functionality also enabled users to retrieve unscheduled data from a single site if situations warranted an off-schedule or emergency level evaluation and inspection. Facilitators could verify the correctness of the data received, input their comments and concerns, and offer assessments to determine corrective actions. Transmitted recommendations were evaluated to ensure that all the facilities were operating up to speed. This program has been operational worldwide for 3 years. PCG wrote the original program, and performed serial enhancements until this client upgraded and requested a full rewrite of the application to bring it up to Enterprise level application.

Still operational, the MTDBA and MTSTIS systems are currently monitoring every oil shipping port in the world, to ensure oil spill factors are mitigated prior to their becoming a catastrophic problem.