Vivek Rathod
Aarav was twenty-six, freshly minted from a data analytics program in Wichita, Kansas, with a dog-eared textbook and a rolling trolley that kept falling sideways on the Amtrak to Penn Station. He had been hired by a pharma consulting firm in Midtown Manhattan to support the launch analytics for RIX - a new oncology drug targeting EGFR-mutant non-small cell lung cancer.What followed was equal parts data science crash course and comedy of errors, narrated by two warring internal voices: Spreadsheet Aarav - who wants to explain exactly why the ENROLLMENT table loses 34% of patients at Step 3 - and Consulting Aarav - who wants to call it 'a focused coverage footprint with significant pull-through opportunity' and move on to the next slide.Claims, Cohorts & Consulting Chaos is the book nobody wrote for people entering US pharma analytics. Unlike other analytics books that present methodology in isolation, this one explains complex US patient claims data in a storytelling format - every framework is industry-proven, every concept is anchored in a real-world oncology drug launch, and every technical idea is narrated by characters you will recognise from your own career. It covers patient claims data, SQL cohort building, PDC adherence, lines of therapy, and Sankey treatment flow - all through the lens of a fictional oncology launch and the very real tension between analytical rigour and consulting communication.
