Aditya Mittal
Bangalore,India
Summary
Innovative Senior Data Analyst with knack for transforming complex datasets into actionable insights that drive business strategy. Delivered key improvements in data accuracy and reporting efficiency, enhancing decision-making processes across departments. Known for fostering collaboration and leveraging analytical tools to uncover opportunities for growth and optimization.
Overview
4
4
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work History
Senior Data Analyst
Criteo
Gurugram
10.2024 - 01.2025
- Process Automation: Develop and implemented an automated overspending alert system on the Criteo platform, resulting in a potential EUR 50k/month revenue uplift and reducing the commercial team's workload by 5+ hours/week through real-time monitoring of daily and monthly overspending.
- Strategic Analytics Leadership: Demonstrate thought leadership by collaborating with stakeholders to develop and launch analytics products, understanding business processes, ensuring data quality, and fostering strong stakeholder relationships to identify opportunities and enhance business acumen
Data Analyst
Criteo
Gurugram
04.2022 - 09.2024
- Strategic Campaign Management: Performed day-to-day data analysis by extracting and analyzing 500+PB of data using SQL, Python, Hive and Presto across Vertica and Hadoop clusters. Delivered actionable insights to support the commercial team in optimizing decision-making. Led the development and execution of targeted marketing campaigns for various products like video, retargeting, branding, etc. through audience segmentation and campaign optimizations.
- Email Alerting System for Agencies: Designed and implemented an automated email alerting system to monitor campaign performance and spending for various APAC markets with reports tailored to market needs. This system reduced AX manual effort by decreasing the number of tickets from 16 per week to 7 per week and saving 20 hours of team effort per week. Streamlined agency collaboration, enabling timely issue resolution and supporting 200+ campaigns across the region.
- Streamlined Reporting with Automated Dashboards: Developed 2-3 tableau dashboards to automate the reporting for the APAC region, covering all retailers and audience extension campaigns. Replaced manual ticket-based data retrieval process with real-time dashboards by creating automated daily pipelines using BDF jobs. This initiative reduced manual effort by 50% empowered the team with on-demand data access and significantly improved operational efficiency.
- Automated Deck Generation via Cron Jobs: Led the development of an automated post-campaign analysis deck creation process and seamlessly integrate them via slack. This initiative reduced manual effort for the commercial team by 70%, streamlining process and enhancing productivity. Supporting 60+ campaigns with actionable insights.
- Audience Targeting and Cohorts: Collaborated with brands and retailers to design and deliver data driven audience cohorts. Analyzed consumer behavior and segmented audiences, leading to improved campaign precision and contribution to an estimated 20% increase in client ROI. Supported over 50+ campaigns across diverse industries, driving measurable outcome.
Consultant
Fractal Analytics
Gurugram
10.2020 - 03.2022
- Territory Optimization and Capacity Analysis: Led an initiative to optimize territories to maximize sales impact while minimizing costs
- Utilized key metrics to evaluate territories, recommending resource reallocation and new resource deployment
- Successfully forecasted future capacity and targeted accounts for optimal resource utilization
- Time Series Forecasting: Developed an ARIMA (3,0,3) model to forecast quarterly sales for a business line, achieving a MAPE of 10% in training and 15%-18% in testing
- Integrated the model into the existing Einstein Platform, transforming it from a black box into a transparent tool, enhancing end-user comprehension and application accuracy
Education
M.Sc. - Applied Operational Research
University of Delhi
India 06.2018 - 06.2020
B.Sc. - Mathematics Honours
University of Delhi
India 06.2014 - 06.2017
Skills
- Git
- Python
- SQL
- Hive
- Tableau
- Time Series
- AB Testing
- Advanced Excel
- Data Visualization
- Consumer Insights
- Post Campaign Analysis
- Digital Marketing
- Performance Marketing
- Machine Learning Algorithms
- Supervised Learning
- Presentation SKill
- Communication Skill
- Problem Solving
- Product Knowledge
- Innovative Thinking
- Process Optimization
- Mentorship & Trainings
sections.external_links.name
Certification
- KPMG Data Analytics Consulting Virtual Internship
- Introduction to Python
- Social Media Advertising
- Retail Media Platform Certification
- Linear Regression for Business Statistics
- Introduction to Big Data
Additional Information
Currently based in India, open to relocation for the right opportunity. Highly motivated to contribute to a global organization and willing to obtain necessary work authorization with employer support.
Timeline
Senior Data Analyst
Criteo
10.2024 - 01.2025
Data Analyst
Criteo
04.2022 - 09.2024
Consultant
Fractal Analytics
10.2020 - 03.2022
M.Sc. - Applied Operational Research
University of Delhi
06.2018 - 06.2020
B.Sc. - Mathematics Honours
University of Delhi
06.2014 - 06.2017
Similar Profiles
Babli RBabli R
Technical Solutions Engineer at CriteoTechnical Solutions Engineer at Criteo
Ana Romero-TschannAna Romero-Tschann
Senior Manager SP&O GTM at CriteoSenior Manager SP&O GTM at Criteo
Asheesh VermaAsheesh Verma
Team Lead, Technical Solutions - Reseller & Agency at CriteoTeam Lead, Technical Solutions - Reseller & Agency at Criteo