MY WORK
Delivered various challenging enterprise projects from end to end to help business make data driven decision and improved efficiency of business operation in the Financial, Retail, Health Supplement, Non-Profit, Consulting and IT Services industry
RETAIL - DATA WAREHOUSE AND DASHBOARD
Designed and developed the leading supermarket's online sale & ecommerce store operation DW & dashboard using Azure data warehouse, Azure Data Factory, Azure Analysis service cube and Power BI technologies. The solution has gone live and essentially gives business property “GPS” to navigate the business operation, which helps business to improve the customers’ satisfaction, increase the online sales and save cost
TOURISM - DATA AUTOMATION & DASHBOARD
An Azure Cloud solution incorporating Synapse, Azure Data Factory, and Azure SQL provided the infrastructure for the Power BI Reports. We were able to help deliver detailed analytics of bookings, searches, flights, and visitor surveys, providing instant insights to a range of staff from Analysts to C-Suite Executives
ENTERTAINMENT - BIG DATA & REALTIME ARCHITECTURE
Delivered a real time big data architecture including designing big data, real time, IoT, machine learning and advanced analytics platform.
HEALTH - DW FOR DIGITAL MARKETING
Designed & developed ETL, data warehouse, cube, and reports for Digital Email Campaigns. ETL pipelines using Azure Data Factory and Logic Apps to extract data from SharePoint and Rest APIs. The automation saved the client lots of time.
MOTOR - BENCHMARK BI SYSTEM
Delivered data warehouse, ETL and reports. It enables clients to analyses the financial data of motor dealers in the industry to uncover the underlying performance issues and to help dealers and car brands identify the opportunities in the business
FINANCE - DW DESIGN AND REPORTING
designed & developed the new data warehouse, cube, ETL and reports for the mortgage sales from scratch. The reports were being used by sales managers and executives on daily base.