Amazon logoCurrently an Extern @Amazon
Tyler Lin portrait

Aspiring IT Professional

I'm a sophomore at UConn, eager to build my skills in Information Technology and analytics.

View my workMessage Me

Work samples

Explore my journey through academic projects and an externship at Amazon, where I am developing crucial IT skills.

  • 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
  • Resident Assistant Floor Management Database
    Resident Assistant Floor Management Database

    Designed and implemented a relational SQLite database managing resident, event, and incident data for 60+ students, replacing manual spreadsheet lookups Wrote SQL queries and Excel reports that automated participation summaries and recurring incident analysis, reducing monthly administrative reporting effort

    SQLSQLiteExcel

About me

I'm a sophomore at UConn, eager to build my skills in Information Technology and analytics.

I am a sophomore at the University of Connecticut, pursuing a Bachelor's Degree in Information Technology. Currently, I am enhancing my skills through an externship at Amazon, where I'm focused on operational strategy and people analytics.

Externships

Amazon Operational Strategy & People Analytics Externship

Amazon

Experience

Resident Assistant

University of Connecticut Residential Life · August ‘25 – Present

Operational Strategy & People Analytics Extern

Amazon (via Extern) · June ’26 – Present

Education

University of Connecticut - School of Business

Bachelor of Science: Analytics & Information Management · Class of 2028

Skills

Information TechnologyData AnalyticsOperational StrategyPeople Analytics
Back to works
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 work mapped frontline and support roles and prepared employee-voice sources for analysis. It converted unstructured YouTube transcripts and Glassdoor summaries into cleaned datasets, extracted keywords and sentiment scores, and tagged reviews to themes. The deliverables included a workforce network spreadsheet, a cleaned video-review dataset, combined keyword and sentiment analyses, 69

Amazon Operational Strategy & People Analytics Externship

What I've accomplished

I produced a structured workforce network spreadsheet, a cleaned dataset of worker video reviews, combined keyword and sentiment analyses from Glassdoor and YouTube, 69 theme-tagged Glassdoor reviews from 149 cleaned rows, and a ranked segmentation that prioritized Specialized Physical Roles.

Project breakdown

During the AFC mapping task I listed frontline and support roles, recorded main responsibilities, who each role worked closely with, common tools, and why each role mattered. The submission produced a structured spreadsheet of the workforce network.

Google Sheets
Access

Situation: raw YouTube videos and transcripts were unstructured. Task: collect and convert video reviews into analyzable rows. Action: extracted transcripts, cleaned text, added titles and metadata, and compiled a spreadsheet. Result: a cleaned, structured dataset of worker video reviews.

Google Sheets
Access

A mixed dataset of Glassdoor summaries and YouTube transcripts was combined and cleaned, keywords and trigrams were extracted, and sentiment and subjectivity scores were computed. The analysis found shared themes (physical strain, long shifts, limited breaks) and showed that YouTube sentiment…

Google Docs
Access

Situation: public reviews showed recurring complaints. Task: tag reviews to three themes. Action: ran Python keyword-based tagging on 149 cleaned Glassdoor rows. Result: 69 reviews matched the defined themes.

Open Link

Faced with survey and categorical data, I grouped employees into five segments, measured friction frequency across themes, and scored each segment on impact, severity, and size. I produced a ranked list showing Specialized Physical Roles as the top priority.

Google Sheets
Access
View all works
Back to works

Resident Assistant Floor Management Database

Designed and implemented a relational SQLite database managing resident, event, and incident data for 60+ students, replacing manual spreadsheet lookups Wrote SQL queries and Excel reports that automated participation summaries and recurring incident analysis, reducing monthly administrative reporting effort

SQLSQLiteExcel
View all works