Skip to content
View FrancescoCastaldi's full-sized avatar
🎯
Life is Racing, Racing is Life.
🎯
Life is Racing, Racing is Life.

Organizations

@trinodb

Block or report FrancescoCastaldi

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
FrancescoCastaldi/README.md
Francesco Castaldi — Computer Science Engineer
Website Email

Computer Science Engineer · Business Consultant at Maps Healthcare S.p.A.
MSc Informatics for Management — University of Bologna

I build analytics platforms, measurement systems and engineering tooling —
and contribute the same work upstream, where it is reviewed by people who know better.

I — Open Source

Where my work goes through public review. Counts link to the live pull request list for each project.


Project Domain My pull requests
apache / superset Enterprise data exploration & visualization 8 merged · 7 in review
mattermost / mattermost-plugin-mscalendar Microsoft 365 calendar integration 1 in review
Canner / WrenAI Conversational GenAI agent for Text-to-SQL 1 merged · 1 in review
evidence-dev / evidence Business intelligence as code 5 in review
trinodb / trino Distributed SQL query engine 1 merged
slothflowlabs / duckle Workspace orchestration & template engine 2 merged
docker / cli Docker command-line interface 1 merged
kanisterio / kanister Data management for Kubernetes 1 in review
anthropics / claude-code Agentic command-line coding assistant 1 in review

Apache Superset is where most of that upstream work lives — query correctness, engine metadata, visual plugin sorting, and the Italian localization:

  • #44464  ·  added sorting by metrics and groupby in the MCP XY chart plugin (fix/mcp-xy-chart-sort-by, all CI green)
  • #43584  ·  moved optional icons outside the label element in Explore
  • #43565  ·  preserved optimizer hints when formatting semicolon-terminated SQL
  • #43586  ·  set the default catalog on datasets created from file uploads
  • #43274  ·  brought the Italian translation to full coverage with placeholder validation

Alongside it: · Mattermost #550: fixed event time formatting (space between time and AM/PM, Issue #318) in Microsoft Calendar plugin with unit tests — CodeRabbit AI review approved, CLA verified, qualifies for Contributor Mug.
· WrenAI #2753 (merged) & #2754: exposed Cube orderBy in the WASM TypeScript SDK (Issue #2700) and safeguarded multiline subquery wrap against trailing comment swallowing in SQL dialect generation (Issue #2733).
· Evidence (5 in review): architected an i18n localization system with LanguageSelector, and built <MetricCard>, <FilterPresets>, and interactive cross-filtering.
· Trino #31130 (merged): corrected terminology and documentation inconsistencies.
· Docker CLI #7250 (merged): resolved Zsh completion arithmetic evaluation errors.
· Kanister #4192: introduced imagePullSecrets support into the operator Helm chart.
· Duckle #275 & #276 (merged): engineered dynamic time offsets and resilient active job crash recovery.

II — Selected Work

Public repositories and engineering systems, most recent first.


Project What it is Built with
portfolio-tracker Real-time portfolio intelligence (v1.3.2): Gemini 3.5 Flash Lite commentary, HMAC-authenticated dispatch triggers, Vercel serverless TypeScript, Gemini AI, Vercel
CheckLensRB Multivariate tracking service (v1.2.0) with serverless edge API, dynamic status routing, and automated parcel monitoring TypeScript, Serverless
mini-jersey-studio 3D cycling jersey customizer: SVG-to-WebGL planar projection, GLB import, tech-pack export Three.js, WebGL
ci-cervical-lbc Computational imaging on cervical LBC slides: total-variation vs. U-Net vs. diffusion Jupyter, PyTorch
toyota-m15a-connecting-rod Connecting-rod design for the Yaris Mk4 1.5L: inertia, Goodman-Smith fatigue, FEM convergence Python, CAD, FEM
VeloMetric Predictive wear analytics for road bikes — drivetrain decay from ride telemetry Swift
TruMetraPla Productivity intelligence for metalworking shop floors, from spreadsheet to KPI dashboard Python, Streamlit
Esame-UUXD TPER transport portal redesign — Double Diamond, +35 SUS points (72.5), 80% task completion UX Research
sir-markov-chain SIR epidemic model as a discrete-time Markov chain, with Monte Carlo trajectories Jupyter, NumPy
gpx-editor Browser-based GPX editor for power and speed traces — fully offline JavaScript

Specialized tooling & data infrastructure: · Stratum Suite includes stratum-bar (v0.3.8 with outlier pinning & 3D isometric engine), calendar-filter (native dashboard cross-filter with date range broadcasting), stratum-heatmap, hierarchical-table, and kpi-comparison.
· Developer Swag Toolchain: Automated outreach dispatcher with Aruba SMTPS, rate-limiting, and IMAP Sent mailbox synchronization.
· Healthcare DWH & ETL Automation: High-throughput ETL engines (Sirio / SISMART), star schema dimensional modeling, indexed view materialization, and sub-second analytical dashboard responsiveness for hospital clinical operations.

III — Toolkit

Area Tools
Languages Python  ·  TypeScript  ·  JavaScript  ·  Go  ·  Rust / WASM  ·  SQL  ·  Java  ·  C#  ·  Swift  ·  Bash
Data & BI Apache Superset  ·  Trino  ·  WrenAI  ·  Evidence  ·  SQLGlot  ·  PostgreSQL  ·  DuckDB  ·  SQL Server  ·  Pandas
Frontend & Viz React  ·  Svelte  ·  Three.js / WebGL  ·  ECharts  ·  Streamlit  ·  Tailwind CSS
AI & Machine Learning Google Gemini API  ·  PyTorch  ·  scikit-learn  ·  OpenCV  ·  Jupyter
Systems, Cloud & CI Docker  ·  Kubernetes  ·  Helm  ·  Vercel Serverless  ·  GitHub Actions  ·  Linux  ·  Git
Engineering & Kinematics SolidWorks  ·  ANSYS FEM  ·  Dynamic Simulation  ·  LaTeX

IV — Activity

GitHub statistics Most used languages Contribution activity over the last year
Francesco Castaldi  ·  Modena, Italia  ·  francescocastaldi.it

Pinned Loading

  1. HospitalSanitizationTracker HospitalSanitizationTracker Public

    DApp for tracing sanitization activities in hospitals using blockchain technology - Project for Blockchain and Cryptocurrencies course

    JavaScript

  2. Superset-Translator-ITA Superset-Translator-ITA Public

    Superset-Translator-ITA

    Python

  3. ci-cervical-lbc ci-cervical-lbc Public

    Computational Imaging project – Deblur & Denoise on Mendeley LBC Cervical Cancer dataset. Comparison of TV, UNet and DiffPir methods.

    Jupyter Notebook

  4. Esame-UUXD Esame-UUXD Public

    TPER Website Redesign — UX Design project. Double Diamond methodology, usability testing, interactive prototype (22 pages). Course project for User Experience Design, UniBo.

    HTML

  5. sir-markov-chain sir-markov-chain Public

    Simulazione di un modello epidemiologico SIR come catena di Markov a tempo discreto - Progetto universitario Modelli Probabilistici (Unibo)

    Jupyter Notebook