• Design, develop, and maintain a robust data pipeline to manage over 180 datasets within the Open Data Portal, ensuring data accuracy and availability to stakeholders.• Architect and implement a modern data warehouse and AI solution leveraging cloud technologies to enhance data storage, integration, and retrieval processes.• Introduce and establish DataOps best practices, orchestrating the development process to optimize data flow, enhance collaboration among teams, and improve overall efficiency in data management.

• Architected and developed a robust data platform to ingest data from various external and internal data sources to Azure Synapse Analytics, leveraging Python, Azure Data Factory and Azure Functions to extract and transform the data• Engaged with cross-functional teams to understand the business requirements and enhance the strategic dashboards and reports using Power BI• Identified the master data model requirements from various business teams, and designed the data warehouse schemas

• Oversaw a team of 3-5 IT Specialists to successfully deploy 4+ major releases per year with projects ranging from USD$120k to USD$500k• Carried out interviews, focus groups and document reviews to elicited business requirements• Liaised with Project Owner to prioritize user requirements according to the public interest and business values• Carried out system design, algorithm design, data modeling, implementation, troubleshooting, code review, and documentation for public facing and internal applications• Navigated the outsourced contractors to understand the complex business processes using BPMN• Coached newly recruited developers to understand the holistic view of business systems• Assisted Senior Manager in financial management, risk management and resource planning

• Leaded the development team and external partners to ensure the quality in project deliverables • Streamlined the meal cart packing process with various stakeholders to increase productivity and packing accuracy• Automated the bill payment and bank cheque issuing process electronically by utilizing JPMorgan payment solution • Worked closely with the Contractor to migrate Lotus Notes applications and document libraries to SharePoint• Collaborated with the IT Service Delivery Team to establish and maintain the Data Warehouse• Mapped the data asset to business functions and visualized the data with Power BI

• Supervised a team of programmers on variety of system revamp and new factory building migration projects• Collaborated with Cathay Pacific Airways IT project team, to design and integrate system interface to the in-house ERP system• Designed high quality IT systems to support business functions and business process • Performed Oracle database upgrade, performance tuning, monitoring, backup and recovery

• Worked closely with team to develop and maintain high availability in-house ERP systems• Developed and supported in-house Procurement System, Warehouse Inventory Management System, Invoicing System and Meal Ordering System

• Arranged end-user training on an office-wide "managed print" project• Worked with local vendor to collect and dispose all old printers• Maintained the accuracy of IT inventories and assisted in internal audit