Learn Data Skills
Beta
Johnson Pak lam Ip

Johnson Pak lam Ip

Data Management

| UK

Technologies

My Portfolio Highlights

My New Track

Associate Data Engineer

My New Dataset

OCBC Enterprise data warehouse

My New Dataset

eMPF Administration System

My New Track

Associate Data Engineer

ETL, data mapping and gap analysis, data cleansing, data modeling, and data warehouse/data mart design, data Management

My Work

Take a look at my latest work.

dataset

IBOR reform

SQLShellSpreadsheets
dataset

OCBC Enterprise data warehouse

dataset

eMPF Platform

SQLShellPower BI
dataset

IBOR reform

SQLShellSpreadsheets

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

GARP Certified Financial Risk Manager (FRM)

CFA Institute Certified Financial Analyst (CFA) Level 1

ISACA Certified Information Systems Auditor (CISA)

SAS Institute SAS Certified Data Warehouse Architect

Oracle University Oracle Database Certified Associate

Coursera Python and Statistics for Financial Analysis

Tableau Tableau Desktop Specialist

Coursera Google Cloud Platform Fundamentals

DataCamp Course Completion

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

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

eMPF Platform Company (Subsidiary of MPFA) | Jan 2022 - Jul 2024

Senior Manager of Data Service, Digital and Information Technology Team

• Managed the migration of data from 13 trustee administration systems to the eMPF administration system. • Analyzed data architecture design ( e.g. Power BI reporting ) and monitored vendor deliverables to ensure quality and timely completion. • Developed specifications for data migration, data model and data dictionary, including interfaces for the data extraction, data warehouse and data mapping. • Reviewed data migration test results to ensure compliance with data requirements, data quality and project timelines. • Collaborated with cross-functional teams on data services and system architecture to optimize project outcomes.
Show More

Bank of East Asia | Apr 2020 - Jan 2022

Systems Development Manager, Core Banking

• Analyzed user requirements and designed enhancements for the core banking system. • Planned projects and estimated team resources. • Conducted technical evaluations and system designs. • Led system development, testing, and implementation. • Provided ongoing support for the system.

OCBC Bank | May 2009 - Apr 2020

Senior Project Manager / Data Steward, Data Governance Office

• Managed BI projects (e.g. SAS, Power BI, QlikView) focusing on architecture design, data analysis, data modelling and ETL implementation. • Supported group MIS projects in data profiling, mapping, and gap analysis. • Led data quality monitoring initiatives and collaborated with business units to resolve data issues and conduct data cleansing • Conducted reviews and updates of data governance and quality policies. • Implemented credit risk data mart and enterprise data warehouse, designing data models and repository systems.

SAS Institute Co. Ltd. | Sep 2007 - May 2009

Senior Consultant

• Managed data mapping and requirements for the marketing data mart for the Hong Kong Jockey Club. • Customized and configured SAS marketing solutions. • Designed and developed ETL processes.

PCCW | Nov 1997 - Sep 2007

Senior Solution Analyst

• Designed data marts for revenue management and customer relationship management. • Developed and optimized ETL processes for timely data delivery.

K Line Air Service Co. Ltd. | Aug 1995 - Oct 1997

Assistant MIS Manager

• Prepared regular and ad hoc reports for finance, sales, and operations. • Monitored internal information systems and supported budget planning for business solutions.

My Education

Take a look at my formal education

Master of eCommerce in eCommerceOpen University of Hong Kong | 2005
Bachelor of Computer Science in Computer ScienceThe Chinese University of Hong Kong | 1995

About Me

Johnson Pak lam Ip

I am an enthusiastic learner in data technologies with expertise in ETL design and development, data mapping and gap analysis, data cleansing, data modeling, and the design of data warehouses and data marts.

Powered by

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