CELCAT Live Reports
Imperial College London
Software & Data
2,025
01/
Overview
As the lead engineer, I was responsible for rewriting and rebuilding the Live Reports setup under a tight deadline. I analysed CELCAT’s updated schema, restored access control for specific roles and restructured report “blocks” - each consisting of a title, description, icon, parameters and action buttons. The redevelopment restored full reporting functionality, allowing staff to continue producing data-driven insights without disruption and included training and documentation so colleagues could maintain and extend the system independently.
Stack:
JSON
CELCAT
SQL
02/
Process
As the CELCAT Live Reports tool was becoming non-operational due to outdated configuration and system structure changes, my role required auditing the broken setup, comparing legacy and updated documentation and implementing the required technical fixes. I rebuilt report “blocks” from scratch, rewrote JSON and configuration logic and tested SQL query outputs to ensure accurate reporting. Throughout the redevelopment, I worked closely with key stakeholders - to schedule regular demos and feedback sessions to ensure the solution aligned with their reporting needs and user expectations.
Once restored, the tool allowed teams to generate accurate, real-time reports directly within CELCAT Live. I also ensured role-based access was correctly configured so only authorised staff could create or modify reports. Before my departure from the team, I documented the new setup and workflow to upskill the team to ensure they were able to maintain and extend the system in the future.
Technologies used:
MS SQL Server Management Studio - to access CELCAT databases, build and test SQL queries and validate report outputs.
JSON - for defining and restructuring report blocks, parameters and metadata to match the updated CELCAT configuration.
CELCAT Live environment - for managing report deployment, user roles and permissions directly within the live system.
Confluence - for documentation of the report setup, stakeholder feedback and technical notes.
03/
Key features
Rebuilt and restructured CELCAT Live Reports blocks for system compatibility.
Restored SQL query and report generation functionality.
Configured role-based access and report parameters.
Collaborated closely with stakeholders, delivering demos and gathering feedback.
Completed redevelopment under strict time constraints.