Hello!

I'm Jolie Tran

A Geospatial Data Analyst

Contact me My works

Hello!

I'm a geospatial data analyst based in Seattle, WA

Contact me My works

About Me

Jolie is currently a senior studying Geography: Data Science at the University of Washington. Upon graduation, she will have at least 1 year of experience with data analytics and web development.

Jolie has a passion in "cooking up" the data to create insightful dashboards that can inform authorities to create positive changes in her community, especially in the transportation sector, with the focus on road and safety analysis.

Resume

September 2021-March 2024

B.A. in Geography: Data Science

University of Washington

  • In-major GPA: 4.0.
  • Cumulative GPA: 3.94
  • Relevant Coursework: Data Structures and Algorithm, Database Management, Machine Learning, Web Development

June 2023-Present

GIS Analyst

Washington State Transportation Center (TRAC)

ORCAnalysis Dec 2023 - Present
  • Implemented robust methods in PostgreSQL to effectively rectify wrongly encoded stops within the ORCA data based on GTFS, ensuring data integrity and accuracy.
  • Created an interactive map interface and treemap/billboard dashboards, seamlessly integrated with ORCA data, providing a comprehensive visualization of ridership at each stop in adherence to the GTFS standard.
TDEI: OpenSidewalks June 2023 - Present
  • Developed a method for automating sidewalk attributes collection from State and City DOT and feed into the sidewalk data in OpenStreetMap (OSM) using PostgreSQL and PostGIS.
  • Designed sets of rules in SQL for handling data integration challenges from disparate sources, identifying poorly drawn segments, and generating missing OSM sidewalk networks.
  • Tested and fine-tuned queries across multiple neighborhoods in Seattle (WA), achieving an accuracy rate exceeding 90%. Established a baseline for scaling in Portland (OR) and Baltimore (MD).
  • Built a web interface with HTML, CSS, JavaScript, and Leaflet for transparent public review, fostering continuous enhancements in sidewalk data precision.

June 2023-August 2023

Social Media Research Intern

Humanistic Data Science Summer Institute (HDSSI) @ University of Washington

  • Collaborated with a multidisciplinary team to conduct a comprehensive analysis of social media conversations on Twitter, focusing on the influence of historical figures in political movements and historical events.
  • Analyzed an extensive dataset of 3 million tweets spanning from 2007 to 2023, applying advanced data processing techniques using Pandas and Dask libraries in Python. This efficient analysis revealed key trends and patterns.
  • Implemented a mixed-method research approach, combining quantitative data analysis with qualitative assessment to uncover nuanced patterns and trends in social media conversations.
  • Contributed valuable insights and created compelling data visualizations for an ongoing book project led by a professor at UW, enhancing the research and its potential impact.

April 2023-Present

Undergraduate Research Assistant

Laboratory for Auditory Neuroscience and Development (LAND Lab)

  • Utilized MATLAB and the Hilbert transform to extract the envelope of the speech from EEG data of 7-month-old and 11-month-old infants, with a success rate of 70%.
  • Engaged in the pre-processing and artifact removal pipeline, achieving a 25% reduction in data distortion.
  • Analyzed chance prediction accuracy and determined whether the observed prediction accuracy exceeded chance.

Download CV

Expertise

Web Map Development

Data Analytics

Geospatial Data Analytics

My Skills

PL/SQL

95%

JavaScript

85%

Python

85%

R

70%

MATLAB

70%

GIS: QGIS, PostGIS

95%

LeafletJS

85%

MapboxGL

75%

My Projects

ORCAnalysis

GIS Analyst @ TRAC

This map, with GTFS data integrated, is built into the existing dashboard to provide more insights into ORCA data for institutions in the ORCA Business Programs.

TDEI: Conflation Review Tool

GIS Analyst @ TRAC

This is a web map interface that facilitates reviewing the results from the OpenSidewalks Conflation project.

TDEI: OpenSidewalks Conflation

GIS ANALYST @ TRAC

This project automates the sidewalk data collection in OSM by extracting sidewalk attributes from the State & City DOT and feeding into OSM through data integration.

2022 U.S Influenza Map

Web GIS Coursework

This map provides dashboards visualizing weekly and annually data of influenza cases in 2022.