Ankit Kumar Sen – Data Analyst | SQL, Power BI & Marketing Analytics
Hi, I’m Ankit Kumar Sen — a Data Analyst and Marketing Analytics Professional with 4+ 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.
Turning data into business intelligence through analytics, dashboards, and performance optimization.
Tools & Skills I Use to Solve Business Problems
🧠 Data Analysis
SQL
Joins | Group By | Aggregations | Filtering
Excel
Pivot Tables | XLOOKUP | Power Query
Data Cleaning & Transformation
Missing Values | Data Formatting
📊 Data Visualization
Power BI
DAX | Data Modeling | Dashboard Design
Looker Studio
Interactive Dashboards | Reporting
⚙️ Analytics Tools
Google Analytics 4
Traffic Analysis | User Behavior
Google Tag Manager
Event Tracking | Data Collection
Featured Projects 🚀
Real-world data analytics projects focused on solving business problems using SQL, Power BI, and marketing data.
🔥 Marketing Performance & ROI Analysis
Analyzed multi-channel marketing data to optimize ROI, CAC, and budget allocation using dashboards and business insights.
View Case Study →Lead Funnel Drop-Off Analysis
Identified conversion leaks in funnel stages and improved performance using data-driven insights.
View Project →Sales & Marketing Dashboard
Unified sales & marketing data into a single dashboard to track revenue and performance KPIs.
View Project →SQL Business Insights Analysis
Used SQL (JOIN, GROUP BY) to extract insights and analyze performance trends.
View Queries →A/B Testing Analysis
Analyzed experiment results and conversion impact to support data-driven decisions.
View Analysis →GA4 Analytics Dashboard
Built GA4 dashboard tracking leads, calls, and user behavior for business insights.
View Dashboard →Experience & Professional Background
Turning data into insights to improve business performance, optimize funnels, and support data-driven decisions.
Marketing Executive (Analytics-Focused)
IRM Enterprises Pvt. Ltd. | Sep 2025 – Present
- Analyzed multi-market performance data to evaluate ROI, CPL, and conversion efficiency.
- Built GA4 & Looker Studio dashboards for leadership reporting and strategic decisions.
- Identified funnel drop-offs and optimization opportunities improving lead quality.
- Delivered data-driven insights to support budget allocation and performance growth.
Digital Marketing Analyst
Tuchware Technologies Pvt. Ltd. | Jan 2023 – Aug 2025
- Analyzed multi-channel data (website, campaigns, offline) to identify growth opportunities.
- Built 5+ Power BI dashboards tracking CAC, ROI, and funnel performance.
- Improved campaign ROI by 12% through A/B testing and performance analysis.
- Performed funnel analysis (Traffic → Leads → Conversion) to identify revenue leakages.
Digital Marketing Executive
Ascent Brand Communication Pvt. Ltd. | Jan 2022 – Aug 2022
- Managed and coordinated WordPress website development projects for multiple clients.
- Collaborated with developers, designers, and stakeholders to ensure timely project execution and website delivery.
- Planned website structure, content updates, and digital marketing activities aligned with client objectives.
- Monitored website performance and supported optimization initiatives to improve user experience and engagement.
Social Media Marketing Executive
VOSO Store | Apr 2021 – Dec 2021
- Tracked campaign performance metrics and prepared performance reports.
- Assisted in data collection and basic analysis to support marketing decisions.
- Monitored engagement, reach, and lead generation metrics across campaigns.
Certifications & Professional Learning
Continuous learning in data analytics, dashboards, and business intelligence to solve real-world problems.
Google Analytics 4 (GA4)
Web Analytics • Funnel Tracking • User Behavior
GoogleAdvanced Excel & SQL for Analytics
Data Analysis • Reporting • Business Insights
Data AnalyticsPower BI & Dashboard Design
KPI Dashboards • Data Modeling • Visualization
Power BIGoogle Data Analytics Professional Certificate
End-to-End Data Analysis • SQL • Data Cleaning • Visualization
CourseraLet’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.