Summary

Solid Multi - disciplinary Education in Computer Software Engineering, Statistics, Geography, and Transportation Engineering Over 10 Years of Extensive Experience in the Design, Development, and Research of Software Systems Interested in Databases and GIS, Transportation Planning, Statistical and Numerical Analyses, Data Mining and Visualization.

Skills

• Programming Languages: Java .Net Python PHP JavaScript JQuery CSS HTML5
• Software Development Tools: Eclipse JBuilder SliverLight Rational Rose UML Visual Studio
• Database Tools: ArcGIS Oracle in Linux SQL Server MySQL PowerDesigner Birt
• Statistics and Math Tools: MATLAB R SAS SPSS SAS Enterprise Miner CAD Map3D

Employment

GIS and Data Modeler

Business Intelligence and Location Intelligence Big Data

• Analyst Sprint and Verizon Cell-phone Big Data to Estimate Urban Planning Data
• Visualized State-County Trips by Statistical Data Model Development
• Built Models by Arc Toolbox in ArcGIS 10.1
• Designed Desire Lines for Trip Count Data visualization
• Developed GIS Network Analysis for transportation OD study
• Developed Automatic Data Analysis Algorithms and Programming by Python 2.7
• Created QA Data Reporting by BIRT on basis of database, JavaScript, XML, etc.

Software Developer

Web-based Intelligent Management System

• Trained Oracle 11g Database Management and Development in Linux 5.0
• Designed Intuitive GUI Solutions for Mac OS X Targets
• Created Web Services jQuery and Ajax for E-Commerce
• Developed GIS Map, GPS Services for iOS Apps
• Adhered to Agile Design Principle and Agile Work Environment

Research Assistant

Database Project

Confidential

• Invented Spatiotemporal Approaches of Traffic Data Archives to Minimize Data Redundancy and
• Maximize Data Completeness in Transportation Spatio-temporal Databases
• Sampled Traffic Data with Spatial Sampling Method and Power Analysis
• Contrasted Two Different Vehicular Speed Models with Hypothesis Paired T-test in SAS 9.2
• Conducted All- Pairwise Comparisons Hypothesis Turkey Method and ANOVA to Estimate the Validation
• f Different Speed Data Interpolation Models Using SAS 9.2
• Created Linear Approximation Algorithms and Used Numerical Analysis Methods to Estimate Vehicular Speed Interpolation in MATLAB 7.0 and R 2.10
• Estimated Average Traffic Speed with Statistical Regression Models in SAS 9.2
• Developed Conceptual, Logical, and Physical Models of Relational Database to Normalize Traffic Data
• at Highway Railroad Grade Crossing Using PowerDesigner 12.5
• Built the Management System of Nebraska Highway Railroad Grade Crossing Using .Net and SQL Sever 2010
• Designed Transportation Map including Spatial Vector and Raster Data in ArcGIS 9.3
• Converted GIS Shape Files with Vehicular Motion Data Extracted from Traffic Video into Spatio-temporal Databases
• Developed factor method, temporal method with factor, spatial method with factor, and spatio-temporal method with factor to impute missing-data in databases.
• Developed Traffic Video Information Converting System by .NET, SQL Sever 2010, and PostGIS
• Compiled a Synthesis about Transportation Data Archives Systems in USA and Elsewhere in the World

GIS and GPS Project

Confidential

• Analyzed Urban Planning and Traffic Simulation Data by ArcGIS 9.3, VISSIM 5.3, and EXCEL 2012 VB Macro
• Queried and Analyzed Vector and Raster Road Data Stored in Geodatabase by ArcSDE, ArcToolbox
• and ArcCatalog
• Implemented Geoprocessing Script Programming with Python in ArcGIS 10 and Open-source GIS
• Packages OGR and GDAL
• Applied Quality Control Tools for Vector Data Maintenance and Validate Geometry and Recorded
• Topology Errors with ArcGIS Desktop Tools and PLTS GIS Data Reviewer
• Collected Field Data Using GeoXT Explorer GPS Unit and Edited Data Using ArcPad 9.3 and ArcMap 9.3

Statistical Analysis and Data Mining Projects

Confidential

• Imputed Data for Direct Mail Customer Data that have Missing Values with Distribution-based Replacement Methods
• Used SAS Enterprise Miner 5.3 to Analyze Data with Different Data Mining Models, such as AutoNeural, Stepwise Regression, and Decision Tree
• Evaluated Different Data Mining Models with Rate of Change ROC and Score Ranking Overlay Plots in SAS Enterprise Miner 5.3
• Contrasted Support Vector Machine and Multilayer Feed-forward Neural Networks for Volume Forecast by Using MATLAB 7.0 and LibSVM

Software Engineer

Confidential

• Analyzed Calculation Principles and Arithmetic Processes about Train Running Safety Models
• Developed Optimization Algorithms and Processes to Estimate Different Safety Models
• Created Transit Operation Functions to Automatically Monitor Train Regulate and Tracker
• Visualized Transit Simulation Control and Safety Data Analysis Using C in Eclipse 3.0

Transportation Planner

Confidential

• Planed Highway Geometrics and Designed Bridge Construction by AutoCAD 2002
• Developed Bridge Construction Calculation System Using Java in JBuilder 7.0
• Created Online Employee Management System by ASP, C, and SQL Server 2003

Software Engineer

Confidential

Transportation Information System with Data Warehouse, GIS, and Data Mining

• Integrated Seven Subsystems of Intelligent Transportation Systems in Data Warehouse, Such as Transportation Management System, Intelligent Navigation System, Freight System, Public Transit
• System, Electronic Fare Payment System, Driving Safety System, and Emergency Rescue System
• Designed the Architecture, Schema, Granularity of Data Warehouse Using Multidimensional Models
• Identified Data Sources and Formats to Determine Dimensions and Measures of Data Warehouse
• Edited GIS datasets Using ArcView 8.3 and SQL Sever 2003 Served as DBMS of Transportation Systems
• Loaded Traffic Data into SQL Sever 2003 to Optimize the Size and Query Complexity of Data Warehouse
• Applied ArcSDE 8.3 to Serve Spatial Data to GIS client Application and through ArcIMS 8.3 over Internet
• Separated Traffic Data into Meaning Traffic Aggregation Data for Data Mining and Visualization
• Using Java API of SQL Sever 2003
• Utilized Bayesian to Filter out Crash Uncertainties and Smooth Relative Crash Risk, Identified Crash Location, Ranked Roadway Segment Types, and Visualized Spatial Relative Crash Risks in Map 3D Views

Civil Engineer

Confidential

• Supervised Quality Management of Expressway Engineering Project at Suzhou-Singapore Industry Park
• Organized Quality Control of Overpass Engineering at East-southern Junction of Suzhou City