SGAHLM: overhauling the information system of a social housing guarantee fund
Since 2019, TCM has been helping SGAHLM fully overhaul its information system: a web platform and a secure extranet for the quarterly declarations of French social housing (HLM) organisations.
A critical tool that had stopped working
A website built in 2012 that no longer allowed members to file with confidence.
SGAHLM, guarantor of home-ownership risk for HLM organisations
SGAHLM (Société de Garantie à l’Accession des organismes d’HLM) manages a €30 million guarantee fund covering the home-ownership risk taken on by French social housing organisations. It represents three federations of organisations, each with its own information system and reporting practices.
Its website, built in 2012, suffered from major technical failures. Yet this is the tool members rely on to file their mandatory quarterly declarations.
The goal: completely overhaul the information system to provide a standardised, reliable and easy-to-use platform, from operation entry all the way to global reporting.
What the overhaul had to solve
Three challenges to make a tool at the heart of members' mandatory declarations reliable.
Pay down technical debt
Address significant technical debt and the shortcomings of the original code, which weakened the whole tool.
Make financial data reliable
Guarantee 100% reliable financial data, essential for calculating guarantees and checking equity.
Streamline quarterly processing
Simplify quarterly file processing for hundreds of member organisations.
A web platform and a secure extranet
A single tool for declarations, guarantee calculation and reporting.
A secure extranet for social housing organisations
TCM designed a robust business platform made up of a public website and a private, secure extranet.
It makes quarterly declarations easier for member organisations, builds in guarantee calculation and simplifies SGAHLM’s administrative reporting. The result: shorter processing times and fewer issues reported by members.
Public module
An information space open to everyone about the guarantee scheme.
Secure extranet
Organisations declare their operations: creation, update and closure.
Statistics module
Statistics built from the declared operations.
Outstanding calculation & self-check
A built-in algorithm that calculates outstanding amounts and checks equity.
The people behind the project
Project technologies
A proven PHP / Symfony foundation, paired with Vue.js for responsive interfaces.
Frequently asked questions about the SGAHLM project
Key takeaways from the SGAHLM platform overhaul.
SGAHLM manages a €30 million guarantee fund that covers the home-ownership risk of French social housing (HLM) organisations. It represents three federations of organisations, each with its own tools and reporting practices.
The website, built in 2012, suffered from major technical failures and significant technical debt. Members depend on it to file their mandatory quarterly declarations, so a full overhaul was needed to make the tool reliable.
Organisations use it to declare their operations — creation, update and closure. The platform then calculates outstanding amounts, checks equity and feeds a statistics module.
A built-in algorithm calculates outstanding amounts and automatically checks equity (self-check), so declared data is verified before it feeds the reporting.
The platform runs on PHP and Symfony on the server side, Vue.js for the interfaces, MySQL for the database and Docker for the runtime environment.
The new platform has reduced declaration processing times and cut the number of issues reported by members.
Yes. TCM designs and evolves custom business applications: audit of the existing system, architecture, development and maintenance. Book a meeting to discuss your project.
Planning an information system overhaul or a business extranet?
Let's talk about your project: audit of the existing system, architecture, custom development.