Zara Delahunty

Data analyst, skilled in data visualisation and statistical analysis, combined with proficiency in JSON (JavaScript Object Notation), SQL and Excel. A recent Politics graduate from the University of Manchester, with hands-on experience building dashboards and analysing commercial data. Brings a global political perspective to data interpretation, supporting financial and business decision-making. Collaborates with industry leaders on research and development, and is well-suited for IT, tech, or analytical roles through a strong ability to turn complex information into clear, actionable outcomes.

JPMorgan Investment Banking Job Simulation

• Identified an ideal M&A target for a client based on an assessment of their strategic and financial criteria.
• Constructed a DCF model to calculate the valuation of the M&A target and adjusted the model to account for a competitor bid and supply chain interruption.
• Created a 2-pager for the client containing a company profile and summary of the auction process.

Citi Investment Banking Virtual Job Simulation

• Acted as a buyside analyst for a hypothetical client, Big Box Retail, evaluating the acquisition of a smaller retail company.
• Created a company profile for the target firm.
• Built a five-year financial projection using a simple income statement model in Excel.
• Drafted a comparative company analysis.
• Summarised an investor update into an internal report for decision-making.

2024 Common threats

• Cybersecurity series, covering phishing identification, workplace cyber risks, and best practices for digital safety.

AI at work: Use it wisely

• Exploring appropriate applications of AI across various scenarios in commercial insurance, including risk assessment, claims handling, and workflow optimisation.

Data Analysis using Microsoft Excel

• Covering key functions and formulas such as VLOOKUP, INDEX-MATCH, pivot tables, conditional formatting, and data validation to analyse and visualise data effectively.

Getting started with Microsoft Excel

• Focusing on basics such as cell formatting, basic formulas, charts, data entry, and spreadsheet navigation.