Summary
Overview
Work History
Skills
Education
Websites
Projects
Certification
Timeline
Generic

Shiva Mandal

Summary

Highly motivated and detailed-oriented candidate passionate about using data to improve business performance and customer experience. Skilled at leveraging data to develop actionable solutions to business challenges and utilizing data mining and data visualization to create meaningful insights. Excellent technical aptitude and knowledge of programming languages, data analytics and data visualization.

Overview

2
2
years of professional experience
1
1
Certification
1
1
year of post-secondary education

Work History

Customer support and Quality Analyst

Videocon D2H
01.2022 - 12.2023
  • Helped large volume of customers every day with apositive attitude and focus on customer satisfaction.
  • Enhanced customer satisfaction by addressing and resolving complaints in a timely manner, demonstrating commitment to exceptional service.
  • Analyzed quality and performance data to support operational decision-making.

Internship

Hoswin Incinerator Pvt Ltd
07.2021 - 11.2021
  • Supported the biomedical waste management team in safely and efficiently disposing of medical waste, ensuring compliance with regulatory standards.
  • Gained valuable experience working within a specific industry, applying learned concepts directly into relevant work situations.
  • Sorted and organized files, spreadsheets, and reports.
  • Proven ability to learn quickly and adapt to new situations.

Skills

  • Microsoft Excel
  • Python programming
  • Microsoft Power Bi
  • My-SQL
  • Data Cleaning
  • Team Collaboration
  • Quality improvement

Education

Data Analytics - IT

IOTA Academy
Indore
06.2024 - Current

Bachelor of Engineering - Mechanical Engineering

Technocrats Institute of Science and Technology, Bhopal

Diploma in Mechanical engineering -

RKDF IST, Bhopal

Projects

Supermarket sales, Utilized advanced statistical methods and data visualization techniques to uncover patterns in customer purchasing behavior, product performance, and seasonal fluctuations. Generated actionable recommendations to optimize inventory management, pricing strategies, and promotional campaigns, resulting in a X% increase in sales revenue.

  • Tools and Steps: Data cleaning and preprocessing, (EDA), Data visualization (Python, matplotlib, Power BI), Excel for data manipulation and reporting.
  • Key Achievements: Identified correlations between product categories and customer demographics, informing targeted marketing strategies.

Latest Covid-19 State-wise Data of India, Analyzed real-time COVID-19 data for Indian states to provide insights into the pandemic's spread and impact. Utilized Python and data visualization tools to track key metrics such as infection rates, testing trends, and vaccination progress by dashboard understand the current pandemic situation in different states. 

  • Tools and Steps: Dashboard creation (Power BI ( Map, Bar, LIne, Table)),Data extraction and cleaning, (EDA), Time-series analysis.
  • Key Achievements: Developed interactive dashboards to visualize COVID-19 trends, facilitating timely decision-making for public health interventions, * Identified hotspots and emerging clusters to guide resource allocation and containment efforts.

Accenture Data Analyst : ( Job Simulation by Forage ), Deep dive into the evolving world of data from an analytics and visualization perspective with Navigating Numbers. Learn data basics such as data cleaning, modeling, visualization, and storytelling. Upon completion, you'll be equipped with data fundamentals and an understanding of what a career in data analytics could look like. 

Walmart Sales, The project involves an in-depth analysis of Walmart sales data across 45 stores, considering various factors such as holidays, promotions, and economic conditions. The goal is to provide insights into sales patterns, identify the impact of events on demand, and propose strategies to improve stock management with the help of 

  • Tools and Steps: Data cleaning and preprocessing, (EDA), Data visualization (Python, matplotlib, Power BI), Excel for data manipulation and reporting.

Certification

  • Data Analyst Training

Timeline

Data Analytics - IT

IOTA Academy
06.2024 - Current

Customer support and Quality Analyst

Videocon D2H
01.2022 - 12.2023

Internship

Hoswin Incinerator Pvt Ltd
07.2021 - 11.2021

Bachelor of Engineering - Mechanical Engineering

Technocrats Institute of Science and Technology, Bhopal

Diploma in Mechanical engineering -

RKDF IST, Bhopal
Shiva Mandal