- Translated fragmented rostering pain points into requirements and user stories for draft/published schedules, shift visibility, leave requests and shift swaps.
- Connected business rules to a relational, database-backed web application and documented the solution as a business-focused case study.
GUANG QUAN TAN (WILLIAM)
Professional Summary
Final-year Monash University Bachelor of Information Technology student (Business Information Systems), graduating December 2026. Graduate analyst candidate who bridges business requirements and technology delivery through workflow analysis, acceptance criteria, systems thinking, SQL/data modelling and hands-on implementation. Commercial experience at CS TAN includes Excel-based sales/inventory analysis, pricing and purchasing decision support, B2B customer/supplier workflows, operational reporting, IT support and process/document improvement.
Core Skills
Business & Systems Analysis: Requirements Gathering, Process Mapping, Workflow Analysis, User Stories, Acceptance Criteria, Stakeholder Communication, Business Documentation, UAT, Systems Thinking
Data & Databases: SQL, Oracle SQL, PostgreSQL, Supabase, ERD, Normalisation, Schema Design, Data Integrity, Excel
Product & Delivery: HTML/CSS, JavaScript, Next.js, Node.js, Git/GitHub, Figma, Miro, Trello, Agile/Scrum
Selected Projects
- Converted client requirements into onboarding flows and acceptance criteria, then contributed implementation fixes for guided steps, inputs and dropdown interactions.
- Performed strict end-to-end validation to identify gaps between intended requirements and delivered user behaviour.
- Worked across structured AI output, product UX, authentication/data flows, admin/user routing and acceptance testing in a full-stack product.
- Used Playwright role-routing tests and Supabase migrations to validate access boundaries and evolving system behaviour.
Professional Experience
- Research products, suppliers, customer segments and commercial opportunities; support B2B customer communication, quotations, invoices, order coordination, product sourcing and supplier communication, including a 22-passenger corporate booking / itinerary workflow.
- Standardised business documents, templates and digital materials to improve recurring customer-facing workflows and documentation consistency.
- Used Excel to analyse sales, inventory, customer demand, supplier costs, product performance, stock movement, margins and stock levels to support pricing, purchasing and stock decisions.
- Prepared operational reports and improved order handling, invoicing, stock tracking, customer records and inventory documentation.
- Provided first-level support for devices, printers, internet connectivity, email accounts and business software; troubleshot staff issues and improved basic digital workflows.
- Maintained product listings, invoice templates, customer records and stock spreadsheets used in daily operations.
- Manage and optimise 100+ product listings, pricing updates and content consistency; support customer communication, promotions and store operations.
Education
Relevant focus: Business analysis, systems development, databases, data analysis, software/web development and digital solution delivery.
This page is intentionally single-column and text-first for ATS parsing and recruiter scanning. Use Print / Save PDF for a clean application copy.