Data Analytics Engineering, Data Science, Machine Learning
Empowering Change through AI & Automation
Data Analytics Engineer & Scientist with a passion for tackling complex socioeconomic & environmental issues while making data accessible.
My Work
-
Building a DevSecOps-Ready GCP ETL Pipeline for Multi-Year Google Sheet Survey Analysis
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…
-
From Chaos to Clarity: A Lightweight Multilanguage ETL Pipeline for Excel <-> SharePoint Integration
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…
-
Automating NYC InfoHub Data Collection with an Intelligent Excel Web Scraper
A look at how intelligent web scraping, concurrency, and security checks turn NYC InfoHub’s sprawling maze of Excel datasets into a fast, verifiable, and human-accessible data repository.
-
Why Microsoft VBA Still Matters: Automating Data Workflows in Excel with Visual Basic
Discover why Microsoft VBA still matters in 2025. Learn how simple Excel macros can automate data workflows, streamline reports, and empower nonprofits and education teams with real-world Visual Basic examples.
-
Regression Analysis for SARS-CoV-2 RNA Concentrations in NYC Wastewater
An analysis of the trends of SARS-CoV-2 RNA concentrations in NYC wastewater during the height of the COVID-19 pandemic that uses API Building, SQLite for database creation, manipulation, and storage,…
-
Evaluating authenticity and quality of image captions via sentiment and semantic analyses
This study explores how sentiment and semantic variance analyses can be used to assess the quality of image captions in large datasets like COCO. By examining how human-generated captions reflect…
-
Student Adaptability Level Classifier in Online Education
An extensive Exploratory Data Analysis using Python, Pandas and matplotlib, explored Supervised Machine Learning Models using scikit-learn and binary classification methods to train, modify, and evaluate the ability for students…
Dylan K. Picart 