sohasultana

Portfolio

Hello, I am Soha Sultana, a third-year student at the University of Washington studying Informatics. I have projects in both front-end and back-end development which I have gained experience through class projects. I also am interested in Agentic AI and have explored this using Azure OpenAI. You can read more about my experience here:

Please feel free to contact me at sohas@uw.edu

Linkedin: www.linkedin.com/in/sohasultanauw

Resumé: https://uwnetid-my.sharepoint.com/:w:/g/personal/sohas_uw_edu/EUWP_Eu9-4VLmrNARTP23dsB6z-igX0cFliJ6uwIbSqt3g?e=6ApXYN

About Me

image

I develop software projects that are dedicated to giving back to my community. I have developed projects using Java, HTML, CSS, React, JavaScript, and SQL. My future career goals include becoming a full-stack developer, where I would like to strengthen my programming skills to build innovative and effective solutions that serve my community.

My Methodology for designing such projects starts with identifying an issue that my community is facing, and finding out how I can use technology to solve that issue. I start with understanding the criteria and contraints I am given and use the Software Developmental Model to test out my projects and to continually improve them.

Let’s Find Dinner

Timeframe: September 2023 - December 2023
Role: Full Stack Developer
Tools: HTML, CSS, React, JavaScript, GitHub
Link: Let’s Find Dinner

About the Project

This project connected users to local food banks in the Seattle area. The app consists of four main sections:

Deliverables

I was responsible for creating the volunteer form for the users. This included:

Step by Step Outline

  1. Coming up with a Project Topic Proposal

  2. Creating a Static Mock-Up (HTML and CSS outline)

    Initial Landing Page: image

    Static Form without Validation Protocols: image

  3. Adding Validation Protocols with JavaScript image

  4. Creating Interactive Features using React

    Updated Landing Page with hover interaction: image

  5. Creating an Ajax Firebase for Data Analytics image

  6. Deploying the App to GitHub

Instacart Database

Timeframe: January 2024 - March 2024
Role: Database Design
Tools: SQL, Azure Data Studio

About the Project

This project consisted of creating a database using SQL for the information system Instacart, which is a website that compares different grocery store prices. The database stores information such as customers, orders, stores, and delivery data. In addition, we also used stored procedures to streamline the process of adding and retrieving data.

Deliverables

I created the Order table which tracks the order details:

image

When creating the data table, I focused on normalization techniques, such as identifying the primary and foreign keys. After this, I worked with my teammates to get the ERD into third normal form, to ensure there were no redundant values. Additionally, I managed the data by creating a stored procedure called GetCustomerID, which is used to add a new customer into the database using the same code to increase efficiency.

image image image

I also created another stored procedure, newStoreID, that adds a new grocery store into the database:

image

Step by Step Outline

  1. Started with finding out an Information System
  2. Drafted out an ERD with the tables
  3. Identified the primary and foreign keys of each table and normalized them to 3rd normal form

image

  1. Created the database on Azure Cloud Studio

image

  1. Added Stored Procedures and Business Rules to streamline Data image

  2. Presented Final Deliverable https://docs.google.com/presentation/d/13upIJfQKCd0TFLrQI0vJaUULjzw1AbgwI5Eeh7BTBJA/edit?usp=sharing