Gerrit H.

ARCHITECT

879 dollar
Freelancer
26 ans
London, UNITED KINGDOM

Mon expérience

Hamburg Commercial BankJuly 2019 - Présent

Voir plus

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.
Voir plus

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.
Voir plus

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.
Voir plus

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.
Voir plus

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#.
Voir plus

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.
Voir plus

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.
Voir plus

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.
Voir plus

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.
Voir plus

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.
Voir plus

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.
Voir plus

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...
Voir plus

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

Server and network hardening, database optimization, SEO analysis.
Voir plus

IMS HealthJune 2008 - June 2009

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

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.
Voir plus

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.
Voir plus

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.
Voir plus

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.
Voir plus

ABN AMROJanuary 2006 - April 2006

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

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.
Voir plus

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.
Voir plus

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.
Voir plus

Met OfficeMarch 2003 - May 2003

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

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

Design and development of bespoke data warehouse loading system.
Voir plus

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
Voir plus

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
Voir plus

weCommDecember 1999 - June 2000

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

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.
Voir plus

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
Voir plus

CompuwareApril 1997 - July 1998

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

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.
Voir plus

Peter Brotherhood LtdJanuary 1991 - January 1994

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

Mes compétences

UNIX, Technical Design, T-SQL, System Architect, System administration, SSRS, SSIS, SQL Server Integration Services, SQL, Solaris, Software Development, Shell Scripting, SDLC, SAP, Salesforce.com, Project Management, PL/SQL, PKI, PHP, Perl, Oracle CRM, Oracle 10g, Oracle, MySQL, Microsoft SQL Server 7.0, Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server, Maximo, Management, Linux Red Hat, Linux, Jira, ITIL, Integration, IIS, GitHub, ETL, Enterprise Architect, E-commerce, DevOps, Design, Database Design, Data Warehousing, Data Migration, CVS, CRM, Consulting, Clipper, C++, C#, Business Intelligence, Business Development, Business Analysis, Bash, Apache, Analytics, Agile