• Retrieved and integrated data on farms, mainly census and survey data, from various sources• Automated the IT processes for the USDA Economic Research Service’s development of production expense models using SAS and SQLServer• Verified model documentations with subject matter experts within the department• Developed and input results to a web-based Geographic Information System (GIS) that generated visual representations

• Approximated the length of Vehicle Routing Problem solutions using complementary spatial information • Designed experiments to compare routing distance continuous approximation models based on varying spatial point processes with R and Python and used HTCondor to perform parallel computing• Conducted database logical designs and implemented the physical design in MySQL to support the storage and manipulation of simulated spatial point pattern data • Built an improved model of VRP approximation with spatial distance methods

• Stored spatial data in PostGIS and published WMS and WFS via Geoserver• Built a web-GIS to visualize and manipulate spatial data in 3D with OpenLayers, Cesium, and ExtJS

• Supported faculties in spatial statistics and multivariate statistics related subjects• Designed, explained, demonstrated, graded assignments • Assisted courses: Quantitative Methods, Spatial Data Structure, Transportation Geography

• Designed and implemented user interface for the Government Regional Economic and Transportation Location Planning and Decision support system

• Participated in GIS research project to track demographic and geographic data of graduate students in the Global Health Program

• Aided professor of Medical Geography to demonstrate uses of GIS for Health applications

• Participated in graduate level GIS transportation project within a GIS Software and Application Engineering Research Center • Optimized network data structure and implemented revised route planning algorithm• Received second prize in the 18th Science & Technology Thesis and Report Conference

• Helped Visual C++ Programming Design graduate students on course design projects

Zondy Group, University of Geosciences, Wuhan, China • Participated in undergraduate level GIS MapGIS-IMS WebService 2.0 project within a GIS Software and Application Engineering Research Center• Researched on Open GIS Consortium (OGC) standards, including Web Map Service (WMS), Web Feature Service (WFS) and Geography Markup Language (GML)• Translated MapGISdata (GIS software in China) format into OGC standard format, and participated in the development and maintenance of MapGIS-IMS WebService.• Received Excellent rating on undergraduate thesis based on the internship project

• Participated in department research titled: Application of Data Mining in Water-supply Pipeline Network • Implemented a conceptualized K-means algorithm and applied research results to water-supply pipeline network• Received Excellence Award in Undergraduate Extracurricular Scientific Research Project from the University Department of Information Engineering