William Li Email & Phone Number

Toronto, ON, CA

Toronto, Ontario, Canada

Lead and subject matter expert in back-end automation for dashboards summarizing various global network health metrics for all of Scotiabank, saving 50+ hours every month on manual report compilation.Implemented ETL pipelines involving numerous network tools with Selenium, API-driven scripts in Python, and MongoDB, hosted on Docker containers and scheduled.

Toronto

Designed and implemented script to add, remove, and edit network devices in bulk using the bank's main network device management tools, What'sUp Gold and Statseeker. Script is in production with expected lifetime of a minimum of 5 years, with 20,000+ affected devices internationally and 200+ hours saved as of Q3 2021.Led and maintained project to stream.

Toronto

Utilized Pandas and Selenium to fully automate mobile device ticket closures within ServiceNow in accordance with SDLC, saving 6,300 hours. Distributed script in ready to run format requiring no installation nor set-up to execute all contained within EXE files using Pyinstaller. The implementation affects every bank-owned mobile device beginning 2019 and.

Kitchener, Canada Area

Designed and implemented an AWS data pipeline involving over 100 million data points flowing through S3, Redshift, and DynamoDB with minimal assistance, triggered by Lambda scripts written in NodeJS.Managed AWS roles and security policies for the project.Developed and deployed scripts using cloud Linux platform through Cloud9.io.Experimented with AWS.

Guelph, ON

Administered 25 years of historical school board insurance documents, including policies, quotes, and certificates, to online storage system.Assisted with the organization's risk, accounting, and claim departments on various documentation purposes.Compiled insurance reports and communicated with representatives from over 90% of Ontario's school boards.