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)
