Open to opportunities

Sohampirag Sohampirag

@sohampiragsohampirag

Message

I am an aspiring Data Analyst skilled in SQL, Python, Power BI

India

Message

What I'm looking for

I seek entry-level data analyst roles where I can apply SQL, Python, and Power BI to build dashboards, solve business problems, and grow within a collaborative, learning-focused team that values data-driven decision-making.

I am an aspiring Data Analyst with hands-on experience in Excel, Power BI, SQL, and Python.

As a B.Tech Information Technology student, I focus on transforming raw data into actionable insights through dashboards, exploratory data analysis, and KPI reporting.

I have delivered projects that leveraged advanced SQL (CTEs, window functions, aggregations) to identify top-selling items and peak sales hours. I built an interactive Excel dashboard for 10,000+ cafe transactions and developed Power BI reports that supported a 4.18M net sales improvement.

I bring strong data cleaning, visualization, statistical analysis, and communication skills, and I am eager to join a collaborative team where I can apply my analytical skills to solve business problems and grow professionally.

Experience

Work history, roles, and key accomplishments

Pizza Sales Analysis

Academic Project

Used advanced SQL (CTEs, window functions, aggregations) to extract actionable insights identifying top-selling pizzas and peak sales hours to inform operational decisions.

SQL Window Functions Data Cleaning Data Analysis Reporting

Cafe Sales Dashboard

Academic Project

Analyzed 10,000+ cafe transactions (36.5 Lakh revenue, 30,156 units) and developed an interactive Excel dashboard highlighting KPIs, identifying Coffee as the top-selling category (7.6 Lakh) to optimize inventory and promotions.

Excel Dashboarding Data Cleaning KPIs Reporting

Shopify Sales Trend Analysis

Academic Project

Built Power BI analyses that drove 4.18M in net sales growth, increased repeat purchase rate to 46% and CLV to 943.6, and raised Shopify Payments adoption to 51.6% to improve conversions.

Power BI DAX Data Visualization SQL KPI Tracking CLV Calculation

Education

Degrees, certifications, and relevant coursework

IPS Academy, Institute of Engineering & Science (IES), Indore

Bachelor of Technology, Information Technology

2023 -

Grade: 7.7/10

Activities and societies: Academic projects: Pizza Sales Analysis (SQL); Café Sales Analysis Dashboard (Excel) analyzing 10,000+ transactions; Shopify Performance Intelligence (Power BI). Certifications: Data Visualisation (Forage/TATA Group); Python (Scaler Academy).

Pursuing a Bachelor of Technology in Information Technology from Sept 2023 to July 2027 with a CGPA of 7.7/10, focusing on data analysis, visualization, and applied projects using SQL, Excel, and Power BI.