Data Engineer

• Mar 2019 - Present

Duties and Responsibilities:Working in a team of 11 at Capitec BankDevelopmentThis involves:- Making use of the Microsoft SQL Server Stack.- Using software such as T-SQL, SSIS, C#, SSMS and more.- Building of configurable solutions.- Maintenance of existing solutions and models.- Following best standards and principles.Way of WorkThis Involves:- Assisting with the maturing of good agile principles within the team.TrainingThis Involves:- Mentoring new Data Engineers.- Setting up documentation to assist with the training of new Data Engineers.

BI Developer/Analyst

• Jun 2017 - Present

Duties and Responsibilities:Working in a team of 2AnalysisThis Involves:- Providing insight in Online Gaming player behavior. - Day to day analysis with regards to Acquisition, Retention and Financial figures.- Understanding the breakdown of Deposits down to Net Gaming Revenue.DevelopmentThis involves:- Making use of Postgresql and MySQL sql coding syntax.- Linux- Building of Excel VBA reports in order to provide business with data as a short term solution.- Building of a Data Warehouse, using internal as well as external sources in order to provide business with data as a long term solution. Making use of PHP as an Integration Tool. - Making use of Tableau as a visualization tool to exploit the data within the warehouse.- Source code is stored in a GIT repository and pushed to BitBucket in order to simplify deployments.- Making use of the Kimball Methodology to ensure separation of concerns during the Software Development Life Cycle.

Data Analyst/Test Lead

• Feb 2017 - May 2017

Junior BI Consultant

• Mar 2015 - Jan 2017

Based On-Site Capitec Bank Techno ParkDuties and Responsibilities:Mini Team LeadThis Involves:- Acting as a Mini Team Lead for a group of graduates.- Training graduates with regards to TSQL and PDW coding syntax.- Interacting with different departments within Capitec in order to convert and automate existing code to run within new PDW environment.Symmetric multiprocessing (SMP) Data warehouse migration to Parallel Data Warehouse (PDW) /Microsoft Analytics Platform System (APS)This involves:- Converting all SMP TSQL stored procedures to PDW coding syntax. - Making use of CTAS logic within stored procedures.- Converting excel reports to run effectively and efficiently on the APS platform.- Converting ETL SSIS packages and Stored Procedures to run on the APS platform.- Performing tests on converted stored procedures and excel reports.- Updating and Migrating framework configurations.- Making use of Microsoft software which includes SSMS (Sql Server Management Studio), Visual Studio, Team Explorer and SSIS (Sql Server Intergration Services).- Communicating with the Business Intelligence Department at Capitec Bank with regards to code conversions and excel report conversions.

IT Support Technician

• Feb 2014 - Dec 2014

Assisting Students with general I.T. inquiries, performing repairs and maintenance services and involved with the development of applications used at Student I.T.