clientAutomation consultant

Data Search Automation

Python automation for a European energy broker — aggregates trading counterparty lists from multiple Excel files into a unified searchable database.

Replaced a repetitive spreadsheet search with one searchable workflow

PythonPandasExcelAutomation

The problem

Counterparty data was distributed across multiple spreadsheets, making recurring lookup and consolidation slow and error-prone.

What I built

Built a Python and Pandas workflow that aggregates the source files into a unified searchable dataset.

Reliability and safeguards

Preserved the source inputs and made the transformation repeatable instead of relying on manual copy-and-paste.

Outcome

The owner recalls a reduction from roughly 20 hours a week to roughly 20 minutes, but the measure cannot now be independently reconstructed and is therefore presented only as an estimate.