Led and hands-on to deliver PD Patient Tracker; delivered a high-level insight for PD patients around Asia Pacific. Including data pipeline design and implementation, regional data model.

PD Patient Tracker is a consolidation of all country data feeding their local dashboard that supports their operation into a regional senior management insight. Built using table with an Oracle database. Features aligned local hierarchies to a globally understood structure.

Design and developed a data strategy to  acquire, consolidate and harmonise regional data to a more controlled single source of truth for data across the region.

This is an Asia Pacific regional data strategy to reduce/eliminate sharing data using files (Excel, CSV, TXT) on emails and shared drives. Driven by a concern raise by country users being requested the same data in different format from regional team members. These files then flies around on emails or links to shared folder.
Solution built was to capture these data into a database, structures aligned and process in capturing the data in placed for the country. The biggest challenge in this project was the different commercial practices in each country and regulatory regulations.

Japan's commercial data and process migration from the iSeries (AS/400) to an Oracle database including the use of Oracle Application Express for data maintenane and management.

Cost forced Japan to move from the iSeries to another platform due to high maintenance cost of the AS/400. All commercial data was moved from the AS/400 to an Oracle database and utilising the regional data warehouse as the source of major ERP data and migrated all their EDI acquired secondary sales data. My envolvement includes review of current process, system design, development and implementation. Few items were delivered in this project which included business intelligence, rental billing process, maintenance and management applications and the EDI integration.