Selemo Mphephuka

Automating API-to-SQL Data Pipeline – Developing SQL queries for API calls and T-SQL integration to import data and daily API CSV responses into SQL server, improving data refresh reliability. Designing and optimizing T-SQL queries, stored procedures, functions and views to improve performance. Automating data loading and transformation into SQL Server for business reporting.

SQL/BI Developer - Amrod

(2023-09)

• Automating API-to-SQL Data Pipeline – Developing SQL queries for API calls and T-SQL integration to import data and daily API CSV responses into SQL server, improving data refresh reliability.
• Designing and optimizing T-SQL queries, stored procedures, functions and views to improve performance.
• Automating data loading and transformation into SQL Server for business reporting.
• Creating and monitoring SQL agent jobs.
• Building Data warehouse

SQL/BI Developer - Purple Group

(2021-10 - 2023-09)

• Building and maintaining BI tools and interfaces for the business
• Extraction of data for clients on request using SQL
• Developing ETL processes with SSIS, SSRS reports using SSDT tools
• Analysing reports and fixing bugs in stored procedures.
• Creating data extracts on request
• Maintenance of SSAS models and data warehouse.

BI Developer - Zensar Technologies (Placed at Silica)

(2019-01 - 2021-10)

• Use of CTEs, creation of stored procedures, designing and optimizing indexes, views and functions using T-SQL and Sybase servers.
• Follow coding standards and best practices for change management (code reviews, testing, etc.)
• Support existing and developing new ETL processes with SSIS
• Import and transform new data sources into data Store
• Creating SSRS and Crystal Reports subscriptions schedule on reporting server for managers and clients to different delivery destinations
• Power BI dashboards/reports.

System Developer - Syntell (Pty) Ltd

(2017-06 - 2018-12)

Responsible for developing the company intranet site using the following technologies:

• Writing code for the back-end and designing front-end.
• HTML 5,CSS, Javascript, (ASP.Net) for front end design
• C# for back-end coding
• MS SQL server for database.
• Using Git (Bitbucket) as our version control tool.
• Paycity system development .(front end) Using visual studio (ASP.Net) ,CSS,JavaScript

IT Support and Administrator - Redwill ICT

(2016-12 - 2017-06)

• Remote and onsite Support to company clients.
• Respond to client service requests and expediently resolve trouble tickets to maximize system uptime.
• Emails, Hosted IP PBX (HIP) and domain hosting systems.
• Maintain PBX .e.g auto forward and adding new group users.
• Dealing with tickets escalated from client's IT support team.
• Provide technical support to users and ensure proper maintenance of workstations, printers, computers and peripherals.
• Create and setup outlook and cloud (Synaq) emails for users.
• Using Telephone Management System (TMS) to pull usage report on daily basis.
• ESET antivirus managed on ERAC.
• Cloud web security.

IT Technician - Independent Electoral Commission

(2014-10 - 2015-07)

• Responsible for general IT technical issues.
• Installing and configuring computer hardware and printers
• Providing support to employees.

LAN Administrator - National University of Lesotho

(2013-08 - 2014-05)

• Installing and configuring computer hardware and operating system applications.
• Monitoring and maintaining computer systems and networks.
• Troubleshooting system, diagnosing and solving hardware and software faults.
• Replacing parts as required.
• Setting up new users' accounts and dealing with password issues on the library active directory.

Part Time Assistant Tutor - National University of Lesotho

(2010-01 - 2010-05)

• Assisting students with Mathematics tutorials

Sales person - Express store

(2008-11 - 2009-01)

Bachelor of Science - Computer Science and Mathematics - National University of Lesotho (2014)

Grade 12 - Masitise High School (2007-12)