Romi Gupta

Associate – Ad Operations at VDO.AI (Z1 Tech)

Experience

  • Optimize daily monetization across demand partners (Magnite, Amazon Publisher Services, Adipolo and others) to maximize fill rate, RPM and programmatic yield, improving average yield efficiency by ~18%.
  • Run yield analysis in Google Ad Manager (GAM360) to track inventory performance and pricing and demand trends, and to drive floor price decisions for direct publishers.
  • Rolled out a dynamic price floor optimization workflow using historical yield and revenue analytics, contributing to a ~40% lift in incremental revenue. Now used company-wide.
  • Manage demand partner relationships (Prebid, VAST, oRTB): supply-demand mapping, integration communications, MCM invites and site approvals. Root cause analysis on publisher-side delivery issues cut resolution turnaround by ~30%.
  • Led DV360 campaigns end to end: trafficking, pre and post launch activities, screenshot decks and post-launch analysis reports.
  • Built an automated ads.txt crawler and validator that bulk-checks publisher ads.txt files across thousands of domains, cutting compliance-review time by ~70%.
  • WOW Performer of the Month three times (Feb, May and Jul 2026).
GAM360DV360Prebid / VAST / oRTBMagniteAmazon Publisher ServicesAdipoloFloor Price OptimizationPython (Automation)SQL

Education

PursuingAug 2025 – Jul 2027 (E)

Master of Computer Applications (MCA)

Data Science & Analytics

Indira Gandhi National Open University (IGNOU)

New Delhi

Programme progress

Studying alongside full-time work in ad operations.

CompletedOct 2022 – Aug 2025

Bachelor of Computer Applications (BCA)

Data Science & Analytics

Maharaja Surajmal Institute (MSI)

New Delhi

Skills & Technologies

Programming & Analysis

PythonNumPyPandasMatplotlibBasic ML

Databases & SQL

MySQLSubqueriesJoinsWindow FunctionsCTEsAggregate FunctionsNormalization

Business Intelligence

Power BIPower QueryDAX FunctionsData ModelingTime Intelligence

Excel & Spreadsheet Tools

Pivot TablePower PivotCharts & GraphsConditional FormattingAdvanced Excel Functions

Data Engineering Basic

SnowflakeAirflowPySparkETL Pipeline ProcessesAzure Cloud Platform

Soft Skills

Stakeholder ManagementData Driven SolutionsProblem SolvingCommunication & PresentationCritical Thinking

Projects

Atliq Mart Promotion Analysis & Insights

Atliq Mart Promotion Analysis & Insights

Analyze Promotions and Provide Tangible Insights to Sales Director for Diwali 2025 & Makar Sakranti 2025

ExcelPower BIMysql
Pizza Runner - SQL Case Study

Pizza Runner - SQL Case Study

Pizza Runner is a data-driven case study that combines pizza delivery with 'Uberization' concepts.

Mysql
Car Price Prediction Model

Car Price Prediction Model

A Machine Learning model built using Python and Scikit-Learn to predict car prices.

PythonPandasScikit-Learn
PAN Number Validation Project using MySQL

PAN Number Validation Project using MySQL

This project includes SQL scripts to clean, validate, and categorize PAN numbers as Valid or Invalid based on multiple business rules and regex patterns.

SQLMySQLRegexViewFunction
AtliQ Grands Hospitality Dashboard

AtliQ Grands Hospitality Dashboard

A BI dashboard using Tableau & Excel to analyze hotel booking performance.

TableauExcel
Credit Card Usage Analysis Dashboard

Credit Card Usage Analysis Dashboard

A Power BI dashboard analyzing credit card usage trends.

Power BIExcel
Olympics Data Case Study

Olympics Data Case Study

An SQL-based analytics project on Olympics data.

SQLMySQL
AtliQ Hardware – Finance Analysis & Reporting

AtliQ Hardware – Finance Analysis & Reporting

Finance analytics using Excel and DAX to evaluate company performance.

ExcelDAXVBA