Headline

Data Analyst | Excel · SQL · Power BI | 3 Projects · 55K+ Rows Analyzed | Open to Internships

About

I'm a self-taught Data Analyst (BBA background, UTU Dehradun) who has spent the last 8 months building real projects not toy datasets, not tutorials. Projects: Here's what I've actually done: 📊 Global Superstore Analysis — 51,290 rows across 3 PostgreSQL tables. Full pipeline: Excel cleaning → SQL analysis → Power BI dashboard. Key finding: 24.45% of orders were loss-making due to excessive discounting a finding that directly maps to a pricing strategy decision. 🏥 Healthcare Analytics — 54,966-row Kaggle dataset. SQL queries, Excel pivot tables, visual summaries of patient admission trends. 📦 Hospital Data Analysis- Executed end-to-end data cleaning, pivot-table analysis, and SQL querying to extract admission trends and surface departmental bottlenecks. All projects are documented on GitHub with business context, not just code. Tools: Excel (VLOOKUP, Power Query, Pivot Tables) · SQL / PostgreSQL (Joins, Subqueries, Window Functions) · Power BI (DAX, Dashboards) · Google Data Analytics Certificate — 4 of 8 complete My BBA background isn't a limitation. It means I understand the business question before I touch the data. 📩 rupesh.dataanalyst@gmail.com 🔗 github.com/rupesh-gupta-data Open to Data Analyst internships remote or on-site, anywhere in India

Location

Dehradun

Work experience

Data Analytics Project Portfolio at Independent, Oct 2024 - Present · 1 yr 9 mos, •Designed end-to-end analytics pipelines for 3 datasets totaling 160,000+ rows from raw data ingestion to business-ready dashboards in Power BI. •Identified that 24.45% of retail orders were loss-making due to discounting patterns; quantified impact across 3 product categories using SQL window functions. •Wrote recruiter-readable GitHub READMEs documenting methodology, tools, and business recommendations for each project

Education

Bachelor of Business Administration - BBA, Veer Madho Singh Bhandari Uttarakhand Technical University (UTU)

XII and X, Business/Commerce, General, Doon Cambridge School