Back to Developers
Shreya Patil

Shreya Patil

Data Analyst

Bengaluru, Karnataka 80 · Excellent

About

BCA graduate (2025) and Data Analyst Fresher with hands-on project experience across SQL, Python, and Power BI/Tableau, including a 345,000+ row multi-country dataset cleaned and analyzed end-to-end. Skilled in data profiling, data cleaning, exploratory analysis, KPI dashboarding, and translating raw data into business-ready recommendations. Comfortable working across the full pipeline: querying and cleaning data (SQL, Pandas), building interactive dashboards (Power BI, Tableau), and automating reporting (Excel VBA, Power Query). Seeking an entry-level Data Analyst role to support data-driven decision-making.

Skills & Expertise (41)

Excel Advanced
8.5/10
5
Years Exp
Python Advanced
8.1/10
3
Years Exp
SQL Advanced
8.0/10
4
Years Exp
Data Cleaning Advanced
8.0/10
4
Years Exp
Power BI Advanced
7.8/10
3
Years Exp
If GitHub Ifs Conditional Formatting What-If Analysis VBA Macros Power Query Trend Analysis Variance Analysis Scenario analysis Anomaly Detection Business Metrics Report Automation Data Quality Checks Jupyter Notebook VS Code MySQL WorkBench Git Statistical Analysis MySql Pandas NumPy SciPy EDA Data Profiling Data Validation Outlier Detection SUMIFS Tableau KPI Dashboards Interactive Reporting Data Visualization Advanced Excel PivotTables XLOOKUP Index-match

Work Experience

Data Analyst

Sales Performance Analysis

Present - Present

Queried a multi-year, multi-country transactional sales dataset in MySQL, ranking top 10 customers by revenue and flagging underperforming countries for review. Aggregated revenue by product line, deal size, territory, and time period (monthly/quarterly/yearly) to surface the top-performing product lines and seasonal sales patterns. Wrote 10+ SQL queries (joins, GROUP BY, HAVING) to answer business questions, validated in Excel PivotTables, and structured findings into a reporting format for stakeholder review.

Data Analyst

Retail Sales Performance Dashboard

Present - Present

Built an interactive Power BI dashboard covering ₹2.57 Cr in sales across 660 transactions and 5 mobile phone brands, with drill-downs by city, payment method, and day of week. Identified Apple as the top revenue-generating brand (₹67.7L) while Xiaomi led in unit volume (159 units), highlighting a price-vs-volume gap for inventory and pricing decisions. Analyzed unit sales by day of week, finding Monday had the highest volume and weekends the lowest — an input for staffing and promotion timing. Mapped sales across 12+ Indian cities and tracked customer satisfaction via a ratings funnel, with the majority of transactions rated 3 stars or higher.

Data Analyst

COVID-19 Global & India Analytics

Present - Present

Cleaned and structured a 345,000+ row global COVID-19 dataset (2020–2023, Our World in Data) using Python/Pandas, then loaded it into MySQL for country- and time-based aggregation. Programmatically detected 3 major pandemic waves in India using SciPy peak-detection, calculating a 15-day lag between case peaks and death peaks. Quantified vaccination impact: a 46.18 percentage-point rise in vaccination coverage between two waves corresponded to a 20.27% drop in peak daily cases. Built two interactive Power BI dashboards (Global + India) benchmarking India (45.01M cases, 533K deaths, 1.18% death rate) against global figures (285.38M cases, 5.47M deaths, 10.6% vaccination coverage).

Data Analyst

Excel VBA Reporting Automation

Present - Present

Built a macro-driven Excel workflow (VBA + reusable templates) to automate repetitive data preparation, formatting, validation, and report generation, cutting manual processing time. Added data-quality checks and exception flags to catch missing, duplicate, and inconsistent records, and enabled what-if/scenario analysis via PivotTables for faster decision-making.

Education

Bachelor of Computer Applications (BCA) - RTMNU, Nagpur

- 2025 · Afghanistan

H.S.C. - Maharashtra State Board

- 2021 · Afghanistan

S.S.C. - Maharashtra State Board

- 2019 · Afghanistan

Certifications

No certifications added yet

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 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceSep 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation