Dishant Vaswani

Stock Market Watchlist Pipeline

Automated US and NSE stock price ingestion using Apache Airflow, scheduled every 5 minutes during market hours. Implemented MySQL storage and Gmail alerts for configurable price thresholds with cooldown logic. Built a Streamlit–Plotly dashboard for price monitoring and integrated GitHub Actions for CI checks.

Walmart data analysis

• Built an end-to-end ETL pipeline for Walmart sales data — extracted and cleaned raw data using Pandas (standardized columns, engineered a total-amount feature), then loaded it into a MySQL data warehouse via SQLAlchemy for structured querying. • Wrote SQL queries to identify peak sales hours, top- performing branches, and high-margin vs. high-revenue categories, and ran data quality checks to catch inconsistencies before analysis.

Financial EDA

Applied advanced SQL — multi-level CTEs, subqueries, and window functions — to analyze corporate financial data, including boundary/data-quality validation checks, uncovering time-series trends and sector-level risk concentration in large-scale datasets.