Joan Xia Email & Phone Number

Canada

Toronto, Ontario, Canada

- Verified and processed invoices, ensured compliance with provincial guidelines, and supported financial accuracy through audit assistance and process improvement recommendations.

Hamilton, Ontario, Canada

- Student leader and in-residence community advisor to 70 first year students- Moved-in and welcomed 700 students over the course of two days- Organise and facilitate monthly community events for 350 first year students to foster relationships and community spirit, as well as 2 orientation week events- Conducted 2 check-ins per term with 35 students to support and direct them to relevant campusresources- Monitor residence during weekly night shifts, submit work orders and reports to ensure the safety of the residential community of 700 students

Toronto, Ontario, Canada

Technology & Operations | TEO Transformation Office | Transformation & Innovation Team- Designed and built a Tableau dashboard to increase tech modernization and risk reporting visibility for stakeholders- Engaged with various stakeholders and groups across RBC for requirements gathering and feedback during the development process - Data analysis and figure generation for significant strategic project proposals within the team- Presented dashboard MVP to Senior Director- In addition to core responsibilities, participated in a case competition, volunteered for two events, engaged in over 20 coffee chats, and hosted department townhall trivia

Calgary, Alberta, Canada

Business Analyst Intern on the Facility Asset Management team- Analysed and interpreted data lakes to understand trends across all departments at TransCanada- Created data visualisation dashboards using Power BI for the Facilities Reliability & Integrity Department of 200 engineers to use- Used Power Automate to create workflows that streamlined and minimised manual inputs for engineers - Created a data warehouse for legal documentation within the company- Organised and hosted quarterly department town halls as the MC to ensure a smooth transition between guest speakers - Liaised with key internal stakeholders such as legal, commercial, operational, project management and external clients- Presented term work including dashboard initiative to Senior Director

Toronto, Canada Area

- Co-developed balanced schedule to meet objectives of the program, incorporating intellectually stimulating camp activities- Enriched camper experience by teaching valuable skills

Princess Margaret Cancer Research Centre

- Created marketing material for stakeholders such as ebooks, highlighting important details and producing a concise, condensed summary of the company's medical imaging analysis product information- Conducted analysis of trends on client activity and created a stakeholder list of over 500+ potential clients using advanced Microsoft Excel and Access techniques, effectively establishing an organized database for all analytical marketing data - Rebranded and revived social media and online presence, followed up with consistent marketing services such as advertising on social media, increasing the number of prospective clients/interested parties - Updated research content on the company website, applying a business lens to scientific principles- Created a sleek safety procedures orientation brochure, outlining clear expectations and reducing confusion and questions among new employees

Bachelor Of Commerce - Bcom, Management Information Systems And Services, Dean’S Honour List 2019-2024

Activities and Societies: Residence Community Advisor, Angels Without Boundaries ClubYear 4 Honours Commerce student specializing.

Education record

Activities and Societies: UNICEF, Best Buddies, Biology Club, Pledges for Change, DECA, Running Club, Vocal Fusion- won the Citizenship.