Open to opportunities

Aditi Patil

@aditipatil2

Message

I turn complex datasets into actionable dashboards and business insights.

India

Message

What I'm looking for

I'm looking to apply my Python, SQL, Excel, and Power BI skills to solve business problems through data cleaning, analysis, dashboards, KPI reporting, and actionable insights.

I've analyzed 180,000+ supply-chain records for SupplyLens, building an interactive Streamlit dashboard and Power BI KPI reports to uncover delivery, profitability, and customer-segmentation insights.

Through SQL crime analytics, TravelTriangle web scraping, and an IMDb sales dashboard, I've cleaned and explored real-world datasets, built analytical queries, and translated trends into decision-ready reporting using Python, SQL, Excel, Power BI, and visualization tools.

Experience

Work history, roles, and key accomplishments

Data Analyst Intern

Smart Surveillance

Analyzed 187,000+ Chicago crime records (2012–2017) using SQL to identify crime trends, arrest rates, hotspot locations, and district-wise crime patterns. Developed 34+ analytical SQL queries using CTEs, window functions, joins, subqueries, aggregations, and ranking functions to generate business insights and surveillance analytics.

SQL MySQL Data Cleaning Data Validation Window Functions SQL Joins Aggregation

Data Analyst Intern

SupplyLens

Analyzed 180,000+ supply chain records across 45 features to identify operational bottlenecks in delivery performance, profitability, and customer segmentation. Built a multi-page interactive Streamlit dashboard featuring KPI cards, univariate, bivariate, and multivariate analysis with strategic executive recommendations.

Python Streamlit Plotly Pandas Power BI DAX Data Cleaning EDA KPI Reporting

Data Analyst Intern

IMDb

Built a 5-page interactive Power BI dashboard covering box office performance, genre popularity, ratings, and revenue trend analysis. Used Power Query for data transformation and DAX for KPI measures including total revenue, average ratings, and genre-wise performance metrics.

Power BI Power Query DAX data transformation KPIs

Data Analyst Intern

TravelTriangle

Scraped 1,100+ travel packages from TravelTriangle using BeautifulSoup, extracting destination, package type, duration, and pricing attributes. Performed data cleaning including type conversion, null checks, and duplicate detection; conducted EDA on pricing patterns across Goa, Kerala, and Andaman.

Python BeautifulSoup Pandas Matplotlib SeaBorn Data Cleaning EDA