Back to Developers
Mohan Kumar

Mohan Kumar

Data Analyst

Bengaluru, Karnataka 3+ yrs exp 88 ยท Excellent

About

Data Analyst with around 2 years of experience delivering data-driven insights through SQL, Python, Power BI, and Excel. Experienced in business intelligence, dashboard development, KPI reporting, A/B testing, inventory analytics, sales analytics, and campaign performance analysis. Strong analytical and problem-solving skills with hands-on experience building end-to-end analytics solutions to support strategic business decisions.

Skills & Expertise (32)

Power BI Advanced
8.0/10
2
Years Exp
Pivot Tables Advanced
8.0/10
2
Years Exp
MS Excel Advanced
8.0/10
2
Years Exp
SQL Intermediate
7.5/10
2
Years Exp
Python Intermediate
7.5/10
2
Years Exp
Reporting Intermediate
7.5/10
2
Years Exp
Reporting Intermediate
7.5/10
2
Years Exp
Critical thinking Intermediate
7.0/10
2
Years Exp
Problem Solving Intermediate
7.0/10
2
Years Exp
stakeholder communication Intermediate
7.0/10
2
Years Exp
A/B testing Intermediate
7.0/10
2
Years Exp
KPI Tracking Intermediate
7.0/10
2
Years Exp
Business Analysis Intermediate
7.0/10
2
Years Exp
VLOOKUP Intermediate
7.0/10
2
Years Exp
Data Cleaning Intermediate
7.0/10
2
Years Exp
Data Modeling Intermediate
7.0/10
2
Years Exp
Microsoft SQL Server Intermediate
7.0/10
2
Years Exp
DAX Intermediate
7.0/10
2
Years Exp
Pandas Intermediate
7.0/10
2
Years Exp
Power Query Intermediate
7.0/10
2
Years Exp
MySql Intermediate
6.5/10
2
Years Exp
Process Improvement Intermediate
6.5/10
2
Years Exp
Statistical Analysis Intermediate
6.5/10
2
Years Exp
NumPy Intermediate
6.5/10
2
Years Exp
EDA Intermediate
6.5/10
2
Years Exp
Index Match Intermediate
6.5/10
2
Years Exp
Star Schema Intermediate
6.5/10
2
Years Exp
Matplotlib Intermediate
6.0/10
2
Years Exp
ETL Intermediate
6.0/10
2
Years Exp
Data Storytelling Intermediate
6.0/10
2
Years Exp
Time intelligence Intermediate
6.0/10
2
Years Exp
Dashboards

Work Experience

Retail Data Analytics Project

TI Cycles

Jan 2026 - Present

End-to-end retail analytics project developed using SQL, Python, Power BI, and Excel to analyze inventory, sales, and marketing performance for a bicycle manufacturer operating 150+ stores and online channels. Wrote advanced SQL queries for inventory tracking, sales analysis, MoM and YoY growth, and target vs. actual performance reporting. Built a Python-based Inventory Health Scoring Model using ABC-XYZ segmentation to identify dead stock and stock-out risks across 500+ SKUs. Analyzed 15+ marketing campaigns using ROMS, CPA, and CTR metrics to evaluate channel performance and support budget allocation. Conducted campaign uplift analysis using A/B testing and t-test methodology to measure marketing effectiveness. Developed interactive Power BI dashboards using DAX, KPI tracking, Star Schema modeling, and Time Intelligence functions. Delivered data-driven insights and recommendations to support inventory optimization, sales performance, and marketing decisions.

Career Development

Self-directed Learning & Government Exam Preparation

Jan 2024 - Dec 2025

Dedicated this period to preparing for competitive government examinations while continuously strengthening data analytics skills through self-learning and hands-on projects. Completed an end-to-end retail analytics project using SQL, Python, Power BI, and Excel, covering inventory, sales, and marketing campaign analysis.

Business Analyst

Affine Analytics

Jun 2022 - Dec 2023

Analyzed Bing Ads campaigns using KPIs (CTR, CVR, CPA) to measure performance and optimize outcomes. Built reports and dashboards in Excel and Power BI to track revenue, impressions, and clicks. Delivered ad-hoc analysis for daily business requirements, supporting campaign optimization. Collaborated with stakeholders to translate campaign objectives into data requirements. Extracted and prepared campaign data, wrote SQL scripts, and built Power BI dashboards for leadership review. Conducted A/B testing and statistical analysis on KPIs including Monthly Active Users, Conversions, Retention, and Revenue. Delivered insights on campaign effectiveness and recommended strategies to improve KPIs. Automated reporting for 10+ Azure skilling campaigns, reducing manual effort by 60% and improving report delivery time.

Education

Bachelor of Technology in Metallurgical and Materials Engineering - National Institute of Technology (NIT), Jamshedpur

2018 - 2022 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 13/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 88/100

Profile Overview

Member sinceJul 2026