Skip to main content
Otshepeng Ditshego

Otshepeng Ditshego

Business Intelligence Developer | Data-Driven Innovator | Team Mentor

Midrand, City of Johannesburg Metropolitan MunicipalityMember since January 25, 2026
Power BISSISSSASETLSQLC#Microsoft AzureDevOpsCommunication
·

About

Dynamic and results-driven Business Intelligence Developer with 8+ years of experience in designing, developing, and leading end-to-end BI solutions across telecommunications, consulting, and public sector environments. Proven track record of transforming complex data into strategic insights, optimizing data pipelines, and driving automation that improves operational efficiency. Recognized for mentoring BI teams, fostering data literacy among stakeholders, and delivering high-impact Power BI and SQL-based solutions that empower data-driven decision-making.

Experience

Field Support Engineer - Department of Justice National Office

(2025-10)

  • Ensured stability and efficiency of ICT infrastructure through proactive technical support and troubleshooting.
  • Performed system upgrades, including operating system installations and hardware enhancements, to optimize IT infrastructure.
  • Prepared detailed documentation of project milestones, outcomes, and stakeholder sign-offs to facilitate progress tracking and reporting

BI Developer (Consultant) - Rifumo Holdings

(2024-08 - 2025-05)

  • Designed and implemented BI solutions and Power BI dashboards across HR, Finance, and Online Admissions data.
  • Engineered automated ETL pipelines and OLAP cubes (SSAS) for real-time reporting and improved data governance.
  • Led documentation and process standardization for BI systems to support scalability and knowledge transfer.
  • Mentored BI analysts, driving consistency in development practices and quality assurance.
  • Streamlined system monitoring and proactively resolved performance issues using custom-built scripts.
  • Key Impact: Delivered automated BI infrastructure that improved data refresh reliability by 80%.

Power BI Developer (Freelance) - Kelani Consulting

(2023-04 - 2024-07)

  • Partnered with business units to translate analytical requirements into actionable BI deliverables.
  • Built and automated Power BI dashboards measuring KPI performance for the Gauteng Partnership Fund (GPF).
  • Conducted data integration and cleansing from Excel and CSV sources into SQL Server.
  • Designed user training programs and documentation to enhance data literacy.
  • Key Impact: Reduced manual report creation by 70% and delivered dashboards adopted company-wide.

Data Analyst / BI Developer - Telkom Openserve

(2017-01 - 2023-03)

  • Spearheaded the development of automated Power BI dashboards and reporting tools for Telkom's executive teams.
  • Delivered predictive analytics and trend analyses to optimize operations and resource allocation.
  • Developed ETL pipelines integrating SQL, APIs, and flat files to streamline reporting.
  • Supervised small project teams under the Emergency Management Team, creating dashboards for site back up generators and COVID-19 reporting.
  • Key Impact: Drove data automation that cut manual processes by 50%, enabling faster business response times.

HR Assistant (Learnership) - Coca-Cola Beverages South Africa

(2016-02 - 2016-12)

  • Supported HR operations including recruitment, payroll, and SAP reporting.
  • Enhanced HR data management through improved documentation and reporting processes.

Education

Bachelor of Information Science - Business & Competitive Intelligence, Database Design & Implementation, Software Development Life Cycle, Project & Communication Management, Information and Know - University of Pretoria (2014)

Matric NSC - Wallmansthal High School (2010)

Skills

Business Intelligence DeveloperData-Driven InnovatorTeam Mentor

Reviews