After many years working around the world in many different areas of IT, I’ve returned to one of my favourite subjects, data analysis, as it has always played a central role during the years that I have worked in the Insurance, Food, Automotive and Financial Services sectors.
I have recently spent much time and effort on inspecting, analysing, converting, cleansing, transforming and modelling data for various companies.
Experience tells me that businesses are now having to focus much more on utilising their own data productively, as well as external data, and to make use of the many insights that it can provide to maintain their competitive advantage.
Recognising this I have recently focussed on Business Intelligence software, most recently the excellent, highly rated, Microsoft Business Intelligence tools (Power Query, Power Pivot, Power View, Power Maps, Power BI Desktop, Power BI Service) and I am now very familiar with the software and it’s powerful “M” and “DAX” languages.
I have also returned to another of my favourite subjects, maps and mapping, and have now gained a good insight into the capabilities of GIS software (ArcGIS, QGIS and MapViewer 8) which can also play an important role in the provision of geographic data for use in Business Intelligence reporting.
Combining these newly acquired skills with the many years of experience that I have gained in IT in many different business areas, is where I am now focussing my efforts.
For those of you who may be interested, I speak German.
Below is information which provides more background about my IT experience.
Insightful Data Solutions Ltd., Senior Data Consultant, Reading, UK, – Present
Microsoft Power BI Apps (Power Query, Power Pivot, Power View, Power Map), Power BI Desktop, Power BI Service, “M” and “DAX” languages.
Geographical Information Systems (GIS):
ArcGIS, QGIS, MapViewer8
Productivity & Business Software:
Microsoft 365 Apps for Enterprise (MS Access, MS Excel, MS Powerpoint, MS Word), MS Visio, SAP, Custom Business Software
Crystal Reports, Business Objects
Internet Application Development:
Database Management Systems:
IMS, DB2, ORACLE 9i/10g, MySQL, Microsoft SQL Server (2005-2008), Sybase, PostgreSQL, MS Access, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS)
ASSEMBLER, COBOL, PL/1, DL/1, MARK IV, MS Visual Studio 2008, VBA, PHP, AJAX, XML, PowerQuery/”M”, DAX
Honda Finance Europe, IT Consultant, Bracknell, UK, – The previous experience gained as the IT Manager responsible, as a member of the Senior Management Group, for the successful “in-housing” of the BMW Financial Services (GB) in the UK led to taking on the role of an IT Consultant at Honda Finance Europe following their decision to bring “in-house” their own Financial Services operations from the same Service Provider, Lloyds Bowmaker.
Worked with a small, specialist team of data analysts, all with experience of the BMW Financial Services (GB) project, on the successful data migration of the Honda Finance Europe portfolio from the IT systems of Lloyds Bowmaker into their own, newly developed, IT systems.
Supported the business “post” data migration and became involved in a major review of all data held in the new IT systems, which were still being developed, as well as the data held outside of these systems.
Retained to work on a wide-ranging data project to cleanse and improve the quality of data held within all IT systems as well as to ensure that the business continued to pass its annual internal and external audits.
Involved in the analysis of the processes, procedures and IT systems of the Finance department of the company.
Introduced the streamlining of processes and the improved management of data that ensured that the reconciliation of the business could be performed with greater accuracy and in a more timely manner.
Responsible for the specification, design, development and successful implementation of a complete Cash Management and Bank Accounts Reconciliation IT system.
Various UK companies, IT Consultant, Reading, UK, –
Developed an e-Commerce presence for an international manufacturer and distributor of party products.
Wrote a management brief for a software company on the development of a technology-based “games plus media advertising solution” for a client with a large number of business outlets around the UK.
Prepared a detailed management brief on the subject of entering the “Finance & Leasing” software sector in Germany for a leading provider of IT solutions for the Automotive Financial Services sector.
GDX Automotive, European IT Manager, Düsseldorf, Germany, –
European IT Manager for this leading supplier of “Vehicle Sealing Systems” to the Automotive Industry, managing 25+ internal staff around Europe.
Responsible for the management of IT Operations in Germany, France, Spain and the Czech Republic as well as the project management of IT projects related to the restructuring, consolidation, migration and relocation of the companies’ various operations in these countries.
Brought “in-house” the previously outsourced Enterprise Resource Planning (ERP) and Financial IT Systems of GDX France that required the transfer of hardware and software resources, the establishment of a new network infrastructure and a complex IT systems and data migration.
Successfully managed the migration of all local ERP and Finance IT Systems in Germany, France and Spain from local currencies to the new “Euro” currency.
Reorganised and brought up-to-date all the Sales & Distribution, Logistics and Finance modules of the SAP implementation at GDX in Germany.
Copernicus Ltd., IT Consultant, –
IT Consultant whose role it was to research technologies such as the Internet and Mobile Internet for the purpose of using these technologies to deliver “Loan & Lease Administration” products for this successful software house that has provided software solutions to many blue-chip Financial Services companies, such as the Bank of Scotland, BMW Financial Services(GB) and ING Bank.
BMW Financial Services (GB), IT Manager, –
IT Manager for this UK subsidiary of BMW Financial Services, managing 100+ internal and external staff working on many £multi-million projects.
Responsible for the development of a new IT operations infrastructure, installation of business software (including Handheld Quotation, CRM, Process Workflow, Document Imaging, Telephony, Loan & Lease Administration and SAP Accounting systems) and the data migration of all previously outsourced legacy data. The successful completion of these responsibilities enabled BMW Financial Services (GB) to become independent of its’ Service Provider, Lloyds Bowmaker.
Major involvement in the strategic business decision to fully integrate the business of Rover, Land Rover and MINI Financial Services into BMW Financial Services (GB) after the Rover Group was purchased by BMW Group.
Played a major role in further developing the IT operations infrastructure to enable the Rover Finance ‘New Business’ loans portfolio to be successfully transferred from its’ Joint Venture partner, Lombard to BMW Financial Services (GB) and to enable the start-up of a separate Fleet Management company, Alphabet GB, tasked with managing large company car schemes for the Rover Group, BAe, and GEC.
This new IT operations infrastructure enabled the expanded BMW Financial Services (GB) company to maintain a portfolio of over 300,000 financial agreements with a value of over £1.5billion, support over 650 BMW/Rover/Land Rover/MINI Dealers and the IT requirements of 300+ staff.
BMW Financial Services, Project Manager, – Responsible for assessing, together with other senior business managers, which of the European subsidiaries of the BMW Financial Services Group were to be bought “in-house” from their local Joint Venture Partners or Service Providers.
Instrumental in the decision to start with the BMW Financial Services subsidiary in the UK and went on to play a major role in establishing the new company and negotiating and completing the transfer of business from the previous Service Provider, Lloyds Bowmaker.
BMW Japan Corporation, IT Operations Manager / Systems Development Manager, –
IT Operations Manager responsible for Project Managing the relocation of IT operations from the existing premises at Yokohama to a new Corporate Head Office in Tokyo. Also heavily involved in the project to plan the build the new head office, move the business and staff to the new location, upgrade the IT infrastructure and convert all IT software from the DOS to MVS Operating System.
Systems Development Manager responsible for the successful implementation of complex Parts Order Processing and Inventory Management software as well as the development of a local Japanese language front-end.
BMW Switzerland, IT Operations Manager, –
Responsible for the preparation of the relocation of computer operations from Zurich to the central computer centre in Munich.
BMW Japan Corp., IT Operations Manager, –
Responsible for successfully setting up a new Computer Centre, implementing BMW International Systems software and establishing a Japan-wide Wide Area Network (WAN) for BMW Dealers
Managed the localisation of the BMW International Warranty Processing, Vehicle Order Processing and Marketing Systems and the development of local Japanese language Dealer and Front-End software.
BMW AG, Project Leader / Senior Database Administrator / Senior Project Leader, –
Senior Project Leader, Feb 1985 – Jun 1987, responsible for the evaluation, selection and implementation of software development tools
Senior Database Administrator, Nov 1982 – Jan 1985, responsible for overseeing the database design for Vehicle Ordering and Warranty Processing business software
Project Leader, Jan 1979 – Oct 1982, responsible for providing programming technical support to all business software development departments.
Kraft Foods Ltd., Senior Programmer, –
Responsible for the conversion and centralisation of all of the German subsidiaries’ business software from DOS to MVS.
Altergo Software, Database Programmer, –
Database Programmer writing DL/1 business software for IBM UK.
Eagle Star Insurance, Business Analyst, –
Progressed from Trainee Programmer to Senior Programmer / Business Analyst.