Stefano Tranquillini

The storage system is a document-based database and file storage accessible via APIs that implements record level encryption. Due to an additional system with tokenization and pseudo-anonymization (that I made), searches over encrypted data are possible.

More than 50 active customers use the storage system to store sensitive data for their health applications. Examples are doctors’ visits reports, users’ profiles, and anything that has to be protected by legislation. The system also implements and exposes user management and access (Via Oauth2), permission (based on RBAK and PBAK design).

It was built using Python Django, Elasticsearch, Redis, Celery, Memcached, PostgreSQL, Vault, and Minio.

I designed, implemented, and maintained the source code of the first release of each service. As of today, I manage the team (direct employees and contractors) involved in the development. I also organize and maintain the product roadmap and collaborate on the coding when possible.

The logging system is a blockchain-based solution to store, search, and legally-validate logs, all via APIs. For this project, I researched, studied requirements from legislation, blockchain technology, and existing solution that lead to the current system that I designed and implemented.

The system leverages and implements blockchain technology (Merkle tree and hash-chain), which I implemented internally, to create a legally-valid proof of the audit logs.

The system is integrated into all Chino.io services via a plugin built for our framework (Django). The system also exposes functionalities via an API, to be used by customers to create their own entries.

The system is built following regulatory guidelines. It was created using Python Django, Django REST Framework, Elasticsearch, Memcached, PostgreSQL, and Minio.

I designed, implemented, and maintained the source code of the first release of each service. As of today, I manage the team (direct employees and contractors) involved in the development. I organize and maintain the product roadmap and collaborate on the coding when possible.

A consent-management system that implements a web interface and a set of APIs to create, store, and manage user consent (e.g., the consent that one has to check when registering to a service). The product starts from legal requirements and implements all the functionalities required. It was built using Python Django, Django REST Framework, Elasticsearch, Memcached, PostgreSQL, and Minio.

I designed, implemented, and maintained the source code of the first release of each service. As of today, I manage the team (direct employees and contractors) involved in the development. I also organize and maintain the product roadmap and collaborate on the coding when possible.

I designed and created a semi-automatic logging system that's integrated with MacOS to log time at work. The system automatically logs on/off-screen and startup/shutdown, counting exactly the time spent in front of the PC. It allows name activities with a name to have a logbook with minutes spent in every activity.

The system also has a terminal-based interface for reporting, where the single day breakdown is displayed with a summary of all logged time and percentage over the total.

I implemented the system for myself since I was doing this breakdown manually. I was eager to be more precise without installing third-party software that may be invasive and require too many permissions. As of today, I've logged more than 15 months of data.

As a companion of this project, I also create a mini script to check my slack online status. The data can be aggregated to add when I use other PCs or devices for work.