This project tracks fuel as it moved through the delivery system and is divided into 2 main parts. The first is a Linux server responsible for receiving transactions from the automated remote locations. The transactions are captured and stored in a MySQL database where the second part of the project is able to manipulate the records. The technologies used in this project part included MySQL, and C/C++, GDB, Perforce, TCP/IP, and IPCs.
Data Point Manager
A system called Data Points was already in place but needed a better management solution as the current system had grown too large to reasonably manage manually. I identified the need for a management tool and developed one using SVN, PHP, Apache, MySQL, AJAX, and CSS, technologies. Data Points mapped data fields in a MySQL database to a GUI label in 1 or more languages. The main use for data points was the auto-generation of Datagrids complete with multilingual column headings. Other uses included form labels, and menu options. This tool reduced errors and significantly decreased development time.
During the development of the Product Reconciliation application several needs were identified to address testing. Transactions were needed to be simulated and results validated. I addressed these needs by writing several tools including a transaction simulator called “Scenario Builder”, data manipulation/reset tools, and data inspection tools.