H&B Analyst I at Aon

Automated ingestion, transformation, and validation of more than 5,000 insurance experience reports using Python, SQL, Spark, and Delta Lake. Designed governed lakehouse data workflows with schema validation, metadata tracking, audit logging, and automated data quality checks. Built machine learning-ready datasets from claims, premiums, benefits, loss ratios, client attributes, carrier files, and reporting periods. Developed anomaly detection workflows for unusual claims and cost trends, and created Power BI dashboards for claims analytics, premium trends, loss ratios, client performance, and business growth.

H&B Analyst 1 at Aon

Built end-to-end ETL pipelines in Databricks using PySpark, SQL, and Delta Lake, automating ingestion of 5,000+ Excel-based insurance experience reports from carriers like Canada Life, Desjardins, and Sun Life. Designed and implemented a Unity Catalog-enabled data lakehouse architecture for Health & Benefits data, enforcing schema validation, metadata tracking, and audit logging, resulting in a 35% improvement in data reliability. Developed Power BI dashboards that reduced manual analysis time by 50%. Created automated data quality checks improving overall data integrity by 40%. Implemented ML-based anomaly detection models in Databricks to flag irregular claim trends.