Rajarshi saha

Rajarshi saha

Aspiring Consulting Analyst

Bhubaneswar, Odisha, IndiaData Analytics and Consulting
1roles
19skills
2education
4credentials

About

Aspiring Consulting Analyst with hands-on experience in data analytics, business problem-solving, and insight generation. Skilled in SQL, Python, Power BI, and Excel, with experience translating data into actionable business recommendations.

Experience

Data Analyst Intern

3Skill Training Institute

Dec 2024 – Feb 2025 · Remote

Processed and cleaned multiple real-world datasets using Python and SQL; developed KPI-driven dashboards using Power BI and Excel; automated preprocessing workflows, reducing manual effort by approximately 30%; analyzed datasets to identify trends and provided actionable recommendations; communicated findings through simulated stakeholder-oriented problem statements.

Education

KIIT School of Biotechnology, KIIT University

B.Tech + M.Tech Dual Degree, Biotechnology

2023 – 2028 (Expected)

Relevant coursework: Statistics, Data Analysis, Research Methodology

SRM Institute of Science and Technology (SRMIST)

Bachelor's Degree, CSE

Aug 2023 - Jun 2028

Skills

SQLSQL JoinsSQL AggregationsPythonPandasNumPyAdvanced ExcelPower BIExploratory Data AnalysisKPI DesignBusiness InsightsProblem SolvingBasic ETL ConceptsGitHubJupyter NotebookStreamlitAlteryxConsultingAuditing

Projects

Hotel Booking Analysis & Revenue Optimization

Analyzed 119,000+ booking records using Python, SQL, and Power BI to identify drivers of cancellations and revenue loss. Built an interactive KPI dashboard covering cancellation rate, ADR, and booking channels; identified the relationship between longer lead times and cancellation probability; recommended pricing and overbooking strategies to reduce revenue leakage.

Retail Transaction Analysis & Customer Segmentation

Performed transaction-level analysis using Python, SQL, and Excel to identify high-value customer segments and product performance. Built KPI-based reports with Pivot Tables and Lookups, identified top revenue-contributing customer segments, and suggested targeted marketing strategies to improve retention and profitability.

Credit Risk Analysis (Fintech Case Study)

Analyzed loan datasets using Python and SQL to identify patterns in customer default behavior. Segmented customers into risk categories based on financial attributes, generated insights for risk-based decision-making, and recommended strategies to minimize default rates and improve approval efficiency.