Experience

Sebenzela Sales and Merchandising

• South Africa
• Consumer Services
• 1 - 100 Employee

• PowerBi Analyst

  • Oct 2023 - Present

  Gauteng, South Africa



Genpact

• United States
• Business Consulting and Services
• 700 & Above Employee

• Quality Analyst - Management Trainee

  • Apr 2022 - Oct 2023

  South Africa Implemented an automated PowerBi Bank Reconciliation; shrank team workload by 85% and reduced errors by 90%.. Engineered a comprehensive PowerBi reconciliation tracker dashboard for automated completeness tracking and CPS KPI measurement; reduced errors by 80% and shrank team workload by 75%. Designed and deployed PowerBi dashboard to track GRIR Clearing payments and overdue payments; Enabled team to track the payments and resolve the issue of overdue payments 70% faster. Developed… Show more Implemented an automated PowerBi Bank Reconciliation; shrank team workload by 85% and reduced errors by 90%.. Engineered a comprehensive PowerBi reconciliation tracker dashboard for automated completeness tracking and CPS KPI measurement; reduced errors by 80% and shrank team workload by 75%. Designed and deployed PowerBi dashboard to track GRIR Clearing payments and overdue payments; Enabled team to track the payments and resolve the issue of overdue payments 70% faster. Developed PowerBi dashboard for invoice tracker; Enable the team to track the volume of Invoices generated daily and save at least 4 hours daily. Produced AR PowerBi dashboard for age analysis; Enable to team to track payments age buckets weekly, enable the collectors to identify top customers with overdue balances with an efficiency of 90%. Show less



Bidvest Bank Limited

• South Africa
• Banking
• 700 & Above Employee

• Data Analyst

  • Dec 2021 - Apr 2022

  Sandton, Johannesburg Building PowerBi reports for the finance team, helping them understand how the business is doing by giving them insights from the data. Created PowerBi dashboard for Bank channel utilization to show which channel is being utilized the most and generate more interests. Wrote a SQL Scripts to retrieve customer call center data show their daily call summary from the Bank customers using PowerBi dashboard. Developed SQL Scripts to create tables in the database and populate data from excel… Show more Building PowerBi reports for the finance team, helping them understand how the business is doing by giving them insights from the data. Created PowerBi dashboard for Bank channel utilization to show which channel is being utilized the most and generate more interests. Wrote a SQL Scripts to retrieve customer call center data show their daily call summary from the Bank customers using PowerBi dashboard. Developed SQL Scripts to create tables in the database and populate data from excel sheet for ATM solution and create a PowerBi dashboard to show all the activities. Show less



Bidvest Advisory Services

• South Africa
• Software Development
• 1 - 100 Employee

• Software Developer

  • Mar 2021 - Dec 2021

  South Africa Created a Flowgear custom connector that pulls data from Lansweeper platform and take it through to the company platform. Developed a python script that pulls data from Lansweeper Database and then built a SQL Script to write the data and constantly UPSERT it when new data is introduced into the company's Data warehouse. Produced PowerBi dashboard for Audit or Advisory spin on the data that obtained for MIA, outlining the risk rating of company's on premises IT environment, the report was… Show more Created a Flowgear custom connector that pulls data from Lansweeper platform and take it through to the company platform. Developed a python script that pulls data from Lansweeper Database and then built a SQL Script to write the data and constantly UPSERT it when new data is introduced into the company's Data warehouse. Produced PowerBi dashboard for Audit or Advisory spin on the data that obtained for MIA, outlining the risk rating of company's on premises IT environment, the report was done according to the NIST Framework. Show less



ExploreAI Academy

• South Africa
• Higher Education
• 1 - 100 Employee

• Data Science Intern

  • Jan 2020 - Nov 2020

  City of Johannesburg, Gauteng, South Africa Built python package containing functions to calculate metrics using Eskom twitter data. Built ELT pipeline that scrapes and clean twitter data and create an ERD using Microsoft SQL. Created an informative dashboard using Microsoft PowerBI to draw insights from given dataset for decision making purposes. Built Regression predictive model to estimate the delivery time of an order from historical data for a logistic company. Built streamlit app and multiclass classification… Show more Built python package containing functions to calculate metrics using Eskom twitter data. Built ELT pipeline that scrapes and clean twitter data and create an ERD using Microsoft SQL. Created an informative dashboard using Microsoft PowerBI to draw insights from given dataset for decision making purposes. Built Regression predictive model to estimate the delivery time of an order from historical data for a logistic company. Built streamlit app and multiclass classification predictive models to predict whether a person believe in climate change or not based on their novel twitter data. Built movie recommendation algorithm based on content or collaborative filtering capable of accurately predicting how users will rate a movie they have not yet viewed based on their historical preferences Show less