Joseph Liang Email & Phone Number

Burnaby, BC, CA

Toronto, Ontario, Canada

Toronto, Ontario, Canada

• Saved the team 20 work hours per month by automating an extensive “Top Publishers” reportthrough coding a 300-line Python script.
• Created three self-updating Tableau Dashboards by writing ETL scripts that connectedMySQL/RedShift databases, applied transformations and uploaded data to Tableau Server.
• Swiftly delivered data pulls, e.g. region-based email lists, segment-based KPI summariesthrough writing efficient SQL queries and cleaning/formatting data on Jupyter Notebooks.
• Solved the issue of not being able to send clients dashboards with proprietary data, byidentifying a method to individually change a packaged workbook’s dataset programmatically

Toronto, Ontario, Canada

• Streamlined the process of creating a cost-of-living index by picking indicators and associated measures, automating repetitive tasks, writing scraping codes, and clearing data.
• Empowered 10 youth-serving organizations by teaching them about the benefits of using open data, Google Sheets data analysis, and how to create beautiful data visualizations.
• Extracted, cleaned, and organized datasets and tables for other coordinators and clients.
• Persuaded stakeholders such as RBC about the value and methodology of our “Real Affordability” index via an effective PowerPoint presentation.

Montreal, Quebec, Canada

• Created a more fair exam environment by suggesting the addition of a word limit in response to students taking advantage of online testing.
• Communicated with the instructor, improving the answer key by noting ambiguities and typos.

Vancouver, British Columbia, Canada

• Taught students by simplifying complex topics and catering to their strengths and learning styles. For example, by highlighting how a single binary variable regression was like a t-test.
• Adapted to an online working environment with minimal interruption following a sudden lockdown by using Zoom and Squid (a whiteboard software) to maintain quality teaching.

Vancouver, British Columbia, Canada

• Provided excellent customer service by listening attentively to guests and summarizing orders.
• Adapted for guests such as by translating the menu to Chinese and making off-menu drinks.
• Problem solved for guests such as by negotiating with a supervisor to offer a refund to a dissatisfied family who waited 30 minutes for cold food. As a result, restoring brand trust.

Port Moody, British Columbia, Canada

• Created a database for emergency contacts and allergies, and maintained a tight budget.
• Organized three weeks of activity for campers including lesson plans, field trips (e.g. to Science World and Beaty Biodiversity Museum), art projects, and other activities.
• Instructed campers during crafts, taught lessons about different countries and oversaw games.

Master Of Arts - Ma, Economics, 3.71 Overall Gpa (Out Of 4.0)

Bachelor Of Arts - Ba, Economics, 3.75 Overall Gpa (Out Of 4.33)