نسيم بو غنام

Real-Time Incremental Distributed In-Memory Database

- Designing the Computation Engine of a Real-Time Incremental Distributed In-Memory Database, that handles the execution of SQL queries with hundreds of millions or even billions of rows, in a partitioned and multithreaded manner


Real-Time Business Intelligence solution based on In-Memory Database

- Collaborated with the Front-End team to design a generator for analytics queries from BI tiles
- Designed and implemented a compiler that reads company analytics queries and generates SQL requests
- Implemented an ETL tool that extracts data and metadata from an excel file, created the representing schema and imports the data to a database
- Implemented prediction algorithms to build foreign key relationships between the tables extracted from the excel file
- Enhanced the analytics compiler's optimizer to generate better SQL requests cutting the user's waiting time by 50%
- Coached an intern to design and implement a Semantic Analyzer for the analytics compiler which applies semantic checks to the analytics query
- Played the role of a cyclic Scrum Master where I led retrospectives and sprint planning meetings and removed any impediments to the team's progress
- Built a web tool to visualize the BI relational schema, that holds the tables and relationships between them, which helped the analysts construct their BI tiles and calculations