Harshit Garg

Specialist, Data Analytics

AXA XL, XL India Business Services Private Limited•  March 2024 - Present

Led a $1M department-level project to identify duplication and redundancy among deliverables across teams. Led a team of 8 in developing the Lloyd’s Reserving System using SQL, Python, and Excel tools, automating the underwriting year reserving process. Achieved an 85% efficiency improvement over the AY process. Serving as the primary contact for the Lloyd’s Reserving System, leading the project, assigning tasks to the team members and actively imparting required business knowledge to the end users. Developed and maintained Power BI and Python dashboards for the Chief Actuary, UK & Lloyd’s, providing crucial insights to top management, including the CFO and external Lloyd’s Regulatory. Engineered an automated Allocation and Unallocation Engine to allocate Ultimate Premiums, Incurred but not Reported (IBNR), and Earned Losses from higher to detailed granularity, eliminating the need for manual intervention by actuaries.

Senior Data Analyst

AXA XL, XL India Business Services Private Limited•  August 2021 - March 2024

Crafted a fully automated Group Treaties calculation engine with the Actuarial Head, reducing TAT from 25 hours to 30 minutes, cutting manual errors by 80%, and saving over 1.5 hours of bandwidth per day per actuary (20+). Analyzed risks, collaborated on mitigation strategies with team owners, and contributed to developing automated tools for actuaries, reducing redundancy by 67% and manual efforts by 26%. Reduced turnaround time by 70% for critical Power BI-based reports and improved storage efficiency through code optimization and automating complex analytical workflows in SQL. Implemented end-to-end automation of the central pool of reports, which now refresh twice a day using scheduler and python script without manual intervention.

Data Analyst - Intern

AXA XL, XL India Business Services Private Limited•  February 2021 - August 2021

Acquired in-depth knowledge of actuarial concepts, methods, and terminologies, enhancing business process concepts and understanding. Designed and implemented an automated tool for actuaries to review reserves, make necessary adjustments, and present final reserves to underwriters, resulting in a quarterly savings of 35 man-hours. Applied a centralized data approach to minimize redundancy across underwriting units, increasing process reliability and accuracy by 5.88% and reducing data duplication.