Scroll To View More
Stefan Cronje, Software Developer in Cape Town, Western Cape, South Africa
Stefan Cronje

Software Developer in Cape Town, Western Cape, South Africa

Member since April 29, 2015
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.
Stefan is now available for hire

Portfolio

Experience

  • Microsoft SQL Server, 10 years
  • Microsoft Visual Studio, 10 years
  • Database Design, 10 years
  • SQL Server Integration Services (SSIS), 8 years
  • Data Warehouse, 5 years
  • Data Migration, 5 years
  • Microsoft Team Foundation Server, 5 years
  • Database Replication, 5 years
Cape Town, Western Cape, South Africa

Availability

Part-time

Preferred Environment

Microsoft SQL Server, Visual Studio, TFS

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.

Employment

  • 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: Microsoft SQL Server 2008 R2, Microsoft SQL Server Integration Service 2008 R2 (SSIS), Microsoft SQL Server Reporting Services 2008 R2 (SSRS), Visual Studio 2012, Team Foundation Services 2013, Agile Scrum Methodology
  • 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: Microsoft SQL Server 2005, Microsoft SQL Server 2005 Integration Services (SSIS)
  • 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: Microsoft SQL Server 2000, Microsoft Access Professional 2000/2003 with VB
  • 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: Microsoft SQL Server 2000, Microsoft Visual Studio .Net 2003 doing ASP.Net in C#

Experience

  • Maintain Departments (Development)

    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 (Development)

    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 (Development)

    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 (Development)

    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 (Development)

    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 (Development)

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

  • Kenya/Nigeria Localization (Development)

    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 (Development)

    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 (Development)

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

  • DTS to SSIS (Development)

    Upgraded all the old legacy DTS packages into SSIS.

  • Data Migration (Development)

    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.

Skills

  • Languages

    T-SQL, Transact-SQL, SQL
  • 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, SQL Server Reporting Services (SSRS)
  • Tools

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

    Database Design, Agile Software Development, Scrum
  • Other

    Data Warehouse, Software Architecture, Data Migration, Integration, Data Mining, Data Modeling, System Architecture, Software Development Lifecycle (SDLC), Data Transformation Services
  • Platforms

    Windows, Windows XP

Education

  • Technical degree in Information Technology
    2004 - 2006
    Cape Peninsula University of Technology - Cape Town, South Africa
I really like this profile
Share it with others