Dev Patel
Engineering MAY 2022 → JUL 2022

Software Engineering Intern

An e-commerce transaction path across React and Spring Boot, with a 30% query-performance win underneath it.

Classification
Engineering
Client
Sigma InfoSolutions
Window
MAY 2022 → JUL 2022
Duration
2 MO
Location
On-site
The brief

The brief

My first real engineering internship, on an e-commerce product with a React front end and a Spring Boot back end talking to both PostgreSQL and MongoDB through Hibernate.

The measurable result was on the data side: 30% better query performance for the financial analytics views.

Scope of work

Scope of work

  • Improved an e-commerce transaction feature across React and Spring Boot, enhancing the interface and the backend APIs behind it.
  • Elevated PostgreSQL and MongoDB access through Hibernate, optimising data transactions and improving query performance by 30% for financial analytics.
  • Extended AWS infrastructure across S3, EC2 and RDS for new features and monitoring; maintained CI/CD through Jenkins and Kubernetes.
Measured

Measured

30%query performance
2databases via Hibernate
S3 · EC2 · RDSAWS surface
Plan

Plan

Plan

5 items · scale 1:1
REACTstorefront1SPRING BOOTtransaction API2HIBERNATEORM layer3POSTGRESQLtransactional4MONGODBdocuments5
Note · Two stores behind one ORM — the analytics reads were the ones worth tuning.
What I'd redraw

What I'd redraw

Putting one ORM over two very different stores made the code look uniform and the performance anything but. I'd keep the document access explicit rather than pretending both were the same shape.

Materials

Materials

ReactSpring BootPostgreSQLMongoDBHibernateAWSJenkinsKubernetes