The Challenge: A national satellite service coordination company was drowning in manual data processing that delayed customer service across Canada. Every night, they received Excel spreadsheets from multiple satellite providers (Bell Canada and others) containing thousands of service call requests per company. Several managers spent an entire day each week consolidating this data into regional dispatch lists for thousands of technicians across five regions. This bottleneck cost thousands of dollars daily in labor and delayed customer service requests by several days.

Technical Approach: I built a headless, automated processing system using Python and PostgreSQL on a dedicated on-premise Linux server. Security requirements demanded on-premise deployment. PostgreSQL’s Linux/Unix requirement (at the time) dictated our OS choice, and the system needed to integrate seamlessly with their existing office LAN infrastructure.

Solution Delivered: I developed a complete automation pipeline that eliminated the manual bottleneck:

• Automated Excel file interception and parsing from multiple satellite providers
• Data extraction and normalization into a PostgreSQL database
• Intelligent processing of many thousands of daily service requests
• Automated generation of region-specific dispatch lists in technician-ready formats
• Complete hardware procurement, setup, and LAN integration

Results: The system transformed a full-day manual process into minutes of automated processing, handling many thousands of service calls daily across five Canadian regions. Customer service requests that previously faced days-long delays were now processed immediately, enabling same-day technician deployment. The automation eliminated thousands of dollars in daily labor costs while freeing managers to focus on higher-value operational tasks.

My Role: I served as project manager and senior developer, working directly with the client to understand their complex multi-provider workflow and translate it into a robust system. I managed hardware decisions and deployment while overseeing a DevOps specialist who handled coding support and system integration.