A collection of projects that showcase my skills in R developement, automation and data wrangling
A comprehensive municipal energy reporting program for a Swiss canton that processes approximately 30 datasets to generate customized PDF reports for tens of municipalities. The system supports municipal climate policy implementation through annual public energy performance reports.
Contributed to redesigning the data pipeline architecture, then took full ownership of optimizing and maintaining the system. Became sole maintainer responsible for annual delivery of reports after three iterations.
High-performance data processing infrastructure for a central bank's forecasting division to efficiently analyze massive transaction datasets.
Architected data processing solutions using Apache Arrow to enable efficient analysis of large-scale financial transaction data. Refactoring of analysis scripts using the tidyverse.
Backend architecture redesign for a government data submission platform handling public entity expense data uploads.
Redesigned the R backend data validation architecture from sequential to recursive processing, significantly improving platform user experience for data submissions.
An extension to an existing municipal energy reporting system that expands capabilities from municipal-level to building-level energy assessments for a Swiss canton, supporting canton-wide energy efficiency initiatives and climate policy implementation.
Implemented stakeholder requirements and guidelines to extend the system's energy reporting capabilities to include individual building analysis.
A specialized training workshop on seasonal adjustment methodology (X-13ARIMA-SEATS) for central bank economists in the forecasting division.
Served as technical assistant to Christoph Sax, developing and packaging R-based time series analysis tools and educational materials for workshop participants.
Comprehensive R programming training program for a North African central bank, aimed at building internal analytics capabilities across multiple departments. The program combined foundational skills with practical applications using real-world data from Tunisia's agricultural sector.
Delivered 8 remote training sessions to 27 employees across 6 departments. Designed curriculum covering foundational R skills (dplyr, ggplot2) with practical case studies using web scraping and API integration. Established data analysis workflows and Git/GitHub practices for collaborative development.
Implementation of comprehensive multilingual support across a Swiss governmental office's internal R package ecosystem to serve Switzerland's diverse linguistic regions (Italian, English, German, and French).
Contributed to implementing multilingual support features, enabling error messages and user communications in multiple languages.
Frontend development for a government data submission platform requiring improved user experience, form validation, and modern design system integration.
Enhanced Angular TypeScript frontend by implementing smart form state management, improved error display with individual validation messages, redesigned dry-run workflow with persistent results, and upgraded to Angular 17 with Oblique 11 design system.
Performance optimization project for a Shiny application's project management dashboard with Gantt chart visualization for tracking project deliverability.
Optimized Plotly rendering performance in the Gantt chart visualization, significantly reducing execution time and improving user experience.
Developed a R package providing native interface to Stripe's REST API, enabling direct data retrieval and workflow automation for financial analytics. Implements key GET methods for payments and customers data with R-native data structures.
Developed an R package providing seamless integration with Postmark's email delivery API, enabling automated template-based email campaigns and messaging. Currently used in production at nutrivetpet for streamlined customer communication workflows.
Contributing to core R packages across the tidyverse and broader R ecosystem.
Minor contributions to {tibble}, {duckplyr}, {plumber2}, {seasonal}, and {constructive}.
Conducted comprehensive analysis of Italian economics professor Michele Boldrin's YouTube channel using API data extraction and natural language processing. Applied Latent Dirichlet Allocation (LDA) algorithm to auto-generated transcripts from 600+ videos to identify main topics and validate against declared channel themes. Integrated quantitative metrics (views, engagement) with text mining techniques to analyze content patterns and audience response.
Developed advanced risk factor model for US Government bond portfolios using principal component analysis of yield curve dynamics. Applied PCA to decompose interest rate movements into level, slope, and curvature components, enabling portfolio immunization strategies that account for non-parallel yield curve shifts. Conducted bootstrap analysis of eigenvalues and eigenvectors to investigate empirical distributions and model robustness, providing superior risk management compared to traditional duration-based measures.
R-based data processing pipeline powering a Swiss canton's public-facing climate and energy dashboard, integrating renewable energy data, projections, and energy statistics through API endpoints.
Served as maternity leave substitute, maintaining and enhancing the data pipeline. Managed complex data workflows including renewable energy data integration, projections, data patching systems, and API endpoint maintenance.
Full-day workshop on R database integration at posit::conf(2024) in Seattle, covering DBI, duckdb, dbplyr, and SQL workflows.
Assisted Kirill Müller with preparation of the workshop by reworking existing materials and developing new content including exercises and DuckDB content. Provided technical support and answered participant questions during hands-on sessions.
Half-day data analytics workshop for economists and data analysts at a Swiss financial institution, covering modern R tools for data analysis.
Provided workshop support, contributing exercise solutions and facilitating technical discussions with participants.
Personalized training on data visualization techniques using ggplot2 for a Swiss financial institution employee.
Designed and delivered personalized {ggplot2} training curriculum. Created tailored materials from scratch and conducted one-on-one instruction.
Comprehensive R package for analyzing tuberculosis diagnostic gaps globally, integrating data from WHO, World Bank, and Global Fund to harmonize TB surveillance data across countries and years. The platform enables comparison of high-burden vs. non-high-burden countries and detection of data quality issues for WHO guideline compliance.
Led development of the R package and analytical framework. Built automated data pipeline integrating multiple APIs to harmonize TB surveillance data. Designed analytical framework to compute DX Gap metrics.
Comprehensive R programming bootcamp covering advanced topics including foundational R objects, data manipulation, metaprogramming, S3 object-oriented programming, package development, reproducible research workflows, debugging, version control, defensive programming, and professional coding practices.
Assisted in delivering bootcamp sessions, providing technical support and guidance to participants on advanced R programming concepts.
Enterprise pricing automation system (R package) to streamline reseller operations by replacing manual spreadsheet workflows with automated quote generation and reporting capabilities.
Work on the pricing automation system, supporting the transition from manual spreadsheet workflows to automated quote generation and reporting.
Architected and developed a comprehensive suite of internal R packages for pet nutrition startup, covering financial analytics, automated reporting, database interactions, email notification systems, and core nutrition algorithm prototyping.
Built modular ecosystem enabling data-driven operations.
Implemented Story Brand framework methodology to redesign and optimize nutrivetpet's landing page, increasing conversion rate within 1.5 months.
Implemented comprehensive legal framework for pet nutrition platform including Terms of Service, Privacy Policy, and Cookie Policy pages using NextJS. Collaborated with legal counsel to ensure accurate translation of legal requirements into user-friendly web interfaces, ensuring GDPR compliance and transparent data handling practices for Italian pet owners.
Developed data-driven pricing model for advertisement spaces combining observed platform data including product share metrics with strategic assumptions.
Contributed to automated data processing pipeline for European Commission HR surveys across European Union agencies. Developed Python-based solutions to transform raw survey data into standardized reports, streamlining the analytical workflow and reducing manual processing time for multi-agency human resources assessments.
Automated reporting framework for a national weather service's cloud monitoring operations, transforming meteorological data into publication-ready reports with precise formatting requirements for official documentation standards.
Developed foundational R-to-LaTeX reporting framework. Built foundations for automated table generation system that transforms meteorological data into highly customized, publication-ready reports.
Developed automated payment control system for an Italian property management company, integrating bank statement data with XML invoice records to identify outstanding payments. Built R-based reconciliation engine that cross-references financial transactions with billing data, reducing manual accounts receivable processing and improving cash flow management.
Website developement and CI/CD pipeline implementation for automated website build.
I'm always open to discussing new projects and opportunities. Let's create something amazing together!