Skip to main content

Evelyn Ng

Retail Associate

Talent
SingaporeMember since July 14, 2026
ExcelCOUNTIFSConditional formattingPower BISQLSharePointLIMSSQL ServerCASE statementsStar schema design
·

Hire this person

Send a job offer directly to this candidate

ExcelCOUNTIFSConditional formattingPower BISQL

About

Conducted end-to-end dogfooding of the Q2 markdown preparation workflow, identifying friction points in a 595-row SharePoint workbook (150+ out-of-stock items, no progress visibility) and performing root-cause analysis on operational bottlenecks. Built a multi-tab monitoring dashboard in Excel/SharePoint with real-time KPIs (% sectioned, pulled, stickered across 445 active items) using COUNTIFS, nested IF/AND/OR formulas, and formula-driven conditional formatting, surfacing actionable insights on team progress and reducing assessment time from 5 minutes of manual counting to a single glance. Collaborated cross-functionally with the Store Manager and BOH team to deploy the redesigned tracker live via SharePoint, briefing the team on new functionality and achieving adoption across 36 team members over the Q2 markdown cycle.

Experience

Retail Associate - Lululemon

(2024-01)

  • Conducted end-to-end dogfooding of the Q2 markdown preparation workflow, identifying friction points in a 595-row SharePoint workbook (150+ out-of-stock items, no progress visibility) and performing root-cause analysis on operational bottlenecks.
  • Built a multi-tab monitoring dashboard in Excel/SharePoint with real-time KPIs (% sectioned, pulled, stickered across 445 active items) using COUNTIFS, nested IF/AND/OR formulas, and formula-driven conditional formatting, surfacing actionable insights on team progress and reducing assessment time from 5 minutes of manual counting to a single glance.
  • Collaborated cross-functionally with the Store Manager and BOH team to deploy the redesigned tracker live via SharePoint, briefing the team on new functionality and achieving adoption across 36 team members over the Q2 markdown cycle.

Laboratory Assistant - Eurofins

(2024-05 - 2024-07)

  • Managed and validated large analytical datasets in LIMS (Laboratory Information Management System), conducting data audits to identify anomalies and trigger root-cause investigations on out-of-spec results, supporting data integrity and compliance in a QA-critical lab environment.
  • Partnered with lab analysts and senior QA staff to redesign data entry handoffs, reducing manual transcription errors and tightening sample-to-report traceability.

Education

Bachelor of Science, Honours - Chemistry and Biological Chemistry with a Second Major in Data Analytics - Nanyang Technological University, Singapore (2025-08 - 2028-08)

Skills

Retail Associate

Reviews

Related