C++, C, Python, CSS, HTML5, Database Development, SQlite, Javascript

Harry Bassi

669-***-**** • ******@*****.***

Education

University of California, Davis Davis, CA

Bachelor of Science, Computer Science, Currently 3.61 GPA (unweighted) Expected Jun 2020

Deanza College Cupertino, CA

UC Transfer Student, 3.51 GPA (unweighted) Aug 2016–May 2018

Milpitas High School Milpitas, CA

High School Diploma, 3.7 GPA (unweighted) Aug 2012–Jun 2016

Projects

Created a Multi-threaded, In-memory & Durable Database Management System Jan 2020

Implemented L-store DBMS in python

Created (1) Data Model: to store the schema and instance for each table in columnar form (2D Array). (2) Bufferpool Management: to maintain data in-memory. (3) Query Interface: to offer data manipulation and querying capability such as select and update

Implemented (1) Durability & Bufferpool Extension: to ensure all data is stored on disk and can be recovered from it and a page replacement policy. (2) Data Reorganization: to ensure base pages are “almost” up-to-date by periodically merging base pages with their corresponding tail pages data (running as background task). (3) Indexing: to ensure fast lookup by creating indexes on any column by using mappings with Btrees.

Implemented (1) Transaction Semantics: to create the concept of the multi-statement transaction with the property of either all statements (operations) are successfully executed and transaction commits or none will and the transaction aborts (i.e., atomicity). (2) Concurrency Control: to allow running multiple transactions concurrently while providing serializable isolation semantics by employing two-phase locking (2PL) without the need to wait for locks.

Implementation and testing of File System Oct 2019

Written in C, compiled with GCC and only used standard functions provided in GNU C Library (libc)

Implemented Superblock: the very first block of the disk and contains information about the file system (number of blocks, size of the FAT, etc.)

Implemented File Allocation Table (FAT): keeps track of both the free data blocks and the mapping between files and the data blocks holding their content.

Implemented Root directory: contains an entry for each file of the file system, defining its name, size and the location of the first data block for this file.

Compared performance with reference testers, and implemented own testers

Tinder-like Restaurant Application Mar 2020

Use of YELP API Fusion, to create a fun tinder-like game for groups of people to help choose where to eat

Host page to set up the game with food categories and location as input. Non-host page waits until host submits input information, then when information is submitted all users become a client (non-host) and game starts

Game uses yelp API and AJAX requests to a server to get restaurant information based on the inputted values

Each round is finished once all players pick between two restaurants, and each match is finished when all restaurants have gone through a round. Repeat match with only winner restaurants, until one is chosen.

Languages, Technologies and Tools

Proficient: C++, C, Python, Javascript, CSS, HTML, NodeJS, ReactJS, SQL, Linux, Scala, x86 Assembly, RCode, Matlab

Relevant Coursework

Object Oriented Analysis And Design (Winter 2018)

Web Programming (Spring 2020)

Computer Networks (Spring 2020)

Algorithm Design and Analysis A+B (Winter 2019)

Database Systems (Winter 2020)

Operating Systems (Fall 2019)

Data Abstract And Structures (Object Oriented) Using C++ (Spring 2018)

Computer Architecture A+B (Winter 2019)

Computer Vision (Spring 2019)

Computational Linguistics (Spring 2019)

Probability and Statistical Model for CS (Summer 2019)

Theory Computation (Summer 2019)

Intro x 86 Proc Assembly Languages (Fall 2017)

Contact this candidate