Onward Mushava
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
2021.01 - 2023.04
- 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
2017.05 - 2018.08
- 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 2015.01 - 2020.05
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
Languages: SQL, DAX, Python, Java
Azure Cloud: Azure SQL Database, Azure Data Lake, Azure SQL Data Warehouse, Analysis Service (AAS), Azure SQL Analytics, Azure Network components, Virtual Machines, Databricks, Azure Data studio
Home
Unit 9, SS La Toscana, 55 Grobler Street, Polokwane Central, Polokwane, 0700, South Africa
Languages
English
References
Tuliptek Consultancy
14192 Griffin Road, Gunhill,
Harare, Zimbabwe
Contact: Administration,Email: sales@tuliptek.co.zw, Tel: +2638677187007, Mobile: +263779150006.
Kenneth Pfigu: Email kenpfigu@gmail.com, Cell +263772849314, +263719849314.
Department of Research and Specialist Services (DR & SS)
Biometrics and Computer Services Institute (BCSI)
Harare Agricultural Research Centre
Fifth Street Extension P.O. Box CY 550, Causeway, Harare
Tel. +263 4 704531; +263 4 704541
Direct: +263 4 250105
E-mail: bcsi@drss.gov.zw; mikenyika@hotmail.com
Timeline
Server/ Nertwork Adminstrator
Tuliptek Consultancy
2021.01 - 2023.04
Information Communication Technology Officer
Department Of Research And Specialist Services
2017.05 - 2018.08
Bachelor of Science (Honours) Computer Science - Computer Science
University of Zimbabwe
2015.01 - 2020.05