Sathish Mekarthi

Experience

1. Financial Analyst

   Morgan Stanley

   Apr 2025 — Present · Chicago, IL, US

   Designed and implemented a customer churn prediction model integrating SQL, Python, and Tableau. • Processed 5M+ customer records from CRM and transactional systems to identify churn risk indicators. • Applied EDA techniques to uncover behavioral patterns and anomalies influencing customer retention. • Built predictive dashboards in Tableau to visualize churn probability by customer segments, product lines, and geographies. • Automated ETL pipelines with SQL & Python scripts to refresh churn metrics daily, reducing manual reporting by 80%. • Conducted A/B testing to measure effectiveness of retention campaigns, enabling data-driven interventions. • Collaborated with marketing and customer success teams to define actionable KPIs. • Reduced customer churn by 18% in a 3-month pilot program, saving ~$400K in recurring revenue. • Delivered insights to senior executives, enabling proactive retention strategies. • Improved data pipeline reliability with error handling and monitoring scripts. • Provided ad-hoc analysis to support marketing campaigns targeted at high-risk customer groups. • Implemented role-based access for dashboards, ensuring data security. • Migrated datasets to cloud-based Azure Blob Storage for scalability. • Documented end-to-end pipeline, creating knowledge base for future interns. • Project recognized internally as a best practice case for customer analytics.

Education

• DePaul University

  Information Systems