Summary
Overview
Work History
Education
Skills
Projects
Awards
Volunteer Experience
References
Timeline
Generic
Killian Hou

Killian Hou

Surry hills,NSW

Summary

Dynamic Management Consultant with a proven track record at Blue Mountain City Council, leveraging data analysis and visualization skills to drive strategic insights. Achieved over $20k monthly savings through effective risk evaluation and resource reallocation. Proficient in SQL and Excel, with strong communication abilities to present findings and influence stakeholders.

Overview

1
1
year of professional experience

Work History

Management Consultant

Blue Mountain City Council
03.2024 - 06.2024
  • Identified and reconciled errors in the council data on local business
  • Analyze Business data within blue mountain for insights using Tableau and Excel.
  • Evaluate risks and financial requirements for the reforming business structure implementation and save average of fund supporting local business over 20k a month
  • Successfully remedied recognition on local business development and resource reallocation.
  • Internship

Solution Consultant

Western Sydney University
01.2024 - 03.2024
  • Delivered executive presentations on funding research, using analytical skills (Python, ML) to support start-ups investment decisions
  • Produced detailed diagrams and reports using Excel to evaluate annual funding options for tech start-ups, supporting strategic financial decisions.
  • Presented funding research findings to stakeholders, enabling informed investment choices for star-tup clients.
  • Internship

Marketing research Analyst

Practera
12.2023 - 03.2024
  • Led digital marketing strategies (LinkedIn, YouTube) and campaigns, optimizing ROI by analysing KPIs (CAC, conversion rates) in Tableau and Salesforce.
  • Leveraged Google Analytics and CRM platforms (Salesforce) to track campaign performance, enhance stakeholder communication, and improve e-commerce visibility for clients.
  • Designed data-driven email marketing initiatives and presentations to showcase findings, strengthening client brand reputation.
  • Internship

Education

Bachelor of Business Analytics -

Western Sydney University
01.2024

Diploma of Business -

Monash University
01.2022

Skills

  • Data analysis with SQL
  • Visualization using Tableau
  • Excel data management
  • Salesforce CRM skills
  • Digital marketing techniques
  • Digital marketing

Projects

WSDA Music Records Sales Analysis

Role: Business Analyst Intern | Duration: Dec 2024 – Mar 2025, Tools: SQL R, Excel

Built a SQL data pipeline to aggregate historical sales/inventory data (10+ tables) and flag outliers., Wrote SQL queries, functions to consolidate 500K+ transactions from multiple tables, Identified top-performing countries/ and underperforming regions needing targeted promotions, Built a Tableau dashboard connected to SQL outputs 

Awards

KPMG ABSA business case competition winner – Medical AI Security and Cost Analysis, International scholarship by University of Tasmania, International scholarship by Western Sydney University

Volunteer Experience

Sanfilippo's Children’s Foundation (volunteer 08-2022 to 08-2024)

Applied CRM strategies to manage donor relationships and orchestrated fundraising campaigns, raising over $200K via targeted outreach, expanded the foundation’s networking circle, securing additional business partners for fundraising initiatives

References

References available upon request.

Timeline

Management Consultant

Blue Mountain City Council
03.2024 - 06.2024

Solution Consultant

Western Sydney University
01.2024 - 03.2024

Marketing research Analyst

Practera
12.2023 - 03.2024

Bachelor of Business Analytics -

Western Sydney University

Diploma of Business -

Monash University

Similar Profiles

CREATE PROFILE
Killian Hou