Soham Dodia

I am good with designing REST APIs, database design, writing complex queries and query optimization.

I have attended InOut 1.0, 2.0, 3.0 and we won 1st prize in InOut 3.0 in the hardware category for Leapdrop. I have learned so much from these hackathons and want to continue this habit.

I have worked on many projects but the most challenging project was Starbuds which has the same functionality as Instagram.
You can like other people posts, comment on their post, upload multiple photos and videos, user gets notifications for likes, comments and when someone tagged them in a post.
In this project, I learned how to organize the code, how to write complex queries and how to generalize the database.
There were many problems while I was desiging REST APIs but the main problem which I faced was the database designing and queries for user activities.
I don't want to store particular message in db like 'XYZ(username) has liked your photo' because if after some time I want to change message format as 'Your photo has been liked by XYZ' or if user change his username then message is of no use.
So I have learned how to design db and how to write query to make these messages dynamic.

I am passionate about coding and like to solve real world problems using code.
In my free time I work on my small side projects as well.