Allan is available for hire

Allan Kote

Verified Expert in Engineering

Data Engineer and Developer

Location

East London, Eastern Cape, South Africa

Toptal Member Since

November 3, 2022

Allan is a data engineer with 15 years of hands-on experience in data analytics and business intelligence. Having worked as a data specialist for diverse companies, both as an internal team member and a freelancer, he has acquired extensive knowledge about the latest technology in the field. Allan also has excellent written and oral communication skills, a passion for learning, and a strong will to keep increasing his technical skill set.

SQL Relational Databases T-SQL (Transact-SQL)Data Engineering Data Analysis Data Analytics Data Warehouse Design Data Migration Data Warehousing Data Modeling Analytics DAX Azure Data Lake Microsoft Excel Databases PowerBuilder Online Transaction Processing

Portfolio

Freelance Clients

SQL Server Reporting Services (SSRS), Microsoft Power BI, SQL, Data Engineering...

Zoetis - Net Revenue Management

Business Services, Tableau, Microsoft Power BI, Data Analysis...

inQuba

JasperSoft ETL, Data Engineering, Spotfire, Microsoft SQL Server, ETL...

Experience

SQL - 18 years Data Engineering - 17 years Microsoft SQL Server - 17 years T-SQL (Transact-SQL) - 17 years SQL Server Integration Services (SSIS) - 10 years JasperSoft ETL - 4 years Spotfire - 4 years Microsoft Power BI - 3 years

Availability

Part-time

Preferred Environment

T-SQL (Transact-SQL), SQL Server Reporting Services (SSRS), Microsoft Power BI, Spotfire, JasperSoft ETL

The most amazing...

...operational and analytical reports I've recently produced used TIBCO and integrated inQuba's customer experience tool used by corporate clients internationally.

Work Experience

Data Engineer

2021 - PRESENT

Freelance Clients

Developed investment reports for Alexander Forbes using SQL Server Reporting Services (SSRS).
Outlined part of the ETL processes and automated jobs that feed into those investment reports.
Developed ETL processes and reporting for Master Data Services targeting the Aurum Institute and PPECB.
Created data profiling scripts for RapidDeploy to be used on US 911 call data.

Technologies: SQL Server Reporting Services (SSRS), Microsoft Power BI, SQL, Data Engineering, ETL, ETL Tools, Reports, Data Analytics, Data, Azure, Azure Databricks, Azure SQL, Data Warehouse Design, Windows PowerShell, CI/CD Pipelines, DevOps, Data Visualization, Microsoft Excel, Data Migration, Finance, Dashboards, Azure Data Explorer, Consulting, Data Architecture, Data Management, Data Pipelines, Databases, Relational Databases, Analytics, Scripting, OLAP, Data Warehousing, DAX, Financials, Reporting, Azure Data Lake, Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, Spark, PySpark, Databricks, BI Reporting, Data Modeling, Architecture, MySQL, Database Migration, Warehouses, Data Build Tool (dbt)

Deal Desk Technology Advisor

2023 - 2023

Zoetis - Net Revenue Management

Created a new advanced SQL script for tracking and calculating new ODx deals.
Developed a new ODBC dataset connection to access the SharePoint tracker spreadsheet.
Crafted a new paginated report to track sales and orders for new and existing ODx subscribers.
Used Azure Storage Explorer and Python to scrape invoices on PDFs and images.
Responded to the sales teams to recommend client offers based on the ODx tiering system.

Technologies: Business Services, Tableau, Microsoft Power BI, Data Analysis, Robotic Process Automation (RPA), Python, R, Azure Storage Explorer, Azure Data Factory, Azure Synapse, Reports, Data Analytics, Data, Azure, Azure Databricks, Azure SQL, Windows PowerShell, CI/CD Pipelines, DevOps, Data Visualization, Microsoft Excel, Data Migration, Finance, Dashboards, Azure Data Explorer, Consulting, Data Architecture, Data Management, Data Pipelines, Databases, Relational Databases, Analytics, Scripting, OLAP, Data Warehousing, DAX, Pricing, Financials, Reporting, Azure Data Lake, Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, BI Reporting, Data Modeling, Architecture, MacPractice, Database Migration, SQL, Warehouses, Data Build Tool (dbt)

Business Intelligence Developer and Data Engineer

2018 - 2021

inQuba

Developed customer experience BI reports with TIBCO Spotfire and JasperSoft ETL in a team of three developers.
Created scripts to build the DW from the inQuba customer experience platform database with Spotfire dashboards for at least ten multinational clients.
Worked on ETL processes using MS SQL Server to facilitate accurate metric aggregations on data received from inQuba's customer experience survey system. I also linked free text from individual surveys with sentiment generated from text analytics.
Undertook the investigation and resolution of anomalies in reporting.

Technologies: JasperSoft ETL, Data Engineering, Spotfire, Microsoft SQL Server, ETL, ETL Tools, Reports, Data Analytics, Data, Azure, Azure SQL, Data Warehouse Design, Amazon Web Services (AWS), DevOps, Data Visualization, Microsoft Excel, Data Migration, Finance, Dashboards, Consulting, Data Architecture, Data Management, Databases, Relational Databases, Analytics, MongoDB, MongoDB Atlas, Scripting, OLAP, Data Warehousing, DAX, Financials, Reporting, Azure Data Lake, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), BI Reporting, Data Modeling, Architecture, MySQL, Database Migration, SQL, Warehouses

Business Intelligence Developer and Data Engineer

2015 - 2018

Standard Bank South Africa

Developed South African Reserve Bank's regulatory reports for the finance department with SSRS.
Built SSIS packages for integrating data from various accounting and trading data sources into a central data warehouse. Used this main data warehouse as a data source for several regulatory report datasets.
Developed new ETL process status reports using Microsoft Power BI.
Navigated diverse databases like MongoDB, mastering NoSQL. Designed efficient solutions for varied applications using my proficiency in document-oriented, key-value, and graph models. Optimized data processes, ensuring high-performance systems.

Technologies: Computer Science, Microsoft Power BI, SQL Server Reporting Services (SSRS), Microsoft SQL Server, Data Engineering, ETL, ETL Tools, Reports, Data Analytics, Data, Azure, Azure Databricks, Azure SQL, Data Warehouse Design, DevOps, Docker, Data Visualization, Tableau, Microsoft Excel, Data Migration, Finance, Dashboards, Consulting, Data Architecture, Data Management, Java, Data Pipelines, Databases, Relational Databases, Analytics, NoSQL, Scripting, OLTP, OLAP, Data Warehousing, DAX, Financials, Reporting, Azure Data Lake, Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, BI Reporting, Data Modeling, Architecture, Database Migration, SQL, PostgreSQL, Warehouses

Business Intelligence Developer and Data Engineer

2014 - 2015

Telkom

Developed OSS/BSS and CRM system reports for consumer customer support with SSRS.
Developed ETL processes to integrate data from Telkom's various systems into a central reporting data warehouse. I would then use this data warehouse for business intelligence reporting.
Investigated and resolved anomalies in data reporting.

Technologies: SQL Server Reporting Services (SSRS), Microsoft SQL Server, SQL Server Integration Services (SSIS), Data Engineering, ETL, ETL Tools, Reports, Data Analytics, Data, Azure SQL, Data Warehouse Design, DevOps, Data Visualization, Microsoft Excel, Data Migration, Finance, Dashboards, Consulting, Data Architecture, Data Management, Databases, Relational Databases, Analytics, Scripting, PL/SQL, Oracle, OLTP, OLAP, Data Warehousing, DAX, Financials, Reporting, Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, BI Reporting, Data Modeling, Database Migration, SQL

System Developer

2013 - 2014

Direct Transact

Developed banking system transactional components for branch treasury regulation using Transact-SQL.
Wrote code for transaction processing in Transact-SQL triggers and Delphi.
Investigated and resolved system-process anomalies.

Technologies: Delphi, Microsoft SQL Server, ETL, ETL Tools, Microsoft Excel, Finance, Consulting, .NET, Databases, Relational Databases, OLTP, OLAP, Database Migration, SQL

Business Intelligence Developer and Data Engineer

2012 - 2013

Telkom

Developed OSS, CRM, and BSS system reports for consumer customer support with SSRS.
Extracted, transformed, and loaded data from various sources to staging environments on Microsoft SQL Server using SSIS.
Investigated and resolved system and data reporting anomalies.

Technologies: Microsoft SQL Server, SQL Server Reporting Services (SSRS), Reports, Data Analytics, Data, Data Warehouse Design, Data Visualization, Microsoft Excel, Data Migration, Finance, Dashboards, Consulting, Data Architecture, Data Management, Java, Databases, Relational Databases, Analytics, Scripting, PL/SQL, Oracle, OLTP, OLAP, Data Warehousing, DAX, Data Modeling, Database Migration, SQL

Database Support

2012 - 2012

Turfsport

Provided database support for the company's integrated wagering solution.
Ensured triggers for betting processes worked as intended and at the precise time in the OLTP environment.
Investigated and resolved bets with unexpected results.

Technologies: Microsoft SQL Server, Microsoft Excel, Finance, Consulting, .NET, Databases, Relational Databases, Scripting, OLTP, OLAP, SQL

Business Intelligence Developer and Data Engineer

2004 - 2011

Telkom

Developed OSS/BSS and CRM system reports for consumer customer support with SSRS.
Signed a contract with Telkom to integrate legacy system data with new mobile network system data while the company was preparing to become a mobile network provider.
Developed C++, C#, VB.NET, Microsoft Access, and Oracle Application Express (APEX) applications to report network faults and manage fault activity proactively.

Technologies: Microsoft SQL Server, Oracle 10g, Oracle Reports, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), C++, C#, VB.NET, Microsoft Access, Oracle 11g, Reports, Data Analytics, Data, Data Warehouse Design, Data Visualization, Microsoft Excel, Data Migration, Finance, Dashboards, Consulting, Data Architecture, Data Management, Databases, Relational Databases, Analytics, Scripting, PL/SQL, Oracle, OLTP, OLAP, Data Warehousing, DAX, SQL

Agent

2004 - 2004

Sishayele Contact Centre Solutions

Took emergency and police calls as an agent, providing the necessary information to emergency services.
Trained new colleagues on system usage and soft skills.
Captured and uploaded system data to be analyzed by the planning team.

Technologies: Customer Support, Microsoft Excel, Databases, OLAP, Data Warehousing, SQL

System Developer

2002 - 2003

Soluziona Professional Services

Wrote an ICS security application in PowerBuilder and C.
Developed a reports module for the application using Oracle Report Writer.
Created system batch jobs in C and PL/SQL for overnight execution.

Technologies: C, Oracle Reports, PowerBuilder, PL/SQL, Reports, Data Analytics, Data, Data Visualization, Microsoft Excel, Data Migration, Finance, Consulting, Databases, Relational Databases, Oracle, OLTP, OLAP

System Developer

2000 - 2002

Touchstone Computer Systems

Developed new functionality for the Payplus payroll system in Visual Basic for MS-DOS.
Built an HR data capturing application to store the historical data of employees in Q&A.
Created a system to automatically print cheques an operator has entered in Q&A.

Technologies: VB, Human Assessment, OLTP, OLAP, Data Warehousing

Experience

Master Data Services for the Perishable Products Export Control Board

https://ppecb.com/wp-content/uploads/2018/08/ICT_AR_2017_2018.pdf

Contributed to the cleanup of the government entity's master data by scripting ETL processes to move dimension data from its legacy system, Titan. Scripts are dynamic, done in Transact-SQL, run from SSIS packages, and are loaded on a Master Data Services (MDS) data warehouse. The packages also activate leaf-stored procedures that ensure the integrity of the master data in preparation for Dynamix 365 integration.

Emergency Call Center Data Engineering

As a central back-end data engineer, I profiled and structured 911 call center data from various US states. My primary value has been creating automated unit tests to automatically detect anomalies in the data to maintain its integrity.

Financial Data Warehousing

http://www.fundi.co.za

Led data integration within Fundi to keep everything within a centralized data warehouse on Azure. Fundi provides funding for higher education. I built ETL processes to move data from various systems and sources.

Skillset

Languages

T-SQL (Transact-SQL), SQL, Delphi, C++, C#, VB.NET, C, PowerBuilder, VB, Snowflake, Python, Java, R

Storage

Relational Databases, Microsoft SQL Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), PL/SQL, Azure SQL, Databases, Database Migration, Oracle 10g, Oracle 11g, Data Pipelines, NoSQL, MongoDB, OLTP, MySQL, PostgreSQL, Cloud Firestore

Other

Reporting, Data Engineering, Data Analysis, Data Analytics, Data, Data Warehouse Design, Data Migration, Finance, Dashboards, tSQLt, ETL Tools, Consulting, Data Architecture, Data Management, Analytics, Azure Data Factory, Data Warehousing, DAX, Azure Data Lake, BI Reporting, Data Modeling, Warehouses, Machine Learning, Computer Science, ITIL V3 Foundation Certified, Next-generation Networks (NGN), Operations, Business, Customer Support, Human Assessment, Microsoft Master Data Services, Reports, Azure Databricks, CI/CD Pipelines, Data Visualization, Azure Data Explorer, Business Services, Scripting, Robotic Process Automation (RPA), Azure Storage Explorer, Pricing, Financials, Architecture, MacPractice, Data Build Tool (dbt)

Tools

Microsoft Power BI, Spotfire, JasperSoft ETL, Microsoft Excel, Oracle Reports, Microsoft Access, Tableau, Looker, Apache Airflow, MongoDB Atlas

Paradigms

Business Intelligence (BI), ETL, OLAP, DevOps

Platforms

Azure Synapse, Oracle, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), Azure, Amazon Web Services (AWS), Docker, Databricks

Frameworks

Windows PowerShell, .NET, Spark

Libraries/APIs

PySpark, Sage

Industry Expertise

Accounting

Education

2020 - 2020

Postgraduate Program in Artificial Intelligence and Machine Learning

The University of Texas - Austin, USA

2005 - 2014

Bachelor's Degree in Computer Science

University of South Africa - Pretoria, South Africa

2008 - 2010

Advanced Diploma in Telecommunications

Rhodes University | Institute for Technology and Strategy Innovation (ITSI) - Pretoria, South Africa

2008 - 2008

Advanced Diploma in Operations Management

North-West University - South Africa

1999 - 2000

Vocational Diploma in Computer Science

Genetic Computer School - Gaborone, Botswana

Certifications

SEPTEMBER 2017 - PRESENT

Microsoft Certified Professional

Microsoft

DECEMBER 2010 - PRESENT

ITIL Certification

EXIN Cape Town

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring