Gerrit H.

Architect

830 dollar

My experience

Hamburg Commercial BankJuly 2019 - Present

More

Ted BakerJanuary 2019 - March 2019

Survey, reverse-engineer and document database estate in current CRM, ERP and POS systems in terms of semantics and relationships, ascertain data quality to create a consolidated data baseline for re-deploying a new CRM system that will have a richer, more accurate and gap-less customer-centric view.
More

Daimler Financial ServicesJuly 2018 - November 2018

Consolidate the mixed approaches, methodologies, and software delivery mechanisms from various third-party vendors in terms of coding and data-oriented deliveries to Daimler Financial Services, based around the Microsoft DotNet technology stack and the MEAN stack. Drive agreements towards common standards of programming, database design, documentation, UX design, testing regime, sign-off, delivery and cut-over protocols. Socialized the idea of architectural governance in the department to ensure in-flight and to-be designs are within architectural governance principles and policies. Proposed future strategies to further improve DevOps, CI/CD and more collaborative Issue management.
More

UBM plcMarch 2018 - June 2018

Preparing the company for GDPR compliance, Developing an architectural data governance template in preparation for an imminent company merger, with Salesforce CRM forming the operational core application. Validated the core analytics DWH on Amazon Redshift.
More

British AirwaysOctober 2017 - January 2018

Technical design and integration lead to re-platform the airline’s fleet planning, scheduling and airport slots management system (SABRE) to a cloud platform and subsequently consolidate the other filial airlines (part of the IAG Group) on the same platform.
More

The EconomistMay 2017 - September 2017

Data architect in a global business transformation and globalization project, moving from a legacy system to Salesforce.com service desk, Zuora subscription service and GoCardless and CyberSource payment service: Analysed requirements, mapped data and transformations between source & target systems, designed the data cutover process, designed and managed the delivery of the technical data migration process, and did a fair bit of hands-on coding in SQL Server, MS SSIS / SSDT and C#.
More

Matchi.bizApril 2013 - April 2017

System designer and overall technology strategist and architect. Shell script and full-stack developer. Responsible for technical assurance, information security, database designs, architectural governance, technical environments, Business Support Systems, DevOps and BAU day-to-day system maintenance.
More

Checkatrade.comSeptember 2016 - February 2017

A community-based system that is underpinned by a legacy bespoke CRM that runs on SQL Server and ASP DotNet.
More

Sainsbury'sFebruary 2013 - March 2013

Master Data Management of Logistics Data for Depot Management: Design and deliver the solution- and data architecture for a Master Data Management (MDM) application that enriches Sainsbury's product data and assures accurate and consistent data for use by the logistics system in a central product storage depot.
More

SABMillerJanuary 2012 - February 2013

Globalization of a Service Desk system to support 40,000 end-users. Migrate from legacy HP Service Desk to IBM Maximo.
More

TescoMay 2010 - January 2012

Retail and Shop-floor solutions: Re-architect in-store Customer Service Desk. Architect new kiosk project for in-store e-commerce. Security architecture and PCI-DSS compliance.
More

FNB South AfricaApril 2011 - July 2011

Design and implement a new SQL Server 2008 data warehouse and ETL process for generating complex analysis reports for the Bank's business account holders.
More

London UndergroundNovember 2009 - May 2010

Design and deliver high-level data solutions and application solutions based on corporate architectural principles. Scrutinize on-going projects for high-level data architectural issues. Work with Infrastructure Architects and TDA’s and third-party vendors to arrive at optimal solutions – some strategic, some tactical...
More

Almazz.com (now defunct)July 2009 - August 2009

Server and network hardening, database optimization, SEO analysis.
More

IMS HealthJune 2008 - June 2009

Analyzed, Rationalized, Cleansed, Migrated and Reported data between Salesforce.com (SFDC), SAP and SQL Server 2005.
More

British Car AuctionsMarch 2007 - April 2008

Analyse, Design and build an ETL system for migrating vehicle auction data from one service provider to another. Recommended technologies, data analysis with customer and internal staff, design and develop ETL code and custom C# components, system administration, coach others to develop and use SSIS 2005. Developed C# interfaces to AS/400 systems.
More

Credit-SuisseDecember 2006 - March 2007

Analyse, document and make recommendations for the improvement of the existing CVS-based deployment process of fixes and reference data changes to Test, QA and Production Oracle databases for Credit-Suisse's Private Banking CRM system.
More

ebookersAugust 2006 - November 2006

Manage the implementation of a recently-developed data warehouse and its associated ETL processes. Manage design and implementation of new ETL processes.
More

Sunrise Senior LivingMay 2006 - August 2006

Multi-national project between USA, Germany and UK to implement a CRM system. Identified system-security risks and contractual issues and provided technical gap-analysis. Developed data migration system.
More

ABN AMROJanuary 2006 - April 2006

Architected the integration of a bespoke ETL system for the Mantas trading surveillance system.
More

Man InvestmentsSeptember 2004 - October 2005

Design and Develop data warehouse that loads, collates, validates, stored and reports P&L and Risk valuations of investment instrument for hedge fund.
More

CIVICAMay 2004 - August 2004

Design and implement a data warehouse and a bespoke ETL and BI system for motor vehicle intelligence. Introduced Oracle 10g and RedHat Linux to a green-field site.
More

Royal Bank of ScotlandJune 2003 - April 2004

Subject expert on the SearchSpace/Actimize's AML and Fraud surveillance product, to implement a new Cheque and Debit Card anti-fraud system.
More

Met OfficeMarch 2003 - May 2003

Specify and design a message cleansing switch for global Meteorological Observation Bulletins
More

VIPnet d.o.o.December 2002 - March 2003

Design and development of bespoke data warehouse loading system.
More

Stratus TechnologiesJuly 2001 - October 2002

Designed, built and integrated a CTI-based Command and Control (C&C) system (a.k.a. a Mission-critical CRM) for use in a number of UK Police forces
More

Actimize (previously SearchSpace)July 2001 - July 2002

Developed an Anti Front-Running system for the New York Stock Exchange and an Anti Money-Laundering system for the Bank of New York
More

weCommDecember 1999 - June 2000

Developed streaming wireless messaging protocol to stream real-time market data to WindowsCE/ PocketPC-based mobile devices
More

Fujitsu (previously ICL), Pathway DivisionFebruary 1999 - September 1999

Developed a Public Key Infrastructure (PKI) for the automation of UK Post Offices transactions using C++/MFC, SQL Server 7 and Perl.
More

CPM UK LimitedAugust 1998 - February 1999

Developed a real-time PDA-based data capturing system for this tactical marketing company, using C++ on WindowsCE and SQLServer
More

CompuwareApril 1997 - July 1998

Developed a prototype lorry in-cab display module, which interfaced to on-board control systems, sensors and video cameras.
More

Virgin Atlantic AirwaysMarch 1994 - June 1995

Specified, designed and implemented in C++, Clipper and Oracle systems relating to management of passenger, limousine, air mile, revenue and bookings management.
More

Peter Brotherhood LtdJanuary 1991 - January 1994

Designed, implemented and commissioned industrial control systems using a variety of programming languages and hardware platforms

My stack

ERP&CRM

Oracle CRM, SAP

Analysis methods and tools

JIRA, Agile, DevOps, Enterprise Architect, CVS

Other

Servers, English, C Programming Language, Microsoft Windows, Microsoft C-SHARP, Microsoft .NET Technology, German, eCommerce, Perl Programming, strategy, IBM AS400 Hardware, Data Integration, Salesforce.com, Afrikaans, Business Process Design, Microsoft Foundation Classes, Search Engine Optimisation, ASP DotNet, Architecture, GDPR, Business Transformation, Microsoft SQL Server 2008, Data Warehousing, Complex Analysis, BSS (Business Support Systems)

Technologies

System Architect, CRM, Software Development, IIS, Integration

Databases

Microsoft SQL Server 7.0, Oracle 10g, Microsoft SQL Server 2005, MySQL, Oracle, Microsoft SQL Server

Others

Database Design, Data Migration, Consulting, Business Development, Business Analysis, Analytics, Technical Design, SDLC, Project Management, Maximo, Management, ITIL, GitHub, E-commerce, Design

IT Infrastructure

PKI, System administration, Solaris, Linux Red Hat, Unix, Linux

Business Intelligence

SSIS, ETL, SSRS, Business Intelligence, SQL Server Integration Services

Application servers

Apache

Languages

T-SQL, Perl, PHP, PL/SQL, C#, Shell Scripting, Bash, SQL, Clipper, C++

My education and trainings

Bachelor of Science, Electrical and Electronics Engineering - University of KwaZulu-Natal1984 - 1988