Ayan Debnath

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.

Data Science Intern - Lab Mentics

(2025-08 - 2026-02)

• 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

(2023-06 - 2023-10)

• 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

(2022-10 - 2023-02)

• 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%.

BMS - Advertising - NSHM School of Media and Communications