At SCA, manual data entry and formatting across XML web sources, Excel reports, and Access databases consumed hours of employee time and introduced data inconsistency.
Developed a suite of Python automation scripts to scrape and restructure XML web data (using libraries like Gazpacho), automate Excel data merging, and instantly execute precise updates in Access databases via simple ID inputs.