Certificate
✦ Open to opportunities across Analytics, Strategy, Operations & Business

MY
PORTFOLIO
Open to Work

Data Analyst Economics Graduate Student Power BI Developer Business Intelligence Analyst

MSc Economics graduate who likes asking better questions before finding better answers. My work sits at the intersection of data, research, business, and problem-solving, where I turn complex information into insights that are easier to understand and act on. I enjoy exploring unfamiliar problems, finding patterns others might miss, and using analytical and digital tools to turn ideas into practical solutions.

View My Work Get in Touch
SQL Python Power BI Excel Data Analytics Business Intelligence Statistical Analysis Dashboard Design KPI Reporting Forecasting
✦ About Me

Beyond The
Numbers

I bring a combination of structured thinking, commercial curiosity, and hands-on problem-solving. I'm comfortable taking an ambiguous problem, figuring out what matters, and building a clear path from question to outcome. My toolkit includes Python, SQL, Excel, Power BI, statistical analysis, forecasting, data visualization, and GenAI tools, which I use to explore problems, test ideas, organize information, and communicate findings clearly.

What sets me apart is my ability to connect the technical with the practical. I can work through the details without losing sight of the bigger business picture, learn unfamiliar tools quickly, and adapt across research, business, operations, and analytical projects. I bring curiosity, ownership, and a willingness to go beyond the obvious, with a focus on producing work that is not just technically sound, but genuinely useful.

✦ Mission

"To approach every problem with curiosity, challenge assumptions with evidence, and turn insights into solutions that create real value."

✦ Vision

"To become a versatile problem-solver who can move across data, business, research, and emerging technology, bringing clarity to complexity and ideas to life."

📊
I Look for the Signal
I like digging past the obvious numbers to find the patterns, gaps, and drivers that actually matter.
🧠
Economics, Without the Box
An economics foundation shaped how I think about incentives, trade-offs, risk, and the decisions behind the data.
🔎
I Learn by Solving
My projects take me across banking, logistics, healthcare, business, and research, usually starting with a question I don't already know the answer to.
🛠️
I Build to Understand
SQL, Python, Excel, Power BI, and AI tools are not just things I list. I use them to explore problems, test ideas, and turn analysis into something useful.
✦ Technical Arsenal

Skills & Expertise

💻 Data & Programming
🗄️ SQL 🗃️ SQLite 🐍 Python 📦 Pandas 🔢 NumPy 📓 Jupyter 📊 Matplotlib 🔬 Seaborn 🤖 Scikit-learn
📊 Analytics & Statistics
🧭 Exploratory Data Analysis 🧹 Data Cleaning 📐 Statistical Analysis 🔢 Quantitative Analysis 🧪 Hypothesis Testing 📈 Regression Analysis 📉 Forecasting 🎯 Segmentation ⚖️ Risk Analysis 🔍 Root Cause Analysis
📈 Business Intelligence
Power BI 🧮 DAX 🔄 Power Query 🧱 Data Modeling 📊 Dashboard Design 🎯 KPI Development 📡 Data Visualization 📶 Performance Analysis 📋 Reporting
📗 Excel & Productivity
📗 Microsoft Excel 📊 Pivot Tables 🔎 XLOOKUP 📈 Excel Charts What-If Analysis 📽️ PowerPoint 📝 MS Word 🔵 IBM Cognos
🔎 Business & Research
📦 Business Analytics 🏛️ Economic Research 🛒 Market Research 🔢 Quantitative Research ⚔️ Competitive Analysis ⚙️ Operations Analytics 💰 Credit Risk Analysis 🚚 Logistics Analytics 🎨 Data Storytelling 🧭 Decision Support
🤖 AI & Creative Tools
💬 ChatGPT 🌟 Claude 🌙 Kimi 🎨 Canva 🔬 AI-assisted Research 📊 AI-assisted Data Analysis ✍️ Prompt Engineering 🖌️ AI-assisted Content Creation
✦ Portfolio Work

Featured Projects

01
Data Analytics & Business Intelligence
Airbnb Global Marketplace Intelligence

Built an end-to-end marketplace analytics solution using Excel, SQL, Python, and Power BI to analyze 279,712 listings, 182,024 hosts, and 5.37M+ reviews across 10 global cities, translating marketplace data into pricing, growth, host performance, and operational decisions.

  • Audited 279K+ listings in Excel to identify data-quality risks, including 160 duplicate reviews, 113 invalid prices, 85 zero-capacity listings, and 86K+ listings with no review history
  • Answered 10+ marketplace business questions using SQL and Python, uncovering 103K+ significantly underpriced listings, statistically stronger Superhost performance, demand concentration, and key pricing drivers
  • Developed a 4-page interactive Power BI dashboard with a 54.55/100 Marketplace Health Score, dynamic pricing and demand analysis, listing-quality monitoring, and executive KPI cadence
  • Translated findings into actionable business recommendations across pricing guidance, Superhost expansion, demand diversification, and operational triage, prioritizing 174 listings requiring immediate attention
ExcelSQL / SQLite PythonPandas SciPyScikit-learn Power BIDAX Statistical TestingFeature Engineering Random ForestIsolation Forest Data QualityKPI Analytics
02
Data Analytics & Business Intelligence
Hospital Emergency Room Decision Analytics

Built an end-to-end healthcare analytics case study combining Power BI, SQL, Python, and Excel to move beyond dashboard reporting into statistical validation, predictive analysis, forecasting, and operational decision support.

  • Analyzed 9,216 ER visits to evaluate patient flow, wait times, referrals, admissions, satisfaction, and operational patterns
  • Identified 59.3% of visits missing the 30-minute target and pinpointed late-night/overnight staffing gaps for shift-level capacity planning
  • Applied statistical testing and machine learning to distinguish meaningful patterns from noise, including admission, satisfaction, wait-time, and health-equity analysis
  • Built forecasting, patient segmentation, data-quality audits, and business Q&A analysis to translate findings into actionable staffing and data-collection recommendations
Power BISQL PythonPandas SciPyScikit-learn Statistical AnalysisMachine Learning ForecastingExcel
03
Operational Analytics
SwiftRoute Logistics Analytics

Built an end-to-end analytics pipeline to uncover the operational factors affecting delivery performance and turn them into decisions around service quality, hub capacity, workforce allocation, and fleet maintenance.

  • Analyzed 27,979 orders across 2023–2024
  • Identified delay reduction as the highest-leverage opportunity for improving customer satisfaction
  • Flagged Dallas Main Hub at ~121% capacity as a structural network bottleneck
  • Found vehicle age (r = 0.65) to be the strongest available predictor of breakdown risk
ExcelSQL PythonPower BI PandasSQLite DAXScikit-learn Statistical AnalysisData Visualization
04
Data Analytics & Business Intelligence
Bank Loan Analytics Project

End-to-end banking analytics project involving Excel, SQL, Python, and Power BI. Focused on lending portfolio analysis, credit risk assessment, KPI reporting, and business intelligence dashboard development.

  • Analyzed 38,600+ loan applications across the portfolio
  • Identified 86.2% performing loans vs 13.8% charged-off loans
  • Performed borrower risk segmentation and default pattern analysis
  • Built interactive Power BI dashboards for lending performance monitoring
ExcelMicrosoft SQL Server PythonPandas NumPyMatplotlib Power BIDAX
05
Data Analytics & Business Intelligence
Blinkit Sales Performance Analysis

Retail sales analytics project involving Python, Pandas, NumPy, Matplotlib, and Seaborn. Focused on exploratory data analysis, sales performance evaluation, outlet segmentation, product category analysis, and business intelligence reporting.

  • Analyzed 8,523 retail records representing $1.20M+ in total sales
  • Identified Low Fat products contributing 64.6% of total revenue
  • Evaluated sales performance across outlet sizes, establishment years, and location tiers
  • Revealed Tier 3 locations and Medium-sized outlets (42.3%) as key revenue drivers
PythonPandas NumPyMatplotlib Seaborn
✦ Work History

Professional
Experience

Data Analytics Micro Intern
Virtual Internship
Quantium · Forage
📅 June 2026 📍 Remote 📊 Retail Analytics & Commercial Insights
Key Responsibilities
  • Analyzed 260,000+ retail transaction records and customer purchase data using Python to uncover purchasing patterns, revenue drivers, and customer behavior trends
  • Performed data cleaning, transformation, feature engineering, and exploratory data analysis (EDA) to improve data quality and generate actionable business insights
  • Conducted customer segmentation analysis to identify high-value customer groups and support targeted marketing and merchandising strategies
  • Applied correlation analysis, control-store matching, and uplift testing to evaluate store layout trial performance and measure commercial impact
Key Achievements
  • Delivered data-driven recommendations that informed category optimization, customer growth initiatives, and commercial decision-making
  • Developed executive-level analytical reports and visualizations, translating complex findings into clear business insights for stakeholders
  • Identified key sales and customer trends that supported evidence-based merchandising and retail performance improvement strategies
Python Data Analysis EDA Customer Segmentation Uplift Testing
Data Analytics Micro Intern
Virtual Internship
Tata Group · Forage
📅 August 2025 📍 Remote 🏢 GenAI Powered Data Analytics
Key Responsibilities
  • Leveraged GenAI tools to analyze large datasets and extract meaningful patterns
  • Resolved data quality issues and inconsistencies across lending portfolio data
  • Identified delinquency risk indicators from customer data profiles
  • Developed and presented a no-code predictive model framework to stakeholders
Key Achievements
  • Designed an AI-driven collections strategy focused on scalability and regulatory compliance
  • Delivered predictive risk evaluation recommendations using advanced analytical techniques
GenAI Tools Data Analysis Risk Profiling Predictive Modeling
✦ Academic Background

Education &
Qualifications

2021 – 2024
B.Sc. Economics (Honours)
Shri Shikshayatan College, University of Calcutta
  • Economics Honours Curriculum
  • Quantitative and Analytical Foundations
  • Academic CGPA: 7.599
Completed 2021
ISC — Class XII
St. Stephen's School, Dum Dum
  • Scored 96.75%
  • Strong quantitative foundation
  • Academic excellence distinction
Completed 2019
ICSE — Class X
St. Stephen's School, Dum Dum
  • Scored 93.40%
  • Strong academic performance
  • Foundational analytical skills
✦ Credentials

Certifications &
Credentials

Click any certificate to view it in full. 11 certifications earned across data analytics, Python, SQL, Power BI, and generative AI.

Excel Basics for Data Analysis
View ↗
IBM · Coursera
Excel Basics for Data Analysis
Nov 2025
Data Visualization with Excel and Cognos
View ↗
IBM · Coursera
Data Visualization & Dashboards — Excel & Cognos
Nov 2025
Databases and SQL for Data Science with Python
View ↗
IBM · Coursera
Databases & SQL for Data Science with Python
Nov 2025
Data Analysis with Python
View ↗
IBM · Coursera
Data Analysis with Python
Nov 2025
Data Visualization with Python
View ↗
IBM · Coursera
Data Visualization with Python
Nov 2025
Python for Data Science AI and Development
View ↗
IBM · Coursera
Python for Data Science, AI & Development
Nov 2025
Generative AI Enhance your Data Analytics Career
View ↗
IBM · Coursera
Generative AI: Enhance your Data Analytics Career
Nov 2025
Power BI 7-Hours Free Course
View ↗
Skill Course · Learn More Pro
Power BI 7-Hours Free Course
Aug 2025 · Satish Dhawale
GenAI Powered Data Analysis Tata Forage
View ↗
TATA Group · Forage
GenAI Powered Data Analytics Job Simulation
Aug 2025
Quantium Data Analytics Job Simulation
View ↗
Quantium · Forage
Data Analytics Job Simulation
Jun 2026
✦ Get In Touch

Let's Connect and Build Something Meaningful Together

I'm actively seeking opportunities in Data Analytics and Business Intelligence. Whether you have a role, a project, or just want to talk data — I'd love to hear from you.

Email Me Directly Connect on LinkedIn