rohanprad09@gmail.com

Hi, my name is

Rohan Pradhan.

I turn data into decisions.

I’m a data analyst in London. Give me a business question and the data behind it, and I’ll come back with a clear answer you can trust. I’m currently doing that at Reiss.

About me

I started out in Computer Science at the University of Delhi, then moved to the UK for an MSc in Artificial Intelligence, where I focused on data analysis, machine learning and experimental design.

Since then I’ve worked on the business side of data, from my first analytics role at Starbucks EMEA to owning the reporting that department heads at Reiss rely on every week. My favourite part is when messy data turns into a clear answer someone can act on.

Here are the tools I use most:

  • SQL
  • Google BigQuery
  • Power BI & DAX
  • Power Query
  • Python (pandas)
  • Excel
  • Alteryx
  • PowerShell & VBA
Rohan Pradhan

MSc Artificial Intelligence

Royal Holloway, University of London · 2022–23

Data Analysis, Machine Learning, Experimental Design.

BSc (Hons) Computer Science

University of Delhi · 2018–21

Database Management Systems, Introduction to Data Science.

Where I’ve worked

Business Applications Support Analyst @ Reiss

Apr 2024 – Present · London
  • Own the build and upkeep of 20+ business-critical reports, working directly with department heads on what they need to decide.
  • Built Power BI dashboards that reconcile sales and stock across platforms, tracing discrepancies back to their root cause.
  • Automated recurring reports and alerts with PowerShell, VBA and Batch, saving 10+ hours a week.
  • Tuned SQL queries to run 30% faster and streamlined data prep with Alteryx.

Things I’ve built

Power BI dashboard recommending 2,122 H&M lines for markdown

Featured project

Which H&M lines should we mark down, and how deep?

Using 31.8 million real H&M transactions, I learnt from 19,668 past markdowns which discount depth actually works, comparing each against similar products still at full price.

30–50% cuts grew revenue by 45%; shallow cuts barely beat doing nothing. The dashboard flags 2,122 slow lines to mark down now.

  • SQL
  • BigQuery
  • Power BI
  • DAX

04. What’s next?

Get in touch

I’m open to Data Analyst roles in London. Whether you have a role in mind or just want to talk data, my inbox is open.

Say hello