Gildardo Guerra

Built and shipped full-stack product features using TypeScript (React/Next.js) on the frontend and Node.js/Python services on the backend. Designed and optimized PostgreSQL schemas for high-volume data pipelines, writing complex SQL queries and stored procedures for analytics and automation logic. Developed Python-based data processing modules for algorithmic automation and pricing logic, integrating with external APIs under strict rate limits. Deployed and maintained serverless infrastructure on AWS ( Lambda, S3, DynamoDB ) and managed CI/CD workflows with GitHub Actions. Integrated Supabase for real-time data features, authentication, and backend-as-a-service functionality across multiple product surfaces.

Developed end-to-end product features using TypeScript, React, and Node.js with PostgreSQL as the primary data store. Wrote and optimized complex SQL queries, data models, and indexing strategies to support a rapidly growing dataset with consistent read/write performance. Built RESTful APIs and backend services integrated with third-party platforms, handling data synchronization and transformation logic. Contributed to analytics and reporting pipelines, processing and aggregating large volumes of transactional data for user-facing dashboards. Worked in a small, fast-moving remote team — independently owning features from specification to production deployment.

Implemented full-stack features across TypeScript/React frontends and Node.js backends, delivering clean and scalable production code. Designed data models and optimized PostgreSQL queries for high-traffic platforms, applying caching (Redis) and query tuning to maintain performance. Built and consumed RESTful APIs, integrating multiple external services and handling complex asynchronous data flows. Implemented CI/CD pipelines with GitHub Actions, ensuring reliable deployments and maintaining code quality through automated testing.