Workplace project & browser demo
Address Migration Toolkit
A Python toolkit that turns mixed address records into structured migration data and a review queue. The browser demo runs the original parser and review rules on fictional records.
The problem
Address records needed consistent checks before migration. Missing fields, repeated addresses, and other exceptions had to be easy for IT and Operations to review.
What I built
I built the Python pipeline that reads SQL extracts, selects an address, parses it into components, and classifies exceptions. I integrated address validation in the workplace version and designed Excel outputs for Operations to review. Checkpoints let a long run resume without processing completed batches again.
How it works
A suite number, a rural route, and a PO box need different treatment. The parser extracts components such as the unit, street number and direction, then the review rules explain which records are ready, special cases, or missing information. The public demo runs those Python functions locally with example lookup lists.
What it does
- Schema and field validation on SQL extracts
- API results classified for exception review
- Excel reporting and checkpoint recovery
Result and lessons
The professional workflow processed 122,000+ address records. Grouping exceptions made the output easier to review and checkpoints let processing resume after an interruption.