← Back to list
Registration: 29.09.2026

Payel Pramanik

Specialization: Data Analyst
Data Analyst with hands-on experience in data cleaning, validation, and reporting. Skilled in SQL, Python, Power BI, and advanced Excel. Proven ability to automate workflows, build dashboards, and deliver actionable insights. Strong background in exploratory data analysis and data quality initiatives.
Python SQL Git PostgreSQL MySQL Excel Data Analysis pandas Tableau Power BI Jupyter Matplotlib NumPy ETL Data Visualization
Data Analyst with hands-on experience in data cleaning, validation, and reporting. Skilled in SQL, Python, Power BI, and advanced Excel. Proven ability to automate workflows, build dashboards, and deliver actionable insights. Strong background in exploratory data analysis and data quality initiatives.
Python SQL Git PostgreSQL MySQL Excel Data Analysis pandas Tableau Power BI Jupyter Matplotlib NumPy ETL Data Visualization

Portfolio

SQL Retail Sales Analysis | SQL

● Processed 2K+ retail transactions to evaluate customer behavior and purchasing trends. ● Implemented advanced SQL techniques, including CTEs, Window Functions, and aggregations. ● Delivered actionable insights on revenue, seasonal demand, and product category performance.

Indigo Meal Feedback Analysis | Python

● Examined 1,000+ customer feedback records to identify meal quality and satisfaction patterns. ● Transformed raw datasets through preprocessing and validation, improving analysis accuracy. ● Presented actionable insights using visualizations, enabling informed business decisions.

Global Airbnb Performance Dashboard | Power BI

● Analyzed 49K+ Airbnb listings across 10 major cities using Power BI. ● Built 8+ interactive dashboards with DAX, Power Query, and data modeling. ● Identified pricing, occupancy, and review trends to support data-driven decisions.

Skills

Data Analysis
Data Cleaning
Data Visualization
Jupyter
NumPy
Matplotlib
Data Visualization
ETL
Python
SQL
Power BI
Tableau
pandas

Work experience

Data Analyst Intern
12.2024 - 08.2025 |Invact
Mentor
● Generated daily and monthly MIS reports using Excel and Google Sheets for management review. ● Utilized SQL and advanced Excel functions to extract, organize, and interpret information. ● Reviewed records for completeness before integrating them into reporting systems. ● Delivered reliable datasets for dashboards and operational reporting. ● Mentored students in their coursework, guiding them on SQL queries, Excel analytics, and dashboard creation.
Data Analyst Intern
since 11.2025 - Till the present day |Red Dot Foundation (Safety)
Google Apps Script
● Managed, cleaned, and maintained structured datasets to ensure data accuracy and consistency. ● Developed a Google Apps Script-based automation to synchronize project timelines between Google Sheets and Google Calendar. ● Performed exploratory data analysis to identify trends, patterns, and anomalies. ● Supported data quality initiatives through validation, error identification, and data cleansing. ● Maintained organized datasets and documentation to support recurring business reports.

Educational background

Electronics and Communication Engineering (Bachelor’s Degree)
2020 - 2023
Jalpaiguri Government Engineering College

Languages

EnglishProficientHindiProficientBengaliProficient