Experience

Education

– Cloud Migration
– Migration to D365 F&
– Operational Reporting
– Financial Dashboard & Reporting

Azure, Synapse, DevOps, Power BI, D365 F&O

Banking

– Data Migration
– Data Modelling

DevOps Power BI

Beverage/ Consumer

Reporting Monitoring & business Intelligence setup SSIS, Jira, Power BI, Logic Apps, SharePoint, AzureDB, Oracle

CCBA Project

Health

– SSIS, Jira, Power BI, Logic Apps, SharePoint, AzureDB, Oracle

Telecommunications

Power BI, Oracle, SharePoint

Health (Government)

ADF, Synapse, DevOps, Power BI, SSIS Bring Data Home

Transportation

SSIS, Jira, Power BI, Logic Apps, SharePoint, AzureDB, Oracle

Mineral resources (Government)

DevOps, Power BI

Education (Government)

DevOps, Power BI, SSIS

Mineral resources

SSIS, Jira, Power BI, Logic Apps, SharePoint, AzureDB, Oracle

Telecommunications

-Cloud Migration

Insurance

Data Enginer SSIS, Jira, Power BI, Logic Apps, SharePoint, AzureDB, Oracle

1. Coke – CCBA Project

Designing and building modern data pipelines and data streams.
Create and maintain data service APLs.
Use Power BI, zure APL Apps, or any modern visualization tool or experience to provide data to end users.
Support data platform services planning and implementation, including sizing, configuration, and needs assessment.
Analyses current business practices, processes, and procedures as well as identifying future business opportunities for leveraging Microsoft Azure Data and Analytics Services.
Working hand-in-hand with the BI developers deploying data pipelines and data transformations which turns the raw data into relevant datasets and insights (e.g., using Databricks or Azure Data Factory)
Developing reusable stored Procedure and functions.
Put in Place effective metrics and monitoring systems.
Define and implement a robust, scalable, pragmatic, and realistic cloud solution that works for our clients.
Design and implement cloud solutions which are secure, scalable, resilient, monitored auditable and cost optimized.
Provide systems support including responding to monitoring alerts.
Write application deployment automation using industry standard deployment and configuration tools.
Implement and stay abreast of cloud and DevOps industry best practices and tooling.

1.ADV-Tech– Finance and Integration Project

July 2022-To present.

Architect, design, implement migration of Stays into D365.
Setup integration of D365 into Data Lake.
Ingest Data Lake into dedicated instance using ADF.
Build Power
Build Power BI dashboards.
Create views, tables & stored procedures based on clients’ requirements.

1. Capitec– Data migration

March 2022- July 2022

Data modelling which involves data investigating for table that where being migrated to the AWS cloud.
Using the Technology’s where used ER studio, Collabra and manta.
Used data validation for the tables being migrated.
Using AWS Athena s3 baccate and amazon red shift.

1. Discovery

Other responsibilities include extracting data, troubleshooting, and maintaining the data warehouse.
Design and Build SSIS Packages.
Translate business needs to technical specifications.
Create technical documentation for BI environments.
Perform SQL queries – design, code, test.
Monitor ETL and SQL server jobs.
Troubleshooting of SSIS Packages.
Deploy SSIS Packages.

1. GEMS– Data Ingestion & ETLs

30 June 2022- To project

Azure DevOps – Automated Testing.
Creation of Synapse Workspace.
Quality Dashboard Data Ingestion.
Mapping of HWSS: Source to Target Mapping.
Identify Azure Services that are in SA Regions.
Synapse Data Import.
GEMS Data Warehouse and GEMS Azure Environment.
Data Ingestion & ETLs.
Analysis of the Extract SSIS Packages
Enable GEMS to be the custodian of their data.
Have easy access to reports and analytics.
Sourcing Data from SPN.
Creation of Operational Data Warehouse and BI Semantic Layer.
Provision of Analytics and Reporting.

1. Imperial

February 2023

Creating Azure Databricks notebook using sql and python
Creating Azure Data Factory pipelines.
Assuring that data is cleansed, mapped, transformed, and otherwise optimised for storage and use according to business and technical requirements.
Develop and maintain innovative Azure solutions.
Solution design using Microsoft Azure services and other tools.
The ability to automate tasks and deploy production standard code (with unit testing, continuous integration, versioning etc.)
Load transformed data into storage and reporting structures in destinations including data warehouse, high speed indexes, real-time reporting systems and analytics applications.
Build data pipelines to collectively bring together data.

1. MTN

April 2022- To present.

Generate scripts and power BI reports that are based on the campaigns that the business requires.
Creating architecture diagrams pulling manual reports on dbeaver.
Creating scripts and updating them.
Updating the octane based on the project that is assigned to.
Validate Deployed reports and data for specific.
Creating wiki pages with source information from the projects

1. MinTek– Developer Integration Specialist

Jan 2023- March 2023

Developer Integration Specialist within the Information and Communication Technology Division

1. QCTO

April 2022- To Present

working on price comparation according to region on azure calculator.
worked on ETL staging first, ensure that they run correct and scheduled and documented before we move on to DW, we also did the contact list for SharePoint list.
Setup access cloud.

1.Trimble- Power BI

December 2021- July 2022

Build and deploy SSAS tabular cubes.
Power BI Embedded Implementation
Develop SSRS reports from SQL Server databases.
Deploy SSRS reports.
Bitbucket source control.
Power BI development.
Collaborate with other teams to meet the needs of customers.

1.Old Mutual– Data Enginer

February 2023- To Present

Creating architectural designs using Visio and draw.io
Investigating core data sources for applications
Conducting research and analysis in order to document all data sources in relation with the business application.