Develop and maintain Asset Information for Civil Structures data over Greater Toronto and Hamilton AreaCommunicate with Vendors and Project Delivery Team for Asset Handover

▪ Developed reporting system -> identify trends and provide statistical information to analysis departmental KPIs-> create 5+ interactive dashboards to different departments ▪ Data Cleaning-> Enhanced accuracy and effectivity of data cleaning by 70% using Pivot Table, Power Query and VBA-> Automated data extraction process by creating macros and custom functions in Excel which is reduced processing time from 1 hour to 5 minutes ▪ Data Visualization -… Show more ▪ Developed reporting system -> identify trends and provide statistical information to analysis departmental KPIs-> create 5+ interactive dashboards to different departments ▪ Data Cleaning-> Enhanced accuracy and effectivity of data cleaning by 70% using Pivot Table, Power Query and VBA-> Automated data extraction process by creating macros and custom functions in Excel which is reduced processing time from 1 hour to 5 minutes ▪ Data Visualization - Created 5+ reports to summarize and visualize the result including charts and trends and PowerPoint decks to department heads▪ Back up support -> Successfully fixed exist bugs in generating report from MS access-> Solved 10+ cases of VBA coding issues for non-technical end users Show less

• SCADA System Management – Developed SCADA system for Klang Valley Mass Rapit Transit (Database & Human Machine Interface) for software development cycle (SDLC). Evaluated the performance of SCADA systems by writing and executing 100+ unit tests & integration tests. •ETL process management – -> Transformed data into defined structure and format. Loaded the data into MySQL database, followed by data validation in user interface and input/output testing as well as… Show more • SCADA System Management – Developed SCADA system for Klang Valley Mass Rapit Transit (Database & Human Machine Interface) for software development cycle (SDLC). Evaluated the performance of SCADA systems by writing and executing 100+ unit tests & integration tests. •ETL process management – -> Transformed data into defined structure and format. Loaded the data into MySQL database, followed by data validation in user interface and input/output testing as well as troubleshooting. -> Identified data source error – using Python, SQL and Excel Formula to minimize the human errors and data structure issue.• Task Automation – Created various automation tools using Automated Python tools and Bash Shell script for data manipulation, Human Machine Interface as well as installation of database and FEP testing that increased the accuracy and quality of packages and reduced manual hours by up to 70%.• Predictive Maintenance – Worked closely with the software product team and the system engineers for various testing, maintenance, debugging and troubleshooting of errors found in simulator to ensure and enhance quality output.• Web Applications – Configurated Human Machine Interface (i.e a web application) using Angular.js. Show less

▪ Research an Academic Project - investigated the transformative learning and hedonic of Hong Kong teenagers after working holidays.▪ Data Collection - Invited 50+ Hong Kong Youth for interviews and successfully conducted 20+interviews with the candidates to understand their fruitful experiences among the journey. Transformed the audio sources to text sources by doing transcription.▪ Data Analysis & Reporting - -> Analyzed 240+ pages of data on learning and hedonic of… Show more ▪ Research an Academic Project - investigated the transformative learning and hedonic of Hong Kong teenagers after working holidays.▪ Data Collection - Invited 50+ Hong Kong Youth for interviews and successfully conducted 20+interviews with the candidates to understand their fruitful experiences among the journey. Transformed the audio sources to text sources by doing transcription.▪ Data Analysis & Reporting - -> Analyzed 240+ pages of data on learning and hedonic of the interviewees in 40 hours effectively such as filtering irrelevant data and classification of similar experience in personal development -> Inspired the professors in data modelling research -> Initiated 5+ reports to summarize and visualize the results including spreadsheets and charts▪ Acted as a bridge of communication - facilitate the liaison between candidates and project leads Show less

• Distribution Management System (DMS) – Contributed in the migration of the power system and the Distribution Management System. • Evaluated System Design – Verified vendors’ SCADA system technical design documents and provided business requirement to the supplier• Technical Analysis – Prepared system cutover plans. Implemented Bash Shell and PowerShell scripts for automation such as generating diagrams and weekly reports for abnormal hardware status which enhances productivity… Show more • Distribution Management System (DMS) – Contributed in the migration of the power system and the Distribution Management System. • Evaluated System Design – Verified vendors’ SCADA system technical design documents and provided business requirement to the supplier• Technical Analysis – Prepared system cutover plans. Implemented Bash Shell and PowerShell scripts for automation such as generating diagrams and weekly reports for abnormal hardware status which enhances productivity by 20%. Prepared diverse documentation such as acceptance test procedures and user manuals.• Evaluated System Performance - Produced & Verified 100+ user acceptance test procedures documentation and user manuals• Organized 10+ Workshops for Introducing Upgraded DMS System to technical and non-technical audiences such as clerks to explain new techniques• Software and Asset Maintenance – -> Maintained asset and software databases. Updated and maintained software license database. -> Maintained stability of DMS (VMware ESXi & Oracle server) by regular backups and updated security patches (WSUS).-> Managed and chased IT assets using OSISoft PI IT Monitor. Resolved computer software incidents. Show less