← Back to projects

Image Registrars Ltd

Enterprise ETL & Data Pipeline

90% of daily reporting automated

Python · Mage AI · SQL Server · Pandas · 3CX API · Freshdesk API

Built and orchestrate a set of Mage AI pipelines that pull telephony data (3CX), support ticketing (Freshdesk), and internal queue-system data into a shared reporting database, processing 50,000+ records daily.

Automated 90% of what used to be manual daily reporting, cutting the turnaround from roughly 3 hours to 15 minutes and improving agent productivity by 25%. Also built a weighted KPI scoring engine for agent performance management with automated validation, cutting reporting errors by roughly 95%.