Freelancers using SQLite in Madrid

Freelancers using SQLite in MadridFreelancers using SQLite in Madrid

Projects People

Berckan Guerrero

pro

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

$1k+: Earned

3x: Hired

5.0: Rating

9: Followers

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

Cover image for Pulso (https://heypulso.com): Prospect intelligence platform

Pulso (https://heypulso.com): Prospect intelligence platform that scans 28,000+ websites, scores them across 15 health metrics, and manages outreach from discovery to conversion. Scanner engine audits domains: SSL, performance, security headers, vulnerabilities, malware detection, SEO, accessibility. Each domain scores out of 100. Operations dashboard with prospect tables, inline notes, contact popovers, archiving, AI-generated outreach emails, and detail panels with color-coded health breakdowns. Role-based auth. Automated outreach generates custom reports per prospect via API with actual scores and recommendations. 14 years of web maintenance and optimization went into the scoring logic. Every check reflects real patterns found across hundreds of sites. 40,000+ domains. 15 metrics. Sub-second queries. Under €5/month infra.

1

180

INCLUDE: Luxury wellness brand site with video-first marketing. HLS adaptive bitrate streaming via CloudFront CDN for zero-buffer playback across all devices and connection speeds. Accessible video player with poster frames, mute/unmute controls, and mobile-safe autoplay. Hybrid architecture: Webflow handles the editorial frontend with pixel-perfect design freedom, Shopify handles transactions and checkout. No traditional theme constraints. Full GDPR compliance with European consent management. Core Web Vitals passed: LCP 1.7s, CLS 0, FCP 1.0s, TTFB 0.4s. Lighthouse SEO 100. Webflow, Shopify, HLS.js, CloudFront, AWS. Delivered at Yumeda Studio.

1

118

Cover image for LOVEDIS: B2B partnership platform connecting

LOVEDIS: B2B partnership platform connecting startups with enterprise organizations for collaborative innovation challenges in Germany. 140+ dynamic Storyblok components with 166 CMS schemas, all built from a multi-layered Figma design system with pixel-perfect implementation. Automated Figma-to-code workflow with schema synchronization scripts and asset upload pipelines. Anime.js parallax scroll effects and smooth page transitions. Full German/English localization with content-managed multilingual routing. Nuxt 4, Vue 3, Storyblok, TypeScript. Zero hardcoded content: every text, image, and layout variation is editable from the CMS. Delivered at Yumeda Studio.

1

120

Cover image for SpeedDoc: AI-powered web performance optimization

SpeedDoc: AI-powered web performance optimization tool that scans websites, diagnoses bottlenecks, and generates ready-to-implement fix code. Not generic Lighthouse advice: actual code patches developers can copy and apply directly to their codebase. Built as part of a Vercel AI Accelerator application. Scans run against live URLs, identify specific performance issues (render-blocking resources, unoptimized images, layout shifts), and return targeted fixes with before/after impact estimates. Next.js 16, TypeScript, Tailwind 4, Vercel. Personal project.

1

125

Nikita Beznosikov

pro

Full-Stack Engineer · SaaS · Node.js / React / TypeScript

5.0: Rating

2: Followers

Full-Stack Engineer · SaaS · Node.js / React / TypeScript

Cover image for AI-powered language flashcard app for

AI-powered language flashcard app for iOS. Users describe any theme ("Coffee and tea", "Driving exam") and the app instantly generates a custom deck via Google Gemini. Features a progressive 3-level vocabulary system (beginner → intermediate → advanced) with mastery-based unlocking, SM-2/FSRS spaced repetition with Again/Hard/Good/Easy ratings, offline-first SQLite storage, bilingual audio examples, smart daily reminders, and a freemium model (RevenueCat) gating unlimited decks and advanced levels. Built with React Native (Expo), TypeScript, SQLite, Supabase, Google Gemini, RevenueCat.

0

50

Cover image for Pay-per-use video testimonial SaaS. Businesses

Pay-per-use video testimonial SaaS. Businesses collect text reviews for free and pay per video testimonial via a credit system — no subscriptions. Features include browser-based video recording, embeddable widget with masonry layout, Stripe payments, credit metering via Cloudflare Stream analytics, signed video URLs for hotlink protection, and a dashboard for approving/rejecting submissions. Built with Next.js, Supabase (PostgreSQL), Cloudflare Stream, Stripe.

1

60

Cover image for Shopify app for EU Digital

Shopify app for EU Digital Product Passport (DPP) compliance. Merchants can create and manage product passports with QR codes, print labels, bulk edit via CSV, and use AI to auto-fill passport fields from existing product data. Built with Remix, React, Node.js, Prisma, and Shopify GraphQL API.

1

64

Cover image for Built and owned the entire

Built and owned the entire technical stack for a US e-commerce platform generating $1M/mo revenue. Developed custom Next.js storefront, checkout, and CMS admin panel from scratch. Integrated Stripe, Braintree, PayPal, Apple Pay, and Google Pay. Implemented fraud protection, automated chargeback handling via Visa CDRN, server-side tracking (FB CAPI, Google Ads), and BigQuery analytics pipeline.

1

49