Ray Wang Lei

Logo

Return to My Main Page

View the Project on GitHub airfire6518/portfolio

Data Analyst | Data Engineer | Data Scientist | Automation & Machine Learning

Technical Skills: Python, SQL, R, Tableau, Git, etc.

Education

Data Analysis and Automation Project

R:
Economic Growth & Population Dynamics: A Visual Story of Southeast Asia
Integrating Python with R for Data Scraping and Analysis: A Study on GDP and Innovation

Python/R:
The Singapore HDB Resale Market: 1990-2024

SQL/R:
Visual Analysis of University Graduate Survey Data

Python/SQL/R:
Insights from Zoom Transcripts: Analyzing Student Engagement in the Digital Classroom

Python/SQL/Web API/SAP BO/Web GUI/Laravel/PHP:
“Sample Management System” - Infineon Technologies

Work Experience

Data Engineer | Esri Singapore Pte. Ltd. (Mar 2024 - Present)

Key Customer and Projects:

  • Multiple batch jobs for PUB project: Developed and maintained automated pipelines for data import and export, integrating geospatial data generation, feature class and annotation updates, ZIP packaging, and seamless file export and upload to the Submit Retrieve web server.

Data Analytics Engineer [Specializing in Data & Digitalization Automation Role] | Infineon Technologies A/P Pte. Ltd. (Apr 2022 - Mar 2024)

Key Project and Achievements:

  • Sample Management System: Conceptualized and implemented the solution using MySQL/Python/PHP/Bitbucket tools, designed and implemented a practical ETL (Extract, Transform, Load) data process. This process aimed to digitize and automate the previously manual tracking system, resulting in improved traceability and efficiency for ES LOT, ultimately saving 2 hours daily.
  • Data Visualization: Created product reports using Tableau/R to facilitate better decision-making for internal stakeholders.
  • NPI(New Project Introduction) Digitalization: Implemented an automation process and improved workflow using the Sharepoint system.
  • Data Housekeeping: Developed a Visual Basic .NET tool to automate data housekeeping tasks, freeing up 1~2 hours daily.

Process Engineer | KX Technologies Singapore Pte. Ltd. (Feb 2019 - Mar 2022)

Key Project and Achievements:

  • Commercial Excellence Achievement Award (Dec 2020)
  • Operational Excellence & Innovation Achievement Award (Dec 2021)
  • Led and coordinated the setup of the Electrolux (EMA) air-filter production line, which included a box assembly machine and a flow wrapping machine, overseeing machine testing and validation
  • Intelligent RFID (IoT) implemented filter in Strauss Water filter products.
  • HM Global (Korea) water filter (FACT Media) products.
  • Investigate and improve the EMA(Electrolux) Gremlin air-filter line yield from 50% monthly to >95% monthly in three months.
  • Involves projects for HM Global, Kunshan EcoWater, Strauss Water & Thermos products, etc.

Automation Engineer | Meridionale Impianti (Singapore) Pte. Ltd. (Apri 2013 - Sep 2018)

Key Customers:

  • STMicroelectronics/Micron Fab10/Micron Fab 13/REC Solar.

Key Projects:

  • STMicroelectronics EPI Gas Distribution System Project (2017~2018)
  • STMicroelectronics EPI Special Gas Distribution System Installation (2014~2018)
  • STMicroelectronics EKC705 Chemical Distribution System Project (2016)
  • REC Solar Special Gas (HCl/WF6) Distribution System Project (2016)
  • Micron FAB10N Special (Cl2) Gas Distribution System Project (2016)
  • Micron FAB13 DSI LSS Installation Project (2014~2015)
  • STMicroelectronics All Gas System SCADA Heartbeat Signal Updating Project (2015)

Project Engineer | InfoCom & Security System Pte. Ltd. (April 2009 - Mar 2013)