DATA ANALYSIS · AUTOMATION · EXCEL · SQL
Understand the data. Automate the rest.
Data analysis, automation and small software tools for turning repetitive work and complex data into simpler, more controlled processes.
SELECTED PROJECTS
Transit snapshots ↗
Reconstructing the history of operational records in a compact diagnostic interface.
Remote Flow Monitor ↗
Turning read-only SSH checks into a repeatable operational control.
Excel Add-ins ↗
Reusable Excel tools that separate recurring logic from individual workbooks.
LATEST NOTES
Excel as a front-end for Oracle: when it makes sense ↗
When Excel is a useful interface and when it is starting to become a parallel database.
Power Query beyond data import ↗
Thinking in terms of repository, transformation, control and output instead of a single import step.
ABOUT
I work with data and operational processes, usually starting from something that already exists and needs to become more understandable, repeatable or maintainable.