My role involved gaining a deep understanding of the company's core systems, which included a custom-built CRM system in operation for over a decade, a user portal for affiliates, a tracking system for measuring and issuing ad engagements leading to partner sites (the company’s primary revenue stream), and an ETL system. The ETL system connected to partner sites via APIs or scraping scripts, extracted revenue data, and consolidated it using MSSQL Server and SSIS jobs to populate tables for Looker reports and SAP systems critical for billing and reporting.