Michael Smith Email & Phone Number

Melbourne, Australia

Houston, Texas Area

Shell US/Australia: Led the implementation of a data analytics solution for managing US customer compliance requirements (KYC: “Know Your Customer”) across multiple systems and operating units using Alteryx and Tableau. Customer data and associated activity was collected and integrated from 12 systems to present a unified view of the customer including fuzzy matching related accounts.➤ Collected business and technical requirements from compliance team and system specialists➤ Identified data sources and built Alteryx workflows to blend/harmonize data to a common format and fuzzy matching and other algorithms to detect duplicates and quality issues➤ Built data presentations using Tableau and Excel to assist compliance team in managing customer regulatory reporting and identify issues with system setup or compliance

Houston, Texas Area

Shell US: Led the Trading & Supply business through data migration of two highly complex mega-projects; global SAP ERP ($400M) and ENDUR trading platform ($1.2B). ➤ Focal point for business data requirement inputs and business data validation of conversion outputs. Coordinated 100+ data objects between 150 different validators across business lines. ➤ Led a team of 9 staff preparing data and building conversion programs for SAP migration➤ Lead developer for the more complex conversion routines requiring deep business and technical knowledge – primarily MS SQL Server, Oracle SQL and MS Access based tools➤ Supported the development and successful execution of the cutover plan➤ Supported speedy stabilization in a sustain and improve capacity

Houston, Texas Area

Shell US: Developed and executed early business readiness strategy to minimize costs and risks for upcoming global SAP implementation. Deliverables included:➤ Implementation of new data quality standards for US business➤ Data cleansing to adhere to new quality standards and align data across multiple legacy systems ➤ Data modelling of as-is systems and comparison to target data models to spot issues early➤ Documentation of legacy MRD processes and subsequent process improvements➤ Supported Data Governance strategy and facilitated embedding governance in the organization

London, United Kingdom

Shell UK – Facilitated the start-up of a shared service centre for data setup (MRD) in various capacities;➤ Coordinated the review and update of processes and standards for handover to shared service➤ Supported the creation of detailed work instructions➤ Led procurement of new data quality software tools including RFI, RFQ and proof of concept phases ➤ Supported organization design for MRD jobs and roles.➤ Contributed to Data Migration strategy

Melbourne, Australia

Shell Australia – Designer/Architect/Developer for a major supply chain integration and optimization project. This multi-faceted role included:➤ Participated in the architecture review board for setting the functional and technical direction of the project and assessing changes impact assessment➤ Led the solution design for middleware “Information Layer” including a central data repository and integration with source systems➤ Lead developer for the proof of concept phase using IBM WebSphere EAI➤ Coordinated solution delivery with 3rd party architects and offshore developers for new supply chain application required to integrate with the “Information Layer”

Melbourne, Australia

Variety of application development roles including implementation of data warehouses, business intelligence universes and reporting and SAP Portals among other things.