Google Sheets, MySQL Workbench , Jupyter Notebook, Power BI, Visual, Spyder, Studio Code
Shivani Yadav
Data Analyst
Coventry
Summary
Results-driven Data Analyst with expertise in Power BI, Python, R, SQL, and VBA. Experienced in data collection, analysis, and visualization. Skilled in statistical modeling, predictive analytics, and process automation to drive business insights and optimize operations. Passionate about leveraging data-driven strategies to enhance efficiency and support decision-making. Highly motivated and detail-oriented candidate dedicated to using data to improve business performance and customer experience. Proven ability to develop actionable solutions to business challenges through data mining and data visualization. Possesses excellent technical aptitude and extensive knowledge of programming languages, data analytics, and data visualization.
Overview
8
8
years of professional experience
1
1
year of post-secondary education
9
9
Certificates
2
2
Languages
Work History
Data Analyst Intern
Analytics Leap
01.2023 - Current
- Transformed raw data into interactive Power BI dashboards, enhancing user experience and improving data reporting efficiency by 20%
- Analyzed customer data using SQL, identifying key trends that contributed to a 5% improvement in client retention
- Effectively communicated findings to stakeholders, increasing the adoption rate of suggested improvements by 30%
- Identified and corrected data inconsistencies using Power Query Editor, improving data quality and governance while reducing errors by 40%
- Collaborated with project managers and IT stakeholders to fulfill business requirements, achieving a 95% customer satisfaction rate and enhancing CRM performance
Data Analyst (IT Division)
RITES Ltd
01.2017 - 07.2023
- Analyzed and managed IT system data across 27+ projects, improving operational efficiency through data-driven insights
- Processed 1M+ data points using Python, R and SQL, identifying trends that optimized system performance and reduced downtime by 20%
- Designed automated Power BI dashboards, reducing manual reporting time by 30% and improving real-time decision-making
- Conducted predictive modeling and statistical analysis, enhancing IT infrastructure efficiency by 15% through data-driven optimizations
- Ensured 99.9% data accuracy by streamlining data collection and integration processes
Education
MSc - Data Science
09.2023 - 11.2024
Key Modules: Statistics, Machine Learning, Database Management, Data Visualization, Business Intelligence, Big Data, Python & R Programming
Skills
Microsoft Excel
Google Sheets
MySQL
Jupyter Notebooks
Python
R
VBA
Regression Analysis
Hypothesis Testing
Predictive Modelling
Power BI
SAS Visual Analytics
Problem-Solving
Analytical Thinking
Team Collaboration
Data cleaning
Python programming
Excel functions
Google analytics
Machine learning
ETL processes
Data storytelling
Data wrangling
Deep learning
Problem-solving abilities
Data modeling
Multitasking Abilities
Business analysis
Certification
SAS Programming for Beginners, Analytics Leap, 01/01/25
Software
Timeline
Coventry University - MSc, Data Science
09.2023 - 11.2024
Data Analyst Intern - Analytics Leap
01.2023 - Current
Data Analyst (IT Division) - RITES Ltd
01.2017 - 07.2023
Languages
Hindi
Native language
English
Advanced
C1