Lesego Mokhati

BCom Statistics graduate at UP, hands-on working experience in data mining, extraction, transformation, data quality and validation, data modelling as well as data visualization and using SAS, SQL, Python, R and business intelligence in my current role as a Data Analyst Intern at Wild Impact, where I clean and transform raw datasets, develop data models, validate data, automate reporting and build Power BI dashboards. Strong foundation in ETL/ELT, data pipelines, data warehousing concepts, cloud-based data environments and Python-based data processing, supported by Data Engineering Essentials training. I also bring financial-services experience from banking, insurance and financial advisory, as I understand that data engineering is not only about building pipelines; the data ultimately needs to provide accurate data-driven business decisions, mitigate risks, and better business outcomes for clients.

Therefore, ensuring data protection, privacy, regulatory requirements, data lineage and governance is a critical issue in financial-services analytics when working with banks and insurance companies. Therefore, building robust ETL/ELT, pipelines, reliable cloud-based platforms using Microsoft Fabric and data modelling will add strong business protocols and data integrity in the financial-services analytics field which PwC operates in.

Data Analyst Intern - Wild Impact - Sandton

(2026-01)

• Develop and maintain data models supporting business intelligence, reporting and strategic decision-making.
• Extract, clean, transform and normalise raw datasets using Python, Pandas and Power Query, including large Excel datasets.
• Perform data validation and reconciliation using SQL and advanced Excel functions to identify inconsistencies and improve data quality.
• Use Python libraries including NumPy, Pandas and Matplotlib to analyse trends, patterns and anomalies and prepare decision-ready datasets.
• Retrieve and work with data from MySQL and cloud-based environments including Azure/Oracle exposure.
• Build Power BI dashboards and DAX measures to provide interactive reporting and real-time visibility into business performance.
• Automate recurring reporting and analysis using PivotTables and Power Query, improving reporting efficiency and reducing manual processing.
• Collaborate with stakeholders to translate data into actionable insights and evidence-based recommendations.

Risk Consultant – Financial Advisory - PPS - Parktown

(2025-03 - 2025-12)

• Built Excel-based financial models and budget-management tools to analyse expenditure, investment projections and client financial outcomes.
• Performed financial needs analysis and portfolio reviews using historical trends and quantitative analysis.
• Prepared presentations and communicated analytical findings to clients and stakeholders.
• Applied structured problem-solving and data analysis within a regulated financial-services environment.

Banker - Discovery - Sandton

(2025-01 - 2025-03)

• Captured, maintained and verified client banking records, supporting data integrity and regulatory compliance.
• Analysed client profiles and maintained accurate information in line with KYC/FICA requirements.
• Handled account and profile updates while maintaining information-management standards.

Retentions Professional - Prime Meridian Direct - Bryanston

(2023-05 - 2024-04)

• Managed high-volume client and policy data, updating records and resolving payment and policy discrepancies.
• Used Excel to calculate pro-rata amounts and partial refunds and support accurate client account reconciliation.
• Applied analytical and problem-solving skills to investigate client queries and improve resolution outcomes.

BCom Statistics - Statistics - University of Pretoria (2018-02 - 2022-11)