Karan Gangwar

Associate Consultant

1+ yrs exp 73 · Very Good

About

No bio added yet

Skills & Expertise (35)

Python Intermediate

7.5/10

Years Exp

SQL Intermediate

7.0/10

Years Exp

MS Excel Intermediate

7.0/10

Years Exp

Pandas Intermediate

7.0/10

Years Exp

Web Scraping Intermediate

7.0/10

Years Exp

Power BI Beginner

6.5/10

Years Exp

Machine Learning Beginner

6.5/10

Years Exp

Scikit Learn Beginner

6.0/10

Years Exp

GitHub Beginner

6.0/10

Years Exp

TensorFlow Beginner

5.5/10

Years Exp

Stakeholder Management Probability and Statistics client collaboration Market Research IOT Vibration Analysis BeautifulSoup Genetic Algorithms Blockchain Exploratory data analysis Clustering Algorithms Predictive models KPI Tracking Excel Supply Chain Management Problem Solving Strategic Planning Financial Analysis EDA Tableau Selenium NumPy DL ML C++

Work Experience

Associate

Nation with Namo - Kalliope Consulting

Jul 2025 - Aug 2026

Advanced Data Analytics & Data Visualisation: Analyzed electoral and demographic datasets covering 1lakh+ electors across 6 assembly constituencies using SQL, Python, and Excel; identified behavioral patterns that drove segmentation, targeting, and data-driven campaign strategy. Designed a prioritization model for 1.5K+ booths, driving 15% lift conversion via experimentation & insight-led targeting. Automated data collection and reporting workflows by developing Python-based web scrapers across multiple government sources, reducing manual effort by 70%, enabling real-time dashboards for multi-team decision-making. Deployed KPI tracking frameworks measuring MP/MLA performance across 8 parameters over 12 months, improving targeted public outreach effectiveness by 20% and streamlining various ministry-level recommendation reporting. Stakeholder Management & Client Collaboration: Conducted 50+ consulting sessions and facilitated 60+ stakeholder interactions, translating analytical insights and user behaviour patterns into actionable growth and execution strategies, increasing the client’s victory margins by 18%. Collaborated with cross-functional teams across research, operations, and field execution to streamline workflows, improve reporting efficiency, and support rapid data-backed decision-making. Market Research & Strategic Analysis: Executed primary and secondary research, demographic profiling, and competitor analysis across 6 constituencies and 1,500+ booths to identify priority voter segments, shape outreach plans, and guide resource allocation effectively. Contributed to victories across 6 Bihar Assembly constituencies through data-backed planning, micro-targeting at the booth level, constituency-level performance reviews, and end-to-end campaign optimization.

Management Trainee Intern

TATA Steel

May 2024 - Jul 2024

Developed a sensor-driven predictive maintenance system for screens, successfully reducing unscheduled shutdown costs by ₹4 crore. Leveraged vibration analysis integrated with IoT sensors and various ML models to enable proactive early machine failure detection. Upgraded equipment reliability and minimized downtime by 10hr via real time quantitative data driven predictive monitoring.

Data Analyst Intern

Psyliq

Dec 2023 - Jan 2024

Queried and transformed diabetes datasets using SQL, analysed 5 key features to support advanced exploratory and statistical analysis. Analysed employee engagement data using Excel and Power BI, delivering actionable insights that improved workforce retention. Utilized various Python modules, including PyPDF3, BeautifulSoup, and Pandas, to automate data extraction from various files.