Deekshya Singh Deo
Senior Marketing Science Analyst-Reporting and Insights
Summary
Dynamic Senior Marketing Science Analyst with expertise in Advanced SQL ,Visualization tools,Python EDA and automating and formulating MS Excel sheets .Proven track record in delivering actionable insights and optimizing campaign performance. Skilled in stakeholder communication and team leadership, driving continuous improvement through innovative data solutions and automation tools. Passionate about leveraging data for strategic decision-making.I excel in delivering impactful solutions that optimize data-driven decision-making and improve operational efficiency.
Overview
7
7
years of professional experience
Work History
Senior Marketing Science Analyst
Omnicom-Annalect
03.2022 - Current
- Took lead from Annalect India in managing stakeholder and client communications, ensuring smooth requirement gathering and on-time delivery of tasks for PHD-UK Project.
- Built and maintained multi-client dashboards using Power BI and Looker Studio, aligned to campaign KPIs(CTR,CPM,CPC,ROI,ROAS) across brands like BHF, VWG Group, Home Instead, and more.
- Utilized BigQuery and Starburst to write and optimize SQL queries for transforming platform data into actionable insights to help Digital Performance Team.
- Handled network-level campaign reporting via Campaign Manager 360 (CM360), ensuring accurate tracking and alignment with internal systems.
- Applied Python (NumPy, Pandas) for EDA , Regression,Normalization and in-depth data checks across multi-source media performance datasets.
- Developed Excel-based automation tools using advanced formulas, macros, and button-based interfaces to simplify recurring reporting workflows.
- Designed and maintained internal solutions using Power Apps and SharePoint Lists to track ad hoc requests, issue logs, and internal task management.
- Implemented Power Automate flows to trigger stakeholder-specific Teams/email alerts for campaign and delivery updates.
- Delivered structured training to new team members on SQL logic, CM360 reporting workflows, dashboard standards, and client communication practices.
- Spearheaded the development of an AdOps Audit Tool to identify delivery gaps, campaign mismatches, and ensure data consistency across platforms.
Last Mile Quality Analyst-Data Support Engineer
Amazon
09.2018 - 03.2022
- Queried operational data using Amazon Redshift (via SQL Workbench/Hubble) to support deep dives, business audits, and ad hoc data requests.
- Built and maintained Tableau dashboards to visualize quality metrics, audit trends, and SLA status for leadership reviews.
- Delivered Weekly WBR and Monthly MBR reports (Manual Business Tracking) to monitor audit volumes, exception rates, and team performance.
- Tracked and reported utilization and productivity metrics, enabling workforce planning and shift optimizations.
- Designed custom Excel-based automation trackers for SLA monitoring, ticket resolution, and audit flag trends.
- Maintained and updated SharePoint Lists for real-time visibility into ad hoc tasks, issue logging, and follow-up tracking.
- Led a 10-member SPOC team, managing day-to-day audit operations, SLA adherence, and resolution of quality issues across global fulfillment processes.
- Provided regular updates to team leadership on quality metrics by communicating consistency problems or production deficiencies.
- Collaborated with cross-functional teams to develop and implement targeted solutions for identified quality issues, ensuring continuous improvement.
- Authored and regularly updated SOPs (Standard Operating Procedures) for escalation handling, ticket triaging, and data documentation.
Education
Post Graduate Diploma - Data Science
IIIT Bangalore
Bengaluru, India 04.2001 -
Btech - Electrical, Electronics And Communications Engineering
Sathyabama University
Chennai, India 04.2001 -
Junior High/Intermediate/Middle School Education -
ODM International
Bhubaneswar 04.2001 -
Skills
Advanced SQL
Google Big Query
Power BI
Looker Studio
Tableau
Python(NumPy & Pandas)
Starburst
Advanced MS Excel
Power App
Power Automate
Microsoft Power Point
Sharepoint Lists
Campaign Manager 360
Documentation and reporting
Timeline
Senior Marketing Science Analyst
Omnicom-Annalect
03.2022 - Current
Last Mile Quality Analyst-Data Support Engineer
Amazon
09.2018 - 03.2022
Post Graduate Diploma - Data Science
IIIT Bangalore
04.2001 -
Btech - Electrical, Electronics And Communications Engineering
Sathyabama University
04.2001 -
Junior High/Intermediate/Middle School Education -
ODM International
04.2001 -
Awards
- Thankyou Award, Annalect India, Award reflects the high esteem in which you are held by your peers and their collective gratitude for your invaluable contributions.
- Evangelist Award, Amazon, Awarded for raising the bar for ownership, delivering results.
- Sidekick-Salute Award, Amazon, Awarded For managing the floor and keeping the atmosphere of the floor jovial