Industry:   Engineering      Language:   Visual Basic for Applications       Database:   Microsoft Access/Excel     Application Type:   Data Collection and Statistical Management 

 Project Decription:  

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 "down time" 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.


Project Components: 

  • Business Requirements
  • Project Plan
  • Functional Requirements
  • Technical Specification
  • Scope Analysis
  • Design Model
  • Data Conversion
  • Implementation
  • Integration Testing
  • Training
  • Help System