Vikas Uppala

Experience

1. Data Analyst

   MetLife

   Jan 2024 — Present · St Louis, MO, US

   Engineered automated data validation scripts in Python to audit policyholder information, ensuring 99.7% data integrity and compliance with state-specific insurance regulations for the underwriting department. • Developed a predictive model using SQL and machine learning libraries to identify customers at high risk of policy lapse, enabling the retention team to execute targeted outreach campaigns and reduce churn by 8%. • Built interactive Tableau dashboards to visualize claims processing metrics, empowering management to pinpoint bottlenecks and decrease average claim settlement time by 15%. • Orchestrate the monthly ETL process for actuarial data, transforming raw premium and loss data into structured formats for financial reporting and risk modeling, improving process efficiency by 25%. • Collaborate with cross-functional teams to define key performance indicators (KPIs) for new insurance products, ensuring data collection aligns with business objectives from launch. • Perform root cause analysis on data discrepancies between policy administration and billing systems, implementing corrective measures that resolved 95% of synchronization errors. • Generate ad-hoc reports using advanced SQL queries to support strategic initiatives for the sales and marketing departments, providing insights into customer segmentation and product penetration.

Education

• University of Cincinnati

  Master's degree

  2022 — 2023

• Sri Indu College Of Engineering & Technology

  Bachelor's degree

  2017 — 2021