Objective:

Convert a complex legacy Access database to a web accessible database of ‘NASM’ (non-agricultural source materials) sites where Terratec Environmental applies biosolids to farmland.

Technologies:

Laravel PHP Framework, Blade templates, MySQL, PHP, Bootstrap/CSS3/LESS, HTML, JavaScript/JQuery

nasm

Screenshot from NASM database

Solution:

  1. Data cleaned, restructured and converted to MySQL.
  2. Custom web application interface built using Laravel framework.
  3. Styled using Bootstrap and LESS CSS preprocessor.
  4. Designed and implemented ‘report builder’ to allow users to create complex custom reports easily. Reports can be exported to Excel spreadsheets or printed.
  5. Responded to client feedback to ensure successful launch and post-launch tweaks of user interface.