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 3 months

• 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

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

Data Analyst – Regulatory

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

<p>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<br>
Managed daily reporting, exception managements, remediation exercise and data defect to respective regulator<br>
Crafted and presented monthly MI / KPI reports to management on client / product data analysis for insight on corporate / market risk and finance / budgeting<br>
Monitored Data Quality by executing streamlined process for issue management, resolution, and feedback to Business Unit Teams<br>
Managed the periodical 3 ways reconciliation between the business, ARM and FCA<br>
Ensuring any data breaks is escalated, justified and remediated accordingly</p>

Data Analyst

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

<p>Managed daily reporting, exception managements, remediation exercise and data defect<br>
Perform data cleaning and updating activity</p>

Senior Analyst: Regulatory Change

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

<p>Analysed and monitored regulatory updates and tracked implementation by liaising with technology team to ensure accurate and timely delivery of quality data<br>
Resolved bad data quality in repository by coordinating with technology team and pioneering remediation<br>
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<br>
Succeeded to increase data accuracy by 70% via leading process automation to reduce manual data processing<br>
Achieved reduction of error by 65% by process re-engineering and assessment or EMIR data reporting</p>

Data Analyst: Regulatory

JP Morgan London
Nov 2013 - May 2014 · 6 months

<p>Performed regulatory reporting analysis in Microsoft excel on FX asset class<br>
Ensured data accuracy and initiated data scrubbing to aid straight through reporting process upload to repository by reviewing reference data with client central team<br>
Initiated controls on future management of reporting process<br>
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</p>

Analyst: Post Trade - Settlements Operations

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

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

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

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

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?