sohasultana

Portfolio

Hello, I am Soha Sultana, a senior at the University of Washington studying Informatics with a focus in data science. I am passionate about using data to tell a story and have developed projects where I have created machine learning models to help answer a research question, and am exploring more using Agentic AI.

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

Linkedin: https://www.linkedin.com/in/sohasultanauw/details/languages/

Resumé: https://drive.google.com/file/d/1QK4db8-pY2gmGJsDR84ZtfhktPupJGvd/view?usp=sharing

Skills

Java, Python, SQL, JavaScript, HTML/CSS, R, JSON Problem-Solving, Time-Management, Collaboration, Excel, Word, Documentation, Stakeholder Engagement, Data Analysis, Communication, Project Management, Documentation

About Me

image

I develop 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.

Projects

Aria MVP

Timeframe: November 2025 - Present
Role: Back-end Developr
Tools: Python, AWS Bedrock Link: https://github.com/sohasultana/Aria

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