Analytics/Reporting/Business Process Improvement• Developed persona segmentation parameters, based on survey analyses of respondents as example sets for cluster and decision tree analyses, which were then extrapolated for application to the whole alumni population. Analysis included significant data preparation including correlation matrix to determined variables of significance for dataset construction, its validation and clean-up• Comprehensive analysis of Advance omnibus survey of all alumni to guide departmental strategic planning of programs and activities. Key findings include insights into demographic shifts in alumni population, and alumni sentiments on giving and engagement with the university• Analyzing of faculty finances at the annual and major giving levels, reviewing trends in donor giving behaviour, overlaying donor activity over time with various dimensions including geolocations (FSAs)• Formulated and implemented a standardized and regular Annual Giving (AG) report for post-solicitation activities to help gauge and track program progress• Formulating and implementing a standardized digital analysis report that is highly technical but the basis of all knock-on reports for public consumption i.e. PDF or PowerPoint presentations• Key tools: RapidMiner, Oracle SQL, VBA, Tableau

Records Management-Lead department data governance consultation group-Audit department files for migration from on-premise to cloud storage-Reorganizing department files from a reporting file structure to functional structure-Translate Records Management Metadata Standard (RMMS) into SharePoint Online metadata for file directories-Formulate and implement department retention schedule (incl. financial & legal documents)-Assessment and disposition of department assets-Ensuring consistent constituent records-Data acquisition and append (ex. linking constituent social media handles)-Prioritize and advise teams on file management (communications management of multimedia assets)-Member of university working group evaluating university wide digital asset management (DAM) system to manage all its multimedia assetsAnalytics and Reporting-Donor profiles using regression or cluster analysis to correlate donor activities/event attendance to giving propensity, and define donor groups with similar characteristics-Developed Recency, Frequency, Monetary (RFM) model and in-house Alumni Engagement Index (AEI) providing quasi-predictive analytics for better donor identificationManagement/Training-Department (co-)lead (project management) on multiple system migrations (Banner 8 -> Banner 9, SharePoint 2013 -> SharePoint Online)-Provide onboarding training to AER staff on dept. information systems, or producing online documents (wikis) for knowledge management-Training and directing co-op students on iModules CMS to create email campaigns, and event registration pagesiModules CRM/CMS, Encompass database administrator/site asset manager/editorSharePoint, oversaw department migration from 2010 to Online, migrating site assets and files over SQL Developer-for reporting on data integrity/audits, & developing custom offline data sets for data validation/business processes ex. reporting for CASE AEM, VSE, or EAB surveys

Customer consultation on print orders (BW, Colour, oversize, signs & banners), helping customers realize their designs in physical printLayout and setup of prints (business cards to banners) in MS Office and Adobe Suite softwareProduction & QC of orders, helping customers design engaging visual assetsOperation of print equipment - printers, laminators, punches, drills

Prepared house speciality teas, served customers, food prep, general maintenance of tea house.