Mohamed Elfiky

MSc FinTech & Policy graduate with experience in research, data analysis, and customer insights. Skilled in Python, SQL, SPSS, and Power BI, with a strong foundation in market research and policy evaluation. Experienced in turning complex data into clear, actionable insights through academic and professional projects. Curious, detail-oriented, and eager to contribute to Ipsos’ mission of understanding people and delivering impactful research for clients.

Principles of Analytics Group Project

Achieved Merit in a consulting-style analytics project, delivering insights to a simulated client using real-world insurance customer data.

• Collaborated in a team of four to analyse 9,800+ records and 86 variables, identifying key factors behind caravan insurance interest.
• Prepared SQL queries, data cleansing, and KPI visualisation using Power BI to support findings.
• Led stakeholder-facing presentations, translating predictive model results (SPSS & R) into actionable business recommendations.
• Communicated customer profiling strategies to a non-technical audience, improving targeting precision for marketing efforts.

Risk Management Coursework Project 

• Achieved Distinction in applied risk assessment and control evaluation coursework.
• Assessed liquidity and credit risks using Altman’s Z-score, liquidity ratios, and CDS spread analysis.
• Evaluated foreign exchange exposure and designed hedging strategies across FX, derivatives, and economic risks.
• Applied VaR and Expected Shortfall to portfolio-level risk, incorporating stress testing and scenario analysis.

Financial Modelling Independent Project 

• Earned Merit for constructing a data-driven portfolio model using Bloomberg data and Python.
• Analysed diversified asset portfolios across global equities, bonds, and FX exposure (USD/EUR conversion).
• Calculated volatility, daily returns, and correlation matrices to inform risk-aware asset allocation.
• Presented findings on portfolio optimisation, asset weighting, and currency impact over a 10-year window.

Independent Ransomware Protection Project

• Developed and tested a Windows script to automatically restrict execution permissions on newly downloaded executable files, reducing malware risk.
• Worked with SIEM and SOAR frameworks to simulate real-time threat detection and automate responses using prebuilt playbooks.
• Contributed to the design of a secure folder architecture to isolate and mitigate ransomware attacks without human intervention.
• Balanced technical controls with usability and performance, ensuring feasibility of implementation.