Full-Stack Developer•Professional Case Study • 2 Months Delivery

Internal CRM & RNP Lead Management

CEAR Latinoamericano

Internal platform to centralize and qualify over 200,000 RNP procurement entities and leads: sales prospecting pipeline, Marketing Manager task assignments for sales reps, and smart feedback loop with the Mailer System.

Sistema Interno de Prospección & Asignación Comercial

[1/4]Panel principal del CRM de CEAR Latinoamericano

Stack Tecnológico del Proyecto (Frontend, Backend & DevOps)

Frontend & Gestión de DatosClient & Data Tables

Next.jsApp Router / SSR

TypeScriptTipado Estricto

TanStack TableTablas Masivas +200k

Tailwind CSSUI & Dark Theme

Backend & Base de DatosCore API & Drizzle

NestJSModular API / Core

Drizzle ORMType-Safe High Perf

PostgreSQL+200k Entidades RNP

Tareas & FlujosAsignación & Bitácora

DevOps & EcosistemaVPS & Integraciones

Docker ComposeContenedores VPS

VPS On-PremiseServidor CEAR

Sinergia MailerSync Leads Calificados

SSL / HTTPSAcceso Seguro Interno

RNP Entities & Leads

+200,000 records

Data & Performance

Drizzle + PostgreSQL

Operational Roles

Marketing & Sales Reps

Delivery Timeline

2 months (Solo Dev)

The Business Challenge

CEAR's sales reps and Marketing Manager handled prospective student acquisition via direct phone calls and WhatsApp with zero centralization, tracking outreach in scattered Excel spreadsheets. This caused massive data loss, zero performance visibility, and duplicate outreach across more than 200,000 RNP suppliers. The core goals were:

Centralize and structure a massive database of over 200,000 National Registry of Suppliers (RNP) entities in PostgreSQL using Drizzle ORM.
Eliminate scattered spreadsheets with a central Leads module featuring history logs, call logs, and verified email capture.
Implement a Tasks module where the Marketing Manager assigns prospect batches to sales reps and monitors progress, effectiveness, and productivity in real time.
Bidirectional synergy with the Mailer System: the CRM qualifies the contact list via sales calls, and the Mailer feeds back email opens to target campaigns toward highly engaged leads.

Technical Architecture & Decisions

High-performance full-stack solution built in 2 months as a solo developer for high-volume corporate data:

Capa 01 • Frontend & Tablas Masivas

Frontend & High-Performance Data Tables (Next.js, TanStack Table & TypeScript)

Next.js (App Router)TypeScriptTanStack TableTanStack QueryZod Dual Validation

Next.js with TypeScript and TanStack Table to render, paginate, and server-filter massive lists across 200k+ RNP entities with sub-second response times.

TanStack Query for reactive cache synchronization and optimized optimistic mutations on call logs without page reloads.

Typed forms with dual validation via Zod ensuring every email address and phone number logged by reps strictly adheres to standard format.

Capa 02 • Core Backend & Drizzle ORM

Modular Backend & Data Layer (NestJS, Drizzle ORM & PostgreSQL)

NestJS APIDrizzle ORMPostgreSQL (+200k RNP)Roles & Permisos RBAC

NestJS with clean modular architecture, decoupled controllers, specialized services per domain (Leads, Entities, Tasks), and RBAC guards for roles (Marketing Manager vs. Sales Rep).

Drizzle ORM over PostgreSQL: ultra-fast typed queries, optimized joins, and compound indexes for instantaneous lookups by tax ID (RUC), company name, and status.

Task management module with dynamic prospect batch assignment and tracking workflows (Pending, In Progress, Contacted, Discarded, Enrolled).

Capa 03 • Infraestructura & Ecosistema Mailer

Infrastructure, On-Premise VPS & Mailer Synergy

Docker ComposeVPS On-PremiseSinergia CRM ↔ MailerSSL / HTTPS Interno

Docker Compose containerization for Next.js, NestJS API, and PostgreSQL on CEAR's On-Premise VPS, guaranteeing complete data sovereignty over sensitive customer records.

Strategic pipeline with CEAR's Mailer System: leads qualified by reps sync for targeted campaigns, and Mailer engagement metrics prioritize follow-up calls.

Network hardening, SSL/TLS certificates, and automated scheduled backups of the prospecting database.

Engineering Challenges Overcome

Query Performance & Filtering on 200k+ RNP Entities

Handling a database of over 200,000 records without performance bottlenecks through efficient cursor-based queries in PostgreSQL with Drizzle ORM and TanStack Table in Next.js.

Task Tracking & Commercial Productivity

Designing an operational workflow where the Marketing Head distributes leads and assigns targets, enabling clear measurement of contact and closing rates per sales representative.

Integrated Ecosystem: CRM ↔ Mailer Synergy

Preventing data silos by connecting the CRM with the bulk SendGrid/BullMQ mailer engine so reps prioritize warm leads who have already demonstrated high engagement.

Internal CRM Gallery

Screenshots: Institutional dashboard, RNP entities module, lead tracking and task distribution.

[1/4]Panel principal del CRM de CEAR Latinoamericano

Back to Projects

Plataforma de Operaciones Comerciales de CEAR