Automated Order Validation
Affilinet's UK offices needed an automated system to monitor an inbox and parse the attachments containing the previous day's returns and cancellation data.
I designed and implemented a job scheduler that processed the incoming files without any user intervention. Only when the users receive an email containing any errors that may have occurred, they need to log in to troubleshoot the process via the user interface.
The web application also updates the external stock system via a SOAP API.
The automated application created an operational efficiency, accelerating the reconciliation process from weeks to a single day.
Affilinet / Debenhams
Custom Data Processing Extensions (DLLs) for SSRS
It is estimated that only 20% of all data is tabular and can be stored in 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, because it could not be done in stored procedures alone. Data could be merged from various sources, and greatly simplified the report design.
I was also responsible for implementing changes to the ETL processes from the OLAP databases to the Staging and Warehouse databases.
DVT / MiX Telematics / Matrix Vehicle Tracking
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.
DVT / RainFin / Absa
Software Development Project Manager (Agile)
Curro Holdings upgraded both their academic and financial systems in the same year. The 3rd party academic system was retired in favour of a new in-house system, a web-based system based on Grails and Vaadin.
As project manager I was responsible for gathering user requirements from academic specialists and the financial department. We collaborated on a shared specification document, which I enhanced with technical details and UI wireframes.
We hired external developers and followed the Agile Methodology, based on the Jira project management software.
Data migrations from Pastel Partner to Sage Evolution
The company had a need to migrate their Customer, Supplier and GL history for 2013-2014 from 50 Partner databases to 10 Evolution databases. Evolution was configured with segmented GL's and branch accounting.
I harnassed the power of my own Partner SDK and the 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.
Budget Manager Application (Java EE)
I had to rescue a Budget Manager Spring application in a very short time after a junior programmer left the company.
The application is used by management to build the next year's budget from external sources and to present it to the Board.
2013 - 2014
Database replication to 33 sites
Because of slow internet connections between sites, the company could not centralise information as they would like. Financial data would reside at Head Office while academic data would be managed at each site.
I was asked to implement a replication strategy to synchronise financial and academic data between sites.
I chose to use SQL Server Merge Replication, in addition to an ASP.Net implementation on each site where staff members could process invoices and billing remotely.
2012 - 2013
ETL implementations (SSIS)
As a database administrator I was asked to implement ETL processes to stage subsets of data on the company's public facing website.
The data is used by the self-help customer portal.
2012 - 2013
I was asked to design a number of web-based reports, which I chose to implement in SSRS.
The reports were used mainly by financial users, including auditors.
Currently we are migrating these reports to a StimulSoft reporting platform.
2012 - 2014
Debit Order implementation
We retired Absa Bank's debit order system in favour of a new ASP.Net implementaion where the financial department could administer the customer's debit orders from any site.
The debit order system interfaces with Netcash (now SagePay) and pushes billing and unpaid transactions to Pastel Partner (and now Sage Evolution).
The Synergy billing engine is the heart of the company's cashflow provision.
I was asked to implement a system which would take inputs from the 3rd party academic system as the basis for monthly billing. I implemented an ASP.net solution that would generate batches for import into Pastel Partner.
Today Synergy generates more than 30000 monthly invoices for study fees and other adhoc fees. These invoices are pushed to Sage Evolution.
Parents can view their statements online and also pay online.
2010 - 2014