Overview
Work History
Education
Skills
Certification
Extracurricular Activities
Projects
Position Of Responsibility - Description
Electives And Proficiency
Timeline
Hi, I’m

DIPANJAN MITRA

KOLKATA
DIPANJAN MITRA

Overview

5
years of professional experience
1
Certification

Work History

SastaSundar

Management Trainee
05.2024 - 06.2024

Job overview

  • Facilitated retailer onboarding for the RetailerShakti platform to expand its user base and ensure first-time order success.
  • Pitched the platform to 20+ pharmacy shops daily, registering nine retailers and resolving inquiries about app usage, product availability, and discounts.
  • Addressed delivery delays, product returns, and refund issues.
  • Secured six successful first-time orders and enhanced retailer satisfaction through issue resolution.

SG ACADEMICS

Office Assistant
11.2019 - 08.2022

Job overview

  • Supported student admissions and academic progress to improve enrollment and retention.
  • Counseled students on admission processes and courses, followed up on inquiries, and managed student records.
  • Organized mock tests, extra classes for weaker students, and guardian meetings both online and offline.
  • Successfully converted 20 students over two years and enhanced student engagement and performance.

Education

Praxis Business School

PGDM
04-2025

University Overview

GPA: 6.04 CGPA

HERAMBA CHANDRA COLLEGE

B.Com (Hons.) from Finance and Accountancy
06-2019

University Overview

GPA: 6.04 CGPA

NATIONAL GEMS HIGHER SECONDARY SCHOOL

CLASS XII
05-2016

University Overview

GPA: 6.04 CGPA

NATIONAL GEMS HIGHER SECONDARY SCHOOL

CLASS X
05-2014

University Overview

GPA: 6.04 CGPA

Skills

  • Data Visualization and Storytelling
  • Quantitative Techniques
  • Foundations of Machine Learning
  • Market Research
  • Advanced Market Research and Analytics
  • Econometrics
  • Marketing Management
  • Consumer Behaviour
  • Canva
  • Power BI
  • Python
  • Microsoft PowerPoint
  • Tableau
  • Advanced Excel

Certification

  • Data Science, Completed an 8-week online training on Data Science. The training consisted of Introduction to Data Science, Python for Data Science, Understanding the Statistics for Data Science, Predictive Modeling and Basics of Machine Learning, and The Final Project modules.
  • Business Analytics, Completed successfully an 8 week online training on Business Analytics. The training consisted of Excel for Data Analytics, Statistical foundations for Business Analysts, Statistical Decision Making, Optimizing Business Models, and Predictive Analytics.
  • Advanced Excel, Completed a four week online training on Advanced Excel. The training consisted of Getting Started with Excel, Excel Basics, Formulas and Functions, Working with Data, and Advanced Concepts modules.

Extracurricular Activities

Secured the first prize in the Street Play competition at Praxis Business School.

Projects

Five Year Strategic Roadmap for Consumer Goods - Introduction to Generative AI, Disruptions like tariffs, geopolitics, and tech shifts impact consumer goods supply chains; need for predictive, resilient operations. To ensure supply chain continuity, optimize efficiency, automate customer service, and enhance forecasting amid market volatility, tested various LLM models. Compared ChatGPT, Claude, DeepSeek, Gemini, and Perplexity on supply chain tasks; Claude emerged best for real-time, AI-driven resilience. Recommended Claude for GenAI-led risk prediction, autonomous orchestration, and adaptive forecasting to future-proof operations. Health Insurance Cross Sell Prediction - Econometrics, Developed an XGBoost model (81.42% accuracy, 93.94% recall) to predict vehicle insurance buyers, improving conversion rates. Analyzed 380,000+ records using Chi-Square tests to uncover key purchase drivers like vehicle age, damage, and premium. Implemented XGBoost, Random Forest, and Logistic Regression, with XGBoost outperforming in predictive accuracy. Applied model insights to refine targeting, optimize ad spend, and maximize customer acquisition. Psychographics and Behavioural Analysis - Advanced Market Research Analysis, Conducted a quantitative survey targeting college students, particularly those enrolled in professional courses. Segmented respondents based on psychographics and created distinct clusters. Analyzed and linked their product or brand usage patterns to the characteristics of each segment. Identified other products or brands that could effectively target these segments in the future. Lakme Sunscreen - Market Research, Assessed consumer preferences and brand performance of Lakme in the skincare market. Conducted a rigorous cross-sectional study employing a snowball sampling technique across Kolkata, its surrounding districts, and various states. Discovered that Lakme excels in SPF ratings and brand awareness, Lotus stands out for its water resistance, and Mamaearth garners loyalty with its emphasis on natural ingredients. Inferential Statistical Analysis - Quantitative Techniques 2, Evaluated factors influencing user engagement on Facebook posts using secondary data. Found that paid posts drive more interactions; fashion posts gain the most engagement; increased likes boost lifetime user engagement. Conducted inferential statistical analysis, applying regression, ANOVA, t-tests, and chi-square tests to assess the impact of likes, comments, post types, and paid promotions.

Position Of Responsibility - Description

Led the student election process for 300+ students, achieving a high voter turnout of 88%. Coordinated Q&A sessions between senior and junior students to assess candidate suitability. Managed a team to oversee smooth voting operations and accurate vote counting within tight timelines. Demonstrated leadership, organization, and event management skills through seamless execution of the election process.

Electives And Proficiency

Data Visualization and Storytelling, Quantitative Techniques, Foundations of Machine Learning, Market Research, Advanced Market Research and Analytics, Econometrics, Marketing Management, Consumer Behaviour, Canva, Power BI, Python, Microsoft PowerPoint, Tableau, Advanced Excel

Timeline

Management Trainee

SastaSundar
05.2024 - 06.2024

Office Assistant

SG ACADEMICS
11.2019 - 08.2022

Praxis Business School

PGDM

HERAMBA CHANDRA COLLEGE

B.Com (Hons.) from Finance and Accountancy

NATIONAL GEMS HIGHER SECONDARY SCHOOL

CLASS XII

NATIONAL GEMS HIGHER SECONDARY SCHOOL

CLASS X
DIPANJAN MITRA