Aarthi Babu

• Applied a comprehensive methodology to extract and analyze data from various claims systems, focusing on North American catastrophe (CAT) claims. Modeled historical trends, average severities, and development factors, to make adjustments, and IBNR to generate accurate projections for reserving purpose.
• Produced standalone reports to support CAT projections, collaborating with reinsurance teams to ensure accurate application of aggregated treaties and collaborating with Chubb Agribusiness teams for conducting comparative analysis of agricultural CAT claims.
• Delivered monthly and quarterly claims trend analysis for non - CAT claims across various lines of business, providing strategic insights for senior leadership.
• Coordinated with stakeholders to prepare and present quarterly reserving study exhibits for non-CAT claims
• Conducted ad hoc research and data extraction from diverse databases, delivering clear and actionable insights through written, visual, and verbal presentations to actuarial leadership.
• Automated manual workflows using VBA, Power Query and SQL reducing processing time by up to 80% and independently addressing project challenges under tight deadlines.
• Built and maintained Qlik Sense dashboards, enabling real-time, data-driven decision-making with impactful visualizations.
• Mentored junior analysts, fostering professional development and enhancing overall team performance.
• Collaborated with cross-functional teams to identify and implement process enhancement, leading to increased operational efficiency.
• Took ownership of high-impact, ad hoc projects assigned by senior management, ensuring timely and quality deliverables.

Key Projects

• Qlik Sense – Agriculture Claims (2021): Designed and developed a Qlik Sense dashboard to analyze agricultural claims arising from catastrophic events, enabling improved data visualization and decision-making.
• ETL Project – Litigation Claims Data Transformation (2022): Led data transformation efforts using SQL to streamline litigation claims processing, enhancing data quality and management.
• Net Change Automation (2023–2024): Created a fully automated template to monitor changes in Net projections of CY CAT events. Included executive-level commentaries; the tool became a key asset in quarterly earnings calls.
• Qlik Sense – VIP Claims Dashboard (2024): Enhanced a Qlik Sense dashboard during a critical hurricane season, enabling stakeholders to easily track VIP claims and initiate timely contact.
• Process Enhancement – Catastrophe Projection (2025): Implemented a VBA solution that reduced manual input by 50% during peak reporting periods, significantly improving turnaround times and accuracy.

• Research project focused on determining the premium for health insurance policy through the utilization of three distinct methodologies: Frequency-Severity Approach, Burning Cost Approach, and Exponential Curve Fitting.

• Advertising and marketing
• Exploratory data analysis on financial securities such as Equity, Mutual funds and Options.