Boitumelo Mosala

• Developed stored procedures, functions and triggers to support application requirements.
• Designed complex reports using SQL Server Reporting Services.
• Implemented data migration from legacy systems to new databases.
• Provided technical assistance in the form of SQL coding advice to other team members.
• Used T-SQL scripting language for creating stored procedures, functions, triggers.
• Generated ad hoc reports upon request from stakeholders utilizing Microsoft Excel Pivot Tables or Access Queries.
• Implemented front-end development using HTML, CSS, and JavaScript to create visually appealing web pages.
• Created and Monitored a server-based application that refreshes all excel spreadsheets from resources, saves and sends an email.
• Created and Monitored a server-based application that emails all employees for their birthdays.
• Created and Monitored a server-based application that generates a statements commissions for various consultants and emails the statement.
• Created , changed and managed reports
• Code refractoring and maintenance SQL and C#
• Daily Monitoring
• Access, investigate and extract data as needed
• Created test templates for data completeness and correctness
• Provided support to internal users
• Issue investigation and resolution
• Investigated systems and document
• Problem escalations needed

Technologies used :

• Microsoft Visual Studio
• Microsoft SQL Server Management Studio
• Metabase
• SSRS
• SSIS
• JIRA
• Mermaid

• Microsoft Migration; created views and cubes from old on Prem DB environment to new Azure Synapse DB, consolidating the views into a single view; Renaming tables, views, and columns to maintain uniform naming standards
• Microsoft Migration; Building Pipelines in Azure Data Factory
• Build Analytics/Dashboards in the Azure cloud and Microsoft Power BI to monitor the health and performance of the pipelines in real-time
• Support and maintenance for SQL and Power BI environments
• Voluntary responsibilities; Create and update business collateral, engage and liaise with business and clients in order to establish a functional specification document
• Technologies used: Azure Synapse, Microsoft Power BI, Microsoft Visual Studio: SSIS, SSAS, SSRS, Microsoft SQL Server, PowerShell, Microsoft Word, Microsoft DevOps
• Languages used: T-SQL, XML, DAX

• Testing of software applications, developing test cases, and creating test scripts required for successful software
• Recording results in test documentation
• Identifying and logging test failures and identifying with the software development team
• Working closely with the developers to have better understanding of the application
• Creating and executing test plans for software development
• Developing test cases and create test scripts required for successful software
• Executing test cases
• Verifying SQL query and stored procedure
• Ensuring the resolved defects/failures are re-tested
• Performing regression testing whenever there are changes made to the code effects
• Designing testing scenarios for usability testing

• Working with internal team to develop the overall look and feel of the website
• Create a functional specification document
• Fixing any website issues or bugs that arise
• Routinely test website for ease of use, speed, and quality
• Ensuring website is accessible across many platforms
• Debugging and maintaining code
• Identifying technical risks and issues
• Participating in project meetings with management and other team members
• Reporting on project statuses and developments to project stakeholders
• Technologies used: Microsoft Visual Studio, Microsoft Azure DevOps, Microsoft SQL Server
• Languages used: C#, C++, Css, JavaScript, HTML5

• Help to all first-year students in every module
• Tutoring/lecturing
• Technologies Used: Microsoft Visual Studio

• Lead and Guide all first year students into maneuvering around the campus
• Assistant with student registrations and applications