Summary
Overview
Work History
Education
Skills
Certification
Timeline
Personal Information
References
Generic

RIRHANDZU MELVA MAHLAULE

Cape Town,WC

Summary

Proactive and committed Business Intelligence and Sales Analyst with hands-on experience in key tools such as Power BI, SAP BI, Azure Data Factory, SQL, and Advanced Excel. I am adept at developing impactful dashboards, streamlining data pipelines, and transforming complex data into strategic insights. My professional strengths lie in my keen attention to detail, my ability to communicate effectively with stakeholders, and a passion for continuous learning and improvement. I am also adaptable, a strong team collaborator, and a creative problem-solver.

Overview

6
6
years of professional experience
1
1
Certification

Work History

BI Developer

EXL Services
07.2024 - Current
  • In my current role, I am responsible for developing RFCs to transport data between development, testing, and production environments.
  • I create and maintain stored procedures in Azure Data Factory (ADF) pipelines to load aggregated data efficiently from source to destination tables.
  • My work includes maintaining and enhancing the open deliveries Power BI report.
  • I have also mentored new interns, providing guidance on data analytics, query building, and Power BI best practices.
  • A key project involved designing queries in SAP S/4HANA for Procurement Human Rights Due Diligence, which provided total spend analysis by vendor.
  • I used this data to develop Power BI reports that integrate spend data with risk assessment information for comprehensive supplier evaluation.

Power BI Analyst

Sebenzela
10.2023 - 06.2024
  • As a Power BI Analyst, I developed a dashboard to track and analyze the performance and competencies of sales representatives.
  • I collaborated with cross-functional teams to translate their business requirements into effective visualizations and reports.
  • I also assisted in creating and managing Power BI dashboards for tracking key performance indicators (KPIs).
  • Bridged communication gaps between technical and non-technical stakeholders by translating complex data concepts into easily understood terms, fostering a shared understanding of project goals and objectives.
  • Collaborated with cross-functional teams to identify opportunities for process improvements, driving increased operational effectiveness.

Quality Analyst

Genpact
04.2022 - 10.2023
  • At Genpact, I managed and analyzed data through modeling and simulation, and I used creative data visualization techniques to derive actionable insights using Power BI, SAP, and Excel.
  • I delivered effective presentations with data and graphics to communicate insights for decision-making.
  • I successfully implemented an automated Power BI Bank Reconciliation dashboard that shrank team workload by 85% and reduced errors by 90%.
  • I also designed and developed ETL data transformation and management processes.
  • I engineered a comprehensive Power BI reconciliation tracker dashboard for automated completeness tracking and CPS KPI measurement, which reduced errors by 90% and shrank team workload by 75%.
  • Additionally, I created and deployed a Power BI dashboard to track GRIR Clearing and overdue payments, enabling my team to resolve overdue payment issues 70% faster.
  • Provided detailed reports on quality metrics to senior management, enabling informed decision-making regarding process improvements.

Finance BI Analyst

Bidvest Bank
12.2021 - 03.2022
  • I utilized SQL to extract and manipulate customer transaction data, which resulted in a 20% improvement in fraud detection accuracy.
  • I created dynamic Power BI dashboards to monitor branch performance and customer trends, facilitating strategic decision-making.
  • I also wrote SQL scripts to retrieve customer call center data for daily call summaries and presented the outcome using a Power BI dashboard.

Software Development Intern

Bidvest Alice
03.2021 - 11.2021
  • During my internship, I created a custom Flowgear connector that pulls data from the Lansweeper platform to our company platform.
  • I also developed a Python script that pulls data from the Lansweeper database and an SQL script to write and constantly update the data in the company's data warehouse.
  • I produced a Power BI dashboard for an audit spin on the data to outline the risk rating of companies based on their on-premises IT environment, with the report done according to the NIST Framework.
  • Worked closely with peers to identify issues and provide suitable resolutions.
  • Shadowed team members to learn new tasks and how to appropriately handle technical issues.

Data Science Intern

Explore Data Science Academy
01.2020 - 11.2020
  • As a Data Science Intern, I built a Python package with functions to calculate metrics using Eskom's Twitter data.
  • I also constructed an ETL pipeline that scraped and cleaned data and created an ERD (Entity Relationship Diagram) using MS SQL.
  • I assembled an informative Power BI dashboard to draw insights from data to help determine company priorities, and I established a regression predictive model to estimate the delivery time of an order for a logistics company.
  • My work also included creating a Streamlit app and multiclass classification predictive models to predict whether a person believes in climate change based on their Twitter data.
  • Optimized machine learning models for improved prediction accuracy and performance.
  • Utilized programming languages such as Python extensively throughout the internship – applying relevant libraries and frameworks when appropriate.

Education

Bachelor of Science - Mathematics and Information Systems

University of South Africa
12-2028

National Certificate - Information Technology and Software Development

Explore Data Science Academy
12.2020

N6 Certificate - Electrical and Electronics Engineering

Sedibeng TVET College
12.2015

National Senior Certificate - Matric

Kwa-Bhekilanga Secondary School
12.2013

Skills

  • ETL development
  • Data quality management
  • SQL programming
  • Power BI
  • Business intelligence tools
  • Data modeling
  • SAP S/HANA
  • BI strategy development
  • Teamwork
  • Problem-solving
  • End user support
  • Python

Certification

  • AZ-900 (Microsoft Azure Fundamentals)
  • Flowgear certification

Timeline

BI Developer

EXL Services
07.2024 - Current

Power BI Analyst

Sebenzela
10.2023 - 06.2024

Quality Analyst

Genpact
04.2022 - 10.2023

Finance BI Analyst

Bidvest Bank
12.2021 - 03.2022

Software Development Intern

Bidvest Alice
03.2021 - 11.2021

Data Science Intern

Explore Data Science Academy
01.2020 - 11.2020

National Certificate - Information Technology and Software Development

Explore Data Science Academy

N6 Certificate - Electrical and Electronics Engineering

Sedibeng TVET College

National Senior Certificate - Matric

Kwa-Bhekilanga Secondary School

Bachelor of Science - Mathematics and Information Systems

University of South Africa

Personal Information

Availability: upon notice

References

  • Ebrahim Padia, Genpact, Senior Manager Lean Digital Transformation Black Belt, 066 000 7484, epadia@gmail.com
  • Johan Du-Plooy, Ardagh Glass Packaging - South Africa (EXL Services SA), Group IT Team Lead, BI- SA BI Systems, +27 833829010, Johan.Du-Plooy@ardaghgroup.com
RIRHANDZU MELVA MAHLAULE