Amazon logoAmazon Externship via Extern
Omer Ahmad Sayed portrait

Computer Science graduate student exploring operations and people analytics

Graduate CS student who completed an Amazon Operational Strategy & People Analytics externship, seeking connections and early career opportunities.

Work samples

Portfolio includes work completed during the Amazon Operational Strategy & People Analytics externship and related coursework, showing practical steps toward operations and analytics work.

  • TAILWIND TRADERS SALES & PROFIT ANALYTICS DASHBOARD
    TAILWIND TRADERS SALES & PROFIT ANALYTICS DASHBOARD

    Developed DAX measures, engineered a multi-page Power BI Executive Dashboard with executive KPIs, built a star-schema data model integrating 6 datasets and automated multi-currency conversion, and delivered interactive dashboards with drill-down analysis and executive visualisations for cross-country financial reporting.

    Power BIPower QueryDAXPython
  • COVID-19 VACCINATION ANALYTICS USING AWS QUICKSIGHT
    COVID-19 VACCINATION ANALYTICS USING AWS QUICKSIGHT

    Architected a cloud-based analytics solution integrating Amazon S3, AWS Glue, PostgreSQL (Amazon RDS), and AWS QuickSight; optimised ETL of vaccination records using Python; and designed interactive AWS QuickSight dashboards to visualise vaccination trends and KPIs.

    Amazon S3AWS GluePostgreSQLPythonETL

About me

Graduate CS student who completed an Amazon Operational Strategy & People Analytics externship, seeking connections and early career opportunities.

I am Omer Ahmad Sayed, a graduate Computer Science student working toward my bachelors degree. I have limited professional experience and am focused on building relationships and expanding my professional network. I completed an Amazon Operational Strategy & People Analytics externship.

Externships

Amazon Operational Strategy & People Analytics Externship

In progress

Education

Allenhouse Institute of Technology, Uttar Pradesh, India

Bachelor of Technology - Computer Science & Engineering · Class of 2025

Skills

Computer Science fundamentalsOperational strategy conceptsPeople analytics conceptsProject-based learningNetworking and professional relationship building

TAILWIND TRADERS SALES & PROFIT ANALYTICS DASHBOARD

Developed DAX measures, engineered a multi-page Power BI Executive Dashboard with executive KPIs, built a star-schema data model integrating 6 datasets and automated multi-currency conversion, and delivered interactive dashboards with drill-down analysis and executive visualisations for cross-country financial reporting.

Power BIPower QueryDAXPython
View all work

COVID-19 VACCINATION ANALYTICS USING AWS QUICKSIGHT

Architected a cloud-based analytics solution integrating Amazon S3, AWS Glue, PostgreSQL (Amazon RDS), and AWS QuickSight; optimised ETL of vaccination records using Python; and designed interactive AWS QuickSight dashboards to visualise vaccination trends and KPIs.

Amazon S3AWS GluePostgreSQLPythonETL
View all work

BELLABEAT FITNESS CASE STUDY

Interrogated Fitbit activity records using SQL and Microsoft Excel to evaluate user engagement, activity trends, calorie expenditure, and sleep performance; performed data cleaning, EDA, and statistical analysis; and produced executive-ready reports with business recommendations.

TableauSQLMicrosoft Excel
View all work

CYCLISTIC BIKE SHARE CASE STUDY

Examined bike-share transactions using R and Power BI to evaluate customer behaviour, usage trends, and membership patterns; conducted customer segmentation and built dynamic Power BI dashboards delivering strategic recommendations.

RPower BI
View all work

✅ Verified by Extern · ⏱️ In progress

Amazon Operational Strategy & People Analytics Externship

Imagine shaping how AMAZON — yes, THE Amazon — welcomes and keeps its workforce. Every year, Amazon loses billions because new hires leave before Day 90. You’re going to fix that. In this externship, you’ll web scrape real-world employee reviews from across the web, extract actionable insights, and design persona-driven strategies to help Learning Ambassadors connect smarter, faster, and more humanely. It’s part research, part strategy—and all about learning how people data drives big decisions.

Data AnalysisPythonStrategyOperations

Overview

The externship combined operational strategy and people analytics to investigate early-career attrition at Amazon fulfillment centers. The work gathered and analyzed employee feedback sources, extracted patterns across roles and tenure, and translated those patterns into persona-driven recommendations. Deliverables included scraped review datasets, coded thematic findings, and candidate personas.

Amazon Operational Strategy & People Analytics Externship

What I've accomplished

I produced a structured workforce table that listed FC roles, reporting links, responsibilities, and tools used for Learning Ambassadors, pickers, packers, stowers, managers, technicians, and support roles.

Project breakdown

The project mapped FC roles and reporting links, listed responsibilities, tools used, and why each role mattered. I produced a structured workforce table covering Learning Ambassadors, pickers, packers, stowers, managers, technicians, and support roles.

Google Sheets
Access

I collected 10 public YouTube videos, extracted or linked transcripts, cleaned noisy text, and added columns for video title, tone, topic and metadata. The finished sheet produced a CSV-ready dataset of worker feedback for analysis.

Google Sheets
Access

I cleaned raw Glassdoor and YouTube text, generated keyword charts and word clouds, added sentiment scores with polarity labels, and combined both datasets to compare trends. The analysis found long, tiring shifts as a shared theme and showed Glassdoor reviews were more opinionated while YouTube…

Google Docs
Access
View all work