Data Analyst (SQL, Python, Power BI/Tableau)

DHRUV SHARMA

Jersey City, NJ +1-201-***-**** ***************@*****.*** LinkedIn GitHub Portfolio SUMMARY

Data analyst with an MS and 4+ years turning data into decisions — SQL and Python analysis, KPI reporting, and dashboards in Power BI and Tableau, with a habit of leading with the number and tying the analysis to an action someone took. EDUCATION

Baruch College, CUNY — MS Business Analytics, Data Analytics Concentration · New York, USA Jan 2024 – Dec 2025 GGSIPU — BBA Business Administration, Economics Concentration · Delhi, India Aug 2018 – Jul 2021 EXPERIENCE

Data Analyst – Growth & Marketing Delta Rising Foundation Mar 2026 – Present Remote – CA, United States

● Caught four issues the team had missed by building a Python (Pandas, NumPy) and SQL pipeline to monitor 1,500+ weekly active users across 6 dimensions — UTM fragmentation across 4 variants, a duplicate homepage pulling 19x the engagement of the canonical URL, an 8–10s page hang running 4 straight weeks, and dead links; the findings became the web team’s fix list.

● Cut weekly reporting from 60 minutes to 15 by replacing a manual workflow with a 5-page dashboard covering traffic, geography, device, conversion, content, and press in one view.

● Drafted the data-warehouse proposal unifying GA4, Google Ads, and Salesforce into BigQuery — 5 fact and dimension tables, ETL workflows, and a lead-funnel schema tracking each visitor from first touch to conversion. Data Analyst Pepperfry Jan 2023 – Dec 2023

On-site – India

● Dropped dashboard load time from 45 seconds to 8 (82% faster) by rebuilding the Power BI data model and DAX layer for the operations dashboards; executive usage picked up noticeably after.

● Cut $350K of excess inventory annually and lifted forecast accuracy 18% by moving the replacement-parts team off cost-based forecasting onto quantity-based KPIs.

● Ran inventory and backorder analysis across 460 SKUs and reported the findings to the replenishment teams, who used them to flag underperformers and plan restocking; owned the Power BI operations layer across 250+ retail stores.

● Built the SQL funnel analytics for the e-commerce site that exposed where customers dropped off, and owned end-to-end reporting for the Voice Sales Program — ETL, validation, and the exec dashboards on top. Data Analyst Odilia Global Dec 2020 – Dec 2022

Remote – India · Client: financial services firm

● Cut average analysis turnaround 20% by running 80+ ad-hoc analyses end-to-end on Snowflake using SQL and Python for client stakeholders.

● Saved 30+ hours a month by replacing daily manual reporting with AWS ETL pipelines (S3, Glue, Redshift) in SQL and Python, then layered Prophet time-series models on top that forecast quarterly revenue at 93% accuracy.

● Added a 20% cross-sell sales lift with a Market Basket Analysis recommender, built on behavioral and risk-appetite segmentation

(SQL, Python, Snowflake) that raised customer engagement 15%. PROJECTS

FIFA World Cup 2026 — Power Analysis & Match-Up Simulator Databricks SQL, Power BI, DAX

● Built a Bronze Silver Gold pipeline in Databricks SQL across 211 ranked teams and 48,891 match results — standardizing names with 18 mapping rules, flattening home/away records with UNION ALL, and scoring teams with COALESCE-tolerant aggregation — then shipped a 4-page Power BI dashboard with a live DAX head-to-head simulator. NYC Airbnb Market Analysis Python (scikit-learn), SQLite · Group project (2-person technical build)

● Co-built an end-to-end pipeline on ~49,000 listings with one teammate — Kaggle-API ingestion, cleaning, and statistical testing: an ANOVA showed room type significantly affects price (p < 0.05), while a price-on-availability regression came back a weak predictor (R

0.014), flagged rather than oversold.

SKILLS

Languages: SQL (joins, CTEs, window functions), Python (Pandas, NumPy, scikit-learn), R BI & Visualization: Power BI (DAX), Tableau, Looker Studio, Excel, Google Sheets, Data Storytelling Analytics & Experimentation: Hypothesis Testing, Regression, Forecasting, A/B Testing, Funnel & Cohort Analysis, Behavioral Segmentation, Classification

Databases & Cloud: Snowflake, BigQuery, PostgreSQL, MySQL, Amazon Redshift, AWS (S3), Databricks Platforms & Tools: GA4, Google Ads, Salesforce, Git, Jupyter, Excel, Google Sheets

Contact this candidate