Data Visualization Projects in LagosData Visualization Projects in Lagos
Projects
People
Cover image for 1M+ Row Migration ROI: SQL
1M+ Row Migration ROI: SQL Server to PostgreSQL I engineered a Python ETL pipeline to migrate legacy SQL Server data to PostgreSQL, prioritizing cost-efficiency and absolute integrity. The Problem: High licensing costs and a need for cloud-scalability without risking the "Source of Truth." The Outcomes: 🔹Savings: Projected 65% reduction in annual licensing fees 🔹Integrity: 1,055,008 rows reconciled with zero violations 🔹Audit: Flagged 24,000+ quality issues (negative prices, invalid emails) during the move The Impact: Shifted from reactive maintenance to proactive cloud-scaling on AWS/Azure with a cleaner, more reliable database. Why Me? As an Accountant & Data Engineer, I bring "ledger-style" reconciliation to architecture. I don’t just move data; I audit it. Open for Migration contracts. Let’s cut your costs.
2
43