Pritiswony Mohapatra
@pritiswonymohapatra
Media Planner & Campaign Analyst optimizing US digital ads with CPM modeling, KPI insights, and automation using Python and SQL.
What I'm looking for
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
Media Planner & Campaign Analyst
MediaMint
Feb 2025 - Dec 2025 (10 months)
Managed end-to-end media planning for 60+ US digital campaigns across news and sports channels, delivering 60+ RFPs in a 3-month period. Modeled CPM performance, optimized budgets for ROI, and built Python/SQL reporting workflows to accelerate stakeholder decision-making.
Education
Degrees, certifications, and relevant coursework
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).
Availability
Location
Authorized to work in
Job categories
Skills
Interested in hiring Pritiswony?
You can contact Pritiswony and 90k+ other talented remote workers on Himalayas.
Message PritiswonyFind 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!
