Roshini Reddy Chettipally

Data Analyst @Brown & Brown

Troy, MI, US

Developed and maintained scalable data pipelines using Apache Spark (PySpark), Apache Airflow, Talend, and Snowflake on AWS (Redshift & S3), streamlining the ingestion and transformation of largescale insurance datasets covering policyholder, claims, and underwriting records improving data processing efficiency by 20%. Built and optimized predictive models for claims prediction, fraud detection, and risk scoring using Python, R, and SQL, enhancing underwriting precision and reducing fraudulent claim payouts. Designed and deployed dynamic insurance analytics dashboards using Power BI to monitor key performance indicators (KPIs) such as premium optimization, lapse rate, and renewal trends, delivering actionable insights to business stakeholders. Conducted advanced statistical analysis using predictive modeling, A/B testing, and cohort analysis to evaluate customer lifetime value (CLV) and improve customer segmentation strategies. Improved data quality and consistency by 10% through rigorous data cleaning, transformation, and validation processes to support critical decision-making in underwriting and claims. Automated routine reporting and operational workflows using SQL Automation and Excel VBA, reducing manual effort and increasing efficiency across data teams. Partnered with cross-functional teams in underwriting, risk management, and actuarial functions to deliver data-driven solutions aligned with business goals. Ensured secure and compliant data practices by adhering to insurance data governance standards across the AWS cloud environment, protecting sensitive customer and policyholder information.

Central Michigan University

Master of Science - MS, Information Systems

Vignana Bharathi Institute of Technology

Bachelor of Technology - BTech, Electrical, Electronics and Communications Engineering