Insurance System

Project Description

This project involved inheriting a live, customer-facing pet insurance platform and taking ownership of its ongoing maintenance and enhancement. Rather than building from scratch, the focus was on deeply understanding an existing codebase, identifying weaknesses, resolving live bugs, and adding well-tested new functionality without disrupting production users.

Working within an Agile team structure — with QA and DevOps collaboration — each sprint delivered incremental improvements: bug fixes shipped to production, performance bottlenecks resolved, UI inconsistencies corrected, and new features implemented through a structured change-request process. Every change went through a testing pipeline before hitting production.

Key Highlights

• Codebase analysis & bug resolution — Conducted a full review of the inherited codebase, mapped module dependencies, identified and fixed critical bugs including incorrect premium calculation logic, broken claim submission flows, and data inconsistencies in policy renewal records — all resolved without regressions to existing functionality.
• Policy renewal reminder system — Designed and built a new policy renewal notification feature that automatically sends email alerts to customers 30, 14, and 7 days before their policy expiry — implemented as a background scheduled job with configurable reminder intervals per policy type.
• Claim status tracking module — Added a customer-facing claim status dashboard allowing policyholders to view real-time claim progress (Submitted → Under Review → Approved / Rejected) with timestamped status history — reducing inbound customer support queries significantly.
• Performance optimisation — Profiled slow-loading pages using SQL Server Execution Plans and identified missing indexes and N+1 query patterns in the policy listing and claims modules — resolved through query restructuring and index additions, cutting page load time by over 60%.
• UI/UX improvements across key screens — Redesigned several high-traffic screens including the policy dashboard, quote flow, and claims form — improving layout consistency, adding client-side validation feedback, and ensuring cross-browser compatibility for the customer-facing portal.
• Agile sprint workflow — planning to deployment — Participated in full Agile ceremonies: sprint planning, daily stand-ups, sprint review, and retrospectives. All features were tasked, estimated, and delivered within sprint commitments — with change requests handled through a structured approval process.
• QA & DevOps collaboration — Worked directly with QA engineers to define test cases for every new feature and bug fix, and with DevOps to manage environment-specific configuration and deploy changes through the staging-to-production pipeline safely and without downtime.
• API enhancements & Razor Pages integration — Extended existing ASP.NET Core Web API endpoints to support new claim and policy data requirements, and updated Razor Pages views to consume the updated API responses — maintaining backward compatibility with existing integrations throughout.