Data Processing

15 projects.

Other categories

Multimodal LLM Alt-Text Generation for an Ecommerce Catalog

I built an automation to create SEO-focused product image alt text for thousands of images.

OpenAI API
Prompt Engineering
Multimodal
API Development
Python

Analysis and Reporting for Longitudinal Intervention Study

I conducted an analysis of longitudinal intervention data that delivered a client-ready report with figures in a Jupyter notebook.

Statistical Analysis
Python
pandas
Longitudinal Analysis
Data Visualization

Combining Segmented Dataset Across Several Years into One Spreadsheet

I combined multi-year research datasets into a canonical dataset, then generated random samples of control and experimental groups.

pandas
MySQL
Python

Data Matching & Deduplication Across 10.8M Rows

I cleaned and matched 10.8 million records using PostgreSQL and refined logic to improve accuracy.

Python
PostgreSQL
Data Cleaning
Data Engineering

Data Migration via API Integration

I built an API-based migration toolkit and used it to migrate data from one CRM to another.

Python
PostgreSQL
MongoDB
API Integration

Data Mining for Offer Data from Procurement Chat Logs

I built a tool to parse purchasing department chat logs, extract offers made by outside salespeople, and summarize them in a financial spreadsheet.

Data Mining
Python
Data Cleaning
pandas

XML Lead Generation with LLM-Normalized Title Data

I processed 107 MB of XML public records to extract corporate officer data and deliver it as a lead list spreadsheet.

PostgreSQL
XML
pandas
JSON

Refined Python-MySQL Algorithm Performance Across 2.8M Rows

I optimized a Chinese text processing algorithm across millions of database rows, reducing runtime from 19 hours to 2.5 hours.

Python
MySQL

Sync Student Data Between Legacy System and Its Replacement

I built a sync tool to map data between a legacy student info system and its modern replacement to allow them to operate in parallel.

Python
API Development
Data Processing
Data Engineering

Auto Parts Data Formatter

I built a tool for transforming automotive fitment data into structured catalogs, which also identifies missing and inconsistent source records.

Python
pandas

Data Analysis of Call Logs

I analyzed law firm call logs to assess staffing needs and evaluate agent performance.

Python
Data Analysis
Data Wrangling

Campaign Reconciliation Pipeline with Multi-Source Matching

I built a pipeline for reconciling multi-source marketing data and delivering a unified dataset.

Python
Data Engineering
Docker

Dockerized Marketing Analytics Pipeline with Staged Execution and Run Inspection

I built an AWS-hosted marketing pipeline with staged processing, reproducible execution, and detailed reporting.

Python
pandas
Docker

Multi-Pipeline Ingestion Platform

I built an ETL platform that ingests files via webhooks, and supports multiple processing pipelines. It features replay, checkpointing & resume.

Python
FastAPI
Data Engineering
API Development

Shopify Inventory Reporting Pipeline with Google Sheets

I built an inventory-processing pipeline based on the Shopify Admin API. It generates risk forecasts, reorder recommendations, and reports in Google Sheets.

Shopify
Python
Google Sheets
Docker
REST API

Need this done?

What I do →