Ayan Debnath

Data Analyst

Kolkata, India 1+ yrs exp 82 · Excellent

About

Results-driven Data Analyst experienced in leveraging SQL, Python, Tableau, and Power BI to translate complex datasets into actionable business strategies. Expertise in KPI tracking, funnel analysis, and reporting automation to optimize performance, improve ROI, and support cross-functional stakeholder decisions.

Skills & Expertise (23)

Python Intermediate

6.2/10

Years Exp

Pandas Intermediate

6.0/10

Years Exp

Power BI Intermediate

6.0/10

Years Exp

NumPy Intermediate

5.5/10

Years Exp

Tableau Intermediate

5.5/10

Years Exp

SQL Intermediate

5.5/10

Years Exp

Google Analytics Intermediate

5.0/10

Years Exp

Git Intermediate

5.0/10

Years Exp

Advanced Excel Intermediate

5.0/10

Years Exp

A/B testing Intermediate

5.0/10

Years Exp

Power Query Slack Google Sheets GitHub Cohort Analysis KPI Tracking EDA Exploratory data analysis DAX SQLite Joins Window Functions CTEs

Work Experience

Data Science Intern

Lab Mentics

Aug 2025 - Feb 2026

Cleaned and preprocessed 50,000+ records using Python to standardize data pipelines and improve data quality. Designed interactive dashboards and EDA reports to communicate actionable insights effectively to stakeholders. Built and evaluated classification models using Scikit-learn, achieving 82% prediction accuracy.

Media Buyer

Growth Studioz LLP

Jun 2023 - Oct 2023

Analyzed CPC, CTR, and ROAS across digital ad campaigns, improving overall ROI by 18%. Automated weekly performance reporting in Power BI, reducing manual extraction effort by 40%. Implemented audience segmentation strategies that increased user engagement rates by 22%.

Content Manager

Klarecon Ltd

Oct 2022 - Feb 2023

Leveraged Google Analytics insights to optimize content reach, increasing organic traffic by 25%. Conducted systematic A/B testing on landing pages, improving conversion rates by 15%.