Summary
Overview
Work history
Education
Skills
Project
Timeline
Generic

Jin Zhao

Manchester

Summary

Skilled worker visa holder seeking visa sponsorship roles. Experienced Systems Analyst specialising in SQL, Python, and Data Governance for financial crime prevention. Proficient in data analysis, visualisation, workflow automation, and system optimisation. Demonstrated ability to streamline workflows, enhance data integrity, and support financial crime risk assessment using advanced data techniques.

Overview

5
5
years of professional experience
5
5
years of post-secondary education

Work history

Systems Analyst

Handelsbanken
Manchester
03.2024 - Current
  • Collected and analysed requirements for building a new case management system to automate manual processes across the financial crime prevention department. Delivered presentations to demonstrate the features and benefits of the system to senior stakeholders and end users. The new system has reduced account review time by 2/3.
  • Used SQL to extract and analyse operational data to support team leaders' workload management, identify exceptions and propose new system controls accordingly.
  • Designed and implemented relational database schemas for storing Customer Due Diligence queries and Quality Assurance workflows' data for better reporting and analytics.
  • Wrote Python scripts(Pandas, Numpy, Requests and SQLAlchemy) and implemented API calls to automate data synchronisation between SQL databases and case management platforms, reduce redundancy and improve data integrity.

Anti-Money Laundering Analyst

Intouch Games
Birmingham
10.2021 - 10.2024
  • Monitored accounts by writing MySQL queries to detect suspicious activities, track and evaluate gaming/financial activities, and accordingly took remediation actions.
  • As a subject-matter expert on AML, provided AML guidance for the first-line operational teams and presented AML processes to the compliance team and senior management.

Payment Risk Analyst

Intouch Games
Birmingham
10.2020 - 10.2021
  • Created frequent payment & fraud trends reports to highlight recent changes and key influencers. Provided insights and recommendations to optimise payment processes and reduce business losses.
  • Led automation projects. Redesigned processes for identity document requests and failed transaction reprocessing. Reduced the time required for 2 daily tasks for the team.

Education

Master of Science - International Business

University of Birmingham
Birmingham, UK
09.2019 - 07.2020

Bachelor of Business Administration - Marketing

Fuzhou University
Fuzhou, China
09.2015 - 06.2019

Skills

  • Certified Anti-Money Laundering Specialist (CAMLS)
  • ICA Specialist Certificate in Money Laundering Risk in Betting and Gaming
  • Data Analysis: Python, SQL
  • Data visualisation: Power BI, QlikView, Excel and PowerPoint

Project

Financial Data Analysis

  • Created a dashboard with Power BI to help key stakeholders evaluate the performance of each financial product.
  • Transformed and processed data by using DAX and power query to ensure data completeness and validity.

https://github.com/ECCO0220/Powerbi_Projects/blob/main/Financial%20Data%20Analysis%20PowerBi.pdf

Timeline

Systems Analyst

Handelsbanken
03.2024 - Current

Anti-Money Laundering Analyst

Intouch Games
10.2021 - 10.2024

Payment Risk Analyst

Intouch Games
10.2020 - 10.2021

Master of Science - International Business

University of Birmingham
09.2019 - 07.2020

Bachelor of Business Administration - Marketing

Fuzhou University
09.2015 - 06.2019

Similar Profiles

Create profile
Jin Zhao