Deepthi

Results-oriented Data Analyst proficient in SQL, Python, Excel, and Power BI, with experience in data cleaning, transformation, segmentation, KPI development, time series forecasting, and machine learning models including regression and classification. Skilled in translating complex datasets into actionable insights through interactive dashboards and analytical reporting to support data-driven business decisions.

Data Analyst Intern - Learnvista private Limited

(2025-08 - 2026-01)

• Analysed 110K+ transaction records to build an end-to-end e-commerce analytics dashboard for tracking sales, profit, and customer performance.
• Applied SQL-based transformations (joins, aggregations, filtering) to generate KPIs and identified that the top 20% of customers contributed ~60–65% of revenue, while 30% of products drove over 70% of sales.
• Evaluated discount strategies and observed a 15–20% reduction in profit margins at higher discount levels, highlighting pricing inefficiencies.
• Performed Python-based time series analysis to detect 25–30% seasonal variations and generate sales forecasts for future demand planning.
• Analysed 7K+ customer records to identify churn drivers and performed customer segmentation using SQL and Python techniques.
• Built a Random Forest model (84% accuracy) and developed Power BI dashboards to visualize churn patterns and customer behaviour, improving analysis efficiency by approximately 25%.

Bachelor of Technology - ECE - KSRM College Of Engineering (2019-08 - 2023-05)