# Popun Barik

Popun Barik is a remote worker on Himalayas, Associate 2, Quality Analyst at MediaMint, based in India.

Source: https://himalayas.app/@popunbarik

```text
Data Analyst at MediaMint who automated approval tracking, cutting daily manual work by 90%+.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Salary expectations | 140k+ INR |
| Job categories | Data Analyst, Business Intelligence Analyst, Quality Analyst |
| Skills | Data Analysis, SQL, Python, Pandas, NumPy, Power BI, DAX, Data Reconciliation, Data Auditing, Pacing, Discrepancy resolution, Digital Ad Operations, DV360, Google Ads, Meta Ads |
| Website | https://papunbarik.github.io/papun-portfolio |
| Portfolio | https://papunbarik.github.io/papun-portfolio |
| LinkedIn | https://linkedin.com/in/papun-barik |
| GitHub | https://github.com/papunbarik |

## About

```text
At MediaMint, I audit multi-platform media plans and delivery data across DV360, Google Ads, and Meta Ads. I use SQL and Excel to analyze campaign pacing and delivery metrics, and investigate discrepancies between ad servers and reporting systems.

I built a Google Apps Script and webhook engine to automate approval tracking, reducing daily manual work by 90%+. In project work, I reconciled $185K+ in multi-channel spend and created a Power BI pacing dashboard that cut audit turnaround from four hours to 15 minutes.
```

## Experience

### Associate 2, Quality Analyst (current)

MediaMint. Jun 2023 - Present

```text
Audit complex multi-platform media plans and delivery datasets across DV360, Google Ads, and Meta Ads, achieving a 100% precision score. Built a custom Google Apps Script and webhook engine that automated incoming approval tracking, reducing daily manual overhead by 90%+.
```

Skills: SQL, Excel, Google-Apps-Script, Webhooks, DV360, Google-Ads, Meta-Ads, GAM, CM360, Data-Reconciliation, KPI-Analysis, Pacing-Analysis, Discrepancy-Investigation, SLA-Monitoring

## Education

### Siksha 'O' Anusandhan University

Master of Computer Applications, Computer Applications. 2021 - 2023

```text
Pursued a Master of Computer Applications degree, focusing on advanced computing and data analytics.
```

## Tech stack

- Apache Spark
- Google Cloud Storage
- NumPy
- Pandas
- PySpark
- dbt
- Python
- Google Sheets
- Microsoft Excel
- Google BigQuery
- SQL
- Google Ads
- Power BI
- Google Apps Script

To contact Popun, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Irfan khan](https://himalayas.app/@irfankhan): Account Manager, Mediamint Pvt Ltd
- [Piyush User](https://himalayas.app/@piyushRajak): Data Analyst, Highspring
- [Amarnath Nath K](https://himalayas.app/@amarnathnathk): Media Analyst, IOPEX Technologies
- [Viren Solanki](https://himalayas.app/@virensolanki): Data Analyst, WebIndia Inc
- [Manish Das](https://himalayas.app/@manishdas): Senior Analyst, MiQ Digital
- [Preeti Gupta](https://himalayas.app/@preetigupta): Data Analyst, Media.net
- [Itz Ashwani](https://himalayas.app/@itzashwani): Freelance Performance Marketer & Web/App Developer, Self Employed
- [Vivek Shah](https://himalayas.app/@vivekshah2): Senior Data Analyst, Criteo
- [G Yashwanth Reddy User](https://himalayas.app/@gyashwanthreddyuser): Data Analyst Intern, Dollarminds Media LLP
- [Anshu Prasad Sinha](https://himalayas.app/@anshuprasadsinha): Data Associate, MediaRadar
