Projects

Umbra Sync
  • Async Python tool that extracts contact details from Outlook emails and syncs them to Monday.com
  • Features: trusted-sender filtering, deduplication by email, watermark incremental sync, and selective field updates
  • Built with Python 3.12+, Pydantic models, httpx for async HTTP, tenacity retry logic, and Microsoft Graph + Monday GraphQL integrations
  • Designed for reliability: structured logging, CI tests (pytest + respx), and dry-run support

Artlessi

    *Archived since heroku removed free tier*

  • An online art community for amatuer artists

  • Coded entirely from scratch!

  • Functionality: Blog, commenting, payment, social media sharing, backend database

  • Python Djano, Heroku, Stripe, HTML, CSS, Bootstrap

Finance Dash App

    *Archived since heroku removed free tier*

  • Python-built financial planner for importing, analysing and reporting on personal finances.

  • Calculates key Financial KPIs to track my expenditure over time

  • Python, Pandas, Python-Dash, Heroku, Plaid API

Code Wars

  • Python, JavaScript and SQL coding challenges!

  • Testing my logic and problem solving skills by solving various tests

  • Learning from the online community on best practises

Selenium automation

  • Automatically check whether the Italian consulate had passport appointment vacancies

  • To learn selenium, web development and save me time!

  • Selenium, smtplib, web development

Traffic data analysis

  • Perform traffic data analysis in Python

  • To speed up work processes for Traffic Engineers

  • Pandas, tkinter, openpyxl, pathlib

Page down

About me

Hi! Thanks for stopping by! I’m Alessio and I'm . I’m a self-taught programmer. I work as a Senior Data Engineer & Technical Consultant. I lead end-to-end cloud data migrations.

In my spare time I'm committed to learning new backend and frontend development programming skills. My tech stack includes the items below — including tools used in projects like Umbra Sync.

Back end
  • Python (3.12+), async/await, typed code
  • Pandas, SQLAlchemy, requests, httpx, dlt, uv, Pydantic
  • Testing: pytest; mocking with respx
  • APIs: Microsoft Graph (Outlook), OAuth2/msal, Monday.com GraphQL, REST (JSON & XML)
  • Retry/Resilience: tenacity; structured logging
  • SQL/T-SQL, data warehousing, Stored Procedures
Data Engineering & Orchestration
  • dbt, SQLMesh, Prefect
  • Snowflake, Matillion, delta-load patterns
  • Infrastructure as Code: Terraform; GitHub Workflows CI/CD
Cloud & Platform
  • Azure: Fabric, Data Factory, Container Apps, Blob Storage, Function Apps, Logic Apps, Key Vault, Entra ID
  • AWS: Step Functions, Athena, S3, CloudWatch
  • Heroku (past projects)
Front end & Automation
  • HTML, CSS, Bootstrap, JavaScript (this website)
  • Dash dashboards; Power BI & DAX for reporting
  • Selenium, BeautifulSoup for automation and scraping
Tools, Testing & Dev UX
  • mise & uv for reproducible environments; ruff for lint/format
  • pytest + respx; code coverage (codecov); pre-commit hooks
  • GitHub Actions CI and workflow automation
Other
  • Certifications: Microsoft Certified — Azure Data Engineer Associate (DP-203), Snowflake SnowPro Core
  • Experience building reliable syncs: watermarking, deduplication, trust-list filters
  • Familiar with OAuth2 flows, secure credential handling and enterprise auth (msal/Entra ID)
  • AI-assisted development: Claude & GitHub Copilot for coding and reviews

Page top