Soumya Chander Upadhyay
Summary
Programmatic Associate with 2+ years of experience analyzing large-scale marketing and campaign datasets to drive performance optimization. Proficient in SQL, Python, and data visualization tools to extract insights, identify trends, and support data-driven decision-making. Strong experience working with real-time data, building reports, and improving business outcomes through analytical problem-solving.
Overview
2
2
years of professional experience
Work History
Programmatic Operations Associate
Omnicom Media Group
2024.05 - Current
- Analyzed performance data across 40+ concurrent campaigns, identifying trends and optimization opportunities to improve key performance metrics.
- Processed and interpreted large datasets from multiple DSP platforms to evaluate audience behavior and campaign effectiveness.
- Designed and implemented budget pacing strategies, ensuring 100% budget utilization while improving conversion outcomes.
- Built performance reports and dashboards to track KPIs, and support data-driven decision-making.
- Conducted ongoing data monitoring and analysis to identify anomalies, inefficiencies, and optimization opportunities.
- Collaborated with stakeholders to deliver data-backed insights and actionable recommendations.
Analyst Projects
2025.05 - 2026.02
Retail Sales Analysis (SQL) Customer / Data Analysis Project (Python)
- Cleaned and transformed raw retail data using SQL (joins, CTEs, and window functions).
- Analyzed sales trends, customer behavior, and product performance.
- Identified key revenue drivers and high-value customer segments.
- Generated insights to support business decisions related to pricing and inventory.
- Conducted exploratory data analysis using Pandas and NumPy.
- Identified patterns and trends in structured datasets.
- Built visualizations to communicate insights effectively.
- Derived actionable insights to support decision-making.
Education
BBA - Marketing Management
Singapore Management University
Singapore2023-05
Skills
Programming & Data Analysis: SQL (Advanced), Python (Pandas, NumPy)
Data Visualization: Power BI (DAX, Dashboards), Tableau
Analytics Tools: Google Analytics 4 (GA4)
Data Handling: Data Cleaning, EDA, Data Transformation
Excel: Advanced Excel (VBA, Pivot Tables, Lookup Functions)
Timeline
Analyst Projects
2025.05 - 2026.02
Programmatic Operations Associate
Omnicom Media Group
2024.05 - Current
BBA - Marketing Management
Singapore Management University