- Built a standardised relational database schema using SQL to consolidate raw machine logs, order histories, and customer data into a single unified system, improving overall data accuracy and consistency across teams.
- Developed automated Python pipelines using APIs to extract real-time 3D printer telemetry (e.g., bed temperatures, print speeds) and merge it with CRM records, creating advanced visualisations that aided in tracking print failures and managing inventory.
- Segmented customer data to identify a key cohort driving 65% of total revenue, informing targeted, personalised offers that increased retention and maintained profit margins while delivering high customer satisfaction.
SQL schema unificationReal-time 3D printer telemetry65% of revenue segmented