Charles Tshegofatso Diale

Junior Data Analyst

Experienced Junior Data Analyst with proven expertise in designing and deploying Power BI dashboards and optimizing SQL data models. Demonstrated success in automating reporting processes and ensuring data integrity across large datasets, facilitating compliance with governance standards. Committed to driving data-informed decision-making and enhancing operational efficiency for organizations. Known for strong analytical skills and effective stakeholder communication.

Pretoria, Gauteng, South Africa
0
Language
0
Skills
0
Certifications
Work Experience
Junior Data Analyst
Raltech Solution
Jun 2025 — Jun 2026
  • Designed and deployed Power BI dashboards supporting Sales, Operations and Executive Management
  • Built optimized SQL, Power Query and DAX data models using Star Schema principles
  • Automated reporting processes using Microsoft 365 and Dynamics 365
  • Delivered forecasting, trend analysis and SLA performance reporting
  • Facilitated stakeholder meetings to translate business requirements into data-driven reporting solutions
  • Produced documentation, data dictionaries and reporting standards to improve solution adoption
Technical Support Specialist
Raltech Solution
Jan 2025 — Jun 2025
  • Supported more than 300 Microsoft 365 users across multiple business functions
  • Administered Microsoft Entra ID and Exchange Online environments
  • Implemented Dynamics 365 CRM migration consolidating over 2,500 customer records
  • Integrated Microsoft Teams Calling solution improving customer engagement
  • Reduced issue resolution time through process improvements
  • Managed over 200 monthly support tickets while maintaining SLA compliance
Business Analyst
Netcampus Group
Feb 2024 — Feb 2025
  • Authored Business Requirements Documents (BRDs) and maintained project repositories to ensure strict requirements traceability
  • Formally validated 500+ records within a 5,000-record government dataset, ensuring 100% compliance with data governance standards
  • Managed stakeholder reporting and communication channels to seamlessly bridge technical teams and corporate business units
  • Analysed "As-Is" workflows and documented "To-Be" process improvement initiatives to optimize operational efficiency
Operations Manager
Vistec International Security Technologies
Feb 2022 — Oct 2022
  • Engineered end-to-end security infrastructure, integrating IP-based CCTV, biometrics, and alarms for seamless IT environment synergy
  • Spearheaded full project lifecycles from site surveys to final commissioning, consistently delivering installations on schedule and within budget
  • Enhanced system performance through advanced root-cause analysis, significantly boosting uptime for high-security client sites
  • Acted as primary technical liaison, transforming complex stakeholder requirements into scalable, cost-effective security solutions
  • Implemented rigorous quality control and regulatory compliance while managing vendor relationships and overseeing on-site installation teams
Administrative Assistant
St. Catherine Primary School
Jul 2010 — Jun 2021
  • Spearheaded administrative operations for 1,300+ student records, ensuring unwavering data integrity and confidentiality, resulting in zero data breaches over 11 years
  • Directed core financial functions, including procurement and budget tracking, ensuring fiscal compliance and precision while managing annual budgets exceeding R5M
  • Engineered optimized office workflows, streamlining correspondence and filing systems to enhance operational efficiency by 30%
  • Delivered technical support and training for staff on Microsoft 365, elevating team proficiency and software utilization by 50%
  • Acted as the primary liaison for over 200 parents, suppliers, and stakeholders, consistently upholding exceptional standards of professional communication and service
Skills
Power BISQLPower QueryDAXDynamics 365Business AnalysisData VisualizationStakeholder ManagementData CleaningTechnical SupportPythonMicrosoft 365 AdminMicrosoft WordMicrosoft ExcelMicrosoft Power PointMicrosoft Power BIMicrosoft TeamsMicrosoft SQLMicrosoft Dynamic 365Critical ThinkingCommunication SkillsProblem Solving
Education
Bachelor of Science, Computing
University of South Africa
N4 Financial Management
Orbit FET College
National Senior Certificate
Saint Teresa High School
Certifications
Information Technology Short Learning Programme
Boston City Campus and Business College
Entry Certificate in Business Analysis (ECBA)
International Institute of Business Analysis (IIBA)
Microsoft Certified Technology Specialist
Microsoft
AI Starter Kit
ALX Africa
Microsoft AI Fluency
Netcampus Group
GenAI for Software Engineers
WeThinkCode_
Full Stack Development
FNB App Academy
Esports Management and Game Development
HP
References
Mandla Matlou
Director · Raltech Solutions
Former Director
[email protected] · 076 879 0948
Fahaad Noormahomed
Operations Manager · Vistec International Security Technologies
Former Director
[email protected] · 083 443 8178
Dr M.J Mokoena
Supervisor · St. Catherine Primary School
Former Supervisor
[email protected] · 064 516 5310
Languages
English
Fluent