Sign in

PostgreSQL DBA and Data Scientist

San Jose, CA
September 19, 2018

Contact this candidate


Ya Wang

e-mail: telephone: 408-***-****

Summary of Qualifications

Experience in Project management

Technical leader in a team with hands-on experience in solution development.

15 years of experience in Transportation Modeling

15 years of experience in GIS

10 years of experience in database management system

10 years of experience in deployment and use of Open Source Software bundle

In-depth knowledge on transportation planning/modeling theory

In-depth knowledge on enterprise GIS system implementation and deployment.

Basic Knowledge of Big Data Analysis and Map/Reduce

Hands-on experience with using Machine Learning Algorithm algorithms to solve a real world problem

"Never stop learning" spirit.


Santa Clara Valley Transportation Authority March 2002 to Present Senior Transportation Planner in Modeling, Data Analysis and GIS Main Project Management and Development Duties:

Discover and explore new technology and develop innovative solutions. List of Major Projects:

1. Virtual Transit Ride Project

The project aims to develop a browser based app, which could cultivate users’ affinity with the transit service operated by VTA by offering highly interactive virtual transit ride experience. Responsible as Project Initiator and project manager

Plan and develop project scope, schedule and deliverables

Develop request for proposal and select contractor

Monitor contractor’s work progress and review the deliverables.

Draft the report and presentation

2. Clipper Data Analytics Project

The project aims to make use of and make sense of the millions records of clipper transaction we collected yearly since 2011.

Responsible as Project Initiator, project manager and developer.

Plan and develop project scope, schedule and deliverables

Build the system to extract the data, process the data, and analyze the data.

Organize meeting and do presentation to promote the project 3. VTA enterprise GIS system Strategic Plan

This project defines and designs an enterprise GIS system in VTA and provides guidance on its deployment and implementation. The project aims to overhaul the old file based and department silo-ed GIS system and replace it with an enterprise database and web application based GIS system. The new system will make geospatial data management more effective and information more accessible.

Responsible as a System Architect:

Involved in identification of stakeholders and their data needs.

Developed a proposal to use PostgreSQL as backend database

Design system infrastructure and make software and hardware recommendations.

Build the backend infrastructure of the enterprise GIS system

Draft the report.

4. VTA Enterprise Database System Establishment, Development, and Management This project aims to build the system to better organize and manage the data used to support Modeling, GIS and other planning activates. In this project, various software and hardware infrastructure choices are evaluate; servers configured; geospatial data from various sources and in various formats are collected and converted into the database’s native format; Proper user groups and privileges are set up; various CAD and GIS applications are configured to enable connection to the database for either read only or writable use.

Responsible as: System Architect, PostgreSQL DBA and Developer, Promoter of new technology

Define and build the infrastructure of database server

Database design, database development/management and data integration

Set up work flows using procedure language to automate various data processing

PostgreSQL installation, configuration and Database performance optimization

Set up database replication and job schedule for regular maintenance tasks such as backup

Organize multiple PostgreSQL training sessions

5. Data Development and Analysis

The project aims to populate the PostGreSQL enterprise database with data and set up data analysis procedures useful for VTA’s functionality: planning, modeling, engineering, etc. For example, draft a cheat sheet for the use of The “Extraction, Transformation and Loading” (ETL) tool: Ogr2Ogr. The ETL tool were used to convert data original in numerous other formats, including Shapefiles, ESRI’s geodatabase, Oracle database, WFS service layers, GML, XML, and CSV, into PostGreSQL table format.

Responsible as: PostgreSQL DBA and Developer

Developed updated census/ACS database using Python and PostgreSQL

Converting and loading OpenStreetMap data for the BayArea region into PostgreSQL database

Converting and loading existing GIS data into PostgreSQL database

Converting and loading data obtained from various WFS server into PostgreSQL Database

Converting and loading CAD/AVL historic data from Oracle database into PostgreSQL Database

6. R/PostGreSQL Integration

The project aims to integrate the analytical capability in the PostGreSQL enterprise database through PL/R extension. By putting the analytical procedures where the data is, it will make it easier to use the most updated data for analysis purpose and also make it easier to share and reuse analytical procedures.

Responsible as: Data analyst and PostgreSQL DBA and Developer

Spearhead the project.

Develop analytical procedures using Pl/R

Staff Training

7. VTA Web Information Distribution Applications

The project creates interactive web applications for distribution and collection of GIS information related to VTA’s functions. By taking advantage of the platform independent format, the GIS information created or prepared by VTA will become widely and readily accessible to VTA’s employees as well as the general public. The project also aims to promote collaboration between VTA and its member agencies and the online community.

Responsible as: System Architect and Developer

Deployment/implementation/development of VTA MapServer Based GIS Web Applications.

Design and development of VTA transit web applications to enable interactively query of VTA transit facilities, ridership profile, station fly around and virtual transit ride.

Design and development of VTA web land use application to facilitate land use data review process. The application allows VTA member agencies to query ABAG Projections data by city, census tract or traffic analysis zone, and provides synchronized visualization of maps and graphs.

Creation and deployment of Open Source software: Geonode based web data portal:

8. Migration of PostgreSQL to Amazon Cloud

Responsible for:

Setting up prototype for PostgreSQL database in the Cloud

Set up Amazon EC2 ubuntu instance

Configure the PostgreSQL database system in Amazon cloud

Testing the system

Main Modeling Duties: Developing and maintaining travel demand models; travel forecasting and analysis of transportation system performance; processing and analyzing transit onboard survey data and decennial census data; updating modeling related chapters in various reports;

List of Major Projects

1. Transition to Activity Based Model

This project aims to deploy the activity based model developed by the regional planning agency: MTC in VTA. In this project, I am responsible for the development of input data for year 2010 run based on Census 2010 and ACS estimates. 2. VTP2040 Model Run;

This modeling project analyzes the impact of various combinations of land use and network scenarios on greenhouse gas emission. I was responsible for all aspects of this modeling project, including the development of the input data, extraction of the modeling results and the draft of modeling reports. One interesting finding of this project is that only after we concentrate growth inside a small number of traffic analysis zones with highest transit accessibility are we able to really reduce the greenhouse gas emission significantly.

3. Grand Boulevard Initiative Model Run

This modeling project analyzes the impact of various combinations of land use and transit alternatives on transit ridership, mode share and transit trip length. I was in charge of all aspects of this modeling project.

4. VTP 2030 Model Run

This modeling project develops future traffic forecast to support the preparation of VTA 2030 report. In this project, I was responsible for the model run and the extraction from the model a series of transportation system performance indexes, including VMT/VHT, percentage of market share for various transportation modes, traffic volumes across gateways between counties, and etc.

5. Various Highway Corridor Analysis and Transit Corridor Analysis These projects use the VTA County-Wide Model to predict and compare the improvement the proposed highway or transit projects can bring on the transportation system performance. I was playing supporting roles in a lot of these kinds of projects, involved in preparing network, running select link analysis or subarea analysis, extracting results etc.

6. VTA County-Wide Model Update project

This is the modeling project that I played an important role in when I first started in VTA. In this project, I was responsible for the following tasks: 1) define new traffic analysis zone (TAZ) boundaries using GIS software; 2) develop transit network using Viper; 3) create land use database for both base year and forecast year based on Census 2000 and ABAG Projections 2003; 4) convert the TP+ model stream defined in DOS batch file into a set of applications in CUBE VOYAGE. This greatly improved the structure of the model and facilitated the model run.

As part of the model update, I also developed a set of CUBE/Voyage application to automate the calibration process in Trip Generation, Trip Distribution and Modal Choice. This greatly improved the efficiency and also improved accuracy by minimizing the human error in conducting the manual calibration.

Main GIS duties:

Lead various GIS mapping and analysis projects in VTA; Design and build the VTA enterprise GIS database to support VTA GIS/CAD functions; Deploy and implement an end-to-end GIS solution in VTA; Spearhead various Google API and web service based web GIS applications development in VTA; Design and draft VTA enterprise GIS system Strategic Plan.


1. Modeling Software: Cube/Voyager, TransCAD

2. Database development and management: PostGreSQL, PostGIS, PHP, SQL, PL/SQL, PL/PYTHON, PL/R

3. ESRI tools: ARCGIS Server, desktop products, network analyst, spatial analyst 4. Web server, web application development: Apache, WMS/WFS, JavaScript, Google API, KML/JSON, JQuery, Fusion, Silverlight, etc 5. General Programming Language: Java, Python

6. Data conversion: GDAL/OGR

7. Data analytics: SPSS, R, etc.

8. Graph database: Neo4j

9. IDE: Eclipse


Certificate in Geographic Information Science with specialization in Cartography, The Department of Geography, San Jose State University (May, 2005) Mining Massive Data Sets Graduate Certificate, Stanford University (December, 2015) ASSOCIATION MEMBERSHIPS

CITILABS Travel Demand Model Users Group

Volunteer professional in BayGeo


May 2002

Ph.D. in Transportation Engineering

Department of Transportation Engineering, New Jersey Institute of Technology January 2000

M.S. in Transportation Engineering

Department of Transportation Engineering, New Jersey Institute of Technology July 1996

B.A. in Economics and Business

Department of International Economics, Nankai University, Tianjin, China DOCTORAL DISSERTATION

Wang, Y. (2002). A bi-level programming approach for the shipper-carrier network problem, Doctoral Dissertation, New Jersey Institute of Technology. ISBN/ISSN: 978**********


Wang, Y., Naylor, G. (September, 2012). " A Road Less Traveled: Open-Source Web GIS Development Leads to New Paths". GeoWorld Magazine Wang, Y., Naylor, G. (May, 2012). "Going Google: A New Way to Visualize Transit Information". GeoWorld Magazine

Wang, Y. (Summer, 2011). "A Planner Rides the Train in Hong Kong". APA Transportation Division Newsletter / Volume 36, Issue 2 / Summer 2011 Boilé, M. P., Spasovic, L. N., Wang, Y. (2002). A Combined Shipper/Carrier Intermodal Network Model. Journal of Economic Literature

Boilé, M. P., Spasovic, L. N., Hausman, K., Wang, Y., and Rowinski, J. (2000). A Generalized Cost User Equilibrium Model for Assignment of Multi-Commodity, Multi- Class Truck Trips. Final Report Submitted to the New Jersey Department of Transportation.

Rowinski, J., Boilé, M. P., Spasovic, L. N., Wang, Y. (2001). A Multicommodity, Multi- Class Generalized Cost User Equilibrium Assignment Model. TRB ID 01-2596, Presentation at the 80th Annual Meeting of the Transportation Research Board. Spasovic, L. N., Chien, S., Feeley, K. C., Wang, Y., Hu, Q. (2001). A Methodology for Evaluating of School Bus Routing A Case Study of Riverdale, New Jersey. TRB Paper No. 01-2088, Transportation Research Board 80th Annual Meeting. CONFERENCE PRESENTATIONS

Wang, Y. (Nov. 2016) “An Integrated Information Management and Analysis System for Clipper Electronic Fare Card Data”, abstract accepted by 16th TRB National Transportation Planning Applications Conference but not able to attend Wang, Y. and Naylor George (Jan, 2016) “"Identify Transit Service Gap Using Transit Accessibility for the Santa Clara County", TRB 2016 Poster Session: TRB Paper 16-5644 Wang, Y. (Sept. 29, 2011). "VTA Transit Web Application". GeoTec Event 2011. Wang, Y. (Mar. 30, 2011). "An Online Interactive Transit Inventory through Google Map API". APTA TransITech 2011

Wang, Y., Naylor, G. (Jun 28th, 2010). "Modeling for a Multi-modal Transportation Corridor –the Grand Boulevard Initiative Project". 2010 ITE Western District Annual Meeting

Wang, Y. (Feb. 5th, 2009). Land Use Analysis of Catchment Areas for Light Rail Stations. Presented at 2009 ESRI California/Hawaii/Nevada Regional User Group

(CA/HI/NV RUG) Conference


Boile, Maria, Director Hellenic Institute of Transport, Center for Research & Technology,

Contact this candidate