Katleho Phokojoe

South Africa

@kgphokojoe

Badges

Days of Code
Days of JS
Sql

Certifications

kgphokojoe has not earned any certificates yet.

Work Experience

  • SQL Developer

    CODESEARCH•  June 2022 - November 2023•  Centurion

    Data modelling (SSIS, DAX), Create database triggers for use in automation, stored procedures, and Functions, Create views, Maintain data quality and oversee database security, Reports (SSRS), Data Integration, SQL

  • Database Developer

    BINARY INNOVATIVE TECHNOLOGY SOLUTIONS (PTY) LTD•  November 2021 - April 2022•  Midrand

    Knack and Power BI, Data modelling, Create database triggers for use in automation, Maintain data quality and oversee database security, Reports, Data Integration, Design database

  • Automation QA Tester

    BANTURE (PTY) LTD•  March 2020 - October 2021•  Remote

    Wrote, designed, and executed automated tests by creating scripts that run testing functions automatically, Maximized test coverage for the most critical features of the system, Determined the priority for test scenarios and created execution plans to implement these scenarios

  • BI/ SQL Developer

    NAMBITI TECHNOLOGIES•  October 2018 - November 2019•  Centurion

    Translated business needs to technical specifications, Designed, built, and deployed BI solutions (reporting tools), Maintained and supported data analytics platforms, Created tools to store data (OLAP cubes), Conducted Unit Testing and troubleshooting, Evaluated and improved existing BI systems, Collaborated with teams to integrate systems, Developed and executed database queries and conducted analyses, Created visualizations and reports for requested projects, Developed and updated technical documentation, Designed database tables and structures, Created views, functions, and stored procedures, Wrote optimized SQL queries for integration with other applications, Created database triggers for use in automation, Maintained data quality and oversaw database security

  • System Developer

    MPANDE TECHNOLOGIES•  August 2017 - August 2018•  Benoni

    Developed C# ASP.NET solutions for the organisation, Created in-house applications using the ASP.NET framework, Debugging and maintaining written code, Defined and organised projects on an ongoing basis, Reported and resolved issues related to ASP.NET projects, Identified and handled technical risks and issues, Worked in a Project team alongside other Developers, Provided technical support to stakeholders in the organisation, Reported on project statuses and developments to senior team members, Participated in Project meetings with management and other team members

Education

  • RICHFIELD GRADUATE INSTITUTE OF TECHNOLOGY

    Information Technology, Information Technology BSC Honors•  June 2023 - June 2024•  Percentage: 70

    BSc Honours in Information Technology Advanced Software Engineering Information and Cyber Security Information Technology Strategy Governance Research Methodology Research Project Big data Metaverse

Skills

SSMS
Git
VS Code
SQL Server 2016
Visual Studio
Jenkins
ETL
SSAS
SSRS
SSIS
Node.js
SQL
MongoDB
MySQL
ASP.NET
.Net
API
Selenium Automation Framework
C#
XML
DAX
MDX
SQL
T-SQL
JavaScript