Enterprise Churn Analytics & Strategy
(Image by vector4stock)
Overview: Mentored an enterprise data team from start to finish as they executed an Exploratory Data Analysis (EDA) project. Guided the corporate professionals through database architecture, technical strategy, metric design, and statistical analysis, culminating in a predictive model delivered to executive leadership.
Key Contributions & Leadership
- Data Strategy & Engineering: Advised the team on extracting, cleaning, and merging transactional datasets from local Microsoft SQL Server architectures into Python Pandas dataframes.
- Metric Design: Guided the conceptualization and mathematical formulation of the Customer Loyalty Index (CLI), combining promotion engagement data and historical complaint rates.
- Statistical Modeling: Directed the workflow for statistical analysis and customer profile grading in Python (Jupyter Notebooks) to identify high-risk customer segments.
Business & Educational Outcomes
- Corporate Upskilling: Successfully facilitated accountability sessions, unblocking advanced data cleaning, code refactoring, and database integration challenges for the corporate team.
- Executive Delivery: Steered the project execution lifecycle from an initial proposal to a final, high-impact presentation detailing revenue loss mitigation for senior leadership.