Home·About·Portfolio

Portfolio

Selected projects across client work, open source, training, and personal research.

Projects


····

Large-Scale Financial Data Processing - cynkra GmbH

2023 – 2024

R, Arrow, tidyverse

Apache Arrow–based infrastructure for analysing massive transaction datasets at a central bank's forecasting division.

Municipal Energy Reporting System - cynkra GmbH

2022 – 2025

R, LaTeX, Microsoft SQL Server, {dm}

R-to-LaTeX pipeline generating customised PDF energy reports for 200+ municipalities; sole maintainer after the redesign.

Climate & Energy Data Pipeline - cynkra GmbH

2024

R, {plumber}, Apache Arrow

R backend powering a Swiss canton's public climate and energy dashboard — data integration, projections, and API maintenance.

TB Diagnostic Gap Analysis Platform - cynkra GmbH

2024 – 2025

R, tidyverse

Lead developer on an R package harmonising tuberculosis diagnostic data from WHO, World Bank, and Global Fund sources.

Building Energy Assessment Extension - cynkra GmbH

2024

R

Extended a municipal reporting system from municipality-level to building-level energy assessments across a Swiss canton.

Data Validation System Optimization - cynkra GmbH

2023

R

Redesigned a government data submission platform's R validation backend from sequential to recursive processing.

File Upload Platform UI/UX Enhancement - cynkra GmbH

2023

Angular, TypeScript, Oblique

Angular/TypeScript frontend work on a government file-upload platform — form state, validation UX, Angular 17 upgrade.

Multilingual R Package Ecosystem - cynkra GmbH

2023

R, {potools}

Added multilingual (IT/EN/DE/FR) support across an internal R package ecosystem for a Swiss governmental office.

Plotly Performance Optimization - cynkra GmbH

2023

R, Shiny, Plotly

Optimised Plotly Gantt-chart rendering in a Shiny project-management dashboard, substantially cutting execution time.

Automated Cloud Monitoring Reports - cynkra GmbH

2022

R, LaTeX

Foundational R-to-LaTeX reporting framework producing publication-ready cloud monitoring reports for a weather service.

Payment Reconciliation Automation - Magicondominio SRL

2021

R, XML

R engine cross-referencing bank statements with XML invoice records to flag outstanding payments for an Italian property manager.

Landing Page & CI/CD - Magicondominio SRL

2022

Astro, React, TypeScript, Netsons

Astro/React landing page and CI/CD pipeline for an Italian property management company.

HR Survey Data Processing - Intellera Consulting

2022

Python

Python pipeline transforming raw European Commission HR survey data into standardised multi-agency reports.

postmarkr - R Interface to Postmark API - nutrivetpet

2024

R, {httr2}

Open-source R package wrapping the Postmark email API; used in production at nutrivetpet for automated campaigns.

striper - R Interface to Stripe API - nutrivetpet

2024

R, {httr2}

Open-source R package providing a native R interface to the Stripe REST API for financial analytics.

Open Source R Ecosystem Contributions - cynkra GmbH

2022 – 2025

R

Minor contributions to the R open-source ecosystem: {tibble}, {duckplyr}, {plumber2}, {seasonal}, and {constructive}.

R for Databases - cynkra GmbH

2024

{DBI}, {duckdb}, {dbplyr}, {duckplyr}, SQL

Co-taught a full-day posit::conf(2024) workshop on R database integration; developed new DuckDB exercises.

R Analytics Training Program - cynkra GmbH

2023

R, {dplyr}, {ggplot2}, {rvest}, {httr2}, git

Designed and delivered an 8-session R analytics curriculum for 27 employees of a North African central bank.

Seasonal Adjustment Workshop - cynkra GmbH

2023

R, {seasonal}, X-13ARIMA-SEATS

Built R-based seasonal-adjustment tools and educational materials on X-13ARIMA-SEATS for central bank economists.

Advanced R Programming Bootcamp - cynkra GmbH

2024

R

Assisted delivery of an advanced R bootcamp: metaprogramming, S3 OOP, package development, and reproducible workflows.

Custom Data Visualization Training - cynkra GmbH

2023

R, {ggplot2}

Bespoke one-on-one ggplot2 training designed and delivered for an employee of a Swiss financial institution.

YouTube Channel Analytics & Topic Modeling

2020

R

LDA topic-modelling of an Italian economics professor's 600-video YouTube channel with engagement-metric integration.

PCA for Yield Curve Risk Modelling - MSc Thesis

2020

R

MSc thesis applying PCA to US yield-curve dynamics; decomposed rate movements into level, slope, and curvature factors.

Internal R Package Ecosystem - nutrivetpet

2023 – Present

R, {dm}, {dbplyr}, {DBI}, Quarto, Typst

Modular internal R package ecosystem for financial analytics, reporting, databases, email, and nutrition algorithms.

nutrivetpet.com - nutrivetpet

2023 – Present

Next.js, TypeScript, Tailwind CSS

Co-founded platform calculating individualised pet diets; Next.js/TypeScript site with Story Brand landing page.

Startup vs. Job - Expected-Value Decision Model

2026

React, TypeScript, Vite, Recharts, Vitest

Interactive decision calculator comparing a bootstrapped startup path against a salaried job under expected-value, logistic revenue ramp, and sensitivity analysis.

Headless Shopify Storefront - nutrivetpet

2026

Next.js, TypeScript, Shopify Storefront API, Tailwind CSS

Headless Next.js storefront over Shopify for the nutrivetpet supplement and pet food line.

Competitor & Pricing Analysis - nutrivetpet

2026

Market research, Pricing modelling, Unit economics

Competitor evaluation and margin modelling to set retail prices for two Shopify-launched pet supplements.

Monte Carlo Profit Simulation & Pricing Grid Search - nutrivetpet

2025

Rust, Monte Carlo simulation, Grid search, Binomial sampling, Unit economics

Rust port of an R profit model that runs Monte Carlo simulations across a price × purchase-rate grid to find pricing strategies maximising expected profit and probability of ROI.

Instagram Growth Modelling for Sponsorship Pricing

2024

R, Time series forecasting, Instagram data, Pricing modelling

R package modelling Instagram follower growth to price sponsored-content collaborations for a veterinary influencer based on projected reach at contract delivery.

© 2026 Andrea Ranzato·github·linkedin