Yu Cheng Yew — delivery portfolio

Director of IT Operations

Twelve years across banking business intelligence, enterprise systems delivery in Singapore, regional logistics integration and high-volume e-commerce analytics — the data, integration and operations work that sits behind reporting and keeps systems running after launch.

← Back to Directors

EXPERIENCE SNAPSHOT

12 years

In software and data engineering

24 countries

Production deployment supported

1,000 jobs

Per full batch cycle at HSBC

4 sectors

Banking, government, logistics, e-commerce

SECTOR EXPOSURE

Banking & Financial Services

Sales and portfolio management systems, relationship-manager KPI analytics, and end-to-end BI, ETL and data warehouse testing.

Government & Education

SingPass and e-Services authorisation integration, SkillsFuture Credit grant functionality and agency reorganisation programmes in Singapore.

Logistics & Supply Chain

API and EDI data exchange between logistics platforms and warehouse vendors, with production deployment support across twenty-four countries.

E-Commerce

Reporting automation, internal business APIs, sales-event performance analysis and competitor data collection at regional marketplace scale.

CAREER PROGRESSION

  1. 2019 – Current Co-Founder & Chief Executive Officer Squarebox Tech (M) Sdn Bhd
  2. 2018 – 2019 Senior Associate, Business Intelligence Shopee Singapore
  3. 2017 – 2018 Analyst Developer Bollore Logistics Asia Pacific Pte. Ltd.
  4. 2015 – 2017 Software Engineer I-Access Solutions Pte. Ltd., Singapore
  5. 2013 – 2015 Software Engineer, Business Intelligence HSBC Development Malaysia Sdn. Bhd.

SELECTED DELIVERY REGISTER

Engagement Sector Scope Stack
01Sales & Portfolio Management system Banking KPI calculation and analysis for relationship managers, internal bank usage Control-M, SQL, data warehouse
02BI / ETL / DW test programme Banking End-to-end testing across UAT and SIT, full batch runs up to 1,000 jobs Control-M, Unix shell, SQL
03Education portal authorisation Government SingPass and e-Services Authorization System integration Enterprise web stack
04SkillsFuture Credit module Government Government education grant functionality for training management systems Enterprise web stack
05Workforce Development Agency reorganisation Government System reorganisation programme Enterprise web stack
06Legacy data migration Enterprise Migration and analysis from legacy system into new database MSSQL, SQL
07SFTP batch interface setup Finance ops Journal entry, online payment settlement and disbursement interface files SFTP, batch jobs
08Logistics API and EDI layer Logistics Data exchange between logistics system and warehouse vendors API, EDI
09Stored procedure optimisation Logistics Execution-time tuning to prevent database blocking MSSQL
10Multi-country deployment support Logistics New project deliverables released to production across 24 countries Release management
11Shipping cancellation report automation E-commerce Automated report generation and email distribution Python, task scheduler
12Internal business tools API E-commerce RESTful services for Price Spam Tracker and Item Recommender tools Python, Flask

SELECTED WORK IN DETAIL

01

Sales & Portfolio Management

Banking / Business Intelligence · Kuala Lumpur

Managed and maintained the system calculating and analysing KPIs for relationship managers across the bank, running full batch cycles of up to a thousand jobs through UAT and SIT with colleagues in China, Hong Kong, France and India.

EXPOSURE

  • Data warehouse and ETL delivery
  • Batch scheduling at scale
  • End-to-end BI testing
  • Distributed multi-region teams
  • Regulated release governance

02

Government education systems

Government / Education · Singapore

End-to-end support and enhancements for live client systems, including legacy data migration, SingPass and e-Services authorisation integration for an education portal, and SkillsFuture Credit grant functionality.

EXPOSURE

  • National identity integration
  • Grant and subsidy logic
  • Legacy data migration
  • Live system support
  • Agency reorganisation programmes

03

Logistics integration layer

Logistics / Supply Chain · Asia Pacific

Built the API and EDI layer exchanging data between the logistics platform and warehouse vendors, tuned stored procedures to stop database blocking, and supported deployment of new deliverables to production across twenty-four countries.

EXPOSURE

  • API and EDI development
  • Database performance tuning
  • Excel VBA reporting tools
  • Multi-country release support
  • Vendor coordination

04

Marketplace analytics

E-Commerce · Singapore

Automated shipping cancellation reporting in Python, built Flask APIs powering internal business tools, produced performance reporting and insight for major sales events, and built crawlers for competitor analysis.

EXPOSURE

  • Reporting automation
  • RESTful API delivery
  • Sales-event performance analysis
  • Web crawling and data collection
  • Business stakeholder reporting
← Back to Directors