The union tracked members and partner agreements on paper, and the printed membership card had to be redone every year.

SigeSind · Union · In production since March 2026

Problem
Paper records and a printed membership card redone every year.
What I did
A single record of members, agreements and appointments, and a digital membership card with public validation.
Result
The membership card is now digital and anyone can validate it with the QR code. Members, agreements and appointments live in the same record. In production since March 2026.

Digital membership card

What I observedThe printed membership card had to be redone every year.

Solution appliedDigital membership card with public validation: the QR code opens a page that confirms whether the membership is active, no login needed.

System screen: Digital membership card

One single record

What I observedMembers and agreements were tracked on paper.

Solution appliedMembers, agreements and appointments in the same record. Each appointment is linked to the person and to the type of appointment, with a status: scheduled, done, canceled or no-show.

System screen: One single record

Contact with members

What I observedThere was no simple way to remember birthdays or to notify members.

Solution appliedBirthdays and announcements to keep in touch with members, with conversations inside the system.

System screen: Contact with members

Schedule without clashes

What I observedAppointments booked by hand could land at the same time, and the follow-up of each one got lost.

Solution appliedWeekly appointment schedule. The system does not accept two appointments of the same type at the same time. The board records follow-up notes, and an appointment that already has notes is not deleted: it is canceled, and the history stays.

System screen: Schedule without clashes

Appointments in numbers

What I observedThe board did not know how many appointments took place, or how many were canceled or ended in a no-show.

Solution appliedPeriod report with the total appointments by type and by status: scheduled, done, canceled and no-show. Only the board can filter by member.

System screen: Appointments in numbers

Financial transparency

What I observedThe board did not have the union's income, expenses and balance at hand to show.

Solution appliedIncome and expenses by category, with income, expenses and balance for the period, total balance, filters and PDF export. Only the board posts entries, and only the president edits or deletes one.

System screen: Financial transparency

The union's assets

What I observedThe union's assets and equipment had no single list, and nobody knew the total value.

Solution appliedAssets and equipment with year of acquisition, quantity and unit value. The system adds up items, quantity and total value of the assets.

System screen: The union's assets

Each profile sees what it needs

What I observedMembers' personal data could not be left in view of everyone.

Solution appliedFour profiles: president, board, member and associate. A member sees only their own appointments and notes, and other people's personal data stays with the board. A user with entries, conversations or messages cannot be deleted, so no history is lost.

Role
Requirements gathering, interface design, database, API, front end and deployment: Álvaro Marinho.
Period
In production since March 2026
Technologies
Angular 22, Node.js 22, Express 5, TypeScript, MariaDB 10.11, Sequelize, autenticação JWT, CI/CD com GitHub Actions, VPS Linux (PM2 e nginx)