We are exceptionally proud of the work that we have accomplished for the Oil sector. Our work has enabled the safeguarding of the environment in substantial and long term methods to allow these important industries to minimize accidents and to maximize safety. From the environmental safety checks to the training programs, Phoenix Consultants Group has continually strive to better our world with our programs.
Marine Terminal Management System
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 MS Access 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.
EPA Emissions Clean Air Act Monitoring System (Microsoft Access / Excel / VBA)
By working hand-in-hand with the Phoenix Consultants Group's OSHA Compliance Management application, this project specifically focused on the DEP's Clean Air Act permit application. PCG's database development design accommodated multi-user regulatory compliance databases to facilitate the filing of proper New Jersey DEP and federal DEP applications for this client's Clean Air Act permit.
Tracking thousands of fields from an Excel Spreadsheet and automating calculations to effectively monitor all devices (plant devices that were "online", such as control valves, flow adapters, pressure sensors, etc.,), PCG integrated an "add-on" in Excel called Solver to run "best" and "worst-case" scenarios, Solver focused on changes in real-time flows and pressures and how those changes would affect emission statistics. By performing real-time analytic scenarios, this client could and did develop higher production efficiency while maintaining compliance with the Clean ir Act.
Fluid / Flexi Coker Management System (Microsoft Access / Excel / VBA)
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. [Cokers are crude oil processing rigs capable of extracting petroleum remnants after initial removal of gasoline, diesel, kerosene, etc.] 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.
OSHA Training Monitor System (Microsoft Access / Excel / VBA)
Under constant and consistent OSHA regulation and compliance with the DEP's Clean Air Act, this multinational client required an OSHA training management system designed to document, track, and record proper course verification, attendance by employees, and course completion. Reports of the employee training, updates, and progress was submitted to relevant government offices and organizational supervisory staff. By comparing scheduled mandatory training sessions with tracked attendance records, all employees could be followed via reporting functionality. Any deficiency, or gap in any employee's, or groups of employees training and attendance was immediately "flagged, reported, and appropriately addressed.
In addition, training instructor credentials were investigated, tracked as to their qualifications to teach, continuing education credits, and curriculum management class scheduling. The Phoenix Consultants Group application included mass mailing capability for announcements, scheduling, and sign--off sheets for attendance records.