Gert Van Deventer Email & Phone Number

Gauteng, South Africa

Responsible for the end-to-end information technology and technical function within Trace Network Operations.

Gauteng, South Africa

• Responsible for Canvas Intelligence’s Data Engineering function to Imperial Logistics from MS Azure Data Factory, Azure Databricks and MS SQL Scripting. End-to-end data sourcing, supply, curation and provisioning to.
• Various ADF, Azure Databricks (Python, PySpark, Azure Data Lake, etc) sprints/tasks to provide inter alia RAW data, transformed and curated to be consumed in the Power BI conformed data models/data marts.The above.
• First MS SQL to MS SQL ADF data sourcing, transforming and curation in the Imperial Logistics ADF platform from Sage AccPac
• Mastering Python in Azure Databricks from zero to intermediate proficiency in less than 7 weeks and transfer of basic knowledge on the fly to the required data engineers in the Canvas team.
• Reverse data engineering the Manage Engine AD Manager PostgreSQL Power BI prototype data model back into MS SQL - to leverage the power of the MS SQL database engine for high volume datasets.
• Optimal, SAP ECC6 real time replication, raw data extract - based on the correct timing (taking into account the various after hours SAP ECC6 jobs) to maximise the correct data extraction in the least intensive timing..

Sandton, Gauteng, South Africa

• Responsible for Kynoch’s end-to-end IT function from MS Cloud, Servers (Bare Metal & Virtual) to end points (laptops, tablets & desktops)Achievements:
• Project: Cutting edge Cisco SD-WAN network plan & rollout for 7 plants and a multiple company integrated Head Office in Sandton – replaces MPLS hybrid network.
• Project: Rapid collaboration rollout (Covid-19): Established and managed a full work from home IT strategy for all office and plant-based staff using LTE and MS Teams as basis – currently still used where required.
• Project: Server Consolidation & Migration: Consolidated business acquisitions of two companies’ IT infrastructure into Kynoch’s IT infrastructure.
• Project: Set up a fully functional MIS Reporting server infrastructure for fully automated reporting purposes.

Potchefstroom, North-West, South Africa

• BI & MIS Reporting platform establishment from zero to a fully functional framework based on Syspro ERP, MS SQL Server and MS Office.End-to-end IT function and full responsibility for Profert’s IT platform from Servers.
• Reporting platform: Built a full reporting framework based on Syspro ERP, MS SQL Server and MS Office Excel to cover all required Sub Ledgers as well as an Excel pivot-based GL consolidation with drill-down.
• 3rd party mobile application for sales order automation: End to end management and roll out of Profert’s mobile sales order automation. It entailed inter alia, business analysis (BA), user requirements (URS).
• 3rd party application for plant production automation: End to end management and roll out of Profert’s plant production automation. It entailed inter alia, business analysis (BA), user requirements (URS), overseeing.
• Transport (Stock based) order conversion to Non-Stock items: Developed and implemented the VB Scripting routines for business rule based non-stock transport procurement (vendors) and invoicing (customers) with a.
• Cashflow Optimization Report: Developed, implemented and administrated the Profert Cashflow Report in conjunction with Price Waterhouse-Coopers (PWC built the baseline report functionality) for business rule-based.

Bryanston, Johannesburg, Gauteng, South Africa

• Responsible for SIS Global’s Business Intelligence consultancy related activities. This entailed the full BI reporting (OLTP & OLAP) development lifecycle which included inter alia business analysis (BA), user.
• Customers: o The SPAR Group Ltd. (Retail)o CTP Digital Services prev. CD Technologies (Pty) Ltd. (Manufacturing)o Atos Origin (Pty) Ltd. (Project Management)o Blendcor (Pty) Ltd. (Manufacturing)o Dauphin Office Seating.
• Atos Origin (Pty) Ltd. (Project Management): Built a fully integrated Project-by-project based trial balance and Work in Progress cashflow report.
• The SPAR Group Ltd. (Retail): Built a full reporting framework based on MS Dynamics NAV (previously Navision), MS SQL Server and MS Office Excel to cover all required Sub Ledgers as well as an Excel pivot-based GL.

City Of Johannesburg, Gauteng, South Africa

Responsible for Nedbank’s MIS reporting focused on IT related activity-based costing (ABC), IT asset register(s); Home Loans and Project Accounting information to the relevant business clusters and senior IT management.

Klerksdorp, North-West, South Africa; Carletonville, Gauteng, South Africa

• Between January 1994 and May 2003, I was employed by MCG in various positions, starting of as a Systems Developer (Jan’94 – Dec’96); Regional Manager - Carletonville Operations (Jan’97 – Aug’00); Regional Manager –.
• Systems Developer (Jan’94 – Dec’96): In the mid 1990’s remote data access was nearly impossible in the rural areas of South Africa. I created a modem (9.6 kbps) transmissible compressed data file which the SABC would.
• Regional Manager – Klerksdorp Operations: I established this regional office in record time (6 months) and still managed to keep on developing and make enhancements to our in-house software application. We used a rapid.

Management Advancement Program, Business Administration, Management And Operations, Nqf 8

B. Engineering (Metallurgy), Engineering

Completed up to 2nd semester in fourth year, require two subjects, project & plant design for completion • Serious allergies to dust.

Senior Certificate, Grade 12

SR Council Dux Scholarship