03Valoriza Engenharia · website + request system
in production

Website and inspection system.

I built Valoriza Engenharia's website and internal system. The website presents their appraisal, forensic and consulting services; the system tracks each inspection from intake to final report, with quotes, chat, files and role-based permissions.

Valoriza Engenharia website homepage: city skyline at dusk and the headline “Engenharia que valoriza cada decisão.” — caso-03 · gestao-de-demandas

01 · problem: The history came in a spreadsheet with thousands of rows. Importing one request per record hit the API's rate limit.
02 · decision: I built a batch import endpoint with 500 rows per transaction. An invalid row goes into a report and the rest of the batch continues; if the database rejects a batch, its rows are inserted one by one. Because of that, the historical load doesn't notify the team. Reads go through a Redis cache with expiry varied by 10%, and if Redis goes down the query goes straight to the database.
03 · number: 5,450 rows imported · 0 skipped · 12 API modules · 4 permission levels