- Developed a conceptual schema using an Entity-Relationship (ER) data model to streamline the inventory and checkout process for a member-only supermarket.
- Ensured high performance and data integrity, leveraging SQL for efficient querying and relational database management.
- Collaborated with stakeholders to define key system requirements, resulting in a more user-friendly and scalable system.
- Developed a sophisticated search engine using Java Database Connectivity (JDBC), facilitating efficient access to academic publications, including ACL papers from 2016-2017.
- Designed a command-line interface, enabling users to easily search and retrieve structured data from a large repository.
- Collaborated with stakeholders to optimize search parameters and database indexing for enhanced performance and user experience.
- Analyzed a comprehensive dataset of high school students, focusing on demographic details, study habits, parental involvement, extracurricular activities, and academic performance.
- Explored key features to identify patterns affecting student GPA and grade classification.
- Applied statistical analysis and machine learning techniques to derive insights, highlighting how study habits, parental support, and extracurricular activities influence academic success.
- Leveraged the dataset to create robust models for educational research and performance prediction, providing valuable insights for optimizing student outcomes.
- Utilized advanced computational techniques to manipulate and analyze digital images, focusing on applications like medical imaging, surveillance, and autonomous vehicles.
- Enhanced image quality through edge detection, segmentation, and pattern recognition, improving decision-making capabilities and feature extraction for critical applications.
- Applied a range of methods, from basic resizing and color adjustment to more complex procedures in image analysis and interpretation.
- Engineered a dynamic array system to manage the game's Tetris blocks and introduce randomization in block shapes and sizes, increasing gameplay complexity.
- Improved upon traditional Tetris by implementing real-time dynamic memory management for unpredictable tetromino patterns.
- Leveraged core concepts in computer science to enhance the gameplay experience with added variety and difficulty.
- Designed an efficient buffer management system to facilitate process management in Unix-like environments.
- The system handles multiple text buffers, allowing users to modify and execute various commands such as opening, saving, and editing files with optimal performance.
- Ensured system stability and user efficiency by providing seamless management of memory operations across multiple buffers.
- Assisted in teaching Database Concepts, providing one-on-one and group support to students on topics such as SQL, entity-relationship modeling, normalization, and database design principles.
- Guiding students through practical database exercises, including setting up and querying databases.
- Collaborated with professors to create and review course materials, assignments, and projects, ensuring that learning objectives were clearly conveyed.
Programming Language and Database: C, Java, Python, SQL, MongoDB
Analytical Tools: Pandas, Numpy, Matplotlib, Tableau, Jupyter
Other: Data Visualization, Data Analysis