Back to Selected work

06

Sysco E-commerce Core Enterprise Services

where
Sysco LABS
when
2022 to 2023
live
shop.sysco.com
  • Java 17
  • Spring Boot
  • Confluent Kafka
  • AWS Kinesis
  • ECS Fargate
  • Aurora PostgreSQL
  • REST API
  • OpenAPI

The problem

The e commerce platform needed customer, product and account data that still lived in a legacy AS400 system, close to real time. The streaming layer was tied to Amazon Kinesis, which locked the pipelines to one cloud provider. Access needed to be controlled via Apigee based API gateway, so that different service consumers will have their access tied to the API key.

What I did

Engineering manager and technical lead over four developers and two QA. REST microservices serving customer, product and account data to Sysco’s e-commerce platform, fed by AWS Batch ETL jobs and real time migration off a legacy AS400 database to an scalable Postgres DB on AWS cloud. Moved the streaming layer from Kinesis to Confluent Kafka so the pipelines were no longer tied to one cloud provider.

What changed

Active data served from PostgreSQL, and a streaming layer that is no longer bound to a single cloud. Scalability & reliability was achieved from AS400 to microservices.