Multi-Product Platform Expansion: Beef View (Livestock Insurance Management)
From hours of daily manual spreadsheet work to a fully automated livestock insurance management system.
Hours lost daily to manual tracking from Excel spreadsheets
After successfully modernizing the grain marketing platform, the client identified an adjacent business need: managing livestock insurance (LRP — Livestock Risk Protection) endorsements for beef producers. Their team was spending hours daily manually tracking endorsement expirations, sending notifications, and generating monthly statements from Excel spreadsheets. A competing vendor had built a basic proof-of-concept (Cattle Keeper) using Supabase and React, but it lacked the full endorsement lifecycle, automated notifications, statement generation, commission tracking, and branded PDF output the client required.
A new product module built into the existing platform in four phases
Rather than port the existing proof-of-concept, we built Beef View as a new product module within the existing BushelView monorepo, leveraging all shared infrastructure (auth, RBAC, PDF generation, email, Azure deployment). PostgreSQL schema separation ensures grain and beef data are cleanly isolated while sharing the same database instance.
Phase 1 delivered the foundation: endorsement tracking with full CRUD and bulk Excel import, insured/producer management, a beef-specific dashboard with KPIs (total endorsements, active head count, premium totals, expiring-soon alerts), and a product-aware market ticker showing live cattle futures (Feeder Cattle, Live Cattle) via Yahoo Finance.
Phase 2 added automation: daily expiration alerts that automatically detect endorsements expiring within 21 days and email the insured with coverage details (with duplicate prevention), monthly statement auto-generation with branded PDF delivery, a notification dashboard for admin oversight, and a self-service Producer Portal where insured customers log in to view their own coverage, endorsements, and statement history — all with proper data isolation between producers.
The monorepo was restructured into apps/grain-web, apps/beef-web, and apps/home-web with shared packages extracted to packages/shared, enabling independent deployment while maintaining UI consistency. A home screen launcher with Logic Ag branding provides navigation between the two products, and each app has its own branded login page.
Monorepo Architecture: Restructured into apps/grain-web, apps/beef-web, and apps/home-web with shared packages extracted to packages/shared — enabling independent deployment while maintaining UI consistency across products.
Database Isolation: PostgreSQL schema separation cleanly isolates grain and beef data while sharing the same database instance. Proper data isolation between producers enforced at the application layer.
Automation Layer: Daily expiration alerts (21-day window, duplicate prevention), monthly statement auto-generation with branded PDF delivery via Azure Communication Services, and a notification dashboard for admin oversight.
Producer Portal: Self-service portal where insured customers log in to view their own coverage, endorsements, and statement history — with full data isolation between producers.
Bulk Import & Market Data: Excel/CSV bulk endorsement data loading with validation. Product-aware market ticker showing live Feeder Cattle and Live Cattle futures via Yahoo Finance API.
How we built it
Monorepo Architecture: Restructured into apps/grain-web, apps/beef-web, and apps/home-web with shared packages extracted to packages/shared — enabling independent deployment while maintaining UI consistency across products.
Database Isolation: PostgreSQL schema separation cleanly isolates grain and beef data while sharing the same database instance. Proper data isolation between producers enforced at the application layer.
Automation Layer: Daily expiration alerts (21-day window, duplicate prevention), monthly statement auto-generation with branded PDF delivery via Azure Communication Services, and a notification dashboard for admin oversight.
Producer Portal: Self-service portal where insured customers log in to view their own coverage, endorsements, and statement history — with full data isolation between producers.
Bulk Import & Market Data: Excel/CSV bulk endorsement data loading with validation. Product-aware market ticker showing live Feeder Cattle and Live Cattle futures via Yahoo Finance API.
Manual daily work replaced by a fully automated insurance management system
The team went from hours of daily manual spreadsheet work to a fully automated system handling alerts, statements, and producer self-service — all within the same platform they already used.
Multi-Product Architecture, Monorepo Engineering, Automation, Self-Service Portals, PDF Generation, RBAC
Agricultural Technology
