The product
A data analytics platform built for a client. People upload, query and visualise data that includes personal information, on interactive dashboards. It has no public site and the client is not named, so this page describes it at the level of its features.
What I built
PII masking and audit logging. The service that detects personal data and masks it, with an audit log of every data operation it performs.
The test data seeder. A seeder that fills Snowflake with realistic test data, with a performance report.
The load-test bot. A Selenium bot that signs in, navigates to the query dashboard, validates each page and captures screenshots along the way.
How it works
The front end is React with TypeScript. It calls a FastAPI backend that handles the API, uploads, data validation and authentication over PostgreSQL and MongoDB, and the platform includes a guest-user system. The masking service is a separate Flask service. Each service runs in its own container, with separate setups for development and production, and the test tooling works against Snowflake and the running app.