Data Project
Resume:
Ya Wang
adco60@r.postjobfree.com
Skype ID: adco60@r.postjobfree.com
Los Gatos, CA
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.
EXPERIENCE
MV Transportation May 2019 to Present
Quality Assurance Manager
Responsible for the following tasks
● Internal audit to ensure compliance with contract, policy and procedures and law
● Audit subcontractors for policy/procedure compliance
● Prepare, revise, update and develop policies/procedures based on best practices
● Statistics analysis of system metrics, scheduling quality check, driver’s performance, client behavior etc.
● Manage and supervise staff for monthly data collection, processing and taxi service policy/procedure compliance
Manhan Group http://manhangroup.com/ November 2018 to May 2019 Consultant
Main Project Management and Development Duties:
LLAMA Platform Development: Transferable Parameter Estimation Support Responsible for the following tasks
● Set up a PostgreSQL and R studio server in AMAZON AWS
● Develop python script for data loading and conversion
● Optimize and maintain the database server and data development
● Apply machine learning algorithm, such as maximum likelihood, logit, random forest to train various land use models
● Create web dashboard using R and shiny
web link of dashboard:
http://100.26.115.212:3838/myapps/llama_webapp_v00_local Santa Clara Valley Transportation Authority March 2002 to September 2018
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
● 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
● 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 activities. In this project, various software and hardware infrastructure choices are evaluating; 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 workflows 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 Shape files, ESRI’s geodatabase, Oracle database, WFS service layers, GML, XML, and CSV, into PostgreSQL table format. Responsible as: PostgreSQL DBA and Developer
● Developed PEMS database for traffic count data using Python and PostgreSQL and doing data analysis using R
● Developed updated census/ACS database using Python and PostgreSQL
● Converting and loading Open Street Map data for the Bay Area 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: geonode.vta.org.
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.
SKILLS
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
PROFESSIONAL CERTIFICATE
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
EDUCATION
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**********
PUBLISHED PAPERS
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
Contact this candidate