SHIVAM YADAV
Coforge
Delhi
6
years of professional experience
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.
Work History
Senior Associate
2 Years 8 Months- 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
1 Year 9 Months- 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
2 Years 6 Months- 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
GPA: 65%
Class 12 (CBSE)
- UP Board
- GPA: 68%
Class 10 (CBSE)
- CBSE Board
- GPA: 70%
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 - CurrentRead More
Senior Data Analyst
Wunderman Thompson Studios
03.2022 - 12.2023Read More
Senior Technical Specialist
Concentrix
09.2019 - 03.2022Read More
Anand Engineering College
B.Tech from Computer Science & Engineering
Read More
USSN INT College
Class 12 (CBSE)
Read More
Little Flower School
Class 10 (CBSE)
Read More