Aiham Hammami

Supercooldata is an interactive educational web app teaching data analytics using SQL. I co-founded Supercooldata as a bootstrapped startup and successfully generated profit without any external funding. I also wrote the full codebase on my own and built a user experience unique in the analytics education space, inspired by the Duolingo app.

Built an in-browser peer-to-peer blockchain using WebRTC and WebSockets to communicate between peers and the central coordinating server. Implemented a blockchain from scratch inspired by the Bitcoin blockchain design as a study exercise. The web app generated public/private key pair for wallets to hold coins using WebCrypto. It also used WebCrypto to generate hashes for the mining of new blocks then used WebRTC and Socket.IO to communicate with peers to reach a consensus for every newly mined block. This was an interesting exercise but I did not pursue it further.

Developed an arbitrage trading bot connected to multiple cryptocurrency exchanges. It's constantly monitoring the price of various trading pairs, waiting for sufficient price discrepancy before executing simultaneous trades for guaranteed profit.

A proxy server written in Python that implements the PostgreSQL back end wire protocol and reverse-engineered the Snowflake HTTP protocol to intercept all incoming SQL queries to a data warehouse (Snowflake, RedShift, and PostgreSQL). It would parse the SQL query to generate an AST, manipulate the query to reroute to other tables or optimize where appropriate, then transparently proxy to the intended server. There were many use cases for this software, such as security, cost optimization, and performance optimization.