Constructing a North America Employee Roster from Regional Databases

My culminating project with Digital Domain 3.0 was leading the biweekly construction of an 800+ artist roster by accurately querying Oracle Human Capital Management and Shotgun Management databases before producing a dashboard on Excel using Pivot Charts. The end result was the streamlining of roster construction from 1 week to 2 days.



Constructing a Strategy Brief for the Grants for Catalyzing Research Clusters Program

The Grants for Catalyzing Research Excellence Clusters (GCRC) competition was jointly created by the UBC Vice-President Research & Innovation and the Provost & Vice-President Academic to support the development of emerging research clusters into Global Research Excellence (GREx) clusters. For this project, I analyzed data across all competition years and presented my findings in a brief which provided recommendations for the GCRC’s future strategic direction.