Diwei Guan
About Diwei Guan
Diwei Guan is a Business Intelligence and Quality Assurance Analyst Intern at the Government of Canada, where he has worked since 2021. He has experience in automating reports and improving data processing efficiency through SQL and VBA.
Work at Government of Canada
Diwei Guan has been employed at the Government of Canada as a Business Intelligence and Quality Assurance Analyst Intern since 2021. In this role, Guan has implemented scheduled SQL queries to automatically pull recent data for analysis, which has significantly reduced the manual workload. Additionally, Guan has automated manual reports using SQL queries, enhancing the efficiency of report creation. This position has allowed Guan to contribute to data management and reporting processes within the government sector.
Previous Experience at Royal LePage
Prior to joining the Government of Canada, Diwei Guan worked as a Receptionist at Royal LePage / Johnston & Daniel Division from 2017 to 2021. During this four-year tenure, Guan developed skills in customer service and office administration, providing support and assistance to clients and staff. This experience laid the groundwork for Guan's transition into a more technical role in business intelligence and quality assurance.
Education and Expertise
Diwei Guan studied at Ryerson University, where Guan earned a Bachelor of Science degree in Computer Science from 2018 to 2023. This academic background provided Guan with a solid foundation in programming, data analysis, and software development. The knowledge gained during this period has been instrumental in Guan's current role, particularly in the application of SQL and VBA for data processing and reporting.
Technical Skills and Contributions
In the capacity of a Business Intelligence and Quality Assurance Analyst Intern, Diwei Guan has made notable contributions to data processing efficiency. Guan has improved the processing time of Excel worksheets by utilizing VBA for streamlined input. These technical skills have been essential in optimizing workflows and enhancing productivity within the team.