My Items

Arnhem Land Progress Aboriginal Corporation (ALPA), established in 1972, is an Aboriginal-owned benevolent organisation which provides benefits to its members from the successful operation of community retail stores.
Compulsory Income management was introduced to many Aboriginal communities in 2007 in the Howard Government's Northern Territory Emergency Response (NTER). Income management works by quarantining a proportion of social security payments. This money can only be used to buy ‘essentials’. Income managed funds must not be spent on prohibited items, including alcohol, tobacco, gambling and pornography. Recipients must negotiate arrangements with CentrePay to pay bills using the quarantined amounts. The ALPA FOODcard evolved from community consultations in Gapuwiyak in 2004 and is designed to be a tool to help families to regularly eat healthy meals throughout the whole pay cycle. It has been hugely successful, according to ALPA, with 12,500 people across the region participating in its decade of operations, voluntarily allocating some $15 million in income to “healthy choices” as determined by the community.
Technical objective Design an Income Management system with the following functionality/components. Offline capability Smartcard based Income Management system which could be operated for several days off-line. Customers may choose to have a percentage of their pay automatically paid into their FOODcard then spend that money over the remainder of the pay cycle or period on a selected range of food and household essentials. The card contains payment sequence interlock to prevent multiple payments between stores when communications are down. It is common for a card holder to migrate to other stores which may or may not have internet connectivity. Regulatory Compliance FOODcard must comply with Government legislative and privacy requirements. The system must be auditable by Department of Families, Housing, Community Services and Indigenous Affairs (FaHCSIA). Satellite network The system required a secure private Satellite network that operates on a national basis independent of conventional telecommunications infrastructure. Remote sites such as Elcho Island are located off the coast of NT, bounded on the western side by the Arafura Sea. During certain times of the year, energy from the Sun can overpower a satellite's signal (Sun fade), the system will automatically failover to conventional telecommunications infrastructure. Installation of Wireless Point-to-Point Microwave Bridge Links between buildings on same site acting as a transparent extension of the Ethernet backbone or segment. Smartcard EMV compliant microprocessor Smartcard capable of storing Biometric (photograph) and CentrePay income managed fund (IMF) data. The card functions as an independent data storage device such that card holder can purchase goods irrespective of frequent breakdowns in the communication system at a particular site. The card file system efficiently structured to allow over 4K of biometric data to be read in timely manner. Kiosk One or more pending IMF payments are loaded onto the card when the card is inserted into one or more Kiosks located in the foyer of each supermarket The Kiosk notifies card holder of when a payment has been transferred, if no payments are pending and the total balance A built in price check scanner also indicates if scanned item can be purchased off FOODcard Grocery Checkout The ALPA Member Stores utilise Worldsmart Retail Grocery Manager. The technological challenge for Worldsmart Technology was to develop a mechanism to interface with Worldsmart Grocery Manager to support Income Managed Funds. When a FOODcard is inserted into checkout card reader, the console operator is prompted to view a photograph of the primary card holder and up to fifteen additional authorised users of the FOODcard The balance on the card is displayed, the balance reduces as each item is rung up on the register. The card cannot be overdrawn. Items blocked by the register for purchase from the FOODcard can then be paid using cash or EFTPOS by the customer Data Pipeline SQL Server Service Broker provides native support for messaging and queuing to the central WorldSmart SQL Server Database and Azure SQL Managed Instance. The system required the capability of transmitting secure data over an unreliable network in real time In order to download payment data upload POS sale basket.

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.

This project explored data insights and determinants for a new Hotel, Located in Metropolitan Adelaide based on following criteria: Local Government Area with high gaming revenue Geodemographic classification of city amenities by applying a clustering algorithm Customer demographics for customer insights and segmentation Located on a main arterial road with medium to high traffic volume Located in proximity to shopping complex or transport hub High population density Avoid locations where the competitor hotel has a dominant presence Python Code Jupyter notebook Presentation Report

The NextGen Pole Mount Player Interface Module features a high-resolution 7.0-inch IPS 1200×1920 glass to glass projected capacitive touch digitiser and a Bezel-less CNC machined hardened aluminium alloy enclosure. Designed to fit adjacent and between slot machines with dual side speakers, a vandal-resistant smart card reader, an NFC reader-writer and secure network over private (LAN) via several PoE managed switches. Includes an innovative Bluetooth Low Energy iBeacon that enabled geo-fencing for proximity marketing and cardless login via smartphone. Loyalty, cashless gaming, pre-commitment, integrated point of sale food and beverage orders. Gamification via animated video promotions, bonus offers and community bonuses. An integrated content management system for publishing and management of digital signage content. Live statewide two level linked jackpot plus local linked jackpot English and Chinese language functionality. All components bespoke, Mechanical, Electrical & Electronic ( Autodesk Inventor, Altium ) Including Digitizer, CNC enclosure, T ubular support pole, Looms, Printed Circuit Board. ODM Kiosk customized to support Smartcard reader mechanism. Conducted market analysis, determined the viability of offshore manufacturing and fabrication and established a vendor network throughout China, Taiwan, the US and Singapore. Established a sea and airfreight logistics network, to minimise port handling charges and road freight costs. I developed a hardware abstraction layer to provide a unified Windows software interface for Neuron® 5000 and NextGen P layer Interface Module to enable the re-use of software, product validation and business processes that support software development. Both Neuron® 5000 and NextGen Devices can be installed together in one site to one host. Consolidated application development platforms and code libraries to simplify IT architecture management and accelerate the rate of application deployment while reducing total costs. Device agnostic web API and relational database management system NextGen, Kiosk installation and Mobile App best viewed at 'The Glenelg Club' gaming room Link to Jackpot Club Android App https://play.google.com/store/apps/details?id=com.Jackpot.LoyaltyApp&hl=en_AU Feature • High resolution 7.0-inch IPS Touch Screen 1200(RGB)×1920, WUXGA • Cashless Gaming • BLE iBeacon for Proximity marketing and Cardless sign in via smartphone • NFC Reader-Writer supporting all NFC Forum modes • Centralized Digital Signage, Video and Image • PlaySmart pre-commitment • Food and Beverage ordering • Animated Video Promotions (Gamification) • Multi-Lingual (English and Chinese) • Live statewide two level linked jackpot plus local venue linked jackpot Technical Specification • Processor Intel® Atom™ x5-Z8350, Intel HD Graphics 400, Windows 10, 64bit • Display IPS LCD Screen 1200(RGB)×1920, WUXGA, Size 7.0-inch Portrait Touch Screen • Glass to Glass Projected Capacitive Touch Touch Surface hardness ≥ 7H • Power Supply PoE, IEEE802.3af, DC DC isolated Power over Ethernet • LAN - 8 port gigabit managed PoE switch 2.4GHz / 5.8GHz Wi-Fi: IEEE 802.11a /b/g/n/ac • Multimedia USB Stereo Speakers, Virtual 7.1CH effects • Enclosure CNC Machined A6061-T6 hardened Aluminium Alloy • Smartcard Connector ISO-8, Landing Contact, Min 500,000 insertion cycles • Smartcard Contact CCID, WHQL certified, ISO7816 Class A/B/C, T=0, T=1 S=8, S=9, S=10 • Contactless T=CL, MIFARE®, iCLASS®, ISO 14443A/B, iCLASS 15693, NFC Tag 1,2,4 • Bluetooth Low Energy iBeacon (Advanced Proximity Hardware)

The challenge was to design an inexpensive single cavity thermoset injection enclosure and tubular support pole which could support either s martcard or magnetic reader mechanism with optional NFC (Near field communication) reader writer. Between 1999 and 2018 over three thousand, magnetic and smartcard variants were manufactured and installed throughout South Australia, Queensland and Northern Territory. During this time, I developed an expert knowledge coding Neuron® C, OpenLDV and Echelon's LNS® Network Operating System. I wrote an interface that enabled Windows applications to send and receive low-level messages through Echelon's LonTalk implementation of the ISO/IEC 14908 Control Network protocol, for Layer 2 or Layer 5 network interfaces. Researched and collated most of the LNS Data field structures for explicit messages, network variables, n etwork management and diagnostics and exposed via a Dynamic-link library . Coded an ActiveX Exe out of process server for third party application. LNS licencing and installation tools no longer required. The device integrates a high-performance Echelon Corporation FT-5000 Smart Transceiver for the LONWORKS® 2.0 platform with a free topology twisted-pair transceiver and three independent 8-bit logical processors to manage the physical Media-Access Control (MAC) layer, the network, and the user application. Neuron® C code highly optimised to fit into an application code block of only 42KB. Including IO peripherals, LCD and keypad, encrypted telemetry APDU, cryptographic algorithms for BlockChain, 3DES and Mutual Authentication to Host Security Access Module and support for a total of twelve EMV compliant microprocessor Smartcard platforms. Technical Specification Single cavity thermoset injection mould requiring 140 ton hydraulic push pull ejector. Contactless option supports all variants of the MIFARE Mini, MIFARE 1K, MIFARE 4K, MIFARE Ultralight, MIFARE DESFire EV1 and MIFARE Plus RF identification protocols. Magnetic, ISO 7811 track 2 or ISO 3554 track 1 Contact Asynchronous: T=0; T=1 Synchronous: S=8 (I²C) ; S=9 (3-wire); S=10 (2-wire) ISO 8 Landing Contacts, 500K insertion cycles 2 x 16 character LCD, 85db Transducer, 6x2 keypad 4-34VDC Buck-Boost Switching Regulator 80Mhz Neuron® Core Network Length: Free Topology 2700m (8,850 feet) with no repeaters Transmission Speed: 78 kilobits per second Power and Communications over Cat5/6 patch cable, up to ten devices daisy chained via network splitters to 16 port rack mount Neuron® 5000 Power Control Unit(s) Neuron® 5000 Power Control Unit connected to PC LonTalk Interface. Remote port switching and monitoring of current, temperature, voltage. Individual MOSFET controlled overload protection.

May 2000, WorldSmart's business was rapidly expanding. Liquor & Gaming NSW granted WorldSmart a gaming machine manufacturers licence and WorldSmart was appointed VISA preferred supplier in Australia for the VISA open platform Smartcard. The challenge was to design an EMV compliant Player Interface Module suitable for a Club market with over 100 gaming machines per site. The device had to be small enough to be mounted between the screen and top box of an older stye gaming machine collar and able to support an 800 by 600 TFT touch panel for larger machine collars. CCCE is a Communications Protocol for New South Wales Electronic Gaming Machines. In both Cashless and Gambling Harm Minimization modes, the PIM can inhibit machine play and transfer credits to and from the player account Features • Intel XScale® 315-520 MHz PXA-270 RISC Processor, 30 to 35% over clocking option • Microsoft® Windows® CE 5.0 • Power over Ethernet (IEEE 802.3af compliant) • Optional OLED (Organic light-emitting diode) display • Bi-directional Voice over IP for remote assistance and media streaming • Charge-transfer capacitive sensor touch-key keypad with self adhesive Digital Print facia • NSW CCCE RS422 Communication Port for Cashless Gaming • Compliance with national jurisdictional legislative and regulatory gaming requirements Technical Specification • Intel XScale® 315-520 MHz PXA-270 RISC Processor, 30 to 35% over clocking option • 64MB SDRAM (32 Bit) RAM • 32MB NOR (32 Bit) Flash • Industrial temperature rated: −40 ° to 85 °C • Operating System Microsoft® Windows® CE 5.0 • Database Microsoft SQL Server Compact • OLED 160 by 32 dot matrix LCD STN (Yellow-green) Viewing area 99 by 24 mm • TFT/STN/LVDS flat panel port to support displays up to 800 by 600, 24-bit color pixels • Touchscreen Controller 4 or 5-wire • Camera interface(QCI) • 1 x IEEE802.15.4/ZigBee expansion port • I ntegrated WLAN (WiFi) interface implements 802.11b/g • Power Supply PoE, IEEE802.3af, DC DC isolated Power over Ethernet • LAN - 8 port gigabit managed PoE switch 2.4GHz / 5.8GHz Wi-Fi: IEEE 802.11a /b/g/n/ac • Multimedia USB Stereo 4 watt Speakers, AC-97 v.2.1 compliant • Omni-directional microphone with integrated amplifier for remote assistance • Smartcard Connector ISO-8, Mechanical locking system, Electromechanical release • Charge pump for solenoid electro mechanical release • Smartcard Contact CCID, WHQL certified, ISO7816 Class A/B/C, T=0, T=1 S=8, S=9, S=10 • Smartcard Contactless T=CL, MIFARE®, iCLASS® ISO 14443A/B, 15693,NFC Tag 1,2,4 • Magnetic, ISO 7811 track 2 or ISO 3554 track 1 • Mini SD card for secure loading of application image (up to 1 Gigabyte) • New South Wales CCCE RS422 Communication Port for Cashless Gaming • Charge-transfer capacitive sensor touch-key keypad with self adhesive Digital Print facia • 32 input membrane switch connector with ESD protection • 3 x high speed UART, 3 x synchronous Serial Protocol (SSP) serial ports • 2 x USB Client, Host and On-The-Go controller • OEM expansion connector, data and address bus, I2C, serial, PS2, reset, power and USB • 16 x discrete inputs 72 VAC input tolerant • I/O and communication driver chips ±15kV ESD-Protected

The challenge was to design a LonWorks® EMV compliant Player Interface Module (PIM) supporting CCCE Cashless and Gambling Harm Minimization while small enough to be mounted between the screen and top box of an older stye gaming machine collar. CCCE is a Communications Protocol for New South Wales Electronic Gaming Machines. In both Cashless and Gambling Harm Minimization modes, the PIM can inhibit machine play and transfer credits to and from the player account. Incorporates a Neuron 3120® LonTalk communications coprocessor memory mapped to the ARM7TDMI™ ARM® host microprocessor. ARM application code written with a mixture of ARM Assembler and C/C++. The most notable achievement is the ability to update ARM application code via LonWorks® Typically forty devices are signaled to reboot into bootloader mode. The ARM AXF file is split into foreign frame packets and broadcast via LonWorks® into ARM memory. On completion the checksum is compared and copied to ARM Flash. Technical Specification • ARM® ARM7TDMI® 40 MHz 32-bit RISC Host Processor • 64KB (16 Bit) SRAM, 2MB (16 Bit) Flash • Neuron 3120FE5 ® LonTalk communications coprocessor • Memory mapped to the core processor, slave B mode token passing • 4 Kbytes internal SRAM, 3 Kbytes internal EEPROM, 16 Kbytes internal ROM • Real-time clock/calendar with alarm, watchdog, power-on reset, battery monitor • 2 x 10 Amp MOSFET relay driver • LCD, 16 character by 2 lines, 122.0 x 44.0 mm • Piezo beeper • Dallas iButton port • Switch mode and linear regulator (5 and 3.3 volt, 1.0 amp) 10-34 volt input • Smartcard Contact CCID, WHQL certified, ISO7816 Class A/B/C, T=0, T=1 S=8, S=9, S=10 • New South Wales CCCE RS422 Communication Port for Cashless Gaming • 36 input membrane switch connector with ESD protection • OEM expansion connector, data and address bus, SPI, reset and power • 2 x high speed UART, 3 x synchronous Serial Protocol (SSP) serial ports • Full duplex, 115k baud, interrupt driven with receive timeout and time guard register • 6 x discrete inputs 72 VAC input tolerant • I/O and communication driver chips ±15kV ESD-Protected • Industrial temperature rated: −40 ° to 85 °C