Aman Pathania

Data Analyst

New Delhi 2+ yrs exp 85 · Excellent

About

Data Analyst with 1+ years of experience in data analysis, MIS reporting, campaign analytics, and business intelligence. Proficient in SQL, Python, Advanced Excel, Tableau, and statistical analysis for transforming raw data into actionable business insights. Experienced in KPI reporting, dashboard development, trend analysis, and stakeholder reporting to support data-driven business decisions.

Skills & Expertise (32)

Tableau Intermediate

7.4/10

Years Exp

Data Cleaning Intermediate

7.4/10

Years Exp

Exploratory data analysis Intermediate

7.4/10

Years Exp

KPI Reporting Intermediate

7.4/10

Years Exp

Data Analysis Intermediate

7.4/10

Years Exp

Dashboard Development Intermediate

7.4/10

Years Exp

Advanced Excel Intermediate

7.4/10

Years Exp

Python Intermediate

7.4/10

Years Exp

NumPy Intermediate

7.4/10

Years Exp

Pandas Intermediate

7.4/10

Years Exp

SQL Intermediate

7.4/10

Years Exp

MySql Intermediate

6.6/10

Years Exp

Logistic Regression Intermediate

6.4/10

Years Exp

XGBoost Intermediate

6.4/10

Years Exp

Random Forest Intermediate

6.4/10

Years Exp

K-Means Clustering Intermediate

6.4/10

Years Exp

Statistical Analysis Intermediate

6.4/10

Years Exp

Business Analytics Intermediate

6.4/10

Years Exp

scikit-learn Intermediate

6.4/10

Years Exp

Seaborn Intermediate

6.4/10

Years Exp

Matplotlib Intermediate

6.4/10

Years Exp

Campaign Analytics Data Validation Sales Analytics XLOOKUP MIS Reporting Trend Analysis Forecasting VLOOKUP Conversion Rate ROI Analysis Pivot Tables

Work Experience

Marketing Analyst

Collegedunia Web Pvt. Ltd.

Aug 2025 - Present

Extracted customer and lead data from centralized databases using SQL and Advanced Excel to support marketing and client campaigns. Cleaned, validated, standardized, and segmented large datasets by removing duplicates, correcting inconsistencies, and ensuring data quality before campaign execution. Prepared campaign-ready datasets based on business rules, target audience, and client requirements for the marketing operations team. Built MIS reports and performance dashboards to monitor campaign KPIs including Open Rate, CTR, CPL, CPC, Conversion Rate, and lead generation metrics. Analyzed campaign performance data to identify trends, audience behaviour, and optimization opportunities for improving campaign effectiveness. Generated business reports and presented actionable insights to internal stakeholders for campaign planning and performance reviews. Collaborated with marketing, sales, and operations teams to maintain data accuracy, automate reporting processes, and support data-driven decision-making.

Data Research Analyst

Collegedunia Web Pvt. Ltd.

Nov 2024 - Jul 2025

Solved and structured examination question papers using ChatGPT and LaTeX while maintaining formatting consistency and publishing standards. Published educational content and monitored post-publication performance by tracking user engagement, response quality, and content effectiveness. Performed data validation, quality checks, and trend analysis to identify content improvement opportunities. Prepared analytical reports summarizing content performance, user behaviour, and engagement trends for internal stakeholders. Collaborated with editorial and operations teams to maintain accurate datasets and improve reporting quality.

Data Science Intern

AI Variant

Apr 2024 - Jul 2024

Conducted Exploratory Data Analysis (EDA) on 20,000+ customer records using Python, SQL, Pandas, and NumPy. Cleaned, transformed, and validated structured datasets to improve data quality and reporting accuracy. Built customer segmentation models using K-Means clustering to identify high-value customer groups. Developed Tableau dashboards and visualizations to communicate customer behaviour and business insights.

MIS Executive Intern

Bathline India Pvt. Ltd.

Sep 2023 - Jan 2024

Developed MIS reports and Excel dashboards to monitor inventory, product availability, and business KPIs. Utilized Advanced Excel, Pivot Tables, VLOOKUP, XLOOKUP, and advanced formulas to analyze inventory movement, pricing trends, and sales performance. Generated business reports supporting procurement planning, inventory optimization, and management decision-making. Collaborated with sales and procurement teams to improve reporting accuracy and operational efficiency.