Oi Ching Wong
Graduate Data Analyst
Glasgow
Summary
I'm a newcomer to Toronto from the United Kingdom, originally from Hong Kong. Eager to bring my skills as a Data Analyst to a new environment, as well as a strong drive to learn and work with all kinds of different people. I do not require a sponsorship.
Overview
5
5
years of professional experience
Work History
Graduate Data Analyst
NatWest
09.2023 - Current
- Currently working with functions and franchises to ensure their data management aligns with NatWest's Data Management Operating Procedure (DMOP) compliant.
- Assisted with ad-hoc data request projects from stakeholders, mainly using SQL to extract, analyze and resolve issues on raw data.
- Produced data reports using Excel and data visualization techniques to provide insights that could be understood by end users.
- Created a Tableau dashboard to showcase daily insights on risk customer case numbers, performed Quality Assurance (QA) testings throughout the production process to ensure accuracy and user friendliness. Performed daily refreshing of the dashboard within a set time to update and inform stakeholders of the changes within the data.
- Assisted in legacy code migration from Teradata to Snowflake, with documentation on the process and a data dictionary to allow ease of future project continuation.
Data Analytics Intern
NatWest
06.2022 - 08.2022
- Developed core SQL skillset, as well as data visualisation and presentation skills through assisting on various Teradata team projects.
- Produced an insights package for stakeholders which presented and analyzed NatWest's customer demographic trends and provide suggestions on NatWest's current products.
- Presented findings as a team of graduates on NatWest's ongoing climate strategies, provided recommendations and analysis as a team on the future progression of meeting the Bank's climate goals.
Content Development Freelancer
MTR Corporation
06.2020 - 09.2020
- Created and published social media posts for the MTR Mobile App with a wide range of topics including: Lifestyle, Advertisements, Campaigns, and Corporate content.
- Took charge of the input and upload of final drafts onto the Content Management System (CMS), structured folders and filtered keyword tags to suitable categories.
- Helped with bilingual content copywriting in the English and Chinese Language.
- Use of various software such as Adobe Illustrator and Adobe Photoshop to create and edit visual content / banners for campaigns.
- Collaborated and communicated efficiently within the Commercial & Marketing Division team to generate new ideas for posts, and providing end-to-end solutions for various tasks.
Temporary Project Assistant
MTR Corporation
07.2019 - 09.2019
- Assisted the development of MTR Mobile App User Acceptance Testing (UAT) including content creation and bug testing.
- Collaborated with the front-end testing team and back-end developers for various testing such as: in-station testing, application bugs, QR code testing, and language checking.
- Conducted follow-up testing with written reports on error findings, logging error reports onto Redmine.
- Assisted in creating promotions and projects for the MTR Mobile App and the MTR Official Website.
Education
Master of Science - Masters of Science (SE)
University of Glasgow
Glasgow, Scotland 9 2022 - 9 2023
Master of Arts - Digital Media And Information Studies
University of Glasgow
Glasgow, Scotland 9 2018 - 6 2022
Skills
Java
undefinedDesired Location
Toronto, Canada, 2024, first
Nationality
Hong Kong, China
Current Location
Glasgow, UK
Personal Information
- Date of Birth: 11/17/00
- Gender: Female
Timeline
Graduate Data Analyst
NatWest
09.2023 - Current
Data Analytics Intern
NatWest
06.2022 - 08.2022
Content Development Freelancer
MTR Corporation
06.2020 - 09.2020
Temporary Project Assistant
MTR Corporation
07.2019 - 09.2019
Master of Science - Masters of Science (SE)
University of Glasgow
9 2022 - 9 2023
Master of Arts - Digital Media And Information Studies
University of Glasgow
9 2018 - 6 2022
Similar Profiles
Nikhil SinghNikhil Singh
Customer Service and Operations Analyst at NatWestCustomer Service and Operations Analyst at NatWest
TAMILARASAN STAMILARASAN S
Supply Chain and Delivery Manager at NatWestSupply Chain and Delivery Manager at NatWest
Prem Shankar ManhiraPrem Shankar Manhira
IT Projects Portfolio Manager at NatWestIT Projects Portfolio Manager at NatWest
NISHA SHARMANISHA SHARMA
Senior Analyst at NatwestSenior Analyst at Natwest
Katie SutherlandKatie Sutherland
Administrative assistant at University of GlasgowAdministrative assistant at University of Glasgow