Amber Chen Email & Phone Number

Sunnyvale, Ca, Us

Sunnyvale, Ca, Us

Hybrid-Remote Workplace, Us

San Francisco, Ca, Us

- Established a systematic pipeline to easily ingest multiple data types across 8 companies of bike-share historical trips and stations using schema normalization with S3, EC2, Python, Spark, and PostgreSQL.- Shortened 75% computational time to implement data transformation and normalization using Pandas and Spark.- Designed an organized pipeline to group stations that changed geometry positions and station id formats using Dictionary.- Presented a number of rented bikes across bike-share stations and companies on a web-application using R and PostgreSQL.

Austin, Tx, Us

- Collaborated with industry, government, and academia to establish web-applications and pipelines which estimate traffic conditions in real-time by collecting data from 41 roadside sensors using R, PostgreSQL, and MSSQL.- Developed a web-application and multiple pipelines with R, Python, PostgreSQL, and MSSQL to customize traffic simulation scenarios and to visualize simulated results by ingesting network geometry data, GPS-speed based data, and roadside sensors data.- Predicted traffic impact (ex. vehicle reroute path, traffic condition, and travel time) from the number of closed lanes in the San Antonio subarea traffic demand model provided by MPO using R, VISTA and TransCAD.- Acquired projects to report data quality regularly with detecting at least 20% data error using a data processing pipeline with MSSQL, PostgreSQL and R. - Refined the structures in the web-applications to shorten the computational time. - Coached clients to use the traffic web-applications and to understand the underlying models by documenting the tutorials and white papers.

Austin, Tx, Us

- Established a real-time optimized bus priority signal timing model using bus GPS data and loop-detector to reduce 20% bus travel time without increasing car travel time.- Developed an automated tool that transformed traffic data format from a mesoscopic traffic simulator to a microscopic simulator using C++ and PostgreSQL to reduce manual effort on establishing a microscopic traffic simulated network.- Created a linear regression model that estimated an optimized traffic network with number of closed lane considering the balance between computational time and accuracy using C++, SPSS, and VISTA.

Munich, Bavaria, De

Developed a pipeline to transform network format from OpenStreetMap to format in ArcGIS and MapSim.

Taipei City, Taipei, Tw

- Consulted Tainan City Transportation Government to win IBM "Smart City" in ITS program.- Predicted traffic condition with the assumption of the bridge was broken in Kauoshiung city using VISSIM.

- Launched and tested a real-time optimized signal timing model which estimated signal timing using loop-detector data on three consecutive signals connected between highway and local streets. - Customized RTE (Run Time Extension) to real-time control signal time in CORSIM (a traffic simulator) using C++ and objected-oriented programming. - Coordinated with software, system, and electrical engineers to install real-time signal timing models on road-side equipment which improved traffic congestion by over 100%.- Engineered a pipeline to connect a traffic simulation model using C++ and TCP communication to a web-application residing on linux.

Doctor Of Philosophy (Ph.D.), Civil Engineering

Master'S Degree, Civil Engineering

Transportation Techonology And Management