Skills Used: MySQL, Java, JavaFX, UI/UX, ServiceNow, ITSM/ITIL
Github Link: https://github.com/Nyefari/incident-viewer
This project is something I took on due to there being no other viable solution found. We were transferring from one instance of our ticketing system to another, and the legal requirement for keeping incident records in my field is about 7 years. The two instances were configured quite differently, and the provider for our ticketing system has no ready way to transfer records from one instance to another even if they were configured the same. However, we were able to make XML and CSV backups of 90,000 incidents and 14,000 change requests. Unfortunately, the legal requirements would not have been satisfied by just keeping a backup. The records had to be “readily accessible,” and our audit team agreed that the format did not constitute accessible.
Because of this, I took on the project of creating a MySQL database to store all the records, a GUI for accessing them, and the software for loading the data from the CSV and XML files into the database. I learned how to parse data and build queries and started learning how to present data and options to users.
Donovan Pate 