Summary
Overview
Work history
Education
Skills
Websites
Certification
COVID-19 Global Impact Dashboard, Personal Project, 2023
Maven Market Data Analysis on Power BI (Datacamp, 2023)
Timeline
Generic

Deepshikha Mittal

London

Summary

Master of Computer Science graduate with a robust background in data analysis and visualization, seeking a data analyst role. Proven expertise in collecting, processing, and interpreting large datasets using Python, SQL, and Power BI. Skilled in developing actionable insights, building dashboards, and presenting results to stakeholders. Eager to apply technical and analytical skills in solving real-world business challenges.

Overview

3
3
years of professional experience
1
1
Certification

Work history

Data Analyst

Interface Microsystems
03.2020 - 03.2022
  • Analyzed performance data for Body Control Modules (BCMs), reducing system failures by 25% for automotive clients like Maruti Suzuki and Mahindra over two years.
  • Built and optimized interactive dashboards using Power BI, facilitating real-time monitoring and increasing testing efficiency by 15%
  • Preprocessed and analyzed 3M+ data points using Python, accelerating decision-making processes by 30%
  • Automated reporting processes, saving 50+ hours per month for the team by reducing manual efforts

Data Analyst Intern

Rockgold Academy
01.2019 - 12.2019
  • Developed dashboards in Tableau and Power BI to track key performance metrics across educational programs
  • Conducted detailed analyses to identify trends in student performance, increasing efficiency in academic planning by 27%
  • Integrated data analytics into administrative processes, improving decision-making through visualized insights.
  • Designed workflows for maintaining and updating data systems, ensuring consistency across 500+ records

Education

Master + Bachelors of Technology - Computer Science

Jayoti Vidyapeeth Women’s University
05.2013 - 5 2017

Skills

  • Python
  • SQL
  • Power BI
  • Tableau
  • Pandas
  • NumPy
  • Matplotlib
  • Data Collection
  • Data Analysis
  • Data Visualization
  • Stakeholder Collaboration
  • Communication
  • Statistical Analysis

Certification

  • Foundations: Data, Data, Everywhere, Google, 2023
  • Ask Questions to Make Data-Driven Decisions, Google, 2023
  • Microsoft Power BI Desktop for Business Intelligence, Udemy, 2023
  • The Data Analyst Course: Complete Data Analyst Bootcamp, Udemy, 2023
  • MySQL for Data Analytics and Business Intelligence, Udemy, 2023
  • Database Administration Fundamentals, Microsoft Technology Associate, 2014

COVID-19 Global Impact Dashboard, Personal Project, 2023

  • Collected and preprocessed global COVID-19 data from sources like WHO and John Hopkins University using Python.
  • Analyzed trends in daily cases, recoveries, and fatalities, using Pandas and Matplotlib to generate descriptive statistics and trend visualizations.
  • Designed an interactive Power BI dashboard, integrating slicers for filtering by region, date, and case type (active, recovery, fatality rates).
  • Highlighted key hotspots, vaccination progress, and recovery trends, aiding policymakers in resource allocation.

Maven Market Data Analysis on Power BI (Datacamp, 2023)

  • Cleaned, connected, and transformed data from a multinational grocery chain using Power BI.
  • Built relational data models, ensuring proper table relationships for accurate analysis.
  • Created interactive dashboards with calculated fields to visualize revenue, profit, and return rates, providing actionable insights for decision-making.
  • Used advanced Power BI features such as bookmarks and custom visuals to enhance user exploration and report accessibility.

Timeline

Data Analyst

Interface Microsystems
03.2020 - 03.2022

Data Analyst Intern

Rockgold Academy
01.2019 - 12.2019

Master + Bachelors of Technology - Computer Science

Jayoti Vidyapeeth Women’s University
05.2013 - 5 2017
Deepshikha Mittal