Keerthika J S

WORK EXPERIENCE:

A. Insurance Operations & Underwriting
• Underwrote motor and non-motor policies and processed endorsements for 13 insurers, ensuring regulatory
compliance across the full policy lifecycle.
• Verified customer documents for policy issuance, renewal, and endorsements per each insurer's underwriting
guidelines and compliance standards.
• Coordinated daily with insurers and clients on renewals, document clearance, and payment follow-ups to ensure
smooth policy management.
• Trained and mentored junior team members on quotation preparation, VIR procedures, documentation checklists,
and payment collection processes.
B. Data Analytics & Reporting
• Performed end-to-end EDA on 100K+ policy records using Python (Pandas, NumPy, Matplotlib) and Advanced Excel to
segment portfolios, detect anomalies, and surface actionable insights.
• Built and maintained Power BI dashboards tracking KPIs — sales performance, claims ratio, premium collection, and
renewal retention — adopted by senior management for strategic review.
• Automated MIS reporting using Python and Power Query, improving reporting efficiency by 30% and saving 20+
hours/week of manual effort.
• Validated and reconciled large-scale insurance datasets using SQL, achieving zero data discrepancy incidents across
100K+ policy records.
• Developed penetration and retention analysis reports tracking new business acquisition vs. renewal success rates;
shared insights with management for strategic planning.