Nikita Dongre

About Nikita Dongre

Data analyst with a Master\'s in Computer Science and a passion for turning complex datasets into clear, actionable insights.I\'ve built end-to-end analytics projects analyzing records — from data cleaning and SQL optimization to executive dashboards and strategic recommendations.What I bring to the table: Dashboard Design — Built 4-panel executive dashboards and interactive Excel reports that cut ad-hoc requests by 50% SQL & Data Analysis — 15+ optimized queries (CTEs, window functions, joins) across 100K+ transactions KPI Tracking — Identified 3.75× churn rate and 76% adoption gaps to inform retention strategy🧹 Data Quality — Resolved schema mismatches, nulls, and duplicates improving accuracy by 35%Tools: Python (Pandas, Matplotlib, Seaborn) · SQL · Excel (Pivot Tables, Power Query) · Tableau · Jupyter Notebook Fun fact: I\'m a National Football Player who represented India — I bring the same teamwork, resilience, and competitive drive to every analytics challenge. Portfolio: github.com/Nikita-Dongre Open to Data Analyst, Client Analyst, and BI Analyst roles (remote & on-site) Authorized to work in the U.S. — No sponsorship required.

Experience

1. Data Analyst Independent Analytics Projects

   Independent Analytics

   Jun 2024 — Present · Fremont, CA, US

   Building end-to-end data analytics projects using Python, SQL, Excel, and Tableau:• Analyzed records across 4 datasets to evaluate AI feature adoption across users for a B2B SaaS platform. Built a 4-panel executive dashboard and delivered a strategic memo to VP of Product.• Developed 15+ optimized SQL queries (CTEs, window functions, joins) to analyze retail transactions, improving reporting accuracy by 35% and reducing review time by 40%.• Created an interactive Excel dashboard with Pivot Tables, Power Query, and dynamic charts analyzing records across 20+ categories. Reduced ad-hoc reporting requests by 50%.• Conducted market analysis on NYC Airbnb listings, producing 10+ visualizations (heatmaps, scatter plots, trend lines) to surface pricing and availability insights.

Education

• Savitribai Phule Pune University (SPPU)

  Master of Science (M.Sc.), Computer Science

• Savitribai Phule Pune University (SPPU)

  Bachelor of Science (B.Sc.), Computer Science