Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Generic

Sonam Agrawal

RWE Data Analyst
Bengaluru

Summary

Dynamic Data Analyst and Consultant with a proven track record at IQVIA and Mu Sigma in delivering patient analytics solutions and enhancing pharmaceutical data utility. Excelled in team management and client relations, leveraging Python and critical thinking to drive project success. Mentored junior consultants, ensuring quality and innovative problem-solving.

Overview

10
10
years of professional experience

Work History

RWE Data Analyst

Sanofi
Hyderabad
10.2022 - Current
  • Built T1DM dashboard using Power BI based on the patient Demographics, Comorbidities, Treatment,
    and other Auto-immune diseases along with Auto-Antibody tests to predict stages of T1D using Optum Claims Data
  • Actively delivered feasibility Analysis and RWE Literature search projects
  • Drug Persistency Analysis
  • Performed analysis of multiple data sources to verify continuity and incorporate findings into final weighting for decision-making processes
  • Exploration of Blood Eosinophil values for COPD and Asthma patients in different time intervals

Consultant

IQVIA
02.2020 - 10.2022
  • Worked as a Team Lead with 5-6 Analysts providing Patient Analytics solutions across various Therapeutic Areas in Belgium
  • Responsible for delivery, stakeholder management, quality assurance, training and resourcing
  • Managed client relationships through regular check-ins and evaluated client needs and expectations
  • Projects: Source of Business, Adherence Analysis (Persistence/Compliance), Line of Therapy, Indication Split, Patient Journey

Senior Consultant

Harman Connected Services
Bengaluru
05.2016 - 02.2020
  • Worked for a leading provider of U.S. Pharmaceutical data and helped to sell their extensive data to various stakeholders including Drug manufacturers, Insurance Companies, Investors, and retail Chains
  • Estimating physician universe for Sales force sizing projects
  • Patient Journey, line of therapy, Impact of Covid, Competitive Assessments
  • Mentored junior consultants, helping them enhance their skills and contribute more effectively to projects.
  • Prioritized projects and Troubleshot issues by understanding issue, diagnosing root cause and coming up with effective solutions.

Decision Scientist

Mu Sigma Business Solutions
11.2014 - 04.2016
  • Worked with Pharmaceutical Clients, participated in requirement gathering process, data analysis, team discussions, and drafting detailed methodology to solve the problem
  • Created end-to-end data visualization assets and tools to illustrate analytical findings for internal and external stakeholders.
  • Worked on Affiliations, HCP Behavior,
    Impact of copay cards, Reversals and Rejections, etc., tracking activities of sales force executives in excel dashboard

Education

Bachelor of Technology - Information Technology

National Institute of Technology, Raipur
Raipur, India
04.2001 -

Skills

Python

SQL

SAS

Excel

Tableau

Datasets - Optum Claims, EMR, APLD, LRx, LPD, Xponent data

Therapy areas – Diabetes, Respiratory diseases, Oncology and Cardiovascular Diseases

Problem-Solving

Team Management

Client Management

Critical Thinking

Additional Information

AWARDS AND ACHIEVEMENTS

▪ Sanofi - The Extra Mile Reward & Recognition Stakeholder Engagement Champion in February 2023 - Substantial

contribution to the Protocol Visualization tool in different domains as per the stakeholder expectations

▪ IQVIA BRONZE AWARD - IQVIA IMPACT PROGRAM - POC opened avenues for new types of projects that will add to the CoE's capability in the future.

▪ IQVIA OVATION AWARD – Demonstrating a high learning curve and contributing to delivering high-value client outputs

Timeline

RWE Data Analyst

Sanofi
10.2022 - Current

Consultant

IQVIA
02.2020 - 10.2022

Senior Consultant

Harman Connected Services
05.2016 - 02.2020

Decision Scientist

Mu Sigma Business Solutions
11.2014 - 04.2016

Bachelor of Technology - Information Technology

National Institute of Technology, Raipur
04.2001 -
Sonam AgrawalRWE Data Analyst