I'm a Business Analytics graduate with Distinction from the University of Surrey, currently working as a Universal Banker in HSBC UK's Wealth & Personal Banking division. I operate daily within a regulated FCA environment, handling fraud assessment, AML verification, and supporting the delivery of financial products and services.
Beyond banking, I'm passionate about using data to solve real-world business problems. From analysing 9,800+ retail transactions across four regional markets to uncover performance drivers, to conducting a behavioural analytics study involving 113 participants, I enjoy combining analytical techniques with business context to support better decisions.
Currently enrolled in HSBC University's Data & AI Academy alongside the role, developing expertise in data analytics and the application of AI to enhance analytical workflows, insight generation, and data-driven decision-making.
Enrolled alongside the role, developing expertise in data analytics and the application of AI to enhance analytical workflows, insight generation, and data-driven decision-making.
01
Data Analysis & Diagnostics
SQL (Window Functions, CTEs)Python (Pandas, NumPy)Exploratory Data Analysis
02
BI & Visualisation
Power BIDAX & Power QueryExcel (Advanced)Dashboarding & KPI Tracking
I use a structured approach to analytics: understanding the business problem, preparing trustworthy data, uncovering meaningful insights, and recommending actions that drive better outcomes.
I seek to push the limits of creativity to create high-engaging, data-driven, and memorable analytical solutions.
Retail Sales Analytics & Forecasting
Business Intelligence / Forecasting
Road Traffic Accident Severity Prediction
Machine Learning
Impact of Statistical Visualisations on Decision-Making
Research / Behavioural Analytics
Battery Recycling Market Forecasting
Forecasting / Market Analysis
Retail Sales Analytics & Forecasting
Business IntelligenceForecastingSQLPythonPower BIProphetDAX
Problem
Diagnose sales performance and build reliable demand forecasting across four regional markets.
Approach
Executed end-to-end SQL diagnostics on 9,800+ retail transactions worth $2.26M across 4 regional markets, applying window functions and CTEs to identify a 32% sales collapse in the South region and low-AOV structural weaknesses in the Central market.
Built a three-page interactive Power BI dashboard with DAX measures, time intelligence modelling, and KPI tracking — enabling regional performance comparison and data-driven business recommendations.
Developed a Python Prophet forecasting model to automate demand planning.
Result
Reduced weekly forecast error (MAPE) from ~250% to ~11%, identifying a 32% sales collapse in the South region and enabling automated demand planning.
Predict accident severity and identify key drivers from UK road-traffic data.
Approach
Conducted end-to-end predictive analytics on 2,480 UK road traffic accident records across 35 variables using SAS for data preparation, visualisation, and modelling.
Applied SAS text analytics and topic modelling on 598 social media posts to generate insights on accident impact and public sentiment.
Result
83.47% accuracy, 0.9172 AUC, and 0.6688 KS statistic — identified location and speed limit as leading severity drivers.
Detailed report and supporting materials available upon request. Certain project artefacts are not publicly distributed due to academic copyright, confidentiality, intellectual property, and professional-use considerations.
Impact of Statistical Visualisations on Decision-Making
ResearchBehavioural AnalyticsRMATLABSQLiMotions
Problem
Measure how visualisation design affects decision accuracy and cognitive load.
Approach
Designed and executed a controlled behavioural analytics study across 113 participants using eye-tracking, pupil dilation analysis, and physiological sensors to measure how visualisation design affects decision accuracy and cognitive load.
Applied Wilcoxon testing and linear mixed-effects modelling in R across multimodal datasets combining response accuracy, fixation heatmaps, and biometric signals.
Result
Redesigned violin plots improved interpretation accuracy from 61% to 70% (p=0.014) and cut response times by 14 seconds compared with traditional histograms.
Detailed report and supporting materials available upon request. Certain project artefacts are not publicly distributed due to academic copyright, confidentiality, intellectual property, and professional-use considerations.
Identify the stronger European market for battery-recycling investment.
Approach
Built a fixed-effects regression model forecasting battery recycling volumes through 2027 across 2 European markets, identifying the stronger investment market through ROI-based analysis across 10 regulatory and commercial variables.
Conducted end-to-end market analysis integrating EU regulatory frameworks, fleet age structure data, and recycling volume datasets across 2 markets to assess commercial viability and investment risk.
Result
Delivered a market-entry strategy report covering 10 regulatory areas within a 4-month internship, directly supporting senior leadership decision-making on European market entry.
Detailed report and supporting materials available upon request. Certain project artefacts are not publicly distributed due to academic copyright, confidentiality, intellectual property, and professional-use considerations.
BEYOND THE SPREADSHEET
Cases, stages & competitions
Representing the University of Surrey at the UK’s largest inter-university consulting competition — The Consulting Summit 2025, hosted by UCL Consulting Society in partnership with Oliver Wyman.
Our case: “Revitalising Santander Cycles — sustaining and expanding market share in London’s competitive bike-sharing market.” Competing against 25 teams from across the UK, we built a data-driven market growth strategy and presented structured recommendations to a panel of industry judges, with mentorship from BCG and McKinsey & Company.
25TEAMS ACROSS THE UK
1SURREY DELEGATION
BCG · McKinseyINDUSTRY MENTORS
Feb 2025UCL, LONDON
Presenting the comparative plan analysis to industry judges
Inter-university case competition · UCL
UCL Consulting Society × Oliver Wyman · Feb 2025
My professional experience
Mar 2026 – Present
Universal Banker — Wealth & Personal Banking
HSBC UK · London
Assess and resolve 2–3 fraud cases daily applying AML verification protocols in a regulated FCA environment. Support delivery of financial products within FCA Consumer Duty frameworks. Enrolled in HSBC University's Data & AI Academy.
Nov 2025 – Feb 2026
Research Analyst Intern
ReviveBattery B.V · London
Built fixed-effects regression models forecasting battery recycling volumes through 2027. Conducted end-to-end market analysis across EU regulatory frameworks. Delivered a market-entry strategy report covering 10 regulatory areas.
Sept 2024 – Sept 2025
MSc Business Analytics — Distinction
University of Surrey · Guildford
Activities: Surrey Consulting Society, University of Surrey Cricket Club. Key Projects: Road Traffic Accident Severity Prediction & Text Analytics (SAS, Predictive Modelling); Rapid DNA Forensics Process Optimisation (Monte Carlo Simulation, Discrete Event Simulation & ROI Analysis).
WHAT OTHERS SAY
A word from my supervisor
AH
“It was a pleasure to supervise Arpit for his dissertation project. He was dedicated and professional, and was very keen to learn everything he could. Arpit is clearly a very passionate and able analyst and I would happily recommend him!”
Dr Andy Hill
Senior Lecturer in Business Analytics · Surrey Business School, University of Surrey
Thanks for reaching out. I'll get back to you shortly.
Let's talk about your next Analyst hire
I'm actively looking for Business Analyst and Data Analyst opportunities where I can combine analytical skills with domain knowledge to drive measurable impact.
