* Designed and developed a web application that easily rebalances AWS EC2 reservations across instance sizes and availability zones to maximize discount coverage of hundreds of thousands of instances. Developed node/express backend to interface with AWS EC2 Reservation API and to generate efficient inventory conversion plans that minimize inventory splits/ fragmentation.

* Designed and developed an ETL pipeline to surface and analyze AWS' detailed billing report data, which is used for capacity planning and cost attributions.

* Developed a custom web application using react.js and d3 to explore cloud AWS usage, cost and reservations.

* Designed and implemented ETL logic to calculate EC2 reservation shortages and identify top service growth. Developed email alerts to surface these shortages, as well as a UI to allow users manage alert configurations.

* Developed an ETL pipeline logic to simulate savings & recommend S3 Storage class lifecycle policies. Developed a tableau dashboard and weekly email reports to track S3 usage patterns for major S3 buckets & prefixes.

* Redesigned canary report visualizations on Spinnaker UI (Kayenta deck).

* Developed ETL pipeline, custom dashboard and email reports to engineering managers to track data cost trend in AWS (e.g. Hive tables, Cassandra, Kafka topics). Built an interactive graph to explore data lineage across data platforms.

* Developed ETL pipeline, custom dashboard and email reports to engineering teams to track their microservice availability scores.

* Made minor contributions to Semiotic, an open source D3-based data visualization library.

* Conducted various cost analyses related to Cloud/ AWS, which includes EC2 instance migrations, pricing & contract changes, micro-service architectural changes, VPC migrations, and new AWS products

* Periodically planned and executed EC2 capacity procurements, as well as reservation modifications to maximize capacity utilizations

* Planned capacity conversions and coordinated with AWS to ensure various service teams could smoothly migrate from classic network to VPC

* Conducted cost analysis and provided guidance for service teams to optimally leverage S3 SIA and Glacier storage classes

* Designed tableau visualizations to unveil cost, usage and reservations of AWS products

* Managed monthly cloud expense forecast and quarterly guidance

* Analyzed Supply Chain operations and gathered tool requirements from stakeholders in the Sales, Operations, Finance and Marketing-Ops departments.

* Designed new business processes, data model & system solutions and created functional specifications for IT solution implementations.

* Tested tools/solutions and conducted business user training.

* Supported existing SAP APO applications and assisted business stakeholders in operations-related data analysis and reconciliation.

* Managed SAP and custom web projects, which typically involved 2-5 project members.

* Designed and developed reports and visualizations for various levels of stakeholders.