Summary
Overview
Work History
Education
Skills
Timeline
Generic

ROBIN TROY CHAKA

Centurion

Summary

Dynamic and results-driven Business Intelligence Developer with 8+ years of experience in data analytics, BI reporting, and enterprise data solutions across insurance and financial services. Expert in Power BI (DAX, Power Query M, Tabular Models), SQL/T-SQL, and advanced data modeling, with proven success delivering scalable, secure, and insight-driven solutions. Skilled in Azure Synapse, Data Factory, and SQL Server, with transferable expertise to Snowflake-based architectures. Experienced in AI-driven analytics in Power BI (AI visuals, smart narratives, decomposition trees) to enhance data storytelling. Adept at enforcing data governance, version control (TMDL, SSAS Tabular Models), and best practices for performance optimization (including use of tools such as Measure Killer). Strong communicator with a track record of translating business requirements into impactful BI solutions that drive strategic decision-making.

Overview

9
9
years of professional experience

Work History

Senior BI Developer

PPS Insurnace
Johannesburg
01.2023 - Current
  • Designed and deployed enterprise Power BI dashboards, delivering real-time insights across the insurance value chain.
  • Built and optimized data models using DAX, Power Query M, and Tabular Models, applying best practices for scalability, usability, and governance.
  • Collaborated with actuarial, claims, and finance teams to translate requirements into BI solutions that improved operational efficiency and regulatory compliance.
  • Developed and optimized SQL/T-SQL stored procedures and database objects, improving query performance, and enabling faster analytics.
  • Applied AI visuals, smart narratives, and Q&A features in Power BI to enhance insights and improve data storytelling.
  • Managed Azure Synapse and Data Factory pipelines for ETL and data warehousing, with transferable expertise to Snowflake dynamic tables and views.
  • Implemented TMDL concepts through tabular model management and version control, ensuring consistency and maintainability of datasets.
  • Performed advanced Excel analysis (pivot tables, VLOOKUP, Power Query) for ad-hoc reporting and executive decision support.
  • Mentored junior developers on DAX optimization techniques and leveraged tools such as Measure Killer to streamline report performance.
  • Enforced data governance practices including dataset documentation, role-level security, and compliance with organizational standards.

BI Developer/Data Analyst

Growthpoint
Johannesburg
12.2019 - 12.2022
  • Developed T-SQL queries, stored procedures, and views to support financial reporting and analytics.
  • Engineered data pipelines and ETL processes improving accuracy and reducing report refresh times by 30%.
  • Collaborated with stakeholders to translate business requirements into BI solutions and visualizations.
  • Conducted data modeling and database optimization to support property portfolio analytics.
  • Delivered Power BI dashboards for asset tracking, financial reporting, and operational KPIs.
  • Introduced task automation using SQL and Python, reducing manual reporting overhead.

Software Developer

Daisy Business Solutions
Johannesburg
12.2016 - 12.2019
  • Designed, developed, and maintained enterprise system applications tailored to ERP and CRM environments.
  • Built and optimized SQL databases, stored procedures, and functions, ensuring data consistency and performance.
  • Developed data warehouse solutions to support reporting and analytics across multiple business units.
  • Created ETL workflows for data migration and integration between legacy and new systems.
  • Led requirements gathering sessions with stakeholders to translate business needs into technical solutions.
  • Contributed to the full software development lifecycle (design, coding, testing, deployment, and support).
  • Documented system architectures, processes, and procedures to ensure maintainability and knowledge transfer.
  • Collaborated with cross-functional teams to integrate applications, reporting tools, and data services.

Education

Bachelor of Computer Science - Software Engineering

The Belgium Campus
Pretoria, Gauteng
12.2022

Grade 12 -

Pretoria Technical High School
Pretoria, Gauteng
12.2016

Skills

Business Intelligence & Analytics
  • Power BI (DAX, Power Query M, AI Visuals, Smart Narratives, TMDL, Measure Killer)
  • SSRS, SSAS, Excel (PivotTables, VLOOKUP, Power Query)
Data Engineering & Warehousing
  • SQL/T-SQL, Data Modeling, ETL Pipelines
  • Azure Synapse Analytics, Azure Data Factory, Snowflake (transferable expertise)
  • Data Governance, Version Control, Performance Optimization
Cloud & DevOps
  • Microsoft Azure, Azure DevOps
  • Docker, Kubernetes, Jenkins
Programming (Supporting BI/ETL)
  • Python, C#, NET Framework, R, Java, JavaScript (React, Angular, Vue)
Other Tools & Platforms
  • Jira, ERP Systems, CRM Systems, Automated Testing Frameworks

Timeline

Senior BI Developer

PPS Insurnace
01.2023 - Current

BI Developer/Data Analyst

Growthpoint
12.2019 - 12.2022

Software Developer

Daisy Business Solutions
12.2016 - 12.2019

Bachelor of Computer Science - Software Engineering

The Belgium Campus

Grade 12 -

Pretoria Technical High School
ROBIN TROY CHAKA