Open to opportunities

Mohan Kumar

@mohankumar4

Message

Data Analyst specializing in campaign and retail analytics, turning data into actionable A/B-tested insights.

India

Message

What I'm looking for

I’m looking for a role where I can build KPI-driven dashboards and run A/B tests that improve marketing and retail performance, using SQL, Python, and Power BI to turn data into clear, decision-ready insights.

I’m a Data Analyst with 1.7+ years of industry experience in campaign and marketing analytics at Affine Analytics, where I translate business needs into measurable insights. I’m especially drawn to work that blends KPI tracking, statistical testing, and clear reporting for stakeholders.

At Affine Analytics, I analyzed Microsoft Bing Ads performance using CTR, CVR, CPA, impressions, clicks, and revenue, and built Excel and Power BI dashboards to support business reporting. I also wrote SQL for ad-hoc analysis and delivered optimization-ready insights, including A/B testing and statistical analysis across KPIs like Monthly Active Users, conversions, retention, and revenue.

I continue growing through end-to-end retail analytics projects, including customer segmentation, control-store trial evaluation, and inventory health scoring using Python, SQL, Power BI, and Excel. I enjoy automating reporting, validating results with statistical significance, and presenting findings in a decision-ready way using a “Pyramid Principle” approach.

Experience

Work history, roles, and key accomplishments

Data Analytics Job Simulation

Quantium

Jun 2026 - Jul 2026 (1 month)

Completed a Quantium retail category management job simulation, performing EDA and customer segmentation on ~72K+ customers using Python. Identified benchmark stores for trial locations, validated uplift with statistical significance testing, and delivered results in a category-manager-ready report.

Python Pandas NumPy EDA Customer Segmentation Magnitude Similarity Scoring Statistical Significance Control Store Evaluation Data Storytelling

Retail Analytics Capstone

TI Cycles of India

Jan 2026 - Jun 2026 (5 months)

Built an end-to-end retail analytics simulation using SQL, Python, Power BI, and Excel based on TI Cycles of India’s business profile. Analyzed inventory and sales trends, developed an inventory health scoring model with ABC-XYZ segmentation, evaluated marketing campaigns using ROMI/CPA/CTR, and delivered interactive dashboards and actionable insights.

SQL Python Power BI Excel Inventory Analytics MoM YoY Growth Inventory Health Scoring ROMI CPA CTR A B Testing T Value Data Modeling DAX KPI Tracking

Business Analyst

Affine Analytics

Jun 2022 - Dec 2023 (1 year 6 months)

Analyzed Microsoft Bing Ads campaign performance and built Excel/Power BI dashboards to support business reporting and ad-hoc insights for optimization. Performed SQL-based data extraction/cleaning and ran A/B testing and statistical analysis for Azure marketing campaigns, automating reporting across 10+ campaigns.

SQL Power BI Excel Campaign Analytics Dashboard Development KPI Tracking A B Testing Statistical Analysis Data Extraction Data Cleaning data transformation Report Automation Stakeholder Communication Customer Segmentation

Project - Microsoft Bing Ads

Microsoft Bing Ads

Analyzed Microsoft Bing Ads campaign performance using CTR, CVR, CPA, impressions, clicks, and revenue metrics. Built Excel and Power BI dashboards and used SQL to generate ad-hoc insights for campaign optimization.

Bing Ads SQL Power BI Excel CTR CVR CPA KPI Analysis Dashboard Development

Project - Microsoft Azure Campaign Analytics

Microsoft Azure

Collaborated with stakeholders to translate analytical requirements for Azure marketing campaigns. Performed data extraction/cleaning with SQL, built Power BI dashboards, ran A/B testing and statistical analysis across KPIs, and automated reporting for 10+ Azure campaigns.