MTES-MCT/zero-logement-vacant
Nov 2024 – Feb 2026
16 Months active
Languages Used
CSSHTMLJavaScriptSCSSSQLTypeScripttsxJSON
Technical Skills
API IntegrationBackend DevelopmentCSSCSS ModulesCode ClarityCode Cleanup
Loïc Guillois
PROFILE
Loïc Guillois
Loïc Guillois developed and maintained the MTES-MCT/zero-logement-vacant platform over 16 months, delivering robust features and reliability improvements across backend, frontend, and data pipelines. He engineered solutions for address normalization, PDF generation, and campaign tracking, integrating services like Brevo and La Poste APIs while optimizing data ingestion and analytics workflows. Using TypeScript, Python, and PostgreSQL, Loïc enhanced infrastructure with Terraform, improved CI/CD automation, and implemented security best practices such as dependency pinning and error monitoring. His work demonstrated depth in API integration, database optimization, and DevOps, resulting in a scalable, maintainable codebase with strong data quality and operational resilience.
Overall Statistics
Feature vs Bugs
57%Features
Repository Contributions
356Total
Bugs
96
Commits
356
Features
127
Lines of code
94,464
Activity Months16
Your Network
5 people
Work History
February 2026
5 Commits • 4 Features
Feb 1, 2026February 2026 — MTES-MCT/zero-logement-vacant: Delivered four principal initiatives focused on data resilience, CI/CD efficiency, data portability, and dependency stability across the codebase. While no explicit bug fixes are logged in this period, the changes collectively reduce risk, accelerate deployment, and improve compliance-readiness through improved tooling and governance.
5 Commits • 4 Features
Feb 1, 2026February 2026 — MTES-MCT/zero-logement-vacant: Delivered four principal initiatives focused on data resilience, CI/CD efficiency, data portability, and dependency stability across the codebase. While no explicit bug fixes are logged in this period, the changes collectively reduce risk, accelerate deployment, and improve compliance-readiness through improved tooling and governance.
February 2026
January 2026
23 Commits • 7 Features
Jan 1, 2026January 2026 – MTES-MCT/zero-logement-vacant: Monthly performance snapshot focused on delivering business value, stabilizing the codebase, and enabling scalable geospatial and tooling capabilities across the product.
January 2026
23 Commits • 7 Features
Jan 1, 2026January 2026 – MTES-MCT/zero-logement-vacant: Monthly performance snapshot focused on delivering business value, stabilizing the codebase, and enabling scalable geospatial and tooling capabilities across the product.
December 2025
49 Commits • 18 Features
Dec 1, 2025December 2025 – MTES-MCT/zero-logement-vacant: Delivered security-first, maintainable enhancements and data reliability improvements. Key features included user type classification, centralized server configuration, and Portail DF integration with token-based authentication and retry logic. Implemented comprehensive security hardening (ignore-scripts, CI tooling pinning, install-script allowlists, and dependency pinning) to reduce supply-chain risk. Introduced NPQ pre-installation scanning with updated docs. Completed major performance and reliability work: optimized housings BAN addresses query, batched seed/config checks, improved Shapefile validation and test stability, and refined DPE progress bar behavior. Extended monthly operations with automated logs export via Clever Cloud cron, standardized environment variable names, and exports including campaigns. Numerous bug fixes across Vite paths, npm alias pinning, Vite alias handling, user type mappings, and UI/UX wording improvements. This combination reduces security risk, speeds up secure release cycles, improves data quality, and strengthens the platform’s resilience and observability.
49 Commits • 18 Features
Dec 1, 2025December 2025 – MTES-MCT/zero-logement-vacant: Delivered security-first, maintainable enhancements and data reliability improvements. Key features included user type classification, centralized server configuration, and Portail DF integration with token-based authentication and retry logic. Implemented comprehensive security hardening (ignore-scripts, CI tooling pinning, install-script allowlists, and dependency pinning) to reduce supply-chain risk. Introduced NPQ pre-installation scanning with updated docs. Completed major performance and reliability work: optimized housings BAN addresses query, batched seed/config checks, improved Shapefile validation and test stability, and refined DPE progress bar behavior. Extended monthly operations with automated logs export via Clever Cloud cron, standardized environment variable names, and exports including campaigns. Numerous bug fixes across Vite paths, npm alias pinning, Vite alias handling, user type mappings, and UI/UX wording improvements. This combination reduces security risk, speeds up secure release cycles, improves data quality, and strengthens the platform’s resilience and observability.
December 2025
November 2025
1 Commits • 1 Features
Nov 1, 2025Month: 2025-11 Focused on hardening La Poste API integration in the npai tool within MTES-MCT/zero-logement-vacant. Delivered targeted reliability improvements and updated documentation to reduce debugging time and access friction. Key outcomes: - Strengthened error handling for 403 Forbidden responses in La Poste API integration - Enhanced observability with more detailed logging (request URL, response text) - Updated README to clarify API key permission prerequisites for smoother access and debugging - Consolidated changes under a single commit to ensure traceability and rapid iteration
November 2025
1 Commits • 1 Features
Nov 1, 2025Month: 2025-11 Focused on hardening La Poste API integration in the npai tool within MTES-MCT/zero-logement-vacant. Delivered targeted reliability improvements and updated documentation to reduce debugging time and access friction. Key outcomes: - Strengthened error handling for 403 Forbidden responses in La Poste API integration - Enhanced observability with more detailed logging (request URL, response text) - Updated README to clarify API key permission prerequisites for smoother access and debugging - Consolidated changes under a single commit to ensure traceability and rapid iteration
October 2025
18 Commits • 7 Features
Oct 1, 2025October 2025 performance summary for MTES-MCT/zero-logement-vacant focused on stability, security, and developer velocity. Delivered core platform improvements across dependencies, verification, identity management, data import, and CI/CD workflows, with performance enhancements for data processing and robust test coverage. Key outcomes include safer deployment pipelines, improved data accuracy, and clearer internationalization for DPE/ADEME import, enabling faster onboarding and reduced maintenance risk.
18 Commits • 7 Features
Oct 1, 2025October 2025 performance summary for MTES-MCT/zero-logement-vacant focused on stability, security, and developer velocity. Delivered core platform improvements across dependencies, verification, identity management, data import, and CI/CD workflows, with performance enhancements for data processing and robust test coverage. Key outcomes include safer deployment pipelines, improved data accuracy, and clearer internationalization for DPE/ADEME import, enabling faster onboarding and reduced maintenance risk.
October 2025
September 2025
23 Commits • 11 Features
Sep 1, 2025September 2025 achieved meaningful progress across deployment reliability, data ingestion performance, address normalization, and observability for MTES-MCT/zero-logement-vacant. Key changes included targeted deployment fixes, performance optimizations, and new tooling that reduce operational risk and improve user-facing outcomes.
September 2025
23 Commits • 11 Features
Sep 1, 2025September 2025 achieved meaningful progress across deployment reliability, data ingestion performance, address normalization, and observability for MTES-MCT/zero-logement-vacant. Key changes included targeted deployment fixes, performance optimizations, and new tooling that reduce operational risk and improve user-facing outcomes.
August 2025
7 Commits • 3 Features
Aug 1, 2025August 2025 performance summary for MTES-MCT/zero-logement-vacant: Delivered stable PDF generation improvements, introduced a BullMQ queue management CLI with retry capabilities, and upgraded the Clever Cloud Terraform provider. Fixed critical code-quality issues (loop bound injection alert and lint) that enhanced security and maintainability. Overall impact: higher reliability in document rendering, more robust background processing, and stronger infrastructure alignment; demonstrated expertise in PDF rendering, queue management, and infrastructure as code.
7 Commits • 3 Features
Aug 1, 2025August 2025 performance summary for MTES-MCT/zero-logement-vacant: Delivered stable PDF generation improvements, introduced a BullMQ queue management CLI with retry capabilities, and upgraded the Clever Cloud Terraform provider. Fixed critical code-quality issues (loop bound injection alert and lint) that enhanced security and maintainability. Overall impact: higher reliability in document rendering, more robust background processing, and stronger infrastructure alignment; demonstrated expertise in PDF rendering, queue management, and infrastructure as code.
August 2025
July 2025
22 Commits • 14 Features
Jul 1, 2025July 2025 monthly summary for MTES-MCT/zero-logement-vacant. Focused on delivering features that improve data pipelines, campaign measurement, and system reliability, while enhancing observability and security. Key items delivered span Brevo-based campaign tracking, job management enhancements, Puppeteer stability, and data management capabilities (Cerema and Ademe scrapers). Clean code practices and configuration hardening were applied to reduce operational risk and improve maintainability. Notable cross-cutting improvements include removing noisy logs, expanding defaults, and refining pagination and API state handling to support robust batch processing.
July 2025
22 Commits • 14 Features
Jul 1, 2025July 2025 monthly summary for MTES-MCT/zero-logement-vacant. Focused on delivering features that improve data pipelines, campaign measurement, and system reliability, while enhancing observability and security. Key items delivered span Brevo-based campaign tracking, job management enhancements, Puppeteer stability, and data management capabilities (Cerema and Ademe scrapers). Clean code practices and configuration hardening were applied to reduce operational risk and improve maintainability. Notable cross-cutting improvements include removing noisy logs, expanding defaults, and refining pagination and API state handling to support robust batch processing.
June 2025
14 Commits • 5 Features
Jun 1, 2025June 2025: Delivered a focused set of data-model improvements, reliability fixes, infrastructure upgrades, and data tooling across MTES-MCT/zero-logement-vacant. Key features delivered include city code data model enhancement, infrastructure/provider upgrades, data ingestion/analytics tooling, and DPE data integration. Notable bugs fixed improve reliability of PDF generation and analytics tagging accuracy. These efforts enhanced data granularity, reporting reliability, security posture, and end-to-end data capabilities, enabling better program insights and operational efficiency.
14 Commits • 5 Features
Jun 1, 2025June 2025: Delivered a focused set of data-model improvements, reliability fixes, infrastructure upgrades, and data tooling across MTES-MCT/zero-logement-vacant. Key features delivered include city code data model enhancement, infrastructure/provider upgrades, data ingestion/analytics tooling, and DPE data integration. Notable bugs fixed improve reliability of PDF generation and analytics tagging accuracy. These efforts enhanced data granularity, reporting reliability, security posture, and end-to-end data capabilities, enabling better program insights and operational efficiency.
June 2025
May 2025
33 Commits • 10 Features
May 1, 2025May 2025 summary for MTES-MCT/zero-logement-vacant focusing on reliability, performance, and developer velocity across PDF workflows, UI, and CI/testing: - Strengthened PDF generation and testing pipeline with content tests for subject, sender, logos, and signatories; extended test timeout for stability; enhanced typing for nullable values and resolution of queueing issues. - Updated PDF draft template and introduced a tabbed interface for grouped edit forms, with refined sub-status display and behavior (including disablement when not applicable and removal of redundant grouped sub-status UI). - Stabilized CI/CD and test infrastructure: pinned runner to Ubuntu 22.04 and added environment variables and test config needed for reliable execution. - Clarified and aligned dependencies (tslib, polyfills) across packages and server to reduce build/test friction and improve runtime consistency. - UI stability and performance improvements: lint fixes and EOF corrections; React build stabilization; owner/search performance gains via full-text search indexing; refactors of form components for better maintainability and data handling.
May 2025
33 Commits • 10 Features
May 1, 2025May 2025 summary for MTES-MCT/zero-logement-vacant focusing on reliability, performance, and developer velocity across PDF workflows, UI, and CI/testing: - Strengthened PDF generation and testing pipeline with content tests for subject, sender, logos, and signatories; extended test timeout for stability; enhanced typing for nullable values and resolution of queueing issues. - Updated PDF draft template and introduced a tabbed interface for grouped edit forms, with refined sub-status display and behavior (including disablement when not applicable and removal of redundant grouped sub-status UI). - Stabilized CI/CD and test infrastructure: pinned runner to Ubuntu 22.04 and added environment variables and test config needed for reliable execution. - Clarified and aligned dependencies (tslib, polyfills) across packages and server to reduce build/test friction and improve runtime consistency. - UI stability and performance improvements: lint fixes and EOF corrections; React build stabilization; owner/search performance gains via full-text search indexing; refactors of form components for better maintainability and data handling.
April 2025
20 Commits • 4 Features
Apr 1, 2025April 2025 (2025-04): Delivered major features and bug fixes in MTES-MCT/zero-logement-vacant, delivering higher-quality PDFs, enhanced analytics, and increased maintainability. Key outcomes include a refactored PDF generation pipeline integrating pdfme and Puppeteer, Metabase integration for JIMO analytics, removal of legacy Draft templates to reduce maintenance, and codebase modernization with dependencies, linting, and TS config updates. A critical division-by-zero fix in housing vacancy calculations stabilized reporting. These efforts improved customer-facing document quality, data-driven insights, and developer productivity.
20 Commits • 4 Features
Apr 1, 2025April 2025 (2025-04): Delivered major features and bug fixes in MTES-MCT/zero-logement-vacant, delivering higher-quality PDFs, enhanced analytics, and increased maintainability. Key outcomes include a refactored PDF generation pipeline integrating pdfme and Puppeteer, Metabase integration for JIMO analytics, removal of legacy Draft templates to reduce maintenance, and codebase modernization with dependencies, linting, and TS config updates. A critical division-by-zero fix in housing vacancy calculations stabilized reporting. These efforts improved customer-facing document quality, data-driven insights, and developer productivity.
April 2025
March 2025
18 Commits • 4 Features
Mar 1, 2025March 2025 monthly summary for MTES-MCT/zero-logement-vacant focusing on business value, user experience, and code quality. Delivered a set of frontend and backend improvements that enhance external service integration, user data hygiene, UI consistency, and maintainability. The work aligns with the product goals of secure, scalable user management and a polished user interface.
March 2025
18 Commits • 4 Features
Mar 1, 2025March 2025 monthly summary for MTES-MCT/zero-logement-vacant focusing on business value, user experience, and code quality. Delivered a set of frontend and backend improvements that enhance external service integration, user data hygiene, UI consistency, and maintainability. The work aligns with the product goals of secure, scalable user management and a polished user interface.
February 2025
33 Commits • 9 Features
Feb 1, 2025February 2025 — Summary: Implemented production-ready configs and data pipelines for zero-logement-vacant, delivering stability, performance, and data completeness. The month focused on environment/config stabilization, rate-limiting mitigation, pipeline modernization, production DB access, and enhanced data exports. Key outcomes include BAN resources configured via environment variables, Dagster port updated, 5-second API delay to prevent throttling, campaign export complement, production PostgreSQL write access provisioning, merged chunk processing with API calls and DB insertion (replacing Parquet with CSV), and BAN addresses optimization with memory improvements and reliability fixes.
33 Commits • 9 Features
Feb 1, 2025February 2025 — Summary: Implemented production-ready configs and data pipelines for zero-logement-vacant, delivering stability, performance, and data completeness. The month focused on environment/config stabilization, rate-limiting mitigation, pipeline modernization, production DB access, and enhanced data exports. Key outcomes include BAN resources configured via environment variables, Dagster port updated, 5-second API delay to prevent throttling, campaign export complement, production PostgreSQL write access provisioning, merged chunk processing with API calls and DB insertion (replacing Parquet with CSV), and BAN addresses optimization with memory improvements and reliability fixes.
February 2025
January 2025
29 Commits • 13 Features
Jan 1, 2025January 2025 performance summary for MTES-MCT/zero-logement-vacant. Focused on delivering user experience improvements, robust BAN address workflows, and performance-driven data processing, while simplifying maintenance and enhancing documentation.
January 2025
29 Commits • 13 Features
Jan 1, 2025January 2025 performance summary for MTES-MCT/zero-logement-vacant. Focused on delivering user experience improvements, robust BAN address workflows, and performance-driven data processing, while simplifying maintenance and enhancing documentation.
December 2024
29 Commits • 9 Features
Dec 1, 2024December 2024 monthly summary for MTES-MCT/zero-logement-vacant: Delivered a set of stability, performance, and UX improvements across the codebase, with a focus on data correctness, test reliability, and CI quality. Key architectural improvements include faster owner search, robust mocks, and UI componentization. The work emphasized business value through corrected data flows, improved user routing, clearer UI labels, and dependable report generation.
29 Commits • 9 Features
Dec 1, 2024December 2024 monthly summary for MTES-MCT/zero-logement-vacant: Delivered a set of stability, performance, and UX improvements across the codebase, with a focus on data correctness, test reliability, and CI quality. Key architectural improvements include faster owner search, robust mocks, and UI componentization. The work emphasized business value through corrected data flows, improved user routing, clearer UI labels, and dependable report generation.
December 2024
November 2024
32 Commits • 8 Features
Nov 1, 2024November 2024 monthly summary for MTES-MCT/zero-logement-vacant. Key features delivered: - Brevo healthcheck monitoring added to improve observability and alerting for service health. - Brevo URL typo fixed to ensure reliable health checks. - Website navigation improvements: removed outdated pages and updated footer links for clearer navigation. - Vacancy search enhancements: added a vacancy duration filter and updated terminology to vacancy year for clarity. - Address management improvements: show DGFIP address on owner edition modals and add missing DGFIP address where applicable. - UI density and drafts: reduced dropdown margins for a tighter layout; added vacancy start year to drafts. Major bugs fixed: - Test and quality fixes: refined vacancy duration tests, fixed test names, and addressed test warnings. - Code quality: lint fixes, removal of console logs, security hardening (helmet on queue), and sonar config cleanup. - Address-related fixes: ensured address verification modal appears when BAN address is empty; fixed address array handling and EOF marker. Impact: - Stronger reliability and faster incident response through improved observability. - Clearer, faster recruiting workflows due to better search precision and address management. - Reduced regressions and safer releases thanks to continued code quality and test improvements. Technologies and skills demonstrated: - Backend observability, health-check instrumentation, and alerting. - Frontend UI refinements and UX improvements. - QA discipline: test refactors and stability improvements. - Code quality and security enhancements: linting, cleanup, and best practices.
November 2024
32 Commits • 8 Features
Nov 1, 2024November 2024 monthly summary for MTES-MCT/zero-logement-vacant. Key features delivered: - Brevo healthcheck monitoring added to improve observability and alerting for service health. - Brevo URL typo fixed to ensure reliable health checks. - Website navigation improvements: removed outdated pages and updated footer links for clearer navigation. - Vacancy search enhancements: added a vacancy duration filter and updated terminology to vacancy year for clarity. - Address management improvements: show DGFIP address on owner edition modals and add missing DGFIP address where applicable. - UI density and drafts: reduced dropdown margins for a tighter layout; added vacancy start year to drafts. Major bugs fixed: - Test and quality fixes: refined vacancy duration tests, fixed test names, and addressed test warnings. - Code quality: lint fixes, removal of console logs, security hardening (helmet on queue), and sonar config cleanup. - Address-related fixes: ensured address verification modal appears when BAN address is empty; fixed address array handling and EOF marker. Impact: - Stronger reliability and faster incident response through improved observability. - Clearer, faster recruiting workflows due to better search precision and address management. - Reduced regressions and safer releases thanks to continued code quality and test improvements. Technologies and skills demonstrated: - Backend observability, health-check instrumentation, and alerting. - Frontend UI refinements and UX improvements. - QA discipline: test refactors and stability improvements. - Code quality and security enhancements: linting, cleanup, and best practices.
Activity
Loading activity data...
Quality Metrics
Correctness91.6%
Maintainability90.4%
Architecture87.2%
Performance86.2%
AI Usage21.2%
Skills & Technologies
Programming Languages
BashCSSConfigurationGitGit IgnoreHCLHTMLJSONJavaScriptJupyter Notebook
Technical Skills
API DesignAPI DevelopmentAPI HandlingAPI IntegrationAPI MockingAPI developmentAPI integrationAWSAWS S3Access ControlAddress NormalizationAddress VerificationAnalytics IntegrationAuthenticationAutomation
Repositories Contributed To
Overview of all repositories you've contributed to across your timeline