About Ian
English
Native or bilingual
Experience
- InvestecSenior Technical Business AnalystBANKING AND INSURANCENovember 2023 - June 2025 (1 year and 7 months)London, United KingdomWorked with Credit Risk business users, report owners and technical teams to analyse the Everest enterprise Credit Risk data warehouse, developing an evidence-based understanding of the underlying business processes, supporting systems and data, and using those findings to support its redevelopment for IRB compliance and migration to Azure.I investigated complex data flows, validated data quality and lineage, and helped build a detailed understanding of existing business processes before transformation began.
- Investigated Credit Risk and Treasury data structures and business processes to support redevelopment of the Everest data warehouse and its migration to Azure.
- Analysed operational databases using SQL to understand how business-critical data was stored, transformed and consumed.
- Mapped data between legacy and target platforms, identifying dependencies and validating migration requirements.
- Worked with Treasury SMEs, developers and architects to resolve complex data and integration issues.
- Reduced delivery risk by validating system behaviour against actual operational data rather than relying solely on documentation.
- Kleinwort HambrosSenior Technical Business & Data AnalystBANKING AND INSURANCEMarch 2016 - September 2022 (6 years and 6 months)London, United KingdomWorked with Core Banking, Treasury, Finance, Credit Risk and Regulatory Reporting teams to determine the requirements for the bank's Osprey "golden source" reporting platform. Developed an evidence-based understanding of the underlying business processes, systems and data, ensuring regulatory reporting and downstream systems were built on trusted, validated information rather than assumptions.Analysed complex banking data, translated business requirements into technical specifications, and supported regulatory reporting, data migration and system integration initiatives.
- Worked with business users, SMEs and developers to analyse requirements and design practical solutions.
- Performed data analysis, mapping and transformation across core banking, treasury and regulatory data.
- Delivered Functional, Technical and Data Mapping Specifications for new developments.
- Supported regulatory reporting including FINREP, PRA110, Basel III, IFRS9, Liquidity and AMM reporting.
- Led System Integration Testing (SIT), User Acceptance Testing (UAT), defect management and production readiness.
- Supported strategic data migration and legal entity merger projects, reducing delivery risk through detailed impact analysis.
- Bank of America Merrill LynchSenior Business AnalystBANKING AND INSURANCEMay 2014 - October 2015 (1 year and 5 months)London, United KingdomWorked with Prime Brokerage business users and global technology teams to analyse the Margin & Risk platform, developing an evidence-based understanding of collateral processes, pricing data and trading workflows to support strategic platform replacement and client migration to a new risk-based solution.
- Analysed upstream and downstream collateral and pricing data flows.
- Defined ETL requirements for internal and external pricing feeds.
- Analysed regulatory requirements including US Reg U and Reg W.
- Investigated Bloomberg reference data for the "Do Not Publish" programme.
- Improved pricing accuracy by analysing collateral data flows and defining enhanced mapping rules.
- Worked with global teams across London, Dublin, New York, Hong Kong and India.
Recommendations
Be the first to recommend Ian
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4