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
2024.03 - 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
2021.10 - 2024.10
- 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
2020.10 - 2021.10
- 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 2019.09 - 2020.07
Bachelor of Business Administration - Marketing
Fuzhou University
Fuzhou, China 2015.09 - 2019.06
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
2024.03 - Current
Anti-Money Laundering Analyst
Intouch Games
2021.10 - 2024.10
Payment Risk Analyst
Intouch Games
2020.10 - 2021.10
Master of Science - International Business
University of Birmingham
2019.09 - 2020.07
Bachelor of Business Administration - Marketing
Fuzhou University
2015.09 - 2019.06