Vvek

Marketing Analyst

Systems Plus Solutions•  March 2022 - Present•  Pune, India

Optimized and automated Customer Count queries, reducing execution time by 20%. Implemented SQL Server job scheduling, executed Customer Segmentation using K-means clustering, conducted a comprehensive analysis of the loyalty program, comparative analysis between "Best" and "Core" segments, leveraged SQL to analyze POS transactions, developed and implemented a Dash application, developed and deployed a predictive model using XGBoost Classifier, analyzed 1 million transactions using Market Basket Analysis, developed a predictive model to forecast the likelihood of customers with 200-299 loyalty points returning within 60 days.