A well seasoned Data Professional with over 20 years experience. My passion is deriving business insight from multiple data sources into information that drives meaningful knowledge to make informed and actionable operational and strategic decisions.
Recently was privileged to be involved in Project Horizon at Coca-Cola Beverages Africa. A complete ERP change to Microsoft Dynamix 365 Finance and Operations as well as D365 Customer Engagement.
I was involved in processing data across all functions using Kimball Methodology.
Here are some some of the Automated Solutions Developed as Initiatives that I am particularly proud of. Kimball Methodolgy is not just Datawarehouse Fact and Dimension Design, its making sure that all the subsystems are in place and are easy to use:
· SQL Data Lineage from Sources to Target Facts and Dimensions
o Kimball - Subsystem 29: Lineage and Dependency Analyzer
· Metadata Driven Incremental Process of staging data from Serverless SQL Pool to Dedicated Pool
o Subsystem 2: Change Data Capture System
o Subsystem 30: Problem Escalation System
· Late- Arriving Dimension Identification and rectification
o Subsystem 16: Late Arriving Data Handler
· Data Duplication Detection
o Subsystem 7: Deduplication System
· Data-Profiling of Tables
o Subsystem 1: Data Profiling
· Incremental Fact Load Pattern Design
o Subsystem 13: Fact Table Builders
· Detailed SQL Stored Procedure Performance Monitoring without extra overhead tapping into sql performance system data
o Subsystem 27: Workflow Monitor
I particularly enjoy generating Cost Savings through query optimisation