06
Sysco E-commerce Core Enterprise Services
- where
- Sysco LABS
- when
- 2022 to 2023
- live
- shop.sysco.com
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.