Juan Martín Bogarin Juárez

Fullstack enterprise platform with a logistics focus. FastAPI backend with 40+ REST endpoints on SQL Server 2022, OIDC authentication via Authentik with granular per-application RBAC, and three React frontends (CRM sales, login, and reporter). Includes commercial CRM, route quoting engine with legs and profitability tiers, CTPAT (customs compliance) module, quadrants with geographic rules, employee log, and PDF generation with Carbone.

• ▸Complete commercial CRM: companies, contacts, opportunities, quotes, and activities with stage pipeline.
• ▸Route quoting engine with cost calculation by miles/toll booths/weight, legs, profitability tiers, and materialization into formal quotes.
• ▸CTPAT (customs compliance) module: audits, checklists, and documents per company with approval/rejection workflow.
• ▸Granular per-application RBAC with Authentik OIDC; permission catalog, roles, and user quadrants.
• ▸DogWatch: uptime monitoring microservice with SQLite, 15-second checks, alerts, and availability reports.
• ▸PDF generation with Carbone (server-side); interactive maps with Leaflet.

Conversational AI agent that provides information of interest to students, prospective students, and administrative staff (Community Service, Social Service, Academic Plans, academic calendar dates by modality). Improves the student experience by offering official information quickly and effectively, and improves institutional efficiency by automating repetitive tasks. Fully adaptable, scalable, and configurable project.

Backend and frontend application with FastAPI and React to create, maintain, and manage a computer equipment inventory, visualizing the overall status of equipment based on age, hardware specifications, department priority, and usage factor of the assigned position.

• ▸Dashboard: priorities, departments, assigned positions, equipment in optimal condition, near replacement, and needing replacement.
• ▸Equipment page: create, edit, or delete equipment, view existing equipment and their details.
• ▸Departments page: view the status of equipment in a specific category.
• ▸Maintenance page (in development): schedule and manage preventive maintenance and assign interns to these tasks.

Backend and frontend application with FastAPI and React to create and manage queues, services, counters, and users, providing personalized service to the target public. Designed for moderate-to-high applicant flows.

• ▸Dashboard: active counters, queued tickets, and informational video section for waiting rooms.
• ▸Configuration module: manage services, counters, users, and dynamic messages.
• ▸Administration module: ticket control (call, attend, reassign, cancel).
• ▸History module: view recently attended tickets.
• ▸Metrics module: KPIs and service report generation.
• ▸Ticket module: ticket creation via form with personal data and requested service.