Summary
Overview
Work History
Education
Skills
Certification
Timeline
PROJECTS (Course / Capstone)
ADDITIONAL INFORMATION
Generic

Payel Paul

Gurgaon

Summary

Detail-oriented Data Analyst with an MA in Economics and practical experience delivering end-to-end BI solutions using Power BI, SQL and Python. Skilled at building ETL pipelines, writing DAX & SQL (including window functions), performing data cleaning and feature engineering in pandas, and creating actionable dashboards and reports. Seeking an entry-level Data Analyst role to apply strong data modeling, visualization and analytical skills.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Subject Matter Expert (Economics)

Chegg India Pvt. Ltd
01.2018 - 01.2023
  • Authored clear, step-by-step solutions to complex economics problems for a high-volume student base, ensuring accuracy and pedagogical clarity.
  • Standardized solution templates and quality checks to maintain content consistency across reviewers.
  • Collaborated with cross-functional reviewers to validate content and ensure fast turnaround of answers.
  • Remote

Education

Master of Arts - Economics

Indira Gandhi National Open University
12-2018

Bachelor of Arts - Economics

Tripura University
06-2015

Skills

  • Power BI (Power Query M, DAX)
  • SQL (MySQL, PostgreSQL)
  • Python (pandas, numpy, scikit-learn)
  • Jupyter Notebooks
  • Tableau
  • Advanced Excel (Pivot Tables, VLOOKUP)
  • ETL
  • Data Cleaning
  • Data Modeling
  • DAX measures
  • SQL window functions
  • Data Visualization
  • Feature Engineering
  • Logistic Regression
  • Confusion Matrix

Certification

  • Data Analyst Masters Program — Simplilearn, 2025
  • Power BI / PL-300 — Simplilearn, 2025
  • Python 101 for Data Science — IBM, 2025
  • SQL for Data Analysis — Simplilearn, 2025

Timeline

Subject Matter Expert (Economics)

Chegg India Pvt. Ltd
01.2018 - 01.2023

Master of Arts - Economics

Indira Gandhi National Open University

Bachelor of Arts - Economics

Tripura University

PROJECTS (Course / Capstone)

Zomato Restaurant Analytics — Power BI | Aug 2025, 

Tools: Power BI (Power Query, DAX), 

> Consolidated multi-file restaurant datasets into a single Power BI data model using Power Query; cleaned and standardized fields to enable reliable joins and reporting., Implemented DAX measures for YoY growth, Average Order Value and repeat-customer rate; built drill-through dashboards for city/cuisine/restaurant-level analysis., Designed interactive visuals and filters for quick segmentation and trend discovery to support prioritization of top-performing restaurants., 

Healthcare Analytics — Python & Power BI (Capstone) | Sep 2025, 

Tools: Python (pandas), Power BI,

> Cleaned and engineered features from raw clinical datasets using pandas; prepared train/test datasets and implemented logistic regression models., Evaluated model performance using confusion matrix and standard classification metrics; visualized outcomes in interactive Power BI dashboards., 

Air Cargo Analysis — SQL | Apr 2025, 

Tools: SQL (MySQL/PostgreSQL), 

> Performed SQL-based analysis to identify regular customers and busiest routes; prepared insights to inform capacity planning and route optimization., Produced ticket-sales and route utilization analyses to guide operational decisions.

ADDITIONAL INFORMATION

  • Languages: English, Hindi, Bengali
  • Availability: Immediate
Payel Paul