New Territories, Hong Kong SAR
Experienced Business Intelligence Developer with a demonstrated history of working in the information technology, financial and services industry. Skilled in SQL, Data Analysis, Databases, Data Warehousing, and Data Mining. Strong information technology professional with a Master of Science - MS focused in Data Science and Business Statistics from The Chinese University of Hong Kong.
Data Science and Governance Department (Center of Excellence) 1. Developed digitalized solutions using the comprehensive Tableau suite to address data-related challenges for business users. 2. Leveraged the Google Cloud Platform and Vertex AI to create innovative solutions for a range of machine learning use cases with Python, including potential customer discovery, merchant name matching etc. 3. Delivered effective and engaging Tableau Prep Training sessions to internal staff, equipping them with the necessary skills to confidently utilize the platform. 4. Utilized genAI and langchain platforms to execute customized market content generation, ensuring targeted and personalized marketing strategies. 5. Leveraged genAI and langchain technologies to conduct intricate micro-economic analysis, providing valuable insights for informed decision-making and strategic planning.
1. Conducted data analysis and developed visualizations tailored to meet diverse business requirements while ensuring the upkeep of Data & Business Intelligence Application Platforms. 2. Oversaw a team and collaborated with vendors to successfully execute a system migration project to the Azure Cloud Platform within a 5-month timeframe. Successfully migrated over 100 Alteryx workflows and more than 400 Tableau data sources from on-prem servers to cloud servers. 3. Implemented a self-service environment for cross-functional team users on the Tableau Server, enabling them to access and utilize data independently. 4. Worked closely with the Data Engineer team to contribute to ETL design, data modeling, and continuous enhancement of the data platform offerings. 5. Actively engaged with various departments and teams to analyze business requirements, design solutions, implement initiatives, and facilitate product and service launches.
1. Led the implementation of Tableau for automating executive dashboard reports, resulting in streamlined processes and improved reporting efficiency. 2. Produced comprehensive reports on the impact and effectiveness of new marketing campaigns, providing valuable insights to inform managerial decision-making. 3. Analyzed and processed a vast volume of digital lead records, comprising over 60,000 rows, to generate insightful dashboard reports that assessed the performance of marketing campaigns. 4. Translated managerial strategies into clear and actionable requirements for the IT team, ensuring effective communication and collaboration throughout the delivery of DataMart projects, as well as providing feedback on UAT test results.
Companies served: HKEX, Keystone Foods, Immigration Department (HKSAR), Mitsubishi UFJ Financial Group Job Duties: 1. Engaged in effective communication with business users to thoroughly comprehend their requirements and expectations. 2. Designed and developed ETL (Extract, Transform, Load) jobs using a combination of SQL scripts and shell scripts, ensuring efficient data integration and processing. 3. Collaborated with an international team to successfully execute a comprehensive revamp of over 300 reports, ensuring their accuracy, reliability, and adherence to business needs and standards.
Companies served: Chanel, McDonald's, the Hong Kong Institute of Certified Public Accountants (HKICPA) Job Duties: 1. Developed a comprehensive data model comprising over 20 tables to support the entire project scope, ensuring efficient data organization and management. 2. Demonstrated a quick grasp of new tools, such as Pentaho Data Integration and MS Access, and effectively applied them in projects to enhance productivity and achieve project goals. 3. Provided leadership to a small team, effectively delegating tasks and coordinating efforts to ensure successful completion of assigned project deliverables.
Companies served: Shanghai Commercial Bank, Bank of Communications Job Duties: 1. Designed and implemented robust ETL (Extract, Transform, Load) jobs to efficiently process and handle large volumes of data, regularly processing over 100,000 rows of records. 2. Developed more than 20 Cognos reports, utilizing a comprehensive framework that ensured accurate and timely reporting of critical business information. 3. Collected and analyzed social media data from a vast user base of over 10,000 individuals, leveraging big data analysis techniques to derive valuable insights and support informed decision-making. 4. Collaborated closely with a team to successfully convert over 600 SQL queries from an outdated system to a new system within a tight deadline of 6 months, ensuring seamless data migration and system compatibility.