Case study · Web platform & extranet

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.

Real estate · Social housing
Paris
Since 2019
Information system overhaul
PHP · Symfony · Vue.js · MySQL · Docker

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.

€30M
The guarantee fund managed by SGAHLM, which the platform helps monitor reliably every day.
2019 Start of our partnership with SGAHLM
3 federations of organisations brought together on one standardised platform
4 modules delivered: public site, extranet, statistics, outstanding calculation

The people behind the project

SAK
Samar KALLEL
Cheffe de Projet
Projets Web Projet Mobile Conseil
Mon rôle, c’est de faire avancer les projets simplement, sans friction inutile.
9 ans d'expérience
+ 30 projets livrés

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.