top of page

Retail Management System (RMS)

Updated: Aug 19, 2020

WorldSmart is a solution provider to more than 1,600 supermarkets, with more than 20,000 terminals and self-checkouts. The company established a Data Analytics and Insights division in 2015, comprising data scientist and business intelligence analysts to provide probability and regression analysis to drive loyalty, basket size and foot traffic.


WorldSmart is a Microsoft Silver Partner and early adopter of Microsoft SQL Server 2016


I designed a Retail Management System (RMS) database collection and data warehouse to consolidate all retail verticals, including Rental, Hardware, Dining, Apparel, Forecourt, Pharmacy, Grocery, Hospitality and Gaming.


Data models were based on a combination of the following, but mostly Dynamics and ARTS

  • Microsoft Dynamics AX 2012 R3

  • National Retail Federation ARTS Data Models

  • Global Standards One (GS1 Australia)

  • ISO, FIPS, ANSI, IEEE, UNSPSC

  • National Geospatial-Intelligence Agency

  • Australian Bureau of Statistics, Australian Bureau of Meteorology

  • Food Standards Australia

  • Independent Gaming Corporation.

I later commissioned an abridged version of the RMS for the company’s Data Analytics and Insights Division.

  • Required consolidating different databases and design of data pipelines, both streaming and batched from subsidiary companies and third parties.

  • Statistical inference engine to impute, clean, and enrich data, leveraging available quality rules, value correlations and reference data. Uniquely identifies a person from multiple profiles. Postal Addresses are standardised and geocoded. 84% basket items linked to master Item table.

  • The Customer Relationship Management (CRM) model combines nine dissimilar Loyalty schemes and one Income Management scheme.

  • The application tracks an individual’s grocery, liquor, petrol, pharmacy, hardware purchases and slot machine player profile.

  • Item Content Management (ICM) model contains a cleansed master Item table based on the GS1 Global Trade Item, Global Product Categorisation, DataBar and International Federation for Produce Standards (IFPS).

Comprising

  • OnLine Transaction Processing (OLTP) database

  • Extract-Transform-Load staging database, numerous C# CLR assemblies

  • Logging Database, Data Interchange, Connectors

  • Data Warehouse and Analysis Services for Reporting and Power BI Visualisation.

Platform

  • Telstra Private Cloud

  • Microsoft SQL Server 2016 Enterprise

  • SQL Server Analysis Services tabular instance

  • Power BI, Azure, SQL Server Reporting Services

Statistics

  • 2.5 million Customer Accounts

  • 980 Organisations, 269 x Legal Entity's, 711 x Retail Channels

  • 4.2 Billion Journal Items, over 2.5 million journal items per day

  • 2.1 million Global Trade Items (barcodes)

  • 72% of scanned items linked to Food Standards Nutrition Panel Calculator

  • Geocoded Postal Addresses linked to Australian Bureau of Statistics Census Data

  • Organisation Postal Addresses linked to Australian Bureau of Meteorology Station Weather Observations

  • Independent Gaming Corporation data feed for Gaming Machine / Player analysis

  • GS1 Australia Trusted Data Service and SmartMedia data feed

  • Microsoft SQL Server Analysis Services validated and refreshed every 30 minutes

Core Models

  • Organisation Model

  • Customer Relationship Management

  • Inventory and Warehouse Management

  • Procurement and Sourcing

  • Human Resources

  • Accounting

  • Logistics

  • Digital Asset Management

  • Item Content Management (ICM)

  • Categorisation

  • Nutrition

  • Retail Assortment

  • Merchandising

  • Planograms

  • Offers

  • Loyalty

  • Data Import Export Framework

  • Electronic Data Interchange and Business Rule Framework.




81 views

Comments


Commenting has been turned off.
bottom of page