Ray Wang Lei
Data Engineer | Data Analyst | Data Automation
| Singapore Citizen | English & Mandarin |
| Portfolio |
Professional Summary
Data Engineer / Data Automation Engineer with experience in Python, SQL, Databricks, ETL automation, Power BI/Tableau reporting, dashboard development, and business process digitalization. Strong background in engineering operations, manufacturing analytics, quality analytics, and product telemetry data workflows. Experienced in building automated data pipelines, dashboard-ready datasets, KPI reports, and data tools that improve traceability, reduce manual effort, and support business decision-making.
Skills
- Programming & Analytics: Python, SQL, R
- Data Engineering & Automation: ETL, data cleaning, data transformation, API integration, workflow automation
- BI & Visualization: Power BI, Tableau, Excel, data modelling, KPI reporting, dashboard development
- Data Platforms & Tools: Databricks, GitHub, Bitbucket, Azure DevOps, Jira, SharePoint
- Databases: MySQL, relational data modelling
- Domain Experience: Product telemetry analytics, quality analytics, manufacturing analytics, process automation, engineering operations
Education
-
Master of Data Analytics and Visualisation
Singapore University of Social Sciences (SUSS) | May 2026 -
Bachelor of Engineering in Electronics, Honours
Singapore University of Social Sciences (SUSS) | Dec 2022 -
Diploma in Communications and Automation Electronics
Republic Polytechnic | Apr 2009
Work Experience
Data Analytices Engineer | HP Inc. (Contract)
Sep 2025 - Present
- Developed SQL and PySpark logic in Databricks to analyze product telemetry, PSA driver adoption, firmware rollout, support case trends, and device-level behavior.
- Built Power BI-ready fact tables, time-series datasets, and dashboards for adoption rate, migration eligibility, migration success, device counts, and regional/product-level performance tracking.
- Developed and supported Databricks dashboards to monitor telemetry trends, PSA adoption, product quality indicators, and device-level behavior.
- Automated data extraction, transformation, validation, and aggregation workflows using Python, SQL, and Databricks notebooks.
- Developed Python web scraping automation to collect, process, and consolidate app star ratings and customer reviews for product quality and customer experience tracking.
- Supported product owners and engineering teams in investigating root causes for product quality and device behavior issues, including cartridge connection-related issues, through telemetry, support case, firmware, product, and regional analysis.
- Standardized KPI definitions, data quality filters, OS segmentation, region mapping, and product/platform classifications to ensure consistent dashboard reporting.
Data Engineer | Esri Singapore (Contract)
Mar 2024 - Jul 2025
- Supported PUB geospatial data automation workflows using ArcGIS Pro, ArcPy, Python, SQL, and APIs.
- Automated spatial data import/export, feature class updates, annotation updates, and file packaging workflows.
- Worked with GIS specialists, developers, and project managers to support customer-specific data workflow requirements.
Data Automation Engineer | Infineon Technologies
Dec 2021 - Mar 2024
- Designed and implemented a Sample Management System using MySQL, Python, PHP, and Bitbucket to replace manual tracking workflows.
- Built ETL processes to improve sample traceability, reduce manual effort, and save approximately 2 hours per day.
- Created Tableau and R-based reports to support product and operational decision-making.
- Automated NPI workflow tracking using SharePoint, improving visibility and process control.
- Developed a VB.NET data housekeeping tool, reducing manual work by 1 to 2 hours per day.
- Used Jira, Kanban, and Bitbucket to manage project delivery, documentation, and version control.
Process Engineer | KX Technologies
Dec 2018 - Dec 2021
- Applied R, Tableau, and statistical analysis to improve process yield, quality, and production readiness.
- Led engineering improvement projects for new product launches and production line setup.
- Improved Electrolux air-filter line yield from 50% to above 95% within three months.
- Received Commercial Excellence and Operational Excellence & Innovation Achievement Awards.
Automation Engineer | Meridionale Impianti Singapore
Apr 2013 - Dec 2018
- Supported installation, testing, commissioning, and validation of gas, chemical distribution, and life safety systems for semiconductor customers including STMicroelectronics, Micron, and REC Solar.
- Performed PLC/system-level testing, hardware validation, equipment setup, troubleshooting, and technical drawing interpretation.
Project Engineer | InfoCom & Security System
Apr 2009 - Mar 2013
- Managed BMS installation, testing, commissioning, troubleshooting, project handover, site coordination, and technical support for commercial and institutional facilities.
Contact
- Email: wanglei6518@yahoo.com
- LinkedIn: linkedin.com/in/ray-wang-666
- Portfolio: airfire6518.github.io/portfolio