Harshitha Kotikalapudi

Objective:

Developed a customer segmentation and retention strategy to enhance Sony's customer lifetime value using data-driven insights.

Key Achievements:

• Analyzed 3 years of transactional and demographic data using SQL to identify patterns in customer behavior.
• Implemented clustering algorithms (K-Means) in Python to segment customers based on purchase frequency and product categories.
• Built a Power BI dashboard showcasing customer segments, product performance, and churn likelihood.
• Recommended personalized marketing campaigns and bundled offers, projected to increase customer retention by 12%.

Technologies Used: Python, SQL, Power BI, Pandas, NumPy, Matplotlib

• Queried large datasets using SQL to extract actionable insights, improving business reporting efficiency by 20%.
• Built predictive models in Python to forecast sales trends, achieving a 90% accuracy rate.
• Developed interactive Tableau dashboards to track key metrics, leading to data-driven decisions for marketing and operations teams.
• Automated data cleaning workflows using Python scripts, reducing processing time by 30%.