Ryan Heugh

I am detail-oriented, highly analytical, and a results-driven Data Engineer with experience designing, building, and optimising data solutions in cloud and enterprise environments. I am skilled in Azure technologies, SQL development, data warehousing, ETL processes, and automation, with a strong ability to transform complex business requirements into scalable and efficient data solutions. I am passionate about leveraging data to drive business insights, improving operational efficiency, and supporting strategic decision-making innovatively.

I have many years of experience working in cross-functional teams. I enjoy continuously expanding my technical expertise in modern data engineering and cloud platforms.

Managing Director & Principal Consultant - Enigma IT Solutions - South Africa - Remote

(2026-06)

• Founded Enigma IT Solutions to provide practical technology solutions that address real business challenges.
• Collaborated with organisations to design, build, and support IT consulting, data engineering, and cloud technologies.
• Focused on delivering reliable results and long-term value while modernising existing systems and creating new solutions.

Senior Data Engineer Consultant - ITBusiness (Pty) Ltd - Hybrid

(2024-12)

Senior Data Engineer Consultant - FNB Finworx

(2025-12 - 2026-04)

Server Re-engineering project

• Migrated tables, views, and stored procedures from legacy SQL Servers to new SQL environments
• Configured data management pipelines for staging, transformation, and loading processes
• Resolved cross-server data value, volume, and quality issues
• Developed scripts to compare records, tables, views, and data quality across old and new servers
• Created automated comparison reporting to provide project visibility

Senior Data Engineer Consultant - FNB Finworx

(2025-07 - 2025-11)

Flash project

• Migrated Flash tables and stored procedures between SQL Server environments
• Configured Data Management pipelines to automate sequential and parallel stored procedure execution
• Developed telemetry procedures and monitoring tables for runtime tracking and issue identification
• Resolved migration-related data issues
• Built an automation tool for: Pipeline configuration creation, Enabling and disabling pipelines, Automated testing and result collection
• Developed a collection tool to identify: Stored procedures using Teradata feeds, All associated tables used within procedures
• Improved troubleshooting efficiency and reduced turnaround time

Senior Data Engineer Consultant - FNB Risk

(2024-12 - 2025-06)

• Developed and maintained regulatory reporting solutions for the FIC
• Ensured accurate and timely submission of compliance reports
• Sourced data from multiple IT teams and integrated it into a local MS SQL data warehouse
• Developed ETL packages using SSIS

Consultant Developer Team Lead - MTN

(2022-10 - 2024-11)

• Developed Oracle stored procedures for the Yellobucks rewards platform
• Automated rewards allocation based on customer preferences and campaign participation
• Built Hive views and Power BI dashboards for MTN insurance products, including: Quotations, Sales, Claims, Base changes
• Developed XMF REST APIs for mobile money applications
• Created automated reporting solutions using Globalscape and email distribution
• Worked on SARB compliance frameworks and KYC data quality initiatives
• Developed FICA compliance reporting and customer blocking processes
• Created Oracle procedures and APIs for transaction limitation controls
• Analysed customer journeys and customer fallout across product lifecycles
• Designed data specifications for Oracle-to-Hive ingestion processes
• Assisted with product deployment documentation, go-live monitoring, and support

Consultant Developer Team Lead - MTN

(2021-01 - 2024-11)

Consultant Developer - FNB Finance

(2020-08 - 2020-12)

• Assisted with converting SAS logic into Netezza SQL stored procedures to allow for integration of various systems into a single system
• Assisted with automating recons and other functions within the department

Consultant Developer - KwikBuild Cement

(2020-02 - 2020-07)

• Provisioned an Azure VM as well as storage accounts and functions
• Created scheduled backups and restores, as well as triggered executables to move data from client source systems to the Azure VM
• Built a normalised data warehouse for them in Azure SQL VM using data ingested from their environment (including all tables, views and stored procedures required for reporting)

Consultant Developer - Consultant Developer

(2020-01 - 2022-09)

Senior Analyst: Data Visualisation - Standard Bank South Africa

(2018-07 - 2019-12)

• Developed data quality solutions through software engineering for Enterprise Information Management (EIM)
• Created and maintained Qlik and Power BI dashboards
• Built and maintained data marts and profiling solutions
• Automated operational tasks to improve efficiency
• Developed PowerApps solutions for business process improvements
• Applied feature engineering techniques in Python to enhance customer analytics
• Built data science use cases for DQM and African regions
• Extracted and analysed social media data for customer sentiment analysis and behavioural prediction

MI Data Analyst - Standard Bank South Africa

(2015-03 - 2018-06)

• Created and maintained SQL tables and data warehouse structures
• Built SQL views to support QlikView dashboard requirements
• Developed dashboards for Financial Accounting Shared Services (FASS) and external departments
• Created Excel templates with VBA macros for data capture and reporting
• Automated business processes using SSIS packages
• Developed recurring management reports and dashboards
• Implemented and maintained Coupa data integrations across Africa
• Built an automated query resolution system for Coupa support processes

Surveillance Monitoring Officer - Sun International

(2009-04 - 2015-02)

• Monitored gaming floor operations to ensure procedural compliance
• Protected company assets in accordance with gaming regulations and company standards

Schedule Cashier - Sun International

(2008-01 - 2009-04)

• Managed front-line cash handling operations
• Facilitated secure cash flow processes across gaming floor cash points and vault operations
• Ensured compliance with gaming regulations and internal standards

BCom - Financial Management - University of South Africa (UNISA) (2014)

Matriculation - Fields College (2007)