Xiaochen Chen

Select Projects

Executive Master of Business Administration (GPA: 3.9/4.0) – Ottawa University, Jan 2019-Jan 2022

Concentration: Information Technology & Business Data Analytics

Master of Urban Planning & Policy (GPA: 3.6/4.0) – University of Illinois at Chicago, Sep 2015-Dec 2018

Certificate: Geospatial Analysis and Visualization (GSAV)

Bachelor of Construction Management – Shandong Architecture University, China, Sep 2007-Jun 2011

Analysis Tools: ArcGIS/QGIS (advanced), R (medium)

Business Intelligence Tools: Tableau (medium), Power BI (medium)

Programming: SQL (medium), Python (medium), HTML (knowledgeable) 

Documents & Presentations: Word (advanced), Excel (advanced), PowerPoint (advanced)

Design Tools: Photoshop (advanced), InDesign (advanced), Illustrator (advanced), SketchUp (advanced)

Business Intelligence Analyst – Fresh International Market, Schaumburg, Jan 2023- Present

●    Generate daily, weekly, monthly sales reports and assess sales strategies by analyzing related products, markets, or trends.

●    Leverage business intelligence data and tools to accurately plan and optimize inventory based on historical sales, shipment, point-of-sale and other performance data such as trends in inventory turns.

GIS & Business Analyst – RHthermo, Remote, Jan 2022- Present

●    Creating and maintaining detailed GIS maps of the existing IoT heating system that provides a complete systematic inventory of the equip ments and sensors.

●    Established BI tools to provide insights for operation optimization.

●    Developed an interactive map using GIS and JavaScript. Users can use the control components to monitor the indoor level operations of a campus IoT heating system (23 buildings, 3700+ rooms).

GIS Analyst – Chowbus, Chicago, June 2019-Dec 2021

●    Forecasted and balanced supply and demand by collecting and analyzing the constraints of geographically distributed supply chains.

●    Captured user behavioral needs and pain points by using GIS spatial analysis to combine information from multiple sources (consumer data, socio-demographics, land use, operating environment, etc).

Research Assistant – Metropolitan Planning Council, Chicago, Jan 2019-May 2019

●    Created, maintained, and updated various data related to the Chicago suburb paratransit system.

●    Produced maps for the paratransit study in the Chicago region.

●    Explored the transit ridership patterns and trends through GIS spatial analysis.

Transportation Planning Intern – Chicago Metropolitan Agency for Planning, Chicago, May 2017-Apr 2018

●    Prepared data and built metrics for regional and local transportation planning.

●    Engineered the processes of data mining, cleansing, and wrangling from multiple time-series transportation datasets to validate data accuracy and ensure data quality.

●    Developed transportation performance evaluation measures with archived traffic data (probe data) by writing SQL scripts and working with ArcGIS Server.

●    Developed GIS analysis tools to use key factors to prioritize regional transportation improvement projects by writing Python scripts and using GIS ModelBuilder.

Graduate Research Assistant – University of Illinois at Chicago, Chicago, May 2016-Dec 2017

●    Analyzed multiple datasets and developed quantitative models for studies.

●    Co-authored two journal papers and presented several projects at national academic conferences.