Duncan Wallace

Senior Consultant/Data Analyst specializing in retail location planning and ETL for Automotive OEMs. Tools and technologies used: Microsoft SQL Server, Power BI, Alteryx.

Provide IT consulting services to a major pharmaceutical industry client, in particular supporting the global drug safety operation. Manage a Amazon AWS cloud infrastructure platform for application development. Develop applications using PHP, MySQL and Linux.

Delivered a review and recommended improvements of business processes in the areas of waste collection and vehicle fleet management.

Project Manager of IT systems deployment of global retail network database. Performed business analysis and business intelligence reporting to support UK franchise operation: sales performance, geo-demographic analysis, retailer KPI, market analysis. Defined and implemented new business processes for the adoption of Peugeot and Citroën franchises by new retailers. Provided operational support to new franchise retailers in their use of corporate IT systems.

Developed and deployed Peugeot UK's first business intelligence CRM database and provided regular and ad-hoc analysis for senior management teams of sales and marketing. Technology used: SAP Business Objects. As Project Manager, successfully deployed four systems covering all sales reporting and sales BI requirements for the Peugeot brand in the UK. Technology used: SAP BW, SAP Business Objects, IBM Cognos. Developed a new suite of retailer KPIs.

Controlled UK IT division's budget. Produced budget forecasts for IT Director and head office in Paris, planned annual budget spend for department, worked with management team to implement cost reductions of 20%.

Managed two business-critical data centres supporting car manufacturing and spare parts logistics facilities. Worked in close international coordination with operations teams, operating systems experts, and server and storage OEM’s to install and maintain data centre infrastructure. Supervised resolution of IT incidents affecting production plant and logistics centre. Coordinated formal investigations of major IT incidents, identified causes and implemented corrective action plans.

Two-year secondment working and living full-time in Paris, Java developer for vehicle recall system.

Analyst programmer on global warranty system. Member of the product launch team delivering major version upgrades into pre-production and production.

Software development, Java, SQL, conceptual database modelling, business information systems

Economics of the European Union

International Finance, Economics of the European Union