ARCeH logoARCeH Externship via Extern
Rajan Gupta portrait

I am Rajan Gupta, an early-career professional

Starting my career, learning core skills and preparing to take on practical work and entry-level roles.

🟢 Open to work

Work samples

A collection of learning projects and early practical work that demonstrate developing skills and readiness for entry-level roles.

  • Data Analytics, Health Outcomes Externship with ARCeH
    Data Analytics, Health Outcomes Externship with ARCeH
    ARCeH logo

    ARCeH · ✅ Verified by Extern · ⏱️ In progress

    Data Analytics, Health Outcomes Externship with ARCeH

    Here’s what the data says: put a pin in Bangkok. Draw a five-hour flight radius around it. You just circled half the world's population. And half of those people are kids under five, an age where survival itself isn't guaranteed. Five isn't an arbitrary number: it's the line researchers use as a proxy for a country's overall health, because almost every preventable childhood death, driven by a bad water source, poor air quality, or an infection nobody caught in time, happens before it. Clear five, and the odds of reaching adulthood jump astronomically. Don't, and the cause almost always traces back to poverty, healthcare access, environmental risk, or nutrition, something that could have been mapped, measured, and prevented in time. That's the gap this externship exists to close: turning scattered, messy public data into a specific, defensible answer about what's actually driving that risk in a given place, and pass it to the people at ARCeH who want to know about it.

    Data AnalysisData VisualizationData Storytelling
  • World Cup EDA Analysis
    World Cup EDA Analysis
    World Cup EDA Analysis

    Performed exploratory data analysis on historical FIFA World Cup match data to study team performance, scoring patterns, tournament winners, and goal trends across years. Cleaned the dataset, handled missing values, and applied descriptive statistics and correlation analysis. Built bar charts, line

    PythonPandasNumPyMatplotlibSeabornJupyter Notebook

About me

Starting my career, learning core skills and preparing to take on practical work and entry-level roles.

I am Rajan Gupta, an early-career professional beginning my first steps toward a career. I am building skills, exploring roles, and preparing to contribute in a practical, hands-on role as opportunities arise.

Externships

Data Analytics, Health Outcomes Externship with ARCeH

In progress

Education

UpGrad Bhubaneswar, India

Certification in Data Science

Vyasanagar Autonomous College Jajpur Road, India

Bachelors in Commerce (Accounting & Finance Honours), 6.65/10.0 CGPA

Kanhu Charan Mahavidyalaya Jajpur Road, India

Class 12th Science Stream

St. Xavier’s High School – Senior Secondary Jajpur Road, India

Class 10th – Central Board of Secondary Education (CBSE)

Skills

Early-career, learning phaseData AnalyticsData Science

✅ Verified by Extern · ⏱️ In progress

Data Analytics, Health Outcomes Externship with ARCeH

Here’s what the data says: put a pin in Bangkok. Draw a five-hour flight radius around it. You just circled half the world's population. And half of those people are kids under five, an age where survival itself isn't guaranteed. Five isn't an arbitrary number: it's the line researchers use as a proxy for a country's overall health, because almost every preventable childhood death, driven by a bad water source, poor air quality, or an infection nobody caught in time, happens before it. Clear five, and the odds of reaching adulthood jump astronomically. Don't, and the cause almost always traces back to poverty, healthcare access, environmental risk, or nutrition, something that could have been mapped, measured, and prevented in time. That's the gap this externship exists to close: turning scattered, messy public data into a specific, defensible answer about what's actually driving that risk in a given place, and pass it to the people at ARCeH who want to know about it.

Data AnalysisData VisualizationData Storytelling

Overview

The externship worked with public health datasets to locate and quantify drivers of under-five mortality within the ARCeH regional scope. The work surveyed available data sources, clarified analytic limits of correlation versus causation, and produced a conceptual foundation for subsequent quantitative analysis.

Data Analytics, Health Outcomes Externship with ARCeH

What I've accomplished

I selected a topic (child asthma and air pollution), located county-year asthma emergency department rates and EPA PM2.5 summaries, applied a dataset fitness checklist, and produced a joined, documented dataset noting that the outcome file covered only 2012.

Project breakdown

I defined a topic (child asthma and air pollution), found county-year asthma ED rates and EPA PM2.5 summaries, applied a fitness checklist, and reported joins, variable types, and a conditional verdict noting the outcome file covered only 2012.

View all work

World Cup EDA Analysis

Performed exploratory data analysis on historical FIFA World Cup match data to study team performance, scoring patterns, tournament winners, and goal trends across years. Cleaned the dataset, handled missing values, and applied descriptive statistics and correlation analysis. Built bar charts, line

PythonPandasNumPyMatplotlibSeabornJupyter Notebook

Overview

World Cup EDA Analysis
View all work

Adidas Quarterly Sales EDA

Performed exploratory data analysis in Python on Adidas quarterly sales data to identify sales trends and performance patterns. Cleaned and prepared the data, then visualized results to support business insights.

PythonPandasNumPyMatplotlibJupyter Notebook

Overview

Adidas Quarterly Sales EDA
View all work

Power BI Dashboard Projects (Retail Sales & IT Services)

Developed a Power BI dashboard using DAX and data modeling to analyze retail sales, profit, customer segments, product categories, and supplier performance. Built a Power BI dashboard for an IT services dataset to track project performance, client revenue, project status, team efficiency, and key bu

Power BIDAXPower QueryData Modeling

Overview

Power BI Dashboard Projects (Retail Sales & IT Services)
View all work

SQL Project on Metro Transit Database System

Designed a MySQL database with an ER diagram to manage stations, routes, trains, passengers, tickets, schedules, payments, and trips. Wrote SQL queries using joins, subqueries, CTEs, window functions, and views to analyze station usage, route performance, ticket revenue, and peak travel hours.

SQLMySQLMySQL WorkbenchDatabase DesignData Analysis

Overview

SQL Project on Metro Transit Database System
View all work

SQL Project | NexusArena Esports SQL Database

Developed a SQL-based esports league database to manage teams, players, matches, tournaments, and performance statistics. Wrote SQL queries to enable data-driven analysis of competitive gaming performance.

SQLMySQLDatabase DesignData Analysis

Overview

SQL Project | NexusArena Esports SQL Database
View all work