Rohit Dubey

About Rohit Dubey

About Me I am a•Business & Data Analytics• enthusiast with a strong foundation…

Experience

1. Technical Lead

   Sb Infotech

   Dec 2018 — Present · Indore, IN

   Project Name: Market Basket Analysis for Consumer InsightsTeam Size: 2Technologies Used: Python (Pandas, NumPy, mlxtend), R (arules), Tableau, Jupyter Notebook, ExcelDescription:Designed and deployed a Market Basket Analysis (MBA) pipeline to uncover product association patterns within retail transaction datasets. The project aimed to improve cross-selling strategies and customer experience by analyzing frequent itemsets and generating actionable business insights.Responsibilities & Contributions:• Pre-processed and cleaned large-scale transactional data using Python (Pandas, NumPy) and R, ensuring integrity and readiness for association rule mining.• Applied Apriori algorithm via Python’s mlxtend and R’s arules to extract frequent itemsets and association rules with high support, confidence, and lift values.• Filtered results to identify top combinations for product bundling, targeting key categories like home essentials, grocery, and stationery.• Built interactive dashboards in Tableau to visualize rule metrics, consumer purchasing behavior, and product affinities by geography and seasonality.• Exported insights to business stakeholders using Excel and Tableau storyboards, highlighting KPIs like:o ↑15% increase in bundle sales potentialo ↓10% reduction in inventory mismatcho ↑20% higher response rate on bundled promotional offers• Documented the workflow and findings in Jupyter Notebooks and R Markdown for reproducibility and presentation.Key Impact:• Enhanced customer segmentation and marketing strategies by integrating MBA insights into campaign planning.• Supported data-driven decision-making for product placement and supply chain optimization across retail partners.

Education

• Prestige Institute of Management & Research, Ring Road, Indore

  PG Program

  2017 — 2018

• Rajiv Gandhi Prodyogiki Vishwavidyalaya

  Engineer's Degree

  2008 — 2012

• Devi Ahilya Vishwavidyalaya

  Master of Business Administration (M.B.A.)

  2013 — 2015

Skills

• Python
• Javaserver Pages (Jsp)
• Oracle
• Marketing Management
• Hive
• Project Bidding
• Data Warehousing
• Informatica
• HR Management
• Etl
• Xml
• Jsp
• Apache Pig
• Javascript
• Java
• Hadoop
• Css
• Big Data
• Big Data Analytics
• Team Management
• Html
• C
• Etl Testing
• Mysql
• Php
• Cascading Style Sheets (Css)
• Public Speaking
• Sql