Portfolio - Gaurav Birari

Gaurav Birari

Data Analyst

[email protected]

PHONE

+971 507624463

Download CV

About Me

I began my journey in Civil Engineering, but it was at Amazon as an SPS Associate that I discovered my real passion—fixing data anomalies. After streamlining SQL workflows and improving support metrics, I was hooked on data.

Since then, I’ve unified 10+ disparate sources into Snowflake pipelines for 600+ eCommerce brands at Pattern, cutting dashboard inaccuracies by 25% and speeding up insights. At Clearlink, I manage 50+ Looker models, optimized GA4/GTM analytics to surface 20% deeper user insights, and contributed to AI initiatives that automated core metrics for marketing teams.

I thrive where analytics is about asking better questions, not just dashboards. Going forward, I want to keep applying analytics to solve marketing and business problems, while integrating AI to make insights more powerful and scalable.

2

PowerBI Projects

1

Python Project

1

SQL Project

1

Excel Project

Key Skills

SQL

Data Visualization

Data Modeling

Python

Pandas

Google Analytics

Redshift

Snowflake

Power BI

Looker

My Projects

My Experience

Marketing Analyst,

Clearlink/ Core Delivery, Utah, USA

Dec 2024 – Present

● Maintained 50+ data models, metrics, and dashboards in Looker BI, increasing reporting efficiency by 30% and accelerating strategic insights. ● Executed 100+ SQL queries in Amazon Redshift, enhancing data accuracy and access for 200+ users while reducing inconsistencies by 25%. ● Leveraged GA4 and GTM to refine campaign analytics, increasing insight depth by 20% and improving ad targeting precision. ● Influenced AI-focused analytics strategy by shaping data modeling and automation outcomes across 3 strategic initiatives.

Data Analyst,

Pattern, Utah, USA

Sep 2023 – OCT 2024

● Optimized processing of 1TB+ datasets (20M+ rows) by converting R scripts to Python, boosting team efficiency and improving report accessibility. ● Consolidated 10+ disparate data sources into unified Snowflake queries for 600+ brands, improving dashboard accuracy by 25% and reducing retrieval time by 15%. ● Architected and delivered 50+ BI dashboards, enhancing strategic visibility; mentored a team of 10 to elevate analytical capabilities. ● Ensured 100% data accuracy in eCommerce uploads, increasing marketplace compliance to 98% and boosting visibility for 500+ products.

SPS Associate,

Amazon, Bengaluru, India,

Jun 2022 - Aug 2023

● Revamped Amazon partner support operations by implementing structured data management and cleaning processes, reducing performance anomalies by 28% and improving key metric performance by 6%. ● Conducted comprehensive reviews of support workflows, identifying inefficiencies that decreased discrepancies and errors by 12%, while improving response times and partner satisfaction. ● Implemented documentation standards using Microsoft Office tools, improving workflow clarity and decreasing the PAA metric by 28%.