U Mobile 5G network upgrade

Processes weekly work-permit spreadsheets: extracts network-site IDs from multiple columns, normalizes inconsistent delimiters, deduplicates, groups sites by region, maps IDs to names, and outputs formatted Excel reports.

• ·Parses comma-, slash-, and whitespace-separated site identifiers.
• ·Combines and deduplicates records across multiple workbooks.
• ·Enriches site IDs using a separate mapping workbook.

Correlates two Excel data sources to show a network site’s key status, key holder, collection location, responsible handler, and collector details when required.

• ·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.

Automates repetitive browser workflows for batches of network sites: logs in with environment-based credentials, validates sites against a work permit, performs clock-in/out, and produces a success/failure summary.

• ·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.

A PowerShell workflow that transforms a raw daily clock report into structured Excel reports — filtering categories, validating distances, building PivotTables, and flagging duplicate records.

• ·Controls Microsoft Excel through COM automation.
• ·Generates detailed and summary PivotTables.
• ·Highlights duplicate and unmatched records for review.

A Selenium workflow that submits batches of network-related identifiers through an authenticated internal request form, recording failures with diagnostic screenshots.

• ·Keeps authentication under user control (manual login).
• ·Isolates failures so one record does not stop the batch.
• ·Saves screenshots to support troubleshooting.