Krunal Patel

Experience

• 

  Fiserv

  Jun 2010 - Jun 2013

  Software Engineer | Business Intelligence and Datawarehousing
• 

  BD

  Jul 2015 - Dec 2016

  ASM | Management Trainee Program
• 

  Mu Sigma Inc.

  Jan 2017 - Feb 2018

  Apprentice Leader | Retail Analytics
• 

  Infosys

  Mar 2018 - Oct 2019

  Lead Analyst | Supply Chain Analytics
• 

  Titan Company Limited

  Oct 2019 - Oct 2021

  Analytics Lead | Retail Analytics
• 

  Amazon Web Services (AWS)

  Nov 2021 - now

  Data Engineer | Supply Chain Analytics

  • Developed replenishment-planner tool - using AWS Lambda for processing, Step-Function for orchestration and Event-Bridge for scheduling - catering to a new complex supply chain process for the US region which allocates requirement across data-centers from inventory present at multiple hub types and provides-output to multiple systems automatically for order generation.• Automated and integrated refurbished-spares planning process in regular replenishment cycle along with providing visibility for fulfillment via dashboard. Includes complex processes like:- Disaggregating demand based on part-hierarchy and vendors- Translating it to orderable parts based on available inventory - Preparing multiple order files based on sourcing hubs• Developed a full-stack web-application using AWS using Lambda, API Gateway, S3 and React to enable, extraction and display of information from hundreds of ETL jobs at the click of a button• Automated complex MRP process to provide the expected units that the vendors need to keep to satisfy spares demand for next 6 months• Developing and maintaining Python scripts and ETL pipelines to automate spare supply-chain processes like planning, ordering and product-life-cycle management for 1000s of parts for data-centres across the globe• Initiated, developed and evangelized self-serve Python utility to check file-format before its ingestion in automated processes which is used across teams and converted it to Lambda which is triggered at S3 events• Implementing secure cloud-infra for small web-apps and developed and maintained CI/CD pipelines.• Trained team to use Airflow for orchestrationTech: Python, Redshift, SQL, React, AWS services (Lambda, Step-function, Api-gateway, S3, SNS, Event-Bridge, Step-Function), Tableau, ETL tools, Airflow Show less