Hi, I'm Vytautas.

This ELT project loads source files from object storage, stages them in an analytical database, and then transforms them into standardized, history-aware dimensional tables. Raw data is first copied into a dated backup area, then ingested into staging schemas with minimal structure changes. Next, transformation models build SCD2-style dimensions, applying data quality checks to ensure consistency and traceability. The entire pipeline (backup → load → transform → test → document) runs on Kubernetes cluster and orchestrated by Airflow.

Refactored a data product that consolidates raw regulatory data into a single governed fact layer, enriched with metadata, entity attributes, and submissions status. Improved SQL readability and maintainability using well-structured CTEs.

Python CLI that orchestrates three data maintenance modes over S3 and Trino/Iceberg: backup (copy CSVs between S3 accounts into date-based folders), load (normalize columns and write into Trino *_staging tables), and cleanup (delete old backups by retention period). All behavior is configured via environment variables and CLI arguments.

A fully serverless contact form for my portfolio website. The frontend sends a POST request with user input (email and message). API Gateway acts as a secure HTTP interface, routing requests to the backend. AWS Lambda processes incoming requests, validates the payload, and triggers email delivery. Messages are sent via AWS SES — no servers, no long-running services.

Simple website deployment automation with GitHub Actions and Terraform.

Automated weather data ingestion to Postgres with subsequent analysis.

Pipelines for ML experiments and price prediction.

Prototype with data preparation and a web UI.

Containerised example with Airflow orchestration.