Leon

Leon

Data Analyst
United Kingdom

About Me

Highly-analytical, Prince2 certified, Agile results-driven self-starter and team player and a fast learner data Analyst extensive experience in data process re-engineering and improvement leading business towards profita…

Experience

Data Analyst

Citigroup
Jul 2021 - Present · 5 years

• Data Validation, Evidencing data completeness, accuracy and timeliness for upload into DTCC portal and FCA MDP. Verify and review data for errors or discrepancies
• Organise daily calls and production of MI and KPI for management updates. Maintaining consistency of process across regulatory data regimes. Maintain data integrity and confidentiality
• Escalating any data reporting breaches to compliance and document lesson learn. Handle data entry tasks within specified timeframes by following established procedures and guidelines for data entry. Prepare NCA form in line with compliance process for regulators attention. Remediating any data breach through use of T24 data tool. Creating dashboard for data analysis interpretation.
• Liaise with relevant internal and external stakeholder, vendors to negotiate and agree services pricing and contracts.
• Ensuring stakeholder management framework and effective communication progress and risk associated with data functions.

Senior data Analyst

Northern Trust Asset Management
Feb 2021 - Aug 2021 · 6 months

Test and document vendors system upgrades
Collaborate with 1st and 2nd line monitoring and compliance to ensure implemented process and procedures are accepted and signed off
Conduct risk assessment to initiate Process re-engineering
Ascertain automation data upload where required to minimise risk
Responsible for the banks RTS28 and quarterly FCA 3-way data reconciliation using Microsoft excel queries and formular
VLOOKUP, pivot tables connecting from different data sources
Responsible for remediating all previously incorrectly reported trades data realised during reconciliation and auditing process to regulator
Day today MiFID2 and SFTR data reporting upload

Data Analyst – Regulatory

SG Kleinwort Hambros
Jul 2017 - Jun 2020 · 2 years 11 months

Developed client type compliant with MiFiD II reporting requirement strategy by managing pre- and post-Support with client onboarding process to ensure client classification for regulatory reporting and data relevance
Managed daily reporting, exception managements, remediation exercise and data defect to respective regulator
Crafted and presented monthly MI / KPI reports to management on client / product data analysis for insight on corporate / market risk and finance / budgeting
Monitored Data Quality by executing streamlined process for issue management, resolution, and feedback to Business Unit Teams
Managed the periodical 3 ways reconciliation between the business, ARM and FCA
Ensuring any data breaks is escalated, justified and remediated accordingly

Data Analyst

London Borough of Southwark (LBS)
Jul 2016 - May 2017 · 10 months

Managed daily reporting, exception managements, remediation exercise and data defect
Perform data cleaning and updating activity

Senior Analyst: Regulatory Change

Lloyds Banking Group
May 2014 - Jun 2016 · 2 years 1 month

Analysed and monitored regulatory updates and tracked implementation by liaising with technology team to ensure accurate and timely delivery of quality data
Resolved bad data quality in repository by coordinating with technology team and pioneering remediation
Achieved relevant rules assignment to aid reportable and non-reportable products before being sent to FCA by heading various working group sessions with both technology and business stakeholders
Succeeded to increase data accuracy by 70% via leading process automation to reduce manual data processing
Achieved reduction of error by 65% by process re-engineering and assessment or EMIR data reporting

Data Analyst: Regulatory

JP Morgan London
Nov 2013 - May 2014 · 6 months

Performed regulatory reporting analysis in Microsoft excel on FX asset class
Ensured data accuracy and initiated data scrubbing to aid straight through reporting process upload to repository by reviewing reference data with client central team
Initiated controls on future management of reporting process
Delivered timely instruction and settlement report of FX trades to CLS for timely clearance to ascertain active trade reporting to regulators by liaising with SME

Analyst: Post Trade - Settlements Operations

JP Morgan London
Jun 2008 - Nov 2013 · 5 years 5 months

Monitored data compilation and completeness aligned to regular CMAR/CASS reporting requirements
Designed reports in Microsoft excel for periodic KPIs on all market to present a comprehensive Management Information to management on trade volumes
Fail trade and Counterparty risk report analysis, classification and escalation for rating and relationship management

Analyst: Trade settlements Operations

JP Morgan London
Jan 2007 - Jan 2008 · 1 year

Analyst: Client Services

Merrill Lynch London
Jan 2007 - Jan 2007

Analyst: Operations

JP Morgan London
Jan 2004 - Jan 2007 · 3 years

Data Analyst

Citigroup
Aug 2021

Data validation
Evidencing data completeness, accuracy and timeliness for upload into DTCC portal and FCA MDP
Verify and review data for errors or discrepancies
Organise daily calls and production of MI and KPI for management updates
Maintaining consistency of process across regulatory data regimes
Maintain data integrity and confidentiality
Escalating any data reporting breaches to compliance and document lesson learn
Handle data entry tasks within specified timeframes by following established procedures and guidelines for data entry
Prepare NCA form in line with compliance process for regulators attention
Remediating any data breach through use of T24 data tool
Creating dashboard for data analysis interpretation
Liaise with relevant internal and external stakeholder, vendors to negotiate and agree services pricing and contracts
Ensuring stakeholder management framework and effective communication progress and risk associated with data functions

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Statistical Analysis System (SAS) Structured Query Language (SQL) Data Representation Data Analysis Skills Power BI R Programming Language (R) Tableau PRINCE2 Agile Data Analysis Data Validation Data Reporting GDPR Stakeholder Management Communication Microsoft Excel Microsoft Project Microsoft Visio Microsoft PowerPoint Microsoft Excel Queries VLOOKUP Pivot Tables Microsoft Forms Process Re-engineering Automation Risk Assessment Data Reconciliation MiFID II SFTR EMIR RTS28 FCA MDP DTCC portal T24 data tool
Report this Profile?