• Developed software-as-a service products by using SQL Server SSMS, SSIS and SSAS to perform ETL and automation, relational database management, define dimensions and deploy OLAP cube of metrics for web based solutions/dashboards• Built machine learning models with Lasso, Random Forest and XGBoost to predict housing price in major markets• Facilitate tasks in an Agile team that follows Scrum framework, and used Jira/Git to manage version control

• Performed geospatial analysis using ESRI ArcGIS tools and extensions such as ModelBuilder, Spatial Analyst, Network Analyst• Conducted quantitative analysis in ArcGIS and QGIS with SQL/Python to create geo-databases for project management• Developed web mapping applications using Google Maps API by writing JavaScript, HTML and CSS

• Geo-referenced and manipulated vector and raster data to create, upload and manage map layers in SQL Server• Analyzed web traffic data with SQL in Oracle Database to evaluate marketing page conversion by examining visit counts, traffic source, retention rate and keywords, etc.• Collaborated with software engineers to define requirements and specifications for customized project management solutions for clients

• Geocoded data from post-sandy business interview to create maps and analysis, which is published in the APA NY Metro Chapter report.• Participated in the planning strategy making process with regard to issues includingtransportation accessibility, retail leakage, insurance coverage and grant opportunities, etc.