Linford Lo
About Linford Lo
Linford Lo is a Business Intelligence Developer with experience in data management and application development. He has worked for the Government of Canada since 2019 and previously contributed to the Hong Kong Trade Development Council in 2011.
Work at Government of Canada
Linford Lo has been employed as a Business Intelligence Developer at the Government of Canada since 2019. In this role, he focuses on enhancing data management and reporting processes. He has developed and maintained various applications and workflows that support organizational efficiency. His contributions include creating Alteryx ETL workflows that reduce manual data entry time and developing an ETL workflow to consolidate COVID data for reporting purposes.
Previous Experience at Hong Kong Trade Development Council
Prior to his current role, Linford Lo worked at the Hong Kong Trade Development Council as a Fair Assistant in 2011 for a duration of two months. This position provided him with initial exposure to data management and operational support within a trade development context.
Education and Expertise
Linford Lo studied at Algonquin College of Applied Arts and Technology, where he focused on Computer/Information Technology Administration and Management, achieving a specialization in Business Intelligence System Infrastructure from 2018 to 2019. Additionally, he earned a Bachelor of Arts in Psychology from Carleton University, completing his studies from 2012 to 2016. His educational background equips him with a blend of technical and analytical skills relevant to his current role.
Data Management Projects
Linford Lo has successfully converted a performance management system from Microsoft Excel to a Microsoft Access database, which improved data management efficiency. He also developed a Microsoft Access application aimed at streamlining data collection and storage processes for end-users. Furthermore, he designed and updated Tableau dashboards to provide senior management with daily awareness of the COVID situation, benefiting both the organization and the National Capital Region.
Technical Skills and Tools
Linford Lo possesses expertise in various data management tools and technologies. He has created Alteryx ETL workflows that significantly reduce manual data entry time across different units. His skills include developing applications in Microsoft Access, designing dashboards in Tableau, and implementing ETL processes to ensure data integrity and accessibility for reporting purposes.