Data Architect (Contract) at UBS & Hewlett Packard
July 2011 - June 2012
Responsible for the data analysis for, and the design and implementation of, interfaces between the UBS systems and HP's FlexDeploy program, to allow UBS to automate the Desktop Transformation Program, where the worldwide desktop landscape is migrated from Windows XP to Windows 7.
The role started out as pure data analysis, but soon evolved into a data architecture role to synchronise and merge data from 16 feeder systems into a single, coherent data stream into the FlexDeploy database. Extra responsibilities taken on during the project were system analysis from a data perspective, and requirements/expectation management of the different stake holders up to senior management, including problem analysis of the source data and source systems.
Owner/Senior IT Consultant at van Beest IT
January 2004 - December 2011
Specializing in Oracle cross-platform, cross-version migrations, as well as troubleshooting, optimization, performance tuning, system design and implementation.
Other services include software design, auditing and maintenance, using C/C++/C#, Delphi, PL/SQL, UNIX scripting, ABAP and PHP as languages.
KEY PROJECTS:
2010/11 - City of Cape Town
o Training of DBA's in SAP Data Management
o Data analysis/alignment for legacy-to-SAP/LUM migration
o ABAP & Oracle performance optimisation
2010 - Old Mutual/Systemic Logic
o Data architecture maturity assessment to determine the current state of the financial data architecture
2009/2010 - New Clicks Holdings
o Redesigned the company's data warehouse environment, allowing for high-availability and disaster recovery
o Auditing the company's data warehouse system, including the production of a detailed implementation plan for the governance and segregation of duties in this environment
o Developing and implementing a scalable system for the centralised management of AIX servers, including hardware and Oracle error reporting, daily database utilisation reports and the collection of performance statistics
2009 - City of Cape Town
o SAP/Oracle clean-up and reorganisation, successfully reclaiming 2TB of an 11TB database by cleaning up erroneous data and reorganising 50% of the indexes
2008-2009 - New Clicks Holdings
o Managing and technically executing an Oracle data warehouse storage migration with no downtime
2008 - Eskom/IBM
o Cross-platform migration of 8 SAP landscapes, coordinating end-user testing
2007 - City of Cape Town/IBM
o Cross-platform migration of an 8TB SAP/ISU landscape with only 36 hours downtime
2007 - MTN/IBM
o Oracle Apps landscape analysis for migration
2007 - New Clicks Holdings/IBM
o Migration of a 10TB Oracle data warehouse
2006 - Various/IBM
o Migration of SAP landscapes
2006 - Sasol/IBM
o SAP Landscape design
2005 - Telkom/IBM
o Migration of 4 SAP landscapes
Senior Technical Consultant at R Hulsman Consultancy BV
May 2000 - December 2003
Technical consultancy for the Baan software series.
Customer specific development of new Baan modules, extensively using the AFS interface of Baan IV.
Rewrite of the major part of the Baan standard Euro-conversion software.
Implementation and enhancement of the Baan IV Enterprise Information System for KPN Netwerkbouw in the Netherlands.
Development of a thin-client, browser based GUI for the Baan IV software, deemed impossible by the then Baan development team.
Technical Consultant at TopTier Software
November 1999 - April 2000
Implementation and customizations of TopTier's hyper-relational database software.
Technical Consultant at Baan Netherlands BV
May 1997 - October 1999
Specialization on performance tuning:
o Databases: Oracle, Informix, MS SQL Server and TBase
o Hardware: HP, IBM, Sun, NT, AS400
o Software: SQL query optimizations
System architecture design for BaanIV
Conversion of legacy systems to BaanIV
Implementation and enhancement of the Enterprise Performance Manager of BaanIV
Training of technically oriented courses
Customization of the BaanIV software
Tools and Utilities development using Delphi (part-time)
Technical Consultant at Baan South Africa (Pty) Ltd
May 1996 - April 1997
Technical support on Baan systems, from Triton 1 up to BaanIV
Installations, migrations, upgrades, and performance enhancements of the Baan software
System hardware design for BaanIV
Tools and Utilities development using Delphi (part-time)
System Analyst/Programmer at Sasol Mining Explosives
September 1993 - April 1996
ERP enhancements & business analysis
Maintenance and ongoing development of Tetra2000, a small scale ERP system running on Novell, written in C & Informix SQL
Add-on development of a marketing/budgeting system for Tetra2000
Business analysis for the selection of a new, full-blown ERP system
Tools and Utilities development using Turbo Pascal and Delphi 1 (beta)
System Analyst/Programmer at The South African Mint Company
September 1992 - August 1993
Development/enhancements of the Factory Control System
Maintenance and ongoing development/enhancements of the Factory Control System - C with an Ingres database/HP9000 systems
Development of an Ingres-MS Excel interface - C/Ingres/Microsoft Excel/HP9000/PC
Development of an Enterprise Information System - Microsoft Excel/PC
System Developer at Ninham Shand
January 1985 - August 1992
General computer maintenance
Software development:
* Flexi-time accounting system
* Several numerical analysis programs (using Fortran)
* Graphical representation for numerical analysis output (using Pascal and X86 Assembler)
* AutoLisp routines for AutoCAD
AutoCAD training for colleagues
Data/System Architect (Contract) at The White Company
June 2012
The contract with The White Company is to analyse, reverse engineer and document their complete landscape. The contract started as a Data Architect, but, due to the software almost being an undesirable black box, it became a systems architect role, including Dynamics NAV source code auditing, to try and understand and highlight the errors made in the coding of the interfaces.
The landscape includes the main ERP suite, Dynamics NAV V5, and numerous external applications, including Dynamics NAV 2009, Dynamics CRM, Digital Vantage Point's Nav-To-Net, LS Retail POS, MPlan, Feefo, Google Analytics, data warehouses and BI platforms.
Director at Data Maven Limited
January 2012
Social Networks