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