Software project
Assenze Desk — absence management
An Excel/VBA tool, used daily by a team, that automates the handling of sick-leave, holiday and time-off notices.
The problem
Every sick-leave notice required manual steps across email, the Italian social security (INPS) portal, the HR system and replies to employees. Constraints — nothing to install, Microsoft tools only, health data that never leaves the company.
The solution
- Reads the emails, retrieves the medical certificate from the INPS portal, fills in the HR system and drafts the replies. The operator always confirms before anything is sent.
- Handles holidays and time off, including requests written as free text.
- Started as a Python prototype, then rewritten in Excel/VBA so it can run without any installation.
- About 23,000 lines of VBA, more than 1,800 automated tests and over 100 documented decisions.
- Handling time cut by 70%; a complete sick-leave case is closed in about 75 seconds.
AI-assisted project. Requirements, rules, testing and decisions are mine.