0 viewsjobseeker
Sruthi T. — Mid-Level Insurance Data Analyst from United States

Sruthi T.

Mid-Level Insurance Data Analyst

United States 3-6 years
Open to offersNew to Platform
Languages
English
Video Introduction
No video introduction yet
The candidate has not added a video.
Contact information and social networks are private. Connect to unlock.
Hidden

About

Sruthi T. is a skilled Data Analyst with over four years of experience, focusing on high-volume insurance and financial datasets to improve business intelligence. She has demonstrated expertise in building scalable ETL pipelines utilizing Python (Pandas) and SQL, as well as crafting optimized Star Schema data models for enterprise data warehousing. At MetLife, Sruthi effectively engineered ETL workflows using AWS S3, significantly reducing data preparation time and enhancing report generation speed. She also created a Customer Churn Prediction model using Logistic Regression that helped to recover $500k in potential lost premiums. Sruthi excels in developing Power BI dashboards to provide real-time insights to senior leadership. During her tenure at Sage SoftTech, she migrated sales data to PostgreSQL and automated complex reporting tasks using Advanced Excel and VBA, thus streamlining financial operations. Her role involved utilizing Power BI, Tableau, and implementing data governance protocols using Informatica to maintain regulatory compliance and data protection. Sruthi's educational credentials include a Master's in Data Science from Lewis University.

Experience

  • Data Analyst

    MetLife · 2024 — Present
    Engineered automated ETL workflows with Python (Pandas) and AWS S3, transforming raw policyholder data from legacy systems for analytics. Designed a Star Schema data model in SQL Server, optimizing complex actuarial queries. Developed a Customer Churn Prediction model utilizing Logistic Regression (Scikit-Learn) to analyze policy renewal trends. Built interactive Power BI dashboards to visualize Claims Loss Ratios and underwriting performance. Implemented Data Governance and Lineage protocols with Informatica for compliance. Conducted A/B Testing on digital engagement strategies to validate UI changes. Optimized SQL queries in cloud-based warehouses through indexing and partitioning.
  • Data Analyst

    Sage SoftTech · 2020 — 2022
    Led the migration of historical sales data from Excel to a PostgreSQL database, ensuring data integrity through validation scripts. Created robust data cleaning scripts using Python (NumPy, Pandas) to standardize diverse datasets. Developed dynamic Tableau visualizations to track sales performance KPIs. Automated month-end reconciliation reports with Advanced Excel (VBA Macros) and Power Query. Maintained complex PL/SQL stored procedures in MySQL for daily data aggregation. Conducted exploratory data analysis (EDA) using Seaborn and Matplotlib to identify demand patterns. Collaborated in an Agile environment using JIRA, refining business requirements into technical specifications.

Skills & Expertise

Education

  • Master's in Data Science
    Lewis University · 2023 — 2024