Improved the data ETL delivery time from 48 hours to 1 hour by designing a real-time streaming pipeline automated with Airflow.

Designed the pipeline to be flexible for schema evolutions and potential expansion to other sales channels by encoding Kafka messages in Avro format.

Reduced roughly $200K USD, which is 35% of the project raw material cost by analyzing corporate purchasing data and approaching suppliers with cost reduction strategies.

Derived insight to drive business purchasing decisions of millions of USD by consolidating multiple data sources using Excel to generate purchasing reports for VP of Operations.

Completed 2~3 cost reduction/estimation projects weekly by efficiently communicating with