Retail Management System (RMS)

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 Microsoft News 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 pipelin es, 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.