La Venezolana de Seguros y Vida

**Context:** I developed a complete system for an alternative channel of the insurer "La Venezolana", specialized in Vehicle Civil Liability (RCV) policies. The system allows insurance agents to manage policies, clients, payments, and commissions centrally.


**Architecture & Database:**  
- Relational modeling with MySQL: main tables `polizas`, `clientes`, `vehiculos`, `coberturas`, `pagos`, `comisiones`. Eloquent relationships (hasMany, belongsTo).  
- Use of migrations, seeders, and factories for test data.  
- Optimized queries with indexes and eager loading for reports.


**Backend (Laravel + Livewire):**  
- Role-based authentication: agents (only see their clients) and administrators (global management).  
- Admin panel with Livewire for policy CRUD, commission management, and PDF (Dompdf) and Excel (Laravel Excel) report generation.  
- REST API for coverage validation and real-time premium calculation.


**Frontend & UX/UI:**  
- Responsive design with Bootstrap 5, using the insurer's corporate palette.  
- Dynamic JavaScript forms for quotes (automatic premium calculation).  
- Interactive tables with datatables and confirmation modals.  
- Toastr notifications for user feedback.


**Achievements:**  
- 70% reduction in policy issuance time (from 2 days to 2 hours).  
- 40% increase in client retention thanks to automatic expiration reminders.  
- System adopted nationwide.