Tony Qiu

Context

Individual course project for IV1351 Data Storage Paradigms at KTH. Spanned three progressive tasks from schema design through performance tuning to a full Java application layer.

Objective

Design and implement a relational system to model a university's course instances, planned teaching activities, teacher allocations, and salary structures — with versioning to track changes over time.

What I Built

• Designed a third normal form (3NF) relational model in PostgreSQL with versioned salary and course-layout tables, enabling the system to track historical changes to course hours and teacher pay.
• Automated derived activity-hour computation and enforced strict allocation constraints at the database level.
• Authored OLAP workload queries for reporting: planned hours per course, allocated hours per teacher, teachers with excessive loads, and variance detection (planned vs. allocated > 15%).
• Engineered query performance using EXPLAIN ANALYZE, strategic indexing, and materialized views.
• Implemented an ACID-compliant CLI in Java (strict MVC architecture) with pessimistic row-locking to prevent phantom reads and enforce business rules under concurrent usage.

Technologies

Ownership

Sole author — all 117 commits across three repositories. The main repository is explicitly labelled "Only Dajue Qiu has worked on this task."

Evidence

Context

Built as the capstone deliverable for the Web App Development Certification at Stockholm School of Economics (awarded November 2024).

Objective

Design and implement a responsive, visually polished landing page for a professional web presence — demonstrating front-end development skills including layout, animation, and interactivity.

What I Built

• Designed the full visual identity, layout, and interaction model.
• Implemented the complete front-end using semantic HTML, custom CSS (responsive design, transitions, layout grid), and vanilla JavaScript for interactivity.
• Created a production-ready single-page site with clean code structure.

Technologies

Ownership

Sole author — designed and coded entirely by me.

Evidence

Context

Group course project for BE603 Data Analytics at Stockholm School of Economics. Worked as part of Group 9.

Objective

Analyze crowdfunding campaign and contributor datasets to identify the key factors that distinguish successful campaigns from unsuccessful ones, and present findings with clear visualizations.

Team Objective vs. My Contribution

The team collaborated on framing the research question, interpreting results, and presenting findings. I was responsible for the entirety of the Python coding — data cleaning, analysis, statistical modelling, and visualization generation.

What I Coded

• Loaded and cleaned campaign and contributor datasets (XLSX sources).
• Performed exploratory data analysis and feature engineering.
• Built statistical models and generated the final plot outputs used in the team's presentation.
• Produced the Jupyter Notebook and standalone Python script that formed the technical deliverable.

Technologies

Ownership

Collaborative project — Group 9 at SSE. I wrote all the Python code; teammates contributed to research framing and presentation.

Evidence

Context

Internship at Pango, a startup incubated at SSE Business Lab, Dec 2024 – Apr 2025. Pango works on improving return management for e-commerce companies.

Objective

Automate the recognition and processing of customer returns to improve efficiency in e-commerce logistics workflows.

What I Did

• Fine-tuned computer vision models to recognise and classify returned items from images.
• Implemented software pipelines that integrated machine learning outputs with the company's existing IT infrastructure.
• Contributed to technical and product discussions in a fast-paced startup environment.

Technologies

Ownership

My internship work. Contributed directly to the company's core product pipeline.

Evidence

Code is proprietary to Pango. Described at a high level to avoid exposing confidential details. Employer reference available upon request.

Context

Group project for a strategy course at SSE, conducted as a consultancy-style engagement with Azets (the parent company of COZONE).

Objective

Analyse COZONE's competitive position and develop a strategic recommendation for how the platform could evolve from a compliance tool into a multi-sided marketplace connecting investors and scale-ups.

What the Team Built

• Applied Porter's Five Forces and VRIO analysis to evaluate COZONE's competitive position and internal resources.
• Benchmarked KPIs across comparable platforms to identify differentiation opportunities.
• Recommended a differentiation pivot: turning COZONE into an investor–scale-up marketplace with co-created reporting templates, reputation building, and long-run network effects.

Technologies & Frameworks

Ownership

Collaborative — group project at SSE.

Evidence

Analysis involved client-facing material from Azets. Described at a high level to avoid exposing confidential details.