Profession: Network Adminstrator|Microsoft SQL Server Developer | Data Engineer (Azure & AWS)
Polokwane
Summary
I am inspired, willing to learn and self motivated young man with demonstrable competencies in adaptability and teamwork. I have good oral and written communication skills and also possess some unique analytical, leadership, networking and inter-personal traits. Being part of a focused and result driven team makes me perform much more better.
Overview
6
6
years of professional experience
5
5
years of post-secondary education
Work History
Server/ Nertwork Adminstrator
Tuliptek Consultancy
01.2021 - 04.2023
A Network and Security Professional with over 2 years in Enterprise Network solutions and Cyber Security (Sophos/Cyberoam)
Key Responsibilities:
Provide technical support for both Sophos and partner-led sales opportunities.
Conduct Proof of Concept online or onsite to prospective customers.
Design and Implement Sophos solutions in complex cyber security projects.
Lead online 'hands on' webinars or onsite demos with partners to their customers and prospects.
Provides technical support to end users for desktop computers, applications, and related technology, utilizing Active Directory.
Collaborates with vendor support contacts to troubleshoot technical issues related to desktop computing equipment and software.
Works with Help Desk and Network Operations teams to identify and resolve client-reported problems.
Manages interactions with various computer platforms in multi-layered client-server environment.
Ensures seamless connectivity between desktop computers and diverse systems, including validation systems, file servers, email servers, computer conferencing systems, application servers, and administrative systems.
Provides training and orientation to staff on hardware and software usage.
Assists in maintenance of LAN/WAN records and, if required, telephone systems cabling.
Proven experience with PBX troubleshooting/support/maintenance
Strong knowledge (i.e. routers and switches) and strong understanding of VoIP (i.e. various types of IP based voice products )
VoIP Troubleshooting Skills
Information Communication Technology Officer
Department Of Research And Specialist Services
05.2017 - 08.2018
Cisco Managed network installation and administration(VLANS) Cyberoam firewall security for Web and Application filtering Online video conferencing setup and coordination Disaster Recovery Plan formulation and implementation Data security and online-offsite backup Linux servers(Email & FTP) Database applications administration.
SQL Server Reporting Services (SSRS) Developer (Cash Converters).
Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
Installed MS SQL Server 2008R2 and Management tools using SQL Server Setup Program.
Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.
Designed, created, and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
Helped to design all kind of production and sales reports for Sales and procurement departments using SSRS.
Responsible for optimizing all indexes, SQL queries, stored procedures to improve quality of software.
Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
Generated periodic reports based on statistical analysis of data using SQL server Reporting service (SSRS).
Extensively used SSIS transformations such as lookup, merge, derived column, data conversion, conditional split, and aggregate for creating SSIS ETL Solution.
Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
Used Transformations such as Union All, Merge and Breakpoints in SSIS.
Generated ETL Packages tasks daily using SQL Server Agent jobs by scheduling and manually configured.
Used all types of container tasks such as for loop, foreach loop and sequence container in SSIS.
Created reports to retrieve data using Stored Procedures that accept parameters.
SQL Server Reporting Service (SSRS) for th client, Cash Converters
SQL Server Reporting Service (SSRS)
Creation of Tablix Reports on daily basis
Implementation of appropriate Filters and Parameters for Tablix Reports
Import data from remote SQL Server through Stored Procedures
Connect Data Sources and Creation of Datasets
Work on Total Quality Management (Jira), reports constructed fall under Cash Converter’s requirements or to company formats
Daily meeting updates on productions
Commit all changes made in project on Server through Git Changes
Deployments of Reports created in Server for client to access reports
Presentations of Reports to client on daily meetings
Creation of Stored Procedures as data sources for Reporting
Data Modelling, Transformation, Cleaning through Pipelining
Education
Bachelor of Science (Honours) Computer Science - Computer Science
University of Zimbabwe
Harare, Zimbabwe
01.2015 - 05.2020
Skills
Technical Support Storage Area Network (SAN) Domain Name System (DNS) Network Security Networking DSL Cyber Cyber-security Troubleshooting 2nd Line IT Support Information Technology Cabling IT Operations Internet Protocol Suite (TCP/IP) Problem Solving Databases Desktop Virtualization Network Operations Center (NOC) Local Area Network (LAN) IT Service Management Cybersecurity
undefined
Home
Unit 9, SS La Toscana, 55 Grobler Street, Polokwane Central, Polokwane, 0700, South Africa
Tax Advisor, Accountant and Financial Analyst at AL Qabas Enlightening Economic Consultancy LLC (Finpro Consultancy)Tax Advisor, Accountant and Financial Analyst at AL Qabas Enlightening Economic Consultancy LLC (Finpro Consultancy)
Founder and Managing Director at Elex Consultancy Ltd & Alsedox Consultancy LtdFounder and Managing Director at Elex Consultancy Ltd & Alsedox Consultancy Ltd
Founder and Managing Director at Elex Consultancy Ltd & Alsedox Consultancy LtdFounder and Managing Director at Elex Consultancy Ltd & Alsedox Consultancy Ltd