Dylan Călin

Profile

Data engineer and database administrator with nearly six years in a public-sector institution, where I run the relational databases and build the Python tools on top of them: ingestion pipelines, analytics apps and automated reporting. My main internal pipeline cut manual record lookups by ~85%. Alongside that I build scraping and automation pipelines for freelance clients, and I design, ship and maintain Flutter apps, with six live on the App Store and Google Play.

~85%less manual lookup work after the ingestion engine

Since 2020running institutional databases in production

6apps live on the App Store and Google Play

30+apps, tools and games designed and built

Experience

Senior Database Administrator & Data Systems Engineer

Dec 2020 – Present

Public-sector institution · Bucharest, Romania

Administer the institution's relational databases (MySQL, PostgreSQL, Oracle, SQLite): schema migrations, query profiling and index tuning, scheduled backups and recovery, and security compliance.
Designed and built a Python ingestion and lookup engine (PyQt6 desktop app plus FastAPI service) that searches several departmental databases in one step, cutting manual lookup effort by ~85%.
Wrote parsers that turn unstructured operational logs and dispatch feeds into clean relational records, with validation and deduplication that keep schemas consistent across sources.
Built incident analytics (frequencies over time windows, geographic clustering, peak-hour detection) that feed auto-generated Word and Excel briefs for leadership, replacing manual report drafting.
Developed an internal Flask/MySQL web app for multi-criteria record matching and entity resolution across departments.
Designed and shipped the staff canteen app (Flutter client, MySQL backend) for reservations, portions and inventory: the only way staff order from the canteen, live on both stores.

Stack: Python, FastAPI, PyQt6, Flask, Pandas, NumPy, Pydantic, RegEx, python-docx, openpyxl, MySQL, PostgreSQL, Oracle SQL, Flutter

Freelance Python Automation & Data Engineer

2022 – Present

Independent · Remote

Built scrapers for 10+ social media platforms and other sites, tracking creator and competitor accounts to give clients the data behind their marketing strategy.
Deliver ETL pipelines that clean scraped data and sync it straight into clients' Airtable CRMs (REST API) and Google Sheets (service accounts, gspread).
Deploy and monitor scheduled workers on PythonAnywhere and Linux (cron, systemd) with error webhooks and log retention, so collection and reporting run unattended.
Built subscription Telegram bots: Reddit monitoring via PRAW with real-time channel alerts, PostgreSQL with connection pooling, and Stripe recurring billing.
Automated data extraction from legacy desktop software with no API (PyAutoGUI, Pandas) and parsed unstructured legal and administrative documents into structured tables and Excel deliverables.

Stack: Python, Playwright, Selenium, Requests, BeautifulSoup, Airtable API, Google Sheets API, PRAW, Telegram Bot API, PostgreSQL, Stripe, PyAutoGUI

Independent Mobile Developer (Flutter)

2019 – Present

Self-published · dylansapps.netlify.app/apps

Took 6 apps from idea to the App Store and Google Play on my own: architecture, offline-first storage (SQLite, Drift), Supabase backend with Row-Level Security, RevenueCat subscriptions, store compliance and releases.
Built 30+ apps, utilities and games in total, including a deductive SAT solver that guarantees every Minesweeper board is solvable without guessing, and physics games built on Flame and Forge2D.

Stack: Flutter, Dart, SQLite, Drift, Supabase, Firebase, RevenueCat, Flame, Forge2D

Skills

Languages: Python, SQL, Dart
Data & back end: Pandas, NumPy, Pydantic, FastAPI, Flask, REST APIs and webhooks, ETL design, data modelling and normalisation, RegEx parsing, python-docx, openpyxl
Databases: PostgreSQL, MySQL, Oracle SQL, SQLite, Supabase (Row-Level Security), Drift · schema design, indexing, query tuning, migrations, backup and recovery, connection pooling
Scraping & automation: Playwright, Selenium, Requests, BeautifulSoup, lxml, PyAutoGUI, PRAW, Telegram Bot API
Cloud & integrations: Airtable API, Google Sheets API, Stripe, RevenueCat, Firebase / FCM, PythonAnywhere, Linux cron and systemd
Mobile: Flutter, Flame, Forge2D, offline-first architecture, biometrics, AES-256 encryption, device sensors, App Store and Google Play publishing

Selected Projects

Enterprise Data Pipeline Suite In use internally

Ingestion, lookup and reporting engine across departmental databases. ~85% less manual lookup work; leadership briefs generated automatically.

Python · FastAPI · PyQt6 · Pandas · openpyxl

GriLEX · Grile MAI & TCO Live · iOS & Android

Exam prep for Romanian Police, Gendarmerie and MAI admission and promotion: timed simulations, official past papers, AI explanations, offline question banks, subscriptions.

Flutter · SQLite · Supabase · RevenueCat

Grile TCO Live · 1K+ downloads

Earlier exam-prep app for MAI admission tests, still live on Google Play with over 1,000 downloads.

Flutter · SQLite

Popota · Canteen Ordering Live · iOS & Android

The only ordering channel for an institutional staff canteen: meal reservations, portion allocation, inventory, push notifications and Excel exports.

Flutter · MySQL · Supabase · FCM

Minesweeper The Original Live · Android

Board generator backed by a deductive SAT solver that guarantees guess-free, solvable boards. Daily challenges and custom boards.

Flutter · Dart · SAT solver · AdMob

Telegram Monitoring Bots Client work

Paid Telegram bots that watch Reddit communities and push real-time alerts to client channels, billed through Stripe subscriptions.

Python · PRAW · PostgreSQL · Stripe

Sensor Toolkit Live · iOS & Android

Compass, decibel meter, lux meter, accelerometer readout and flashlight in one utility, with subscription tiers.

Flutter · Sensors Plus · Geolocator · RevenueCat

Flip Rush Live · iOS & Android

Fast arcade reaction game running at 60 FPS, with high scores and custom audio.

Flutter · Flame

Permis Armă & Permis Vânătoare Pre-release

Exam prep for Romania's weapons (Law 295/2004) and hunting (Law 407/2006) permits: 800 and 600 official questions, pass-mark simulations, dossier checklists.

Flutter · SQLite · Offline First

Obscura · Privacy Messenger & Vault Pre-release

Zero-cloud, offline end-to-end encrypted messaging & cryptographic key vault. Curve25519 ECDH key negotiation, authenticated AES-256-GCM, steganographic cloaking, and RevenueCat subscription tiers.

Flutter · Curve25519 · AES-256-GCM · RevenueCat · SQLite

AegisVault In development

Offline, zero-knowledge vault for photos and documents, unlocked with Face ID or fingerprint and encrypted with AES-256.

Flutter · AES-256 · local_auth · SQLite

Languages

English (C1, professional working proficiency) · Romanian (native)

Full catalogue, store links and privacy policies: dylansapps.netlify.app/apps