Available for opportunities

Yash
Malviya

Data Analyst crafting end-to-end analytics pipelines, dimensional models, and dashboards that turn 200K+ rows into decisions that matter.

View Projects Get in Touch
Yash Malviya
200K+
Rows Processed
20+
SQL Analyses
$109M+
Revenue Analysed
6
Live Dashboards
01

About

I have completed my B.Tech in Artificial Intelligence & Data Science from Prestige Institute of Engineering Management & Research, with a CGPA of 7.33/10.

My craft is the full analytics lifecycle — raw ingestion, PostgreSQL star schemas, complex SQL with window functions, and executive Tableau dashboards built to answer real business questions.

I care about precision over noise. Every pipeline I build, every query I write starts with a concrete question. No vanity metrics, no fluff charts.

Currently seeking full-time Data Analyst roles — open to opportunities across India, global, or remote.

Languages & Databases

PythonSQLPostgreSQL

Analysis

EDACohort AnalysisKPI AnalysisCLV ModellingCustomer Segmentation

Visualisation & BI

TableauMatplotlibSeaborn

Tools

PandasNumPySQLAlchemyJupyterDockerGitExcel
02

Experience

Oasis Infobyte Data Analyst Intern
Jul 2024 – Aug 2024

Data Analyst Intern

  • Performed EDA on retail and customer datasets using Python, Pandas, Matplotlib, and Seaborn — identified sales trends and seasonal demand patterns.
  • Cleaned and preprocessed datasets (missing values, duplicates, inconsistencies); built KPI reports tracking revenue, customer insights, and product performance.
  • Conducted statistical and trend analysis using end-to-end Jupyter Notebook workflows to support data-driven business recommendations.
Prestige IEMR B.Tech Student
Dec 2021 – Dec 2025

B.Tech — AI & Data Science

  • Built two end-to-end retail analytics pipelines (AdventureWorks & Contoso) processing 200K+ rows, complete with star-schema modelling in PostgreSQL.
  • Designed 20+ SQL analyses using CTEs and window functions — cohort retention, CLV, territory performance, holiday profitability.
  • CGPA: 7.33 / 10
03

Projects

Project 01

Adventure Works
End-to-End Analytics

Full analytics pipeline on AdventureWorks — ingestion, feature engineering, star-schema modelling in PostgreSQL, and 3 executive Tableau dashboards covering territory performance, product mix, and sales channel breakdowns.

$109M+
Revenue
$9.37M+
Profit
~73%
Offline share
View Repository
Project 02

End-to-End Customer
Revenue Analysis

Processed 200K+ sales transactions, designed a 5-table star schema with 104K customers and 2.5K products. Built cohort analysis tracking 24-month retention, CLV rankings, profitability trends, and 3 Tableau dashboards with 20+ drill-down visualisations.

200K+
Transactions
104K
Customers
24-mo
Cohorts
View Repository
04

Key Achievements

Built 2 end-to-end retail analytics pipelines (200K+ rows each) with full ingestion, feature engineering, and star-schema modelling in PostgreSQL using Python and SQLAlchemy.

Designed 20+ SQL analyses — cohort retention, CLV, territory performance, holiday profitability — using CTEs and advanced window functions.

Identified Australia as top-profit region ($3.43M) and Bikes as top category ($94.65M revenue) across $109.85M total analysed revenue.

Delivered 6 executive Tableau dashboards with KPI cards, geographic maps, treemaps, and 20+ drill-down visualisations across two projects.

Let's make data
mean something.

Open to full-time Data Analyst roles — India, global & remote.

yashmalviya0011@gmail.com LinkedIn GitHub +91 82259 66630
Send a Message

© 2025 Yash Malviya · Designed with intent