I architect highly resilient, multinational Microsoft BI ecosystems that enforce strict Row-Level Security and establish an unshakeable source of truth for actuaries and executives.
Legacy transactional databases overwrote historical contract states, destroying policy lifecycles. Furthermore, disparate regional systems across Botswana, South Africa, and Zambia caused severe cross-border KPI conflicts.
I engineered over 30 SSIS orchestration packages to extract and parse 115 million flattened audit trails, reconstructing history into a specialized SQL snapshot database, governed by SSAS tabular models with strict RLS.
Centralized over 20 million contract records into a single SQL Server environment. Automated the reporting cadence entirely, stripping manual Excel compilation out of the business operations.
"Sandile took absolute ownership of the architectural delivery for one of our most complex multinational engagements. His ability to untangle legacy data and engineer a highly scalable SSIS and Tabular pipeline not only recovered critical operational history but set a new standard for our technical deployments."
— Principal BI Consultant, Corporate Analytics Firm