Overview
Profiled 1.2M records, implemented dedupe rules, and migrated to 3NF with foreign keys and constraints.
Impact
Reduced duplicate rate by 98% and enabled reliable downstream analytics.
Author: mined records
-
Excel KPI Dashboard
Overview
We built a weekly reporting pack driven by a single refresh. Power Query ingested CSVs, standardised schemas, and fed model tables used by PivotCharts.
Impact
Cut reporting time from 6 hours to 20 minutes and improved KPI accuracy.
-
Oracle Performance Tuning
Overview
Analysed AWR reports, added composite indexes, and refactored heavy CTEs.
Impact
70% reduction in p95 query time and improved batch window reliability.
-
Hello world!
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!