Summary
Overview
Work History
Education
Skills
LANGUAGES
Hobbies and Interests
Accomplishments
Timeline
Generic

SHIVAM YADAV

Delhi

Summary

Senior Data Analyst with 5+ years of experience delivering data-driven solutions across analytics, BI, and data engineering. Proven expertise in Python, SQL, Power BI, Tableau, and Azure Cloud, enabling the development of predictive models, automated workflows, and actionable dashboards. Experienced in data governance, client management, and cross-team collaboration, consistently improving operational efficiency and decision-making.

Overview

6
6
years of professional experience

Work History

Senior Associate

Coforge
02.2024 - Current
  • Led data operations initiatives, including data extraction, cleaning, and structuring to drive efficient marketing campaign execution.
  • Developed automated workflows and implemented standardized processes, improving campaign data accuracy and turnaround time.
  • Performed advanced SQL-based audience segmentation and list pulls for highly targeted campaigns.
  • Built interactive dashboards and reports using Power BI, Tableau, Advanced Excel, and SQL to track KPIs and optimize campaign performance.
  • Created SOPs, project templates, and data governance documents to maintain consistency, quality, and compliance across projects.
  • Conducted campaign requirement gathering through kickoff and review calls, ensuring alignment with business objectives.
  • Analyzed large customer datasets to identify trends, generate actionable insights, and anticipate customer needs.

Senior Data Analyst

Wunderman Thompson Studios
03.2022 - 12.2023
  • Collected and cleaned audience data to ensure accuracy and readiness for targeted marketing campaigns.
  • Built automated ETL workflows to segment and prepare audience datasets, reducing manual errors and processing time.
  • Designed and developed interactive Power BI dashboards to monitor audience performance and engagement trends.
  • Performed trend analysis and forecasting using Excel and DAX to optimize audience targeting strategies.
  • Collaborated with stakeholders to refine audience lists and ensure precise campaign delivery.
  • Created automated reports and visualizations to deliver clear, actionable audience insights.

Senior Technical Specialist

Concentrix
09.2019 - 03.2022
  • Performed data scrubbing and validation of customer support records to ensure accuracy and completeness for reporting and analysis.
  • Tracked and analyzed CSAT and DSAT metrics using Excel dashboards, enabling teams to identify service gaps and improve customer experience.
  • Developed automated Excel trackers and pivot-based reports to monitor case status, SLA adherence, and escalation trends.
  • Extracted and processed technical support data from CRM and ticketing systems for weekly and monthly performance reviews.
  • Leveraged Excel macros, VLOOKUP, and advanced formulas to streamline repetitive reporting tasks, reducing manual effort by 15–20%.
  • Collaborated with support teams to analyze escalation patterns and provide data-driven insights for issue resolution and workflow optimization.


Education

B.Tech - Computer Science & Engineering

Anand Engineering College
Agra
01.2019

Class 12 (CBSE) - undefined

USSN INT College
01.2015

Class 10 (CBSE) - undefined

Little Flower School
01.2013

Skills

  • Programming & Querying: SQL, Python (Data Validation, Automation)
  • Data Visualization: Power BI, Tableau, Excel (Pivot Tables, Macros, Advanced Formulas)
  • Data Operations: Data Cleaning, Extraction & Enrichment, Campaign Data Management
  • Tools & Platforms: Google Sheets, Microsoft Excel, Power BI Service
  • Statistical & ML Techniques: Regression, Clustering, Predictive Modeling

LANGUAGES

English – Native or Bilingual Proficiency
Hindi – Native or Bilingual Proficiency

Hobbies and Interests

Artificial Intelligence | Data Visualization | Technology Trends | Business Intelligence | Process Automation | Tech Gadgets | Machine Learning

Accomplishments

  • Developed a Python-based data validation tool, improving data quality checks by 20%.
  • Created Python automation scripts to manage and reconcile inventory data, reducing manual effort by 25%.
  • Built productivity tracking dashboards in Power BI/Excel, enabling real-time monitoring of team performance and KPIs.
  • Developed advanced Excel macros to automate recurring data processing tasks, reducing manual reporting time by 30%.

Timeline

Senior Associate

Coforge
02.2024 - Current

Senior Data Analyst

Wunderman Thompson Studios
03.2022 - 12.2023

Senior Technical Specialist

Concentrix
09.2019 - 03.2022

B.Tech - Computer Science & Engineering

Anand Engineering College

Class 12 (CBSE) - undefined

USSN INT College

Class 10 (CBSE) - undefined

Little Flower School

Similar Profiles

CREATE PROFILE
SHIVAM YADAV