Back to Developers
Jyothi Valluru

Jyothi Valluru

Entry-Level Data Analyst

Tirupati, India
85
Profile Score

About

Data Analyst aspirant with practical experience handling datasets end-to-end, including data cleaning, transformation, exploratory analysis, and insight generation using Python and SQL. Passionate about applying statistical and analytical methods to support AI model performance and research-driven decision-making.

Skills & Expertise (30)

Analytical Thinking Expert
8.5/10
1
Years Exp
Python Advanced
8.1/10
1
Years Exp
SQL Advanced
8.0/10
1
Years Exp
Power BI Advanced
7.8/10
1
Years Exp
Data Cleaning Advanced
7.6/10
1
Years Exp
Trend & Correlation Analysis Data Modeling Relational Database Design Churn Analysis Customer Segmentation Revenue Impact Analysis XLOOKUP MySql GitHub Problem Solving Communication Attention to Data Feature Engineering Pivot Tables Excel Interactive Dashboards KPI Design DAX Window Functions Subqueries GROUP BY JOIN Matplotlib NumPy Pandas

Work Experience

Data Analyst

Telecom Customer Churn Analysis & Retention Insights

Jan 2026 - Feb 2026

Cleaned and normalized 7,000+ customer records across 50+ columns into structured relational tables using Python and MySQL. Built 10+ SQL queries (JOIN, GROUP BY, aggregations) to calculate churn rate, revenue loss, and high-risk customer segments. Identified that month-to-month contract customers contributed to majority churn and highest revenue leakage. Estimated potential revenue retention opportunity by targeting high-risk segments with long-term contract incentives. Designed interactive Power BI dashboard with KPIs including churn rate, total revenue at risk, and customer segmentation. Reduced manual churn reporting effort by creating automated KPI tracking dashboard.

Data Analyst

Olist. E-Commerce Delivery Performance & Customer Reviews Analysis

Dec 2025 - Jan 2026

Merged and cleaned 100k+ order records from multiple datasets (orders, customers, reviews, payments). Engineered delivery delay, order status, and revenue features to evaluate logistics performance. Discovered correlation between delayed deliveries and low customer review scores. Identified high-delay states contributing to negative customer satisfaction trends. Built business KPI dashboard tracking revenue, delayed order %, avg delivery time, and review distribution. Provided actionable recommendations to improve logistics efficiency and customer retention.

Data Analyst

Urban Water Consumption Optimization

Dec 2025 - Dec 2025

Analyzed smart meter data to identify abnormal water usage patterns across households. Created leak risk flag and per-capita consumption metrics using Excel and SQL. Ranked high-risk households using SQL window functions (RANK). Estimated potential water loss reduction through early leak detection strategy. Developed district-level Power BI dashboard visualizing consumption trends and efficiency index. Demonstrated how data-driven monitoring can improve sustainability and reduce resource waste.

Education

Bachelor of Technology (B.Tech) in Computer Science & Engineering - JNTUA University

2011 - 2015 · Afghanistan

Certifications

IBM Introduction to Data Analysis

· 2025

Coursera Excel for Data Analysis

· 2025

Microsoft Power BI for Data Analysis

· 2025

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceFeb 2026

Skills (30)

Analytical Thinking Python SQL Power BI Data Cleaning Trend & Correlation Analysis Data Modeling Relational Database Design Churn Analysis Customer Segmentation +20 more