As a Data Analyst, I use Python with Pandas & pySpark to process and analyse data. In my spare time I also build projects and solve data structures and algorithm problems.

I present data within Power BI and Excel. Along with building financial models using Excel and Power Apps to allow clients to enter data directly into the model/database within Sharepoint sites & Power BI reports.

Typically, client data is stored and managed using Data Pipelines & Warehouses/Lakehouses within Microsoft Fabric. Our systems allow for near real-time data processing and forecasting. My implementation of Data Pipelines allows for automatic refresh of analysis, stored SQL procedures & Python notebooks.

In addition to using SQL, many of our large-scale data transformations are performed using cloud-based fabric notebooks with Spark & Pandas. My forecasting has been completed using models such as SARIMA to predict the seasonality and adjust the trend of revenue etc.

I have developed financial models including project management for a biotech startup, financial analysis for a large private equity firm and revenue projections for company sales.

One product I developed is a custom web app using Power BI Embedded with Microsoft Entra P1 authentication. This allows clients/businesses to authenticate to their power BI reports without a Power BI license through our custom designed web portal that is hosted on an Azure web app.

Financial modelling for startup companies.

I developed several financial models for startup companies, up to revenues of $10 M, that analysed core business metrics such as profitability, revenue growth and customer retention. This was done using Excel and Power BI with data being presented within Power BI reports and in Power BI Embedded reports hosted on Azure Web applications.

Financial modelling for a large Private Equity firm.

I designed a financial model to analyse the performance of investments and funds by fund managers to present to shareholders on $100 M investments. As part of this, I cleaned and streamlined their data storage process to allow for extra fund analysis and future scalability. This enhanced the shareholders understanding of their fund finances & forecast profits.

Project management system for a biotech startup.

I developed an Excel model with VBA Macros to allocate staff full time equivalence and schedule multiple pharmaceutical projects. As part of this process, I implemented high levels of data validation and automation to improve model scalability and useability.

Improving company forecasting & analysis techniques.

Since I joined the company, I have led the new implementation of analysis and forecasting on Microsoft Fabric using Azure Data Factory, Fabric notebooks with Python & Pandas. This has provided SARIMA modelling for our clients to forecast their revenue and profits.

Improving company data storage & processing methods.

We have now moved our clients to a cloud storage and computing solution, using Data Warehouses/Lakehouses. This allows for scheduled and automated refresh for near real time data analysis and updating. Combined with Power apps, we enabled clients to directly add data into the SQL Endpoint from their reports.

As a contracted tutor for TutorChase, I focus on tutoring Mathematics at A-level and Chemistry up to Undergraduate level. I also mentor students on Oxbridge personal statements and interviews.

This was a weekend role as a Chemistry department ambassador. This involved answering questions of potential applicants and giving tours around the Chemistry Research Laboratory.

I undertook water testing and analysis including on-site testing, off-site testing & analysis of water testing data.

As part of a team, I performed PCR COVID testing for the island of Jersey, scaling up sample testing from 300 to 1,500 samples a day. My role was delegating tasks, managing shifts along with directly testing PCR samples and troubleshooting quality control/contamination issues.

I instructed students on what an Oxford interviewer is looking for and how best to prepare for the interview.

I took payments, delivered scooters, managed inventory/rentals and completed data entry.

I tutored students with learning difficulties in English, Maths & Reading.

Classification: Distinction | Mark 78%

My master's thesis focused on utilizing molecular simulations to simulate rod-like particle phase behaviour. These simulations were performed using Large-scale Atomic/Molecular Massively Parallel Simulator (LAMMPS). The particles were modelled as a collection of hard spheres and molecular interactions (depletion interactions) as Lennard-Jones potentials. This generated phase behaviour similar to the experimental and theoretical literature of these systems.

Learn more

Classification: First Class Honours | Mark: 89 | Rank: 2nd

Throughout my undergraduate degree, I particularly enjoyed highly mathematical modules such as Quantum Chemistry, Statistical Mechanics & Thermodynamics. As a chemist many of the systems studied where highly complex chemical & physical systems. To predict and rationalize behaviour for these systems you are required to clearly define model assumptions and then use the key patterns of your data/theory. It was always important to understand the margin of error and level of predictability that your model could provide and in addition where the model breaks down.

Applications in Mathematics: A*, Biology: A*, Chemistry: A*, Design and Technology Resistant Materials: A*, English Language: A*, English Literature: A*, General Science: A*, Geography: A*, Methods in Mathematics: A*, Philosophy: A*, Physics: A* and French: A.

Finalist across the island of Jersey.

Annually awarded to two undergraduates in the Sciences & Mathematics division of Oxford University for excellence in their respective field.

Awarded for the top mark in the chemistry finals undergraduate exams.

Awarded for obtaining a a distinction in first year (preliminary) examinations.

For top performance in 1st year chemistry practicals.

Awarded for the top performance in my school for Chemistry & Mathematics.

Awarded for the top performance in my school in Biology, Chemistry, English & Mathematics.