Looking for a job

Sumit Kandpal

@sumitkandpal1

Message

Data Analyst building self-service BI and AI analytics bots that cut SQL bottlenecks.

Zimbabwe

Message

What I'm looking for

I’m looking for analytics work where I can build KPI frameworks, reliable pipelines, and self-service dashboards—and use AI to automate insights without forcing users back to ad-hoc SQL.

I’ve spent the last 2+ years turning complex business questions into web and product analytics—ETL pipelines, data validation, visualization, and exec reporting that cross-functional teams can actually use.

At TwarIT Mobility Solutions, I led client analytics for JBM EcoFuel, Capgemini, Olectra GreenTech, and NueGo using AWS Athena, Glue, and S3 with Power BI and Excel. I also analyzed user behavior and engagement with SQL to spot trends, drop-off points, and conversion opportunities.

I designed and shipped an AI-powered analytics chatbot for self-service insights and automated KPI visualizations, reducing ad-hoc SQL turnaround time by 60%. Alongside that, I built an end-to-end solar predictive maintenance platform in Python with ML models and a FastAPI service, including a device-health index and maintenance recommendations.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

TwarIT Mobility Solutions Pvt.Ltd

Sep 2024 - Present (1 year 11 months)

Led analytics projects for clients using AWS Athena, Glue, S3, Power BI, and Excel. Designed automated pipelines improving data accuracy to 98% and developed an AI-powered analytics chatbot reducing SQL turnaround time by 60%.

AWS Glue S3 Power BI Excel SQL Python Chatbot User Behavior Analysis Web Analytics Product Analytics

Data Analyst Intern

ITC INFOTECH

Jul 2023 - Jan 2024 (6 months)

Gathered business requirements and supported data analysis. Developed a data management system using Excel and SQL, improving operational efficiency by 30%.

Excel SQL Data Extraction Data Cleaning Reporting Business Requirements