Portfolio
Projects &
Cases
Real work, conceptual strategy and applied technique. Each case documents the reasoning behind decisions, not just the numbers.
Project 01 · Fênix Educação
CRM Turnaround on a 50K+ lead database
Disengaged base, mass blasting, zero segmentation. Operation rebuilt from scratch with behavioral automation and lifecycle logic. Results in 1-2 months: open rate ~2% to ~25%, +35% CTR, +20% enrollments.
Case 01 · CRM & Lifecycle
Abrindo Caminhos
Institutional repositioning for a major NGO: condition-based personas, a 5-stage donor journey, a KPI framework and multichannel automation for recurring revenue.
Case 02 · Hybrid prospecting
Boa Leitura
A reading-incentive social project designed as a prospecting engine: a 5-stage Defenders funnel, a literary calendar as cadence and guests as a leverage channel.
SQL · Case 01
Filters and Lead Qualification
Filter structure that isolates SQLs based on role, intent score and status. 40% reduction in prospecting time.
SQL · Case 02
Precedence Logic
Audit query with boolean logic to recover VIP leads inactive for over 30 days. 15 new opportunities opened.
SQL · Case 03
360° Customer Success View
LEFT JOIN with IS NULL to identify clients without activation. 15-day reduction in onboarding time.
SQL · Case 04
Funnel Aggregation
Volumetric analysis by pipeline stage. Identified a critical bottleneck at "Proposal Sent" and triggered document automation.
SQL · Case 05
Average Ticket by Segment
AVG() grouped by sector to identify the most profitable industries. Technology 40% above average, defining expansion focus.