Greater Coventry Area
Selected to mentor incoming statistics students in adapting to university-level quantitative study.
•Built an end-to-end ETL pipeline, consolidating and standardising 18 months of Monthly Business Reports into a single structured dataset. •Designed an interactive Power BI dashboard tracking 172k+ customers across KPIs, time-series trends and segmentation by business line, customer status and digital engagement. •Identified digitally inactive customer segments and cross-selling opportunities through product holding analysis (avg. 2.91 products per customer). •Built an exploratory Python time-series model to analyse trends in internet and mobile banking adoption.
•Supported risk assessment activities by reviewing organisational processes and control frameworks and contributing to gap analyses that identified control enhancement opportunities. •Communicated with clients to improve the quality of risk and control matrices, enhancing compliance and operational resilience. •Worked on a client engagement that involved verifying data accuracy through bank reconciliation and analysis of financial statements, formulating findings, and contributing to draft internal audit reports that highlighted key deficiencies and areas for improvement. •Conducted Google- and World-Checks as part of the customer due diligence process. •Refined Excel skills through practical application of VLOOKUP, pivot tables, and conditional formatting. •Completed the following training as part of my internship: Internal Audit and Risk Management - Global Independence training Do What is Right - Integrity at KPMG training Global Information Protection and Data Privacy Fundamentals