Projects

This project was to streamline and better expose the lighting products of JCC via an online portal including stock availability, pricing and much more. This meant the ability to facilitate Oracle with the necessary data from JCC's SQL Server both in live calls from the site and SSIS FTP deposits

This project was the review and redress of Interest Rate Hedging Products that had been allegedly mis-sold. 

This needed quick and robust reporting methodology to satisfy both project teams and stake holders as well as the FCA who were required to publish frequent updates

This project was the initial automation and publishing of the company's main quarterly report to Tableau Server, (21 pages and over 100 worksheets) followed by major updates to reports after a major system overhaul from MySQL to Postgres across several unconnected database sources

This project involved the complete revamping of reporting methods; the introduction of visualisation and data mining which subsequently  led to the redundancy of legacy applications and dependencies on the vendors

This project was the analysis and integration of local rail asset maintenance data to the MIMS  application. 

This was due to government reviews of how maintenance data was handled after poorly managed track conditions led to a major rail disaster and accountability was sought

Formerly  Department for Business, Enterprise and Regulatory Reform which had in turn superceded it's original name, DTI (Department for Trade and Industry). This project was the introduction of an Export Licencing database