About Me

Welcome to StackedStats! I’m Sandro, a software engineer with a passion for building reliable, scalable systems and sharing knowledge with the tech community.

What I Do

I specialize in backend development, data engineering, and infrastructure automation. My work involves designing and implementing systems that process large amounts of data efficiently and reliably.

When I’m not writing code for work, you’ll find me:

  • Tinkering with my home lab - Running self-hosted services, experimenting with NixOS, and automating everything possible
  • Learning new technologies - Currently exploring Rust and distributed systems
  • Writing about what I learn - Hence this blog!

About This Blog

StackedStats is where I document my technical journey. I write about:

  • Programming tutorials - Deep dives into Python, Go, and other languages
  • Data engineering - Building data pipelines, working with databases, and data analysis
  • Home lab adventures - Self-hosting, infrastructure, and automation
  • Best practices - Software architecture, testing, and development workflows

My goal is to write the articles I wish I had found when learning these topics myself. I believe in practical, hands-on explanations with real-world examples.

Get in Touch

I’m always happy to connect with fellow developers and tech enthusiasts. Feel free to reach out through any of the social links, or drop me an email if you have questions or just want to chat about tech!

Experience

Consultant

Machine Learing Reply

• Led the development of a scalable automated data pipeline for the customer's Azure-based data warehouse. • Designed and implemented modern Azure infrastructure to support analytics workloads. • Developed reusable Python tools to process and manage data across Azure Storage solutions. • Collaborated closely with the customer to deliver technical solutions tailored to their needs.

Associate Consultant

b.telligent

• Optimized customer engagement by implementing successful data-driven predictive models. • Designed an internal machine learning framework to accelerate deployment and monitoring processes. • Handled over 150 analytical data applications for client projects. • Advised customers on technical and business decisions related to advanced analytics.

Research Assistant

Freie Universität Berlin

• Generated data models, performed statistical analysis, and helped produce reports outlining results. • Performed feature selection and dimension reduction on high-dimension data sets. • Gathered, arranged, and corrected research data to create representative graphs and charts highlighting results for presentations. • Developed preprocessing pipelines and tuned hyperparameters for better model performance.

Student Assistant

Freie Universität Berlin

• Revised, modularized, and updated old code bases to modern development standards, reducing operating costs and improving functionality. • Used critical thinking skills and decisive judgment and worked with minimal supervision.

Student Assistant

Freie Universität Berlin

• Took photos of experimental setups and post-produced them. • Made videos of experiments and post-produced them. • Recreated supplemental materials for student experiments.

Freelance Sales and Event Host

Self-Employment

• Managed points of sale. • Organized (inter-) national events. • Advertised and sold tickets for events. • Entertained guests on events.

Education

Master of Science in Physics

Freie Universität Berlin

Focused on advanced topics in physics, developing a strong foundation in theoretical and experimental techniques.

Bachelor of Science in Physics

Freie Universität Berlin

Gained comprehensive knowledge of fundamental physics, with an emphasis on problem-solving and analytical skills.

Abitur

Hannah-Arendt-Oberschule

Completed secondary education with a focus on biology and political science, fostering an interdisciplinary perspective alongside natural sciences.

Skills

Cloud Platforms

Microsoft Azure Amazon Web Services (AWS)

Programming

Python JavaScript Bash

Data & Analysis

Statistical analysis Time series forecasting Classifier models Databricks MySQL PostgreSQL PL/SQL

Infrastructure & Networking

Terraform Docker & Docker-Compose Ansible SSH NFS HTTP(S) SAMBA (S)FTP Traefik Nginx

Version Control & CI/CD

Git GitLab GitHub Azure DevOps

Markup Languages

HTML CSS LaTeX Markdown

Operating Systems

Linux (Ubuntu, Arch, NixOS, Proxmox, TrueNAS Scale) MacOS Windows Unifi OS

IT Administration

Linux server administration and installation User and permission management System monitoring and troubleshooting

High-Performance Computing (HPC)

HPC infrastructure usage (e.g., creating and submitting SLURM jobs)

Featured Projects

In-House ML Deployment Framework Development

Software Developer at Telefonica

Developed and maintained a proprietary Python framework designed internally to streamline and standardize machine learning model deployments across environments for business-critical applications at enterprise scale.

Python SQL Databricks ML Flow CI/CD Pipelines Internal Framework Development Azure

AI Agent Orchestration Platform

Technical Lead at Machine Learning Reply

Led the technical development of a cloud-native platform enabling AI developers to seamlessly deploy and orchestrate intelligent agents focused on enhancing developer workflows, including automated code review, technical debt identification, and development process optimization.

Python (Pydantic, Jinja2, Boto3, PyYAML) AWS (Lambda, Step Functions, ECS, API Gateway) DynamoDB Docker & Container Registry GitHub API Event-Driven Architecture

Automated Data Pipeline Integration and Warehousing Solution

Cloud Developer at Allianz Global Life

Led the development of an automated data pipeline to support customer's Azure Data Warehousing needs, reducing manual ETL efforts by 80%.

Azure Function Apps Azure Synapse Azure Networking Python SQL Terraform

Replay Parser and Feature Extractor for Heroes of the Storm

Software Developer at Independent Project

Developed a professional-grade tool for parsing and extracting insightful features from Heroes of the Storm replay files. The tool was tailored for professional use and created in collaboration with an e-sports league to support analytics and strategic decision-making.

Python PostgreSQL Agile Development Database Design

Yet Another Trajectory Interface (YetI)

Software Developer at Academic Research

Developed a feature-engineering tool for biomolecular simulations to accelerate data analysis during master's and PhD research, significantly optimizing feature extraction for large-scale simulations.

Python Multi-threading NumPy Physics and Chemistry Agile Development