Fangrui (Flory) Hou
Milton,QLD
Summary
A proficient data analyst with one year of experience in data transformation, management, and visualization. Certified in Power BI, Tableau, Azure, and Alteryx, and skilled in SQL and Excel VBA, I am adept at addressing diverse data challenges. I am a proactive, team-oriented self-starter who excels both independently and collaboratively. My tertiary education and experience in finance enable me to effectively integrate financial insights with data analysis.
Overview
3
3
years of professional experience
Work History
Data Analyst Consultant
The Data School
01.2023 - Current
- Collaborated with cross-functional teams to develop comprehensive data-driven solutions for various business challenges.
- Developed strong working relationships with clients by consistently delivering high-quality results tailored to their unique requirements.
- Identified trends and patterns in complex datasets, driving strategic recommendations for process improvements.
- Assessed potential risks within datasets, recommending appropriate mitigation strategies as needed.
- Regular personal development of data analytics techniques through courses and certifications.
Financial Assistant
Silver Asset Services
01.2021 - 01.2022
- Identified bad debt management for all overdue payments and hand over to a third-party company for processing. Assisted in developing an overdue bill management system as well as related SOPs.
- Improved and streamlined the billing process. Continuously monitored the process to identify any issues and prevent the occurrence of incorrect invoices.
- Presented the financial reports and recommendations to the body corporate or committee.
- Monitored the performance of CRM and customer self-service portal to identify any issues that need to be addressed.
Education
Master of Commerce - Finance
The University of Queensland
Brisbane, QLD12.2021
Bachelor of Commerce - English Business Economics
Hunan Institute of Science And Technology
China06.2019
Skills
- Power BI Skills (Certified)
- Tableau Expertise (Certified)
- SQL Proficiency (Certified)
- Alteryx Advanced (Certified)
- Advanced Excel (VBA)
- Azure Fundamentals (Certified)
Project Experience
Financial Data Transformation and Visualization Transportation Company
- Leveraged Tableau to transform intricate financial data from Excel spreadsheets into automatically updating financial statements, featuring more distinct and clearer categorization.
- Enhanced financial data visualization and accessibility, improving accuracy and reliability.
- Enabled real-time data analysis for better decision-making.
API Integration for Customer Segmentation Online Design Software
- Analyzed user-registered email addresses to enable targeted customer segmentation.
- Utilized Excel, Alteryx Designer, and Tableau Desktop for data analysis and visualization.
- Provided comprehensive insights into customer demographics and behaviour patterns, informing a marketing strategy that aimed to increase revenue by 10%.
Dashboard Development for Real-Time Monitoring and Promotion Strategies Charity Organization
- Tracked user demographic shifts and buyer-donor interactions to create dashboards for real-time monitoring.
- Informed targeted product promotion strategies for diverse customer groups, enhancing engagement across varied customer segments.
- Resulted in increased sales and donations.
Timeline
Data Analyst Consultant
The Data School
01.2023 - Current
Financial Assistant
Silver Asset Services
01.2021 - 01.2022
Master of Commerce - Finance
The University of Queensland
Bachelor of Commerce - English Business Economics
Hunan Institute of Science And Technology
Similar Profiles
DOV RANDDOV RAND
Data Analytics Intern at School Data Corp.Data Analytics Intern at School Data Corp.
Benedetto BiiBenedetto Bii
Career Support at Colaberry School Of Data AnalyticsCareer Support at Colaberry School Of Data Analytics
Chayaphol LortaraprasertChayaphol Lortaraprasert
Teaching Assistant at UTokyo Data Science School Internship CourseTeaching Assistant at UTokyo Data Science School Internship Course