Portrait of William Guardado
Statistician Quantitative Analyst Data & SQL PHP / Web Systems Linux VPS Adobe Creative University Educator Community Founder

William Jesus Guardado

I work across statistics, quantitative analysis, databases, web systems, teaching, and digital production. I also build and operate Melbourne communities including Linguas, Thought Experiment, Respawn, and Sugar & Spice Nights — combining analytical thinking with practical delivery.

10+
Years in analytics
186
Events in 2025
39K+
2025 attendees
35K+
Community audience
Current focus: secure web tools, database-backed event systems, community growth, digital campaigns, and practical uses of AI in teaching and operations.

Ventures

I design and operate communities and platforms that help people connect, learn, and have fun.

Skills

A multidisciplinary toolkit developed through banking, university teaching, self-managed web infrastructure, media production, and live community operations.

Statistics, Analytics & Risk
Statistical ModellingQuantitative Analysis Credit RiskPD / EAD / LGD Fraud DetectionForecasting Model EvaluationOperations Research

Experience across banking risk, detection management, business analytics, statistical modelling, optimisation, and communicating results to technical and non-technical audiences.

Data, Databases & Programming
SQLPythonR MySQL / MariaDBPostgreSQL Oracle / PL/SQLCassandra Concepts Data PipelinesReporting

Relational data design, querying, stored-procedure concepts, database-backed applications, analysis workflows, data validation, and operational reporting.

Web Development & Internal Tools
PHPHTML / CSSJavaScript BootstrapPDOREST APIs Eventbrite IntegrationsAdmin Portals Search / Full TextResponsive Design

Practical websites and operations tools including event dashboards, promo-code reporting, mailing-list systems, protected admin pages, content portals, and database-driven utilities.

VPS, Hosting & Web Security
LinuxDigitalOcean VPSNginx DNSSSL / TLSSSH CronCloudflareTurnstile Access ControlLogs & Troubleshooting

Managing domains and self-hosted sites from deployment to maintenance, including reverse proxy configuration, certificates, scheduled jobs, bot protection, authentication, and incident troubleshooting.

Creative Production & Digital Campaigns
PhotoshopAfter Effects Premiere ProLightroom Motion GraphicsAudio Editing Posters & Event CoversReels & Promo Video Meta AdsBrand Systems

End-to-end campaign production for social events: visual identity, posters, photography, video editing, animation, captions, promotional copy, paid social, and platform-specific assets.

Teaching, Facilitation & Communication
University TeachingBusiness Analytics AI & Machine LearningQuantitative Methods Workshop FacilitationScenario Design Public SpeakingTechnical Explanation

Teaching undergraduate and postgraduate students, translating technical ideas into clear language, facilitating group discussion, and designing structured learning and debate experiences.

Community, Events & Business Operations
Event ProductionVenue Partnerships Community GrowthEventbrite / Meetup Email CampaignsTicketing & EFTPOS BudgetingContractor Coordination Run SheetsMulti-brand Operations

Building recurring events from concept to delivery: venue negotiation, programming, promotion, registration, customer communication, on-site operations, partnerships, financial tracking, and post-event improvement.

Featured Projects

Representative builds — code, write-ups, and live demos where possible.

Leadership

Student leadership, club operations, and digital systems ownership.

Positions & Roles
President, EFMSA (2024) Vice President, EFMSA (2025) President, BSA (2021) Vice President, BSA (2020) Vice President, MIBSA (2022) Digital Solutions Architect, BSA (2026) Research & IT Lead, RMIT Strategy & Consultancy Society (2026)

I enjoy building the “operating system” behind communities — processes, tools, automation, and reporting — so teams can move quickly without chaos.

What I build for teams
  • Automated comms: email workflows, reminders, task notifications, approvals.
  • Self-hosted tools: portals, internal knowledge hubs, search, dashboards.
  • Reliable ops: roles, checklists, templates, and “runbooks” for events and committees.
  • Data clarity: simple reporting that decision-makers actually use.

Experience

Teaching & Research Sessional — RMIT University
2024–Present • Economics, finance, marketing, quantitative analysis, and related teaching support
Lecturer — Kaplan Business School
2023–Present • Quantitative analysis, business analytics, AI, and machine learning
Analyst, Detection Management — NAB
2022–2023 • Fraud prevention & detection
Founder & Event Organizer — Linguas
2021–Present • Community strategy, partnerships, marketing, systems, and recurring event operations
Teaching Sessional — RMIT University
2019 • Business Statistics Tutor
Analyst & Quantitative Analyst — NAB
2018–2021 • PD modelling (SME & mid-market), early-warning signals
Data & Operations Analyst — illion ANZ
2017–2018 • Data pipelines, BI, reporting

Education

Master of Statistics & Operations Research

RMIT University • 2015–2016

Focus: statistical modelling, optimization, and forecasting.

B.Sc. (Statistics)

RMIT University • 2012–2014

Core probability, inference, and applied modelling.

B.Sc. (Physics) | B.Bus — In Progress

RMIT University • Expected 2028

Want to collaborate?

Analytics, teaching, web systems, creative production, community partnerships, or events. I am interested in work that benefits from clear thinking, practical systems, and strong execution.