Sai Eswar Nalam

Aspiring Data Analyst with hands-on experience building Python-based data pipelines, SQL databases, and Power BI dashboards across 3 end-to-end projects. Skilled in cleaning and analyzing datasets of 23,000+ records, writing 25+ optimized SQL queries, and designing KPI dashboards that translate raw data into clear business insights. Trained in statistics, ETL processes, and data warehousing. Seeking a junior Data Analyst role to apply technical skills in a professional environment.

Cricket Batting Statistics Analysis - Hyderabad

(2025-01 - 2025-03)

Web Scraping & EDA · Python

• Data Collection: Scraped 23,000+ batting records across 7,800+ international players from ESPNcricinfo using Requests, BeautifulSoup, and Pandas — eliminating 100% of manual data entry effort.
• Data Cleaning: Resolved 1,200+ missing values and removed 340+ duplicate records, improving dataset completeness by 94%.
• Outlier Detection: Applied IQR method to flag and remove statistical outliers, raising model analysis accuracy by 18%.
• EDA: Conducted multivariate analysis across Test, ODI, and T20 formats; uncovered that the top 5% of players account for 38% of total runs scored.
• Visualization: Developed 10+ charts using Matplotlib and Seaborn, revealing a strong positive correlation (r = 0.87) between total runs and centuries.

Grocery Store Management Database - Hyderabad

(2025-03 - 2025-04)

Database Design · MySQL

• Schema Design: Designed a 3NF relational database with 7 tables and 15+ relationships to manage 500+ products, 200+ customers, and supplier data.
• Data Integrity: Enforced referential integrity using 12 Foreign Key constraints, reducing data inconsistency errors to zero.
• SQL Queries: Wrote 25+ optimized queries using Joins, GROUP BY, ORDER BY, Subqueries, and Aggregate Functions — cutting report generation time by 60%.
• Business Insights: Pinpointed top 10 customers (42% of revenue) and 5 highest-selling products through sales trend analysis.
• Documentation: Created an ER Diagram covering all 7 entities and 15 relationships for full schema documentation.

Bank Customer Analytics Dashboard - Hyderabad

(2025-04 - 2025-05)

Business Intelligence · Power BI

• Data Preparation: Cleaned and transformed a 10,000-row bank customer dataset using Power Query, reducing null values by 96%.
• DAX Measures: Engineered 15+ DAX measures including total balance, customer lifetime value, and monthly transaction summaries.
• Dashboard Design: Developed a 4-page interactive dashboard with 12 visuals, slicers, and drill-through pages — cutting reporting time by 70%.
• Insights: Surfaced top 15% high-value customers contributing 61% of total deposits, enabling targeted retention strategy recommendations.

B.Tech - Electronics & Communication Engineering - JNTU Kakinada (2021-07 - 2025-04)

Certification Program - Data Analyst - Innomatics Research Labs (2025-11 - 2026-04)