Saurav Sundararaju Makam

About Saurav Sundararaju Makam

Data Analyst with 3+ years of experience transforming raw data into actionable insights…

Experience

1. Data Analyst

   MetLife

   Jul 2024 — Present

   Designed and deployed 12+ Power BI dashboards integrating data from Snowflake and Excel, enabling underwriters and actuaries to monitor claims KPIs and reduce manual dependency.• Automated monthly performance reports using Python (Pandas, openpyxl) and SQL, reducing reporting cycle time by 40% and eliminating redundant Excel processes.• Extracted and transformed data from policy, claims, and CRM systems using SQL and Snowflake for compliance and audit analysis, supporting regulatory reporting with 99.5% accuracy.• Conducted root cause analysis on customer churn, identifying that 17% of lapses were linked to delayed communication, helping improve outreach strategies.• Founded and maintained parameterized DAX measures and slicers in Power BI to allow self-service analytics for over 60 stakeholders across 4 teams.• Collaborated with data engineering to refine and validate ETL pipelines, reducing data latency by 2.5 hours for daily dashboards.• Integrated GitLab CI/CD pipelines with data validation scripts to automate testing and deployment of Power BI reports.• Enhanced custom Python scripts for processing unstructured feedback and survey data, developing sentiment scoring logic for 50K+ customer responses.• Implemented interactive data filtering components in a Streamlit dashboard using custom TypeScript widgets, improving user interactivity for business users.• Implemented anomaly detection logic on policy lapse rates using Z-score thresholds, flagging suspicious patterns proactively.

Education

• Syracuse University

  Master of Science - MS, Data Science

• K S Institute of Technology, BANGALORE

  Computer Science And Engineering