Systems, shaped with care.
Personal portfolio of Francesco Castaldi: Computer Engineer (BSc Ingegneria Informatica), MSc Computer Science candidate (LM Informatica, University of Bologna), and Healthcare Business Consultant.
Documenting all public GitHub repositories with technical schematics and comparative tables across upstream open-source engines, healthcare BI & analytics, artificial intelligence, and embedded telemetry.
Portfolio in Numbers
Precision-labeled dimensions across Computer Engineering, MSc Computer Science (LM Informatica, UniBo), Healthcare Business Consulting, and open-source software ecosystems.
ACCREDITATION & INDUSTRY PRACTICE (DIRECT VERIFICATION)
PRACTICE AREA DISTRIBUTION (COMMON SCALE MATRIX)
Selected Work
Docker CLI — Shell Completion & Plugin Discovery
Maintained and fixed shell completion routines for Docker CLI plugins under Zsh, ensuring stable automated plugin discovery.
All 36Documented Projects & Public Git Catalog
Every engineering treatise, upstream open-source contribution, healthcare BI plugin, and university laboratory across all 47 public Git repositories remains permanently accessible with technical tables, architectural schematics, and immutable URLs.
Upstream Systems & Cloud Native
11 projectsDocker CLI — Shell Completion & Plugin Discovery
Maintained and fixed shell completion routines for Docker CLI plugins under Zsh, ensuring stable automated plugin discovery.
Kanister — Kubernetes Application Data Management
Enhanced Kanister operator Helm chart infrastructure by introducing imagePullSecrets support for air-gapped clusters.
Evidence — BI as Code (Open Source Contribution)
Architected global multi-language system, language switcher, full Italian localization, MetricCard, and FilterPresets for Evidence BI.
Duckle — Workspace Orchestration & Multi-Tenant Data Engine
Engineered dynamic time offset handling in template evaluation and implemented inline config rollups with crash recovery.
Apache Superset · Enterprise Localization, Native Filters & SQLGlot Specs
Upstream contributor to Apache Superset (10 merged PRs, 11 active PRs): Italian localization overhaul, SQLGlot optimizer hints, FilterBar overflow geometry, and db engine specs.
Trino Distributed SQL Engine · Iceberg Row-Level NDV & Optimizer
Upstream contributions to Trino (trinodb/trino): preserved Apache Iceberg NDV column statistics across row-level deletes/updates (#31546) and verified Materialized View refresh semantics (#31130 merged).
WrenAI GenBI Engine · DuckDB Type System & Prompt Sanitization
Merged upstream contributions to Canner/WrenAI (#2753, #2754): expanded DuckDB analytical data type mappings and hardened Jinja2 LLM prompt templates against curly-brace injection.
QuestDB Time-Series Engine & MCP Server · Window Join & Core Fixes
Upstream contributions to QuestDB high-performance time-series database (WINDOW JOIN symbol filter validation, PR #7850) and official QuestDB Model Context Protocol server (PR #7 merged).
Node.js Core Runtime · Readline Unicode Line Separators
Upstream contribution to nodejs/node (PR #66478): implemented opt-in unicodeLineSeparators support (LS U+2028, PS U+2029, NEL U+0085) in node:readline.
Mattermost MS Calendar Plugin · OAuth2 Concurrency & KV Store
Four upstream Go pull requests (#550, #551, #552, #554) to mattermost/mattermost-plugin-mscalendar fixing OAuth2 token refresh race conditions, expiry propagation, and KV storage.
Claude Code & Dragonfly P2P · PowerShell Encoding & OCI Distribution
Upstream contributions to Anthropic Claude Code (PR #65344: Windows PowerShell UTF-8 encoding prevention) and CNCF Dragonfly P2P OCI image distribution.
Automotive & Powertrain Kinematics
7 projectsToyota M15A Connecting Rod — Structural & Kinematic Analysis
Kinematic, dynamic inertia, fatigue (Goodman-Smith), and FEA simulation of the connecting rod for Toyota Yaris Mk4 1.5L.
Yaris HV Battery Cooling Fan Optimizer — CAN/OBD-II Telemetry
Real-time Denso HV battery cooling fan controller, UDS ECU coding suite, Dragy sprint timer, and multi-ECU CAN telemetry for Toyota Yaris Hybrid MK4.
VeloMetric iOS · Predictive Cycling Drivetrain Wear Telemetry
Native iOS Swift application calculating mechanical stress and predictive wear of road cycling drivetrain components from rider power (watts), weather, and elevation gradients.
Bike Garage & Maintenance Suite · Fleet Lifecycle & GPX Analytics
Full-stack web and desktop cycling fleet management suite (bike-garage & Bike-Maintenance-Tracker-Application) for multi-bike component lifecycles, GPX ride ingestion, and service alerts.
GPX Telemetry Editor · Offline Power, Cadence & Elevation Studio
Privacy-first, 100% client-side TypeScript web application for inspecting, repairing, and recalculating GPS tracks, cycling power (watts), speed, and elevation profiles.
BenzaTracker · Multi-Interface Automotive Fuel & Cost Analytics
Multi-interface Python automotive telemetry suite (CLI, Desktop GUI, Flask Web App, SQLite, ReportLab PDF) for tracking real-world vehicle fuel economy, €/km TCO, and price trends.
Desktop Hardware Monitor · Low-Overhead CPU/GPU/RAM Telemetry
Lightweight C# / .NET native desktop telemetry widget interfacing with kernel hardware sensors for real-time CPU, GPU, VRAM, and memory thermal/load monitoring.
Data Science, Radar AI & Stochastic Modeling
8 projectsHailCast-ML — Dual-Polarization Radar Convective Nowcasting
Real-time hail tracking & convective nowcasting platform using open-source radar networks, optical flow, and deep learning.
SIR Epidemiological Model — Discrete-Time Markov Chain
Discrete-time Markov Chain simulation of the SIR epidemiological model with Monte Carlo trajectory analysis.
CI Cervical LBC — Deblurring & Image Restoration
Comparison between Total Variation, UNet, and DiffPIR for the restoration of cervical cytology images (LBC).
SGF² AI — Algorithmic Fairness & SHAP Auditing
Machine Learning on the UCI Adult dataset: income prediction and in-depth investigation of Fairness metrics.
SQL Performance Copilot: Multi-Dialect Query Execution Plan Analyzer
Multi-dialect SQL execution plan analyzer and automated query tuning advisor for Oracle, SQL Server, PostgreSQL, and DB2 healthcare workloads.
Hospital Sanitization Tracker: Healthcare Facility Hygiene Operations
Clinical facility sanitization workflow tracker and infection-control SLA auditing suite for hospital wards and operating theaters.
OpenCode Pro Setup: Multi-Agent AI Engineering & MCP Orchestration
Multi-agent AI engineering harness, Model Context Protocol (MCP) server orchestration, and deterministic verification skills for autonomous software development.
UniBo Computer Engineering & MSc CS: Systems, Compilers & Web Architectures
Consolidated academic engineering suite from Alma Mater Studiorum Universita di Bologna (BSc Computer Engineering & MSc Computer Science): compilers, C/Java systems, and full-stack web architectures.
Enterprise Analytics & Visualization
10 projectsApache Superset 6.1.0 — Hierarchical Table & Matrix Grid Plugin
Enterprise multi-level hierarchical table chart plugin for Apache Superset 6.1.0 with parent-child adjacency, recursive aggregation, and dashboard cross-filtering.
Apache Superset 6.1.0 — Calendar Cross-Filter Chart Plugin
React plugin for Apache Superset: an interactive Calendar Heatmap for temporal exploration and cross-filtering.
Mini Jersey Studio — 3D WebGL Real-Time Graphic Customizer
Interactive 3D WebGL apparel customizer with dynamic planar texture projection, custom GLB import, and Tech Pack export.
TruMetraPla — Industrial Sheet Metal Productivity & KPI Analytics
Python dashboard to monitor productivity in metalworking processes. Automatic calculation of KPIs from raw Excel sheets.
Apache Superset 6.1.0: Stratum Bar Multi-Tier Distribution Plugin
Multi-tier stratified bar chart plugin for Apache Superset 6.1.0 with clinical cohort variance bands, percentage stack normalization, and cross-filtering.
Apache Superset 6.1.0: Stratum Matrix Heatmap & Density Grid
2D stratified density heatmap plugin for Apache Superset 6.1.0 with quantile color clamping, cell-level z-score annotations, and cross-filtering.
Apache Superset 6.1.0: Executive KPI Comparison & Variance Card
Executive scorecard and KPI variance plugin for Apache Superset 6.1.0 featuring YoY/MoM delta badges, sparkline trends, and polarity-aware SLA coloring.
Apache Superset Italian Localization & PO/MO Compilation Pipeline
Automated GNU gettext (.po/.mo) localization pipeline and terminology validation suite for Italian enterprise deployments of Apache Superset.
TPER Bologna Urban Mobility: UUXD Human-Centered Redesign & Accessibility
Human-Centered Design (ISO 9241-210) and WCAG 2.1 AA mobile ticketing & real-time transit redesign for Bologna public transport (TPER).
Sculpted Atlas Portfolio, Spedizioniere & Regalo: WebGL & Logistics Apps
3D WebGL architectural portfolio engine (francescocastaldi.it) alongside full-stack shipping logistics (`spedizioniere`) and event registry (`Regalo`) web applications.
Complete Public GitHub Repository Matrix (36 Monographs / 47 Public Repos)
| # | Monograph / Project | Pillar | Affiliation / Track | Primary Stack | GitHub Repository | Specification |
|---|---|---|---|---|---|---|
| 01 | Docker CLI | I · upstream | Healthcare IT & Enterprise BI | Go, Zsh, Docker | docker/cli | Folio → |
| 02 | Kanister (CNCF) | I · upstream | Healthcare IT & Enterprise BI | Kubernetes, Helm, Go | kanisterio/kanister | Folio → |
| 03 | Evidence (BI as Code) | I · upstream | Healthcare IT & Enterprise BI | Svelte, TypeScript, SQL | evidence-dev/evidence | Folio → |
| 04 | Duckle Orchestration | I · upstream | Healthcare IT & Enterprise BI | DuckDB, Python, SQL | slothflowlabs/duckle | Folio → |
| 05 | Apache Superset | I · upstream | Healthcare IT & Enterprise BI | Python, Flask, React | apache/superset | Folio → |
| 06 | Trino SQL Engine | I · upstream | Healthcare IT & Enterprise BI | Java, Trino, Apache Iceberg | trinodb/trino | Folio → |
| 07 | WrenAI GenBI | I · upstream | Healthcare IT & Enterprise BI | Python, GenBI, Text-to-SQL | Canner/WrenAI | Folio → |
| 08 | QuestDB & MCP | I · upstream | Healthcare IT & Enterprise BI | Java, Python, QuestDB | questdb/questdb | Folio → |
| 09 | Node.js Core | I · upstream | Healthcare IT & Enterprise BI | JavaScript, Node.js, V8 | nodejs/node | Folio → |
| 10 | Mattermost MS Calendar | I · upstream | Healthcare IT & Enterprise BI | Go, Mattermost, OAuth2 | mattermost/mattermost-plugin-mscalendar | Folio → |
| 11 | Claude Code & Dragonfly | I · upstream | Healthcare IT & Enterprise BI | TypeScript, PowerShell, UTF-8 | anthropics/claude-code | Folio → |
| 12 | Toyota M15A Connecting Rod | II · automotive | Healthcare IT & Enterprise BI | CAD, FEA, Kinematics | FrancescoCastaldi/toyota-m15a-connecting-rod | Folio → |
| 13 | Yaris HV Fan Optimizer | II · automotive | Healthcare IT & Enterprise BI | Android, Kotlin, Jetpack Compose | FrancescoCastaldi/yaris-hv-fan-optimizer | Folio → |
| 14 | VeloMetric iOS | II · automotive | Healthcare IT & Enterprise BI | Swift, iOS, SwiftUI | FrancescoCastaldi/VeloMetric | Folio → |
| 15 | Bike Garage Suite | II · automotive | Healthcare IT & Enterprise BI | TypeScript, React, Python | FrancescoCastaldi/bike-garage | Folio → |
| 16 | GPX Telemetry Editor | II · automotive | Healthcare IT & Enterprise BI | TypeScript, GPX, Cycling Power | FrancescoCastaldi/gpx-editor | Folio → |
| 17 | BenzaTracker | II · automotive | Healthcare IT & Enterprise BI | Python, SQLite, Flask | FrancescoCastaldi/BenzaTracker | Folio → |
| 18 | Hardware Monitor Widget | II · automotive | Healthcare IT & Enterprise BI | C#, .NET, WPF | FrancescoCastaldi/Desktop-Hardware-Monitor-Widget | Folio → |
| 19 | HailCast-ML | III · data-science | Healthcare IT & Enterprise BI | Python, Machine Learning, Computer Vision | FrancescoCastaldi/hailcast-ml | Folio → |
| 20 | SIR Markov Chain | III · data-science | Healthcare IT & Enterprise BI | Python, NumPy, Matplotlib | FrancescoCastaldi/sir-markov-chain | Folio → |
| 21 | CI Cervical LBC | III · data-science | Healthcare IT & Enterprise BI | Python, PyTorch, DiffPIR | FrancescoCastaldi/ci-cervical-lbc | Folio → |
| 22 | SGF² AI | III · data-science | Healthcare IT & Enterprise BI | Python, scikit-learn, pandas | FrancescoCastaldi/SGF2--AI-PROJECT | Folio → |
| 23 | SQL Performance Copilot | III · data-science | Healthcare IT & Enterprise BI | SQL, Oracle, SQL Server | FrancescoCastaldi/sql-performance-copilot | Folio → |
| 24 | Hospital Sanitization Tracker | III · data-science | Healthcare IT & Enterprise BI | Healthcare IT, Hospital Operations, TypeScript | FrancescoCastaldi/HospitalSanitizationTracker | Folio → |
| 25 | OpenCode Pro Setup | III · data-science | Open Source / Engineering Lab | AI Agents, MCP, TypeScript | FrancescoCastaldi/opencode-pro-setup | Folio → |
| 26 | UniBo CS & Engineering Lab | III · data-science | UniBo (BSc Eng / MSc CS) | Java, C, ANTLR | FrancescoCastaldi/NeoSlither | Folio → |
| 27 | Superset Hierarchical Table | IV · analytics | Healthcare IT & Enterprise BI | TypeScript, React, Apache Superset | FrancescoCastaldi/superset-plugin-chart-hierarchical-table | Folio → |
| 28 | Superset Calendar | IV · analytics | Healthcare IT & Enterprise BI | Superset, TypeScript, React | FrancescoCastaldi/superset-plugin-chart-calendar-filter | Folio → |
| 29 | Mini Jersey Studio | IV · analytics | Healthcare IT & Enterprise BI | Three.js, WebGL, TypeScript | FrancescoCastaldi/mini-jersey-studio | Folio → |
| 30 | TruMetraPla | IV · analytics | Healthcare IT & Enterprise BI | Python, Data Analysis, Dashboard | FrancescoCastaldi/TruMetraPla | Folio → |
| 31 | Superset Stratum Bar | IV · analytics | Healthcare IT & Enterprise BI | Apache Superset, TypeScript, React | FrancescoCastaldi/superset-plugin-chart-stratum-bar | Folio → |
| 32 | Superset Stratum Heatmap | IV · analytics | Healthcare IT & Enterprise BI | Apache Superset, TypeScript, React | FrancescoCastaldi/superset-plugin-chart-stratum-heatmap | Folio → |
| 33 | Superset KPI Comparison | IV · analytics | Healthcare IT & Enterprise BI | Apache Superset, TypeScript, React | FrancescoCastaldi/superset-plugin-chart-kpi-comparison | Folio → |
| 34 | Superset Translator ITA | IV · analytics | Healthcare IT & Enterprise BI | Python, Apache Superset, i18n | FrancescoCastaldi/Superset-Translator-ITA | Folio → |
| 35 | TPER Accessible Mobility UX | IV · analytics | UniBo (BSc Eng / MSc CS) | UX/UI Design, Human-Centered Design, WCAG Accessibility | FrancescoCastaldi/Esame-UUXD | Folio → |
| 36 | Logistics & Portfolio Hub | IV · analytics | Open Source / Engineering Lab | Next.js, Three.js, TypeScript | FrancescoCastaldi/portfolio-tracker | Folio → |
Expertise & Disciplines
Relational constellation mapped directly from shared engineering projects. No arbitrary proficiency percentages.
Open Source Software Engineering
Active upstream contributor to enterprise open-source platforms including Apache Superset, Trino, Evidence, WrenAI, QuestDB, Node.js, Mattermost, Docker CLI, Kanister, and Duckle.
Automotive Systems & Kinematics
Hybrid powertrain OBD-II/CAN bus telematics, fuel consumption analytics, hardware sensor monitoring, and reciprocating engine kinematics.
Data Science & Analytics
Statistical modeling, distributed SQL engines, AST query optimization, BI-as-code, and enterprise Apache Superset visualization plugins.
Artificial Intelligence & Computer Vision
MSc Computer Science (LM Informatica, UniBo) research in PyTorch deep learning, medical image restoration (UNet/DiffPIR), fairness auditing, Text-to-SQL GenBI, and multi-agent AI orchestration.
Full-Stack & WebGL Development
Building high-performance interactive web applications and BI plugins with TypeScript, React, Next.js, Three.js/WebGL, Svelte, and Tailwind CSS.
Cloud Native, Kubernetes & DevOps
Kubernetes operators, Helm charts, Docker CLI tooling, distributed P2P OCI registries, Go concurrency, and CI/CD automation.
Cycling Telematics & Wear Analytics
Predictive drivetrain wear modeling on iOS, fleet maintenance tracking, GPX power/elevation editing, and 3D cycling apparel customization.
Hardware Hacking & Reverse Engineering
CAN bus protocol decoding, ISO-TP multi-frame reassembly, UDS diagnostic manipulation, and low-level kernel hardware sensor telemetry.
Healthcare Information Technology & BI Consulting
Healthcare Business Consulting, clinical KPI data warehouses, Apache Superset hospital dashboards, cytology computer vision, and smart-contract sanitization tracking.
Blockchain & Smart Contract Engineering
Immutable audit trail engineering with Solidity smart contracts, Hardhat testing suites, Ethereum EVM deployment, and Ethers.js integration.
Healthcare Business Consulting & UX Architecture
Enterprise BI requirement engineering, Double Diamond UX design (SUS usability auditing), executive KPI storytelling, and digital transformation.
Initiate Technical Dialogue
Available for Healthcare Business Consulting, Enterprise BI & Apache Superset architectures, upstream open-source contributions, and AI systems engineering.