Workforce Planning · Excel Modelling
Audit Capacity Projection ModelDual-scenario workforce model forecasting month-by-month audit throughput for a 24-person regional hub team through 2025, accounting for staggered hiring, role-based training timelines, and vacation-adjusted realistic versus ideal capacity.
Exploratory Analysis · Strategic Planning
Audit List Data AnalysisExploratory analysis of a confidential European audit company list using pivot tables and visualisations, uncovering geographic distribution patterns, company type breakdowns, priority category splits, and special audit requirements to support strategic resource planning.
Power BI Dashboard · Data Visualization & Interaction
Project Map for interactive visualization dashboardDeveloped an interactive Power BI dashboard using Azure Map visuals to geographically track hundreds of ongoing projects across Europe, with dynamic filtering by status, owner, and project type, fed by a daily-refreshed Excel data source.
Power BI Dashboard · Project Timeline Gantt Chart
Project Timeline Tracker (Gantt Chart)Built an interactive Power BI Gantt dashboard consolidating 100+ projects across multiple owners into a centrally tracked, auto-refreshing timeline with colour-coded milestones and dynamic filtering to replace scattered Excel-based manual reporting.
Exploratory Analysis & Reporting
Audit List Data AnalysisExploratory analysis of a confidential European audit company list using pivot tables and visualisations, uncovering geographic distribution patterns, company type breakdowns, priority category splits, and special audit requirements to support strategic resource planning.
SQL Querying · Problem Solving
SQL-Noir Case Files SolutionsDocumented SQL query workflows and solutions across six mystery-themed SQL Noir cases, practicing database querying, table joins, and analytical thinking.
R · Data Science · Visualization
R for Data Science – Learning LogA hands-on learning log documenting my journey through the R for Data Science (2nd edition) workbook, covering data wrangling, transformation, and visualization using tidyverse, dplyr, and ggplot2 (snippet of graphs included above).
SQL · Problem Solving
SQL Interview Practice - DataLemurPractising and documenting solutions to real-world SQL interview questions from DataLemur, spanning pharmaceutical sales analysis, candidate filtering, assembly line tracking, and messaging analytics using PostgreSQL.
Bioinformatics · RNA-sequencing
RNA-Seq Data Analysis WorkshopCompleted a five-day SciLifeLab/NBIS workshop at Uppsala University covering the full RNA-seq analysis pipeline, from raw data quality control and read mapping through to differential gene expression and gene set enrichment analysis using R and Linux.
Data Science · R · SQL
Clinical Data Science ProjectsCoursework repository from the University of Colorado's Clinical Data Science program, featuring projects spanning EHR-based hypertension phenotyping, ICU mortality risk prediction modelling, and NLP keyword extraction from clinical notes.
Excel · Word · Mass Email Sending
Mail Merge using Excel & WordDocumented a stakeholder email workflow using Excel functions (SUMPRODUCT, XLOOKUP, TEXTBEFORE/AFTER) to validate, extract, and structure contact data from merged strings for use in a customised Word mail merge campaign.
Excel · Healthcare data · Database harmonization
ICD Health Code Dataset HarmonizationCross-referenced and harmonized a dataset of ~200 Swedish ICD-8/9/10 disease codes against international WHO classifications for X-chromosome related autoimmune diseases at Linköping University's Nestor Lab, identifying and documenting key coding discrepancies across classification systems using Excel.
Bioinformatics · Shell · Genomics · R
Bioinformatic Pipeline DevelopmentsDeveloped and implemented modular genomics and transcriptomics pipelines at Linköping University's Nestor Lab, spanning LP-WGS alignment, RAP-seq RNA processing, and R-based Copy Number Variation analysis using Bash, Python, and R. Example above for expression profile from DNA CNV analysis.
Data Modelling · R
Toxicology Modelling and Study (BSc project)Investigated the acute and chronic toxicological effects of alcohol-based and non-alcohol-based hand sanitisers on the freshwater indicator species Daphnia pulex using probit regression, Kaplan-Meier survival analysis, and heart rate endpoints in R, identifying alcohol evaporation as a key methodological confound.