Dylan K. Picart

Projects

Listed below are both my individual and collaborative projects

Building a DevSecOps-Ready GCP ETL Pipeline for Multi-Year Google Sheet Survey Analysis

Data Analysis · Data Engineering

A behind-the-scenes look at how I engineered a secure, reproducible, analytics-ready GCP ETL pipeline that automates the ingestion and transformation of multi-language Google Sheet survey data; blending YAML preprocessing, Google API integration, data auditing, and DevSecOps principles into one cohesive system.
Read More
Querying NYSED School Data in Microsoft Access Using SQL: Graduation, ELA, and Math Insights

Data Engineering

Learn how to use SQL in Microsoft Access to query NYSED education data for specific schools. This guide walks through real-world examples for filtering, joining, unions, and ordering datasets to analyze graduation rates and 3–8 ELA and Math exam performance. Ideal for data analysts, educators, and researchers seeking to turn public data into actionable insight.
Read More
From Chaos to Clarity: A Lightweight Multilanguage ETL Pipeline for Excel <-> SharePoint Integration

Data Engineering

A practical, human-centered data migration framework that blends Python, Bash, and JavaScript to automate the transition across SaaS platforms. Designed to make complex data accessible, secure, and easy to navigate for everyone.
Read More