PROJECTS_DB Selected work

Projects.

A growing collection of data, technology and development projects—from classroom concepts to real business decisions.

01

Projects completed during my Data Management degree.

01

Data Modelling & Design

Auction Database · Pokémon Trading Cards

+

Designed a relational auction database modelling users, auctions, cards, rarity, grading, sets and expansions. The work combined business-domain analysis with iterative technical design.

SQLER modellingDDDMySQL
02

Agile Ways of Working

Extreme Adventure Travel Platform

+

Worked as Scrum Master in a team building a data-driven travel platform. Coordinated Kanban workflows, user stories, priorities and dependencies across different skill levels.

ScrumKanbanUser storiesTeam coordination
03

Data Architecture

E-commerce Architecture

+

Designed bounded contexts, aggregates, domain events and system flows for products, customers, carts, orders and inventory, including an Anti-Corruption Layer and scalability considerations.

DDDUMLModular architectureCaching
04

Data Science

Swedish Housing Market Analysis

+

Analysed nearly 100 years of housing data to uncover long-term price trends and regional differences, connecting data patterns to urbanisation and population change.

PythonPandasData visualizationTrend analysis
05

Graph Databases

Swedish Government Graph

+

Modelled ministers, political parties and government departments as a connected graph and used queries to explore, validate and troubleshoot relationships.

Neo4jCypherGraph modellingData validation
06

Statistics & Data Analysis

Statistical Analysis Project

+

Applied descriptive and inferential statistics to explore patterns, relationships and hypotheses, with a focus on contextual interpretation and clear communication.

StatisticsHypothesis testingCorrelationVisualization
07

Data Quality

Banking ETL Pipeline

+

Cleaned and standardised account data including addresses, identifiers, account numbers and phone numbers, then built automated validation and orchestration.

PythonPandasRegexGreat ExpectationsSQLAlchemyPrefect
08

Metadata & Web Analytics

Metadata Search Engine

+

Built image-metadata extraction into JSON, MySQL storage and searchable REST routes, including nested metadata and map-connected geolocation data.

MetadataJSONMySQLREST APIGeolocation
09

Data Security

Secure Forum Backend

+

Developed authentication, authorisation and role-based access for a forum backend with defence-in-depth security controls.

JavaScriptMySQLRBACCSRFCORSHelmetRate limiting
10

Data Governance

E-commerce Governance Framework

+

Profiled customer, product and order data, then defined domains, ownership, classifications, glossary terms, policies and quality standards.

Data governanceGDPRData qualityBusiness glossary
11

Thesis Project

ETL & Data Integration

+

Designed a maintainable ETL pipeline integrating source systems with different structures and quality levels, using AI-assisted development alongside systematic validation.

PythonPandasETLData mappingValidation
02

Business-facing analytics developed during my internship at Caterbee.

01

Sales & Customer Analytics

Project Matilda

+

Created delivery-pricing decision support covering AOV, volume, category distribution, profitability and margins—giving Sales more independence from Tech.

SQLPower BIGoogle SheetsKPI design
02

Seasonal Sales Analysis

Semla Campaign

+

Delivered increasingly frequent customer and sales updates ahead of a major seasonal period, helping Sales prioritise outreach and Operations plan demand.

SQLSales analyticsOperational planning
03

Customer Analytics

Customer Performance Analysis

+

Translated stakeholder questions into ad-hoc analyses of purchasing behaviour, order values and performance against business goals.

SQLExploratory analysisStakeholder communication
04

Rapid Business Analysis

Vanilla Hearts

+

Answered an urgent CEO request by extracting historical product sales for a customer to support upcoming sales-period planning.

SQLAd-hoc analysisDecision support
05

Sales Analysis

VegRatio

+

Compared vegetarian purchasing between 2024 and 2025 while adapting SQL logic to changing product classifications.

SQLYear-over-year analysisData quality
06

Sustainability Analytics

Carbon Emissions Estimation

+

Estimated customer emissions by combining order history, delivery methods, distances and food data while resolving incomplete and inconsistent records.

Data modellingAssumptionsData qualitySustainability
03

Independent projects driven by curiosity and experimentation.

01

Web Development

Interactive Resume Website

+

Designed, built and continuously improved this interactive resume through iterative prompting, requirements refinement, code validation and technical review.

HTMLCSSJavaScriptCodexAI-assisted development