Amazon logoAmazon Externship via Extern·🟢 Open to work
Syed Taha Ahmad portrait

Early-career designer and product thinker

I build portfolio projects that show my design thinking, visual work, and product interest as I prepare to start my career.

View my workAbout me

Work samples

A selection of portfolio pieces and practice projects that reveal my process, visual work, and product thinking as I build experience.

  • Amazon Operational Strategy & People Analytics Externship
    Amazon Operational Strategy & People Analytics Externship
    Amazon logo

    Amazon · ✅ 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
  • Dubai Real Estate Analysis
    Dubai Real Estate Analysis

    Cleaned and transformed 93K+ Dubai property transactions (Jan 2020 – Apr 2026) in Power Query and Excel, engineering price-per-sqft and rental-yield fields. Built a 4-page Power BI dashboard covering market trends, pricing and yield, fastest-growing areas, and off-plan developer activity, using Key Influencers to identify location price drivers. Found an inverse price 6yield relationship: communities like Sustainable City and Dubai South returned ~10%+ gross yields against an 8.25% average, while off-plan averaged ~$700/sqft vs ~$508 for secondary.

    Power BIPower QueryExcel

About me

I build portfolio projects that show my design thinking, visual work, and product interest as I prepare to start my career.

I am Syed Taha Ahmad, an early-career creative exploring design and product work. I have limited formal work experience and am preparing to start my professional career, building skills and portfolio pieces to show what I can do.

Externships

Amazon Operational Strategy & People Analytics Externship

In progress

Experience

Operational Strategy & People Analytics Extern

Extern (Amazon-sponsored externship) · Sep 2026 – Present

Education

Allenhouse Institute of Technology (affiliated with AKTU), Uttar Pradesh, India

B.Tech, Computer Science & Engineering · Class of 2025

Skills

Design thinkingVisual designProduct thinkingPortfolio developmentLearning and experimentation
Back to work
Amazon ↗

✅ 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 examined retention challenges in Amazon fulfillment centers by collecting and analyzing employee reviews and operational context. The work combined web-scraped employee feedback with operational research to surface patterns in early-tenure exits and to inform persona-driven strategies. Deliverables included analyzed review data, synthesized insights, and candidate personas.

Amazon Operational Strategy & People Analytics Externship

What I've accomplished

I produced a role-by-role workforce spreadsheet that listed each position, main responsibilities, close collaborators, common tools, and explanatory notes.

Project breakdown

Situation: the externship asked for a workforce map at an AFC. Task: catalog roles and their responsibilities. Action: compiled a spreadsheet listing roles, main responsibilities, who they work closely with, common tools, and notes. Result: produced a clean role-by-role workforce structure showing…

Google Sheets
Access

I gathered Glassdoor reviews and YouTube transcripts, cleaned encoding and label inconsistencies, removed empty/duplicate columns and rows, added tone and topic columns for videos, and exported final CSVs ready for analysis.

Google Drive
Access

I cleaned and combined Glassdoor and YouTube text, scored sentiment with TextBlob, generated unigram/bigram/trigram charts and word clouds, and reported that Glassdoor leaned positive on pay while YouTube emphasized breaks, long shifts and physical strain.

Google Docs
Access
View all work
Back to work

Dubai Real Estate Analysis

Cleaned and transformed 93K+ Dubai property transactions (Jan 2020 – Apr 2026) in Power Query and Excel, engineering price-per-sqft and rental-yield fields. Built a 4-page Power BI dashboard covering market trends, pricing and yield, fastest-growing areas, and off-plan developer activity, using Key Influencers to identify location price drivers. Found an inverse price 6yield relationship: communities like Sustainable City and Dubai South returned ~10%+ gross yields against an 8.25% average, while off-plan averaged ~$700/sqft vs ~$508 for secondary.

Power BIPower QueryExcel
View all work
Back to work

Airbnb Market Analysis

Cleaned 279K+ listings and 5.37M reviews in MySQL, handling NULLs, standardizing 662 inconsistent host-location values, and engineering an amenity-count field. Built a Power BI semantic model and used Key Influencers analysis to identify cleanliness (+13.3 pts), accuracy (+13.3 pts), and communication (+11.0 pts) as the strongest drivers of review score. Found guest satisfaction tracked with amenity count and service quality rather than price tier.

MySQLPower BI
View all work
Back to work

Google Fiber Repeat Call Analysis

Combined 3 market datasets in BigQuery and ran data quality checks, resolving nulls, duplicates, and inconsistent problem-type labels to produce one analysis-ready table. Documented stakeholder requirements, project requirements, and a dashboard strategy, then designed a low-fidelity mockup before building an interactive Power BI dashboard with market, problem-type, and time-period filters. Found 20K repeat calls from 65K initial contacts (~31%), with Market 1 driving ~63% of them, mainly Internet & Wi-Fi issues; recommended prioritizing first-contact-resolution training there.

BigQuerySQLPower QueryPower BI
View all work