Ronald Mamogobo

Business Intelligence Analyst with strong experience in Power BI development, SQL, and data modelling. Skilled at building end-to-end reporting solutions, automating data processes, and translating business requirements into impactful dashboards.

Background includes collections analytics at Intelligent Debt Management and Data Analytics in the financial services environment at PSG. Proven ability to support business users, resolve data issues, and create scalable analytics assets. Spearheaded the introduction of Power BI in PSG's Distribution department, improving reporting efficiency and insight delivery.

Data Analyst at PSG Financial Services (2024-12 – Present)

• Managed end-to-end data integration processes for investment and insurance datasets.
• Worked with developers to extract, transform and load data from SFTP into the CRM using Python-based ETL pipelines automated through Jenkins.
• Introduced and led Power BI adoption across the Distribution department, improving reporting efficiency and enabling self-service analytics.
• Built Power BI reports and models to support finance and operations teams. Improved data quality and reporting accuracy through validation, automation, and governance practices.
• Provided business stakeholders with actionable insights for decision-making.

Collections Analyst at Intelligent Debt Management (Pty) Ltd (2023-01 – 2024-11)

• Troubleshot, built, and maintained collections performance reports using SQL Server Reporting Services (SSRS).
• Developed interactive Power BI dashboards to measure and visualize collections performance across teams and portfolios.
• Analysed collections data to identify recovery trends and optimize debt recovery strategies.
• Conducted A|B testing to measure the effectiveness of newly implemented collections strategies.
• Prepared monthly management slide decks using Thinkcell, highlighting key performance metrics and strategic initiatives.
• Measured retention performance using cohort analysis to evaluate and refine client retention strategies.
• Collaborated cross-functionally with operations and management teams to ensure data accuracy, actionable insights, and strategy alignment.

Support Consultant Intern at WebAfrica (Pty) Ltd (2022-02 – 2023-12)

• Assisted in technical support and customer queries.
• Gained hands-on exposure to data tracking and issue resolution in an ISP environment.

Bachelor of Business Science in Finance with Accounting – University of Cape Town (2017-01 – 2022-12)