Software Engineering & Data (Databases and Data Analysis)

Todo: The Better Student Planner

Take a look at the repository at this link:

https://github.com/adrianakamor/Todo-Copy-CSDS-393

In CSDS 393, Software Engineering, we had the opportunity to work in teams to complete a hosted web application using a database. Our team worked to create a student-centered planner application: Todo. Unlike traditional planners, our planner combined the best aspects of a to-do list and a planner into one application. We had found that traditional planners lack the ability to prioritize tasks, so we made that a priority in our development. With Todo, you have the option to sort your tasks by time created or by the due date. This way, you have a clear view of what needs to get done. To complete the project, all teams followed their own modified Scrum approach with accompanying documentation and used GitHub to collaborate on our code and deploy our project. Using the Agile methodologies covered during class time, our team decided on a modified approach that worked around our other academic and extracurricular commitments. Along with our methodology, we also kept extensive documentation throughout the iterative development process. Currently, the project is not being hosted but all necessary files for local hosting can be found in the repository link.

My specific contributions to the project were configuring our Scrum board and updating it as necessary, creating the registration page, writing the README file, structuring the functionality for adding and removing tasks, performing some UI updates, structuring documentation, and being in charge of the product's documentation

Addepar Optimization at Morgan Stanley

You can see more about my internship experience at Morgan Stanley here, but a large portion of my internship role involved optimizing the naming system and organization of company accounts in the Addepar database system. For this project, I created a design document, style guidelines, Excel spreadsheets, and laid out the steps and recommendations for further streamlining other aspects in the future.

Swimming College Database

Take a look at the repository here: https://github.com/adrianakamor/CollegeSwimmingDBCode

In Introduction to Database Systems, our final project involved working with a team to build a database with user interaction/input using SQL and JDBC. My team chose to build a relational database around college swim teams that has various components such as teams, conferences, records, coaches, and swimmers. Using JDBC, our database is accessible to users in the "terminal" or "command line" where the user can find ranks/meets, add swimmers/best times, and more.

My specific contributions include writing Java input code and SQL stored procedures to retire a swimmer, writing Java input code and SQL stored procedures to update a swimmer's best time, writing the SQL trigger to automatically update records, Section 1 in the written report, Section 2 in the written report, collaborating on Section 3 in the written report, and collaborating on Section 6 in the written report.