Data Analytics & Visualization Specialist

MITALI PARDESHI

+91-951******* **************.**@*****.*** LinkedIn GitHub

EDUCATION

Modern Education Society Wadia College of Engineering Pune, Maharashtra BachelorofEngineeringinElectronics&Telecommunication – CGPA: 8.28/10 2021 – 2024 Bharat English School and Junior College Pune, Maharashtra HigherSecondaryCertificate(HSC) – 71% 2019 – 2020

TECHNICAL SKILLS

Core Analytical Skills: Data Cleaning & Wrangling, Data Transformation, ETL, Data Modeling, Data Warehousing, Data Pipelines, Exploratory Data Analysis (EDA), Statistical Analysis, Dashboard Designing Language: Python

Visualization & BI Tools: PowerBI, Advanced Excel, Google Sheets Data Warehousing Tools: Snowflakes

Database: MySQL, SQL Serve

Cloud: Azure

AI Tools & Platforms: ChatGPT, Jupyter Notebook, VS Code, GitHub Business Skills: Data Storytelling, Critical Thinking, Problem-Solving WORK EXPERIENCE

Data Analyst Intern Feb 2025 – Aug 2025

CubicITService(6 months) Pune, Maharashtra

• Performed data cleaning and transformation on large datasets using SQL and Python, ensuring 99%+ data accuracy for critical business reporting

• Designed and deployed interactive Power BI dashboards to visualize key business KPIs, enabling leadership to track performance trends and identify growth opportunities

• Collaborated with senior analysts to automate recurring reports using Python scripts, reducing manual effort by 40% and improving report delivery time

• Utilized SQL queries with complex joins and CTE to extract, transform, and load data from multiple sources for comprehensive analysis

PROJECTS

Customer Shopping Behaviour Analysis SQL, Gen AI

• Wrote optimized SQL queries to evaluate total revenue by gender, age, category, discount impact on spending, and shipping-type performance

• Identified top-performing products using aggregation queries and ranking functions (DENSE_RANK).

• Segmented users into New, Returning, and Loyal customers using CASE expressions for behavioral insights. Movies Dataset Correlation Analysis Python, EDA, Visualization, Gen AI

• Cleaned and pre-processed a raw movie dataset by handling missing values, formatting inconsistent fields, and converting data types for analysis.

• Conducted exploratory data analysis to understand distribution patterns and detect anomalies in ratings, budget, gross revenue, and company data.

• Visualized trends using scatter plots to show how budget correlates with gross revenue. Underwater Data Transmission using Li-Fi Technology

• Developed a Li-Fi based underwater communication system to transmit text data using visible light.

• Designed transmitter using laser module and Arduino with On-Off Keying (OOK) modulation for digital data encoding.

• Built receiver setup using photo-diode to convert light signals back into electrical signals.

• Programmed data processing and transmission logic in Embedded C using Arduino IDE. CERTIFICATIONS

• UV Technocrats - Data Analysis (Python, SQL, Advance Excel, PowerBI, Gen AI)

• IIT Kharagpur - Data Analysis using Python

• Deloitte Australia - Data Analytics Job Simulation (Forage)

• NPTEL - Enhancing Soft Skills & Personality

• IETE - National Level Project Competition

Contact this candidate