Joe Tran
Sydney,Australia
Overview
6
6
years of professional experience
Work History
Customer Service
Coles Australia
01.2022 - 01.2023
- Customer Service, deliver shopping satisfactory experience for Coles Supermarket's customers, helping retail department to enhance sales and services.
Marketing Commercial Analyst
Hem Viet
01.2019 - 01.2020
- Exploratory and analyze assigned datasets with Excel tools
- Research industry trends and competitors
- Collecting data from different methods such as questionnaires, polls, surveys, and other data collection resources
- Transformed complex data into easily understandable reports and dashboards, facilitating effective communication of results.
Office Consultant
International University - Vietnam National University
01.2017 - 01.2018
- Managed staff scheduling, task allocation, and project assignments using Excel, while also serving as the point of contact for human resources inquiries
- Facilitated the approval of timesheets and provided responsive solutions to payroll-related questions.
Data Analyst
William and Partners Accounting
01.2023
- Create data storage in Google Sheets for effective entry data performance, helping businesses client successfully implement a new workflow for data entry and reporting daily sales, staff performance, expenses, and marketing
- Successfully implemented a new workflow of managing data and using data analytics skills to create an effective dashboard report for business
- The new system has granted approval to officially run within requirement testing time, helping businesses to save costs, and resources and bring up accurate insight details
- Utilized Power BI and Excel for data preprocessing, transformation, and statistical analysis to derive actionable insights
- Create interactive finance data visualizations in dashboard using Power BI, enhancing data-driven decision-making in marketing initiatives
- Conducted in-depth data analysis to identify trends, patterns, and anomalies in operation data, offering valuable marketing insights.
Education
Master of Information System Management, Project Management, Database Systems, Information Security, Business Analysis, Application Modelling, Systems Analysis and Design, Enterprise Integration System, Information Systems Design and Management, Applied Cyber Security, Cyber Crime and Cyber Policing -
Macquarie University
Data Analytics Intensive K1, SQL, Database Design Fundamentals, EDA Process, Python libraries for EDA, Data exploration & validation, Statistics, Data quality issues, Data summarization, Data manipulation/ transformation/ engineer, building blocks and navigate Power BI, Data transformation with Power Query -
Coding Mentor
Bachelor of Commerce Major in Marketing, Digital Marketing, Strategy Marketing, Consumer Behavior, Marketing Research, Marketing Management, Integrated Marketing Communication -
Macquarie University
Skills
- Exploratory Data Analysis (EDA)
- Data-driven-decision making
- Data Visualization
- Data Manipulation
- Data Modelling
- Statistics, Math, and critical thinking
- Identify trends, patterns, and anomalies from conducting data analysis visualizations
- Database management systems
- Collaborative teamwork
- Attention to details
- Problem-solving, self-learner, quickly adapt, multitask
- Effective communication and presentation
- Python
- SQL
- MySQL Workbench
- Power BI
- Excel
Technical Experience
- Mr. Splash Power Bi Dashboard, Aug 2023, Develop a new structure of database storage for client's company to replace an aging system that is currently not efficient. Prepare data, clean data by Excel and Power BI, and then use all data resources to create reports, and dashboards to pull out business insights of finance, performance, expense, revenue, and marketing., Power Bi, Excel, Google Sheet
- Football Data Analysis with Python language, Sep 2023, Conducting an in-depth data analysis project focused on historical football match results. Leveraging Python data analysis libraries such as Pandas, NumPy, Matplotlib, and Seaborn, performing exploratory data analysis to extract meaningful insights from the dataset. The primary objectives of the project were to examine team performance, assess the impact of playing at home, and identify trends in football results over time., Python (Pandas, NumPy, Matplotlib, Seaborn), Collab Notebook, GitHub for version control
- Olympic Tokyo 2020 Power Bi Dashboard, Oct 2023, Utilize Power BI's analytical capabilities to derive insights from the Olympic Tokyo 2020 data. This may involve calculating trends, comparing performance across countries or sports, and identifying patterns or outliers., Power Bi, Excel
Other Technologies
- CSS/HTML
- Google Suites
- Figma
- Microsoft Offices
Libraries Frameworks
- Pandas
- Seaborn
- Matplotlib
Personal Information
Title: DATA ANALYST | BUSINESS ANALYST | SYSTEM ANALYST
References
Available upon request
Timeline
Data Analyst
William and Partners Accounting
01.2023
Customer Service
Coles Australia
01.2022 - 01.2023
Marketing Commercial Analyst
Hem Viet
01.2019 - 01.2020
Office Consultant
International University - Vietnam National University
01.2017 - 01.2018
Master of Information System Management, Project Management, Database Systems, Information Security, Business Analysis, Application Modelling, Systems Analysis and Design, Enterprise Integration System, Information Systems Design and Management, Applied Cyber Security, Cyber Crime and Cyber Policing -
Macquarie University
Data Analytics Intensive K1, SQL, Database Design Fundamentals, EDA Process, Python libraries for EDA, Data exploration & validation, Statistics, Data quality issues, Data summarization, Data manipulation/ transformation/ engineer, building blocks and navigate Power BI, Data transformation with Power Query -
Coding Mentor
Bachelor of Commerce Major in Marketing, Digital Marketing, Strategy Marketing, Consumer Behavior, Marketing Research, Marketing Management, Integrated Marketing Communication -
Macquarie University
Similar Profiles
Vaishali SharmaVaishali Sharma
Inventory Team Member at Coles AustraliaInventory Team Member at Coles Australia
Rory ScomazzonRory Scomazzon
Coles Supermarket Service Supervisor at Coles AustraliaColes Supermarket Service Supervisor at Coles Australia
Sweta PatelSweta Patel
Cashier at Coles AustraliaCashier at Coles Australia
Osca SmithOsca Smith
Team Member at Coles AustraliaTeam Member at Coles Australia
Luke BilobrkLuke Bilobrk
Client Advisor at PradaClient Advisor at Prada