Back to Developers
Gautam Bhardwaj

Gautam Bhardwaj

Data Analyst

New Delhi, India 0+ yrs exp 85 · Excellent

About

Data Analyst with advanced Excel proficiency (pivot tables, complex formulas, VLOOKUP/SUMPRODUCT) and experience building automated reporting solutions and BI dashboards. Former Data Analyst Intern at an ad-tech platform, where I delivered daily/weekly MIS-style reports across 36+ data sources, audited 20-50 partner accounts for accuracy, and built performance dashboards (Looker Studio) and scorecards for stakeholders. Automated a manual reporting workflow, cutting turnaround by 70%+. Served as sole point of contact for a live external enterprise account. High attention to detail, comfortable managing multiple priorities, and a fast learner. MCA candidate (BCA foundation).

Skills & Expertise (22)

Python Intermediate
7.5/10
1
Years Exp
Pandas Intermediate
7.5/10
1
Years Exp
NumPy Intermediate
7.5/10
1
Years Exp
Statistical Analysis Intermediate
7.5/10
1
Years Exp
Feature Engineering Intermediate
7.5/10
1
Years Exp
LightGBM Intermediate
6.5/10
1
Years Exp
Jupyter Notebook Intermediate
6.5/10
1
Years Exp
VS Code Intermediate
6.5/10
1
Years Exp
Git Intermediate
6.5/10
1
Years Exp
SQLite Intermediate
6.5/10
1
Years Exp
Power BI Intermediate
6.5/10
1
Years Exp
Seaborn Intermediate
6.5/10
1
Years Exp
Matplotlib Intermediate
6.5/10
1
Years Exp
Google Sheets Intermediate
6.5/10
1
Years Exp
Looker Studio Intermediate
6.5/10
1
Years Exp
Cross-Validation Intermediate
6.5/10
1
Years Exp
VLOOKUP Intermediate
6.5/10
1
Years Exp
Aggregations Intermediate
6.5/10
1
Years Exp
Subqueries Intermediate
6.5/10
1
Years Exp
Joins Intermediate
6.5/10
1
Years Exp
Data Cleaning & Validation Intermediate
6.5/10
1
Years Exp
Pivot Tables Intermediate
6.5/10
1
Years Exp

Work Experience

Data Analyst Intern (Ad Operations)

JustBaat Mediatech

Jun 2026 - Aug 2026

Designed and shipped a Revenue Analytics Dashboard (Google Sheets → Looker Studio) monitoring SSP/DSP revenue across multiple advertising partners. Diagnosed a demand-side performance gap by comparing endpoint-level revenue against request volume. Built an automated Python reporting solution for daily MIS-style revenue reports. Managed data configuration and accuracy for external partner accounts. Sole point of contact for a live external enterprise account. Audited supply and demand partner accounts. Rebuilt a manual VLOOKUP/SUMPRODUCT banner-inventory lookup in Python. Sourced and qualified B2B partners across international publishers, DSPs, and OTT platforms. Built a formula-driven Google Sheets dashboard aggregating outreach data.

Education

Master of Computer Applications (MCA) - Jagannath Community College, Jagannath University

2025 - · Afghanistan

Bachelor of Computer Applications (BCA) - College of Architecture and Design, MDU

2022 - 2025 · Afghanistan

Certifications

AI Appreciate Badge

CBSE and Intel · 2026

Academic Process Mining Fundamentals

Celonis · 2026

Introduction to Data Analysis Using Microsoft Excel

Coursera · 2025

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceSep 2026