✉️ Email: raylao925@hotmail.com
🌐 Languages: English • Cantonese • Mandarin
🚀 Summary
A detail-oriented data analyst with 7+ years of experience in statistical modeling, automation scripting, and cross-departmental collaboration. Adept at transforming raw data into actionable insights using SQL, Python, and Power BI. Proven track record in optimizing workflows and delivering high-impact reports under tight deadlines.
⚡ Core Skills
Technical |
Domain Expertise |
• SQL |
• Feature Engineering |
• Python |
• Modeling |
• Power BI Dashboards |
• Hospitality Analytics |
• Linux |
• Campaign ROI Analysis |
• Pipeline Development |
• Team Mentorship |
💼 Experience
Wynn Macau | Manager (Nov 2023 – Present)
- 🗃️ Integrated 10+ data sources into centralized database, reducing data discovery time by 60% for model development and Power BI dashboards.
- 🧠 Led team in building predictive models for campaign targeting and sales team prioritization, increasing conversion rate by 1.3x.
- 🤝 Collaborated with IT Project Team and EIM to develop applications for real-time customer insights collection, accelerating feedback loop by 3x.
- 🏆 Organized internal data modeling competitions, boosting team’s technical proficiency and collaboration.
Wynn Macau | From Junior Data Analyst to Assistant Manager (Aug 2016 – Nov 2023)
- 📊 Conducted campaign re-investment analysis, providing actionable insights for marketing campaigns.
- 🔗 Partnered with Finance Team to identify GGR KPIs across systems, enhancing financial visibility.
- 🛠️ Developed standardized SQL code templates reducing new members’ onboarding time by 50%.
- 📈 Created executive-level reports tracking operational metrics, adopted as the primary decision-making tool.
Wynn Palace | Buyer (Oct 2014 – Aug 2016)
- ⚡ Developed scripts automating PO tracking and price updates, saving the team 10+ hours/week.
- 💰 Negotiated supplier contracts achieving cost reduction, while maintaining quality standards.
Galaxy Entertainment Group | Internal Auditor (Oct 2012 – Sep 2014)
Casa Real Hotel | Income Auditor (Mar 2012 – Oct 2012)
🎓 Education
Sun Yat-sen University
- 🖥️ Bachelor of IT - Computer Science (Database) (2016–2019)
Relevant Coursework: Data Warehousing, SQL Optimization
- 📦 Bachelor of Logistics (2007–2011)
Thesis: Supply Chain Cost Optimization Models
📜 Certifications
-
HCIA AI |
Huawei Certified 2024 |
-
HCIA Datacom |
Huawei Certified 2024 |
-
Oracle 11g Administration |
Oracle Certified 2019 |
-
LCCI Accounting Level III |
Certified 2011 |
