Edward T

Lead Data Analyst @ Marina Bay Sands Singapore

Las Vegas Sands • Full time

Jun 2024 - Mar 2026 • 1 yr 9 mos

Leading analytics initiatives to improve IT performance and operational efficiency across multiple teams. + Designed an IT Scorecard dashboard for 5 IT teams to track their monthly performance, assisted to reduce IT operation incidents by 25%. + Benchmarked IT productivity against industry standards, identifying performance gaps and driving improvements across 5 teams. + Presented to management team on IT performance quarterly, and highlighted at least 1 key problems for the respective IT teams to follow up. + Automated ETL workflows using Python, reducing processing time by 95% (24 hours to 1 hour) and enabling near real-time decision-making.

Business Data Analyst @ DBS Bank Singapore

Banks • Full time

Jul 2022 - Jun 2024 • 1 yr 11 mos

I am part of the data analytics team involved in staff productivity, investment product and Application usage. + Led cross-functional analytics in DBS Consumer Group (CBG). + Created 4 dashboards in Excel and Qliksense to monitor business flow for CBG business partner to make near real-time decision making. + Revamped 5 legacy dashboards and SAS scripts to meet the current demands of CBG business partners. + Migrated and optimized 7 legacy SAS scripts to Python ecosystem, increasing efficiency by 90% (24 hours to 30 minutes). + Built scalable ETL pipelines using Python and PySpark on AWS CDSW to process large datasets for downstream analytics. + Managed a small team for a project to meet its objective. + Mentored new joiners and interns.

Digital Business Analyst @ GovTech Singapore

Consulting • Full time

Aug 2020 - Jul 2022 • 1 yr 11 mos

I am deployed as DBA in MOE ITD Data Analytical Unit to manage data warehouse projects. Student Hub + Worked closely with vendor to provide support and enhancement for various stakeholders within MOE and with other agencies + Reviewed Design Specifications before development starts + Participated in DR exercises and coordinate with various stakeholders to ensure smooth testing in PROD + Involved in procurement approach to offer new maintenance contract, from tender preparation to awarding of contract + Involved as part of the team in migrating existing data warehouse to GCC + Onboarded vendor to GCC and SHIP-HATS + Utilized waterfall approach in implementation + Involved in technical architecture design discussion MOE Data Hub + Involved in the initial concept design phase for management approval + Worked closely with Project Manager in the budget process, from getting budget quotation to securing of project funds + Utilized scrum approach in implementation + Involved in technical architecture design discussion + Identify and proposed mitigations for various business and technical project risk with the team + Participated in scrum workshops to gather and prioritize user stories, finalize on the detailed scrum approach such as Definition of Done + Researched on certain COTS products like SAS and Tableau + Led procurement approach to offer new contract, from tender preparation to awarding of contract + Reviewed multiple tender proposals (business functions and technical design) + Prepared deck for management update Tableau Dashboard + Migrated and enhanced dashboard in Tableau + Worked with stakeholder to clean up data