- Spearheaded the development of a spreadsheet automation system for Guangzhou Baiyun (CAN) and Changsha Huanghua (CSX), leveraging JavaScript and Google BigQuery, resulting in an 80% increase in efficiency and data extraction speed.- Played a pivotal role in rectifying nearly 1,000,000 data discrepancies across various reports, ensuring a higher level of accuracy in report reflections.- Designed and implemented real-time dashboards using Google BigQuery, Looker, and Google Looker Studio, enabling stakeholders to make well-informed business decisions and monitor key performance metrics.- Constructed an entity-relationship diagram to visually represent Teleport's database, enhancing internal documentation and facilitating a better understanding of data relationships.- Shared expertise and fostered knowledge transfer by hosting a spreadsheet bootcamp for new team members, emphasizing corporate best practices known as "The Teleport's Way."- Contributed to knowledge dissemination by writing articles tailored for individuals with non-technical backgrounds, further enhancing the organization's expertise in the industry.