Learn Data Skills
Beta
Lap Keung Szeto

Lap Keung Szeto

Certified

Data Analyst

| UK

Technologies

My Portfolio Highlights

My New Certification

Data Analyst Associate

My New Certification

Data Analyst Associate

Data conductor, orchestrating the symphony of insights with precision.

My Work

Take a look at my latest work.

course

Database Design

SQLTheory
course

Data Manipulation with pandas

PythonTheory
course

Analysis in Excel

TheoryExcel
course

Cleaning Data in PostgreSQL Databases

SQLTheory
course

Data Communication Concepts

SQLTheory
course

Understanding GDPR

Theory
course

Database Design

SQLTheory

My Certifications

These are the industry credentials that I’ve earned.

Data Analyst Associate

Data Analyst Associate

Other Certificates

Project Management Institute Generative AI Overview for Project Managers

Project Management Institute Talking to AI: Prompt Engineering for Project Managers

Project Management Institute Project Management Professional (PMP)®

Project Management Institute PMI Agile Certified Practitioner (PMI-ACP)®

Scrum.org PSM I

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

J&E Group Limited | Mar 2023 - Feb 2025

Information Technology Support Assistant

● As a retail analyst for a company with 20 shops, 1 warehouse and over 14,000 products, I generated 30+ weekly analysis reports and cleaned, managed, analysed, and visualised sales data. ● Utilized a CRM system for managing suppliers and tracking customer interactions during campaigns. ● Excel gathers and analyses data from various systems, including QlikView, warehouse management systems, and POS Navigator. ● Developed over 20 automated Excel reports using formulas and VBA macros for increased 70% efficiency and productivity. ● Committed to driving organisational success through strategic reporting and data-driven decision-making. ● Assisted in system migration by cleansing and transferring over 14,000 product and stock records to a new system, ensuring accuracy and enhancing efficiency. ● Collaborated effectively with stakeholders to gather requirements, identifying data trends and root causes for precise analysis and informed decision-making.
Show More

Axics Education | Oct 2022 - Feb 2023

Teaching Assistant

● Worked well with support staff, teachers and professionals such as educational psychologists. ● Helped teachers organize student records, including grades and attendance, wrangling students on school grounds and off.

Funki Finance Limited | Feb 2021 - Nov 2021

Technical Project Manager

● Worked for a £500K end-to-end money lending system project in a startup fintech company. ● Quickly capture project requirements and effectively clarify project vision to deliver high business value projects. ● Achieved company-high lending business retention of 70% through better data control and auto-generating lending contracts. Increased the total number of consumers and the entire lending amount by more than 60%. ● Driven agile project development with all stakeholders. ● Developed the lending system, which has allowed applicants to lend money and e-signature online. ● The leading team used MySQL, Java, JavaScript and microservices architecture to deploy to the AWS cloud. ● Reduced monthly AWS cloud service cost by 30%. ● Responsible for building and managing the IT team to develop core systems and operations, overseeing software vendors' development.

TFI Digital Media Limited | Dec 2017 - Dec 2020

Assistant Project Manager

● Achieved a hybrid AGM platform project for the client, so the project budget is over £100K. ● Led internal project budget review and achieved 30% savings in monthly operation costs. ● Prioritised and resolved multiple maintenance 4 projects in parallel ● Engaging with the customers’ project and company key stakeholders to define business requirements and agree on baselined time, cost & quality. ● Managed the development team using MySQL and Java in live streaming projects. ● Implemented Google data analytics for over-the-top (OTT) media service, CRM, and E-commerce.

TFI Digital Media Limited | Oct 2014 - Dec 2017

Senior Analyst Programmer

● Delivered over 5 iOS and Android applications for video streaming projects. ● Clarify the 100+ requirements and provide new technical solutions with teammates. ● Successfully communicated and co-worked with UX design, front and backend, and infrastructure service teams. ● Improved team quality by code review, defined test cases and fixed program bugs.

My Education

Take a look at my formal education

MPhil of Department of Computer Engineering and Information Technology in Department of Computer Engineering and Information TechnologyCity University of Hong Kong | 2004
Bachelor of Engineering (Second Class Honors) Degree in Computer Engineering in Computer EngineeringCity University of Hong Kong | 2001

About Me

Lap Keung Szeto

Experienced Data Analyst and IT Project Manager with over 10 years of experience in data analysis, software development, and project management.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free