PROFILE
Highly motivated and skilled IT graduate from Techno India, Kolkata. Proficient in SQL, Python, Advanced Excel and data visualization tools including Power BI. Proven ability to develop data-driven solutions, as demonstrated by projects in Bank customer churn analysis, Domino’s pizza sales insights and Tactical Crime Analysis. Eager to apply technical skills and contribute to a challenging role in data analysis.
Personal Project/s
Project Name :
UrbanCart Superstore Analysis – Python
Description :
Python Data Analysis project using PANDAS and MATPLOTLIB to analyze retail sales data, perform data
cleaning and feature engineering, conduct revenue, profit and margin analysis, build time-series and
regional visualizations, and deliver data-driven business insights for profitability optimization.
Project Name :
Tactical Crime Analysis – Power BI
Description :
Designed and deployed a multi-page Power BI tactical crime analysis dashboard using DAX, advanced data modelling, and Azure Maps to analyse citywide crime patterns.
Project Name :
Customer spending Analysis & Credit card strategy – Power BI
Description :
Developed a Power BI–driven banking analytics solution analysing spending behaviour of 4,000 customers to support data-driven credit card product strategy and customer segmentation.
Project Name :
Domino’s Pizza Sales Analysis – SQL
Description :
Performed Domino’s Pizza Sales Analysis using MySQL, applied advanced SQL techniques such as JOINS, CTE, WINDOW functions to analyse order trends and revenue performance.
Project Name :
Walmart Sales & Customer Analysis – SQL
Description :
Utilized SQL to analyse 10,000+ Walmart sales transactions, identifying trends in revenue, product performance, and customer behaviour.
Project Name :
BMW Sales Analysis - Excel
Description :
Analyzed 50K+ BMW sales records in Excel, uncovering key insights on top models, regional performance, and customer preferences to support data-driven decisions.
Built an interactive dashboard with KPIs and trend analysis, enabling strategic business insights
Project Name :
Bank Customer Churn Analysis – Excel
Description :
Performed Bank Customer Churn Analysis on a dataset of 10,000 records using Microsoft Excel, applying data cleaning, segmentation, and exploratory data analysis (EDA).
Project Name :
HR Analytics Dashboard - Tableau
Description :
Developed an interactive HR Analytics Dashboard in Tableau to analyze employee distribution, attrition trends, salary patterns, and hiring growth for data-driven workforce insights.
Experience/s
Company :
Webskitters Academy
Designation :
Data Analyst Intern
Description :
Retail Sales & Inventory Power BI Dashboard
- Built a Power BI dashboard analyzing 829K+ transactions across 50 stores, enabling real-time sales and inventory insights that improved decision-making speed.
- Developed DAX-driven analytics to identify 77 stockouts and 15K low-stock risks, reducing lost sales and optimizing inventory distribution.
EDUCATION
B.TECH INFORMATION TECHNOLOGY