Berckan Guerrero's Work | ContraWork by Berckan Guerrero
Berckan Guerrero
pro

Berckan Guerrero

14+ years building fast, accessible websites. AI Friendly.

    1x
    Hired
    5.00
    Rating
    5
    Followers

Madrid, Spain

WorkProductsReviewsServicesAbout

Madrid, Spain

RAVEN: AI-powered knowledge management app with notes, tasks, and a built-in AI chat. Built with Nuxt 4, Vue 3, TypeScript, Supabase (PostgreSQL, Auth, RLS), and Gemini AI. 34 components, 25 composables, 13 database tables, 12 AI functions including streaming chat, voice input, and automatic conversation titles. Full i18n (EN/ES), offline support with sync queue, real-time CRUD, folder organization, and workspace-based content separation. Built for a private client, actively developed.
2
244
SPEEDDOC: AI-powered web performance optimization tool that scans websites, diagnoses bottlenecks, and generates ready-to-implement fix code. Built with Next.js 16, TypeScript, and Tailwind 4 on Vercel. Designed for developers who want actionable performance fixes instead of generic audit reports. Currently in development as part of a Vercel AI Accelerator application. Personal project.
2
314
LOVEDIS: B2B innovation platform for a German ecosystem connecting startups and corporate partners. Built with Nuxt 4, Vue 3, and TypeScript on a headless CMS architecture. Delivered during my time at Yumeda Studio, this website was developed creating 110+ reusable CMS components and 200+ Vue components total, a custom responsive image system with modern format support and art direction per breakpoint, centralized SEO management, Content Security Policy with enterprise security headers, and a design system with 70+ tokens enforced across the entire codebase. GDPR-compliant EU deployment.
3
3
363
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.
2
428
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.
2
334
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.
2
288
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.
2
286
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.
2
263