Trevor Letswalo

Results-driven Data Analyst and Reporting Specialist with over 4 years of experience in data analysis, reporting, stakeholder management, and quality assurance across banking and IT asset management. Skilled in Power BI, SQL, Excel, and ServiceNow reporting, with a track record of turning data into actionable insights that improve operational visibility and decision-making. Experienced in building dashboards, automating reporting workflows, and collaborating with cross-functional teams to deliver accurate reporting solutions.

ITAM Data Analyst / BI Developer - Alviva Holdings (Client: Rand Merchant Bank) - Johannesburg

(2024-12)

• Engineered weekly and monthly Power BI dashboards and ServiceNow reports for IT asset lifecycle, SLA compliance, and operational metrics.
• Collected and translated requirements across Finance, Procurement, Security, and Operations teams to improve reporting accuracy.
• Performed quality assurance checks on dashboards and reports to ensure completeness and correctness before deployment.
• Analyzed IT asset inventory data (~10,000 assets) to identify trends and support forecasting for Finance and Procurement.
• Built reporting outputs using Power BI, SQL, and Excel to support executive decision-making.
• Reduced reporting query turnaround time by 40% through ad hoc data analysis and issue resolution.
• Developed documentation including data dictionaries, workflows, and user guides.
• Automated ETL and data refresh workflows, reducing manual reporting effort by 65%.
• Improved SLA monitoring accuracy by 30%.

Junior Process Analyst / Call Centre Reporting Analyst - African Bank - Johannesburg

(2024-03 - 2024-11)

• Built and maintained Power BI dashboards tracking SLAs, call abandonment rates, campaign performance, and agent productivity.
• Collaborated with operations, IT, and management teams to gather requirements and improve reporting processes.
• Conducted UAT testing, defect logging, and validation of reporting outputs.
• Produced structured reporting packs with insights and recommendations.
• Facilitated stakeholder workshops and training sessions.
• Documented processes to improve workflow efficiency.

Customer Retention Consultant - African Bank - Johannesburg

(2022-02 - 2024-02)

• Analyzed customer data to identify cancellation drivers and retention opportunities.
• Handled customer queries and escalations within SLA targets.
• Applied retention strategies including upselling and service adjustments.

Certificate - Data Science Practitioner (NQF 5) - APEX Business Academy