Architected a medallion-layer SQL Server data warehouse ingesting ~500 GB/day from 11 ERP instances.
Designed the target data model to support multi-dimensional reporting across finance, sales, and operations.
Automated daily refreshes (full load < 6 min), eliminating manual spreadsheet consolidation for 20?30 finance staff.
Established performance-tuning and data-quality controls to ensure reliability for near real-time reporting.
Architected a medallion-layer SQL Server data warehouse ingesting ~500 GB/day from 11 ERP instances.
Designed the target data model to support multi-dimensional reporting across finance, sales, and operations.
Automated daily refreshes (full load < 6 min), eliminating manual spreadsheet consolidation for 20?30 finance staff.
Established performance-tuning and data-quality controls to ensure reliability for near real-time reporting.