Enniwes Mashonganyika
Pretoria,GP
Summary
I am seeking to provide quality solutions to complex business problems within scope, budget and tight schedules through steering IT Application and Infrastructure systems for organizations. My enterprise management roles include designing, Implementing, re-engineer Enterprise wide IT solutions in line with organization’s strategies, policies and procedures ensuring continuity, continuous improvement, security, scalability ensuring all are enforced and are in line with current technologies.
Overview
17
17
years of professional experience
Work History
Senior Database & BI Developer
IOCO/Vodacom Contract
10.2020
- Architecting the full lifecycle of a Big Data solution, including requirements analysis, framework selection, technical architecture design, application design and development, testing, and Deployment of ETL solutions
- Pentaho PDI ETL (Extract-Transform-Load) between high-scale distributed RDBMS (Teradata, MySQL, SQL Server, Vertica, Oracle)
- Operationalizing Big Data applications
- Deliver end to end Cloud Infrastructure architectures and designs
- Debug, troubleshoot, enhance, test and monitor BI Solutions
- Design, develop, deploy and maintain reports using SSRS and Pentaho
- Design, develop, deploy, maintain and enhance ETL packages using SSIS and Pentaho PDI
- Define, design and implement data access patterns for multiple analytical and operational workloads, across on-premise and Cloud based platforms
- Testing, including unit, integration, system, performance, and acceptance testing
- Administrator Microsoft environment(s) and Pentaho environment(s).
Senior SQL Server Database and MIS Developer
TymeBank
07.2018
- Analysis of operational processes followed by the design and implementation of solutions to improve operational inefficiencies
- Provide technical leadership and mentorship to the junior members of the team
- Provide Database Architecture, enhancement and support of SQL Server data warehouse (EDW), SSRS reports, SSAS, SSIS packages
- Ensure the smooth running of all BI operational processes, including ETL batch processes, reports and data extracts
- Liaison with data warehouse source teams to when changes happen in source teams and to inform source teams of any data warehousing issues
- Use Microsoft SSRS to produce reports and dashboards from the Enterprise Data Warehouse for the Group
- Work with cutting edge development to optimising business performance within SQL Server 2016 environment using complex data modelling and analytics
- Performing data analysis and extracts from the Enterprise Data Warehouse for the Group
- Make changes to database tables, packages and solutions
- Database tuning, monitoring, and query optimization
- Create and maintain complex SQL stored procedures, triggers, tables, etc
- To support SSRS reporting and BI functions
- Investigate and implement solutions to Data Warehouse problems
- Development of all relevant documentation and manuals including code comments, process documentation
- Liaise with users regarding problems / requirements
- Working closely with solution and platform vendors as part of systems development and integration efforts.
Senior SQL Development Consultant
Dake
06.2020 - 09.2020
- SAP BW (Business Warehouse) Migration for https://www.exxaro.com/
- Translation of SAP BW reports to sql and migration of the same to SQL Server, SQL TSQL, SAP, SSIR, SSRS, SSAS, PowerBi
Senior Database Developer and Solutions Specialist
Sasol
11.2018 - 05.2020
- Establishing and maintaining constructive relationship between service providers and business to transform needs into requirements that can be developed into solutions using appropriate software systems
- Provide Database Architecture expertise and guidance in the use of database management systems
- Identifying changes to the business environment and technology trends that could potentially impact the type, level or utilization of services provided
- Ensuring that all changes are assessed for their impact on service levels, including SLAs, OLAs and underpinning contracts
- Monitor all queries from business and managers and assist in effective resolution
- Design and maintain various database environments on SQL server
- Design and support of SQL Server data warehouse (EDW), SSRS reports, SSAS, SSIS packages
- Monitor and manage Microsoft SQL Server and Oracle databases along with their respective high availability solution
- Installations and configurations of Microsoft SQL Server and Oracle databases
- Monitor and manage database backups, Database recovery
- T-SQL and PL/SQL
- Develop MS SQL and Power BI data models
- Develop Tabular/Power BI models using DAX and similar rules
- Develop Power BI reports, dashboards
- Security administration, Capacity management
- Problem investigations, Review, coordinate and test disaster recovery plans
- Implement and recommend high availability solutions for critical environments
- Adhere to ITIL principles
- Provide an advisory role to SASOL IM by recommending technologies, hardware/software configurations
- Ensuring compliance with license agreements.
IT Solutions Architect & MS SQL Server Consultant
Tourplan (Pty) Ltd
03.2017 - 06.2018
- Govern cloud Platform in-line with Enterprise standards and principles
- Support Group/Enterprise Cloud based project with expertise consultancy and operational provisioning of services and platform components in accordance with defined standards
- Mange and co-ordinate efforts between Enterprise/Group Infrastructure, Networks, Security, BI, Data Analytics and Development teams regarding Cloud Platform requirements and services
- Provisioning of and maintaining of Hosted servers for both internal use and for client access via RDWeb access
- Webservices IIS
- Maintaining of SQL Server, SQL Server Jobs and Databases
- Extract, transform, clean and validate data through the use of databases, spreadsheets, and queries for purposes of implementing prescribed data models and visualizations
- ETL SSRS SSAS SQL Scripting
- Providing first & second line support to staff and clients
- Client implementations, installations and upgrades
- Manage technical support team and ensure tickets are done within SLA
- Ensure all issues are expediently addressed, resolved, and documented with technician notes
- Analyze monthly support reports results
- Implement Strategy in improving desktop support services
- Setup Maintain and Administer Backup Solutions, Antivirus Solutions
- Liaison with business partners and vendors to resolve their IT related issues, problems and requests.
Information Systems Operations Lead
Condevsys, Centurion, Pretoria
10.2015 - 02.2017
- Planning strategies and transitioning projects into operations
- Maintain the operational integrity of the technologies and services provided
- Provide promptly respond to support the needs of the business users
- Ensure secure information systems that will serve to protect the business from data loss and breaches of integrity
- Design and reflect business structure in IT Systems appropriately in order to optimize operating efficiency, flows of data and resource utilization within the structure
- Mobilize technical and technology-based resources to solve business problems in a specified context
- Perform cost effectively and efficiently in technology-based projects
- Manage customer relations appropriately
- Ensure day-to-day operations of technology infrastructure, including networks, servers, databases architecture and maintenance
- Operate effectively within a change, release and configuration process
- Utilize technology-based research tools and knowledge-base repositories
- Identify and communicate business opportunities appropriately
- Install, support and maintain end-user applications.
IS Applications and Infrastructure Specialist
Toshiba Africa (Pty) Ltd
10.2011 - 01.2015
- Responsible to the General Manager
- Providing company-wide direction in areas of Information Communication Technology (ICT) policy, information processing, systems and guidance to support the business through effective implementation of ICT interventions
- Planning, coordinating, directing, and designing ICT-related activities of the organisation, as well as provide administrative support for daily operational activities of the Information Systems Department
- Working closely with Senior Executives in other departments to identify, recommend, develop, implement, and support cost-effective technology solutions for all aspects of the organization
- Managing the deployment, monitoring, maintenance, development of ERP and other systems within TOSHIBA
- Solution of differences within applications and software modules
- Documentation and training of programmed or changed functions and workflows according to actual rules (system administration, Microsoft SQL server database administration and customer orientation)
- Service for all existing systems with the main field on interfaces
- Definition of add-on's to standard applications
- Analysis of defective functions and their solution respectively documentation and transmission to external organization programmer
- Tests of changed standard applications
- Database Management
- Manage a complex production database environment
- Disaster recovery, capacity planning, and Real Time monitoring, troubleshooting, and maintenance
- Refractor existing objects to improve server performance
- Read and Write complex TSQL queries view, triggers, and stored procedures
- Support of interfaces between the systems
- Definition of interfaces between standard applications and applications, developed by IS Division
- Support and co-ordination of the development of interfaces to applications of other TOSHIBA areas
- Preparation and service of interfaces, developed by IS Division
- Analysis of defective functions, documentation and transmission to external organization programmer
- Tests of changed interfaces
- Development of data models according to BU-Requests, company's structure and standards of safety
- Development (programming) of new applications or modification of existing applications using C# and VB.net and on demand tests in co-ordination with users
- Preparation of system documentation and user manuals for all new or changed applications respectively organizational flows
- Responsibility for training of users
- Server maintenance, backup and disaster recovery
- Providing technical advice and consultancy to Toshiba Africa management in Designing, implementing and deploying technical architecture infrastructure for Toshiba Africa’s hardware, software, networking, security and applications systems
- Prepare the budget of all IT Requirements within the Group & Software Licensing
- Provide guidelines and technical specifications for hardware and software to be acquired
- Ensure high availability of all critical business facilities
- These include e-mails, Project Management, Data and Hosting including web sites, networking services, telecommunications, authentication services, security, etc
- Disaster Management including back-up and restoration of critical data and services
- Implement IT risk and security mitigation processes.
Data and Information Systems Manager
Reditron (Pty) Ltd formerly Norbain SA (Pty) Ltd
02.2009 - 10.2011
- Business Applications Support including Implementing, data loading, customizing, upgrading and supporting Sage line 500 ERP, Sage Paperless, Sage Business Intelligence
- Responsible for all functions associated with the design, implementation and maintenance of SQL Server 2005 databases including security, back-up, and logging, reporting, recovery procedures, monitoring and tuning, triggers, views, stored procedures
- To proactively monitor the database systems to ensure secure services with minimum downtime Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management
- Define rules to evaluate data quality and creating test plans that work
- Monitor quality of data flows against data quality standards
- Developing feeds to Data Warehouse and Marts (Sage line 500 Business Intelligent) for reporting purposes
- Build, deploy reporting cubes, including designing Sage BI reports
- Prepares routine reports (financial, quality, sales, representative service, operational efficiency, market share, etc)
- Ensure data can be provided to support OLAP reports and various reporting requirements
- Review, analyze, and create detailed documentation of business systems and user needs, including workflow, program functions, and steps required to develop or modify computer programs
- Report writing using Sage business intelligence Sage report writer, Chrystal reports, Ms Access and Visual basic
- Windows Sever 2003 system administration, including installing and configuring servers, application software, creating and maintaining user accounts, backing up and restoring files, monitoring and tuning performance, configuring a securing the system
- Administration experience relating to mission critical network services (Authentication / Active Directory Services, E-Mail Services, File Services, Print Services, Terminal Services, Telecommunication Services, Storage Area Network Services, Back-Up Services, VM Services, WAN / LAN Services)
- Active Directory experience as it relates to servers and governing its contents
- Support network infrastructure including WAN, LAN, and wireless technologies.
Systems Administrator
Harvatel Wireless Networks
04.2003 - 06.2005
- Administer network workstations, utilizing one or more TCP/IP or non-TCP/IP networking protocols and/or one or more UNIX-based or non-UNIX based operating systems
- Evaluate and/or recommend purchases of computers, network hardware, peripheral equipment, and software
- Investigate user problems, identify their source, determine possible solutions, test and implement solutions
- Install, configure, and maintain personal computers, Novell networks, UNIX workstations, file servers, Ethernet networks, network cabling, and other related equipment, devices, and systems
- Perform and/or oversee software and application development, installation, and upgrades
- Plan and implement network security, including building firewalls, applying cryptography to network applications, managing host security, file permissions, backup and disaster recovery plans, file system integrity, and adding and deleting users
- Troubleshoot networks, systems, and applications to identify and correct malfunctions and other operational difficulties
- Develop and conduct various training and instruction for system users on operating systems, relational databases, and other applications
- Anticipate communication and networking problems and implement preventive measures.
Education
BSc Honours in Information Systems -
Women’s University in Africa
06.2008
Certificate in Data-communication and Networking -
University of Zimbabwe (AVU)
01.2005
Technician Diploma in Telecommunications and Electronics Engineering (city and guilds) -
Tel-One centre for learning
02.2003
UCLES-GCE ‘A’ level -
Glen Norah 1 High
11.2000
UCLES-GCE ‘O’ level -
Glen Norah 1 High
11.1998
Skills
- Relational Database Management Systems - SQL Server, Vertica and Oracle
- SQL, T-SQL, SQL Plus scripting (stored procedures, views and triggers)
- Business Intelligence, Data Mining, Data warehousing, (SSAS, SSRS, SSIS, ETL), Pentaho PDI, Power BI development
- Data Warehousing
- Business Intelligence Tools
- SQL Programming
- ETL Development
- Business Intelligence Analysis
- API Development
- Project Management
- Report Writing Skills
- Trend Modeling
- Data Governance
- Database Management
- Performance Metrics Analysis
- Data Dashboard Design
- Visualization Techniques
- Data Quality Management
- Data Modeling
- Data Security
- Requirements Gathering
- Machine Learning
- Operating Systems – Windows Server, UNIX, Solaris and Linux operating systems
- Application Systems - Microsoft Dynamics NAV, Sage line 500/1000 and/ Other ERP’s
- Networking LAN/WAN, Security Firewalls
- Active Directory/DHCP/DNS/TCP/IP
- Cloud Infrastructure Solutions
- Webservices IIS, Remote Desktop web apps
- Back-up, recovery and disaster recover planning
- Ability to investigate complex issues, identify and implement solutions
- Technical project management over enterprise solutions
- Knowledge of architecture and design patterns
- Strong oral and written communication skills
- Strong interpersonal and leadership skills
Personal Information
- Passport Number: DN140617
- Date of Birth: 10/13/82
- Marital Status: Married
Membership
- Member of INSTITUTE OF INFORMATION TECHNOLOGY PROFESSIONALS SOUTH AFRICA (IITPSA)
- VERTICA CERTIFIED PROFESSIONAL – Vertica Analytics Database
Work Permit Number
C04135419
References
- Mr. A. Khalil, Financial Manager, Toshiba Africa (Pty) Ltd, 10th Floor Sandton City Office Towers, Sandton, Johannesburg, +27 83 414 3789, aslam.khalil@toshiba.co.za
- Mr. C. Barikano, IT Service Delivery Executive, National Foods Limited, 1 Stirling Road, Harare, +263 4 753 751-9, christopherba@natfood.co.zw
- Mrs Cobie Nel, Senior Manager, Sasol, 50 Katherine Street, Sandton, 2196, +27 83 631 2920, Cobie.nel@sasol.com
- Mr. Leigh Ingle, Managing Director, Tourplan (Pty) Ltd, Unit 35 Oaklane Office Park, Boksburg, 1459, +27 11 918 0031, Leigh.Ingle@sa.tourplan.com
- Mr. Benny Lukhele, Service Delivery Manager, IOCO, +27 (81) 478 0327, benny.lukhele@ioco.tech, www.ioco.tech
- Mr. Pierre Coetzer, General Manager, Condevsys, 297 Kildare ave, Centurion, 0157, +27 82 422 1285, pierre.coetzer@condevsys.co.za
Projects
EOH/Vodacom – Generator Management reporting data mart from multiple sources into Vertica DB using Pentaho PDI IM Mordenisation – SQL Azure Cloud PaaS database consolidation and Applications Cloud migrations. Sasol 2019-20 DevSecOps Batabase Automation, Digitaly Transform and drive agility in the database devops cycle (DB Maestro) Sasol 2019-20 Develop automated SQL server maintenance plans for Client Hosted Databases for all Tourplan SA Hosted Client Servers Oct 2017 Continuous, Design deploy manage Remote Desktop Webservices and ETL for hosted clients Tourplan Jan 2017 to date Condevsys – Excelohealth Design deploy Dental health SQL Server RDBMS DLV Engineers LAN WAN restructure and security vulnerability-management/patch-management March 2016. Metrotelworks SA. LAN cabling, Implementing Firewall internet access policies. Oct 2015. Toshiba Africa IT Enterprise Architecture October 2014 to Jan 2015 Microsoft Dynamics Nav Installation and Configuration Toshiba South Africa (Pty) Ltd October 2011 – 2012 Drafting of IT policy document (October 2009) Reditron (Pty) Ltd formerly Norbain SA (Pty) Ltd Implementing analysis, reporting services (Sage Business Intelligent) March 2010) Reditron (Pty) Ltd formerly Norbain SA (Pty) Ltd Design, install configure sage Business Intelligence using SSAS, SSIS, SSRS, ETL. Restructuring Sage Line 500 ERP Chart of Accounts from single company into an Internal Multi-company Currency Conversion (removing three zeros)-Aug 2008
Timeline
Senior Database & BI Developer
IOCO/Vodacom Contract
10.2020
Senior SQL Development Consultant
Dake
06.2020 - 09.2020
Senior Database Developer and Solutions Specialist
Sasol
11.2018 - 05.2020
Senior SQL Server Database and MIS Developer
TymeBank
07.2018
IT Solutions Architect & MS SQL Server Consultant
Tourplan (Pty) Ltd
03.2017 - 06.2018
Information Systems Operations Lead
Condevsys, Centurion, Pretoria
10.2015 - 02.2017
IS Applications and Infrastructure Specialist
Toshiba Africa (Pty) Ltd
10.2011 - 01.2015
Data and Information Systems Manager
Reditron (Pty) Ltd formerly Norbain SA (Pty) Ltd
02.2009 - 10.2011
Systems Administrator
Harvatel Wireless Networks
04.2003 - 06.2005
BSc Honours in Information Systems -
Women’s University in Africa
Certificate in Data-communication and Networking -
University of Zimbabwe (AVU)
Technician Diploma in Telecommunications and Electronics Engineering (city and guilds) -
Tel-One centre for learning
UCLES-GCE ‘A’ level -
Glen Norah 1 High
UCLES-GCE ‘O’ level -
Glen Norah 1 High
Similar Profiles
Zandalee MarshallZandalee Marshall
Senior Application Support Specialist at IOCOSenior Application Support Specialist at IOCO
Iain LofthouseIain Lofthouse
Senior Technical Specialist at iOCO Cloud ServicesSenior Technical Specialist at iOCO Cloud Services
Veneece MyersVeneece Myers
Applications Support Specialist at IOCOApplications Support Specialist at IOCO