Kezhou Lyu

· Supervised and optimized GO bus routes using HASTUS to ensure on-time performance and efficiency.

· Checked and updated station inventory information with ArcGIS, creating maps and Excel sheets for SQL.

· Automated generating of weekly and monthly vehicle schedules excel sheet using R studio.

● Drafted Plan of Surveys, Reference Plans, Subdivision Plans, Topographic & As-Built surveys using Civil 3D.

● Utilized, compiled, and present data collected during field work by Sokkia total station and GPS.

● Prepared plots and maps for construction and development projects and organizing HCMs and BMs in ArcGIS Pro.

● Consulted with team leader and help them redesigned dynamic blocks such as north arrow, scale bar in AutoCAD.

● Created 3D models and calculated material such as salt amount using Civil 3D for infrastructure projects.

● Performed calculations to determine precise measurements of property lines, solve community conflicts

Independently cleaned, organized and archived 5+ years of digital data backlog on environmental contamination, facilitating city of Markham's access to historical data in future projects and decision making.

Created a spatial database (attribute table) to provide the division with comprehensive data on locations monitored from an environmental perspective

Prepared sections of annual reports to help record the division's environmental management work

Assisted the team with outdoor site visits, inspections, and measurements, to collect evidence for tackling safety and environmental community issues.

● Participated in planning a real estate development project in Wei Hai, China, named Na Xiang Hai. Written python script in Jupyter Lab to automatically generated needed GIS files.

● Developed GIS databases for government at Wei Hai and company using ArcGIS software. Integrated GPS data with existing GIS layers in order to update attribute information.

● Field data collecting by UAV through drone deploy to build aerial maps and 3D models, create in ArcGIS. 2D maps processing by PCI Geomatical and QGIS 3, 3D maps processing by ArcGIS.

● Performed geospatial data building, modeling or analysis using data manipulation or cartography software. Then help company made decisions on Na Xiang Hai projects.

● Utilized scripting languages such as Python or VBScript to automate GIS processes and tasks.

● Extensive data cleansing and analysis, used pivot tables, formulas (v-lookup, index, SUMIF), data validation, conditional formatting and graph and chart manipulation.

● Manipulation of large data files such as SAS, Excel, and Power BI to identify global market trends and mispricing products to make recommendations to business partners.

● Created automated process for selecting prospective auditees from client database, replaced traditionally manual process and established improved client nomination approach.