Skip to content
System Note 04 · Enterprise Systems

Network-Ticket Reporting Pipeline

Bell Canada

PythonSQLSAS DITeradataETLData Warehousing
Live
What it is

The nightly batch pipeline on Teradata and SAS DI that takes data from four systems, cleans and joins it through staging, warehouse, and analysis layers, and lands 150K records a day in a 78-column fact table. It has run since November 2025, and I presented it to directors.

150K records/day · 78-column fact table · DEV → QA → PROD

Why I built it

The business needed one reliable daily picture of network tickets, and the four sources had never been stitched together before.

Outcome
150Krecords/day
← Back to Build Notes