Pfizer logoPfizer Externship via Extern
Dia Khatter portrait

Junior Data Analyst with a Passion for Insights

I leverage my Statistics background to uncover insights and drive impactful decisions in data analytics.

View my workMessage Me

Work samples

Explore my work in Data Analytics, where I tackle real-world problems and apply statistical methods to derive insights.

  • BeReal Product Management Externship
    BeReal Product Management Externship
    BeReal. logo

    BeReal. · Aug 2026 · ✅ Verified by Extern

    BeReal Product Management Externship

    Discover how product teams at social apps like BeReal design for authenticity while driving user growth. In this externship, you’ll explore what keeps users coming back— benchmarking competitors, analyzing engagement features, and designing your own growth-driven app feature. You’ll learn how to balance product innovation with BeReal’s unique mission of real, unfiltered connection. Perfect for those interested in product management, UX strategy, or social media innovation, this experience gives you a hands-on look at how product teams grow platforms without losing their core values.

    Top performerDesignUI/UXProduct Management
  • Customer Segmentation using RFM Analysis
    Customer Segmentation using RFM Analysis

    Built an end-to-end customer analytics pipeline using pandas — including data cleaning, deriving Total_Amt, datetime transformation, and grouped aggregation by Customer ID. Segmented customers into 5 business-ready groups (VIP/Loyal, Potential Loyal, At Risk, Can't Lose, Lost) and visualised distribution and score profiles using matplotlib, seaborn, and Plotly (bar charts, treemap, box plots, heatmap)

    pandasNumPyMatplotlibSeabornPlotly

About me

I leverage my Statistics background to uncover insights and drive impactful decisions in data analytics.

As a junior studying Statistics, I am passionate about Data Analytics and its power to drive decision-making. Currently, I am gaining hands-on experience as a Product Management Extern at BeReal, where I apply my analytical skills to real-world challenges and contribute to innovative solutions.

Externships

Pfizer Advanced: AI-Powered Document Insights & Data Extraction Externship

In progress

Experience

Product Management Extern

Extern-BeReal · June 2026- Present

Intern

Ministry of Statistics and Program Implementation, GOI · December 2025-February 2026

Growth and Analytics Power BI Intern

Frost and Sullivan · June - September 2025

Research and Data Analyst Intern

Institute of Economic Growth · January- February 2025

Education

Ramjas College, University of Delhi

Bachelor of Science in Statistics (Honors) · Class of 2026

Skills

Data AnalyticsStatisticsProduct Management
Back to work
BeReal. · Aug 2026 ↗

✅ Verified by Extern

BeReal Product Management Externship

Discover how product teams at social apps like BeReal design for authenticity while driving user growth. In this externship, you’ll explore what keeps users coming back— benchmarking competitors, analyzing engagement features, and designing your own growth-driven app feature. You’ll learn how to balance product innovation with BeReal’s unique mission of real, unfiltered connection. Perfect for those interested in product management, UX strategy, or social media innovation, this experience gives you a hands-on look at how product teams grow platforms without losing their core values.

DesignUI/UXProduct Management

Overview

The work mapped BeReal's five-stage user journey, benchmarked core engagement features against competitors, designed a PRD-lite for a Best Friend Streaks feature, and tested the prototype in virtual focus groups, recording usability and intent metrics. The work was awarded Top Performer by BeReal.

BeReal Product Management Externship
Google Docs
Access

What I've accomplished

I produced a five-stage journey map with actions, thoughts, feelings, and documented frustrations; a competitor-feature benchmark linking mechanics to engagement; a PRD-lite for Best Friend Streaks including a private two-person streak flow and acceptance criteria; and focus-group findings plus prototype metrics.

Top performer

Project breakdown

View all work
Back to work

Customer Segmentation using RFM Analysis

Built an end-to-end customer analytics pipeline using pandas — including data cleaning, deriving Total_Amt, datetime transformation, and grouped aggregation by Customer ID. Segmented customers into 5 business-ready groups (VIP/Loyal, Potential Loyal, At Risk, Can't Lose, Lost) and visualised distribution and score profiles using matplotlib, seaborn, and Plotly (bar charts, treemap, box plots, heatmap)

pandasNumPyMatplotlibSeabornPlotly
View all work
Back to work
Pfizer ↗

✅ Verified by Extern · ⏱️ In progress

Pfizer Advanced: AI-Powered Document Insights & Data Extraction Externship

Prototype AI-powered document intelligence with Pfizer—using OCR, LLMs, and RAG to automate real enterprise PDF workflows and build a standout portfolio project.

AI & MLPythonDocument IntelligencePresentation Skills

Overview

The externship explored methods for extracting and summarizing information from enterprise PDFs using OCR, LLMs, and retrieval-augmented generation. Work included research into model architectures and pipeline components and producing prototypes that combined text extraction with LLM-based interpretation.

Pfizer Advanced: AI-Powered Document Insights & Data Extraction Externship

What I've accomplished

I researched foundational concepts and practical mechanisms behind large language models, then documented how those components fit into an AI document-intelligence pipeline.

Project breakdown

View all work