Sydney, NSW · Australia
Yanlyu Xu
Business & Technical Analyst
I turn ambiguous business and technical requirements into clear specifications, data models, and shipped software — bridging stakeholders, analysts, and engineers across compliance-critical platforms.
About
Business & Technical Analyst with proven ability to translate business and technical requirements into system specifications that drive solution design and delivery. Experienced across the full delivery lifecycle — requirements elicitation, data-flow and integration mapping, system-impact assessment, solution design, and functional, non-functional, and security testing. I've helped architect and deliver a production, multi-system web platform end-to-end — from public marketing and lead capture through dashboards, CRM, and finance/admin back office — across operational and compliance-critical environments.
Skills
Business & Technical Analysis
- Requirements elicitation
- System specifications & BRDs
- Data-flow & integration mapping
- System-impact analysis
- UAT & test-case design
AI & Automation
- LLM-based AI agents
- Prompt engineering
- AI-assisted development
- Claude · Cursor · Codex · Copilot
- Workflow automation
Data Analysis & BI
- SQL
- Python
- R
- Power BI
- Tableau
- Excel
Full-Stack / Web
- Next.js
- NestJS
- PostgreSQL
- REST API integration
- AWS
Security & Compliance
- ISO 27001
- GDPR
- NIST
- KYC / AML
Delivery
- Jira
- Agile
- Waterfall
- Stakeholder workshops
Experience
ICT Business Analyst · Decode Global
Apr 2025 — Present- Elicited and documented business and technical requirements from sales, operations, and compliance stakeholders, translating them into system specifications, data models, and acceptance criteria.
- Helped build the full web lifecycle end-to-end — public marketing and lead capture, internal dashboards, CRM, KYC/compliance workflows, and finance/admin back office — as a single integrated platform.
- Mapped data flows and integration points across CRM, trading, accounting, and client-portal systems, defining reconciliation and standardisation logic for operational and compliance reporting.
- Specified and helped implement compliance workflows — KYC/AML screening, e-signature agreements with audit trails, and role-based access control — and supported functional, non-functional, and security testing.
- Helped deliver the platform to production across dev, staging, and production for two operating entities under a controlled, source-of-truth deployment process.
Business Analyst · Vantage
Jan 2023 — Apr 2025- Performed statistical data analysis on CRM, trading, and marketing datasets using Python, R, and SQL — regression, ANOVA, and hypothesis testing to uncover behavioural and operational trends.
- Built time-series and regression forecasting models for client acquisition, deposit patterns, and campaign performance to inform planning and optimisation.
- Designed controlled experiments / A-B tests with sampling, randomisation, and significance testing for continuous improvement.
- Partnered with Compliance on AML/CTF risk analytics, using probability-based thresholds to flag transactional anomalies.
- Built Power BI dashboards to visualise statistical outcomes and KPIs for executive reporting.
Internship Trainee · Vantage
Aug 2022 — Jan 2023- Gathered and formalised business requirements with the CRM team; surfaced product and market-trend insights using dplyr and R.
- Produced weekly and monthly customer-conversion breakdowns using Python and Power BI for sales and marketing.
- Helped improve retention by 6% within 3 months via Python sentiment analysis (NLTK).
Selected Projects
Fund CRM Platform & Exchange (CEX) Integration
Helped design and build a multi-tenant fund-management platform end-to-end — marketing/lead-capture frontend, internal CRM, investor portal, and finance/admin back office. Integrated a centralised exchange via API to sync account, balance, and trade data into operational dashboards and compliance reporting.
hugcrm — CRM + Client Portal
A CRM built from scratch with a separate client portal and KYC onboarding. Staff back office with a lead pipeline, KYC review queue, multi-currency funds & investments driven by an immutable transaction ledger, NAV performance charts, referral commissions auto-accrued on investment, a sales dashboard, and an audit trail — all under role-based access (Admin > Manager > Agent).
Paw Studio — E-commerce
A custom pet-merchandise storefront: brand landing, category-filtered shop with original SVG 'patch' artwork, a localStorage cart, and a checkout that runs in invoice mode out of the box and switches to Stripe card payments the moment keys are added. Fully self-hosted artwork with i18n.
Job Application AI Agent
An LLM-powered agent that parses job descriptions, tailors resumes and cover letters to each role, and tracks applications end-to-end — reducing manual effort and improving keyword/ATS alignment.
Trading Analysis Report AI Agent
An LLM-powered agent that ingests market and trading data and automatically generates structured trading-analysis and risk reports — turning raw data into decision-ready insights for review.
Let's build something clear.
Open to Business / Technical Analyst roles and AI-assisted delivery work. The fastest way to reach me is email.