Data Analyst × Engineer

HELLO,I'M KARAN.

I turn messy data into clear insights and circuits into intelligent systems — combining analytics, business thinking and hands-on engineering.

Karan Mondal
Currently buildingData + engineering stories
that people can act on.
PYTHON✦SQL✦POWER BI✦TABLEAU✦EMBEDDED C✦ESP32✦PYTHON✦SQL✦POWER BI✦TABLEAU✦EMBEDDED C✦ESP32✦
01 / The person behind the projects

Data curious.
Engineering minded.

Data Analyst and final-year Electronics & Telecommunication Engineering student at Thadomal Shahani Engineering College, with hands-on experience across analytics internships and embedded systems builds.

01

From raw signals to useful decisions.

My work sits at the intersection of digital and physical systems. I enjoy cleaning data, finding the non-obvious pattern, building a dashboard that makes it understandable, and then asking the business question behind the number.

02

Built for the question, not just the tool.

Python, SQL, Excel, Power BI and Tableau are tools in the workflow — from data cleaning and EDA to dashboards and stakeholder-ready communication. Embedded C, ESP32 and Arduino extend that same mindset into hardware.

02 / The tools along the way

What I work with.

Programming

PythonPandas · NumPyC / Embedded CSQL

Analytics

MS ExcelPower BITableauStatistics · EDA

Data & Databases

MySQLMongoDBData cleaningVisualisation pipelines

Embedded & IoT

ESP32 · ESP32-S3ArduinoMQTT · BlynkRFID · Robotics

03 / Where I've learned by doing

Experience &
background.

2025 — 2026

Data Analytics Intern

Uptricks Services Pvt Ltd · Dec 2025 — Feb 2026
  • Engineered a composite engagement metric across 100+ posts, 3 platforms and 5 content types using Python, Pandas and Seaborn.
  • Surfaced platform, day and content patterns that informed a revised posting strategy and boosted audience reach by 20%.
2025 — 2026

Data Analytics Intern

Cognifyz Technologies · Dec 2025 — Jan 2026
  • Analysed a 40-respondent investment behaviour survey across 9 dimensions using Excel PivotTables.
  • Found consultants and newspapers influenced investors more than the internet — a useful marketing insight for financial brands.
2023 — 2027

B.E. Electronics & Telecommunication

Thadomal Shahani Engineering College, Mumbai · CGPA 7.225
04 / Things I've brought to life

Selected work.

Analytics and engineering projects, presented as problems, approaches and outcomes rather than a list of technologies.

01 · DATA

E-Commerce & Superstore Sales Analytics Platform

Automated ETL in Python/Pandas to clean, aggregate and transform 10,000+ transaction records, feeding Power BI dashboards for revenue, customer segments and delivery logistics.

PythonPandasSQLPower BI
View on GitHub →
02 · DATA

HR Analytics & Attrition Intelligence Dashboard

Workforce analytics dashboard evaluating headcount, attrition, salary distribution and tenure to support data-driven talent management decisions.

Power BIVisualisationStatistics
View on GitHub →
03 · DATA

FNP Orders & Sales Analytics Dashboard

Interactive dashboard tracking order and sales KPIs, trends and customer insights for easy, data-driven decision-making by non-technical stakeholders.

Power BITableauKPI Tracking
View on GitHub →
04 · DATA

Credit Card Spending Analytics in India

EDA across national credit-card usage datasets to surface patterns by city, payment type and gender, with visualisation pipelines for high-value customer segments.

PythonPandasSeabornSQL
05 · DATA

Marketing Analytics Dashboard

Collaborated with a global team to build a Facebook campaign optimisation dashboard, identifying underperforming strategies for data-backed cost reductions.

PythonSQLPower BI
06 · DATA

Social Media Engagement Analytics

End-to-end data cleaning and exploratory analysis pipeline that surfaced engagement trends and achieved a 20% improvement in audience engagement.

PythonPandasSeabornEDA
07 · AI / CONTROL

RL Traffic Control System

Applied reinforcement learning to optimise urban traffic flow by dynamically adjusting signal timings to minimise congestion and improve throughput.

PythonReinforcement LearningOptimisation
08 · IOT

ErrorBot — ESP32-S3 Wi-Fi Robot

Wi-Fi controlled robot with live IP camera streaming, Blynk IoT control, OLED smart UI and a hardware safety switch.

ESP32-S3BlynkC++
View on GitHub →
09 · ROBOTICS

Fasal Kavach — Autonomous Pesticide Rover

Autonomous pesticide-sprinkling rover built for Smart India Hackathon 2025, automating agricultural maintenance with hardware logic and robotics.

RoboticsHardware LogicSIH 2025
10 · IOT

Smart IoT Safety System

Multi-sensor safety system combining ultrasonic, IR, fire and water sensors with real-time Blynk monitoring and instant buzzer/notification alerts.

ESP32BlynkEmbedded C
11 · IOT

RFID Attendance & Access Control

ESP32-based RFID authentication using MFRC522 with MongoDB/MySQL integration and dual access through a web interface and IoT dashboard.

ESP32RFIDMongoDBMySQL
12 · IOT

Industrial Gas Leak Detection

Real-time MQ-2/MQ-135 monitoring with MQTT-based automated fan, buzzer and LED alerts plus a mobile interface for remote monitoring.

MQTTMQ-2 / MQ-135Real-Time
13 · ROBOTICS

RC Car — Hardware Optimised

Reworked a remote-controlled car to remove Blynk/Wi-Fi dependencies in favour of direct serial communication for better responsiveness and reliability.

Serial CommArduinoRobotics
05 / Milestones worth keeping

Certificates &
learning.

Click any certificate to view the original document image.

HP LIFE Data Science & Analytics certificate
Data Science & Analytics
HP LIFE / HP Foundation
Presented Nov 26, 2025
Microsoft and LinkedIn Career Essentials in Data Analysis certificate
Career Essentials in Data Analysis
Microsoft & LinkedIn
Jul 28, 2025
Introduction to Career Skills in Data Analytics certificate
Introduction to Career Skills in Data Analytics
LinkedIn Learning
Jul 11, 2025
Deloitte Data Analytics Job Simulation certificate
Data Analytics Job Simulation
Deloitte / Forage
Jul 4, 2025
Google Foundations Data Data Everywhere certificate
Foundations: Data, Data, Everywhere
Google / Coursera
Aug 6, 2025
Google Ask Questions to Make Data Driven Decisions certificate
Ask Questions to Make Data-Driven Decisions
Google / Coursera
Nov 27, 2025
HackerRank SQL Intermediate certificate
SQL (Intermediate)
HackerRank
Earned Jul 29, 2026
JPMorgan Chase Quantitative Research Job Simulation certificate
Quantitative Research Job Simulation
JPMorgan Chase & Co. / Forage
Jun 19, 2026
Tata Data Visualisation certificate
Data Visualisation: Empowering Business with Effective Insights
Tata / Forage
May 5, 2026
06 / Let’s connect

Let’s build
something great.

Have a question, opportunity, project idea, or just want to say hello? Send me a message through the form and I’ll get back to you.

Send me a message

I'll get back to you

Your details are used only to respond to your message.