Ankit Kumar Sen –Marketing Data Analyst | Power BI | SQL | GA4 | Business Intelligence | Data Analytics

Hi, I’m Ankit Kumar Sen — a Data Analyst and Marketing Analytics Professional with 5+ years of experience transforming complex data into actionable business insights. I specialize in SQL, Power BI, Excel, and Google Analytics 4, helping organizations optimize performance, improve decision-making, and drive measurable business growth through data-driven strategies.

✔ 5+ Dashboards Built

✔ ROI Improved by 12%

✔ Multi-channel Data Analysis

Turning data into business intelligence through analytics, dashboards, and performance optimization.

CORE TOOLKIT

Tools & Skills I Use to Solve Business Problems

A practical toolkit combining data analysis, visualization, reporting and digital analytics to turn business data into actionable insights.

ANALYSIS

Data Analysis

Analyze, clean and transform business data to identify trends, patterns and performance opportunities.

SQL Core

Joins · GROUP BY · Aggregations · Filtering

Excel Core

Pivot Tables · XLOOKUP · Power Query

Data Cleaning & Transformation

Missing Values · Data Formatting · Transformation

VISUALIZATION

Data Visualization

Build interactive dashboards and reporting solutions that communicate business performance clearly.

Power BI Primary

DAX · Data Modeling · Dashboard Design · Power Query

Looker Studio

Interactive Dashboards · Reporting · KPI Monitoring

DIGITAL ANALYTICS

Analytics Tools

Track user behavior, marketing performance and digital interactions to support data-driven decisions.

Google Analytics 4 Analytics

Traffic Analysis · User Behavior · Funnel Tracking

Google Tag Manager Tracking

Event Tracking · Data Collection · Tag Management

ANALYTICAL WORKFLOW

From Raw Data to Business Insight

Data Collection → Data Cleaning → Analysis → Visualization → Business Insight

SELECTED PROJECTS

Turning Data Into Business Insights

A collection of analytics and business intelligence projects focused on solving real-world business problems using data.

ENTERPRISE BUSINESS INTELLIGENCE

Executive Business Intelligence & KPI Monitoring Platform

Designed an enterprise-level Power BI platform integrating sales, finance, marketing, and operational data into a centralized reporting solution.

↳

Data Architecture

Star Schema · Data Modeling · Power Query

↳

Advanced BI

DAX · Forecasting · Anomaly Detection · RLS

↳

Executive Reporting

KPI Monitoring · Drill-through · Automated Reporting

SQL Power BI DAX Power Query Data Modeling

PROJECT LEVEL Enterprise
BI Platform

↗

PROFITABILITY & ROOT CAUSE ANALYSIS

Revenue Leakage & Profitability Root Cause Analysis

Analyzed revenue, profit, discounts, returns, and shipping costs to identify the key drivers behind profitability decline and profit leakage.

↳

Root Cause Analysis

Product · Customer · Regional Profit Leakage

↳

Advanced Analytics

Advanced SQL · Python · DAX · Variance Analysis

↳

Executive Dashboard

Profitability KPIs · Drill-through · Margin Analysis

SQL Python Power BI DAX Excel

PROJECT LEVEL Advanced
Analytics

↗

MACHINE LEARNING & CUSTOMER ANALYTICS

Customer Churn Prediction & Retention Analytics

Analyzed customer behavior, engagement, and transaction history to identify churn patterns and predict high-risk customers.

↳

Churn Prediction

Machine Learning · Customer Risk Segmentation

↳

Customer Analytics

CLV · Retention · Cohort Performance

↳

Business Insights

Churn Drivers · Retention Opportunities

SQL Python Scikit-learn Power BI

PROJECT LEVEL Predictive
Analytics

↗

MARKETING & CUSTOMER JOURNEY ANALYTICS

Marketing Attribution & Customer Journey Analytics

Analyzed multi-channel customer journeys and conversion paths to evaluate marketing performance and optimize customer acquisition.

↳

Attribution Analysis

Conversion Paths · Attribution Models

↳

Marketing KPIs

CAC · ROAS · Conversion Rate · CLV

↳

Customer Journey

Multi-touch Channel & Funnel Analysis

BigQuery SQL Python Power BI GA4

PROJECT LEVEL Advanced
Marketing Analytics

↗

SALES & MARKETING ANALYTICS

B2B Lead Generation & Sales Funnel Analytics

Analyzed B2B lead and sales pipeline data to evaluate lead quality, conversion performance, and funnel bottlenecks across channels and regions.

↳

Funnel Analysis

Lead → MQL → SQL → Opportunity → Won

↳

Lead Segmentation

Industry · Company Size · Source · Region

↳

Sales Dashboard

Conversion · Pipeline Value · Sales Cycle

SQL Python Power BI Excel DAX

PROJECT LEVEL Business
Analytics

↗

MANUFACTURING & PRODUCT ANALYTICS

Product & Customer Performance Analytics for Manufacturing

Analyzed product, customer, regional, and order-level data to identify high-performing products, valuable customer segments, and growth opportunities.

↳

Customer Segmentation

Revenue · Frequency · Order Value · Lifecycle

↳

Product Analysis

Revenue · Profitability · Sales Trends

↳

KPI Dashboard

Revenue · Margin · AOV · Regional Performance

SQL Python Power BI DAX Excel

PROJECT LEVEL Product &
Customer Analytics

↗

PRODUCT ANALYTICS & EXPERIMENTATION

Product Funnel Optimization & A/B Testing Analytics

Analyzed end-to-end customer funnels to identify conversion bottlenecks and evaluate product improvements through experimentation.

↳

Funnel Analysis

Conversion Rates · Drop-offs · User Journey

↳

Experimentation

A/B Testing · Hypothesis Testing · Statistics

↳

Optimization

Experiment Performance · Conversion Improvement

SQL Python Power BI Statistics

PROJECT LEVEL Product
Analytics

↗

01 07

Experience & Professional Background

Turning data into insights to improve business performance, optimize funnels, and support data-driven decisions.

CURRENT POSITION

Marketing Executive

IRM Enterprises Pvt. Ltd.

Sep 2025 – Present

Digital Marketing Analyst

Tuchware Technologies Pvt. Ltd.

Jan 2023 – Aug 2025

Digital Marketing Executive

Ascent Brand Communication Pvt. Ltd.

Jan 2022 – Aug 2022

Social Media Marketing Executive

Tracknovate Technologies Private Limited

Apr 2021 – Dec 2021

Sales Marketing Executive

Sparsh Realities

Jun 2020 – Mar 2021

Certifications & Professional Learning

Continuous learning in data analytics, dashboards, and business intelligence to solve real-world problems.

📚

PROFESSIONAL LEARNING

Data Analytics Program

Sathya Technologies

Structured learning focused on practical data analytics, reporting, business intelligence and analytical tools.

SQL Advanced Excel Power Query Power BI DAX Python Data Analytics

📊

MICROSOFT CERTIFICATION

Microsoft Power BI Data Analyst Associate

PL-300

Professional certification focused on building analytical solutions with Power BI, data preparation, modeling, DAX and visualization.

Power BI Power Query Data Modeling DAX Data Visualization Power BI Service

🎓

PROFESSIONAL CERTIFICATE

Google Data Analytics Professional Certificate

Google · Coursera

End-to-end data analytics learning covering data analysis, spreadsheets, SQL, data cleaning, visualization and business analytics through practical case studies.

Data Analysis Spreadsheets SQL Data Cleaning Data Visualization Business Analytics Case Study

🚀

Continuous Learning

Building practical expertise across SQL, Excel, Power BI, DAX, Python and data analytics through structured learning and project-based application.

OPEN TO OPPORTUNITIES

Let’s Connect

Looking for a Data Analyst who can turn data into actionable insights and drive business decisions? Let’s connect and discuss how I can add value to your team or project.

✉ GET IN TOUCH Email Me → in CONNECT WITH ME LinkedIn ↗ ⌘ VIEW MY WORK GitHub ↗ ↓ PROFESSIONAL PROFILE Download Resume ↓