William On Email & Phone Number

Canada

-Utilized SAS & SQL to create critical data marts and reports for Product Sales team-Implemented robust automation to streamline and optimize highly manual reporting processes, resulting in significant time saved and enhanced operational efficiency-Through Tableau, created impactful and visually compelling dashboards, delivering valuable insights utilized extensively by the pavilion sales team to drive informed decision-making and coaching

-Utilized Big Query in Google Cloud Platform (GCP) to create test and control groups based on current campaign exclusions-Leveraged the SciPy library in Python to perform statistical tests as well as measuring changes in efficiency and incremental lift for marketing campaign offers-Analyzed customer survey response data to investigate the correlation between grocery fill/found rates and customer experiences-Updated customer segment comparisons and web interaction metrics in weekly reports to help support business decisions

Toronto, Ontario, Canada

- Utilized MS Excel to analyze and produce reports from insurance claims data.- Identified trends and potential problems in claim activities. Presented findings in team meetings.- Designed and created new dashboard reports to help drive business decision.- Automated monthly reports using MicroStrategy- Insights and Power Query.

Toronto, Ontario, Canada

- Planned convocation event layouts leading to more efficient attendance and 95% event satisfaction rates.- Trained new team members to update alumni databases containing over 2000+ contacts using MS Excel.- Conversed with university alumni and consolidated feedback to improve upon events in the future.- Worked closely with the Microspec events team to ensure that 5000+ UofT alumni were able to successfully register for the Reunion event.

Toronto, Ontario, Canada

- Contacted UofT alumni and business corporations to inform them about new donation opportunities at the university.- Assisted university alumni in making transactions towards school scholarships and bursaries.- Updated alumni about upcoming events and activities happening at the university.

- Provided VSC and Crossey Engineering team members with project documentations and schematics when required.- Ensured clients received well organized work binders containing all required project documentations.