INDUSTRY EXPERIENCE
TAPWARE & BATHROOM FITTINGS
Complex Manufacturing Data & ERP Migration
Prepared and validated complex product, purchasing, inventory and manufacturing data for migration to SAP S/4HANA Public Cloud.
Developed and executed over 560 data checks covering 16.8 million data values, identifying inconsistencies and investigating exceptions across multiple migration cycles.
Built repeatable Excel and Power Query processes to prepare and validate interconnected product characteristics, Bills of Materials, routings and production versions, while supporting business knowledge transfer.
Result: 99.9% migration load success rate.
What This Demonstrates: Successful data migration requires more than transferring records. The relationships, business rules and dependencies within the data must also be understood and validated.
Capabilities: Data Check | Data Build | Data KT
PATIO & OUTDOOR STRUCTURES
Product Data, Pricing & Business Processes
Investigated Pronto master data, including items, suppliers, pricing, product attributes and Bills of Materials, identifying data quality issues and inconsistencies affecting business processes.
Analysed business rules, data relationships and manufacturing scenarios, developing prototypes to explore Make-to-Order and Engineer-to-Order processes, evaluate system capabilities and identify operational constraints.
Documented findings, business impacts and potential improvements to support informed decisions about data readiness, manufacturing processes and future system design.
What This Demonstrates: Data quality problems are often connected to underlying business processes, system configuration and operational decisions. Investigating the data can reveal business problems that are not immediately visible.
Capabilities: Data Detect | Data KT | Business Action
GLASS & BUILDING PRODUCTS
Data Readiness for Digital Commerce
Investigated and profiled product, customer, supplier and sales-order data to assess data quality and readiness for integration between an existing ERP system and Shopify.
Used AI-assisted techniques to extract product information from existing business catalogues, building structured product and variant data in Excel for upload into Shopify.
Developed Power Query processes, field mappings, data validation checks and cleansing recommendations to improve data quality and consistency.
Developed Power BI reporting to make data gaps, cleansing priorities, outstanding business actions and progress visible to stakeholders, providing a clearer understanding of the work required for implementation.
What This Demonstrates: A successful digital commerce initiative depends on the quality and consistency of the underlying business data. Technology creates opportunities, but reliable business data provides the foundation.
Capabilities: Data Check | Data Build | Data Gap