Henry Sun Email & Phone Number

Calgary, Canada Area

- Currently leading the ArcMap Decommissioning in Mobility Project- Worked as Project Manager on the Calgary Roadway Activities Emap Project with a budget of $750,000 and delivered an interactive online map showing ongoing and future construction projects across multiple City business units and various utility companies to enhance collaboration and reduce conflicts- Created a Power BI dashboard for concrete repairs showing budget, running total and daily accomplishment to replace a weekly manual and very time-consuming process- Developed a Power BI dashboard for traffic related assets showing Signal, Streetlight and Sign asset conditions and total cost, also highlighting critical assets, level of service targets and funding gaps- Creatively calculated reliable pavement inventory data for the City using the most recent road surface and street center line data instead of collecting the data in a traditional and costly way- Developed a highly efficient and productive Compaction Test app to replace a paper-based form- Created automated data flow on multiple platforms (PC, FME Server, Power BI Report Server, ArcGIS Online, etc.) to optimize business processes for front line operations

Calgary, Canada Area

- Designed on-street parking signing plans for ParkPlus zones and residential parking zones- Reviewed existing on-street parking signage in various communities to identify errors and took action to correct them- Took the initiative to analyze the ParkPlus zone numbers stored in the geodatabase and converted them into a ParkPlus zone map efficiently using FME- Collaborated with business partners such as Public Spaces Delivery (formerly known as Transportation Infrastructure) on various projects to provide from interim to ultimate traffic control solutions required on roadways- Investigated a wide spectrum of traffic related 311 service requests and provided informative responses to concerned citizens- Teamed up with IT to optimize the procedures for creating sign installation work orders to achieve more efficiency and improve productivity for 10+ team members

Calgary, Canada Area

- Performed business process review and analysis on concrete condition survey and provided strategic advice on application improvement- Conducted research on various projects to identify issues and opportunities, and provided practical and sustainable solutions- Created highly customized SAP BusinessObjects reports for various Roads divisions to track 311 service requests, average sign cost, and costs of SNIC and Spring Clean-Up activities- Designed dynamic dashboards for visualizing key business performance measures- Provided GIS training and technical support to users in Roads

Calgary, Canada Area

- Maintained and managed a GIS based inventory of all traffic signs in the city and kept this inventory updated in the City's enterprise geodatabase- Collected GPS data for traffic signs- Linked the traffic sign inventory to the asset management system and managed asset data- Conducted annual traffic sign condition survey- Created monthly traffic sign installation and maintenance reports for senior management team- Provided suggestions and recommendations to improve the accuracy and efficiency of GIS and asset management system

Calgary, Alberta, Canada

- Performed data collection, error correction, data format conversion, and spatial data reprojection- Designed geodatabases for the collected media data, election data and demographic data- Conducted spatial and statistical data analysis- Improved cartographic visualization of the on-line maps- Created an interactive GIS-based website using ArcIMS- Developed training manuals for the in-country partners: Peru, Mexico, Guatemala, Argentina- Offered technical trainings and logistical support to the in-country partners

Master'S Degree, Geographic Information Science

Master in Geographic Information Systems

Bachelor Of Science (B.Sc.), Geography, Resource And Environment Planning And Management