UnivarSAP Migration Architect
May. 2011 - May. 2013EuropeSAP Migration Architect\Team Lead for Univar SAP EMEA rollout. Responsible for technical leadership during creation of automated SQL Server (inc SSIS) based toolset for management of mapping\tracking processes, transformation framework and creation of standard SAP format load files.
Technical architect for creation of sql server toolset. Managed the creation of a SAP data dictionary based process for automating extracts out of target and source SAP instances. Implemented automatic extraction of SAP configuration data into repository for local validation of load data prior to extract into SAP load format, ensuring high level of data readiness and quality prior to load into SAP system. This greatly reduced the issues associated with a trial and error based approach and lead to delivery of SAP friendly data against tight deadlines and for high volumes of data. Managed team of 5 developers in the delivery of transformation routines within toolset. Toolset was used to transform data from a variety of sources including SAP 4.7, DB2, Baan, Oracle etc. Individually responsible for the mapping, extraction and transformation of all FtS (Forecast to Stock) data including Material Master, Warehouse management, Production Planning, Quality Management & Stock Control modules for Wave 1 deliverables (Benelux companies) and Wave 2 deliverables (Nordic and Iberian companies). All deliveries were achieved via the transformation toolset developed.