Leela Prasad Pathivada

About Leela Prasad Pathivada

Machine Learning Engineer with 5+ years of experience building and deploying AI-driven solutions across insurance and financial domains. I specialize in designing end-to-end ML pipelines, from data ingestion to model deployment, using Python, R, SQL, and cloud platforms like AWS SageMaker, Glue, Athena, Redshift, and Azure Data Factory.My work focuses on fraud detection, risk modeling, predictive analytics, customer segmentation, and NLP. I’ve delivered measurable business impact—improving model accuracy, automating workflows, reducing operational costs, and accelerating data-driven decision-making.I enjoy solving complex problems, collaborating with cross-functional teams, and transforming raw data into intelligent, scalable solutions. Passionate about leveraging AI to optimize business outcomes and enhance enterprise decision systems.

Experience

1. Data Analyst

   State Farm Insurance

   Aug 2024 — Present

   At State Farm, I work with actuarial, claims, and fraud detection teams to analyze over 20 million policy and claims records using SQL, Python, and R. My role involves designing advanced SQL queries with CTEs and window functions on AWS Athena and Redshift, which improved query performance by 30%. I also developed automated ETL pipelines in AWS Glue to process structured and unstructured data (CSV, JSON), improving accuracy by 28% and reducing processing time by 25%.I apply time-series decomposition, cohort analysis, and statistical hypothesis testing to uncover seasonal claim trends, which has helped fraud teams prevent ~$3M in risk exposure annually. To support business decisions, I build interactive Power BI dashboards with DAX measures, KPIs, slicers, and drill-throughs, reducing reporting time by 40% and enabling executives to monitor policy lapse rates in real time.In addition, I established data validation frameworks that reduced reporting errors by 22% and improved overall compliance. I thrive in Agile environments, working within Scrum sprints, gathering requirements, and using JIRA to align analytics delivery with business goals.

Education

• Adikavi Nannaya University, Rajahmundry, East Godawari

  Bachelor's degree, Information Technology

• Indiana Wesleyan University

  Master's degree, Data Analytics