Ashutosh Vats

About Ashutosh Vats

Strategic Product Data Analyst with expertise in defining and implementing product metrics, building interactive dashboards, and delivering actionable insights via SQL, experimentation, and BI platforms. I drive product outcomes by collaborating cross functionally with engineering, marketing, and finance to optimize user experiences and support business decision making.

Experience

1. Data Analyst & Data Engineer

   Merca Applied Sciences Inc

   Apr 2025 — Present

   Developed scalable data pipelines in Google BigQuery for e-commerce data ingestion and transformation, enhancing data availability across teams. Built and deployed predictive models using BigQuery ML to drive customer segmentation and personalized product recommendations. Led UAT testing and validation cycles, ensuring data integrity and accuracy across analytics deployments. Designed and maintained KPI dashboards in Looker Studio, delivering real-time insights on marketing performance and user behavior. Automated critical reporting processes using SQL and Looker Studio, eliminating 152+ hours/year of manual work. Created conceptual data models and mapping documents to standardize structured data workflows and improve data governance. Integrated GA4 and Meta Ads data to deliver unified digital performance reporting, enabling more informed marketing decisions. Automated key analytics workflows, reducing manual effort by 40% and accelerating reporting turnaround times.

Education

• Dav Institute of Engineering and Technology

  Bachelors Degree, Computer Science

  2018 — 2022