Hello, I'm Morné Fourie

National Certificate in Datametrics

My studies centered around systems analysis and various design methodologies. I use UML, Use Case, Flow Control, Timelines and other diagrams in my technical documents.

Advanced Delphi and Oracle Course

My first in-house CRM was written in Delphi. This course helped me to master the more advanced concepts, and also introduced me to Oracle databases.

Microsoft Certified Systems Engineer (MCSE)

My MSCE certification enabled me to administer and maintain Microsoft Windows Servers and provided me with the necessary network skills.

Peer to Peer Lending Platform

Rainfin invited us back to help solve inefficiencies in their system. We were able to address many performance issues and added much needed features for them to expand into new markets.

We also implemented a lending platform for the 4AX exchange, who partnered with Rainfin to boost SME growth in Africa.

VIN Database

MiX Telematics needed to create more efficiencies in terms of their tracking device installations. As a DVT contractor I was asked to design and implement a VIN database and API that would query external providers to store the Make, Model, Year of a vehicle based on it’s VIN number. The application provided a way to build proprietory device scripts from known snippets based on the VIN number.

Custom Data Processing Extensions (DLLs) for SSRS

It is estimated that only 20% of all data is tabular and can be stored in relational databases. MiX Telematics needed their SSRS reports to bind to other data sources like SOAP and REST Web Services.

Enter the Custom Data Processing Extension (DPE)! As a DVT contractor I was responsible for implementing a set of DLLs for deployment alongside SSRS, to enable RDLs to access non-SQL data via Web Services.

Complex business rules could be implemented and data could be merged from various sources, greatly simplifying the report design.

I was also responsible for implementing changes to the ETL processes from the OLAP databases to the Staging and Warehouse databases.

Part of my support duties was to troubleshoot trip data using SQL Server Geography and Geometry APIs.

Peer to Peer Lending Platform

RainFin's lending marketplace is an alternative way to borrow or lend money. It directly connects borrowers and lenders, allowing for cheaper credit for borrowers and better returns for lenders.

As a DVT contractor I was responsible for completing the SME version of the application, along with 3 other developers. I learnt from one of the best architects in South Africa.

We also ported the PHP version of the Personal Loans application to a .NET MVC application.

The Personal and SME applications consumed web services exposed by the core system, and also did live credit checks.

Solutions Architect and Project Manager

Curro Holdings upgraded both their academic and financial systems in 2014. The 3rd party academic system was retired in favour of a new in-house web-based system built on Grails and Vaadin.

As project manager I was responsible for gathering user requirements from academic and financial specialists. We collaborated on a shared specification document, which I enhanced with technical details and UI wireframes.

I managed an agile process with the external developers using Jira.

Data migrations from Pastel Partner to Sage Evolution

The business needed to migrate their Customer, Supplier and General Ledger history from 50 separate Pastel Partner databases into 10 Sage Evolution databases. Evolution was configured with segmented GL's and branch accounting.

I combined my own Pastel Partner SDK with the Sage Evolution SDK to migrate the transactions to the new system.

The trial balances were signed off by the financial department and balanced to the cent. Deloitte audits were also successful.

Budget Manager Application (Java EE)

When a junior Java developer unexpectedly resigned, I had to cross over to the "dark side" to rescue a Budget Manager Spring MVC application to meet deadlines.

The application was used by management for budget forecasting from historical data and external sources.

Database replication to 33 sites

Do you remember 4MB ADSL? Because of slow internet connections between schools, Curro could not centralise their critical systems. Financial data resided at the Head Office while academic data was managed at each school.

I implemented and monitored a replication strategy to synchronise financial and academic data between sites.

I used SQL Server Merge Replication and an ASP.NET web portal on each site so that the staff members could process invoices and billing remotely.

ETL implementations (SSIS)

We ran a very lean operation in those days. Besides Software Development I also wore the database administrator hat. I implemented ETL processes to stage subsets of data on the company's public facing website.

The data was used by the self-help customer portal.

Reporting (SSRS)

I designed a number of web-based reports using SSRS.

The reports were used by financial users, including auditors.

Debit Order implementation

Curro retired their bank's debit order system in favour of a new ASP.NET web platform where the school bursars could efficiently administer the parents' debit orders.

The debit order system interfaced with Netcash (now SagePay) and fed transactions into Pastel Partner (and later Sage Evolution).

Billing Engine

I designed and implemented the Synergy billing engine which was at the heart of Curro's cashflow provisioning.

The billing system which would take inputs such as attendance records and class lists from the 3rd party academic system for monthly billing. I implemented an ASP.NET solution that would generate batches for import into Pastel Partner. Exception reporting helped the bursars to validate the external inputs before generating the monthly invoices.

In 2015 Synergy generated more than 30000 monthly invoices for study fees and other adhoc fees and stored them in Sage Evolution.

Parents could view their statements online and pay online.