ESG Live Survey (OSU)

Toward the end of the government-funded project, I was asked to help design an ESG survey workflow for end users. I met with the development manager and our resident ESG expert — a professor from Purdue — to understand the requirements.

Due to time-constraints, the original plan was to distribute an Excel spreadsheet that users would fill out and upload for parsing into a database. Having built similar systems before, I immediately recognized the risks: complex spreadsheet logic, non-intuitive design, and heavy denormalization — a brittle solution waiting to happen.

I proposed instead that we build a true full-stack application — essentially a no-code survey builder that allowed administrators to define questions with custom data types for answers, create spreadsheet-like formulas, and test in real time through a Live Preview mode. What would typically take 5–10 weeks, I built in just two weeks using Claude Code as a development assistant.

The result was a turn-key, extensible ESG Survey Builder that replaced an error-prone spreadsheet workflow with a scalable, maintainable web app.