Finance Report - Automation
This project involves using APIs to pull and manipulate data from Bullhorn using stored functions in Azure Functions, storing this data in Snowflake, and presenting it on Power BI.
The aim was to reduce the workload of the finance team by streamlining a process they have to do manually, and so our solutions ensured data integrity.
Applicant Tracking System - Data Migration
My responsibility involved retrieving necessary data from Bullhorn CRM via API calls, cleaning and transforming it and then posting it to Teamtailor using their API. This invovled understanding both APIs and reformatting the data so it was appropriate.
Accessing the backup files using SQL Server Management System (SSMS), I provided a mapping of candidate emails to their CVs and securely sent over the mapping with their files.
Match Outcome Prediction
Designed and improved classification and regression models to predict match outcome and scores and use these to predict league outcomes from historical football match data.