Berckan Guerrero

14+ years building fast, accessible websites that convert.

New to Contra

Berckan is ready for their next project!

Madrid, Spain

Work Services About

Madrid, Spain

Valsole: Premium orthopedic footwear brand. Built a 3D product viewer with Spline (with fallbacks for mobile), GSAP scroll animations, 50+ custom sections, and 32 locales. Delivered during my time at Yumeda Studio.

PartSpace: B2B SaaS marketing website for the manufacturing sector, built with Nuxt 4 and Storyblok. Developed 100+ reusable CMS components, integrated real-time commodity pricing via FRED API, implemented strict Content Security Policy (CSP) with enterprise-grade security headers, and delivered full English/German localization with 8 dynamic sitemap variants. Delivered during my time at Yumeda Studio.

Where Are They? (dondeestan.cl): Full-stack platform built on Supabase PostgreSQL from the ground up. Designed and implemented the complete database architecture: 63 migrations, Row Level Security (RLS) policies, full-text search with Spanish stemming, and incremental data sync using SHA-256 change detection. The project aggregates 3,216+ records from 4 external sources through a Python ETL pipeline with 99% deduplication accuracy, AI-powered image restoration (Real-ESRGAN + GFPGAN), and a Nuxt 3 frontend. Hosted on GitHub with a monorepo structure, CI/CD via GitHub Actions, and Vercel deployment. This project demonstrates deep Supabase expertise: auth, storage, database design, RLS, edge functions, and seamless integration with a modern frontend stack.

THE SPOT: Ongoing maintenance and DevOps for Germany's leading film industry news service. Delivered during my time at Yumeda Studio. Security hardening, custom PHP plugin development, infrastructure management, and performance optimization that took PageSpeed from 54 to 99.

berck.io: personal portfolio with multilingual support (EN/ES/FR), personalized client pages, and Supabase-powered private portals. Built for speed: Islands architecture with partial hydration and a 72% reduction in asset size.