Yashwanth Raj

About Yashwanth Raj

I’m a results-driven Data Engineer with 5 years of experience transforming complex data…

Experience

1. Data Analyst

   Allstate

   Aug 2024 — Present · MO, US

   Designed and delivered Power BI dashboards to track claim lifecycle metrics (e.g, settlement times, adjuster efficiency, loss ratios), accelerating quarterly underwriting reviews by 10 business days across three departments.• Engineered scalable ETL pipelines with AWS Glue and Lambda to ingest 14M+ records from legacy systems, cutting 60+ hours/month of manual work for analytics teams.• Wrote optimized SQL and audit queries to detect billing and disbursement anomalies, recovering ~$13K in overpaid claims within the first quarter of rollout.• Built predictive lapse-risk models using Random Forest and XGBoost in Python to flag at-risk customers, helping retain 3,500+ policyholders over two renewal periods.• Partnered with actuarial teams to deploy ARIMA and Prophet models for claim volume forecasting, improving resource planning and preserving $2.6M in operational reserves.• Developed fraud detection logic using Isolation Forests, anomaly scoring, and statistical rules, surfacing 1,600+ high-risk claims—130 of which were confirmed fraudulent.• Led multi-region pricing optimization via A/B testing and regression modeling for bundled offers, boosting new customer acquisition revenue by $1.1M in key states.• Built an enterprise-wide data quality framework across Snowflake and Amazon RDS (PostgreSQL) pipelines, increasing SLA compliance from 71% to 100% for four quarters.

Education

• Park University

  Master's degree