Karthik Garikapati

Data Analyst @CVS Health

CT, US

Collected and integrated customer data from core banking systems, CRM, online banking, and mobile platforms to build a unified customer profile for segmentation.• Cleaned and transformed raw data using SQL and Python (Pandas, NumPy) to prepare structured datasets suitable for analysis and modeling.• Applied clustering algorithms like K-means and hierarchical clustering to segment customers based on behavior, demographics, and financial activity.• Used Power BI to create interactive dashboards displaying key metrics such as segment size, average balance, product usage, and churn risk.• Collaborated with marketing and business teams to define target personas and develop personalized outreach strategies based on segment insights.• Employed machine learning models to predict customer lifetime value and identify high-potential segments for upselling and cross-selling opportunities.• Conducted cohort analysis to track retention trends and evaluate the impact of segment-specific promotions and campaigns.• Ensured data privacy compliance with internal policies and external regulations like CCPA and GLBA, anonymizing sensitive data where required.• Scheduled automated reports and dashboards to monitor segment performance over time, enabling continuous optimization of strategies.• Communicated actionable insights through presentations and written reports, supporting decision-making at both operational and executive levels. Achievements :• Increased campaign conversion by 18% through tailored segmentation of high-value digital-first customers.• Reduced manual reporting effort by 40% by automating dashboard generation using Power BI.• Enabled a 12% improvement in retention by identifying and targeting at-risk customer segments with proactive engagement strategies.