Walk me through a time you had to redesign an existing legacy pipeline to handle a 10x increase in data volume for production analytics.