Security Compliance and Risk Assessment Tool
- context
- Fujitsu France · internship
- period
- Jul → Dec 2025
- platforms
- Linux · Windows · web interface

> cat context.md
SCRAT is the second tool from my internship at Fujitsu France, designed as an open-source project. Before an IT, information system or data project starts, the security team needs to know how much support it will require. SCRAT turns that qualification into a guided questionnaire, scores the answers and keeps a full audit trail, in line with ISO 27001 governance.
> cat how-it-works.md
- 01Ran comparative studies (Ubuntu vs Debian, PostgreSQL vs MySQL vs SQLite, web frameworks) and presented them to my tutor to settle the stack: Rust, Axum and PostgreSQL.
- 02Security by design: a unique master key generated at first launch, passwords hashed with bcrypt under a strict policy, and deliberately generic error messages.
- 03Three roles with strictly separated rights (administrator, operator, auditor), and an activity log of every action for audits.
- 04Least-privilege database: a restricted role for the app and stored procedures only, never dynamic SQL, to shut out injections.
- 05Available in English and French, runs on Linux and Windows, documented with cargo doc from a technical overview written before the first line of code.
> cat lessons.md
Governance and risk management, not just code. Designing the architecture and the handling of sensitive data took the most thought and many reviews with my tutor. It showed me how a large company expects a security tool to be specified, justified and audited.