Skip to content
View prathmesh0work's full-sized avatar
  • Lemma Technologies
  • Pune

Block or report prathmesh0work

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
prathmesh0work/README.md

Hey, I'm Prathmesh Ingole 👋

Data Analyst in Training · M.Sc. Data Science Student · Insight Hunter

Turning raw data into decisions — one query at a time.

LinkedIn


💫 About Me

I'm a B.Sc. Computer Science graduate from Savitribai Phule Pune University, currently pursuing my M.Sc. in Data Science, with a passion for making data tell meaningful stories. My work sits at the intersection of data analytics, machine learning, deep learning, and web development — I enjoy understanding systems end to end, from the database layer all the way to the dashboard.

  • 🎓 Pursuing M.Sc. Data Science (Active)
  • 💼 Currently a Technical Intern at Lemma Technologies (May 2026 – Present)
  • 📊 Experienced with Tableau, Power BI, Excel, SQL, and Python-based analytics
  • 🤖 Exploring AI, Machine Learning & Deep Learning — from classical models to neural networks
  • 🌐 Built full-stack projects using Flask, JavaScript, MySQL/SQLite, HTML/CSS, Bootstrap
  • 🏆 Completed virtual internships with Deloitte and Tata (TCS) via Forage
  • 📍 Based in Pune, India
  • 🤝 Open to Data Analyst / Data Science opportunities

🛠️ Tech Stack

Languages

Python SQL JavaScript

Data & Analytics

Pandas NumPy Matplotlib Seaborn

Machine Learning & AI

Scikit-Learn TensorFlow PyTorch

BI & Visualization

Tableau Power BI Excel Google Data Studio

Web, Backend & Database

HTML5 CSS3 Bootstrap Flask MySQL SQLite MongoDB Gunicorn


🚀 Featured Projects

Flask · Python · JavaScript · Chart.js · MySQL

Full-stack analytics dashboard for Digital Out-of-Home (DOOH) advertising campaigns. Features fuzzy column detection, a six-step data cleaning pipeline, KPI aggregation (ROI, CTR, CPC, CPM), screen occupancy tracking, delivery discrepancy detection, and per-screen anomaly detection — built during internship at Lemma Technologies.


Python · Random Forest · Linear Regression · Power BI · EDA

End-to-end ML project for predicting advertising campaign performance and ROI. Includes full EDA, data preprocessing, regression modelling, Random Forest-based classification, feature importance analysis, and an executive Power BI dashboard — built during internship at Lemma Technologies.


Python · Scikit-learn · SMOTE · Random Forest · Logistic Regression

Built a binary classifier on 284,807 transactions (0.17% fraud rate). Applied SMOTE to handle severe class imbalance. Random Forest outperformed Logistic Regression by capturing non-linear patterns, achieving strong ROC-AUC performance.


🗃️ SQL Quest

MySQL · Basics & Aggregations · Joins · Subqueries · CTEs · Window Functions

An ongoing daily MySQL practice repo built on a 6-table e-commerce schema (Customers, Products, Orders, Payments, etc.). Covers SQL fundamentals (SELECT/WHERE/GROUP BY/HAVING), joins (INNER/LEFT, multi-table), subqueries (correlated, EXISTS/NOT EXISTS), CTEs, and window functions from basic ranking (RANK(), ROW_NUMBER(), LAG()) through advanced analytics (NTILE(), CUME_DIST(), PERCENT_RANK()) — with new sessions added regularly and each query documented by topic.


MongoDB · CRUD · Aggregation Pipelines · $lookup

Ongoing slip-style MongoDB practice repo covering CRUD operations, sort/limit, projections, $or/$in/$regex queries, and aggregation pipelines with $lookup across multiple sample databases (movieDB, companyDB, deptDB, sales, libraryDB, hospitalDB).


MyTodo

Flask · SQLAlchemy · SQLite · Bootstrap 5

A lightweight CRUD task manager with a Flask backend, SQLite database, and responsive Bootstrap UI — deployable via Gunicorn.


💼 Experience

Role Organization Period
Technical Intern 🟢 Lemma Technologies May 2026 – Present
Data Analytics Virtual Intern Deloitte Australia (Forage) Jul 2025
Data Visualization Job Simulation Tata Consultancy Services (Forage) Aug 2025

Highlights:

  • Analyzed forensic datasets with 10,000+ records; built a 5-KPI Tableau dashboard (Deloitte)
  • Translated executive business requirements into clear, decision-ready visuals (TCS)

📜 Certifications

  • 🏅 Data Analyst Course — AISECT Skill India, NSDC (18 Feb 2025) · Grade B · Certificate ID: CERT_2495429
  • 🏅 Python Programming — ETLHIVE (Oct 2024) · ID: 968849PR
  • 🏅 SQL — ETLHIVE (Oct 2024) · ID: 968849PR
  • 🏅 SQL (Basic) — HackerRank (Verify)
  • 🏅 SQL (Intermediate) – HackerRank (Verify)
  • 🏅 AI Tools Workshop — be10x (June 2026) · AI-assisted presentations, data analysis, code & debugging (Verify)
  • 🏅 Viksit Bharat Young Leaders Dialogue (VBYLD) 2026 — Ministry of Youth Affairs & Sports, MYBharat (Oct 2025) · Online Quiz Participation
  • 🏅 Digital Edge 101 — FutureSkills Prime, NASSCOM (Mar 2026) · Course Participation
  • 🏅 Gen AI 101 — FutureSkills Prime, NASSCOM (Mar 2026) · Course Participation
  • 🏅 Data Analytics Job Simulation — Deloitte, via Forage (Jul 2025) · Data analysis, forensic technology · User Verification Code: 5MXHZHD24y853rcgg
  • 🏅 Data Visualisation: Empowering Business with Effective Insights — Tata (TCS), via Forage (Aug 2025) · Framing business scenarios, choosing/creating effective visuals, communicating insights · User Verification Code: 5MXHZHD24y853rcgg

📊 GitHub Stats

Prathmesh's GitHub Stats

GitHub Streak

Top Languages


"Data is not just numbers — it's a story waiting to be told."

Feel free to explore my repos and drop a star if something interests you!

Pinned Loading

  1. DOOH-Campaign-Intelligence DOOH-Campaign-Intelligence Public

    📊 Drop in any campaign CSV, get a full analytics dashboard back — auto-cleaned, auto-charted, zero manual setup.

    JavaScript 1

  2. Campaign-Performance-Prediction Campaign-Performance-Prediction Public

    End-to-end Machine Learning project for predicting advertising campaign performance using Random Forest. Includes data preprocessing, exploratory data analysis (EDA), model training, performance ev…

    Jupyter Notebook 1

  3. Flask-My-Todo Flask-My-Todo Public

    A lightweight full-stack To-Do app built with Flask, SQLAlchemy, and Bootstrap — create, update, and delete tasks with a clean, responsive UI.

    HTML

  4. SQL-practice SQL-practice Public

    MySQL practice repo — SQL exercises covering subqueries, joins, window functions, and more, with a schema-driven e-commerce dataset. 🗃️📈

  5. Credit-Card-Fraud-Detection- Credit-Card-Fraud-Detection- Public

    Built an end-to-end fraud detection system using Python, SQL. Applied SMOTE to handle imbalanced data and trained machine learning models to detect fraudulent transactions. Visualized insights thro…

    Jupyter Notebook

  6. DOOH-Dashboard DOOH-Dashboard Public

    📊 DOOH Advertising Performance Dashboard — Interactive Looker Studio report tracking Revenue, ROI, Impressions & Campaigns across 10 Indian cities.