Skip to main content
Pritiswony MohapatraPM
Open to opportunities

Pritiswony Mohapatra

@pritiswonymohapatra

Media Planner & Campaign Analyst optimizing US digital ads with CPM modeling, KPI insights, and automation using Python and SQL.

India
Message

What I'm looking for

I’m looking to own end-to-end digital campaign performance, use Python/SQL automation for reporting, and apply CPM/KPI analytics to maximize ROI. I want a data-driven team where I can optimize spend, improve dashboards, and deliver insights fast.

I’m a results-driven Media Planner & Campaign Analyst with 10+ months of hands-on experience managing end-to-end digital advertising campaigns, budget planning, and performance analytics for US-based markets. I turn campaign data into actionable insights that optimize spend, improve ROI, and drive measurable results.

In my current work at MediaMint, I manage 60+ digital campaigns across short-form and long-form video placements, targeting US audiences using demographics, age groups, and zip-code level geographies. I model CPM, monitor KPIs like CTR, impressions, reach, frequency, and engagement, and recommend data-driven optimizations for underperforming segments.

I also developed and delivered 60+ RFPs within a 3-month period, aligning client budget requirements with publisher inventory and audience reach goals while consistently meeting deadlines. My approach emphasizes cost-vs-performance analysis, clear client communication, and stakeholder-ready reporting to support faster decisions.

Beyond campaign operations, I automate reporting workflows with Python and SQL and build dashboards in Power BI and Tableau to keep insights current and scalable. I’ve also built an AI-powered campaign data analysis tool using Python, Pandas, Flask, and Hugging Face LLM APIs to generate plain-language performance summaries for non-technical stakeholders.

Experience

Work history, roles, and key accomplishments

Education

Degrees, certifications, and relevant coursework

Siksha 'O' Anusandhan Deemed University logoSU

Siksha 'O' Anusandhan Deemed University

Bachelor of Technology (B.Tech), Computer Science & Engineering

2021 - 2025

Grade: CGPA: 7.42

Earned a B.Tech in Computer Science & Engineering from Siksha 'O' Anusandhan Deemed University, Bhubaneswar (CGPA: 7.42).

Tech stack

Software and tools used professionally

Find your dream job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan