LESTER YAM'S PORTFOLIO

Lester Yam

Result-driven and Independent Software & Data Engineer

About Me

Hello! I’m Lester Yam. I am a software engineer wwith more than 8 years experience in web development, databases management, data visualisation, administrative and user training. I have a strong passion for data analytics and visualisation which spurred me on to pursue a specialist diploma in Business and Big Data Analytics at NYP. I'm skilled at working independently, creating effective presentations and developing new opportunities and innovations to meet organisational goals.

Email
Phone
+65 9731-9951
Linkedin Profile
https://www.linkedin.com/in/lester-yam

Portfolio

(Click on image to view in detail)

Work Experience

Senior Software Engineer (Permanent)at Penta-Ocean Construction Co. Ltd
2019 - Present

● Developed and implemented "Dredging Operation Online System". The online system has improved data collection and reporting process by 90%.

● Developed and implemented "Manpower management Online System". The online system has improved accruacy and availability of staff information by 80%.

● Perform daily data extraction using SQL script and prepare reports for project client which include Marine and Port Authority of Singapore and Surbana Jurong.

● Prepare dashboard and reporting for construction managers using Microsoft Power BI

● Create SQL Stored Procedures to perform complex queries and complex data manipulations.

System Analyst (External Contract)at United Oveseas Bank
2018 - 2019

● Developed automation tools for Group Wholesale Banking and UOB Thailand to generate monthly report. The systems have reduced processing time from 1 week to 3 hours.

● Performed data extraction and cleaning of 40 million rows of bank data for annual MAS reporting.

Data Manager (Permanent)at Tan Tock Seng Hospital
2016 - 2018

● Design, build and manage databases (Access, SQL Server & REDCAP) for various clinical research projects.

● Perform all necessary data transformations to populate data into a database

● Design training matertial and content for database courses

● Delivered Data Management and MS Excel and Access database training courses to hospital staffs.

Research Assistant (Contract)at Tan Tock Seng Hospital
2014 - 2016

● Responsible for patient recruitment, data collection and analysis, and preparation of monthly reports to research team and stakeholders.

● Tracked project financial spending to ensure it operates within the approved research budget.

● Designed, built and deployed web-based electronic form to facilitate collection and reporting of research data


Education

Bachelor of Science in Business Information Systems and Cyber Forensics, Information Security & Management - Murdoch University
2013 - 2015
● Tasked to build a “Kanban” web system prototype for final year project. The project received distinction.
Specialist Diploma in Business & Big Data Analytics - Nanyang Polytechnic
2015 - 2016
● Created a web crawling tool to extract text data from a web forum called “Kiasu parents” for data analysis and discovery of new insights.
Diploma in Business Application - Republic Polytechnic
2006- 2009
● Developed a school video sharing web portal for final year project. The project received distinction.
● Developed a customer management system for 2nd final year project. The project was selected as one of the IT projects to showcase during 2006 Open House.

Professional Skills

PHP
CSS
JavaScript
VBA
SQL
Microsoft Access
Microsoft Excel
Data Analytics & Visualisation
User Training
Requirement Gathering

Contact

Linkedin

https://www.linkedin.com/in/lester-yam

Phone

+65 9731-9951

Email