InsightUBC

Designed a RESTful query engine over UBC dataset dumps (grades and campus rooms) using Node.js, Express, and TypeScript, handling 100,000+ dataset entries while optimizing query execution to achieve response times under 50 ms, improving efficiency by 40% over the initial baseline.

Built a scalable query engine using recursive descent parsing and Abstract Syntax Trees, processing 500+ JSON queries per second while enforcing 100% compliance with a formal EBNF grammar and reducing query failures at the API boundary.

Engineered an advanced dataset processor that parsed 60,000+ entries from ZIP, JSON, and HTML files, leveraging parse5 for HTML traversal and fs-extra for file persistence, cutting end-to-end data processing time by 40%.

Achieved 95% test coverage using Mocha and Chai across 100+ unit and integration tests, improving API reliability to 98% and preventing critical regressions during parser and query-planner refactors.