2025

Underwriting Renewal WebApp

Pulls live GuideWire data, runs renewal analytics, writes results back

ReactPythonSQLGuideWireDocker

Overview

Full-stack web application that replaced a fully manual Excel workflow for the Underwriting team. Pulls live account data from the GuideWire platform, lets underwriters enter inputs and run analytics on renewal policies, then writes the results back to the analytics database for downstream reporting.

Key Outcomes

→Retired a fully manual Excel-based renewal process
→Gives underwriters live GuideWire data without bouncing between systems
→Persists renewal analytics to the warehouse for reporting and audit