About
I'm a Data Analyst with 1.7+ years of professional experience in Marketing Analytics and Business Intelligence at Affine Analytics, where I worked on Microsoft Bing Ads and Azure Campaign Analytics. My experience includes using SQL, Python, Power BI, and Excel to analyze campaign performance, build interactive dashboards, automate reporting, conduct A/B testing, and track business KPIs. I automated reporting for 10+ Azure skilling campaigns, reducing manual reporting effort by 60%, and worked with stakeholders to translate business requirements into actionable insights. From 2024 to 2025, I took a career break due to family responsibilities while continuing to develop my Data Analytics skills through structured learning and self-directed practice. Since 2026, I have completed 9+ end-to-end analytics projects and virtual job simulations covering retail analytics, sales analytics, customer segmentation, inventory analytics, marketing analytics, and business intelligence. Some of my recent work includes: • B2B Sales Performance & Profitability Analytics using Power BI and DAX • Quantium Data Analytics Job Simulation involving ~72K customers, customer segmentation, benchmark-store evaluation, and statistical testing • Retail Analytics Capstone covering inventory health scoring across 500+ SKUs, 15+ marketing campaigns, SQL analysis, Python, Power BI, and A/B testing 🛠️ Core Skills SQL | Python | Power BI | DAX | Power Query | Excel | Data Analysis | Business Intelligence | Dashboard Development | Data Visualization | A/B Testing | Statistical Analysis | KPI Reporting | Marketing Analytics | Retail Analytics 🏆 Key Highlights • Automated reporting for 10+ campaigns, reducing manual effort by 60% • Built an Inventory Health Scoring Model using ABC-XYZ segmentation across 500+ SKUs • Evaluated 15+ marketing campaigns using ROMI, CPA, CTR, A/B testing, and statistical analysis • Analyzed a Quantium retail trial and identified genuine uplift in 2 of 3 stores, including up to +19% customer growth • Flagged a trial-store result as statistically unreliable due to a weak control-store match, avoiding overstatement of the result 📩 Open to opportunities as a Data Analyst, Business Intelligence Analyst, Reporting Analyst, Business Analyst, or Power BI Developer. Immediate joiner. GitHub: https://github.com/Mohan81020?tab=repositories
Work experience
Business Analyst at Affine, Jun 2022 - Dec 2023 · 1 y 6 mo, Bengaluru, Karnataka, India, Project: Microsoft Bing Ads * Analyzed Bing Ads campaign performance using CTR, CVR, CPA, Revenue, Impressions, and Clicks to measure campaign effectiveness. * Delivered weekly ad-hoc analysis and Flight Scorecard reports to support campaign monitoring and optimization. * Conducted A/B testing on ad copy to improve campaign engagement and conversion rates. * Built Excel and Power BI dashboards to track campaign KPIs and provide business insights. Project: Microsoft Azure Campaign Analytics * Analyzed Azure skilling campaigns across the Acquisition, Onboarding, Expansion, and Retention lifecycle stages. * Developed SQL queries and Power BI dashboards to analyze campaign performance and business KPIs. * Conducted A/B testing and statistical significance analysis on Monthly Active Users, Conversions, Activations, Retention, and Revenue. * Automated reporting for 10+ Azure skilling campaigns using Python and Excel, reducing manual effort by 60% and improving report delivery efficiency. * Delivered campaign performance insights and data-driven recommendations to stakeholders to improve campaign effectiveness and business outcomes.
