Stefan Cronje, Developer in Cape Town, Western Cape, South Africa
Stefan is available for hire
Hire Stefan

Stefan Cronje

Verified Expert  in Engineering

Data Warehouse Design Developer

Location
Cape Town, Western Cape, South Africa
Toptal Member Since
June 18, 2020

Stefan is a passionate and dedicated developer who loves what he does with an attention to detail and a cool head under pressure. He loves a challenge and every aspect of data. He works well in a team, has worked with many different races and cultures, and also works well independently. His biggest strengths are Microsoft SQL, Microsoft SQL Server Integration Services (SSIS), Visual Studio, Team Foundation Services (TFS), and Team Management.

T-SQL (Transact-SQL)SQLMicrosoft SQL ServerSQL Server Integration Services (SSIS)SQL Server 2008 R2SQL Server 2012IntegrationData MiningData Warehouse DesignData WarehousingData MigrationDatabasesDatabase DesignSQL Server Management Studio (SSMS)Microsoft Visual Studio

Availability

Part-time

Preferred Environment

TFS, Visual Studio, Microsoft SQL Server

The most amazing...

...system I've developed is a component that is used to upload marketplace products onto the live website and stage the products incrementally.

Work Experience

SQL Team Lead

2011 - PRESENT
EOH Microsoft Coastal (via Old Mutual)
  • Lead a custom dev team of 8 SQL developers in the financial sector, which consists of a front-end, back-end, support, and data warehousing.
  • Migrate 300GB of data from one source system to another, necessitating control checks and optimization for timely completion.
  • Help with the design, development, implementation, and maintenance of Old Mutual Wealth.
  • Develop a Valuation Recon Extract process that recons all the transactions for a financial year that were loaded against what should have been loaded and reports the recon to the CAs.
  • Upgrade all the old legacy DTS packages into SSIS.
  • Upgrade SQL from 2000 to 2008 R2.
  • Assist and implement a variety of other, smaller projects.
Technologies: Scrum, Agile, TFS, Visual Studio 2012, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Microsoft SQL Server

Senior SQL Programmer

2008 - 2011
Kalahari.com
  • Developed the whole component used to load marketplace products onto the website using SQL & SSIS.
  • Assisted in the extension of the website to Kenya and Nigeria as well SQL & SSIS implementation.
  • Contributed to the development of the Parcel Tracking system that gets used to inform the warehouse of completed packages and assign the Track&Trace number they were associated by the warehouse to the corresponding parcels. The pallets that get sent to either Kenya or Nigeria get labeled with an auto-generated commercial invoice and the parcels within get assigned the associated tracking numbers.
  • Fixed issues that arose either from the website, tools, stock systems, warehouse issues, and anything else SQL-related.
  • Coded in SQL Server 2005 (back-end).
  • Created and managed store procedures.
  • Created and managed SQL Server agent jobs.
  • Created and managed SQL Server integration service packages.
Technologies: SQL Server Integration Services (SSIS), Microsoft SQL Server

IT System Developer

2007 - 2008
Morvest PremiumIdeas
  • Responsible for all modification, enhancement, and change to the global program, which controlled the whole production flow process, and which was already written in Access combined with VB as a front-end and SQL as a back-end. This program provides the user with a variety of options (tasks) depending on the production flow area they are working in and what task they require.
  • Coded in SQL Server 2000 (back-end).
  • Coded in Microsoft Access Professional 2000/2003 combined with VB (front-end).
  • Performed all IT supervisor duties.
  • Provided comprehensive helpdesk support.
Technologies: VB, Microsoft Access, Microsoft SQL Server

User Administrator/Developer

2006 - 2006
MIH Internet Africa (Naspers) - Media24
  • Maintained dynamic features, including the ability to add/edit/delete departments, users, and user permissions including status as a department manager, from a website that needed to be stable and working 100% or give an appropriate error message if an error occurs.
  • Coded in SQL Server 2000 and in Microsoft Visual Studio .NET 2003 doing ASP.NET in C#.
Technologies: C#, ASP.NET, Microsoft Visual Studio, Microsoft SQL Server

Maintain Departments

Feature maintained for MIH Internet Africa, enabling adding, editing, or deleting of departments. The website needed to be stable and working 100% or give an appropriate error message if an error occurs.

Maintain Users

Feature maintained for MIH Internet Africa, enabling adding, editing, or deleting of users. The website needed to be stable and working 100% or give an appropriate error message if an error occurs.

Department Manager Profile

Feature maintained for MIH Internet Africa, enabling adding or deleting of department managers. The website needed to be stable and working 100% or give an appropriate error message if an error occurs.

Users Profile

Feature maintained for MIH Internet Africa, enabling adding, editing, or deleting of user permissions. The website needed to be stable and working 100% or give an appropriate error message if an error occurs.

Global System

This program was already written in Access combined with VB as a front-end and SQL as a back-end. Any modifications, enhancements and changes that need to be done, I did. This program controlled the whole production flow process. Basically, if it's not operating, nobody is able to work. This program provides the user with a variety of options (tasks) depending on the production flow area they are working in and what task they require.

Marketplace

I developed the whole component used to load marketplace products onto the website.

Kenya/Nigeria Localization

Assisted in the development to extend the website to be available in Kenya and Nigeria as well. One of the core parts I was involved with is with the Parcel Tracking system that gets used to inform our warehouse of the packages that is completed and assign the Track&Trace number that were associated by the warehouse to the corresponding parcels. Also, the pallets that gets sent to either Kenya or Nigeria get an auto-generated commercial invoice and the parcels within the pallets get an assigned number.

Valuation Recon Extract

Developed a process that recons all the transactions for a financial year that were loaded against what should have been loaded and reports the recon to the CA’s.

Old Mutual Wealth

Helped with the design, development, implementation, & maintenance of this project.

DTS to SSIS

Upgraded all the old legacy DTS packages into SSIS.

Data Migration

Did a data migration from one source system to another, which had to have control checks in place and had to be optimized to complete in a certain time period. 300GB of data had to be migrated.

Languages

T-SQL (Transact-SQL), SQL, VB, C#

Storage

SQL Server Integration Services (SSIS), SQL Server 2012, SQL Server 2008 R2, Microsoft SQL Server, Oracle PL/SQL, Relational Databases, Databases, Database Replication, Oracle SQL, SQL Server 2000, Data Integration, PL/SQL Developer, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS)

Other

Freelancing, Data Warehouse Design, Data Warehousing, Software Architecture, Data Migration, Integration, Data Mining, Data Modeling, System Architecture, Software Development Lifecycle (SDLC), Data Transformation

Tools

Jira, Visual SourceSafe, TFS, Visual Studio 2012, Visual Studio 2010, Visual Studio 2008, Microsoft Visual Studio, Microsoft Team Foundation Server, Microsoft Access, Visual Studio, GitLab

Paradigms

Database Design, Agile Software Development, Scrum, Agile

Frameworks

ASP.NET

Platforms

Windows, Windows XP

2004 - 2006

Technical Degree in Information Technology

Cape Peninsula University of Technology - Cape Town, South Africa

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.

1

Share your needs

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

Choose your talent

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

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