Skip to content
QYChan Qing Yee
CV
← all projects

U Mobile 5G network upgrade

Project Engineer Intern · Huawei Technologies Malaysia

I coordinated daily deployment operations for Malaysia’s U Mobile 5G Network Upgrade (RAN and Microwave) — tracking 100+ subcontractor teams, resolving bottlenecks between Huawei, subcontractors, and the client, and managing the handover of 1,000+ acceptance deliverables. To keep that pace I built five automation tools in Python, PowerShell, and Selenium.

100+
Teams tracked
1,000+
Site deliverables
5
Tools shipped
15m → 1m
Reporting time

// note · The scripts here are sanitized: credentials, internal URLs, personal information, customer and subcontractor names, and operational datasets have been removed.

// the tools

01

Work Permit Site Extractor

Shared with teammates

Turns weekly work-permit spreadsheets into one clean, regionally grouped site list.

  • Parses comma-, slash-, and whitespace-separated site identifiers.
  • Combines and deduplicates records across multiple workbooks.
  • Enriches site IDs using a separate mapping workbook.
Pythonopenpyxldata validationdeduplication
view sanitized source ↗
02

Site Key Status Checker

Shared with teammates

Answers who holds a site’s access key and where to collect it, from two separate datasets.

  • Accepts one or many site IDs and correlates across separate datasets.
  • Enriches key-holder records with collection-location data.
  • Restricts collector details to relevant status conditions.
Pythonpandasdata correlationinput validation
view sanitized source ↗
03

Multi-Site Clock-In/Out Automation

Shared with teammates

Clocks batches of sites in and out through the browser, then reports what succeeded and what did not.

  • Selenium explicit waits for reliable browser interaction.
  • Validates site IDs before acting; continues when individual sites fail.
  • Keeps credentials and endpoint URLs outside the source code.
PythonSeleniumsecure configurationfault tolerance
view sanitized source ↗
04

Daily Clock Report Automation

Personal productivity tool

Turns a raw daily clock report into structured Excel, with PivotTables and duplicates flagged.

  • Controls Microsoft Excel through COM automation.
  • Generates detailed and summary PivotTables.
  • Highlights duplicate and unmatched records for review.
PowerShellExcel COMdata cleansinganomaly detection
view sanitized source ↗
05

Batch Email Request Automation

Personal productivity tool

Submits batches of identifiers through an authenticated internal form, screenshotting anything that fails.

  • Keeps authentication under user control (manual login).
  • Isolates failures so one record does not stop the batch.
  • Saves screenshots to support troubleshooting.
PythonSeleniumauth-aware designexception handling
view sanitized source ↗

// engineering practices carried forward

Five tools, five practices, and which proves which. The sparse columns are the honest part — diagnostic evidence rests on one tool, so it is one tool’s worth of proof.

Work Permit Site Extractor

  • correlate
  • anomaly

Site Key Status Checker

  • correlate

Multi-Site Clock-In/Out Automation

  • creds
  • correlate
  • fault-tol

Daily Clock Report Automation

  • correlate
  • anomaly

Batch Email Request Automation

  • creds
  • fault-tol
  • evidence
creds
Credentials and internal endpoints read from the environment or left under user control — never stored in source.
correlate
Records matched and checked across more than one operational data source before being acted on.
anomaly
Missing, duplicate, or unmatched records surfaced rather than silently passed through.
fault-tol
One bad record does not stop the run; the batch continues and reports what failed.
evidence
Enough captured at the point of failure to work out afterwards what went wrong.