Hello there!

I’m an IT specialist and data‑driven developer who helps clients turn ideas into working systems. I build automated solutions that save time, secure applications that protect data, and interactive dashboards that make complex information easy to understand. My experience ranges from creating full hardware and software tracking systems, to designing data pipelines that scrape, clean, and visualize information, to developing web applications with login and permission features.

If you need someone who can automate processes, design databases, integrate backend and frontend technologies, or transform raw data into clear insights, that’s exactly what I deliver. I focus on building solutions that are simple to use, scalable for the future, and structured so that anyone on your team can pick them up with ease. My goal is always the same: to create tools that make your work faster, smarter, and more reliable.

My approach

I follow KISS — Keep It Simple, Structure principles in everything I build. I prioritize clarity, maintainability, and real‑world usability.

During my time as an employee at the Tartu Local Government, it was standard practice to follow the E‑ITS (Estonian Information Technology Standard) This protocol, aligned with ISO/IEC 27001, set the baseline for information security in public sector projects. Working under E‑ITS gave me hands‑on experience in building solutions that not only functioned effectively but also complied with strict security and governance requirements.

Contact: rivotruupold@gmail.com or Truupold@protonmail.com

Facebook Profile

My Portfolio

Here you can read about my achievements while I studied in school: Estonian IT guys saved Dogeland.

Hardware Tracking & Automation

I created a fully automated system to track hardware, software, and peripherals across a network using PowerShell, MySQL, and PHP. The system logs changes over time, detects connected devices, and provides clear visualizations for quick insights.

What I learned: This project taught me how to design scalable automation pipelines, apply the Medallion Architecture (Bronze → Silver → Gold) for data structuring, and build interactive dashboards that turn raw logs into actionable insights.

Job Data Gathering & Visualization

I built a pipeline to scrape 1,100+ job listings, store them in MySQL, and map them with Python visualizations. The project revealed hiring patterns across cities and highlighted gaps like missing salary data.

What I learned: This was my first end‑to‑end data engineering project, teaching me how to go from web scraping → database design → interactive visualization, while handling real‑world challenges like geocoding accuracy and responsible crawling.

Node-Based Leaflet Map with Login & Permissions

I built an interactive map website using Node.js and Leaflet where users must log in to access features. Authenticated users can add and edit their own markers, but can’t delete others’ data, ensuring collaboration and security.

What I learned: This project strengthened my skills in backend authentication, frontend–backend integration, and designing user permission systems that protect data while keeping the experience smooth.