Professional Projects
Ticket Management System
Group project: full-stack IT ticketing application with Bun, React and PostgreSQL
General Information
| Field | Detail |
|---|---|
| Period | 18.02.2026 → 03.06.2026 |
| Context | Jobtrek Training Centre, group project (3 apprentices) |
| Training | Apprentice 1st year |
| Main goal | Build a full-stack IT ticketing application as a team, from user stories to a working product |
| Role | Developer in a team of 3: authentication and sessions, protected routes and roles, ticket comments, ticket assignment and statuses, user credentials page, Docker Compose setup and documentation (252 of 469 commits, 51 pull requests) |
Description
A full-stack ticketing application where users create IT support tickets and the support team handles them. It includes authentication, ticket creation with images, real-time comments over WebSockets, and an admin dashboard with search and pagination where support staff assign tickets and change their status. Assignment and status changes are recorded in the ticket's comment thread. The project started on SQLite and was migrated to PostgreSQL with Drizzle ORM. Work was planned with user stories and GitHub issues.
Technologies Used
| Category | Detail |
|---|---|
| Languages | TypeScript |
| Frameworks / Libraries | React 19, TanStack Router, Zustand, Axios, Valibot, Tailwind CSS 4, Drizzle ORM |
| Tools | Git, GitHub Projects, Bun, Vite 7, Biome, Docker Compose |
| Database | PostgreSQL 18 |
ICT Training Plan Competencies
c1: Identifier et analyser les données et développer des modèles de donnéesc2: Mettre en œuvre des modèles de données dans un dispositif de stockage de données numériquesg1: Analyser et documenter les besoins en matière d'applications et d'interfacesg3: Evaluer et documenter la sécurité des applications et des interfacesg4: Elaborer des variantes de mise en œuvre d'une application et développer la solution sur le plan conceptuelg5: Implémenter les applications et les interfaces selon le concept en respectant les exigences de sécuritég6: Vérifier la qualité et la sécurité des applications et des interfacesh1: Définir la plateforme appropriée pour la livraison des applicationsh2: Définir le processus de livraison des applicationsh3: Implémenter le processus de livraison des applicationsh4: Surveiller les applications et les interfaces et résoudre les problèmes en cours de fonctionnement