Shengjun (Josh) Xu
Data Analyst
Thornhill,Ontario
Summary
Detail-oriented and self-motivated professional with 1+ year of experience in data analytics, financial modeling, and business intelligence. Proficient in tools like SQL, Python, Tableau, and Excel. Currently pursuing an entry-level Data Analyst role across various industries to leverage my skills. Also working toward CFA and FRM certifications to enhance my financial analysis and risk management expertise.
Overview
2
2
years of professional experience
2
2
years of post-secondary education
Work History
Day Trader Trainee
Day Trade The World
Toronto, ON
9 2023 - Current
- Executed daily financial transactions on the PPro8 platform and analyzed over 100,000 financial products through variance analysis using Excel; generated weekly reports and visual dashboards with Power BI to deliver results
- Implemented SQL and VBA Macros to standardize and automate the data processing, mapping, aggregation, and visualization procedures, and developed predictive models to monitor real-time market shifts and forecast trends
- Conducted robust risk management strategies by optimizing trading positions and employing targeted stop-loss orders, achieving a 15% reduction in financial exposure and improving portfolio resilience to optimize asset allocation
- Strengthened communication skills through preparing weekly presentations to the senior management teams and proposing actionable insights to mitigate potential risks, drive decision-making, and streamline operations.
Data Analyst
China Southern Airlines
04.2022 - 08.2022
- Spearheaded regular business intelligence and end-to-end data analytics for over 100,000 records using Excel and presented analytical results to internal teams to support strategic business planning and identify new opportunities
- Gathered and interpreted over 50,000 historical datasets from diverse sources using SQL and advanced machine learning techniques to provide stakeholders with deep insights into industry trends, customer behavior, and seasonal patterns, resulting in a 15% improvement in forecast accuracy and a 10% increase in customer satisfaction score
- Provided analytical, sales, and marketing support for new air route launch initiatives by leveraging comprehensive ad-hoc analysis to resolve business requests, track performance, and ensure effective solutions implementation
- Enhanced cross-departmental collaboration by 30% through the creation of interactive dashboards in Tableau, facilitating data transparency, improving stakeholder engagement, and maximizing operational efficiency.
Education
Honours Bachelor of Arts - Financial Mathematics
Wilfrid Laurier University
Waterloo, ON 09.2021 - 08.2023
Skills
Data Analysis
Data Visualization and Presentations
SQL, Excel, R, Matlab
Python Programming
Timeline
Data Analyst
China Southern Airlines
04.2022 - 08.2022
Honours Bachelor of Arts - Financial Mathematics
Wilfrid Laurier University
09.2021 - 08.2023
Day Trader Trainee
Day Trade The World
9 2023 - Current
Similar Profiles
Shakkila AnsariShakkila Ansari
Software Consultant at Dubai Trade World, DP WorldSoftware Consultant at Dubai Trade World, DP World
Erik StaffordErik Stafford
Self Employed at Day Trade & DeliverySelf Employed at Day Trade & Delivery
Mohanad YamanMohanad Yaman
Project Manager (Expand North Star ‘GITEX’) & (GITEX Europe) at Dubai World Trade CentreProject Manager (Expand North Star ‘GITEX’) & (GITEX Europe) at Dubai World Trade Centre
Kevin Kyle LeguaKevin Kyle Legua
Forklift Operator / Shipping and Receiving Clerk at Merithian Products Corp.Forklift Operator / Shipping and Receiving Clerk at Merithian Products Corp.
Amir JafariAmir Jafari
Graphic Designer at GYEON GCCGraphic Designer at GYEON GCC