Harshath Peram

About Harshath Peram

Data Engineer Over 3 years of experience building scalable, secure, and high-performance…

Experience

1. Data Analyst

   U.S. Bank

   Jan 2024 — Present

   Worked on Customer Churn Analysis for PNC\'s Retail Banking Division by collaborating with CRM, Product, and Data Engineering teams during Agile sprints and requirement sessions, identifying churn behavior and improving customer retention prediction accuracy by 23% • Utilized SQL with advanced functions including CTEs and Window Functions on large Oracle datasets, optimizing complex queries and performing ETL using AWS Glue and Athena from multi-source CRM and digital transaction data in CSV and Parquet formats • Conducted Cohort and RFM analysis to segment customer behavior, discovering that 45% of users showed inactivity after 90 days, enabling targeted retention strategies and contributing to a 14% increase in customer re-engagement rates • Employed Python along with NumPy, Pandas, and SciPy to perform data wrangling, correlation analysis, and hypothesis testing, identifying key behavioral churn indicators with high statistical significance (p < 0.01) among inactive and low-engagement users • Executed data validation and pipeline integrity checks using AWS Glue and AWS DataBrew, ensuring schema alignment, automation of validation rules, and achieving 99.2% data accuracy across all customer interaction and transaction datasets in ETL pipelines • Built Power BI dashboards featuring slicers, drill-throughs, and bookmarks to visualize churn insights, applying DAX for rolling churn rate metrics and enabling executives to identify and reduce churn by 11% in key customer segments

Education

• St. Francis College

  Master's degree

  2022 — 2024

• SRM University, AP

  Bachelor's degree

  2018 — 2022