Ban Yong Lim
Senior Data Engineer
Petaling Jaya,10
Summary
I am a seasoned Data Engineer with 9 years of experience specializing in the E-commerce and Financial industries. Proven expertise in designing and implementing robust data solutions, optimizing data processes, and ensuring seamless integration within complex environments. Adept at leveraging technology to drive business intelligence and enhance data-driven decision-making. Eager to bring contribute experience and technical skills to contribute effectively to challenging projects and foster innovation within a dynamic team
Overview
9
9
years of professional experience
4
4
years of post-secondary education
4
4
Certifications
5
5
Languages
Work History
Senior Consultant - Data Engineering
Capco Consultancy
Kuala Lumpur, Kuala Lumpur
04.2024 - Current
- Squad lead for an enterprise-wide process mining initiative for Prudential, a key global insurer, targeting core insurance lifecycle processes.
- Deployed process mining solutions across critical functions: New Business & Underwriting, Claims, Policy Administration, and Policy Servicing.
- Architected and integrated data from diverse front-end/back-end systems; designed harmonized data models and defined event-object mappings to unify cross-system process flows.
- Partnered with senior leaders across Prudential's regional units to co-develop data-backed insights driving process optimization and operating model redesign.
- Facilitated cross-functional workshops between Insurance Ops SMEs and business leaders to define improvement initiatives and track KPI-driven outcome.
- Spearheaded the migration of Trade Finance reporting from legacy systems to a new strategic platform as a Core Data Engineer at Standard Chartered Bank.
- Orchestrated the end-to-end development lifecycle: gathering business requirements, designing robust data pipelines and implementing scalable solutions.
- Optimized report generation performance and established comprehensive testing protocols, including unit, integration, and performance testing.
- Accelerated delivery timelines, successfully deploying 11 critical Trade Finance reports ahead of schedule.
Senior Data Engineer
Lazada South East Asia
04.2022 - 02.2024
- Developed, implemented and maintained Logistics Domain Data. Including sourcing, data modelling and data application layer.
- Designed and implemented effective data model solution for Real Time Sort Visibility Project. Provide visibility for sort center on each sort process backlog.
- Designed data model solution for Return & Reverse Domain from 0 to 1. Common data model covers all scenarios : Return Initiation, Return Leadtime, Refund Leadtime, Return Logistic, Disputes and Quality Control.
- Responsible for ETL task for Lazada Payment Domain (Cash Loan & Seller Loan)
- Analyze and support Production issue to mitigate impact to user.
Big Data Developer
Mercedes Benz Bank AG
09.2019 - 03.2022
- Lead cross-functional agile teams to develop automated solution for Risk Management regulatory reporting for Federal Financial Supervisory Authority regulation. Automated solutions that elevated client side experience and significantly improved overall functionality and performance.
- Developed vehicle information data sourcing to Hadoop platform, transform the related data regarding on Daimler Sales which is relevant for Sales & Controlling reporting.
- Core member to initiate DevOps Tool Chain for Mercedes Benz Bank.
- Developed central event-based triggering for Hadoop applications.
- Developed highly maintainable application and followed best practices regarding to Bank coding guideline.
- Took scrum master role to facilitate scrum team by ensuring scrum framework is followed.
- Worked on various data interface such as SAP Bank Analyzer, SAP Hana, SAS integration, REST API with Hadoop platform.
Hadoop Developer
Standard Chartered Bank
08.2016 - 08.2019
- Developed Big data module in Spark (Scala) for Standard Chartered Bank Liquidity Department.
- Developed Basel III Intraday Liquidity program to ensure that Bank's intraday liquidity positions and risks to meet payment and settlement obligations on timely basis under both normal and stressed conditions.
- Standard Chartered is one of frontier among other banks to automated regulatory report submitting to Prudential Regulation Authority (PRA).
- Developed Balance Sheet Optimization (BSO). This project is developed to produce high quality in depth Management Information (MI), competitor analysis and predictive modelling which used to drive top management decision making and optimization of Balance Sheets.
- Developed Relationship Manager Risk Management Dashboard. This project is development of backend data sourcing, data processing and stitching for consumption of Financial Crime Key Risk Indicator dashboard.
Education
Bachelor of Science - Software Engineering
Universiti Malaysia Sarawak
Sarawak, Malaysia 09.2012 - 06.2016
Skills
Apache Spark
Hadoop (Kafka, HBase, Hive, HDFS)
Scala
Agile
Project Management
Dataworks
Flink
Data modeling
Advanced SQL
Python programming
Process Mining
Accomplishments
- Improved the precision of Risk Management calculation enable the Bank to save 4 million Euros equity.
- Redesign Risk Management module and improve the performance with parallel computation. Reduced calculation time by 25%.
- Implement automation pipeline handling to enable faster and more flexible module operation.
- Improved precision of Open Residual Value in Expected Loss calculation logic. Reduced the equity.
- Standard Chartered Growing With Us Program, Program Winner. Lead a team of 5 to work on POC of Prometheus Monitoring System in Bank. Provide working solution and customization to suits Banks scenario.
Certification
PSM I - Professional Scrum Master
Timeline
Senior Consultant - Data Engineering
Capco Consultancy
04.2024 - Current
Senior Data Engineer
Lazada South East Asia
04.2022 - 02.2024
PSM I - Professional Scrum Master
01-2021
Big Data Developer
Mercedes Benz Bank AG
09.2019 - 03.2022
Hadoop Advance Training
11-2017
Apache Spark Training
09-2017
Essential Python Training
09-2017
Hadoop Developer
Standard Chartered Bank
08.2016 - 08.2019
Bachelor of Science - Software Engineering
Universiti Malaysia Sarawak
09.2012 - 06.2016
Similar Profiles
Mr. Amit ChandorkarMr. Amit Chandorkar
Senior Consultant at Capco ConsultancySenior Consultant at Capco Consultancy
Jyoti LakshmiJyoti Lakshmi
Business Analyst at CapcoBusiness Analyst at Capco
Kumar PushkarKumar Pushkar
Product Owner at CAPCO TechnologiesProduct Owner at CAPCO Technologies
MoonLeng Phang BrudenallMoonLeng Phang Brudenall
Director of Clinical Services at Mahkota Medical CentreDirector of Clinical Services at Mahkota Medical Centre
NAYEEM HOSSAINNAYEEM HOSSAIN
Multiple Roles: Waiter, Barista, Cashier, Kitchen Helper, Assembler at NAMultiple Roles: Waiter, Barista, Cashier, Kitchen Helper, Assembler at NA