Boitumelo Khaba

Data Analyst • Johannesburg, GP, ZA

Python

Data Cleaning

Data Mining

ETL

Programming

Microsoft Azure

PowerBI

SQL

Available for hire fromNegotiable

Contracts

Experienced data analyst with a passion for data analytics, business intelligence, and data engineering

Experienced data analyst with a passion for working with data. With a background in data analytics, business intelligence, and data engineering, I aim to provide value to the companies and clients I work for. I believe in data being a tool to unearth valuable insights to problems that need solutons.

Projects

Communications' Migration

A company required the architecture it used to send communications such as letters to be migrated to modern cloud architecture. The project involved using ETL techniques to move data from the client's environment into a tool that generates PDFs using JSON data. The technologies used in this project include: Azure SQL Databases and SQL Azure Data Factory Azure API Manager Dotnet Core Rest APIs Additional tools used for vetting data quality were SQL and PowerBISee More

Business Intelligence Reporting

This project involved migrating data to a new ERP system and generating reports for business users to use as a part of their analysis. I was required to generate SQL queries that would produce the expected results for various reports. I was also involved in analyzing business requirements and ensuring that they align with the expectation of both business users and the report development team.See More

Report Automation

The aim of this project was to automate a report that was created manually from various CSV files and SQL data. Using C# and Selenium for web scrapping, I created a program that automatically downloaded the CSV files from a transactional ERP system and loaded them into a file share. Using Python for data cleaning, I managed to ensure that the data in the CSV files held integrity and was "clean" enough to be loaded into an on-premise SQL Server database. The data was modeled in Power Pivot in Excel. See More

Work History

Data Engineer

Entelect SoftwareApr 2022 - Present • 2 yrs 6 mosInvolved in a project that included using C#, Rest APIs, SQL, and Azure Data Factory an ETL tool to provide JSON data to a workflow orchestration tool that composes PDF statements

Programmer Analyst

Growthpoint PropertiesFeb 2018 - Mar 2022 • 4 yrs 2 mos• Assisting with the development and code maintenance of existing Business Intelligence solutions and applications • Providing technical support to the application help desk for technical user queries • Assisting with MRI (property management system) report development and maintenance using SQL queries • Maintaining, testing, and debugging an SSIS ETL solution that loads data from CSV files sourced from Fraxion through automation using Selenium and C# • Maintaining an Excel Power Pivot report that sources data from an on-premises database used for spend-analysis • Aiding fellow team members with code debugging and testing • Developing and maintaining business reports centered around financial data from the company’s General Ledger and tenant recurring charges using SQL

Education

University of Johannesburg

BSc Computer Science and Informatics, Computer SciencesFeb 2015 - Dec 2017

Similar Pangeans

How Pangea Works

Effortlessly discover top talent

We’ve distilled the candidate search from endless hours down to just a few minutes. Using Pangea’s AI-powered search tools, you can find top fractional talent able to take on your next project. Our system looks at your company’s niche and your needs to find the perfect match faster than any traditional hiring platform.

Start working with talent today

The top talent on Pangea is ready to get started with you right now. You can message or hire a candidate right from their profile page and start assigning work as soon as they respond. And the best part? Pangea’s fractional contract structure lets you start small and ramp up as your needs change, keeping your costs manageable and your team’s capabliities flexible.

Track work and invoices in one place

Assign tasks, track progress, and complete invoices all on Pangea. We’ve combined every part of the hiring process into one platform to eliminate the miscommunication that’s unavoidable on other freelance platforms. We even send out 1099s to your contractors at the end of the year!

Talk with a Talent Expert

Members of our team are available to help you speed through the hiring process.

Available Now

Book a Call

Experienced data analyst with a passion for data analytics, business intelligence, and data engineering

Talk with a Talent Expert

Members of our team are available to help you speed through the hiring process.

Available Now

Book a Call

Similar Pangeans

Ahmad Bukhari

Data Analysis • Business Intelligence • Sales & Business Development • 5 years of exp. • Islamabad, Islamabad Capital Territory, PK

Robelle Borjal

Experienced Data Analyst proficient in Power BI, R programming, and event management, seeking opportunities to excel in data and business analytics.

Data Analysis • Community Management • Operations Management • 1 years of exp. • Muscat, Muscat Governorate, OM

Viola M

I am a true data enthusiast having immense passion in conducting user and product research. I have experience of working on gaming and e-commerce data

Data Analysis • AI & Machine Learning • Product Analysis • Cupertino, CA, US