Salma Ansari portrait
Amazon Externship via Extern

Data Analyst

I'm a data analyst who bridges technical rigor with a science background, from lab research in CAR-T cell therapy to statistical modeling and dashboarding in SQL, Python, Power BI, and Tableau.

Work samples

Explore my work in healthcare data analytics, showcasing my projects and the skills I've developed during my externship.

  • SQL Healthcare Analytics Project
    SQL Healthcare Analytics Project

    Explored a 100,000+ record patient healthcare dataset in SQL, analyzing hospital quality and length-of-stay metrics to identify trends and reporting opportunities.

    SQL
  • SQL Financial Analysis Project
    SQL Financial Analysis Project

    Conducted comprehensive financial analysis using SQL to evaluate the global financial and accounting landscape for the World Bank dataset.

    SQL

About me

I'm a data analyst who bridges technical rigor with a science background, from lab research in CAR-T cell therapy to statistical modeling and dashboarding in SQL, Python, Power BI, and Tableau.

I am a recent graduate holding a Master’s degree, currently seeking to strengthen my resume and gain valuable experience in the healthcare analytics field. My externship at TruBridge has equipped me with foundational skills in data analytics, preparing me for future opportunities.

Externships

Amazon Operational Strategy & People Analytics Externship

In progress

Experience

Research Technician III

Center for Cell and Gene Therapy, Baylor College of Medicine · June 2015 6 July 2017

Customer Service Representative

Nationwide Credit, Inc. · August 2013 6 May 2015

Graduate Teaching Assistant

Binghamton University · May 2013 6 May 2015

Education

Western Governors University

Bachelor of Science, Data Analytics · Class of 2025

Binghamton University

Master of Arts, Biological Sciences · Class of 2014

Binghamton University

Bachelor of Science, Biological Sciences · Class of 2013

Data Career Jumpstart

Data Analytics Bootcamp Certificate (Online) · Class of 2026

Skills

Healthcare Data AnalyticsData AnalysisResume BuildingInternship Preparation

SQL Healthcare Analytics Project

Explored a 100,000+ record patient healthcare dataset in SQL, analyzing hospital quality and length-of-stay metrics to identify trends and reporting opportunities.

SQL
View all work

SQL Financial Analysis Project

Conducted comprehensive financial analysis using SQL to evaluate the global financial and accounting landscape for the World Bank dataset.

SQL
View all work

DoorDash Excel Project

Analyzed 2,000+ rows of customer behavioral data using VLOOKUPs, Pivot Tables, and charts in Excel to evaluate campaign performance and inform business decisions.

ExcelVLOOKUPPivot TablesCharts
View all work

Power BI Coursework & Applied Practice

Built dashboards and data models applying DAX measures (PARALLELPERIOD, TOTALYTD), Power Query transformations, date tables, and conditional formatting to turn raw data into actionable reporting.

Power BIDAXPower Query
View all work

Tableau Education Dashboard

Built an interactive dashboard covering 1,800+ Massachusetts school systems, enabling at-a-glance understanding of key performance metrics for stakeholders.

Tableau
View all work

Python Manufacturing EDA Project

Performed exploratory data analysis using Pandas, NumPy, and Matplotlib to troubleshoot a manufacturing process issue and surface data-driven insights.

PythonPandasNumPyMatplotlib
View all work

R People Analytics Project

Applied statistical modeling and machine learning in R to identify key factors driving employee attrition.

R
View all work

✅ Verified by Extern

SQL & Database Architecture Externship with Breaking Games

Turn six messy CSVs into an analytics database and a Q4 dashboard that drives real business decisions. SQL + Claude.

Analytics Database DesignData AnalysisSQL FundamentalsData Storytelling

Overview

The externship converted six raw CSV data sources into an analytics database and produced a Q4 dashboard. The work mapped data schemas, identified cleanliness and consistency issues, and defined the tables and relationships needed for reporting. Deliverables included the transformed database schema and a functioning Q4 dashboard.

SQL & Database Architecture Externship with Breaking Games
Google Drive
Access

What I've accomplished

I built an analytics-ready SQLite database from six CSVs, documented table contents and relationships, and produced SQL queries that returned key metrics including product count (99), ad spend ($37,200.94), top products, revenue leaders, and unique checkout counts.

Project breakdown

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 web scraping, people analytics, and operational-context research for Amazon fulfillment centers. The work analyzed employee reviews and operational literature, mapped common retention risk factors, and translated those findings into persona-based insights and recommended touchpoints. Deliverables included scraped review datasets, an analysis of turnover drivers, and

Amazon Operational Strategy & People Analytics Externship

What I've accomplished

I produced a tabular roster of fulfillment-center roles that documented responsibilities, common tools, and close collaborators, creating a structured workforce map used in subsequent turnover analysis.

Project breakdown

During the externship I compiled a workforce map for an Amazon Fulfillment Center. I listed roles (e.g., Learning Ambassador, Picker, Packer), their main responsibilities, who they worked with, common tools, and notes about why each role mattered.

Google Sheets
Access

The project loaded 141 Glassdoor reviews, identified and removed seven noninformative columns, cleaned column names and duplicates, and exported a final CSV with review_pros, review_cons, and transcript fields ready for analysis.

View all work