Top Talent like Boitumelo are on Pangea

Pangea, a YC company, connects companies with fractional talent. Fractional hiring allows companies to move faster and work with more specialized talent, while giving talent more flexibility and independence. If you are talent open to fractional work, apply here. If you’re a company looking for high-quality fractional talent, learn more here.

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

E

Data Engineer

Entelect SoftwareInvolved 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
G

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

U

University of Johannesburg

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

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
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.

Talk with a Talent Expert

Members of our team are available to help you speed through the hiring process.
Available Now
Book a Call

Top Talent like Boitumelo are on Pangea

Pangea, a YC company, connects companies with fractional talent. Fractional hiring allows companies to move faster and work with more specialized talent, while giving talent more flexibility and independence. If you are talent open to fractional work, apply here. If you’re a company looking for high-quality fractional talent, learn more here.

Boitumelo Khaba

Data Analyst • Johannesburg, GP, ZA
Python
Data Cleaning
Data Mining
ETL
Programming
Microsoft Azure
PowerBI
SQL
Available for hire fromNegotiable
Contracts

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 PowerBI

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.

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.

Work History

E

Data Engineer

Entelect SoftwareInvolved 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
G

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

U

University of Johannesburg

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

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
Pangea empowers fractional work across the world for marketing and design roles.