Agam Jeswani
Gurgaon
Summary
Senior Analyst with approximately 2 years of experience in commercial and claims analytics across Oncology, Dermatology, and Immunology. Highly competitive and passionate about driving results, and expertise in SAS, Python, SQL, and Excel.
Overview
2
2
years of professional experience
Work History
Senior Analyst
ProcDNA
Gurgaon
07.2025 - Current
- Led the analytics workstream for a top-10 pharma client in dermatology and immunology, owning multiple processes end-to-end, and serving as the primary contact for claims analytics.
- Built a comprehensive claims analytics framework covering patient, provider, and payer data, enabling client self-service for ad-hoc analyses, and achieving approximately 75% time and cost savings.
- Drove client engagement, leading calls, presenting insights, and participating in on-site visits to support strategic decision-making.
- Mentored junior analysts on claims analytics, Excel, and SQL, managed multiple projects, and led an internal Competitive Intelligence initiative.
Business Analyst
ProcDNA
Gurgaon
07.2024 - 06.2025
- Supported a commercial strategy for oncology rare disease clients with patient- and prescriber-level analytics using claims, sales, shipment, and call activity data, focusing on LoT, DoT, and prescriber engagement.
- Built and automated end-to-end analytical workflows in SAS and Excel, reducing manual effort, and achieving approximately 50% cost savings.
- Developed a fully automated SAS operational pipeline from data ingestion to outputs; the pilot generated an estimated $1M in client revenue.
Education
Bachelor of Technology -
National Institute of Technology
Rourkela01.2024
Senior Secondary -
Central Board of Secondary Education
Gwalior01.2019
Secondary -
Central Board of Secondary Education
Gwalior01.2017
Skills
- Python programming
- SAS programming
- SQL programming
- Machine learning
- Advanced Excel
- MS PowerPoint
- Commercial analytics
- Claims analytics
- Data analysis and insights
- Data storytelling and communication
- Leadership and collaboration
- Analytical thinking
Publications
Research Paper on CO2 Sequestration, 09/24, Co-authored a published research study investigating the short-term effects of subcritical CO2 on the geomechanical and mineralogical properties of shale from the Barakar Formation. The study demonstrated how CO2 interaction alters shale integrity and enhances pore structures, contributing to the understanding of CO2 storage potential in unconventional reservoirs.
Positions Of Responsibility
- Literary Secretary, Minare, NIT Rourkela, 01/23, 03/23
- Mentor, Institute Counselling Service, NIT Rourkela, 01/22, Present
Websites
Timeline
Senior Analyst
ProcDNA
07.2025 - Current
Business Analyst
ProcDNA
07.2024 - 06.2025
Bachelor of Technology -
National Institute of Technology
Senior Secondary -
Central Board of Secondary Education
Secondary -
Central Board of Secondary Education