ayaz khan

Data Analyst

Pune, Maharashtra 3+ yrs exp 87 · Excellent

About

Data Analyst with 3.8 years of experience in data analysis, data validation, quality checks, reporting automation, and business intelligence. Skilled in SQL, Python, BigQuery, Snowflake, Tableau, Looker Studio, Excel, and Adverity. Experienced in analyzing large datasets, identifying data inconsistencies and anomalies, validating data accuracy and completeness, transforming data from multiple sources, and delivering reliable analytical outputs. Strong experience in KPI reporting, data quality checks, ETL workflows, dashboard development, and cross-functional collaboration.

Skills & Expertise (35)

SQL Advanced

8.0/10

3.8

Years Exp

Python Advanced

8.0/10

3.8

Years Exp

Tableau Desktop Intermediate

7.5/10

3.8

Years Exp

Pandas Intermediate

7.5/10

3.8

Years Exp

NumPy Intermediate

7.0/10

3.8

Years Exp

Data Wrangling Intermediate

7.0/10

3.8

Years Exp

ETL Intermediate

7.0/10

3.8

Years Exp

Excel Intermediate

7.0/10

3.8

Years Exp

Looker Studio Intermediate

7.0/10

3.8

Years Exp

Data Modelling Intermediate

6.5/10

3.8

Years Exp

Data Validation Intermediate

6.5/10

3.8

Years Exp

Predictive Modelling Intermediate

6.5/10

3.8

Years Exp

scikit-learn Intermediate

6.5/10

3.8

Years Exp

Clustering Intermediate

6.5/10

3.8

Years Exp

Classification Intermediate

6.5/10

3.8

Years Exp

Regression Intermediate

6.5/10

3.8

Years Exp

Matplotlib Intermediate

6.0/10

3.8

Years Exp

K-Means Intermediate

6.0/10

3.8

Years Exp

Naive Bayes Intermediate

6.0/10

3.8

Years Exp

KNN Intermediate

6.0/10

3.8

Years Exp

Decision Trees Intermediate

6.0/10

3.8

Years Exp

Random Forest Intermediate

6.0/10

3.8

Years Exp

Seaborn Intermediate

6.0/10

3.8

Years Exp

AWS EC2 Intermediate

6.0/10

3.8

Years Exp

Snowflake Intermediate

6.0/10

3.8

Years Exp

BigQuery Intermediate

6.0/10

3.8

Years Exp

Query Optimization Intermediate

6.0/10

3.8

Years Exp

Databricks Intermediate

5.5/10

3.8

Years Exp

XGBoost Intermediate

5.5/10

3.8

Years Exp

SVM Intermediate

5.5/10

3.8

Years Exp

Dimensionality Reduction Intermediate

5.5/10

3.8

Years Exp

Meta Ads Intermediate

5.0/10

3.8

Years Exp

Google Ads Intermediate

5.0/10

3.8

Years Exp

SQL Server Tableau Cloud

Work Experience

AI Analyst - Reporting & Analytics

Admedia

Feb 2025 - Aug 2026

Managed weekly and monthly reporting for multiple global clients, delivering accurate performance insights and dashboards across digital media campaigns. Used SQL for data extraction, transformation, validation, analysis, and reporting. Built automated data workflows using Adverity, connecting multiple platforms and data sources for centralized reporting. Developed Looker Studio dashboards to visualize key metrics including spend, impressions, clicks, conversions, revenue, CPM, CTR, and ROAS. Created Adverity enrichments and reporting transformations for clients including Kohls, Choice Hotels, and other global clients and collaborated with analytics, media, and client teams to ensure data accuracy and resolve data issues.

Senior Analyst - Reporting & Analytics

IPG Mediabrands

Jan 2023 - Feb 2025

Led weekly, monthly, and adhoc reporting for the AWS account across the Global region, delivering data-driven insights and maintaining reporting accuracy. Used Python, SQL, and Excel for data processing, analysis, extraction, validation, and reporting. Automated Excel reporting workflows using Python, reducing manual effort and improving efficiency. Developed and published interactive Tableau dashboards on Tableau Cloud, enabling effective data visualization and self-service reporting. Collaborated with cross-functional teams and clients including AWS, Coca-Cola, Nike, CVS Health, and Upwork for campaign trafficking, quality assurance, data collection, and analysis.