Open to opportunities

Watan Asthana

@watanasthana

Message

I am a data analyst delivering insights with SQL, Python, and BI.

India

Message

What I'm looking for

I want a mid-level data role where I can build dashboards, automate workflows, and use SQL/Python to improve e-commerce operations and retention within a collaborative, impact-driven team.

I am a data analyst specializing in SQL, Python and BI tools, focused on turning data into actionable insights for e-commerce and operations.

I automated inventory reporting using Excel and BigQuery, cutting manual effort by 30% and enabling faster decisions; developed SQL window-function logic to detect vendor fulfillment failures, improving fulfillment rate by 12% and supporting campaign planning that increased orders by 15%. I also automated Excel tasks with Python (pandas), saving over 10 hours monthly.

I build interactive dashboards in Power BI and Google Data Studio, perform cohort and retention analysis, and deliver operational insights for logistics and CRM collaboration. I seek to apply these skills to drive measurable improvements and support data-driven decision-making in collaborative teams.

Experience

Work history, roles, and key accomplishments

Current

Executive

Current

Boodmo

Nov 2023 - Present (1 year 10 months)

Automated inventory reporting using Excel and BigQuery, reducing manual effort by 30% and enabling faster decision-making. Identified top-performing brands and planned weekly campaigns that increased orders by 15% and improved fulfillment rate by 12%.

BigQuery SQL Excel Power BI Google Data Studio Cohort Analysis Automation)

Junior Data Analyst

Ambiwo

Jul 2022 - Aug 2023 (1 year 1 month)

Used MySQL to analyze and transform marketing and sales data and built Excel and Power BI dashboards that improved stakeholder decision-making and customer engagement.

MySQL Excel Power BI Data Analysis Reporting Dashboarding SQL Stakeholder Engagement

Quality Engineer

Usaka Engineers

Oct 2021 - Jul 2022 (9 months)

Conducted root cause analysis of customer complaints, reducing recurring issues by 25%, and applied statistical process control to improve component quality, reducing defects by 15%.

Root Cause Analysis Quality Improvement Data Analysis Process Improvement Excel