Building calculation engines, compliance monitoring, licensing requirements, documentation management systems, training systems and more for decades. We thrive on our ability to understand your technical requirements and work them into data structures and programs that speed and simplify the work at hand.
Fluid Coker Time Management System (Visual Basic for Applications / Microsoft Access / Microsoft Excel)
This was a small access database that generated the ability to estimate and schedule downtime for Cokers that would allow for Preventative Maintenance and the timeframes required to fix certain pieces of the coker. (Cokers are crude oil processing rigs capable of extracting petroleum remnants after initial removal of gasoline, diesel, kerosene, etc.) It also estimated the cost that the time would incur on the repairs of being down.
Fluid/Flexi Coker Management System & Delayed Coker Management System (Visual Basic for Applications / Microsoft Access / Microsoft Excel)
Our international, world-wide, energy production and transportation corporate client for this project required an interactive database application capable of managing their "fleet" of cokers. Once developed and deployed around the world, this program enabled production engineers to monitor and recall individual and trend statistics related to specific compound compositions in any location (Fluid/Flexi coker) while being imported into the central database for further analyses and archiving during the oil extraction process.
Phoenix Consultants Group used their unique coding abilities to add special features to this program. One such feature, an auto-field modifying interface, that "allowed" the automatic addition of new fields over time, without "downtime" for reprogramming Any new field was simultaneously auto mapped to an Excel export routine, as well. Phoenix currently estimates several thousand fields are currently in use by this database, linking the complex hierarchical structure necessary to record and track petroleum derivatives and processing results and requirements.
Data replication and distribution, as well as international contact management functionality were also built into this application.
Marine Terminal Management System (Visual Basic / Microsoft Access / Microsoft Excel / SQL Server / Microsoft Outlook)
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.