Juan Andrade

At Ecotrak, I deliver product features end to end, from NestJS APIs and SQL through React interfaces, tests, and CI. I built provider discovery APIs with batched queries and cached directory data using NestJS, TypeORM, and Redis.

I modernized Ecotrak’s shared UI architecture with composable page templates, typed form drawers, and reusable table components. I also corrected budget calculations across fiscal-period boundaries and added authorization checks with regression tests.

At CERTI, I architected the AUSSYS video processing engine, a Dockerized Python and FFmpeg service that processes RTSP streams for low-latency HLS playback and raw feeds for AI models. I also migrated IoT communication from legacy SMTP polling to an event-driven RabbitMQ and MQTT architecture.

I contributed to critical library updates for the Tangram Design System at TOTVS, using compatibility testing to avoid production regressions. In my ChooseLife project, I built a Next.js and Expo monorepo that shares React Query logic, hooks, and context providers across web and mobile apps.