Distribution-route tracking platform for an international brewery

Case study

The case

The project tracked the delivery routes a distributor used to dispatch product from the brand to its points of sale. The core requirement was that any combination of filters — date, route, unit, delivery point, dispatch status — could be queried across thousands of records without each combination needing its own hand-written query.

Rafael solved this by building an engine that dynamically concatenates SQL against the database based on the active filters: the resulting queries were huge but fully dynamic, generated at query time instead of maintained as a fixed catalog of reports. He also supported the system's infrastructure — permissions and routes — so different roles could check dispatch status according to their access level.

The design challenge wasn't just assembling dynamic SQL, but keeping it maintainable: adding a new filter had to mean extending the engine, not rewriting it.

Confidential client: by agreement, its name is not published. That is professional discretion, not missing content.