Patrick Hon Email & Phone Number

As the Manager of Data Automation and Optimization, I was responsible for overseeing the loyalty points awarding data processes. I used my expertise to create and continuously improve the automated data processing system that awarded loyalty points to customers. To enhance the scalability of the loyalty awarding process, I implemented data-driven solutions that reduced the time and number of data queries needed. I also improved the stability of the loyalty awarding process by adding error-handling and self-recovery processes to ensure all points were awarded timely.I worked together with the Senior Data Enablement Manager to plan the data architecture for transitioning from on-premises Oracle to Google Cloud Platform's (GCP) BigQuery. This transition was intended to make BigQuery the primary data source for reporting and analytics, as a part of the company's data roadmap. I collaborated with both technical and business stakeholders to translate business data extraction requirements into data mappings and dictionaries, bridging the gap between technical and business understandings.As part of my role, I trained data analysts on the best practices for extracting data to improve their efficiency and understanding of the database design. I prepared standard operating procedures (SOPs), data dictionaries, data flow charts, and swim lane charts as training materials for data analysts.

In my role, I was responsible for designing, developing, and implementing data Extract Transform Load (ETL) solutions that automated reporting and data processing tasks. I also maintained data dictionaries, entity relationship diagrams, and database documentation to make it easier for my colleagues to understand the databases.To help non-technical business users analyze complex data and make quick business decisions, I created various analytical tools. I set up and managed Online Analytical Processing (OLAP) cubes in SQL Server Analysis Services (SSAS) to enable users to explore data without needing technical expertise. I also used SQL Server Reporting Services (SSRS) to generate online reports and dashboards for the business. Furthermore, I worked with the marketing team to analyze the performance of their campaigns and adjusted their strategies accordingly.

As the IT Manager, I set up, fine-tuned, and enhanced the performance of two SQL Servers (production and replicated). Also, I set up and troubleshot Windows file servers, IIS Web servers and Tomcat for JSP to ensure the critical websites were less than 1% downtime. I created Extract Transform Load (ETL) projects to store and retrieve sales data from clients and various media/newspaper vendors.My responsibility also included programmer tasks. I improved the scalability of the data processing system by converting the old FoxPro program into a Client/Server solution consisting of an ASP.NET user interface and SQL Server database backend.Being a Data Analyst, I used Geographic Information System (GIS), MapInfo and MapXtreme, to create demographic maps showing the customers' locations overlayed with their demographic profiles.

Diploma (Honours), Economics

Master Of Science - Ms, Information Technology

Bachelor'S Degree, Computer Science